My Oracle Support Banner

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

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.

Symptoms

First full load after installing OPLA fails with below error

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




Steps

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

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!


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