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