
Greetings, I receive the following error in DBBuild.log when updating the database from SL 2011 FP1 to SL 2015. Is there any way to resolve the duplicate key issue?
Start Time: 4:11:08 PM
Database Name: [SYSTEM DATABASE NAME HERE]
Error Code: 1505
Error Text: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.RptFormat' and the index name 'RptFormat0'. The duplicate key value is (04600, Standard ).
Could not create constraint. See previous errors.
The statement has been terminated.
Statement: SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULL_DFLT_OFF ON
GO
exec ut_build_indexes '%'
End Time: 4:28:44 PM
*This post is locked for comments
I have the same question (0)I went back and used Database Maintenance and ran the Synchronize Selected Application database Ownership & Security for my databases. After that completed successfully, I was able to run the Update from 2011 to 2015 Update Scenario.