Created attachment 1088955 [details] server.log with exception Description of problem: When you start an instance of some process (e.g. Evaluation) and then navigate to Process Instances perspective, there is a modal with error shown & the following exception in server.log (attached): org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: jbpmProcessInstances ... Caused by: org.h2.jdbc.JdbcSQLException: Data conversion error converting "false"; SQL statement: SELECT COUNT(*) FROM (SELECT PROCESSINSTANCEID, PROCESSID, START_DATE, END_DATE, STATUS, PARENTPROCESSINSTANCEID, OUTCOME, DURATION, USER_IDENTITY, PROCESSVERSION, PROCESSNAME, CORRELATIONKEY, EXTERNALID, PROCESSINSTANCEDESCRIPTION FROM PROCESSINSTANCELOG WHERE STATUS = 'false' ORDER BY START_DATE ASC) "dbSQL" [22018-168] ... Caused by: Caused by: java.lang.NumberFormatException: For input string: "false" Version-Release number of selected component (if applicable): BPM Sute 6.2.0 ER5 How reproducible: Always Steps to Reproduce: 1. Start an instance of any process (e.g. Evaluation) in Process Definitions 2. Navigate to Process Instances perps. Actual results: Modal with error displaed + exception in server.log Expected results: Process Instance displayed Additional info:
*** Bug 1277545 has been marked as a duplicate of this bug. ***
This bug affects BPMS running with following DB: db2-101, oracle11gR2, oracle11gR2RAC, oracle12c, postgresql92, sybase157.
Created attachment 1089542 [details] sybase157 server log
Created attachment 1089543 [details] postgresql92 server log
Created attachment 1089544 [details] oracle12c server log
Created attachment 1089545 [details] oracle11gR2RAC server log
Created attachment 1089546 [details] oracle11gR2 server log
Created attachment 1089547 [details] db2-101 server log
Please, check this SQL error too. Experienced in BPMS with oracle11gR2RAC as a datasource. 17:56:21,829 ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (http-localhost/127.0.0.1:8080-11) SELECT COUNT(*) FROM (SELECT ID, TIMESTAMP, STATUS, COMMANDNAME, MESSAGE, BUSINESSKEY FROM REQUESTINFO WHERE ID = 'true' ORDER BY TIMESTAMP ASC) "dbSQL" 17:56:21,829 ERROR [org.dashbuilder.dataset.backend.exception.ExceptionManager] (http-localhost/127.0.0.1:8080-11) Can't lookup on specified data set: jbpmRequestList: org.dashbuilder.dataset.exception.DataSetLookupException: Can't lookup on specified data set: jbpmRequestList ... Caused by: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
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.
The original issue reported (with H2 db) has been fixed. Transferring to Pavel to verify that there are no issues with this on other databases.
BPMS 6.2.0.CR1 Fixed for all supported DB's.