org.postgresql.util.PSQLException: ERROR: column "resourcecode.codeid" must appear in the GROUP BY clause or be used in an aggregate function

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via Liferay Issues by Albert Lee, 1 year ago
ERROR: column "resourcecode.codeid" must appear in the GROUP BY clause or be used in an aggregate function
via adempiere by bmagoha5
, 1 year ago
ERROR: java.lang.ClassNotFoundException: org.compiere.sqlj.Product; State=XX000; ErrorCode=0
via adempiere by sfetter0511
, 1 year ago
ERROR: function bomqtyavailable(numeric, integer, integer) does not exist; State=42883; ErrorCode=0
via adempiere by dellph
, 1 year ago
ERROR: function round(numeric, numeric) does not exist; State=42883; ErrorCode=0
via adempiere by gauravsontakke
, 1 year ago
ERROR: java.lang.ClassNotFoundException: org.compiere.sqlj.Product; state=XX000; ErrorCode=0
via adempiere by banym
, 1 year ago
ERROR: java.lang.ClassNotFoundException: org.compiere.sqlj.Product; State=XX000; ErrorCode=0
org.postgresql.util.PSQLException: ERROR: column "resourcecode.codeid" must appear in the GROUP BY clause or be used in an aggregate function
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1608)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1343)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:194)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350)
at com.liferay.portal.upgrade.util.Table.generateTempFile(Table.java:371)
at com.liferay.portal.convert.ConvertPermissionAlgorithm._convertToBitwise(ConvertPermissionAlgorithm.java:157)
at com.liferay.portal.convert.ConvertPermissionAlgorithm.doConvert(ConvertPermissionAlgorithm.java:124)
at com.liferay.portal.convert.ConvertProcess.convert(ConvertProcess.java:41)
at com.liferay.portal.convert.messaging.ConvertProcessMessageListener.doReceive(ConvertProcessMessageListener.java:59)
at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
at java.lang.Thread.run(Thread.java:595)

Users with the same issue

37 times, 1 week ago
3 times, 1 month ago
Once, 2 months ago
Once, 2 months ago
32 times, 2 months ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.