Bug 1278322
Summary: | JobExecutor: Creating Filter where ID equals_to a job_id results in error | ||||||||
---|---|---|---|---|---|---|---|---|---|
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: | etirelli | ||||||
Target Milestone: | CR1 | ||||||||
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:48:40 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: |
|
Created attachment 1089994 [details]
BPMS 6.2.0.ER5 server.log
There were a problem with the dataset condition marshaling that has been solved in 6.3.x https://github.com/droolsjbpm/jbpm-console-ng/commit/b9ee18604c21730050ad4af3048b00cc996c0c2c In master this json code marshaling is included in dashbuilders modules. BPMS 6.2.0.CR1 |
Created attachment 1089992 [details] Job search filter modal dialog Description of problem: When creating Job search filter where ID equals_to some job ID results in modal dialog: Can't lookup on specified data set: jbpmRequestList Version-Release number of selected component (if applicable): BPMS 6.2.0.ER5 How reproducible: Always Steps to Reproduce: 1. In Job perspective go and create Job filter 2. As a condition select ID equals_to <job_id> and hit Ok. Actual results: Modal dialog and an error in server.log Expected results: Filter created Additional info: 10:12:38,391 ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (http-localhost/127.0.0.1:8080-4) SELECT COUNT(*) FROM (SELECT ID, TIMESTAMP, STATUS, COMMANDNAME, MESSAGE, BUSINESSKEY FROM REQUESTINFO WHERE ID = 'true' ORDER BY TIMESTAMP ASC) "dbSQL" 10:12:38,392 ERROR [org.dashbuilder.dataset.backend.exception.ExceptionManager] (http-localhost/127.0.0.1:8080-4) Can't lookup on specified data set: jbpmRequestList: org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: jbpmRequestList ... Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting "true"; SQL statement: SELECT COUNT(*) FROM (SELECT ID, TIMESTAMP, STATUS, COMMANDNAME, MESSAGE, BUSINESSKEY FROM REQUESTINFO WHERE ID = 'true' ORDER BY TIMESTAMP ASC) "dbSQL" [22018-168]