Error "ORA-06502: PL/SQL: Numeric or Value Error" During Step 57/63, Part 2 (If Running Setup) or During Step 43/49, Part 2 (If Running starETL) for Loading UDF and Codes Historical Dimension Tables (Doc ID 2134434.1)

Last updated on JULY 20, 2016

Applies to:

Primavera Data Warehouse - Version 15.2.0.0 and later
Primavera Analytics - Version 15.2.0.0 and later
Information in this document applies to any platform.

Symptoms

Running SETUP.BAT (OR SETUP.SH), the ETL process fails with the following error at step 57/63, Part 2/3:

ERROR

TIMESTAMP setup [INFO] (Message) - === Step 57, Part 2 ====================================================
TIMESTAMP setup [INFO] (Message) - === Load UDF and Codes Historical Dimension Tables (udf_codes_hd_load)
TIMESTAMP setup [INFO] (Message) - Adding sql script W_CODES_PROJECT_HD.sql to the job queue
TIMESTAMP setup [INFO] (Progress) - Starting Script W_CODES_PROJECT_HD.sql
TIMESTAMP setup [INFO] (Message) - Adding sql script W_UDF_ACTIVITY_HD.sql to the job queue
TIMESTAMP setup [INFO] (Progress) - Starting Script W_UDF_ACTIVITY_HD.sql
TIMESTAMP setup [INFO] (Message) - Adding sql script W_CODES_ACTIVITY_HD.sql to the job queue
TIMESTAMP setup [INFO] (Progress) - Starting Script W_CODES_ACTIVITY_HD.sql
TIMESTAMP setup [INFO] (Message) - Adding sql script W_CODES_RESOURCE_HD.sql to the job queue
TIMESTAMP setup [INFO] (Progress) - Starting Script W_CODES_RESOURCE_HD.sql
TIMESTAMP setup [INFO] (Message) - Adding sql script W_UDF_PROJECT_HD.sql to the job queue
TIMESTAMP setup [INFO] (Progress) - Starting Script W_UDF_PROJECT_HD.sql
TIMESTAMP setup [INFO] (Message) - ORA-06512: at "STARUSER.SCD", line 397
TIMESTAMP setup [INFO] (Message) - ORA-06512: at "STARUSER.SCD", line 789
TIMESTAMP setup [INFO] (Message) - Exception: Error during load for table W_CODES_RESOURCE_HD: ORA-06502: PL/SQL: numeric or v
TIMESTAMP setup [INFO] (Message) - (100,W_CODES_RESOURCE_D,W_CODES_RESOURCE_HD,n/a,n/a)
TIMESTAMP setup [INFO] (Message) - DECLARE
TIMESTAMP setup [INFO] (Message) - *
TIMESTAMP setup [INFO] (Message) - ERROR at line 1:
TIMESTAMP setup [INFO] (Message) - ORA-06502: PL/SQL: numeric or value error
TIMESTAMP setup [INFO] (Message) - ORA-06512: at "STARUSER.SCD", line 840
TIMESTAMP setup [INFO] (Message) - ORA-06512: at line 4
TIMESTAMP setup [INFO] (Progress) - Finished Script W_CODES_RESOURCE_HD.sql

RUNNING STARETL.BAT (OR STARETL.SH), the ETL process fails with the following error at step 43/49 Part 2/3:

ERROR

TIMESTAMP staretl [INFO] (Message) - ORA-06512: at "STARUSER.SCD", line 754
TIMESTAMP staretl [INFO] (Message) - Exception: Error during load for table W_CODES_RESOURCE_HD: ORA-06502: PL/SQL: numeric or v
TIMESTAMP staretl [INFO] (Message) - (100,W_CODES_RESOURCE_D,W_CODES_RESOURCE_HD,n/a,n/a)
TIMESTAMP staretl [INFO] (Message) - DECLARE
TIMESTAMP staretl [INFO] (Message) - *
TIMESTAMP staretl [INFO] (Message) - ERROR at line 1:
TIMESTAMP staretl [INFO] (Message) - ORA-06502: PL/SQL: numeric or value error
TIMESTAMP staretl [INFO] (Message) - ORA-06512: at "STARUSER.SCD", line 805
TIMESTAMP staretl [INFO] (Message) - ORA-06512: at line 4
TIMESTAMP staretl [INFO] (Progress) - Finished Script W_CODES_RESOURCE_HD.sql
TIMESTAMP staretl [INFO] (Message) - Adding sql script W_UDF_RESOURCE_HD.sql to the job queue
TIMESTAMP staretl [INFO] (Progress) - Starting Script W_UDF_RESOURCE_HD.sql
TIMESTAMP staretl [INFO] (Message) - ORA-06512: at "STARUSER.SCD", line 371
TIMESTAMP staretl [INFO] (Message) - ORA-06512: at "STARUSER.SCD", line 754
TIMESTAMP staretl [INFO] (Message) - Exception: Error during load for table W_CODES_ACTIVITY_HD: ORA-06502: PL/SQL: numeric or v
TIMESTAMP staretl [INFO] (Message) - (100,W_CODES_ACTIVITY_D,W_CODES_ACTIVITY_HD,n/a,n/a)
TIMESTAMP staretl [INFO] (Message) - DECLARE
TIMESTAMP staretl [INFO] (Message) - *
TIMESTAMP staretl [INFO] (Message) - ERROR at line 1:
TIMESTAMP staretl [INFO] (Message) - ORA-06502: PL/SQL: numeric or value error

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