Debug the Failed ETL

To view the step where the ETL process failed and also the error message related to the ETL process failure, execute the following steps:

1. In the Operator tab > Load Plan Executions section, expand the Load Plan folder to view the current status of the ETL process.

   Figure 7-9 Viewing the Failed ETL Process

   

   The status of the Load Plan appears in Red color with the X symbol, which signifies that the ETL session is not in progress.

2. Double-click the Load Plan, and select Steps.

   The list of steps for the Load Plan appears in the right pane. The step because of which the ETL process has failed, is highlighted in Red color with the X symbol.

   • Hover over the cursor over the error message to view the complete message.
   • For more information about the error message, click Execute.
   • To view the error message, log on to the Oracle SQL Developer using the Argus ETL user credentials, and execute either or both of the following queries:
     • SELECT * FROM etl_stage_log ORDER BY id DESC;
     • SELECT * FROM etl_mart_log ORDER BY id DESC;