Full Load Fails When Agile Read Only Account Is Used
(Doc ID 2139785.1)
Last updated on DECEMBER 06, 2020
Applies to:Oracle Product Lifecycle Analytics - Version 3.5.0 and later
Information in this document applies to any platform.
First full load after installing OPLA fails with below error
Session DM_ETL_LOAD (130631103) fails with return code 942.[[
ODI-1226: Step var_GET_PLM_SCHEMA fails after 1 attempt(s).
ODI-1228: Task var_GET_PLM_SCHEMA (Variable) fails on the target connection SRC_CONN_PHYSICAL.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
The issue can be reproduced at will with the following steps:
1. Install OPLA using Agile read-only account as SRC_CONN_PHYSICAL
2. Run Full Load
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