Bug 1023434 - KPIs with dates not displaying on Oracle DB
KPIs with dates not displaying on Oracle DB
Product: JBoss BPMS Platform 6
Classification: JBoss
Component: BAM (Show other bugs)
Unspecified Unspecified
high Severity medium
: ER5
: 6.0.0
Assigned To: David Gutierrez
Jan Hrcek
Depends On:
  Show dependency treegraph
Reported: 2013-10-25 08:04 EDT by Jan Hrcek
Modified: 2014-08-06 16:07 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2014-08-06 16:07:15 EDT
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)
Error in KPI panel (114.21 KB, image/png)
2013-10-25 08:04 EDT, Jan Hrcek
no flags Details
Server log with UNEXPECTED ERROR (764.48 KB, text/x-log)
2013-10-25 08:05 EDT, Jan Hrcek
no flags Details

  None (edit)
Description Jan Hrcek 2013-10-25 08:04:11 EDT
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:

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
Comment 1 Jan Hrcek 2013-10-25 08:05:44 EDT
Created attachment 816127 [details]
Server log with UNEXPECTED ERROR
Comment 2 David Gutierrez 2013-11-06 05:38:57 EST
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
Comment 3 Jan Hrcek 2013-11-29 08:41:49 EST
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.
Comment 4 Jan Hrcek 2013-12-23 02:03:43 EST
Ok, verified with BPMS 6.0.0 ER6 deployed on EAP 6.1.1

Note You need to log in before you can comment on or make changes to this bug.