Content Deployment Problem : Violation of PRIMARY KEY constraint

I had a content deployment job that had been successfully exceuting the deployment of changed content for many weeks until i started getting this error show up;

-------------------------

Publishing:Content deployment job failed. Error: 'System.Data.SqlClient.SqlException:Violation of PRIMARY KEY constraint 'PK__#ExportObjects____459C5949'. Cannotinsert duplicate key in object 'dbo.#ExportObjects'.

The statementhas been terminated.
   atSystem.Data.SqlClient.SqlConnection.OnError(SqlException exception, BooleanbreakConnection)
   atSystem.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,Boolean breakConnection)
   atSystem.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj)
   atSystem.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommandcmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReaderds, RunBehavior runBehavior, String resetOptionsString)
   atSystem.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   atSystem.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResultresult)
   atSystem.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result,String methodName, Boolean sendToPipe)
   atSystem.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   atMicrosoft.SharePoint.Utilities.SqlSession.ExecuteNonQuery(SqlCommand command)
   atMicrosoft.SharePoint.Deployment.SPExport.CalculateObjectDependencies(BooleanlinksOnly)
   atMicrosoft.SharePoint.Deployment.SPExport.FollowLinks()
   atMicrosoft.SharePoint.Deployment.SPExport.CalculateObjectsToExport()
   at Microsoft.SharePoint.Deployment.SPExport.Run()
   atMicrosoft.SharePoint.Publishing.Administration.ContentDeploymentJob.DoServerToServer()
   atMicrosoft.SharePoint.Publishing.Administration.ContentDeploymentJob.ExecuteJob()
   atMicrosoft.SharePoint.Publishing.Administration.ContentDeploymentJob.Run(BooleanrunAsynchronously)
   atMicrosoft.SharePoint.Publishing.Administration.ContentDeploymentJobDefinition.Execute(GuidtargetInstanceId)'

 For moreinformation, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

-------------------------

To resolve this i took the following steps;

1. Log onto the source server and goto Operations > Content Deployment Paths & Jobs.

2. Delete the path that holds my changed content job

3. Restart the Timer Service

4. Recreate the path and job.

To resolve this i took the following steps;

1. Log onto the source server and goto Operations > Content Deployment Paths & Jobs.

2. Delete the path that holds my changed content job

3. Restart the Timer Service

4. Recreate the path and job.

technorati tags:Sharepoint, MOSS, WCM, Content, Deployment, 2007

Blogged with Flock