CA WA DE (dSeries): Jobs remain in PREDWAIT and READY state, server is slow in triggering events

Products

• CA Workload Automation DE - Business Agents (dSeries)
• CA Workload Automation DE
• DSERIES- SERVER
• CA Workload Automation DE - System Agent (dSeries)
• CA Workload Automation DE - Scheduler (dSeries)

Issue/Introduction

The jobs will remain in PREDWAIT and then REEADY state for a long time.  Jobs will eventually run and complete.

Cause

The database may be taking a long time to respond to DE (dSeries) updates and selects.  Check for following messages in the tracelogs.  Normally, wait times should be few seconds to few minutes for most applications.  If the wait times are constantly going to over 10-20 minutes to a few hours, then DB is taking a long time to respond.

Waiting time was 31 minutes 2.590 seconds

Waiting time was 43 minutes 36.256 seconds

Waiting time was 18 minutes 1.201 seconds

Waiting time was 4 hours 38 minutes 37.396 seconds

Environment

Release : 12.x
Component : CA WORKLOAD AUTOMATION DE (DSERIES)
OS: Any
DB: Any

Resolution

If DE has to wait on database then it will take a long time to run the applications and jobs. DE server has to properly update the database in order to trigger the events and run the applications.
Check if there are any issues on the database side, such as a process that is constantly taking up resources in DB server. Backup process should be checked as they sometimes tend to slow the database.