OBIA 11g BIACM Load Plan Failed - ODI-1529: Refresh of variable "BIAPPS.TODAY_WID" failed
(Doc ID 1964423.1)
Last updated on NOVEMBER 22, 2021
Applies to:
Business Intelligence Applications Consumer - Version 11.1.1.7.1 and laterInformation in this document applies to any platform.
May 05, 2017
Symptoms
OBIA 11.1.1.7.1
In BIACM, the load plan failed with ODI-1519.
ODI-1519: Serial step "Start Load Plan (InternalID:44016500)" failed because child step "Global Variable Refresh (InternalID:44017500)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:44017500)" failed because child step "Warehouse Load Phase (InternalID:45512500)" is in error.
ODI-1519: Serial step "Warehouse Load Phase (InternalID:45512500)" failed because child step "1 PLP Load (InternalID:46467500)" is in error.
ODI-1519: Serial step "1 PLP Load (InternalID:46467500)" failed because child step "2 PLP Fact Group (InternalID:46510500)" is in error.
ODI-1519: Serial step "2 PLP Fact Group (InternalID:46510500)" failed because child step "Parallel (InternalID:46511500)" is in error.
ODI-1518: Parallel step "Parallel (InternalID:46511500)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: OM PLP Serial (InternalID:46568500)
ODI-1519: Serial step "OM PLP Serial (InternalID:46568500)" failed because child step "3 PLP Fact OMCUSTSTATHIST_FG (InternalID:46569500)" is in error.
ODI-1519: Serial step "3 PLP Fact OMCUSTSTATHIST_FG (InternalID:46569500)" failed because child step "OMCUSTSTATHIST_FG (InternalID:46570500)" is in error.
ODI-1529: Refresh of variable "BIAPPS.TODAY_WID" failed :
SELECT ROW_WID FROM W_DAY_D WHERE W_CURRENT_CAL_DAY_CODE='Current'
ODI-1527: Error refreshing variable "BIAPPS.TODAY_WID": the associated SQL query returned no results.
ODI-1519: Serial step "Global Variable Refresh (InternalID:44017500)" failed because child step "Warehouse Load Phase (InternalID:45512500)" is in error.
ODI-1519: Serial step "Warehouse Load Phase (InternalID:45512500)" failed because child step "1 PLP Load (InternalID:46467500)" is in error.
ODI-1519: Serial step "1 PLP Load (InternalID:46467500)" failed because child step "2 PLP Fact Group (InternalID:46510500)" is in error.
ODI-1519: Serial step "2 PLP Fact Group (InternalID:46510500)" failed because child step "Parallel (InternalID:46511500)" is in error.
ODI-1518: Parallel step "Parallel (InternalID:46511500)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: OM PLP Serial (InternalID:46568500)
ODI-1519: Serial step "OM PLP Serial (InternalID:46568500)" failed because child step "3 PLP Fact OMCUSTSTATHIST_FG (InternalID:46569500)" is in error.
ODI-1519: Serial step "3 PLP Fact OMCUSTSTATHIST_FG (InternalID:46569500)" failed because child step "OMCUSTSTATHIST_FG (InternalID:46570500)" is in error.
ODI-1529: Refresh of variable "BIAPPS.TODAY_WID" failed :
SELECT ROW_WID FROM W_DAY_D WHERE W_CURRENT_CAL_DAY_CODE='Current'
ODI-1527: Error refreshing variable "BIAPPS.TODAY_WID": the associated SQL query returned no results.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |