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.

  • Document ID:7012512
  • Creation Date: 30-May-2013
  • Modified Date:03-Mar-2020
    • SUSE Manager

< Back to Support Search

For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback@suse.com

SUSE Support Forums

Get your questions answered by experienced Sys Ops or interact with other SUSE community experts.

Join Our Community

Support Resources

Learn how to get the most from the technical support you receive with your SUSE Subscription, Premium Support, Academic Program, or Partner Program.


SUSE Customer Support Quick Reference Guide SUSE Technical Support Handbook Update Advisories
Support FAQ

Open an Incident

Open an incident with SUSE Technical Support, manage your subscriptions, download patches, or manage user access.

Go to Customer Center