We have SalesLogix 7.5.3, and we have a couple problems related to Activities. On the Activities page all the tabs say, “Displaying 1 – NaN of undefined” rather than displaying data. We also do not get any results for the Welcome screen widget “Today’s Activities”. Instead of displaying data, we only get the title bar for the widget displayed. Both these problems suddenly appeared in our development environment when we rebuilt the portal. Can you think of anything that would cause them to suddenly stop working?

The code for “Today’s Activities” exactly matches the out-of-the-box code we got from SalesLogix Support. I suspect these problems have to do with the connection. The Activities page displays data for "All Open" in the LAN client, but not in the web client.

The problem is with groupBuilder. Tabs are records in table plugin. If you check there is stored some blob. If you check it you will find, that there are some selects from database. Seems like those selects crashes. Probably you did something with activity table or something like this. Probably you could check it with slx profiler to see which request are sended to database and repeat them in toad and see what's the problem. For example if you have removed some column from table activity it could have been causing that behavior.

That was a really good idea. I ran the profiler and looked at the SQL. However, I don't find any broken SQL. All I see are a couple queries that select the calendar user. The answer to this query looks correct. I ran all the queries myself and they return valid results.

What I'm not seeing is a query to get the data from the ACTIVITY table. It's as if it thinks it's empty before trying to get data out of it, or it fails in the code somewhere without looking for the data.

Thanks for your help and if you have any additional ideas, please let me know!

Check table plugin for your groupBuilder tabs. Check blobs stored there to see sql selects. That should help. 

We believe this problem comes from a corrupted SageGroupBuilder.dll. We were able to fix it in our test system by reverting to an older version.