My Oracle Support Banner

ODI-40761: Not Enough Memory to Read the XML File while Loading Data from a Large JSON File (Doc ID 2722341.1)

Last updated on OCTOBER 29, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

The following error is encountered when using Oracle Data Integrator (ODI) 12c and processing a very large JSON file by reading it and synchronizing into the defined schema:

ODI-1228: Task Procedure-IG1_AR_MDM_PRC_SYNC_PRS-Synchronize fails on the target connection XML_conn.
Caused By: java.sql.SQLException: ODI-40761: Not enough memory to read the XML file
  at com.sunopsis.jdbc.driver.xml.SnpsXmlFile.synchronizeFromFile(SnpsXmlFile.java:713)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlSchema.synchronizeSchema(SnpsXmlSchema.java:1747)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.internalExecute(SnpsXmlConnection.java:641)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.preprocessStatement(SnpsXmlConnection.java:1481)
  at com.sunopsis.jdbc.driver.xml.SnpsXmlStatement.execute(SnpsXmlStatement.java:30)
  at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:208)
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:142)
  at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
  at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
  at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:216)
  at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:128)
  at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:886)
  at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2225)
  at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:610)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
  at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85)
  at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:917)
  at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
  at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
  at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
  at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)
  at java.util.concurrent.FutureTask.run(FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
  at java.lang.Thread.run(Thread.java:748)

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
Cause
Solution
References


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