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(*) >