My Oracle Support Banner

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.


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


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

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