新聞財經娛樂♬資訊 News Economy

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.

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.

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

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.