Enforce UI fails to load, shows 404 error and GlobalDialog?type=NOT_FOUND in the URL

Products

• Data Loss Prevention
• Data Loss Prevention Core Package
• Data Loss Prevention Enforce
• Data Loss Prevention Oracle Standard Edition 2

Issue/Introduction

The Enforce console is not loading and keeps refreshing. In the URL, you can see the string GlobalDialog?type=NOT_FOUND. 

In the localhost log, the following error is seen around the time of the server startup:

Exception sending context initialized event to listener instance of class [com.vontu.manager.spring.ManagerContextLoaderListener]
Cause:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'actionAckReconcilerSchedulerService': Injection of autowired dependencies failed; nested exception is java.lang.RuntimeException: org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'ACTIONACK_RECONCILER_JOB_EXEC.ACTIONACK_RECONCILER_JOB' and statement: SELECT * FROM MGR_QRTZ_CRON_TRIGGERS WHERE SCHED_NAME = 'managerScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'ACTIONACK_RECONCILER_JOB_EXEC.ACTIONACK_RECONCILER_JOB' and statement: SELECT * FROM MGR_QRTZ_CRON_TRIGGERS WHERE SCHED_NAME = 'managerScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'actionAckReconcilerSchedulerService': Injection of autowired dependencies failed; nested exception is java.lang.RuntimeException: org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'ACTIONACK_RECONCILER_JOB_EXEC.ACTIONACK_RECONCILER_JOB' and statement: SELECT * FROM MGR_QRTZ_CRON_TRIGGERS WHERE SCHED_NAME = 'managerScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'ACTIONACK_RECONCILER_JOB_EXEC.ACTIONACK_RECONCILER_JOB' and statement: SELECT * FROM MGR_QRTZ_CRON_TRIGGERS WHERE SCHED_NAME = 'managerScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]

Cause

This is a similar problem to the one described in KB article Enforce server fails to load and shows (404) - GlobalDialog?type=NOT_FOUND. The cause is a missing entry in the MGR_QRTZ_CRON_TRIGGERS table. 

Resolution

Please contact Broadcom Support for further assistance.