Created attachment 1084335 [details] Oracle 12c Description of problem: When you try to execute some task query operations (either using REST or SOAP interface) on Oracle database, you will get SQLGrammarException. Version-Release number of selected component (if applicable): 6.2.0 ER4 Steps to Reproduce: 1. Run some process with a task. 2. Try to call for example http://localhost:8080/business-central/rest/query/task?processInstanceId=1 3. See the response Actual results: java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression Expected results: No exception and valid result. Additional info: This bug was probably introduced when trying to fix bug 1265725.
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