返回
-
标题
Database error 2812: Could not find stored procedure 'dbo.QBM_PFunctionDrop'" when performing database upgrade -
说明
Version 7.0.2 database upgrade fails to proceed when it could not locate the "dbo.QBM_PFunctionDrop" stored procedure to execute.Error message:Processing step 'QBM StopDBQueueProcessing (Stop DBQueue processing)' failed.at ConfigWizard.Pages.PageMigration.OnShowFromNext(Wizard wiz)at ConfigWizard.Pages.PageMigration._GenerateSteps()at Quantum.Migrator.Migrator.GenerateSteps()at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IList`1 steps, MigrationContext context)at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IMigrationStep step, MigrationContext context)64 - SqlFile command failed.at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IMigrationStep step, MigrationContext context)at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IList`1 lCommands, MigrationContext context)Error processing sql command line 22 in file 010FunctionsPreView\QBM_GConvert\QBM_FTSQLKeywords.sqlat Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IList`1 lCommands, MigrationContext context)at Quantum.Migrator.Base.CommandBase.Execute(MigrationContext context)at Quantum.Migrator.SqlFileCommand.OnExecute(MigrationContext context)Error during execution of statement: exec dbo.QBM_PFunctionDrop 'QBM_FTSQLKeywords'at VI.DB.DataAccess.ReadWriteDbSession.<SqlExecuteNonQueryAsync>d__13.MoveNext()Database error 2812: Could not find stored procedure 'dbo.QBM_PFunctionDrop'. -
解决办法
- Copy the stored procedure from the installation source files in the folder: ..\Modules\QBM\database\MSSQL\010FunctionsPreView\QBM_GSchema".
- Execute the SQL script manually "QBM_PFunctionDrop.sql" in SQL Server Management Studio to install the stored procedure.
- Run the configuration wizard to upgrade the database schema again.