My Oracle Support Banner

Performance Issues with "IKM SQL to JMS XML Append" ODI KM (Doc ID 2201438.1)

Last updated on MAY 19, 2023

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Information in this document applies to any platform.

Symptoms

When sending data from Database(DB) source (Oracle DB) into a JMS target (weblogic JMS queue) using bind variables and Integrated Knowledge(KM) "IKM SQL to JMS XML Append", the insert XML task is taking 20-50 seconds, and sending one message may take up to a minute.

Most messages are generated and synched successfully.

The ODI repository and J2EE agent are not in same machine. There is no load balancer involved.

The issue can be reproduced with the following steps:

  1. Create a procedure with SOURCE COMMAND being a query to select the columns that will be written in the XML file
  2. Using target command ODISTARTSCEN - run a scenario that binds all columns from the previous query into ODI variables and calls a interface that maps the variables to the target (JMS) columns.
  3. Choose IKM SQL to JMS XML Append with options INITIALIZE_XML_SCHEMA=false; ROOT_TABLE=;SYNCRO_XML_TO_JMS=true

 

 

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.