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 Browse tab, navigate to Runtime > Sessions/Load Plan Executions > Load Plan Executions.

   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.

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

   • Hover over the error message to view the complete message.
   • Alternatively, navigate to Runtime > Sessions/Load Plan Executions > Sessions, right-click the stopped session, highlighted in Red color with the ! symbol, and select View.

     The error details appears in the right pane.

   • 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;