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 JANUARY 02, 2018

Applies to:

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

Symptoms

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

ERROR

[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.

Changes

 

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