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

selectActivityStatistics Query broken on Mssql & Postgres

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Closed
    • Priority: L3 - Default
    • Resolution: Fixed
    • Affects Version/s: 7.0.0-alpha1
    • Fix Version/s: 7.0.0-alpha2, 7.0.0
    • Component/s: engine
    • Labels:
      None

      Description

          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

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: