Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I am trying to enable archiving and am getting this error: Violation of PRIMARY KEY constraint 'archives_pk'. Cannot insert duplicate key in object 'dbo.SDE_archives'.

Is this saying that there is already a primary key in the dbo.SDE_archives table or there is already a primary key which is called archives_pk? I deleted all versions, unregistered as versioned and moved all edits to base, then re-registered as versioned and tryed to enable archiving again with the same error.

My overall question is, how do I approach the dba because I don't have access directly to management studio on SQL Server 2008 nor would I know what I am doing?..Thanks.

share|improve this question
add comment

1 Answer 1

By the error message you have mentioned, there seems to be a duplicate entry in the Archives table. Consult your DBA and delete the concerned record.

If feasible try to achieve a state zero compress and this should probably take care of the error.

Technical Article HowTo: Compress a versioned database to state 0 http://support.esri.com/en/knowledgebase/techarticles/detail/29160

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.