Connections 5 – @Mentions kills the Activity Streams

Problem: The activity stream for @mentions keeps loading on a users homepage.  For other users, the activity stream loads as usual.

Steps for troubleshooting:

Login as the user in Firefox and opening the WebDeveloper you see the following messages in the Console.Auswahl_004

Second error message is Error: Invalid template

The JSON gets loaded by the URL https://[FQDN]/connections/opensocial/rest/activitystreams/@me/@all/@all .

Copy the JSON into a decent viewer for example JsonEditor Online and search for the ID in my case it was 99e81c4d-Auswahl_005

If I try to open the URL in a browser I got an error: Page not found. Testing some other URLs from the JSON. They all open other JSON streams.

 

 

 

 

 

 

Resolving the Issue:

open your SQL Client of choice. for example DB2 Data Studio. Connect to the homepage db.

Remove the content under @Mentions
DELETE FROM HOMEPAGE.NR_MENTIONS_READERS where STORY_ID=’99e81c4d-11….’

Remove the Content under My Activities
DELETE FROM HOMEPAGE.NR_RESPONSES_READERS where STORY_ID=’99e81c4d……’