My Oracle Support Banner

"ORA-00979: not a GROUP BY expression" Error Received when Running ODI 12c Mapping Using Journalization and an Aggregate Component (Doc ID 2520577.1)

Last updated on OCTOBER 18, 2019

Applies to:

Oracle Data Integrator - Version 12.1.3.0.0 to 12.2.1.3.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

An Oracle Data Integrator (ODI) 12c mapping has been configured to utilize an Aggregate Component and Journalization.

If Journalization is not configured, the mapping executes successfully.

However, when running the same mapping after configuring Journalization, the following error is received:

ODI-1228: Task <TASK_NAME> fails on the target connection <CONNECTION_NAME>.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00979: not a GROUP BY expression
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:218)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:31)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1000)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
    at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2168)
    at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2100)
    at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:363)
    at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:205)
    at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:141)
    at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:28)
    at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)
    at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:189)
    at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:111)
    at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:864)
    at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2024)
    at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:562)
    at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:718)
    at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:611)
    at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
    at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:800)
    at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$1400(StartSessRequestProcessor.java:74)
    at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:702)
    at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:180)
    at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:108)
    at java.lang.Thread.run(Thread.java:724)



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.