IBM Connections 6 – Following and Followers blank

IBM Connections 6 – Following and Followers blank

Hi,

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:

Looks good:

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.

The solution:

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.

Leave a Reply

Your email address will not be published. Required fields are marked *