Reviewing Results
There are multiple methods available to review the operations that the upgrade utility has performed on the database. The upgrade utility provides a front end for viewing these results.
Viewing Upgrade Logs in the Utility
After a successful upgrade, the VersionUpgradeEditor window list of modules shows each individual task the utility performed. For any task, you can click the Log button to view details of that task only. To view a comprehensive log of all changes for the upgrade, you can click the Log button on the lower right hand side of the VersionUpgrade editor window.
For each task, you can click on the Report button to view the execution status of the task.
Database Tables
A number of new tables are added to the OIPA schema in order to capture the current status of database compatibility and the results of running the upgrade utility.
AsSystemVersion
- Tracks the OIPA versions where the utility upgraded the database.
- The current database compatibility version can be found by querying for the SystemVersion column that corresponds to the latest CompletedGMT column.
AsUpgradeModule
- Tracks the individual upgrade modules that have been executed on the database instance.
- Modules may include database update scripts or Java modules executed within the utility for rule modification and complex database modification.
DatabaseChangeLog
- Tracks database script execution only.
- Used by the utility to ensure database modification dependency integrity.