web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

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

(0) ShareShare
ReportReport
Posted on by

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)
  • Suggested answer
    Community Member Profile Picture
    on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans