Get a list of all Communities and their ID

If you ever need to get a list of community names and their community uuid out of connections, you can open your SQL Browser and connect to the communities database and try to get the info out of the tables.

Or you can open wsadmin.

wsadmin>execfile(“communitiesAdmin.py”)
wsadmin>commList=CommunitiesService.fetchAllComm()
wsadmin>for cd in commList;
wsadmin> print cd.get(“name”)+”;”+cd.get(“uuid”)
wsadmin>[Enter]

 

Important: Don’t forget the space after the > in this line: wsadmin> print cd.get(“name”)+”;”+cd.get(“uuid”)

 

 

 

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……’