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
Situation
INFO | jvm 1 | 2013/05/28 11:19:00 | com.redhat.rhn.common.db.WrappedSQLException: ORA-00979: not a GROUP BY expression
Resolution
Cause
Additional Information
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
For questions or concerns with the SUSE Knowledgebase please contact: tidfeedback@suse.com