"Db sync data upgrade" step failed with error "CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name dbo.DIRPARTYCONTACTS TAGING' and the index name I_65603STAGINGIDX"


Symptoms


"Db sync data upgrade" step failed with error "CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name dbo.DIRPARTYCONTACTS TAGING' and the index name I_65603STAGINGIDX"

Resolution


Search for any staging table records that would violate the new index and remove them

More information


Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained here in is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.