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
Oracle Data Integrator - Version 18.104.22.168.0 and later Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!