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
Steps to Reproduce:
1. Start an instance of any process (e.g. Evaluation) in Process Definitions
2. Navigate to Process Instances perps.
Modal with error displaed + exception in server.log
Process Instance displayed
*** 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
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.
Fixed for all supported DB's.