Error "ORA-12801: error signaled in parallel query server" While Executing ODI Database Statements With "Degree of Parallelism on Target" Greater Than 1

(Doc ID 2389021.1)

Last updated on APRIL 27, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

While executing any command on an Oracle Database through Oracle Data Integrator (ODI) and a data server that has the "Degree of Parallelism on target" greater than 1, the following ORA-12801 error may occur:

Caused by: org.civ.architecture.batch.BatchException: Unable to run load plan, caused by: ODI-1519: Serial step "root_step (InternalID:9346)" failed because child step "Main Steps (InternalID:9348)" is in error.
ODI-1518: Parallel step "Main Steps (InternalID:9348)" failed; 2 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step.  Failed child steps: Entered Employment (InternalID:9381), Referrals (InternalID:9351)
ODI-1519: Serial step "Entered Employment (InternalID:9381)" failed because child step "WAR_EMP (InternalID:9382)" is in error.
ODI-1217: Session WAR_EMP (811432) fails with return code ODI-1298.
ODI-1226: Step W_WAR_EMP_MA_STG fails after 1 attempt(s).
ODI-1298: Serial task "null (50)" failed because child task "null (120)" is in error.
ODI-1298: Serial task "DW_SRC_UNIT (60)" failed because child task "null (120)" is in error.
ODI-1227: Task LKM Oracle to Oracle Datapump Plus(LRS) (Create External Table on SOURCE) fails on the source ORACLE connection LRS_SRC.
Caused By: java.sql.SQLException: ORA-12801: error signaled in parallel query server P007, instance <database_instance_name_here> (1)
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-04001: error opening file /directory/file.LOG

Changes

 

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