We recently corrected a database that was upgraded to 7.5.1 and after the upgrade the Activities were no longer visible in the web client Activities Window. The Activity window in the LAN client continued to display Activities. What we found out is the fields in the Activity table that did not allow null values had null values. It is believed that most of these fields are related to the Activity Filters but the combination of which ones are necessary and which are not is unknown. We ran the following scripts in the Admin to update the Activity table.
update activity set originaldate = Getdate() where originaldate is null–
update activity set createdate = Getdate() where createdate is null–
update activity set modifydate = Getdate() where modifydate is null–
update activity set Startdate = Getdate() where Startdate is null–
update activity set alarmtime = createdate where alarmtime is null–
update activity set recuriterations = 0 where recuriterations is null–
update activity set recurperiod = 0 where recurperiod is null–
update activity set recurperiodspec =0 where recurperiodspec is null–
update activity set duration =0 where duration is null–
update activity set recurring = ‘F’ where recurring is null–**
update activity set rollover = ‘F’ where rollover is null
update activity set timeless = ‘F’ where timeless is null–
update activity set alarm = ‘F’ where alarm is null–
update activity set attachment = ‘F’ where attachment is null
update activity set longnotes = ” where longnotes is null–
We don’t see this type of issue very often during a SalesLogix upgrade, but here is a possible fix if you need it.
We are dealing with a SalesLogix database that was updated to 7.51 and we are seeing this issue as well.
The SQL script you provided definately worked to resolve the issue but as soon as a new activity is created then the activities no longer display in the web client.
Would you mind sharing what you had to do in order to permanently resolve the issue.