Error: "Invalid column name 'AgentAndBrokerAvailable'"
説明
Update from 8.2 to 9.2 fails with the error message:
Processing step 'QBM StopDBQueueProcessing_part1 (Stop DBQueue processing part 1)' failed. at ConfigWizard.Pages.PageMigration.GenerationAsync(CancellationToken ct) at Quantum.Migrator.Migrator.GenerateSteps() at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IList`1 steps, MigrationContext context) at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLoggingAndRetries(IMigrationStep step, MigrationContext context) at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IMigrationStep step, MigrationContext context) 196 - Sql command failed. at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IMigrationStep step, MigrationContext context) at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IList`1 lCommands, MigrationContext context)
[810023] Error running statement: exec QBM_PTriggerDisable '%', '%' at Quantum.Migrator.Base.ExtensionMethods.ExecuteWithLogging(IList`1 lCommands, MigrationContext context) at Quantum.Migrator.Base.CommandBase.Execute(MigrationContext context) at Quantum.Migrator.Base.MigrationContext.SqlExecuteNonQuery(IOperation sender, String strSql, String logMessage) at VI.Base.SyncActions.Do[T,T1,T2](T1 p1, T2 p2, Func`3 function) at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() --- End of stack trace from previous location where exception was thrown --- at VI.DB.DataAccess.ReadWriteDbSession.<SqlExecuteNonQueryAsync>d__22.MoveNext()
[810143] Database error 50000: 207 0 detected in (SRV=COMMODUS, DB=BL36480V82) Procedure QBM_PWriteDialogJournal, Line 3 207 0 Invalid column name 'AgentAndBrokerAvailable'.
原因
This is a product defect (37341).
対策
WORKAROUND
Intermediate migration to 9.0 or 9.1
STATUS
This will be fixed in a future release of the product. If you require this immediately corrected, please contact Support for a hotfix referencing the defect ID 37341.