My Oracle Support Banner

Error: "java.sql.SQLException: ORA-08103: object no longer exists" Executing STARUSER.BP_PKG While Running SCENARIO_BP_DIM_AND_FACTS With a Unifier ETL (Doc ID 2342522.1)

Last updated on DECEMBER 03, 2019

Applies to:

Primavera Analytics Cloud Service - Version and later
Information in this document applies to any platform.


While running an Analytics ETL against a Unifier source, the following error occurs, causing the ETL to fail:


[ERROR] 2 /-/ Procedure - Load BP Dim - Load BP Dim
                  ODI-1228: Task Procedure-Load BP Dim-Load BP Dim fails on the target connection PRIMAVERA_ANALYTICS_TGT_DS.
                  Caused By: java.sql.SQLException: ORA-08103: object no longer exists
                  ORA-02063: preceding line from DSLINK02
                  ORA-06512: at "STARUSER.BP_PKG", line 19

A second, automatic ETL is executed immediate after and  completes successfully but does not bring any data into the underlining Business Process Data Warehouse tables for Analytics.




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.