LOAD_PLAN_REALTIME_PROJECT Does Not Restart Itself From Error "ODI-1266: Agent OracleDIAGent detected Session as stale session and set to error status"
(Doc ID 2369825.1)
Last updated on MARCH 12, 2021
Applies to:Primavera Analytics Cloud Service - Version 17.7 and later
Primavera Data Warehouse - Version 17.7 and later
Information in this document applies to any platform.
When there is a network connection problem or an agent gets disconnected from master and work repository momentarily, ODI can end up with stale sessions for the three load plans which show be indefinitely running (LOAD_PLAN_ON_DEMAND, LOAD_PLAN_REALTIME_PROJECT, LOAD_PLAN_REALTIME_GLOBAL).
This will result in a Load Plan, which was in a running state before the agent momentarily disconnects from master and work repository, to fail with the following error: "ODI-1266: Agent OracleDIAGent detected Session as stale session and set to error status."
The three load plans are designed to restart themselves by calling LOAD_PLAN_RETRIES_INCREMENT.
However, LOAD_PLAN_REALTIME_PROJECT is not restarting itself when this condition occurs.
- LOAD_PLAN_REALTIME_GLOBAL does successfully restart
- LOAD_PLAN_ON_DEMAND does successfully restart
The LOAD_PLAN_REALTIME_PROJECT should properly restart itself after failing with ODI-1266 when there is a network connection problem or an agent gets disconnected from master and work repository momentarily.
Starting with a running environment (as well as having all three load plans in a running state), complete the following steps:
- Forcefully close the ODI Managed Server
- Restart the ODI Managed Server
- Start the ODI Studio
- From the Operator tab, note:
- the failure with the LOAD_PLAN_REALTIME_PROJECT
- the load plan not restarting
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