Hi , getting below error in camunda-ui (image attached)
camunda/api/engine/engine/default/history/process-instance?maxResults=1000
Request Method:
POST
Status Code:
500 Internal Server Error
error in spring console :
Caused by: org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.sql.SQLSyntaxErrorException: Duplicate column name ‘NAME_’
The error may exist in org/camunda/bpm/engine/impl/mapping/entity/HistoricProcessInstance.xml
The error may involve org.camunda.bpm.engine.impl.persistence.entity.HistoricProcessInstanceEntity.selectHistoricProcessInstancesByQueryCriteria-Inline
The error occurred while setting parameters
SQL: select distinct RES.* from ( SELECT SELF.*, DEF.NAME_, DEF.VERSION_, DEF.DEPLOYMENT_ID_ FROM ACT_HI_PROCINST SELF LEFT JOIN ACT_RE_PROCDEF DEF ON SELF.PROC_DEF_ID_ = DEF.ID_ WHERE ( 1 = 1 ) ) RES order by RES.ID_ asc LIMIT ? OFFSET ?
Cause: java.sql.SQLSyntaxErrorException: Duplicate column name ‘NAME_’
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)