OBIEE 12c: Reports Having COUNT(DISTINCT) Throwing Error: "ORA-00937:not a single-group function at OCI call OCIStmtExecute.(HY000)" after Upgrade from 11g to 188.8.131.52.0
(Doc ID 2466021.1)
Last updated on SEPTEMBER 03, 2021
Applies to:Business Intelligence Suite Enterprise Edition - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
On : 220.127.116.11.0 version, Analytics
After upgrade to 18.104.22.168, a report with multiple columns and one aggregated column(count distinct) is throwing the below error:
odbc driver returned an error(SQLExecDirectW)
State:HY000.Code:17001.[nQSError:17010] Oracle Error code :937, message:ORA-00937:not asingle-group function at OCI call OCIStmtExecute.(HY000)
The issue can be reproduced by following steps:
1. Create an analysis.
2. Create analysis with 3 columns like this - Col1 Col2 Col3 COUNT(DISTINCT Col1 by Col2)
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