CCM posts “wrong” content to Activity Stream
last week our support team had to deal with a strange issue that occurred when using IBM Connections libraries.
From time to time the Activity Stream showed updates from library files that have not been touched for weeks…
A file had been uploaded in December 2015 into a library. And it has definitely never been updated like this! Now in February an entry showed up:
“User XYZ updated the file XYZ” …
or “User XYZ mentioned you in ‘FILEXYZ.PPT’ “
Digging deeper into this, I remembered a problem with the j2calias used by Filenet used to send data to the IBM Connections Activity stream.
The user or the password was set incorrectly so that Filenet was not able to post any content into the activity stream. Now it is interesting what Filenet does in such a case… it stores those entries within its own FNOS database (kind of a buffer so that those messages do not get lost)
After fixing the problem with the j2calias Filenet was able to post again into the stream. The news application reads those entries from the database and processes it. The problem is that those entries were too old and the timestamp is used when the news applications reads the data from the database table. In a way this seems pretty buggy to me… But if you know how it works there is an easy fix for this:
Delete the old entries from database using the following procedure:
– Stop IBM Connections
– Backup the Filenet databases (FNOS / FNGCD)
– Execute the following SQL so that you remove all rows from the table LCUSER.UT_CLBACTIVITYSTREAMEVENTQUE except the row OBJECT_ID=”00000000000000000000000000000000″
db2 "DELETE FROM LCUSER.UT_CLBACTIVITYSTREAMQUEUEENT WHERE ENTRY_STATUS = 2 AND OBJECT_ID <> x'00000000000000000000000000000000'"
The problem description originally comes from a great blog post written by Charlie Price –> link
This post was about mass mail notifications sent from CCM. But this perfectly fits our problem and solved it!! Thanks for this 😉