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.

       

       

      Thanks

       

      Raye

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

           

          Thanks,

          Sony Asrani