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 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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

Cause

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