PLS-00302: component 'AW_GET_JOB_DATA' must be declared

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

The following errors can be seen in the RmiServer log when attempting to execute a job in Applications Manager.

ErrorMsg: AwE-5001 Database Query Error
Details: ORA-06550: line 1, column 24:
PLS-00302: component 'AW_GET_JOB_DATA' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

Environment

Release : 9.4.x

Component : CA Automic Applications Manager (AM)

Cause

This error message indicates that the component "AW_GET_JOB_DATA" does not exist in the database. To confirm if the object exist log into the Applications Manager database and run the following sql.

SQL>select object_name, object_type ,procedure_name from user_procedures where procedure_name ='AW_GET_JOB_DATA';

If the objects does not exist, it is suggested to run awinstall with option 1 as outlined in the resolution section below.

Resolution

Awinstall calls $AW_HOME/sql/awweb_spec.sql and $AW_HOME/sql/awweb_body.sql which creates "AW_GET_JOB_DATA". Running awinstall with option 1 should create the object in the database.

To run awinstall with option 1 please reference the following article

How to run awinstall Option 1

Once awinstall completes, the following sql can be used to confirm if the object was created.

SQL>select object_name, object_type ,procedure_name from user_procedures where procedure_name ='AW_GET_JOB_DATA';

If the object does not exist after running awinstall with option one and the error message persist, please raise a support request and provided the following details in the case.

-The complete version of Applications Manager installed.

-$AW_HOME/sql/awweb_spec.sql

-$AW_HOME/sql/awweb_body.sql

-$AW_HOME/install/aw_install.log