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.