3 Replies Latest reply on May 13, 2016 12:42 PM by Thomas Dodds

    OBIEE error in dashboard



      Hi Experts,

      we are getting below report  error in one of the  dashboard .could you please help to resolve this issue...


      View Display Error:

      Odbc driver returned an error (SQLExecDirectW).

        Error Details

      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 937, message: ORA-00937: not a single-group group function at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)



        • 1. Re: OBIEE error in dashboard
          Thomas Dodds

          This running from a subject area in your RPD or direct SQL?



          Error ORA-00937 occurs when the GROUP BY command is improperly used. The GROUP BY command allows the user to view rows having a common field value in a single row. For example, a small business CEO wants to view employees who worked the highest number of hours by department last month. Another instance could be when a school superintendent wants to view students on the honor roll by homeroom. In such cases, the user may run a GROUP BY statement to view the results.

          GROUP BY is used in conjunction with aggregate functions to filter the results by a value. The GROUP BY command can be very useful for viewing a select set of results. It is commonly used, which deems it essential to utilize the proper syntax when running the statement.

          A SELECT list cannot include both a group function, such as AVG, COUNT, MAX, MIN, SUM, STDDEV, or VARIANCE, and an individual column expression, unless the individual column expression is included in a GROUP BY clause.

          In other words, you tried to execute a SELECT statement that requires a GROUP BY clause without including the GROUP BY clause. If you are using an aggregate function in your select query (e.g. AVG, COUNT, MAX, MIN…), you must have a GROUP BY clause.


          • 2. Re: OBIEE error in dashboard

            Hi Thomas,


            This running from a subject area in  RPD .



            • 3. Re: OBIEE error in dashboard
              Thomas Dodds

              then it's time to take a look at the RPD ... specifically content levels ...