4 Upgrading the Argus Insight Data Mart Structure

Argus Insight upgrade process has been moved from Schema Creation Tool to Liquibase for silent installation.

Before upgrading, make sure:

1. In the profile switch CMN_PROFILE_GLOBAL, the existing database version is 8.1.

2. Take the latest Liquibase build for 8.1.1.

To upgrade Argus Insight data mart structure:

1. Log in to Argus Insight Web Server.

2. Navigate to Programs > Oracle > Argus Insight > Database > DBInstaller.

3. Open DBInstaller.properties file.

4. Modify the following parameters:

   • Insight Database:

     • db_connect_string—connects to the Argus Insight database.

       Syntax: db_connect_string=<host>:<port>/<SID>

       For example, db_connect_string=Us. Xx.com:1521/AI811MT

     • dba_user—specifies the name of the DBA user to run Argus Insight Liquibase Install.

       See Section 3.4.3, "Creating the DBA User."

   • Insight User of each schema, where password is optional:

     • appschema_mart_user

     • appschema_stage_user

     • appschema_mart_app_user

     • appschema_mart_hist_user

     • appschema_ai_link_user

     • appschema_rls_user

     • appschema_ai_apr_user

     • appschema_ai_login_user

   • Insight Roles:

     • ai_role—specifies Mart User roles

     • ai_app_role—specifies App User roles

     • ai_link_role—specifies Link User roles

   • Secure Key:

     • argus_securekey_path—path of the file insight.ini in the middle-tier machine from where the DBInstaller.bat is executed.

   • Safety Database:

     • safety_db—Argus Safety database instance name

     • safety_ro_user—Argus Insight Read-only user created in Argus Safety

   Note:

   For more information on these parameters, see Section 3.2, "Modify of the dbinstaller.properties file."

5. From the command prompt, go to DBInstaller directory.

6. Type dbinstaller.bat, and press Enter.

   The Liquibase upgrade begins, and the parameters (as entered) appear on the command prompt screen with password in the hidden mode (****).

7. Keep monitoring the Liquibase progress by querying the Liquibase Log table insight_dbchangelog, created in APR_MART schema.

8. When the process is complete, a confirmation message appears with the latest version of Argus Insight.