java.sql.SQLException: Column 'ResourceCode.codeId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

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

Solutions on the web

via Liferay Issues by Albert Lee, 1 year ago
Column 'ResourceCode.codeId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
via sourceforge.net by Unknown author, 2 years ago
via jtds by furnerc
, 1 year ago
Incorrect syntax near the keyword 'select'.
via jtds by pauer
, 1 year ago
Cannot insert the value NULL into column 'completedFlag', table 'myDB.dbo.Tran'; column does not allow nulls. INSERT fails.
via jtds by tariq_hasnain
, 1 year ago
Invalid object name 'ioEngVersion'.
java.sql.SQLException: Column 'ResourceCode.codeId' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2820)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2258)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:632)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:477)
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

72 times, 6 months ago
3 times, 8 months ago
Once, 1 year ago
2 times, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 8 months ago

Write tip

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