org.quartz.JobPersistenceException

Couldn't obtain triggers for job: No record found for selection of Trigger with key: 'DEFAULT.6da64b5bd2ee-f6e66122-1a99-4d83-bd60-0281c257e631' and statement: SELECT * FROM ZE_DM.QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'action-execution-group-run-now' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'DEFAULT.6da64b5bd2ee-f6e66122-1a99-4d83-bd60-0281c257e631' and statement: SELECT * FROM ZE_DM.QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'action-execution-group-run-now' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web10

  • via Unknown by Wesley Hartford,
  • via Unknown by Wesley Hartford,
  • via Unknown by Unknown author,
  • Stack trace

    • org.quartz.JobPersistenceException: Couldn't obtain triggers for job: No record found for selection of Trigger with key: 'DEFAULT.6da64b5bd2ee-f6e66122-1a99-4d83-bd60-0281c257e631' and statement: SELECT * FROM ZE_DM.QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'action-execution-group-run-now' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'DEFAULT.6da64b5bd2ee-f6e66122-1a99-4d83-bd60-0281c257e631' and statement: SELECT * FROM ZE_DM.QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'action-execution-group-run-now' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?] at com.ze.datamanager.scheduler.QuartzSchedulerWrapper.getNextScheduledStartTime(QuartzSchedulerWrapper.java:331)[scheduler-4.0-SNAPSHOT.jar:na] at com.ze.datamanager.scheduler.QuartzSchedulerManager.getNextScheduledStartTime(QuartzSchedulerManager.java:206)[scheduler-4.0-SNAPSHOT.jar:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_21] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_21] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_21] at java.lang.reflect.Method.invoke(Method.java:601)[na:1.7.0_21] at com.google.inject.internal.DelegatingInvocationHandler.invoke(DelegatingInvocationHandler.java:37)[guice-3.0.jar:na] at com.sun.proxy.$Proxy128.getNextScheduledStartTime(Unknown Source)[na:na] at com.ze.datamanager.execution.manager.ExecutionManager.prePopulateNextScheduledExecution(ExecutionManager.java:403)[execution-manager-4.0-SNAPSHOT.jar:na] at com.ze.datamanager.execution.manager.ExecutionManager.executionStarted(ExecutionManager.java:233)[execution-manager-4.0-SNAPSHOT.jar:na] at com.ze.datamanager.scheduler.process.ProcessJob.createAndExecute(ProcessJob.java:257)[quartz-process-job-4.0-SNAPSHOT.jar:na] at com.ze.datamanager.scheduler.process.ProcessJob.execute(ProcessJob.java:238)[quartz-process-job-4.0-SNAPSHOT.jar:na] at org.quartz.core.JobRunShell.run(JobRunShell.java:213)[quartz-2.1.7.jar:na] at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:557)[quartz-2.1.7.jar:na] Caused by: org.quartz.JobPersistenceException: Couldn't obtain triggers for job: No record found for selection of Trigger with key: 'DEFAULT.6da64b5bd2ee-f6e66122-1a99-4d83-bd60-0281c257e631' and statement: SELECT * FROM ZE_DM.QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'action-execution-group-run-now' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? at org.quartz.impl.jdbcjobstore.JobStoreSupport.getTriggersForJob(JobStoreSupport.java:2135)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport$28.execute(JobStoreSupport.java:2121)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3798)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:93)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeWithoutLock(JobStoreSupport.java:3703)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.getTriggersForJob(JobStoreSupport.java:2118)[quartz-2.1.7.jar:na] at org.quartz.core.QuartzScheduler.getTriggersOfJob(QuartzScheduler.java:1423)[quartz-2.1.7.jar:na] at org.quartz.impl.StdScheduler.getTriggersOfJob(StdScheduler.java:452)[quartz-2.1.7.jar:na] at com.ze.datamanager.scheduler.QuartzSchedulerWrapper.getTriggers(QuartzSchedulerWrapper.java:310)[scheduler-4.0-SNAPSHOT.jar:na] at com.ze.datamanager.scheduler.QuartzSchedulerWrapper.getNextScheduledStartTime(QuartzSchedulerWrapper.java:322)[scheduler-4.0-SNAPSHOT.jar:na] ... 13 more Caused by: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'DEFAULT.6da64b5bd2ee-f6e66122-1a99-4d83-bd60-0281c257e631' and statement: SELECT * FROM ZE_DM.QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'action-execution-group-run-now' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.loadExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:95)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1801)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTriggersForJob(StdJDBCDelegate.java:1688)[quartz-2.1.7.jar:na] at org.quartz.impl.jdbcjobstore.JobStoreSupport.getTriggersForJob(JobStoreSupport.java:2132)[quartz-2.1.7.jar:na] ... 22 more

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    We couldn't find other users who have seen this exception.