Ask Question Forum:
Model Library:2025-02-08:A.I. model is online auto reply
C
O
M
P
U
T
E
R
2
8
Show
#
ASK
RECENT
←
- Underline
- Bold
- Italic
- Indent
- Step
- Bullet
- Quote
- Cut
- Copy
- Paste
- Table
- Spelling
- Find & Replace
- Undo
- Redo
- Link
- Attach
- Clear
- Code
Below area will not be traslated by Google,you can input code or other languages
Hint:If find spelling error, You need to correct it,1 by 1 or ignore it (code area won't be checked).
X-position of the mouse cursor
Y-position of the mouse cursor
Y-position of the mouse cursor
Testcursor
caretPos
Attachment:===
Asked by conardb
at 2024-07-29 13:15:51
ModifyPoint:500 Replies:5 POST_ID:828635USER_ID:11504
Topic:
Oracle Database;;SQL Query Syntax
How can troubleshoot and fix this oracle database grouping error. I had this error spring up at the last minute in a development of a complex cognos report against an oracle database. Our support resources indicate it is an oracle grouping error and I'm starting from scratch on it. Has anyone had experience with this specifically or suggest the best approach to resolving. Thanks and sorry for initial vaguary. Error attached.
Attachment:OracleError.docx
Author: conardb replied at 2024-08-01 08:40:52
Thanks, it looks like some changes to the cardinality of queries in cognos are address the inclusion of needed columns in the query.
Accepted Solution
Expert: PortletPaul replied at 2024-07-29 16:43:06
167 points GOOD
It's a mistake in the query, something is missing from the group by clause.
Oracle Error: ORA-00979
Error Description:
Not a GROUP BY expression
Error Cause:
The GROUP BY clause does not contain all the expressions in the SELECT clause. SELECT expressions that are not included in a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, must be listed in the GROUP BY clause.
Action:
Include in the GROUP BY clause all SELECT expressions that are not group function arguments.
Oracle Error: ORA-00979
Error Description:
Not a GROUP BY expression
Error Cause:
The GROUP BY clause does not contain all the expressions in the SELECT clause. SELECT expressions that are not included in a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, must be listed in the GROUP BY clause.
Action:
Include in the GROUP BY clause all SELECT expressions that are not group function arguments.
Assisted Solution
Expert: duncanb7 replied at 2024-07-29 13:28:31
166 points GOOD
Take a look to see whether triggering some idea to solve the issue
http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/udasql0107-error-2458285
http://businessintelligence.ittoolbox.com/groups/technical-functional/cognos8-l/udasql0107-error-2458285
Expert: awking00 replied at 2024-07-29 13:22:40
Can you post the query that created the error?
Assisted Solution
Expert: slightwv replied at 2024-07-29 13:21:03
167 points GOOD
Without the query it will be hard to help troubleshoot.
A grouping error means you are trying to perform an aggregate function (like SUM, COUNT, AVG, etc...) and one or more of the other columns isn't in the group by list.
For example:
select col1, col2, sum(col3) from table group by col1;
Since col2 isn't in the group by, it will generate this error.
A grouping error means you are trying to perform an aggregate function (like SUM, COUNT, AVG, etc...) and one or more of the other columns isn't in the group by list.
For example:
select col1, col2, sum(col3) from table group by col1;
Since col2 isn't in the group by, it will generate this error.
