Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Update database Error ...

Update database Error Code: 1505 - SL 2011 FP1 to SL 2015

(0) Share

Report

Posted on by Community Member Microsoft Employee

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

SET ANSI_NULL_DFLT_OFF ON

exec ut_build_indexes '%'

End Time: 4:28:44 PM

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: Update database Error Code: 1505 - SL 2011 FP1 to SL 2015

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.