Duplicate users in IBM Connections 3 Homepage table

In IBM Connections 3.0.1 your network contacts are kept in the profiles database, but also in the homepage database.

The reason for this is probably because you need them to show feeds for your network in the Homepage application and the applications are developed by different teams so the homepage team probably found it more convenient to keep them as well to be able to manipulate the table as they wanted to.

This has some side effects, looks like the restrictions on inserts into this table was not written as well as in the profiles database. As a result you could end up with doubles in there. This will show when users complain about seeing board entries from people in their network twice or even more.

I don’t think there is a fix for this to apply on your 3.0.1 environment but I have not seen this happen since we went to CR1 so I suppose this is fixed now.

If you do not have CR1 or higher and are facing this issue, this is a command you can use to check for doubles in your NR_NETWORK table in the Homepage Database

SELECT PERSON_ID, COLLEAGUE_ID
FROM HOMEPAGE.NR_NETWORK
GROUP BY PERSON_ID, COLLEAGUE_ID
HAVING COUNT(*) > 1

If you find duplicates, run the following command to remove them (after a backup of the Homepage database of course)

DELETE FROM HOMEPAGE.NR_NETWORK WHERE NETWORK_ID IN (
 select NR_NETWORK.NETWORK_ID
 from (
  SELECT MAX(NETWORK_ID) NETWORK_ID, PERSON_ID, COLLEAGUE_ID
  FROM HOMEPAGE.NR_NETWORK
  GROUP BY  PERSON_ID, COLLEAGUE_ID
  ) T,
   HOMEPAGE.NR_NETWORK NR_NETWORK
 where  NR_NETWORK.NETWORK_ID < T.NETWORK_ID AND
   NR_NETWORK.PERSON_ID = T.PERSON_ID AND
   NR_NETWORK.COLLEAGUE_ID = T.COLLEAGUE_ID
);                                                                      

COMMIT;

Run the first command again to check if duplicates are gone

SELECT PERSON_ID, COLLEAGUE_ID
FROM HOMEPAGE.NR_NETWORK
GROUP BY PERSON_ID, COLLEAGUE_ID
HAVING COUNT(*) >
Advertisements

About Wannes Rams

I'm a IBM Collaboration software consultant. I am specialized in the architecture and technical lead of enterprise implementations. I started of as a Lotus Domino specialist certified up to Domino 8, but moved on to IBM Connections, Lotus Sametime and Lotus Quickr. I also have experience with WebSphere Administration and WebSphere Portal deployments. I am also IBM Champion for ICS Specialties: Lotus Domino Lotus Sametime Lotus Quickr IBM Connections WebSphere Portal administration WebSphere Application server administration Cisco Firewall administration Tivoli Directory Integrator Social Business
This entry was posted in IBM Connections and tagged , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s