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

    OBIEE error in dashboard

    2718919

       

      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)

       

      Thanks...

        • 1. Re: OBIEE error in dashboard
          Thomas Dodds

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

           

          ORA-00937

          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
            2718919

            Hi Thomas,

             

            This running from a subject area in  RPD .


            Regards,

            Pavani

            • 3. Re: OBIEE error in dashboard
              Thomas Dodds

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