JMS Messages Delivered by ODI 12c to the Queue Are Not Present After Commit Step
Last updated on SEPTEMBER 05, 2017
Applies to:Oracle Data Integrator - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
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 was researched on ODI 12.2.1 with IBM MQ as the target, but it can occur for any JMS Queue and ODI 12c version.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms