Hi,
I am facing a stale session error in ODI (11g) with error message:
'ODI-1266: Agent OracleDIAgent detected Session as stale session and set to error status'
The occurrence of this error is recurring but not in a regular fashion. This error is occurring during the execution of a PL/SQL function in a scenario whose execution time lasts for about 40-50 minutes. I was informed that this kind of error takes place when Agent or Repository crashes or when connection gets interrupted. I have checked the Agent logs as well as Database logs and no indication of connection timeout or interruption exists in those logs.
I had come upon a workaround for this problem, by trying to set the ODI_CONNECTION_RETRY_COUNT parameter existing in the OdiParams.bat file to a higher value than 0. However, OdiParams.bat file exists in location [ODI_HOME]\oracledi\agent\bin when a standalone agent is used, and since this scenario executes in Production, a Java EE agent is used in this case and I cannot seem to find the OdiParams.bat file to put the workaround to use.
Could anyone specify from where I can change the ODI_CONNECTION_RETRY_COUNT parameter in case of when JavaEE agent is used? Or, some other method by which I can deal with this Stale Session error problem?
Thank you.