Indeed. The solution is to set the property "generate_statistics" to false. Github commit (master): https://github.com/droolsjbpm/dashboard-builder/commit/f83ee1e3f5cb04814b16a7a033c4efe49af5d0cd
Cherry picked into 6.0.x https://github.com/droolsjbpm/dashboard-builder/commit/ad42a6436f510e353b1efbec4f5d4d12d821b7d5
Packed into rollup patch now which is in http://dev138.mw.lab.eng.bos.redhat.com/patches/BPMS_6.0.3_1_2014/.
I cloned and verified this bug for BPMS 6.0.3 rollup. The current bugzilla still needs to be verified against BPMS 6.1.0 build - changing to modified.
While struggling with bug 1163015 we found out, that there are 2 versions of hibernate.cfg.xml: 1) for generic dashbuilder (https://github.com/droolsjbpm/dashboard-builder/blob/master/modules/dashboard-webapp/src/main/webapp/WEB-INF/etc/hibernate.cfg.xml), which ends up in the distribution for EAP (jboss-bpmsuite-6.1.0.ER1-deployable-eap6.x.zip) 2) for jbpm-dashboard (https://github.com/droolsjbpm/jbpm-dashboard/blob/master/jbpm-dashboard-distributions/src/main/tomcat7/WEB-INF/etc/hibernate.cfg.xml) which ends up in the distribution for tomcat (jboss-bpmsuite-6.1.0.ER1-deployable-generic.zip) In 1 the generate_statistics is set to false, while in 2 it's set to false. Please set it to false in both places, so that we keep the configuration in sync.
Yes, right. This is also related https://bugzilla.redhat.com/show_bug.cgi?id=1163029 I think that this issue Jan report will be fixed if we fix the BZ 1163029.
Fixed. No need for having a different data source name on Tomcat. The tomcat's specific hibernate.cfg.xml has been removed and the data source name has been changed to "jdbc/dashbuilder" in order to be consistent with all the other assemblies. Github commit (master): https://github.com/droolsjbpm/jbpm-dashboard/commit/8076f9f0c487e9dd556e639ecd2e6bfea66a0a0a Github commit (6.2.x): https://github.com/droolsjbpm/jbpm-dashboard/commit/15b87252b62109dde5bd932217b3d7cf6e252df6
Ok, verified with BPM Suite 6.1 ER3