Behavior:
When opening the admin tool, you encounter an error message that reads: An item with the same key has already been added. The admin tool then closes.
There is a key constraint violation between the DWUser and DWUserToGroup tables in the dwsystem database.
Solution:
IMPORTANT! Before beginning, make sure you have a backup of the dwsystem database!
Confirm that there are entries in the DWUserToGroup table that don’t have a corresponding UID in the DWUser table.
select UG.*
from DWUserToGroup UG left join DWUser U on UG.uid = U.uid
where U.uid is null
If this statement returns any results, a key constraint was violated when a user was deleted, and some records were left behind. To fix it, execute this query:
delete UG
from DWUserToGroup UG left join DWUser U on UG.uid = U.uid
where U.uid is null
You will be able to open the admin tool again.
Please note: This article is a translation from English. The information contained in this article is based on the original English language product version(s). There may be minor errors such as in the grammar used in the translated version of our articles. While we cannot guarantee the complete accuracy of the translation, in most cases, you will find it to be sufficiently informative. In case of any doubt, please switch back to the English version of this article.