OBIEE 12c : ORA-00937 Error Occurred When Multi-columns Using Count Function In A Table View
(Doc ID 2661506.1)
Last updated on MAY 17, 2020
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
After upgrade from 18.104.22.168 to 22.214.171.124, the table view is displaying ORA-00937 error as below:
In 126.96.36.199 , the ORA-00937 error is not displaying and the table view can show correct results.
In 188.8.131.52, the error occurred when the following condition are met:
- The table view includes one dimension column and multiple measure columns using COUNT function.
- LENGTH function is using with COUNT function in one of the measure columns.
For example, set below three columns in a table view :
Dimension Column, COUNT(1) , COUNT(CASE WHEN LENGTH("Any Dimension Column") > 2 THEN 1 ELSE NULL END)
Upgrade from 184.108.40.206 to 220.127.116.11.
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