1 Re-initializing the ETL Process

Once you have executed the Initial ETL process on a database, you cannot execute it again till the time you clean the database. 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.

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 1-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 1-2 Entering TNS Name to Connect to Database

   
   

3. Enter the TNS Name to connect to the AM database in the Enter Database TNS field and press Enter. This displays the following text on the command screen:

   Figure 1-3 Entering Argus ETL User

   
   

4. Enter the AM database Owner with the administrator rights for the ETL process in the Enter Argus ETL User field and press Enter. This displays the following text on the command screen:

   Figure 1-4 Entering Password for Argus ETL User

   
   

   If the user is not the database owner with the administrative rights for the ETL process, the system displays an error message.

5. Enter the password for the AM database Owner for the ETL process in the Enter Password for User field and press Enter. This displays the following text on the command screen:

   Figure 1-5 Entering Log File Name

   
   

6. Enter a name for 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 1-6 Connecting to the Database

   
   

7. Press Enter to exit from the window.