Full ETL Fails with 'ORA-00942 - table or view does not exist' When SQL: 'SELECT value FROM "agile" .PROPERTYTABLE WHERE id = 33086' Is Run (Doc ID 2978360.1)

Last updated on FEBRUARY 15, 2024

Applies to:

Symptoms

When running Full ETL (Extract-Transform-Load) Load for Oracle Product Lifecycle Analytics (OPLA) in Oracle Data Integrator (ODI), see it fails with below error:

Caused by: Error : 942. Position : 26, Sql = SELECT value FROM "agile" .PROPERTYTABLE WHERE id = 33086, ...
ORA-00942 - table or view does not exist




The issue can be reproduced at will with the following steps:

1. On the new OPLA installation, launch ODI Studio, and access to Operator tab, and run Full ETL Load.
2. Check Operator > Session List, and go to Status > Error and navigate to the session where it failed with Error, expand Variables and open Session Task Variable - var_GET_PLM_SCHEMA. Under Defenition > Variable and Sequence Values, see the error message.
   
   
   
   

Changes

Cause

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