Bug 1024233

For completeness: on other databases we are testing with it's working correctly - e.g. on Oracle 11g R2, PostgreSQL 9.2 and 8.4

Did you deploy the complete business central application on mysql, or just the jbpm dashboards part?

In all cases I deployed the whole BPMS product (business-central.war + dashbuilder.war), downloaded from here: http://dev138.mw.lab.eng.bos.redhat.com/candidate/bpms-6.0.0-ER4/

Also I'm sure, the configuration is correct (it's actually done by scripts to ensure test reproducibility), as other KPIs of dashbuilder are displaying the complete data correctly.

Don't worry, i was just asking because i'm encountering some difficulties in deploying the jbpm-dashboards war.
Did you have to apply any manual changes to deploy it (e.g. additional hibernate properties in the persistence.xml file), or do you create the business-central data model by script instead of automatically?
More specifically, i'm encountering that the "ProcessInstanceLog" (business-central) table is being referenced from one of the jbpm-dashb kpi's as "processinstancelog", which leads to an error when installing that kpi, since MySQL is case sensitive, so I'm curious as to how your environment manages to run correctly.

In our tests the BPMS product is configured by scripts. As far as I know the only configuration change we are doing via scripts to the BPMS product wars are:

1) in persistence.xml of business-central.war we specify hibernate dialect org.hibernate.dialect.MySQL5InnoDBDialect + reference to our own mysql datasource (declared in standalone.xml)

2) in jboss-deployment-structore of dashbuilder war we add reference to EAP module for Mysql 5.5 jdbc driver + in dashbuilder-jboss-web.xml we add reference to the same mysql datasource as in 1)

The database schema is then created automatically when business-central.war is deployed. Interestingly, I don't see any errors about table names anywhere in the logs / in application(s). Where do you see those errors, in server.log?
Did you try to reproduce the bug with BPMS 6.0.0 ER4 + EAP 6.1 (the setup is easy - you just need to unzip EAP + BPMS - see download link in comment 3)?

For your reference I attach server.log created by one of the test runs where this bugzilla issue manifested itself. You can see how the tables are created by business central + no errors for dashbuilder KPIs.

Created attachment 820389 [details]
server.log showing creation of processinstancelog

Fixed in the following commits:

master: https://github.com/droolsjbpm/jbpm-dashboard/commit/131c247

6.0.x: https://github.com/droolsjbpm/jbpm-dashboard/commit/e24c61b


In the end the origin of this problem was faulty configuration of the counter kpi, so it did not have any relation with the type of database. This is strange since you mentioned that on other databases it worked correctly. Please do recheck this specific point on the other supported databases to see if by fixing the configuration issue any other - possibly hidden - problem surfaces.

Thanx for the info you provided! - in the end my installation problems were due to network latency (took forever to complete DB access operations since I was working against a remote mysql installation); as soon as I switched to a local DB things went smoothly.

It appears the problem was only partly solved for the commits above, i.e. it only displays the correct result when default language is English. For the other languages the correction is include in the commits for another bugfix that also required re-exporting the jbpm workspace:

dashboard-builder: 
master: http://github.com/droolsjbpm/dashboard-builder/commit/15497aaea
6.0.x: http://github.com/droolsjbpm/dashboard-builder/commit/448a81808

jbpm-dashboard:
master: http://github.com/droolsjbpm/jbpm-dashboard/compare/c654f93...64cb161
6.0.x: http://github.com/droolsjbpm/jbpm-dashboard/compare/c593fb3...0293c06

Ok, problem has been fixed in BPMS 6.0.0 ER5