My Oracle Support Banner

OPLA ETL Is Failing With Some Errors (Doc ID 2189012.1)

Last updated on DECEMBER 04, 2019

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


OPLA first ETL is failing with errors

ERROR
-----------------------
ODI-1228: Task var_DM_ODI_SESSION_ID (Variable) fails on the target connection TRG_ODMCONN_PHYSICAL.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Source Agile version: 9.3.5, ODI:11.1.1.9.0, OBIEE:11.1.1.9.0

1. Install OPLA 3.5
2. Run ETL Full load for Stage and MDS
3. ETL fails

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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