Backlog Job status stop updating

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

After upgrading to Applications Manager 9.6 to 9.6.2, Job process may stop and Job statuses in the Backlog do not update or a period of time or really slowly.

RmiServer logs show that it aw_inc_update procedure taking a long time to return or does not return at all.

An example log snippet is shown below where the procedure taking over 27 minutes to return in bold:

22:21:08.380 rf: .DBAccess: getFunctionData():  sID-31128576 aw_web_api.aw_inc_update elapsed ms 13 rows 84
22:21:09.409 rf: .DBAccess: getFunctionData():  sID-31128576 aw_web_api.aw_inc_update elapsed ms 14 rows 84
22:49:07.477 rf: .DBAccess: getFunctionData():  sID-31128576 aw_web_api.aw_inc_update elapsed ms 1627313 rows 791
22:49:11.991 rf: .DBAccess: getFunctionData():  sID-31128576 aw_web_api.aw_inc_update elapsed ms 51 rows 450
22:49:15.440 rf: .DBAccess: getFunctionData():  sID-31128576 aw_web_api.aw_inc_update elapsed ms 35 rows 344 

Environment

Applications Manager version 9.6.0 to 9.6.2

Cause

While the cause is unclear, a timeout has been added to skip and retrigger the procedure if it takes longer than 60 seconds.

Resolution

Solution:

A fix will be included in Applications Manager version 9.6.3 and 10.0

Workaround for 9.6 to 9.6.2:

Fixes can be applied by running attached plb file (awweb_body_fix_20260311.plb).

1. Download attached aw_inc_update_fix.zip
2. Extract awweb_body_fix_20260311.plb from zip and move to the master's $AW_HOME/sql directory
3. Stop Applications Manager processes
4. From the $AW_HOME/sql directory, run a sqlplus command and connect to the AM database as the AM Oracle User
5. Run the below command from the sqlplus command line and exit:
   
   SQL> @awweb_body_fix_20260311.plb
   
   
6. Restart Applications Manager processes

If changes need to be reverted:

1. From the same sql directory, follow the same steps replacing the commands with the below commands:
   
   SQL> @awweb_body.sql