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

When filtering by variable in Cockpit, the query fails with ambiguous column name "PROC_DEF_ID_"

    XMLWordPrintable

Details

    Description

      Steps to reproduce

      1. Start Camunda (version 7.13.0)
      2. Open process definition history view in Cockpit
      3. Filter process instances by variable

      Expected behavior
      List of process instances is shown

      Observed behavior

      • Process engine persistence exception is thrown:
        Error querying database.  Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: Mehrdeutiger Feldname "PROC_DEF_ID_"
        Ambiguous column name "PROC_DEF_ID_"; SQL statement:
        select count(distinct RES.ID_ )   
            from
              ACT_HI_PROCINST RES
                LEFT JOIN ACT_HI_VARINST VI0
                ON RES.PROC_INST_ID_ = VI0.PROC_INST_ID_
               WHERE PROC_DEF_ID_ = ?
                  and (VI0.ID_ IS NOT NULL
                  AND  
                     VI0.NAME_= ?
         
                      and
                      (
                        (  VI0.VAR_TYPE_ = ?
                            and VI0.TEXT_
            =
                            ? )              )          ) [90059-200]
        The error may exist in org/camunda/bpm/cockpit/impl/plugin/history/historicProcessInstance.xml
        The error may involve cockpit.history.selectHistoricProcessInstancesCount
        

      Hint

      mgm-controller-panel

        This is the controller panel for Smart Panels app

        Attachments

          Activity

            People

              nikola.koevski Nikola Koevski
              michal.dytko Michał Dytko
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce