14 Re-initializing the ETL Process

Once you have sucessfully 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 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 as shown in the following figure:

   Figure 14-1 Confirmation of Resetting 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, as shown in the following figure:

   Figure 14-2 Entering TNS Name to Connect to Database

   
   

3. Enter the TNS Name to connect to the 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 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, as shown in the following figure:

      Figure 14-3 Connecting to the Database

      
      

5. Press Enter to complete writing the logs.

   Figure 14-4 Writing Enterprise Creation Logs

   
   

6. Press Enter to exit from the window.