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