My Oracle Support Banner

OBIEE 12c: "ORA-00937: Not A Single-group Group Function Error" Message When Opening Analyses (Doc ID 2573151.1)

Last updated on AUGUST 21, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to open an analysis, the results are not displayed and you see a ORA-00937: not a single-group group function in the error details.

In the OBIS component query log, you see the full error:

[<timestamp>] [OBIS] [TRACE:3] [] [] [ecid: <ecid>] [sik: ssi] [tid: <tid>] [messageid: <message-id>] [requestid: <request-id>] [sessionid: <sessionid>] [username: <username>] -------------------- Query Status: [nQSError: 17010] SQL statement preparation failed. [[
[nQSError: 17001] Oracle Error code: 937, message: ORA-00937: not a single-group group function
 at OCI call OCIStmtExecute.
[nQSError: 43119] Query Failed:

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.