Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
"Fixed" this by unchecking the options to migrate users/roles/groups.
Still a cure for the symptom rather than the problem, but oh well
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()