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