My Oracle Support Banner

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 JANUARY 08, 2020

Applies to:

Primavera Analytics - Version 16.2.0.0 and later
Primavera P6 Enterprise Project Portfolio Management - Version 16.1.4.0 to 16.1.4.0 [Release 16.1]
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.

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!


In this Document
Symptoms
Cause
Solution
References


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