Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Error in copying site in "Manage Content and Structure"

  Asked By: Phenil    Date: Jul 23    Category: Sharepoint    Views: 2316

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?

Share: 

 

1 Answer Found

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

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.




Tagged: