Bug 1272981
Summary: | SQLGrammarException when executing task query operations on various DBs | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Product: | [Retired] JBoss BPMS Platform 6 | Reporter: | Tomas Livora <tlivora> | ||||||||||
Component: | Business Central | Assignee: | Shelly McGowan <smcgowan> | ||||||||||
Status: | CLOSED EOL | QA Contact: | Lukáš Petrovický <lpetrovi> | ||||||||||
Severity: | urgent | Docs Contact: | |||||||||||
Priority: | urgent | ||||||||||||
Version: | 6.2.0 | CC: | kverlaen, tzimanyi | ||||||||||
Target Milestone: | ER5 | ||||||||||||
Target Release: | 6.2.0 | ||||||||||||
Hardware: | Unspecified | ||||||||||||
OS: | Unspecified | ||||||||||||
Whiteboard: | |||||||||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||||||||
Doc Text: | Story Points: | --- | |||||||||||
Clone Of: | Environment: | ||||||||||||
Last Closed: | 2020-03-27 19:43:05 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 Depends On: | |||||||||||||
Bug Blocks: | 1265725, 1283109, 1295537 | ||||||||||||
Attachments: |
|
Description
Tomas Livora
2015-10-19 11:11:04 UTC
It seems that this problem is not only present on Oracle but also on other DBs. So far I have identified problems on these databases: IBM DB2 9.7 Oracle 12c Oracle 11g R2 PostgreSQL 8.4 Created attachment 1084737 [details]
PostgreSQL 8.4
Created attachment 1084738 [details]
IBM DB2 9.7
Created attachment 1085750 [details]
Microsoft SQL Server 2012
The same problem can be seen on MSSQL. There seems to be no problems on other databases that were not mentioned above (except of Oracle 11g R2 RAC which is currently blocked and would probably behave the same way as other versions of Oracle database).
Fixed. Commits: 6.3.x: https://github.com/droolsjbpm/jbpm/commit/4b9cf010 master; https://github.com/droolsjbpm/jbpm/commit/0987f956 These commits were also part of the fix: 6.3.x: https://github.com/droolsjbpm/droolsjbpm-integration/commit/30b35244 master: https://github.com/droolsjbpm/droolsjbpm-integration/commit/df5e8743 Verified on BPMS 6.2.0 ER5 |