Uploaded image for project: 'jBPM'
  1. jBPM
  2. JBPM-9395

Timer event not working properly with Quartz/Oracle DB due to CNFE

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • 7.44.0.Final
    • 7.15.0.Final
    • KieServer
    • None
    • False
    • False
    • Undefined
    • ---
    • ---

      TestCronJob.CronProcess-svg.svgI defined a quartz module in wildfly in order to make a Timer Node work with Quartz and Oracle DB 12C.

      But an Exception happens when the timer node triggers:

      }}{{| 06:23:20,910 ERROR [org.quartz.impl.jdbcjobstore.JobStoreCMT] (jBPMScheduler_QuartzSchedulerThread) Error retrieving job, setting trigger state to ERROR.: org.quartz.JobPersistenceException: Couldn't retrieve job because a required class was not found: org.jbpm.persistence.timer.GlobalJpaTimerJobInstance from [Module "org.quartz" version 0.9.1.1 from local module loader @79b4d0f (finder: local module finder @6b2fad11 (roots: /u01/jbpm/wildfly-14.0.1.Final/modules,/u01/jbpm/wildfly-14.0.1.Final/modules/system/layers/base))] [See nested exception: java.lang.ClassNotFoundException: org.jbpm.persistence.timer.Globnal/modules/system/layers/base))]]
      perseus-local | at org.quartz.impl.jdbcjobstore.JobStoreSupport.retrieveJob(JobStoreSupport.java:1388)
      perseus-local | at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTrigger(JobStoreSupport.java:2818)
      perseus-local | at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2759)
      perseus-local | at org.quartz.impl.jdbcjobstore.JobStoreSupport$40.execute(JobStoreSupport.java:2757)
      perseus-local | at org.quartz.impl.jdbcjobstore.JobStoreSupport.executeInNonManagedTXLock(JobStoreSupport.java:3803)
      perseus-local | at org.quartz.impl.jdbcjobstore.JobStoreSupport.acquireNextTriggers(JobStoreSupport.java:2756)
      perseus-local | at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:272)
      perseus-local | Caused by: java.lang.ClassNotFoundException: org.jbpm.persistence.timer.GlobalJpaTimerJobInstance from [Module "org.quartz" version 0.9.1.1 from local module loader @79b4d0f (finder: local module finder @6b2fad11 (roots: /u01/jbpm/wildfly-14.0.1.Final/modules,/u01/jbpm/wildfly-14.0.1.Final/modules/system/layers/base))]
      perseus-local | at org.jboss.modules.ModuleClassLoader.findClass(ModuleClassLoader.java:255)
      perseus-local | at org.jboss.modules.ConcurrentClassLoader.performLoadClassUnchecked(ConcurrentClassLoader.java:410)
      perseus-local | at org.jboss.modules.ConcurrentClassLoader.performLoadClass(ConcurrentClassLoader.java:398)
      perseus-local | at org.jboss.modules.ConcurrentClassLoader.loadClass(ConcurrentClassLoader.java:116)```

       

      Quartz module.xml:

      <?xml version="1.0" ?>
      <module xmlns="urn:jboss:module:1.1" name="org.quartz">
      <resources>
      <resource-root path="quartz-2.2.3.jar"/>
      <resource-root path="quartz-jobs-2.2.3.jar"/>
      </resources>
      <dependencies>
      <module name="org.slf4j"/>
      <module name="org.apache.log4j"/>
      <module name="javax.api"/>
      <module name="com.c3p0"/>
      <module name="oracle.jdbc"/>
      </dependencies>
      </module>

       

       

      oracle.jdbc module:

      <?xml version="1.0" ?>
      <module xmlns="urn:jboss:module:1.0" name="oracle.jdbc">
      <resources>
      <resource-root path="ojdbc8-12.2.0.1.jar"/>
      </resources>
      <dependencies>
      <module name="javax.api"/>
      <module name="javax.transaction.api"/>
      </dependencies>
      </module>

       

      Process is:

      CronProcess.bpmn

              mmacik@redhat.com Marian Macik
              teohaik Theodore Chaikalis (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Created:
                Updated:
                Resolved: