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

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