The following errors can be seen in the RmiServer log when attempting to execute a job in Applications Maanager.
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
Release : 9.4.x
Component : CA Automic Applications Manager (AM)
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.
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