Created attachment 1084658 [details] db2-10 server log Description of problem: BPMS 6.2.0.ER4 server with db2-105 datasource is experiencing DataSetLookupException in server.log. server.log: 15:51:06,281 ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (http-/127.0.0.1:8080-6) SELECT COUNT(*) FROM (SELECT * FROM (SELECT PIL.PROCESSINSTANCEID PID, PIL.PROCESSID PNAME, V.ID VARID, V.VARIABLEID VARNAME, V.VALUE VARVALUE FROM PROCESSINSTANCELOG PIL, (SELECT VIL.VARIABLEID, MAX(VIL.ID) AS MAXVILID FROM VARIABLEINSTANCELOG VIL GROUP BY VIL.PROCESSINSTANCEID, VIL.VARIABLEID) AS X INNER JOIN VARIABLEINSTANCELOG AS V ON V.VARIABLEID = X.VARIABLEID AND V.PROCESSINSTANCEID = PIL.PROCESSINSTANCEID AND V.ID = X.MAXVILID) "dbSQL") "dbSQL" ... Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-338, SQLSTATE=42972, SQLERRMC=null, DRIVER=4.17.29 Version-Release number of selected component (if applicable): BPMS 6.2.0.ER4 How reproducible: Always Steps to Reproduce: 1. Deploy business central with db2-105 datasource 2. Navigate to Process Instances Actual results: DataSetLookupException exception Expected results: No errors Additional info:
BPMS 6.2.0.ER4/EAP 6.4 server with db2-97 datasource server.log: 15:27:23,840 ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (http-localhost/127.0.0.1:8080-19) SELECT COUNT(*) FROM (SELECT * FROM (SELECT PIL.PROCESSINSTANCEID PID, PIL.PROCESSID PNAME, V.ID VARID, V.VARIABLEID VARNAME, V.VALUE VARVALUE FROM PROCESSINSTANCELOG PIL, (SELECT VIL.VARIABLEID, MAX(VIL.ID) AS MAXVILID FROM VARIABLEINSTANCELOG VIL GROUP BY VIL.PROCESSINSTANCEID, VIL.VARIABLEID) AS X INNER JOIN VARIABLEINSTANCELOG AS V ON V.VARIABLEID = X.VARIABLEID AND V.PROCESSINSTANCEID = PIL.PROCESSINSTANCEID AND V.ID = X.MAXVILID) "dbSQL") "dbSQL" 15:27:23,842 ERROR [org.dashbuilder.dataset.backend.exception.ExceptionManager] (http-localhost/127.0.0.1:8080-19) Can't get metadata on specified data set: jbpmProcessInstancesWithVariables: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmProcessInstancesWithVariables ... Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-338, SQLSTATE=42972, SQLERRMC=null, DRIVER=4.14.137
Created attachment 1084801 [details] db2-97 server log
It was related with the query to show the domain variables associated with a process instance. The query has been modified to run in the different db. The commits: 6.3.x https://github.com/droolsjbpm/kie-wb-distributions/commit/0a2905503d021d104665f2877d497a02b7cfc81a Master https://github.com/droolsjbpm/kie-wb-distributions/commit/e01ee86dd1e12aa1f736d6c36e65d31b21148017
BPMS 6.2.0.ER5