My Oracle Support Banner

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.


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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.