Error: "SqlLoaderSQL LOADER ACTION FAILED" During Step 14 Of ETL Process (Doc ID 1551480.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P6 Reporting Database - Version R2 and later
Information in this document applies to any platform.

Symptoms

On : Primavera P6 Reporting Database R2 version, ETL Process

When attempting to run ERD, the following error occurs during step 14:

ERROR
-----------------------
incremental [ERROR] (Message) - SqlLoaderSQL LOADER ACTION FAILED. [control=/opt/oracle/tpdb2/Primavera/erdprd/p6rdb/scripts/DATA_ActivityCodeHierarchy.csv.ldr] [file=/path_to_erd/p6rdb/temp/ActivityCodeHierarchy/DATA_ActivityCodeHierarchy.csv] in STEP

incremental [INFO] (Progress) - Step 14/33 Part 2/12 - [04/30/2013 05:42:00] OdsBulkLoadHierarchies -- Bulk load hierarchy data into ODS (ETL_LOADActivitycodehierarchy.ldr)
incremental [INFO] (Progress) - Step 14/33 Part 2/12 - FAILED (-1) (0 hours, 0 minutes, 6 seconds, 969 milliseconds)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Re-run ERD
2. Error is presented in log files

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