My Oracle Support Banner

'java.sql.SQLException: Not in transaction' Error When Run Jobs With An Agent Connecting To An Informix Repository In ODI (Doc ID 749316.1)

Last updated on JUNE 16, 2022

Applies to:

Oracle Data Integrator - Version to [Release 10gR3]
Information in this document applies to any platform.
This problem can occur on any platform.


The following message is signaled when starting an Agent that connects to an Informix Work Repository:

Starting Oracle Data Integrator Agent...
Version : - 30/10/2007
08/21/2008 04:17:02 PM(main): Server Launched INFORMIX DICTIONNARY CONNECTION : set lock mode to wait 20 INFORMIX
DICTIONNARY CONNECTION : set lock mode to wait 20

Start the Agent with the trace on (-v=5), the following error appears in the trace when run a job with the Agent (local or remote) and the Session never starts: 

java.sql.SQLException: Not in transaction




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

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