Bug 1268219
| Summary: | MySQL case sensitive table names - task list view error | ||
|---|---|---|---|
| Product: | [Retired] JBoss BPMS Platform 6 | Reporter: | Artisan <dicta.artisan> |
| Component: | BAM | Assignee: | David Gutierrez <dgutierr> |
| Status: | CLOSED EOL | QA Contact: | Gui Jospin <gjospin> |
| Severity: | unspecified | Docs Contact: | |
| Priority: | urgent | ||
| Version: | 6.2.0 | CC: | dicta.artisan, kverlaen, nmirasch |
| Target Milestone: | CR1 | ||
| Target Release: | 6.2.0 | ||
| Hardware: | Unspecified | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2020-03-27 20:12:56 UTC | Type: | Bug |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
*** Bug 1270154 has been marked as a duplicate of this bug. *** Fixed the queries in commit: 6.3.x https://github.com/droolsjbpm/kie-wb-distributions/commit/08f2b571adc2b31597c436cde48e3bc3f1c673c6 Verification blocked by bug # 1277466 Will be verified with the next build after that bug is fixed. Checked with MySQL 5.7 (column case sensitivity turned on) and it's working fine now. Verified with BPM Suite 6.2.0 CR1 Employee 'msalatin' has left the company. |
Description of problem: When using jBPM with a MySQL back-end on Linux the task list page returns errors. In MySQL table names on Linux are case-sensitive and the queries from the workbench when displaying the task list are case-insensitive. See stack traces below. Version-Release number of selected component (if applicable): jBPM 6.3.0.Final MySQL 5.5 back-end on Ubuntu 12.04 with default configuration How reproducible: Steps to Reproduce: 1. Configure jBPM demo installation with a MySQL back-end according to install guide 2. Create/upload a process, start some instances 3. When accessing the task list in the workbench an error pops up: DataSet with UUID [ jbpmHumanTasks ] error: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmHumanTasksWithUser Server stack trace: 2015-10-01 19:21:53,508 ERROR [org.dashbuilder.dataprovider.backend.sql.JDBCUtils] (default task-70) 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.p rocessid, 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` 2015-10-01 19:21:53,521 ERROR [org.dashbuilder.dataset.backend.exception.ExceptionManager] (default task-70) Can't get metadata on specified data set: jbpmHumanTasksWithUser: org.dashbuilder.dataset.exception.DataSetLookupException: Can't get metadata on specified data set: jbpmHum anTasksWithUser at org.dashbuilder.dataset.backend.BackendDataSetManager.getDataSetMetadata(BackendDataSetManager.java:156) [dashbuilder-dataset-core-0.3.3.Final.jar:0.3.3.Final] at org.dashbuilder.dataset.backend.BackendDataSetManager$Proxy$_$$_WeldClientProxy.getDataSetMetadata(Unknown Source) [dashbuilder-dataset-core-0.3.3.Final.jar:0.3.3.Final] at org.dashbuilder.dataset.backend.DataSetLookupServicesImpl.lookupDataSetMetadata(DataSetLookupServicesImpl.java:98) [dashbuilder-services-0.3.3.Final.jar:0.3.3.Final] at org.dashbuilder.dataset.backend.DataSetLookupServicesImpl$Proxy$_$$_WeldClientProxy.lookupDataSetMetadata(Unknown Source) [dashbuilder-services-0.3.3.Final.jar:0.3.3.Final] at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source) [:1.7.0_79] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_79] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_79] ......... ......... Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jbpm_dev.peopleassignments_potowners' doesn't exist at sun.reflect.GeneratedConstructorAccessor195.newInstance(Unknown Source) [:1.7.0_79] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_79] at java.lang.reflect.Constructor.newInstance(Constructor.java:526) [rt.jar:1.7.0_79] at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) [mysql-connector-java-5.1.18.jar:] Additional info: This is very similar to bug 1213906