Argus Insight upgrade process has been moved from Schema Creation Tool to Liquibase for silent installation.
Before upgrading, make sure:
In the profile switch CMN_PROFILE_GLOBAL, the existing database version is 8.1.
Take the latest Liquibase build for 8.1.1.
To upgrade Argus Insight data mart structure:
Log in to Argus Insight Web Server.
Navigate to Programs > Oracle > Argus Insight > Database > DBInstaller.
Open DBInstaller.properties file.
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.
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."From the command prompt, go to DBInstaller directory.
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 (****).
Keep monitoring the Liquibase progress by querying the Liquibase Log table insight_dbchangelog, created in APR_MART schema.
When the process is complete, a confirmation message appears with the latest version of Argus Insight.
Validate Schema using the schema validation control file VLDN_APR_AI_8.1.1.CTL.
Recreate the Safety RO User of Insight before execution of the next Incremental ETL.
See Section 3.4.2, "Creating Users and Roles in the Argus Safety Database."