SUSE Manager taskomatic reports "ORA-00979: not a GROUP BY expression"

This document (7012512) is provided subject to the disclaimer at the end of this document.

Environment

SUSE Manager 1.7

Situation

After patching spacewalk-java-* and spacewalk-taskomatic* to version 1.7.54.24-0.5.6, the following error is experienced in /var/log/rhn/rhn_taskomatic_daemon.log:

INFO | jvm 1 | 2013/05/28 11:19:00 | com.redhat.rhn.common.db.WrappedSQLException: ORA-00979: not a GROUP BY expression

Resolution

Customers experiencing this issue should contact Novell Technical Services for a program temporary fix unless a maintenance update is available.

Cause

An invalid SQL statement.

Additional Information

Complete log entries:

INFO   | jvm 1    | 2013/05/28 11:19:00 | 2013-05-28 11:19:00,322 [DefaultQuartzScheduler_Worker-10] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error whi
le processing cached statement sql: SELECT DISTINCT s.id, s.name, scm.label as contact_method_label, max(a.earliest_action) as earliest_action
INFO   | jvm 1    | 2013/05/28 11:19:00 |   FROM rhnServer s
INFO   | jvm 1    | 2013/05/28 11:19:00 |   JOIN rhnServerAction sa ON sa.server_id = s.id
INFO   | jvm 1    | 2013/05/28 11:19:00 |   JOIN rhnAction a ON sa.action_id = a.id
INFO   | jvm 1    | 2013/05/28 11:19:00 |   JOIN suseServerContactMethod scm ON s.contact_method_id = scm.id
INFO   | jvm 1    | 2013/05/28 11:19:00 | WHERE sa.status = 0
INFO   | jvm 1    | 2013/05/28 11:19:00 |    AND (scm.label = 'ssh-push' OR scm.label = 'ssh-push-tunnel')
INFO   | jvm 1    | 2013/05/28 11:19:00 |    AND a.earliest_action <= current_timestamp
INFO   | jvm 1    | 2013/05/28 11:19:00 |    AND sa.server_id = s.id
INFO   | jvm 1    | 2013/05/28 11:19:00 | GROUP BY s.id, scm.label
INFO   | jvm 1    | 2013/05/28 11:19:00 | ORDER BY earliest_action ASC
INFO   | jvm 1    | 2013/05/28 11:19:00 | com.redhat.rhn.common.db.WrappedSQLException: ORA-00979: not a GROUP BY expression
INFO   | jvm 1    | 2013/05/28 11:19:00 |
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.common.translation.SqlExceptionTranslator.oracleSQLException(SqlExceptionTranslator.java:82)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.common.translation.SqlExceptionTranslator.sqlException(SqlExceptionTranslator.java:42)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:141)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:455)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:431)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:337)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:342)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:282)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:126)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.taskomatic.task.sshpush.SSHPushDriver.getCandidateSystems(SSHPushDriver.java:187)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.taskomatic.task.sshpush.SSHPushDriver.getCandidates(SSHPushDriver.java:93)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.taskomatic.task.threaded.TaskQueue.run(TaskQueue.java:113)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.taskomatic.task.RhnQueueJob.execute(RhnQueueJob.java:124)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.taskomatic.task.RhnQueueJob.execute(RhnQueueJob.java:74)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at com.redhat.rhn.taskomatic.TaskoJob.execute(TaskoJob.java:169)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at org.quartz.core.JobRunShell.run(JobRunShell.java:216)
INFO   | jvm 1    | 2013/05/28 11:19:00 |       at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:549)
INFO   | jvm 1    | 2013/05/28 11:19:00 | Caused by: java.sql.SQLException: ORA-00979: not a GROUP BY expression

Disclaimer

This Support Knowledgebase provides a valuable tool for SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.