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 SEPTEMBER 08, 2023

Applies to:

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

Symptoms

An Oracle Warehouse Builder (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 :

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.