Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Skilled Commentator
Posts: 11
Registered: ‎08-06-2009

Saleslogix 8.1 Upgrade ActivityAttendee table missing rows

[ Edited ]

 

I just upgraded a customer to 8.1.  In some cases, activities are showing up in the Activity main view but not showing up in the Lead Activivty tab or the Contact Activity tab.  The problem seems to be missing rows in the new ActivityAttendee table.  Maybe a problem with the upgrade conversion program.  I just discovered this today so this has not been reported to support yet.

 

In the Activity main view, All Open group, there is the new column Participant Count.  The problem activities have a count of blank or zero.  When you go to the associated contact or lead and look at the activity tab, there is no activity listed.  My assumption is those tabs inner join in the new ActivityAttendee table, which has no rows in these problem cases, and therefore the activity does not display. Not all of the activities have this problem, but a few hundred do.

 

The select statements below generate insert statements that populate the ActivityAttendee table which allow the activities to show up again.  (This is a quick and dirty fix.  Not all columns are populated properly, but it does prove that populating the rows solves the problem).

 

-- Populate missing rows for leads

select
'insert into activityattendee (ACTIVITYATTENDEEID,ACTIVITYID,CREATEUSER,CREATEDATE,MODIFYUSER,MODIFYDATE,ENTITYID,NAME,ISPRIMARY,ROLENAME,ACCOUNTNAME,ENTITYTYPE,ISATTENDEE) values (''' + activity.activityid + ''',''' + activity.activityid + ''',''ADMIN'',''05/04/2014'',''ADMIN'',''05/04/2014'',''' + activity.leadid + ''',''' + lead.firstname + ' ' + lead.lastname + ''',''' + 'T' + ''',''' + '' + ''',''' + activity.accountname + ''',''Lead'',''F''' + ');'
from activity
left outer join activityattendee on activityattendee.activityid = activity.activityid
join lead on lead.leadid = activity.leadid
where
activity.leadid is not null and
activityattendee.activityid is null

 

-- Populate missing rows for contacts

select
'insert into activityattendee (ACTIVITYATTENDEEID,ACTIVITYID,CREATEUSER,CREATEDATE,MODIFYUSER,MODIFYDATE,ENTITYID,NAME,ISPRIMARY,ROLENAME,ACCOUNTNAME,ENTITYTYPE,ISATTENDEE,ACCOUNTID) values (''' + activity.activityid + ''',''' + activity.activityid + ''',''ADMIN'',''05/04/2014'',''ADMIN'',''05/04/2014'',''' + activity.contactid + ''',''' + activity.contactname + ''',''' + 'T' + ''',''' + '' + ''',''' + activity.accountname + ''',''Lead'',''F''' + ',''' + activity.accountid + ''');'
from activity
left outer join activityattendee on activityattendee.activityid = activity.activityid
join contact on contact.contactid = activity.contactid
where
activity.contactid is not null and
activity.accountid is not null and
activityattendee.activityid is null

 

 

David Nelson
Accel Solutions Group
Seattle, WA USA
Employee
Posts: 45
Registered: ‎04-02-2009

Re: Saleslogix 8.1 Upgrade ActivityAttendee table missing rows

We found the problem with Leads and have an updated SLXConversionUtility that we are testing right now to resolve the issue.  This is defect 14095746.  This should be ready in a couple of days at which time you can contact SLX Support for an updated version of the SLXConversionUtility until it gets released in the next Update.

 

We have not seen an issue with Contacts, so I'm interested in more details if you had trouble with activities associated with Contacts.

 

Thanks,

Deanne

SLX QA

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Saleslogix 8.1 Upgrade ActivityAttendee table missing rows

How about posting the conversion utility to the partner/customer portal(s) so that we don't have to wait for an update.. or call support.

 

It will save a lot of us a lot of time.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Skilled Commentator
Posts: 11
Registered: ‎08-06-2009

Re: Saleslogix 8.1 Upgrade ActivityAttendee table missing rows

Yes, attendee rows were missing for contact activities also and activities for contacts where the attendee rows were missing were not visible on the contact activity tab.  Inserting attendee rows also fixed that problem.

David Nelson
Accel Solutions Group
Seattle, WA USA