November Happy Hour will be moved to Thursday December 5th.

Migration Tool - PK violation?

Vote:
 

We're migrating a site from 4.62 to 5 R2 and today I ran into a problem that I can't see cause or solution for.
Basically, the migration tool fails with a duplicate key error, see log below: 

 

[1/26/2009 11:24:43 AM][Information] Finished migrating Object Store

[1/26/2009 11:24:43 AM][Information] Migrating database data...

[1/26/2009 11:24:57 AM][Information] Converting Custom Property's types and Assemblies...

[1/26/2009 11:24:57 AM][Information] Source C:\Program Files\EPiServer\MigrationTool\AutoGenerateCustomProperty.cs built into C:\EPiServer\Sites\Nito5\bin\AutoGenerateCustomProperty.dll successfully.

[1/26/2009 11:25:05 AM][Error] System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tblAccess'. Cannot insert duplicate key in object 'dbo.tblAccess'.

The statement has been terminated.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.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.RunExecuteNonQueryTds(String methodName, Boolean async)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at EPiServer.Migration.SqlDataAccess.DeleteDomainPrefixFromTblAccessForUsers()

at EPiServer.Migration.MigrationWorkflow.MigrateDbData(Object sender, EventArgs e)

at System.Workflow.ComponentModel.Activity.RaiseEvent(DependencyProperty dependencyEvent, Object sender, EventArgs e)

at EPiServer.Migration.MigrationStepActivity.ExecuteHandler(Object sender, EventArgs e)

at System.Workflow.ComponentModel.Activity.RaiseEvent(DependencyProperty dependencyEvent, Object sender, EventArgs e)

at System.Workflow.Activities.CodeActivity.Execute(ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(T activity, ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.ActivityExecutor`1.Execute(Activity activity, ActivityExecutionContext executionContext)

at System.Workflow.ComponentModel.ActivityExecutorOperation.Run(IWorkflowCoreRuntime workflowCoreRuntime)

at System.Workflow.Runtime.Scheduler.Run()

#27307
Jan 26, 2009 11:42
Vote:
 

"Fixed" this by unchecking the options to migrate users/roles/groups.

Still a cure for the symptom rather than the problem, but oh well Undecided

#27308
Jan 26, 2009 14:53
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.