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 22.214.171.124.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.
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:
- Create a procedure with SOURCE COMMAND being a query to select the columns that will be written in the XML file
- 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.
- Choose IKM SQL to JMS XML Append with options INITIALIZE_XML_SCHEMA=false; ROOT_TABLE=;SYNCRO_XML_TO_JMS=true
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!