Description of problem: If you check following jBPM KPI queries: https://github.com/droolsjbpm/jbpm-dashboard/blob/6.2.x/jbpm-dashboard-modules/jbpm-dashboard-webapp/src/main/webapp/WEB-INF/deployments/jbpmKPIs_v2.kpis which we ship out of the box, you'll notice they are all written in lower case. However, our DB table names - if created by DDL scripts or even via hibernate schema update feature - are written in camelCase. i.e. there is no processinstancelog table, but only ProcessInstanceLog Make sure this is aligned in the future releases. The problem particularly manifested for MySQL 5.5 database. Following property is to be configured when table names case sensitivity behavior needs to be altered https://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html Here are the default values: "On Unix, the default value of lower_case_table_names is 0. On Windows the default value is 1. On OS X, the default value is 2. " As you can see, if somebody is hosting MySQL DB on a Unix-like server, the default value is 0 - i.e. case sensitive. So, if customer installs BPMS and uses the default MySQL setting following exception will occur: http://pastebin.com/RfwSzx3a To workaround this issue you need to change this value to 1. This shouldn't be necessary. Version-Release number of selected component (if applicable): 6.1.0 How reproducible: always Steps to Reproduce: 1. Start BPMS with dashbuilder configured with MySQL DB on unix-like system and make sure MySQL is using the default value of lower_case_table_names property, which on unix systems is equal to 0. Actual results: Exceptions in the log complaining that table can't be found - queries are in lowercase and table names are in camelCase. Expected results: No exceptions Additional info:
This can be considered a duplicate of: https://bugzilla.redhat.com/show_bug.cgi?id=1231014 Since the root cause are the same in both cases. *** This bug has been marked as a duplicate of bug 1231014 ***