Not Able to Run Averify Generic Fix Scripts In Agile Database with Error: ORA-00942: table or view does not exist
(Doc ID 2973537.1)
Last updated on JANUARY 24, 2024
Applies to:
Oracle Agile PLM Framework - Version 9.3.6.0 and laterInformation in this document applies to any platform.
Symptoms
Not able to run the Averify fix scripts in Agile Database schema with below error:
select name from v$database;
ERROR at line 1:
ORA-00942: table or view does not exist
Oracle database 19c 19.0.0.0.0
select name into :adtSID from v$database;
ERROR at line 11:
ORA-06550: line 11, column 35:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 11, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 14, column 99:
PL/SQL: ORA-00942: table or view does not exist
ORA-06550: line 14, column 5:
PL/SQL: SQL Statement ignored
~ Object: Does not exist in the AGILE schema - operation not performed.
The issue can be reproduced at will with the following steps:
1. Download Averify fix script (i.e. AGIL-00015002_f1.sql) to the client machine.
2. From the client machine. login to sqlplus as agile database user.
3. Run Averify fix script.
4. Gets error in sqlplus console.
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |