Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1055451

Summary: NullPointerExceptions when loading the BAM dashboard
Product: [Retired] JBoss BPMS Platform 6 Reporter: David Gutierrez <dgutierr>
Component: BAMAssignee: Walter Medvedeo <wmedvede>
Status: CLOSED CURRENTRELEASE QA Contact: Jan Hrcek <jhrcek>
Severity: high Docs Contact:
Priority: high    
Version: 6.0.0CC: kverlaen, mbaluch, pzapataf
Target Milestone: ER2   
Target Release: 6.0.1   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-08-06 20:01:59 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
server.log
none
server.log showing the exception
none
Steps to reproduce - video none

Description David Gutierrez 2014-01-20 09:55:29 UTC
Created attachment 852669 [details]
server.log

Consider the following scenario:

.- A data provider which returns a data set containing null values. A database table containing null is some rows. 

.- A dashboard containing a KPI built on top of that data provider.

When we're trying to display the dashboard  the system throws a NullPointerException (see the server.log file attached).

Comment 2 David Gutierrez 2014-01-21 10:41:42 UTC
Fixed. 

Github commit (master): https://github.com/droolsjbpm/dashboard-
builder/commit/57bfd4fac4ddbe4c498299f28ec0bda0ef89c03a

Github commit (6.0.x): https://github.com/droolsjbpm/dashboard-builder/commit/6b55ea179beba8422776bb2915fe7f3cc66ac261

Comment 3 Jan Hrcek 2014-02-17 13:32:58 UTC
It seems to me that this will need some more review. I created simple H2 database using the following DDL:

DROP TABLE IF EXISTS TEST;
CREATE TABLE TEST(ID INT PRIMARY KEY, NAME VARCHAR(255));
INSERT INTO TEST VALUES(1, 'Hello');
INSERT INTO TEST VALUES(2, null);
INSERT INTO TEST VALUES(3, 'World');
INSERT INTO TEST VALUES(4, null);


Then configured the data source as shown in the video. When editting the KPI based on SQL provider querying that db I'm still getting NullPointerException (alas, with the different stact trace).

I attach video with steps to reproduce + server.log

Comment 4 Jan Hrcek 2014-02-17 13:33:22 UTC
Created attachment 864090 [details]
server.log showing the exception

Comment 5 Jan Hrcek 2014-02-17 13:35:52 UTC
Created attachment 864091 [details]
Steps to reproduce - video

Comment 6 Walter Medvedeo 2014-02-19 10:18:57 UTC
The following commits solves the issue

master URL: http://github.com/droolsjbpm/dashboard-builder/commit/6c22a9ab9

6.0.x URL: http://github.com/droolsjbpm/dashboard-builder/commit/bf0f15da2

Comment 7 Jan Hrcek 2014-03-06 09:32:07 UTC
Ok, verified with BPMS 6.0.1 ER2