org.quartz.JobPersistenceException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • springside4.0.1GA运行报错
    via GitHub by wszyquan
    ,
  • 1) Reports - Add Report Template 2) Enter the required information + enter a Cron expression (shedule) 3) Click Save 4) Select the report template you have created and edit it (pencil icon) 5) Press Save without changing anything LOG ******************** FINEST|2156/0|10-11-24 13:35:16|org.obiba.opal.shell.service.CommandSchedulerServiceException: org.quartz.JobPersistenceException: Couldn't store trigger '5454-trigger' for '5454' job:The job (reports.5454) referenced by the trigger does not exist. [See nested exception: org.quartz.JobPersistenceException: The job (reports.5454) referenced by the trigger does not exist.] INFO|wrapper|10-11-24 13:35:16|Trigger found: Exception FINEST|2156/0|10-11-24 13:35:16| at org.obiba.opal.shell.service.impl.quartz.QuartzCommandSchedulerServiceImpl.scheduleCommand(QuartzCommandSchedulerServiceImpl.java:72) INFO|wrapper|10-11-24 13:35:16|start script scripts/trayMessage.gv FINEST|2156/0|10-11-24 13:35:16| at org.obiba.opal.web.shell.reporting.ReportTemplateResource.updateSchedule(ReportTemplateResource.java:152) FINEST|2156/0|10-11-24 13:35:16| at org.obiba.opal.web.shell.reporting.ReportTemplateResource.updateReportTemplate(ReportTemplateResource.java:119) FINEST|2156/0|10-11-24 13:35:16| at sun.reflect.GeneratedMethodAccessor193.invoke(Unknown Source) FINEST|2156/0|10-11-24 13:35:16| at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) FINEST|2156/0|10-11-24 13:35:16| at java.lang.reflect.Method.invoke(Unknown Source) FINEST|2156/0|10-11-24 13:35:16| at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140) FINEST|2156/0|10-11-24 13:35:16| at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:246) FINEST|2156/0|10-11-24 13:35:16| at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:214) FINEST|2156/0|10-11-24 13:35:16| at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:204) FINEST|2156/0|10-11-24 13:35:16| at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:486) FINEST|2156/0|10-11-24 13:35:16| at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:463) FINEST|2156/0|10-11-24 13:35:16| at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:117) FINEST|2156/0|10-11-24 13:35:16| at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:198) FINEST|2156/0|10-11-24 13:35:16| at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:48) FINEST|2156/0|10-11-24 13:35:16| at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:43) FINEST|2156/0|10-11-24 13:35:16| at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:530) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1219) FINEST|2156/0|10-11-24 13:35:16| at org.obiba.opal.server.httpd.OpalJettyServer$TransactionFilter$1.doInTransactionWithoutResult(OpalJettyServer.java:193) FINEST|2156/0|10-11-24 13:35:16| at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) FINEST|2156/0|10-11-24 13:35:16| at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130) FINEST|2156/0|10-11-24 13:35:16| at org.obiba.opal.server.httpd.OpalJettyServer$TransactionFilter.doFilterInternal(OpalJettyServer.java:189) FINEST|2156/0|10-11-24 13:35:16| at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190) FINEST|2156/0|10-11-24 13:35:16| at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:83) FINEST|2156/0|10-11-24 13:35:16| at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190) FINEST|2156/0|10-11-24 13:35:16| at org.obiba.opal.server.httpd.security.AuthenticationFilter.doFilterInternal(AuthenticationFilter.java:60) FINEST|2156/0|10-11-24 13:35:16| at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1190) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:424) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:931) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:361) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:867) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:47) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:113) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.server.Server.handle(Server.java:337) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:581) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:1020) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:775) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:228) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.server.HttpConnection.handle(HttpConnection.java:417) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:474) FINEST|2156/0|10-11-24 13:35:16| at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:437) FINEST|2156/0|10-11-24 13:35:16| at java.lang.Thread.run(Unknown Source) FINEST|2156/0|10-11-24 13:35:16|Caused by: org.quartz.JobPersistenceException: Couldn't store trigger '5454-trigger' for '5454' job:The job (reports.5454) referenced by the trigger does not exist. [See nested exception: org.quartz.JobPersistenceException: The job (reports.5454) referenced by the trigger does not exist.] INFO|wrapper|10-11-24 13:35:16|Trigger found: Exception FINEST|2156/0|10-11-24 13:35:16| at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1245) INFO|wrapper|10-11-24 13:35:16|start script scripts/trayMessage.gv FINEST|2156/0|10-11-24 13:35:16| at org.quartz.impl.jdbcjobstore.JobStoreSupport$5.execute(JobStoreSupport.java:1151) FINEST|2156/0|10-11-24 13:35:16| at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:3691) FINEST|2156/0|10-11-24 13:35:16| at org.quartz.impl.jdbcjobstore.JobStoreCMT.executeInLock(JobStoreCMT.java:242) FINEST|2156/0|10-11-24 13:35:16| at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3687) FINEST|2156/0|10-11-24 13:35:16| at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1147) FINEST|2156/0|10-11-24 13:35:16| at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:845) FINEST|2156/0|10-11-24 13:35:16| at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:254) FINEST|2156/0|10-11-24 13:35:16| at org.obiba.opal.shell.service.impl.quartz.QuartzCommandSchedulerServiceImpl.scheduleCommand(QuartzCommandSchedulerServiceImpl.java:70) FINEST|2156/0|10-11-24 13:35:16| ... 46 more FINEST|2156/0|10-11-24 13:35:16|Caused by: org.quartz.JobPersistenceException: The job (reports.5454) referenced by the trigger does not exist. INFO|wrapper|10-11-24 13:35:16|Trigger found: Exception INFO|wrapper|10-11-24 13:35:16|end script scripts/trayMessage.gv INFO|wrapper|10-11-24 13:35:16|start script scripts/trayMessage.gv INFO|wrapper|10-11-24 13:35:16|end script scripts/trayMessage.gv INFO|wrapper|10-11-24 13:35:16|end script scripts/trayMessage.gv FINEST|2156/0|10-11-24 13:35:16| at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1206) FINEST|2156/0|10-11-24 13:35:16| ... 54 more
    via by Martin Boulanger,
    • org.quartz.JobPersistenceException: Couldn't store trigger 'T_QRTZ.TraitBdd_Trigger' for 'QRTZ.TraitBdd' job:Unknown column 'TRIGGER_TYPE' in 'field list' [See nested exception: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'TRIGGER_TYPE' in 'field list'] at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeTrigger(JobStoreSupport.java:1167) at org.quartz.impl.jdbcjobstore.JobStoreSupport$2.execute(JobStoreSupport.java:1007) at org.quartz.impl.jdbcjobstore.JobStoreSupport$45.execute(JobStoreSupport.java:3654) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3726) at org.quartz.impl.jdbcjobstore.JobStoreTX.executeInLock(JobStoreTX.java:90) at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInLock(JobStoreSupport.java:3650) at org.quartz.impl.jdbcjobstore.JobStoreSupport.storeJobAndTrigger(JobStoreSupport.java:1002) at org.quartz.core.QuartzScheduler.scheduleJob(QuartzScheduler.java:816) at org.quartz.impl.StdScheduler.scheduleJob(StdScheduler.java:250) at org.quartz.xml.XMLSchedulingDataProcessor.scheduleJobs(XMLSchedulingDataProcessor.java:1119) at org.quartz.xml.XMLSchedulingDataProcessor.processFileAndScheduleJobs(XMLSchedulingDataProcessor.java:892) at org.quartz.plugins.xml.XMLSchedulingDataProcessorPlugin.processFile(XMLSchedulingDataProcessorPlugin.java:327) at org.quartz.plugins.xml.XMLSchedulingDataProcessorPlugin.start(XMLSchedulingDataProcessorPlugin.java:255) at org.quartz.plugins.SchedulerPluginWithUserTransactionSupport.start(SchedulerPluginWithUserTransactionSupport.java:144) at org.quartz.core.QuartzScheduler.startPlugins(QuartzScheduler.java:2292) at org.quartz.core.QuartzScheduler.start(QuartzScheduler.java:508) at org.quartz.impl.StdScheduler.start(StdScheduler.java:143) at org.quartz.ee.servlet.QuartzInitializerListener.contextInitialized(QuartzInitializerListener.java:202) at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205) at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704) at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799) at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779) at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601) at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:943) at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:778) at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:504) at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315) at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324) at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061) at org.apache.catalina.core.StandardHost.start(StandardHost.java:840) at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053) at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463) at org.apache.catalina.core.StandardService.start(StandardService.java:525) at org.apache.catalina.core.StandardServer.start(StandardServer.java:754) at org.apache.catalina.startup.Catalina.start(Catalina.java:595) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289) at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
    No Bugmate found.