Project and Portfolio Management Practitioners Forum
cancel

Restart stalled ETL to Business Objects

Highlighted
Erik Cole
Acclaimed Contributor.

Restart stalled ETL to Business Objects

Does anyone know the proper method to restart the ETL to BO? Our last scheduled run got stopped in the FM step, and the job is in a 'chain_stalled' state. The status in RPT_ETL_JOB is still 'RUNNING'.

 

Thanks!

1 REPLY
teetotal
Regular Contributor.

Re: Restart stalled ETL to Business Objects

Please delete the row in RPT_ETL_JOB whose status is RUNNING.

 

It's due to a defect in ETL code, sometimes the oracle job fails, but the row in RPT_ETL_JOB's status does not reset to 'FAILED'