ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 88172

calendar_today

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.





 

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.

Environment

OS Version: N/A

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