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

selectActivityStatistics Query broken on Mssql & Postgres

XMLWordPrintable

    • Icon: Bug Report Bug Report
    • Resolution: Fixed
    • Icon: L3 - Default L3 - Default
    • 7.0.0-alpha2, 7.0.0
    • 7.0.0-alpha1
    • engine
    • None

          1. The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Statistics.xml
          2. The error may involve org.camunda.bpm.engine.impl.persistence.entity.ProcessDefinitionStatisticsEntity.selectActivityStatistics-Inline
          3. The error occurred while setting parameters
          4. SQL: select RES.* from ( select INSTANCE.ACT_ID_ as ID_, INSTANCE_COUNT from (select ACT_ID_, count(PROC_INST_ID_) as INSTANCE_COUNT from ACT_RU_EXECUTION where PROC_DEF_ID_ = ? and IS_ACTIVE_ = 1 group by ACT_ID_) INSTANCE ) RES order by RES.ID_ asc LIMIT ? OFFSET ?
          5. Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: boolean = integer

      https://groups.google.com/forum/?fromgroups=#!topic/camunda-bpm-users/ktDqArKSC5c

        This is the controller panel for Smart Panels app

              Unassigned Unassigned
              meyer Daniel Meyer
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: