Java awapi timing out - PLS-00201: identifier must be declared
Article ID: 88172
CA Automic Applications Manager (AM)
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.
OS Version: N/A
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.
Consult with an Oracle DBA to troubleshoot and resolve the PLS error.