Erik Cole Acclaimed Contributor.
Acclaimed Contributor.
258 views

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!

0 Likes
1 Reply
teetotal Absent Member.
Absent Member.

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'

 

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.