OWB 11.2 Code Template Mapping Execution Fails With java.lang.OutOfMemoryError: Java heap space

(Doc ID 1332077.1)

Last updated on MAY 09, 2017

Applies to:

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

Symptoms

An OWB 11.2 Code Template Mapping reading data from a SQLServer table (78 columns and +700 000 rows) starts running, loads some data into a temp table but nothing really happens.
The session shows right insert into-clause but the session status is inactive and the  Repository Browser shows a status as busy/ready.

Looking at the Agent log file (<Oracle_Home>\owb\bin\admin\jrt.log) the following can be read :

Job 97 error: java.lang.OutOfMemoryError: Java heap space
while executing
"java0xc execute java0x4 {select

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