Java awapi timing out - PLS-00201: identifier must be declared
Article ID: 88172
Updated On:
Products
CA Automic Applications Manager (AM)
Issue/Introduction
Error Message :
ErrorMsg: AwE-9999 Internal error (6/11/17 9:24 AM)
Details: null
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'AW_WEB_API.AW_CLIENT_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
When starting the Application Manager (AM) processes, the following error is seen:
Error: java awapi timed out.
A review of the $AW_HOME/log/AgentService log file shows the above PLS-00201 error messages.
ErrorMsg: AwE-9999 Internal error (6/11/17 9:24 AM)
Details: null
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'AW_WEB_API.AW_CLIENT_SESSION' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
When starting the Application Manager (AM) processes, the following error is seen:
Error: java awapi timed out.
A review of the $AW_HOME/log/AgentService log file shows the above PLS-00201 error messages.
Environment
OS Version: N/A
Cause
Cause type:
Configuration
Root Cause: The PLS-PLS-00201: identifier must be declared error is generate from Oracle. The erorr message is commonly seen when the referenced package (AW_WEB_API.AW_CLIENT_SESSION) does not exist, does not have execute permission or is invalid.
Configuration
Root Cause: The PLS-PLS-00201: identifier must be declared error is generate from Oracle. The erorr message is commonly seen when the referenced package (AW_WEB_API.AW_CLIENT_SESSION) does not exist, does not have execute permission or is invalid.
Resolution
Consult with an Oracle DBA to troubleshoot and resolve the PLS error.
Fix Status: No Fix
Fix Version(s):
N/A
Fix Status: No Fix
Fix Version(s):
N/A
Additional Information
Workaround :
N/A
N/A
Feedback
Yes
No
Powered by
