Why OK v8.6.0.x Analytics ODI ETL Processing Failed With ORA-06512 At Task INSERT-DIM_INTENT_STG of PKG_LOAD_DIM_STG_TABLES ? (Doc ID 2310908.1)

Last updated on NOVEMBER 02, 2017

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.

Goal

Explain why OK v8.6.0.x Analytics ODI ETL processing failing with ORA-06512 at task INSERT-DIM_INTENT_STG of PKG_LOAD_DIM_STG_TABLES as below:

...

ODI-1217: Session PKG_LOAD_DIM_STG_TABLES (2713101) fails with return code 8103.
ODI-1226: Step INSERT-DIM_INTENT_STG fails after 1 attempt(s).
ODI-1232: Procedure INSERT-DIM_INTENT_STG execution fails.
ODI-1228: Task INSERT-DIM_INTENT_STG (Procedure) fails on the target ORACLE connection ORACLE_SERVER.
Caused By: java.sql.SQLException: ORA-08103: object no longer exists
ORA-06512: at line 13

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)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
 ...

Solution

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