My Oracle Support Banner

Error: "ORA-600: internal error code, arguments: [KGL-heap-size-exceeded]" During the ETL Process in Primavera Data Warehouse / Analytics (Doc ID 2216370.1)

Last updated on MARCH 07, 2018

Applies to:

Primavera Analytics - Version to [Release 16.1 to 16.2]
Primavera Data Warehouse - Version to [Release 16.1 to 16.2]
Information in this document applies to any platform.


Attempting to run the ETL process fails during step 44/50 of Part 2/3 (executing the script W_CODES_RESOURCE_HD.SQL), and the following error occurs.

staretl [INFO] (Message) - DECLARE
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-00600: internal error code, arguments: [KGL-heap-size-exceeded], [0xA9EBFAD68], [6], [602359552], [], [], [], [], [], [], [],
staretl [INFO] (Message) - []
staretl [INFO] (Message) - ORA-06512: at "SYS.DBMS_SQL", line 1255
staretl [INFO] (Message) - ORA-06512: at "STARUSER.DYNAMIC_UTIL", line 13
staretl [INFO] (Message) - ORA-06512: at "STARUSER.DYNAMIC_UTIL", line 46
staretl [INFO] (Message) - ORA-06512: at "STARUSER.SCD", line 414
staretl [INFO] (Message) - ORA-06512: at "STARUSER.SCD", line 756
staretl [INFO] (Message) - ORA-06512: at line 4
staretl [INFO] (Progress) - Finished Script W_CODES_RESOURCE_HD.sql
staretl [ERROR] (Message) - The SQL script W_CODES_RESOURCE_HD.sql failed


  1. Run ETL
  2. View error in log




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.