ETL Failed At Step 42/51 Part 5/6 With Error "ORA-01489: result of string concatenation is too long" When Executing Load Codes (codes_part5.sql) (Doc ID 2294822.1)

Last updated on AUGUST 08, 2017

Applies to:

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

Symptoms

When attempting to run ETL process, the following error occurs.

ERROR
-----------------------
staretl [INFO] (Message) - === Step 42, Part 5 ====================================================
staretl [INFO] (Message) - === Load Codes (codes_part5.sql)
staretl [ERROR] (Message) - Problem with credential mapping.
staretl [INFO] (Message) - declare
staretl [INFO] (Message) - *
staretl [INFO] (Message) - ERROR at line 1:
staretl [INFO] (Message) - ORA-01489: result of string concatenation is too long
staretl [INFO] (Message) - ORA-06512: at line 20
staretl [ERROR] (Message) - Problem with credential mapping.
staretl [ERROR] (Message) - Problem with credential mapping.
staretl [INFO] (Progress) - Step 42/51 Part 5/6 - FAILED (209) (0 hours, 0 minutes, 9 seconds, 52 milliseconds)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run ETL process, but fail at step 42/51 with above error.

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

Changes

 

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