OBIA 11g Index Creation Failing on EAM Facts ODI-1217: Session fails with return code 20000

(Doc ID 2042527.1)

Last updated on JANUARY 07, 2016

Applies to:

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


You are attempting to setup the eAM system in OBIEE. The ODI loads are failing on the 3 facts

They all have errors similar to this Asset Fact:

ODI-1217: Session SILOS_SIL_EAMASSETFACT (50044510) fails with return code 20000.
ODI-1226: Step Run SIL_EAMAssetFact.W_EAM_ASSET_F fails after 1 attempt(s).
ODI-1240: Flow Run SIL_EAMAssetFact.W_EAM_ASSET_F fails while performing a Integration operation. This flow loads target table W_EAM_ASSET_F.
ODI-1228: Task SIL_EAMAssetFact.W_EAM_ASSET_F (Integration) fails on the target ORACLE connection BIAPPS_DW.
Caused By: java.sql.SQLException: ORA-20000: Error creating indexes in parallel, see W_ETL_EVENT_LOG for details
ORA-06512: at line 119


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