I have a BIApps Load Plan with dozens of scenarios in it. All of the scenarios run just fine when I execute them straight out of the Developer tab. Three of them fail - every time - when they run as part of the load plan. However, I have built another load plan containing only those three scenarios, and they run just fine in that load plan.
The error on all three is "ORA-00942: table or view does not exist". When I grab the SQL and run it in SQL Developer, it runs without error (of course). Obviously, the tables exist or the scenarios would always fail.
The three scenarios are:
SDE_PSFT_92_ADAPTOR_SDE_PSFT_INTERNALORGANIZATIONDIMENSION_COMPANYHIERARCHY_FINSC
SDE_PSFT_92_ADAPTOR_SDE_PSFT_STAGE_GLSEGMENTDIMENSIONHIERARCHY_PROJECT_PRIMARY
SDE_PSFT_92_ADAPTOR_SDE_PSFT_PRODUCTCATEGORIES_HIERARCHY_EXTRACT
I have regenerated the scenarios - no luck, same behavior in the "bad" load plan. I have also right-clicked the failed load plan on the Operator tab and selected 'Restart'. The three scenarios still fail. Yet I can immediately run them naturally from the Developer tab, or run them from the new 3-scenario-only load plan, and they run perfectly.
What might cause a scenario to fail when it runs in one load plan, but succeed when it runs in a different load plan and also succeeds when run directly from the Developer tab?