java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression

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 Oracle Community by 793445, 1 year ago
ORA-00979: not a GROUP BY expression
via Oracle Community by user13100220, 1 year ago
via Oracle Community by 760318, 1 year ago
ORA-00932: inconsistent datatypes: expected -, got -
via Oracle Community by 785910, 1 year ago
ORA-00904: "MSCPLANSEO"."MSC_PLANS_PARTY_ID": invalid identifier
via Oracle Community by 780131, 1 year ago
ORA-00942: table or view does not exist [exec] [exec]
via by Unknown author, 2 years ago
ORA-00904: "TICKETEO"."ID_CATEGORIA_APERTURA": identificativo non valido
java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression
at oracle.jdbc.driver.SQLStateMapping.newSQLException(
at oracle.jdbc.driver.DatabaseError.newSQLException(
at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(
at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(
at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(
at oracle.apps.xdo.dataengine.XMLPGEN.writeData(
at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(
at oracle.apps.xdo.dataengine.XMLPGEN.processData(
at oracle.apps.xdo.dataengine.XMLPGEN.processXML(
at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(
at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(
at oracle.apps.xdo.dataengine.DataProcessor.processData(
at oracle.apps.xdo.oa.util.DataTemplate.processData(
at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(
at oracle.apps.fnd.cp.request.Run.main(

Users with the same issue

3 times, 1 month ago
5 times, 7 months ago
27 times, 9 months ago
Once, 1 year ago
Once, 1 year ago

Write tip

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