Unable to run jobs throwing Launch Error "AW_GET_JOB_DATA"
Article ID: 399742
Updated On:
Products
Issue/Introduction
Cannot run any jobs due to 'Launch error'. Message says that it is missing the 'AW_GET_JOB_DATA' after the upgrade to v9.5.2
Did not fix after following steps 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.
-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
Environment
V9.5.2
Cause
Both scripts awweb_spec.sql and awweb_body.sql loaded from current version will probably be corrupted calling $AW_HOME/data/extra_file.dat references. Follow small change mentioned in solution to fix the "AW_GET_JOB_DATA" issue.
Resolution
To Fix the issue:
- Remove $AW_HOME/data/extra_file.dat file
- Run installer(cdinst.sh) select option "01" to re-apply upgrade potion
- Start Master Services(startso all)
Additional Information
Feedback
