Violation of Primary Key constraint Cannot insert duplicate key in object 'dbo.#ExportObjects'.  in Service Pack 2
HI AllAm using MOSS with SP2 Installed. During a cumulative content deployment process I recieved the following error. Violation of PRIMARY KEY constraint 'PK__#ExportO__3214EC0626A703B8'. Cannot insert duplicate key in object 'dbo.#ExportObjects'. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command) at Microsoft.SharePoint.Deployment.SPExport.CalculateObjectDependencies(Boolean linksOnly) at Microsoft.SharePoint.Deployment.SPExport.CalculateObjectsToExport() at Microsoft.SharePoint.Deployment.SPExport.Run()Should I install any of the following Hot fixes inspite having SP2936867 950279 pv
February 24th, 2010 8:54am

Hi prasvi,can you please read the following article which have similar issuehttp://techtalkpt.wordpress.com/2008/05/08/incremental-deployment-fails-with-violation-of-primary-key-constraint-pk__exportobjects-cannot-insert-duplicate-key-in-object-dboexportobjects/http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/2e13998b-5cec-4201-b1b4-03b0d7b701c1/ Best Regrads, Ahmed Madany
Free Windows Admin Tool Kit Click here and download it now
February 24th, 2010 11:24am

These articles are about the same issue in SP1.I have SP2 installed and still face the issue. Would it be ok if i install those hotfixes which were released prior to SP2pv
February 24th, 2010 3:43pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics