Red Hat Bugzilla – Bug 967761
Cannot query tasks on PostgreSQL due to: ERROR: column "names5_.text" must appear in the GROUP BY clause or be used in an aggregate function
Last modified: 2015-06-01 21:35:12 EDT
Created attachment 753806 [details]
postgresql server log
Cannot query human tasks on PostgreSQL due to:
Caused by: org.postgresql.util.PSQLException: ERROR: column "names5_.text" must appear in the GROUP BY clause or be used in an aggregate function
The whole stacktrace is attached in server log file postgresql.txt.
See the steps here: https://github.com/jsvitak/jbpm-6-examples/tree/master/rewards-basic
So just clone the repo, follow the steps in readme.md and configure EAP to use PostgreSQL datasource. Also change the hibernate.dialect in file
The process starts correctly, but I was unable to list John's tasks. This operation works on MySQL without problems. It's possible that other problems may follow when approving tasks on PostgreSQL.
JBoss EAP 6.1.0.Beta1 (AS 7.2.0.Final-redhat-4)
jBPM 6.0.0.Beta2 (have to use community deps as no product libraries are available in DR builds so far)
Jiri, I believe this is a duplicate of https://bugzilla.redhat.com/show_bug.cgi?id=955574 which has been already fixed on master and should be included in beta3.
*** This bug has been marked as a duplicate of bug 955574 ***