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

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

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Critical
    • Resolution: Done
    • Affects Version/s: 7.15.0.Final
    • Fix Version/s: 7.44.0.Final
    • Component/s: KieServer
    • Labels:
      None

      Description

      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

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                mmacik Marian Macik
                Reporter:
                teohaik Theodore Chaikalis
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: