Created attachment 1081196 [details]
server.log with exceptions

Description of problem:
This is related to bug #1268219.

There are DatasetLookupExceptions when entering task list. server.log is full of error like these:

SELECT COUNT(*) FROM (SELECT * FROM (select  t.activationtime, t.actualowner, t.createdby, t.createdon, t.deploymentid, t.description, t.duedate, t.name, t.parentid, t.priority, t.processid, t.processinstanceid, t.processsessionid, t.status, t.taskid, t.workitemid, oe.id oeid from AuditTaskImpl t, peopleassignments_potowners po, organizationalentity oe where t.id = po.task_id and po.entity_id = oe.id) AS `dbSQL`) AS `dbSQL`
10:47:01,961 ERROR [org.dashbuilder.dataset.backend.exception.ExceptionManager] (http-/127.0.0.1:8080-2) Can't get metadata on specified data set: jbpmHumanTasksWithUser: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmHumanTasksWithUser


Version-Release number of selected component (if applicable):
BPM Suite 6.2.0 ER3

How reproducible:
Always

Steps to Reproduce:
1. Deploy business-central with MySQL 5.7 as datasource
2. Navigate to task list, try creating an adhoc task.

Actual results:
Column names are case sensitive by default on mysql -> dataset lookup exceptions in task list. 

Expected results:
No exceptions. I think it would be best if the dataset queries contained the same case as the hibernate creates them by default. In this way case insensitive databases would still work + case sensitive would be happy too. What do you think?

Additional info: