Bug 1273341
| Summary: | db2-10: DataSetLookupException on Process Instances Perspective | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | [Retired] JBoss BPMS Platform 6 | Reporter: | Pavel Kralik <pkralik> | ||||||
| Component: | Business Central | Assignee: | Neus Miras <nmirasch> | ||||||
| Status: | CLOSED EOL | QA Contact: | Lukáš Petrovický <lpetrovi> | ||||||
| Severity: | urgent | Docs Contact: | |||||||
| Priority: | urgent | ||||||||
| Version: | 6.2.0 | CC: | kverlaen | ||||||
| Target Milestone: | ER5 | ||||||||
| Target Release: | 6.2.0 | ||||||||
| Hardware: | x86_64 | ||||||||
| OS: | Linux | ||||||||
| Whiteboard: | |||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||
| Doc Text: | Story Points: | --- | |||||||
| Clone Of: | Environment: | ||||||||
| Last Closed: | 2020-03-27 19:34:20 UTC | Type: | Bug | ||||||
| Regression: | --- | Mount Type: | --- | ||||||
| Documentation: | --- | CRM: | |||||||
| Verified Versions: | Category: | --- | |||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||
| Embargoed: | |||||||||
| Attachments: |
|
||||||||
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 |
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: