Return
-
Title
Error "Violation of UNIQUE KEY constraint" encountered when importing Active Roles Server 7.x configuration database -
Description
When attempting to use the Active Roles Configuration Center to import a configuration database from Active Roles Server 7.2.1 to 7.4.3, the following error may be encountered:
[Error] [ArsBaseCommand.ProcessRecord]: Violation of UNIQUE KEY constraint 'UQ_TABLE_distinguishedName'. Cannot insert duplicate key in object 'dbo.TABLE'. The duplicate key value is (CN=Built-in Policy - POLICY NAME,CN=Builtin,CN=Administration,CN=Policies,CN=Configuration).
This issue can be seen with the following Unique Key constraint policy errors, and the respective table the entry can be found:
- UQ_APOs_distinguishedName - Located in Table: dbo.APOs
- UQ_ScriptModules_distinguishedName - Located in Table: dbo.ScriptModules
- UQ_ScheduledTasks_distinguishedName - Located in Table: dbo.ScheduledTasks
-
Cause
This issue has been identified as a product defect and logged as Defect ID: 240451 -
Resolution
STATUS:
None
WORKAROUND:
Contact support for the appropriate solution based off the error encountered.
-
Change Request
TF00240451