05-04-2014 07:30 PM - edited 05-04-2014 07:31 PM
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
05-05-2014 01:38 PM
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
05-05-2014 06:13 PM
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.
05-07-2014 05:24 PM
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.