Full Load Fails When Agile Read Only Account Is Used
Last updated on OCTOBER 06, 2016
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
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