Created attachment 816125 [details] Error in KPI panel Description of problem: When you use Oracle 11g R2 as underlying datasource and in business central you navigate to built-in jBPM Dashboard, the KPIs containing date-based data are not displayed. Instead these panels have error dislayed "An unexpected error occured which has generated the follogin error log" (se screenshot attached). The following KPIs are concerned: -process completed / initiated by date -tasks completed / started by date The underlying exception in all these cases is same: java.lang.ClassCastException: oracle.sql.TIMESTAMP cannot be cast to java.lang.Comparable Version-Release number of selected component (if applicable): BPMS 6.0.0 ER4 Oracle 11g R2 Firefox 17 How reproducible: Always Steps to Reproduce: 1. Deploy BPMS (business-central + jbpm-dashboard webapps) on EAP 6.1 with Oracle 11g R2 as an underlying datasource 2. start some processes to fill in underlying datasource with some process/task data 3. go to jbpm dashboard and check KPIs mentioned above Actual results: Error is displayed as mentioned above Expected results: KPIs should be displayed correctly
Created attachment 816127 [details] Server log with UNEXPECTED ERROR
Fixed. TIMESTAMP columns in Oracle are fetched as instances of the class oracle.sql.TIMESTAMP. This class is not suitable for dashbuilder as it does not implement java.lang.Comparable. We have added a transformation method to get the real java.util.Date instance instead of the proprietary one. Github commit (master): https://github.com/droolsjbpm/dashboard-builder/commit/92516607a56b4cf1802d230b7a21d8a3d630bd3a Github commit (6.0.x): https://github.com/droolsjbpm/dashboard-builder/commit/babec2e156a387e4ef5a801e3341c044e40dcd76
This issue can't be verified with BPMS 6.0.0 ER5, because it is blocked by BZ 1035114. We are currently unable to deploy dashbuilder on oracle11gR2 to test it.
Ok, verified with BPMS 6.0.0 ER6 deployed on EAP 6.1.1