BI Applications 220.127.116.11.1+ How Can We Ensure the Load Plan Does Not Get Started Again Until the Last Run has Completed Successfully
Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 18.104.22.168.1 and later
Information in this document applies to any platform.
You have a nightly scheduled load for Production. The load usually completes successfully in the right amount of time, however occasionally there have been issues that have caused it to continue running, sometimes forever. In these cases, even though the load plan is still running, when the scheduled time the next day comes the load plan will be executed again, overlapping with the last run, and ruining the integrity of the data warehouse.
This would also be an issue when the execution fails, say on the weekend. If the Friday night load failed, the Saturday and Sunday would still run, starting from the beginning, spoiling the Data Warehouse.
How can we ensure the load plan does not get started again until the last run has completed successfully?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms