Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Error in copying site in "Manage Content and Structure"

  Asked By: Phenil Shetye         Date: Jul 23, 2008      Category: Sharepoint      Views: 724
 

I am trying to copy a site to a different part of the portal using
the Manage Content and Structure functionality in MOSS.
This is the error I get:
<error><message>Violation of PRIMARY KEY constraint
'PK__#ExportObjects____19835DBA'. Cannot insert duplicate key
in object 'dbo.#ExportObjects'. The statement has been
terminated.</message><full>System.Data.SqlClient.SqlException:
Violation of PRIMARY KEY constraint
'PK__#ExportObjects____19835DBA'. 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.FollowLinks() at
Microsoft.SharePoint.Deployment.SPExport.CalculateObjectsToExport()
at Microsoft.SharePoint.Deployment.SPExport.Run() at
Microsoft.SharePoint.Publishing.Internal.DeploymentWrapper.Copy(String
[] sourceSmtObjectIds, String destSmtObjectId) at
Microsoft.SharePoint.Publishing.Internal.WebControls.CopyObjects.Copy
() at
Microsoft.SharePoint.Publishing.Internal.WebControls.CopyObjects.DoWor
k() at
Microsoft.SharePoint.Publishing.Internal.LongRunningOperationJob.<T
hreadEntryPoint>b__11() at
Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter
(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter,
CatchBlock catchBlock, FinallyBlock finallyBlock)
</full><customData></customData></error><error><message>Violation of
PRIMARY KEY constraint 'PK__#ExportObjects____19835DBA'.
Cannot insert duplicate key in object 'dbo.#ExportObjects'.
The statement has been
terminated.</message><full>System.Data.SqlClient.SqlException:
Violation of PRIMARY KEY constraint
'PK__#ExportObjects____19835DBA'. 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.FollowLinks() at
Microsoft.SharePoint.Deployment.SPExport.CalculateObjectsToExport()
at Microsoft.SharePoint.Deployment.SPExport.Run() at
Microsoft.SharePoint.Publishing.Internal.DeploymentWrapper.Copy(String
[] sourceSmtObjectIds, String destSmtObjectId) at
Microsoft.SharePoint.Publishing.Internal.WebControls.CopyObjects.Copy
() at
Microsoft.SharePoint.Publishing.Internal.WebControls.CopyObjects.DoWor
k() at
Microsoft.SharePoint.Publishing.Internal.LongRunningOperationJob.<T
hreadEntryPoint>b__11() at
Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter
(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter,
CatchBlock catchBlock, FinallyBlock finallyBlock) at
Microsoft.Office.Server.Diagnostics.ULS.SendWatsonOnExceptionTag
(ULSTagID tagID, ULSCat categoryID, String output, Boolean
fRethrowException, TryBlock tryBlock, CatchBlock catchBlock,
FinallyBlock finallyBlock) at
Microsoft.SharePoint.Publishing.Internal.LongRunningOperationJob.<T
hreadEntryPoint>b__f() at
Microsoft.Office.Server.Diagnostics.FirstChanceHandler.ExceptionFilter
(Boolean fRethrowException, TryBlock tryBlock, FilterBlock filter,
CatchBlock catchBlock, FinallyBlock finallyBlock)
</full><customData></customData></error>

Can someone help me to interpret this message?

Tagged:                

 

1 Answer Found

 
Answer #1       Answered By: Adalberto Merrill          Answered On: Jul 23, 2008       

This is a bug in sharepoint,

You may get the following error  while running content  export

Violation of PRIMARY key  constraint 'PK__#ExportObjects____3B8E1355'.
Cannot insert  duplicate key in object  'dbo.#ExportObjects'

Don't waste hours to resolve this like me.

This is fixed by KB950279.

MS claims this was included in Service Pack 1, but it isn't.

You have to contact Microsoft for hotfix KB950279, I have used it and
it has fixed the above issue

 
Didn't find what you were looking for? Find more on Error in copying site in "Manage Content and Structure" Or get search suggestion and latest updates.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].