{"id":409,"date":"2016-02-15T14:20:21","date_gmt":"2016-02-15T13:20:21","guid":{"rendered":"http:\/\/www.ume.li\/blog\/?p=409"},"modified":"2016-02-15T14:23:54","modified_gmt":"2016-02-15T13:23:54","slug":"connections-5-mentions-kills-the-activity-streams","status":"publish","type":"post","link":"https:\/\/www.ume.li\/blog\/2016\/02\/15\/connections-5-mentions-kills-the-activity-streams\/","title":{"rendered":"Connections 5 – @Mentions kills the Activity Streams"},"content":{"rendered":"

Problem: The activity stream for @mentions keeps loading on a users homepage. \u00a0For other users, the activity stream loads as usual.<\/p>\n

Steps for troubleshooting:<\/p>\n

Login as the user in Firefox and opening the WebDeveloper you see the following messages in the Console.\"Auswahl_004\"<\/a><\/p>\n

Second error message is Error: Invalid template<\/p>\n

The JSON gets loaded by the URL\u00a0https:\/\/[FQDN]\/connections\/opensocial\/rest\/activitystreams\/@me\/@all\/@all .<\/p>\n

Copy the JSON into a decent viewer for example\u00a0JsonEditor Online<\/a>\u00a0and search for the ID in my case it was 99e81c4d-\"Auswahl_005\"<\/a><\/p>\n

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.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Resolving the Issue:<\/p>\n

open your SQL Client of choice. for example DB2 Data Studio. Connect to the homepage db.<\/p>\n

Remove the content under @Mentions
\nDELETE FROM HOMEPAGE.NR_MENTIONS_READERS where STORY_ID=’99e81c4d-11….’<\/p>\n

Remove the Content under My Activities
\nDELETE FROM HOMEPAGE.NR_RESPONSES_READERS where STORY_ID=’99e81c4d……’<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Problem: The activity stream for @mentions keeps loading on a users homepage. \u00a0For other users, the activity stream loads as<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-409","post","type-post","status-publish","format-standard","hentry","category-connections"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t