Red Hat Bugzilla – Bug 999936
KPI preview disappears when editting KPI based on data from custom database
Last modified: 2014-08-06 16:09:46 EDT
Created attachment 789164 [details]
Video of reproducing steps
Description of problem:
When editting KPI, which is using NVD3 as a chart renderer, the preview disappears and is not shown in the KPI editor window.
Version-Release number of selected0 component (if applicable):
BPMS 6.0.0.ER1, deployed on EAP 6.1.0
Steps to Reproduce:
Please see video of reproducing steps. For the test I use local file-based h2 database (attached) with username/password test
0. login using root user (please ignore the login screen - already reported issue with branding)
1. Configure External custom connection (JDBC based) using attached h2 database test.h2.db
2. Configure data provider based on this datasource (using "Select * from person;" as query
3. Add KPI panel to the page and configure it to use data provider from step 2
When you select different Domain / range (x/y axis - see 1:40 in the video) the KPI preview disappears and doesn't appear until you close the window.
The KPI preview should be displayed all the time when editting the KPI.
The database is created using the following DDL:
CREATE USER test PASSWORD 'test';
CREATE TABLE IF NOT EXISTS PERSON (ID INT PRIMARY KEY, NAME VARCHAR(30), AGE INT);
GRANT ALL ON PERSON TO test;
INSERT INTO PERSON (ID, NAME, AGE) VALUES (1, 'John Doe', 25);
INSERT INTO PERSON (ID, NAME, AGE) VALUES (2, 'Jane Doe', 20);
INSERT INTO PERSON (ID, NAME, AGE) VALUES (3, 'James Bond', 35);
INSERT INTO PERSON (ID, NAME, AGE) VALUES (4, 'Jim Blonde', 10);
INSERT INTO PERSON (ID, NAME, AGE) VALUES (5, 'Ludvig van Wokurka', 50);
Created attachment 789166 [details]
Custom test database
Test database used as data source to reproduce the issue.
Use the following to configure it in application:
URL: jdbc:h2:~/test (provided it is saved in your home dir)
I have tried this in both jboss-as 7.1.1 and jboss eap 6.1.1.GA, and have not been able to reproduce it.
I checked with BPMS ER3 - the issue is still present. It seems that this problem is firefox-specific. On Google chrome it works correctly. Could you please try to reproduce it using Firefox v17 (extended support version of firefox - required by PRD)?
Indeed, this is a Firefox specific issue. I was able to reproduce it and has been fixed.
Github commit (master): https://github.com/droolsjbpm/dashboard-
Github commit (6.0.x): https://github.com/droolsjbpm/dashboard-builder/commit/b15a33366b7a5a9fcb3b13db67d14f1c94c36bd1
Ok, now it works correctly even in firefox. Verified with BPMS 6.0.0 ER5.