Solution ID: prim80352
Error migrating Contract Manager group database to MS SQL Server: "The CREATE UNIQUE INDEX statement terminated….. The duplicate key value is(VNMT, VND, VNDT, VNA)."
Status: Reviewed
Version(s): 11.1, 12.0, 12.1, 12.1 sp1

Problem: Error migrating Contract Manager group database to MS SQL Server: “The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name’dbo.IMPORT_MODULES’ and the index name ‘import_modules_index’. The duplicate key value is(VNMT, VND, VNDT, VNA).”
Cause: Rows within the import_modules table are causing a violation of the an index being added during database conversion.
Fix: Please contact Oracle Primavera Support to resolve this issue.