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
Oracle Warehouse Builder - Version 22.214.171.124 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