November Happy Hour will be moved to Thursday December 5th.

Migration error in step "Finalizing database schema"

Vote:
 

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()
#27861
Feb 11, 2009 10:39
Vote:
 
#27862
Feb 11, 2009 10:43
Vote:
 

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

#27866
Feb 11, 2009 11:33
Vote:
 
Indeed, removing the SP:s solved the problem. Thank you!
#27871
Feb 11, 2009 12:37
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.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.