Handshake between ETL and BMC Server Automation database

The handshake between the BMC Decision Support for Server Automation ETL and the BMC Server Automation database informs you whether ETL is running when you try running the Database Maintenance utility on the BMC Server Automation database. Also, it informs you whether the Database Maintenance utility is running on the BMC Server Automation database when you try running ETL, as follows:

If you try running ETL and the Database Maintenance utility is running on the BMC Server Automation database in offline mode, the following error message appears on the ETL Detailed Status page at the CHECK_BSA_DB_CLEANUP step:
```
Offline BSA DB Maintenance is running so cannot start ETL. Please wait till completion 
```
BMC recommends that you let the Database Maintenance utility complete. After that, run ETL.
If you try running ETL and the Database Maintenance utility is running on the BMC Server Automation database in online mode, the following error message appears on the ETL Detailed Status page at the CHECK_BSA_DB_CLEANUP step:
```
Online BSA DB Maintenance is running so cannot start ETL. Please wait till completion
```
You can use the -b option in the run_etl.nsh script to stop the Database Maintenance utility, as shown in the following command:
```
./run_etl.nsh -s <siteID> -v <blVersion> -b [-d <logLevel>] [-p <parallelismLevel>] [-f <propertyFile>] [-l <1>|<0>]
```
When you use this option, the script waits for 90 seconds for the Database Maintenance utility to stop. If the utility does not stop, ETL terminates with the following error message:
```
Online BSA DB Maintenance taking longer than required so aborting ETL. 
```
Note

(Oracle only) To use the -b option, the BMC Server Automation database user must be assigned the DBMS_LOCK permission.

If you try running the Database Maintenance utility on the BMC Server Automation database and ETL is running, the Database Maintenance Wizard displays an error message similar to the following:
```
Database Maintenance cannot be started due to following reason(s): ETL Process is running on the database.
```
In this case, you must wait until ETL completes and then, re-run the Database Maintenance utility.
If ETL or the database maintenance process does not complete and any of these processes is in a hung state, use the following methods to stop the processes:
- To stop ETL, use the stop_etl.nsh script.
- To stop the database maintenance process, stop the Database Maintenance utility.

Handshake between ETL and BMC Server Automation database

Comments