My Oracle Support Banner

JMS Messages Delivered by ODI 12c to the Queue are Not Present after Commit Step (Doc ID 2300685.1)

Last updated on FEBRUARY 01, 2019

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 and later
Information in this document applies to any platform.
The issue can occur for any JMS Queue type and ODI 12c version.

Symptoms

When using a Java Messaging Service (JMS) Queue as a mapping destination in Oracle Data Integrator (ODI) 12c, the data is pulled from the database using IKM SQL to JMS Append. The process completes with no errors and the log records that the records are inserted into the queue as confirmed by the insert step record count. However, the commit step count is at zero records, indicating that the commit is not occurring.

The queue files are disappearing from the destination in a very short time without being consumed, even though there are no listeners enabled for consumption on the JMS side. IKM attribute JMSEXPIRATION is set to zero, which should cause the files to remain present in the location until they are consumed.

The JMS Queue is confirmed to work via a Test, and there are no errors reported in the Operator log.

The issue can occur for any JMS Queue type and ODI 12c version.

Changes

 

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
Changes
Cause
Solution
 To configure the messages to be placed into the target message queue, but not to be consumed upon delivery...
 Adjust the mapping and change the setting of JMS_COMMIT to false as follows:
References


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