Created attachment 1084585 [details] server.log with exceptions (search for DataSetLookupException) Description of problem: When entering Jobs perspective in business-central deployed with Oracle12c, there's modal with DataSetLookup exception. server.log (attached) contains the corresponding: ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (http-localhost/127.0.0.1:8080-36) SELECT COUNT(*) FROM (SELECT ID, TIMESTAMP, STATUS, COMMANDNAME, MESSAGE, BUSINESSKEY FROM REQUESTINFO WHERE TIMESTAMP = '2015-10-20 23:00:00' ORDER BY TIMESTAMP ASC) "dbSQL" ... Caused by: java.sql.SQLDataException: ORA-01843: not a valid month ------------- It seems as if the database is interpreting the '20' in the date string as month, but in fact it's a day (test running on 20th October 2015). Version-Release number of selected component (if applicable): BPM Suite 6.2.0 ER4 + Oracle 12c as a datasource How reproducible: Always on dates when day number is >=13 :-) Steps to Reproduce: 1. Deploy business central with Oracle 12c as a datasource 2. Navigate to jobs perspective Actual results: Modal with DataSetLookupException is opened, exception in server.log Expected results: No errors on entering the perspective Additional info:
BPMS 6.2.0.ER4 with the Oracle 12c datasource is experiencing this error too in server log: 15:49:10,540 ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (http-/127.0.0.1:8080-13) 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: java.sql.SQLSyntaxErrorException: ORA-00907: missing right parenthesis
Sorry, missed some steps to reproduce. 3) After entering jobs perspective, create new filter tab using TIMESTAMP column, operator 'equals' and let the datepicker pick current date. In the case of failing test this was: '2015-10-20 23:00:00'
BPMS 6.2.0.ER4/EAP 6.4 with the postgresql93 datasource is affected: 05:29:54,105 ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (http-localhost/127.0.0.1:8080-18) SELECT COUNT(*) FROM (SELECT ID, TIMESTAMP, STATUS, COMMANDNAME, MESSAGE, BUSINESSKEY FROM REQUESTINFO WHERE TIMESTAMP = '2015-10-21 23:00:00' ORDER BY TIMESTAMP ASC) "dbSQL" 05:29:54,109 ERROR [org.dashbuilder.dataset.backend.exception.ExceptionManager] (http-localhost/127.0.0.1:8080-18) 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.SQLDataException: ORA-01843: not a valid month
The error commented in https://bugzilla.redhat.com/show_bug.cgi?id=1273259#c1 is a different one, and has been already fixed => https://bugzilla.redhat.com/show_bug.cgi?id=1273362 As for the TIMESTAMP related error it's been reported in community: https://issues.jboss.org/browse/DASHBUILDE-58 A fix has been submitted for approval. (master) https://github.com/dashbuilder/dashbuilder/pull/55 (0.3.x) https://github.com/dashbuilder/dashbuilder/pull/56 They will be merge today by EOD.
Done. (master) https://github.com/dashbuilder/dashbuilder/commit/36c07333d4b1ea66f5a2f50a202768abb0003c54 (0.3.x) https://github.com/dashbuilder/dashbuilder/commit/3425a60eb3375c02356924ff19f8e5aaeeab9b62
Verification blocked by bug # 1277466 Will be verified with the next build after that bug is fixed.
Ok, verified with BPM Suite 6.2.0 CR1