My Oracle Support Banner

Error "ODI-15226: The root table <ROOT_TABLE_NAME> has no data" when Sending JMS XML MQ Messages in Parallel (Doc ID 2753899.1)

Last updated on JUNE 01, 2023

Applies to:

Oracle Data Integrator - Version 12.2.1.3.190708 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

To send individual messages to a Java Message Service (JMS) XML Message Queue (MQ) using Oracle Data Integrator (ODI), a mapping takes one row from the table and sends it to MQ in an XML structure. To send multiple messages, an ODI procedure loops execution of the mapping (compiled to a scenario). To speed up this process of adding messages, the procedure is executed in parallel.

In some of the Scenario executions, randomly the below error appears:

 

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!

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