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

  1. ,
    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 sfetter0511
, 2 years ago
ERROR: function bomqtyavailable(numeric, integer, integer) does not exist; State=42883; ErrorCode=0
via adempiere by dellph
, 2 years ago
ERROR: function round(numeric, numeric) does not exist; State=42883; ErrorCode=0
via adempiere by gauravsontakke
, 2 years ago
ERROR: java.lang.ClassNotFoundException: org.compiere.sqlj.Product; state=XX000; ErrorCode=0
via Google Groups by Mike Starov, 2 years ago
ERROR: function function1(bigint) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 15
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 org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:254)	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)	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.convert.messaging.ConvertProcessMessageListener.receive(ConvertProcessMessageListener.java:44)	at com.liferay.portal.kernel.messaging.InvokerMessageListener.receive(InvokerMessageListener.java:70)	at com.liferay.portal.kernel.messaging.SerialDestination$1.run(SerialDestination.java:54)	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)