L3 - Default Steps to reproduce
- Start Camunda (version 7.13.0)
- Open process definition history view in Cockpit
- 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
- Column PROC_DEF_ID_ is present in both tables ACT_HI_PROCINST and ACT_HI_VARINST.
- The prefix pointing to the correct table is missing in the SQL query, see https://github.com/camunda/camunda-bpm-platform-ee/blob/7.13.0/webapps/camunda-webapp/plugins/src/main/resources/org/camunda/bpm/cockpit/impl/plugin/history/historicProcessInstance.xml#L98-L100
