IBM Connections 6 – Following and Followers blank
during the last weeks we had to deal with a strange problem in an IBM Connections 6 environment.
The system was migrated from IC 5.5 to IC 6 and live for about 4 weeks when suddenly the following problem occurred:
Neither users that I follow nor followers were shown in the UI. Despite installing the latest Fixes no bigger changes have been performed on the system.
I was able to follow a user:
Then opening “Following” shows the right results:
But then after some minutes… the entries vanish!
Opening up a PMR ended in a nightmare that took nearly 8 weeks until the solution was found!
During this time there were various troubleshooting sessions where:
- customizations have been completely disabled
- ST integration was switched off
- HTTP Rewrite rules were introduced to prevent caching
- traces and again traces
All data was available in database… but the UI had in a way problems to correctly retrieve the data.
In the trace for the news app IBM saw the following incorrect OrgID:
[10/18/17 14:58:36:669 UTC] 00000116 FollowingImpl > com.ibm.lconn.news.following.impl.FollowingImpl getResourceId ENTRY ResourceImpl [source=PROFILES, type=PROFILE, id=A6906D52-F329-43C8-9F97-5D0E7005E486, organizationId=00000000-0000-0000-0000-000000000000, ] [10/18/17 14:58:36:670 UTC] 00000116 FollowingImpl < com.ibm.lconn.news.following.impl.FollowingImpl getResourceId RETURN [Ljava.lang.Object;@ba483562 [10/18/17 14:58:36:670 UTC] 00000116 FollowingImpl 3 com.ibm.lconn.news.following.impl.FollowingImpl isResourceFollowed Resource is not known, therefore cannot be followed by anybody yet! [10/18/17 14:58:36:670 UTC] 00000116 FollowingImpl < com.ibm.lconn.news.following.impl.FollowingImpl isResourceFollowed RETURN false
It seems that a database table HOMEPAGE.NR_RESOURCE had null values in the column “ORGANIZATION_ID”:
If this is the case you know that you seem to have the same or similar problem…
Updating the columns to match the actual ORGANIZATION_ID of the system solved the problem:
UPDATE HOMEPAGE.NR_RESOURCE SET ORGANIZATION_ID='00000000-0000-0000-0000 -000000000000' WHERE ORGANIZATION_ID IS NULL
Hope this helps someone out there.
Btw. it is not yet known where this comes from. Neither why this happened. It seems other environments are also affected. I think it is a rare specialty that only occurs when using ORACLE as DBMS.
I`ll update this post once we know more details.