Don't miss out Virtual Happy Hour today (April 26).
Try our conversational search powered by Generative AI!
AI OnAI Off
Migration from 4.62B to R2
Looks like you somehow got manually created statistics on that column. Statistics are dropped automatically when they are created by the query optimizer which is the normal case.
The solution: Delete '_dta_stat_386100416_4_2_1' in SQL Management Studio
Apr 29, 2009 15:47
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
Hi I have been struggeling with the migration tool for a couple of days, it now stops on the following
[2009-04-29 13:45:44][Information] Finished migrating database data
[2009-04-29 13:45:45][Information] Finalizing database schema...
[2009-04-29 13:45:53][Error] Migration terminated with error:
[2009-04-29 13:45:53][Error] System.Data.SqlClient.SqlException: The statistics '_dta_stat_386100416_4_2_1' is dependent on column 'ManualInsert'.
ALTER TABLE DROP COLUMN ManualInsert failed because one or more objects access this column.
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.ExecuteReplaceableSqlFile(StreamReader sqlStatements, Regex placeHolderRegex, MatchEvaluator placeHolderHandler, Boolean useIntegratedSecurity)
at EPiServer.Migration.SqlDataAccess.ExecuteSqlFile(StreamReader sqlStatements)
at EPiServer.Migration.MigrationWorkflow.FinalizeDbSchema(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()
Does anyone now why?