My Oracle Support Banner

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.


Symptoms

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 :

IBM Informix JDBC Driver for IBM Informix Dynamic Server 3.00.JC2
.... 
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 :

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
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.