Incident Persister fails to start with error "No record found for selection of Trigger with key: 'BlobCleanupService.BLOB_CLEANUP_JOB'"

Products

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

Issue/Introduction

Symantec Data Loss Prevention (DLP)

 

Incident Persister service fails to start, (stops soon after starting up).
An example of the IncidentPersister_0.log shows the error.

 

"No record found for selection of Trigger with key: 'BlobCleanupService.BLOB_CLEANUP_JOB' and statement: SELECT * FROM IP_QRTZ_CRON_TRIGGERS WHERE SCHED_NAME = 'incidentPersisterScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?"

-----------------------------------------------------------------------------------Log Snip------------------------------------------------------------------------------

(WARNING) Thread: 17 [com.vontu.incidenthandler.blob.cleanup.BlobCleanupSchedulerService.setBlobCleanupSchedule] Incident Blob Cleanup schedule could not be updated. Restart Incident Persister service to retry

org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'BlobCleanupService.BLOB_CLEANUP_JOB' and statement: SELECT * FROM IP_QRTZ_CRON_TRIGGERS WHERE SCHED_NAME = 'incidentPersisterScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'BlobCleanupService.BLOB_CLEANUP_JOB' and statement: SELECT * FROM IP_QRTZ_CRON_TRIGGERS WHERE SCHED_NAME = 'incidentPersisterScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]

at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1524)

at org.quartz.impl.jdbcjobstore.JobStoreSupport$12.execute(JobStoreSupport.java:1512)

at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:245)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeWithoutLock(JobStoreSupport.java:3716)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1509)

at org.quartz.core.QuartzScheduler.getTrigger(QuartzScheduler.java:1477)

at org.quartz.core.QuartzScheduler.rescheduleJob(QuartzScheduler.java:1070)

at org.quartz.impl.StdScheduler.rescheduleJob(StdScheduler.java:312)

at com.vontu.scheduler.CronJobSchedulerImpl.scheduleCronJob(CronJobSchedulerImpl.java:47)

at com.vontu.incidenthandler.blob.cleanup.BlobCleanupSchedulerService.setBlobCleanupSchedule(BlobCleanupSchedulerService.java:92)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.lang.reflect.Method.invoke(Method.java:498)

Caused by: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'BlobCleanupService.BLOB_CLEANUP_JOB' and statement: SELECT * FROM IP_QRTZ_CRON_TRIGGERS WHERE SCHED_NAME = 'incidentPersisterScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?

at org.quartz.impl.jdbcjobstore.CronTriggerPersistenceDelegate.loadExtendedTriggerProperties(CronTriggerPersistenceDelegate.java:92)

at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1801)

at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1520)

-----------------------------------------------------------------------------------Log Snip------------------------------------------------------------------------------

Environment

Any DLP version

Cause

Issue is caused due to missing BLOB_CLEANUP_JOB in IP_QRTZ_CRON_TRIGGERS table.
A select query as protect can be used to verify if record is missing from table.

select * from IP_QRTZ_CRON_TRIGGERS;

Resolution

Contact Support for further assistance.