Created attachment 1097211 [details] Modal error in PI Description of problem: Creating Filter with PROCESSID equals_to $PROCESSID results in Modal Error in BC and SQL error in server log Version-Release number of selected component (if applicable): BPMS 6.2.0.CR1 How reproducible: Always Steps to Reproduce: 1. Go to process instances and create filter with PROCESSID equals_to $PROCESSID 2. 3. Actual results: Modal dialog error Expected results: Filter is created Additional info: 23:29:50,316 ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (http-localhost/127.0.0.1:8080-12) SELECT COUNT(*) FROM (SELECT * FROM (select pil.processInstanceId pid, pil.processId pname, v.id varid, v.variableId varname, v.value varvalue from ProcessInstancelog pil inner join (select vil.processInstanceId ,vil.variableId, MAX(vil.ID) maxvilid FROM VariableInstanceLog vil GROUP BY vil.processInstanceId, vil.variableId) x on (x.processInstanceId =pil.processInstanceId) INNER JOIN VariableInstanceLog v ON (v.variableId = x.variableId AND v.id = x.maxvilid )) AS `dbSQL`) AS `dbSQL` 23:29:50,316 ERROR [org.dashbuilder.dataset.backend.exception.ExceptionManager] (http-localhost/127.0.0.1:8080-12) Can't get metadata on specified data set: jbpmProcessInstancesWithVariables: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmProcessInstancesWithVariables
Created attachment 1097215 [details] Server log
the query has been changed considering the case sensitive treatment of the table names. The commits: 6.3.x https://github.com/droolsjbpm/jbpm-console-ng/commit/0280ce86ad40d825716b73f9e40ea101b3af5dcc master: https://github.com/droolsjbpm/jbpm-console-ng/commit/e761b33bb355f74089de65f005e5a07ff75d0b8e
And master: https://github.com/droolsjbpm/kie-wb-distributions/commit/fad213655531be7964dbf35ab701df8739b94e32 6.3.x: https://github.com/droolsjbpm/kie-wb-distributions/commit/bd437e6b9fcb92430bb24a46e644dc761eaef278
BPMS 6.2.0.CR2