My Oracle Support Banner

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 FEBRUARY 03, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Information 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)

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
References


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