Knowledgebase: FDM
Error “ORA-00979: not a GROUP BY expression” When Importing with Logic Groups in FDM
Posted by Priya Doyle on 08 February 2011 04:04 PM

Error “ORA-00979: not a GROUP BY expression” When Importing with Logic Groups in FDM

 Modified 23-NOV-2010     Type PROBLEM 

Applies to:

Hyperion Financial Data Quality Management - Version: 11.1.1.3.00 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms


Receiving error “ORA-00979: not a GROUP BY expression” when importing data in FDM on a location with Logic Groups attached.
The logic is complex and using the Group By option on one account.

Cause


This is related to unpublished bug 9223586 on Oracle Databases.
It is caused by having the 'cursor_sharing' initialization parameter set to "similar" and not "exact".

Solution


A) Update the "Cursor Sharing" Initialization Parameter on the Oracle Database Instance from the current setting of "Similar" to "Exact"

B) Restart the Database Instance following the Change.

References

BUG:9223586 - ORA-979 FROM QUERY USING TO_NCHAR WITH UTF8 NCHARACTERSET


(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments: