Hi all,
I am trying to notify a process instance waiting for an intermediate catch event.
As explained in docs, messge correlation is constructed as below.
MessageCorrelationResult messageCorrelationResult = runtimeService.createMessageCorrelation(“proposalsGatheredMessage”).processInstanceId(processId).correlateWithResult();
However, at run time I keep getting below exception (please see ‘order by’ statements)
Can you help me to figure out what is wrong?
Thanks in advance
Ali
### The error may exist in org/camunda/bpm/engine/impl/mapping/entity/Execution.xml
### The error may involve org.camunda.bpm.engine.impl.persistence.entity.ExecutionEntity.selectExecutionsByQueryCriteria-Inline
### The error occurred while setting parameters
### SQL: select distinct RES.* from ACT_RU_EXECUTION RES inner join ACT_RE_PROCDEF P on RES.PROC_DEF_ID_ = P.ID_ WHERE RES.PROC_INST_ID_ = ? and RES.SUSPENSION_STATE_ = ? and exists (select ID_ from ACT_RU_EVENT_SUBSCR EVT where EVT.EXECUTION_ID_ = RES.ID_ and EVT.EVENT_TYPE_ = ? and EVT.EVENT_NAME_ = ? ) order by order by RES.ID_ asc LIMIT ? OFFSET ?
### Cause: org.postgresql.util.PSQLException: ERROR: syntax error at or near "order"
Position: 538
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141)
at org.camunda.bpm.engine.impl.db.sql.DbSqlSession.selectList(DbSqlSession.java:87)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectListWithRawParameter(DbEntityManager.java:166)
at org.camunda.bpm.engine.impl.db.entitymanager.DbEntityManager.selectList(DbEntityManager.java:158)