Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-6580

I want to query process instances by start time on DB2 with history level none on DB2

XMLWordPrintable

      Right now we are getting exceptions on DB2 if history level none is set and query of process instances with ordering by start time is performed.
      to reproduce run org.camunda.bpm.cockpit.plugin.base.ProcessInstanceRestServiceTest#testQueryOrderByStartTime with profile cfghistorynone,db2,db2-105

      Hint
      statement 

      <if test="!historyEnabled">
        null START_TIME_
</if>

      in org/camunda/bpm/cockpit/plugin/base/queries/processInstance.xml
      looks very strange.

      Possible solution
      http://stackoverflow.com/questions/2509233/db2-wont-allow-null-column
      customization of null column is done through org.camunda.bpm.engine.impl.db.sql.DbSqlSessionFactory

        This is the controller panel for Smart Panels app

            [CAM-6580] I want to query process instances by start time on DB2 with history level none on DB2

            Sebastian Menski added a comment -

            The test case breaks 7.3 and 7.4 release as RequiredHistoryLevel is not available on these branches. See:

            https://ci.camunda.com/jenkins/release/job/7.3/job/7.3-TEST-RELEASE-camunda-bpm/133/console
            https://ci.camunda.com/jenkins/release/job/7.4/job/7.4-TEST-RELEASE-camunda-bpm/143/console

            Sebastian Menski added a comment - The test case breaks 7.3 and 7.4 release as RequiredHistoryLevel is not available on these branches. See: https://ci.camunda.com/jenkins/release/job/7.3/job/7.3-TEST-RELEASE-camunda-bpm/133/console https://ci.camunda.com/jenkins/release/job/7.4/job/7.4-TEST-RELEASE-camunda-bpm/143/console

              michael.schoettes Michael Schoettes
              askar.akhmerov Askar
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: