1 Reply Latest reply on Feb 17, 2012 12:17 AM by Sony Asrani

    ETL Failure

    Rayemond Newman

      Hi Guy's


      When an etl job fails and you then execute the stop_etl.nsh script what is the sequence of events that occurs.






        • 1. ETL Failure

          Hi Raye,


          When you execute stop_etl.nsh following is the sequence of events that occur-


          1) Removal of running ETL sessions in Unix/Windows

          2) Removing exstat files for given site id

          3) Removal of .LCK file from bin folder for that site

          4) Removing child processes spawned by the run_etl for given site

          5) Resetting ETL [ETL_LAST_RUN] table to ForceError



          Hope this answers your query.



          Sony Asrani