OWB 11.2 Code Template Mapping Fails With Job Error: Com.Microsoft.Sqlserver.Jdbc.Sqlserverexception: The System Is Out Of Memory

(Doc ID 1355676.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version and later
Information in this document applies to any platform.


The execution of an OWB 11.2 Code Template Mapping reading a huge amount of data from a sqlserver source table fails with:

Job xxx error: com.microsoft.sqlserver.jdbc.SQLServerException: The system is out of memory. Use server side cursors for large result sets:Java heap space. Result set size: xxx. JVM total memory size:xxx


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 hundreds of Community platforms