Hi,
i want to migrate my repositories from ODI 11g to ODI 12c.
I launch the "Oracle Fusion Middleware Upgrade Assistant and enter the correct informations.
It manages to migrate from 04.x.x.x to 05.01.01.01, then from 05.01.01.01 to 05.01.01.02, but when it tries to migrate from 05.01.01.02 to 05.01.01.03, i have an error ODI-14096
oracle.odi.setup.RepositorySetupException: com.sunopsis.repository.manager.upgrade.RepositoryUpgradeException: Error while executing DDL Patch M_05.01.01.02_05.01.01.03.xml
Caused by: com.sunopsis.repository.manager.upgrade.RepositoryUpgradeException: Error while executing DDL Patch M_05.01.01.02_05.01.01.03.xml
Caused by: java.lang.RuntimeException: Error while executing alter table SNP_USER_OBJ_METH add constraint AK_R_OBJ_METH_GUID unique ( GLOBAL_IDÂ )
Caused by: java.sql.SQLIntegrityConstraintViolationException: [FMWGEN][SQLServer JDBC Driver][SQLServer]The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.SNP_USER_OBJ_METH' and the index name 'AK_R_OBJ_METH_GUID'. The duplicate key value is (<NULL>).
I previously migrated from 10 to 11g, and perhaps is there some elements that are unstable since then ...
Can somebody help me to find what the problem is, please ?
Thanks.
Best regards,
Eric.