STARETL Fails at Step 41, Part 1 with ORA-12899: Value Too Large For Column (Doc ID 2201833.1)

Last updated on FEBRUARY 16, 2017

Applies to:

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

Symptoms

The STARETL fails with the following error:

<10.26.2016 03:12:20> staretl [INFO] (Progress) - Step 41/50 Part 1/6 -
[10/26/2016 03:12:20] CodesLoad -- Load Codes (codes_part1.sql)
<10.26.2016 03:12:20> staretl [ERROR] (Message) - Problem with credential
mapping.
<10.26.2016 03:12:20> staretl [INFO] (Message) - Connecting to database...
<10.26.2016 03:12:21> staretl [INFO] (Message) - === Step 41, Part 1
====================================================
<10.26.2016 03:12:21> staretl [INFO] (Message) - === Load Codes
(codes_part1.sql)
<10.26.2016 03:12:21> staretl [ERROR] (Message) - Problem with credential
mapping.
<10.26.2016 03:12:21> staretl [INFO] (Message) - declare
<10.26.2016 03:12:21> staretl [INFO] (Message) - *
<10.26.2016 03:12:21> staretl [INFO] (Message) - ERROR at line 1:
<10.26.2016 03:12:21> staretl [INFO] (Message) - ORA-12899: value too large
for column
<10.26.2016 03:12:21> staretl [INFO] (Message) -
"STARUSER"."ETL_PROJ_CODE_MAP_OPT"."REG_EXP_PATTERN" (actual: 267, maximum:
<10.26.2016 03:12:21> staretl [INFO] (Message) - 255)
<10.26.2016 03:12:21> staretl [INFO] (Message) - ORA-06512: at line 85
<10.26.2016 03:12:21> staretl [INFO] (Message) - ORA-06512: at line 105
<10.26.2016 03:12:21> staretl [ERROR] (Message) - Problem with credential
mapping.
<10.26.2016 03:12:21> staretl [ERROR] (Message) - Problem with credential
mapping.
<10.26.2016 03:12:21> staretl [INFO] (Progress) - Step 41/50 Part 1/6 -
FAILED (99) (0 hours, 0 minutes, 1 seconds, 169 milliseconds)

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