My Oracle Support Banner

Full Load Fails When Agile Read Only Account Is Used (Doc ID 2139785.1)

Last updated on FEBRUARY 20, 2019

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

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