My Oracle Support Banner

'Insufficient system resources exist to complete the requested service' Signaled When Running An ODI Integration Interface On A Very Large File Using An ODI_MAX_HEAP of 1GB (Doc ID 1280465.1)

Last updated on JUNE 16, 2022

Applies to:

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

Symptoms

When loading a very large file with the ODI version 10.1.3.4.0 set with a ODI_MAX_HEAP of 1024m (1 GigaB) using the ODI File Driver the following message is signaled:

7000 : null : java.sql.SQLException: Error reading file: java.io.IOException said Insufficient system resources exist to complete  the requested service
java.sql.SQLException: Error reading file: java.io.IOException said Insufficient system resources exist to complete  the requested service
  at com.sunopsis.jdbc.driver.file.x.next(x.java)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(SnpSessTaskSql.java)
  ...

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


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