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.
Release : 11.3.6
Component : WORKLOAD CONTROL CENTER
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