org.quartz.JobPersistenceException

Couldn't acquire next trigger: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]]

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

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

Solutions on the web468

  • via Terracotta Project Issue Tracker by seetha Lakshmi, 1 year ago
    TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]
  • via Terracotta Project Issue Tracker by seetha Lakshmi, 1 year ago
    TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]
  • QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'T3JobScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'TRIGGER-GROUP-CT.CAPTURE-TRIGGER-4752649' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'T3JobScheduler' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]]
  • Stack trace

    • org.quartz.JobPersistenceException: Couldn't acquire next trigger: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?]] at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2848) at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2759) at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2757) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3787) at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756) at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272) Caused by: org.quartz.JobPersistenceException: Couldn't retrieve trigger: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? [See nested exception: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ?] at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1533) at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2808) ... 5 more Caused by: java.lang.IllegalStateException: No record found for selection of Trigger with key: 'MandateManagement.3092665_TRIGGERCREATION_18.02.2015 08:40:14' and statement: SELECT * FROM QRTZ_SIMPLE_TRIGGERS WHERE SCHED_NAME = 'quartzSchedulerJobFactory' AND TRIGGER_NAME = ? AND TRIGGER_GROUP = ? at org.quartz.impl.jdbcjobstore.SimpleTriggerPersistenceDelegate.loadExtendedTriggerProperties(SimpleTriggerPersistenceDelegate.java:95) at org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectTrigger(StdJDBCDelegate.java:1819) at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveTrigger(JobStoreSupport.java:1531) ... 6 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

    You’re the first here who have seen this exception.