Restart the Failed Initial ETL (Rerun)

The process to restart the failed Initial ETL from the beginning is exactly the same as that of the process of running the Initial ETL.

When you have successfully executed the Initial ETL process on a database, you cannot execute it again till the time you reset the mart environment. To facilitate this, you need to execute a Re-initial script. It is a Batch file, which re-initializes the database, so that you can run the Initial ETL on the database again.

Note:

When you run the re-initial ETL, the data of Oracle Argus Mart is truncated and reloaded in RM and SM tables. Revision created due to reference data changes will be lost.

To execute the Re-initial script, execute the following steps:

1. Double-click the am_environment_reset.bat file available at the following path:

   ...\ArgusMart\Database\Utils\am_environment_reset.bat

   This displays a warning message, which serves as a confirmation from you that you want to reset the Mart environment.

2. Enter Y, which represents Yes, in the Do You Want to Continue (Y/N)? field, if you want to continue with resetting the Mart environment to be able to run the Initial ETL on the database again.

   Or

   Enter N, which represent No, if you want to quit the process of resetting the Mart environment.

   If you have entered Y, the Reset Environment to Re-Run Initial ETL Screen is displayed.

3. Enter the TNS Name to connect to the Oracle Argus Mart database in the Enter Database TNS field and press Enter.
4. Enter the following parameters for the user who have administrator rights to access the ETL process.

   Note:

   This user is referred to as Argus ETL User. If the user is not the database owner with the administrator rights for the ETL process, the system displays an error message.
   1. Enter the Oracle Argus Mart Database Owner in the Enter Argus ETL User field, and press Enter.
   2. Enter the password in the Enter Password for User field, and press Enter.
   3. Enter the name of the log file in the Enter log file name field, and press Enter.

      The system displays a Connecting status message and once connected displays Connected.

5. Press Enter to complete writing the logs.
6. Press Enter to exit from the window.

See the Run the ETL section for the step-by-step procedure to restart the failed Initial ETL from the beginning of ETL.