Posted by 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.
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-
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……’