Orphaned Processes Generated On Informix Databases When The ODI Agentscheduler Is Executing Scenarios
(Doc ID 790639.1)
Last updated on JUNE 16, 2022
Applies to:Oracle Data Integrator - Version 10.1.3.4.6 and later
Information in this document applies to any platform.
This problem can occur on any platform.
When running Oracle Data Integrator, (ODI), Scenarios on an Agentscheduler which accesses Informix database tables, the execution appears to go to completion.
However, after consulting the data in the target Datastore, the Integration Interface appears not to have populated the targeted table. Moreover, no error messages are present in the Scenario execution log in ODI Operator.
If the Agent is run in trace mode (-v=5) the trace file which contains an error message such as :
02/24/2009 11:00:44 AM(DwgCmdExecutionThread): Session : 1486001 finished with return code : -1
Also, when consulting the Informix internal tables using the onstat command :
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