ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Information Centric Tagging - UNIQUE KEY constraint violation.
Article ID: 187915
Updated On:
Products
Information Centric Tagging
Issue/Introduction
Symantec Information Centric Tagging (ICT)
Unable to grant roles or licenses to a user, or otherwise modify that user.
Error:
cs_server_common.BO.CannotAccessDatabaseException: Error while accessing Information Centric Tagging administration database. ---> System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'UQ_Users_user_principal_name'. Cannot insert duplicate key in object 'dbo.Users'. The duplicate key value is ([email protected]).
Cause
That user was previously a contractor and was then hired on as an employee.
That user had a different user ID when a contractor than the one she has now as an employee.
But, the user's email address is the same now as it was when she was a contractor.
The user shows up in the ICT console as her new employee user ID.
But the ICT license for her email is associated with her old contractor user ID.
In ICT, the user's email cannot be associated with more than one user ID (user principal name).
That user had a different user ID when a contractor than the one she has now as an employee.
But, the user's email address is the same now as it was when she was a contractor.
The user shows up in the ICT console as her new employee user ID.
But the ICT license for her email is associated with her old contractor user ID.
In ICT, the user's email cannot be associated with more than one user ID (user principal name).
Resolution
Ensure the old contractor user ID is not in the ICT console.
Then, on the Licenses tab, click the "Purge Unused Licenses" button and accept the prompt.
This will purge the old contractor user ID from the dbo.Users table.
After which, you are able to add and modify the new employee user ID associated with that email address.
Then, on the Licenses tab, click the "Purge Unused Licenses" button and accept the prompt.
This will purge the old contractor user ID from the dbo.Users table.
After which, you are able to add and modify the new employee user ID associated with that email address.
Feedback
Yes
No
Powered by
