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

Last updated on JULY 11, 2022

Applies to:

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

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