Overview
Admin of the group is unable to download members of the group using Export all members to CSV option available under the Action tab. It throws 'An unexpected error has occurred'.
Environment
On-premise, Jive Cloud. On-premise customers can execute the query by themselves, Cloud customers will need to open a ticket in the Jive Support Portal.
Resolution
Run the following query:
SELECT groupid
FROM jivesgroup
WHERE name LIKE '%<group name>%';
SELECT *
FROM jiveuser
JOIN jivesgroupmember ON jivesgroupmember.userid = jiveuser.userid
WHERE jivesgroupmember.groupid = <groupid
FROM the FIRST query>
AND jiveuser.firstname IS NULL
AND jiveuser.lastname IS NULL
AND membertype = 1;
If this query shows any results, it means these users are not registered. Removing them should solve the issue.
Comments
0 comments
Article is closed for comments.