Migration from 4.62B to R2

Vote:
 

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
Vote:
 

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.