Many jobs are in success state but the status is not updated in dashboard view. DBTYPE is Derby

Products

• Autosys Workload Automation

Issue/Introduction

Many jobs are in success state but the status is not updated in WCC's dashboard view. It is showing running status.  WCC is using Derby for the database type.

Environment

Release : 11.3.6

Component : WORKLOAD CONTROL CENTER

Resolution

Check the WCC and derby logs for deadlock errors.
If deadlocks are found try restarting WCC and Derby.

Other general recommendations.

https://db.apache.org/derby/docs/10.0/manuals/develop/develop75.html#HDRSII-CONCEPTS-16400
Consider adjusting the derby.properties
derby.locks.waitTimeout=
derby.locks.deadlockTimeout=

Additionally check the wrapper.conf for derby.
https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/workload-automation-ae-and-workload-control-center/11-3-6-SP8/installing/ca-wcc-installation/tune-component-performance.html

Plan for maintenance such as compressing derby.
See link above.

Consider exporting the WCC objects and wiping the derby db clean and then importing 
the wcc objects back in.  That can help also to reclaim space and/or correct
any corruption. 
You can use the follow document as a guide:
https://knowledge.broadcom.com/external/article?articleId=4461