When tenant admin checks User Manager, he may see duplicate users. The users have exactly the same email. Most probably it is because there are duplicate quota records for the user in the database. We have enhanced the uniqueness checking in the DB in new release. However, the issue might happen before the enhancement was in.
When hit the issue, need to delete the duplicate records in the Centrestack database directly.
- On Centrestack database, run the following query:
select userguid, count(*) from csmain.xaf_quota group by userguid having count(*) > 1
Here we assume you are using MySQL and the database is csmain. If you are using SQL Express/Server, the table name should be something like [user].[dbo].[xaf_quota]
The query returns the records in the xaf_quota table where userguid is not unique.
- For any userguid returned, run the SQL Statement here
select * from csmain.xaf_quota where userguid = 'xxxxx'
Need to replace xxxxx with the userguid returned.
The statement will return the duplicate records for the specific userguid. Need to delete the old records. Only keep the latest ONE record.
- After the cleanup, visit User Manager. Should not see the duplicate users anymore. If you still see them, please contact firstname.lastname@example.org.