Red Hat Bugzilla – Bug 1272981
SQLGrammarException when executing task query operations on various DBs
Last modified: 2016-09-20 01:13:17 EDT
Created attachment 1084335 [details]
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):
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
java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression
No exception and valid result.
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 11g R2
Created attachment 1084737 [details]
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).
These commits were also part of the fix:
Verified on BPMS 6.2.0 ER5