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
Migration error in step "Finalizing database schema"
Try to remove these 2 stored procedures from the database. There was like 2 or 3 customers that had a custom page type converter module built in CMS 4 that now is part of the product. Just a qualified guess that this customer is one of them.
netConvertPageType
netConvertPropertyForPageType
Feb 11, 2009 11:33
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.
I get the following error in the migration tool, any clues whag I might do to circumvent it?
[2009-02-11 10:28:58][Information] Finished migrating database data [2009-02-11 10:28:58][Information] Finalizing database schema... [2009-02-11 10:29:13][Error] Migration terminated with error: [2009-02-11 10:29:13][Error] System.Data.SqlClient.SqlException: There is already an object named 'netConvertPropertyForPageType' in the database. 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()