Why Can’t I See All Open Activities in the All Open Activities View in the SalesLogix Web Portal?

Question: Why can’t I see all open activities in the all open activities view in the SalesLogix Web Portal?  I am receiving the error message: ‘totalrecords’ is not a object or it has null value.

Answer: This is an issue many in the SalesLogix community experienced.  You may have success correcting this issue with this statement:

UPDATE sysdba.ACTIVITY
SET TIMELESS = ‘F’
WHERE (timeless IS NULL)

UPDATE sysdba.ACTIVITY
SET recurring = ‘F’
WHERE (recurring IS NULL)

UPDATE sysdba.ACTIVITY
SET rollover = ‘F’
WHERE (rollover IS NULL)