DE service can sometimes take over 30 mins to restart

Products

• ESP dSeries Workload Automation
• DSERIES- SERVER
• ESP dSeries Workload Automation - Scheduler (dSeries)
• ESP dSeries Workload Automation - System Agent (dSeries)

Issue/Introduction

In some rare cases DE service may take over 30 minutes to restart.  This long startup can only happened when DE has active applications and schedules.

Environment

Workload Automation DE 12.3 or above

OS: Any

Database: MS-SQL

Cause

Check logs (tracelog and errors.txt) for DB errors.  See if logs have errors like:

Unable to update ESP_JOB_DATA table

Also check if DE is loading large number of applications that were active before restart.

Resolution

If the DE server encounters database update or access errors, then check with DBA to make sure database is not having any issues.

If DE is loading large number of applications generations (>600) where some applications have large number of jobs (>200 per application), then work on breaking the application to smaller groups.  Large applications will result in extensive dependency checks which requires substantial work by the manager at startup.

It is also a good idea to break applications in smaller chunks so that they are easier to debug manage in the long term.