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 12.2.1.4.0
(Doc ID 2466021.1)
Last updated on SEPTEMBER 03, 2021
Applies to:
Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and laterInformation in this document applies to any platform.
Symptoms
On : 12.2.1.4.0 version, Analytics
After upgrade to 12.2.1.4, a report with multiple columns and one aggregated column(count distinct) is throwing the below error:
odbc driver returned an error(SQLExecDirectW)
Error Codes:OPR4ONWY:U91M8TAC:U91M8TAC:U91M8TAC:U91M8TAC:U91M8TAC:OI2DL65P
State:HY000.Code:17001.[nQSError:17010] Oracle Error code :937, message:ORA-00937:not asingle-group function at OCI call OCIStmtExecute.(HY000)
STEPS
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)
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 |
| Cause |
| Solution |
| References |