Java awapi timing out - PLS-00201: identifier must be declared

Document ID : KB000088172
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.





 
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.
Resolution:
Consult with an Oracle DBA to troubleshoot and resolve the PLS error.

Fix Status: No Fix

Fix Version(s):
N/A
Additional Information:
Workaround :
N/A