Migrating database from HF‐001 to 6.0.0_HF‐002 Hotfix

1. To migrate the database from TIBCO® Order Management 6.0.0_HF‐001 to 6.0.0_HF‐002 Hotfix, run the following scripts for Oracle or PostgreSQL from the <OM_HOME>/db/dbscripts/(oracle/postgreSQL)/ location:
  • For the admin database, ./upgrade_6.0.0hf1_to_6.0.0hf2_db_setup.sh

  • For the order database, ./upgrade_6.0.0hf1_to_6.0.0hf2_db‐setup.sh

2. To add the new properties for all the microservices, use the JSON files present at each $OM_HOME/samples/PayLoadJson/addPayLoads location. It is a good practice to remove the unused properties by using the JSON files present at the $OM_HOME/samples/PayLoadJson/deletePayLoads location for the cleanup purpose.
3. For the migration service, update appropriate configurations for the 6.0.0_HF-2 database under "Order Data Source Configuration for 6.0 Application" and "Archival Database Configuration for 6.0 Application" categories. Use the Configurator UI or Configurator APIs for this purpose.
4. Use the Configurator UI or Configurator API to set the enableLegacyMigration flag to "false" for migration service.
5. Run the migration service in 6.0.0_HF‐002 Hotfix.
6. Use the /migration/auditTrail POST APIs to migrate the audit trail related information for the given set of orders.