Bug 1023434 - KPIs with dates not displaying on Oracle DB
Summary: KPIs with dates not displaying on Oracle DB
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: BAM
Version: 6.0.0
Hardware: Unspecified
OS: Unspecified
high
medium
Target Milestone: ER5
: 6.0.0
Assignee: David Gutierrez
QA Contact: Jan Hrcek
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2013-10-25 12:04 UTC by Jan Hrcek
Modified: 2014-08-06 20:07 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-08-06 20:07:15 UTC
Type: Bug
Embargoed:


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

Description Jan Hrcek 2013-10-25 12:04:11 UTC
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

Comment 1 Jan Hrcek 2013-10-25 12:05:44 UTC
Created attachment 816127 [details]
Server log with UNEXPECTED ERROR

Comment 2 David Gutierrez 2013-11-06 10:38:57 UTC
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 13:41:49 UTC
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 07:03:43 UTC
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.