When upgrading to 6.2.0 or 6.2.2, it is possible to get an upgrade error, indicating a database upgrade failure. When checking the CB.Upgrade.yyyymmdd.hhssmm.txt log in C:\ProgramData\ChangeBASE\Logs, this error appears:
“No Package DId found for Check Transaction xxx related to Load Transaction yyy at CB.Upgrade.Custom._6._2.UpgradeItemsPreUpgrade.AddPackageTypeToCheckExecInstructionArgs.Execute(Int16 dbDefn, ISqlExecutor exec)”
Workaround:
1. Open SQL Server Management Studio
2. Restore your backed up ChangeBASE database(s)
3. Run the attached query against all applicable databases.
Warning: The information in the script(s) provided is known to work successfully; however, they have not been officially tested by Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Support and Development. Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.
4. Attempt the upgrade again
