7 Upgrading the Argus Mart

This chapter explains how to upgrade Argus Mart 8.0 to Argus Mart 8.1, including ODI Metadata and the Schema Creation Tool.

The following figure explains the process to upgrade from Argus Mart 8.0 to Argus Mart 8.1:

Figure 7-1 Steps to Upgrade Argus Mart 8.0

This chapter comprises the following sub-sections:

Before Upgrading Argus Mart
Upgrading Argus Mart Application
Upgrading Argus Mart Database
Upgrading ODI Metadata
Validating Upgraded Schema

7.1 Before Upgrading Argus Mart

Before you start the upgrade process, perform the Schema Validation for Argus Mart database.

To validate the existing schema, see Section 3.5, "Validating the Schema".

7.2 Upgrading Argus Mart Application

To upgrade the existing Argus Mart application, perform all the steps mentioned in the Section 2.2, "Installing Argus Mart Components" in the following order:

Step 1 to Step 4. (Skip Step 5)
In Step 6, on Specify Home Details screen:
1. In the Name field, select the name of the existing Argus Mart version.
2. In the Path field, select the path of the existing Argus Mart version.
3. Click Next.
The Summary screen appears.
Click Install to start the upgrade process.

After upgrade process is complete, the release version 8.0 is updated to 8.1.

7.3 Upgrading Argus Mart Database

Note:

Before upgrading the Argus Mart Database, you must re-create the Argus Mart user (AS_MART_USER) for the Argus Safety database. This user must be the same as the one created in Section 3.4.2, "Creating User for the Argus Safety Database".

To upgrade the database from Argus Mart 8.0 to Argus Mart 8.1:

Start the Argus Mart Schema Creation Tool.
Click DB Upgrade.

The Oracle Database Connect dialog box appears.

Figure 7-2 Oracle Database Connect Screen
Connect to the Oracle Database:
1. In the User field, enter the name of Argus Mart SYSTEM or INSTALL user.
2. In the Password field, enter the password for Argus Mart SYSTEM or INSTALL user.
3. In the Database field, enter the name of your Argus Mart database.
4. Click OK.
  
  The Upgrade Parameters dialog box appears.
Figure 7-3 Upgrade Parameters Screen
In the Database and Upgrade Information section, verify the following information:
1. Database Name
2. Current Database Version
3. Upgrade to Version
4. Upgrade Directory
If the information is incorrect, click Cancel.
In the Upgrade Parameters section:
1. In the Enter DBA User Password field, enter the password of Argus Mart SYSTEM or INSTALL user.
2. In the Mart Schema Password field, enter the password of the Mart Schema Owner (AM_MART_USER).
3. In the Staging Schema Password field, enter the password of the Staging Schema Owner (AM_STAGE_USER).
4. In the Mart Application Schema Password field, enter the password of the Argus Mart application owner (AM_APP_USER).
5. In the Mart BI Schema Owner field, select a schema from the drop-down list (AM_BI_USER).
Click Next.

The Tablespace Management dialog box appears.

Figure 7-4 Tablespace Management Screen
Verify that all tablespaces have enough free space.

The green check mark indicates that the tablespace has enough free space.

If the tablespace does not have enough free space, increase the size of the tablespace by below mentioned methods:
1. Click Add to add a new datafile to the existing tablespace.
  
  The Add Data File dialog box appears.
  
  Figure 7-5 Add Data File Screen
  
  Enter a name for the new datafile (such as, AM_MART_LOB_02), containing the required additional space, and click OK.
  
  Note:
  In case no datafile exists for any tablespace, click Create.A dialog box appears to create a new datafile containing the tablespace information.
2. Alternatively, if you do not wish to add a new data file, the database administrator can resize the tablespace from the back-end.
The tablespace information is updated.

After resizing, click the Recalculate button to re-evaluate the tablespace size and refresh the tablespace grid, as per the updated tablespace size.

Once updated, the Add or Create button no longer appears and the green check mark appears, indicating that the tablespace has enough free space.

When all the tablespaces have enough free space, the Next button is enabled.
Click Next.

The Argus Mart Database Upgrade screen appears.

Click Continue to start the upgrade process.

During the upgrade process, the system upgrades the database and loads the factory data.

Enter Argus Mart SYSTEM or INSTALL user password when prompted.

Note:

In case some columns that are to be added during the upgrade process already exists in the Mart tables, then the upgrade process fails. An error message appears listing the name of those columns in a log file.

To execute the upgrade process successfully:

Stop the current upgrade process.
Drop or rename the existing columns as listed in the error message. Also, update all the dependent objects where columns are to be renamed, like views.
Re-execute DB Upgrade.

After successful completion of upgrade process, the status information appears.

Click the Book icon to view the log file and check for errors.

Alternatively, you can view the log file at any time at the following location:

<Argus Mart Install>\Database\DBInstaller\UpgradeLog.rtf
Click Finish to close the dialog box.

Note:

Recreate Argus Safety Read-only user using Argus Mart Schema Creation Tool after successful upgrade.

7.4 Validating Upgraded Schema

When you have upgraded Argus Mart, validate the schema to ensure that no object is missing.

To validate the upgraded schema, see the Section 3.5, "Validating the Schema".

7.5 Upgrading ODI Metadata

Argus Mart 8.1 does not support upgrade of existing Argus Mart 8.0 - ODI repositories. Instead, you can import new ODI metadata.

Note:

Before importing new ODI metadata, verify the ODI version from the supported technology stack. See Table 2-1.

To import new ODI metadata follow the instructions given throughout the Chapter 5, "Configuring ODI Settings."