OBIA 11g - Manage Load Plan Error (Doc ID 2119541.1)

Last updated on AUGUST 11, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 and later
Information in this document applies to any platform.

Symptoms

On Oracle Business Intelligence Applications, v11g -

When trying to execute SDE and SIL based on https://docs.oracle.com/cd/E63231_01/doc/BIAIN/GUID-C528329C-7EA1-44AA-91E6-B33DCC548A6A.htm

The following error is thrown during the execution the Load Plan:
Error Message ODI-1519: Serial step "Start Load Plan (InternalID:3180501)" failed because child step "Global Variable Refresh (InternalID:3181501)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:3181501)" failed because child step "1 Domain (InternalID:3188501)" is in error.
ODI-1519: Serial step "1 Domain (InternalID:3188501)" failed because child step "2 Domain PRE-SDE (InternalID:3189501)" is in error.
ODI-1519: Serial step "2 Domain PRE-SDE (InternalID:3189501)" failed because child step "3 PRE-SDE Domain (InternalID:3219501)" is in error.
ODI-1519: Serial step "3 PRE-SDE Domain (InternalID:3219501)" failed because child step "PRE-SDE (InternalID:3225501)" is in error.
ODI-1519: Serial step "PRE-SDE (InternalID:3225501)" failed because child step "Serial (InternalID:3226501)" is in error.
ODI-1519: Serial step "Serial (InternalID:3226501)" failed because child step "SIL_LANGUAGESGENERAL (InternalID:3227501)" is in error.
ODI-1217: Session SILOS_SIL_LANGUAGESGENERAL (162501) fails with return code 20942.
ODI-1226: Step Diagnostics Raise Exception fails after 1 attempt(s).
ODI-1232: Procedure Diagnostics Raise Exception execution fails.
ODI-1228: Task Diagnostics Raise Exception (Procedure) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20942: This task failed and could not be autocorrected. Please see complete ODI operator log to get the actual error message => ORA-20942:
ORA-06512: at line 49

  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
  at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
  at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
  at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

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