Error: "ORA-01489: result of string concatenation is too long" STARETL Step 52/59 Part 5/6 - FAILED (Doc ID 2119338.1)

Last updated on MARCH 28, 2016

Applies to:

Primavera Analytics - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run the ETL Process, the following error occurs:

ERROR
-----------------------

staretl [INFO] (Progress) - Step 52/59 Part 5/6 - [01/14/2016 05:10:46] CodesLoad -- Load Codes (codes_part5.sql)
staretl [INFO] (Message) - Connecting to database...
staretl [INFO] (Message) - === Step 52, Part 5 ====================================================
staretl [INFO] (Message) - === Load Codes (codes_part5.sql)
staretl [INFO] (Message) - 1800 rows updated.
staretl [INFO] (Message) - Commit complete.
staretl [INFO] (Message) - 1800 rows updated.
staretl [INFO] (Message) - Commit complete.
staretl [INFO] (Message) - WHERE REGEXP_LIKE(display_name, 'C[N|D]_.*Activity_Code_Description_\d{1}' )
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 5:
staretl [INFO] (Message) - ORA-01489: result of string concatenation is too long
staretl [INFO] (Progress) - Step 52/59 Part 5/6 - FAILED (209) (0 hours, 0 minutes, 7 seconds, 51 milliseconds)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the ETL Process.

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