Migration from 4.62B to R2 | Episerver Developer Community

Migration from 4.62B to R2

 

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? 

#29498 Apr 29, 2009 13:51
  • Member since: 1999
     

    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

    #29506 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.
Please login to post a reply