My Oracle Support Banner

Primavera ETL Process Fails at Step 15 Part 3/4 With Error: ORA-01722: Invalid Number (Doc ID 2187677.1)

Last updated on OCTOBER 13, 2016

Applies to:

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

Symptoms

Running the Primavera ETL process fails at step 15 part 3/4 with error:

ERROR
-----------------------
SqlLoaderSQL LOADER ACTION FAILED. [control=/csapps/oracle/product/10.2.0.4/p6rdb/scripts/DATA_ActivitySpread_1.csv.ldr] [file=/csapps/oracle/product/10.2.0.4/p6rdb/temp/ActivitySpread/DATA_ActivitySpread_1.csv]

In the DATA_ActivitySpread_1.csv.log the following error could be observed:

Record 3290: Rejected - Error on table STG_ACTIVITYSPREAD.
ORA-00604: error occurred at recursive SQL level 1
ORA-01722: invalid number

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the ETL process against the P6 database;
Notice the above behavior.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get the data from P6 to the data warehouse ODS schema.

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!


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