Stage Full ETL Got Stuck after OPLA Configurator Domain Value Setting (Doc ID 2162515.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Product Lifecycle Analytics - Version 3.5.0 to 3.5.0 [Release 3.5.0]
Information in this document applies to any platform.

Symptoms

On : 3.5.0 version, OPLA Configurator

ETL process warning at
Session: ODI_INT_CREATE_DBLINK
Step: Loading - SS_0 - Drop Synonym - view on Target

Error:
----------------------
ODI-1228: Task SS0 (Loading) fails on the target ORACLE connection TRG_ODMCONN_PHYSICAL.
Caused By: java.sql.SQLException: ORA-1434: private synonym to be dropped does not exist

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Environment Details:
Agile source version: 9.3.5
ODI 11.1.1.9
OBIEE 11.1.1.9

Before the following Domain Value setting, ETL can be executed successfully but cannot display portfolio and program data in BI dashboard.

1. Create “Portfolio” subclass under Activities in Agile Java client
2. Create Portfolio object named “Test - 2017” in Agile Web client
3. In portfolio object, add three projects in “PLM Reference” attribute
4. In OPLA configurator->options->ETL configurators->domain lookup->set as following:
Add Agile plm sub class for program and portfolio (portfolio: portfolio, program: program). Save the setting.
5. Execute ETL process and got warning message:

Session: ODI_INT_CREATE_DBLINK
Step: Loading - SS_0 - Drop Synonym - view on Target

ODI-1228: Task SS0 (Loading) fails on the target ORACLE connection TRG_ODMCONN_PHYSICAL.
Caused By: java.sql.SQLException: ORA-1434: private synonym to be dropped does not exist

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