OBIEE 10g - "ORA-00979" Error After Upgrade to 10.1.3.4.2 (Doc ID 1939475.1)

Last updated on DECEMBER 15, 2014

Applies to:

Business Intelligence Suite Enterprise Edition - Version 10.1.3.4.1 [1900] to 10.1.3.4.2 [2405]
Business Intelligence Server Enterprise Edition - Version 10.1.3.4.1 [1900] to 10.1.3.4.2 [2405]
Information in this document applies to any platform.

Symptoms

OPR4ONWY:U9IM8TAC:OI2DL65P
Error (SQLExecDirectW) was returned by the ODBC driver.
Error Code: OPR4ONWY: U9IM8TAC: OI2DL65P
State: HY000. Code: 454 858 400. [NQODBC] [SQL_STATE: HY000]
  [nQSError: 10058] A general error has occurred.
  [nQSError: 17001] Oracle Error code: 979, message:
  ORA-00979: not a GROUP BY expression at OCI call OCIStmtExecute.
  . [nQSError: 17010] SQL statement preparation failed (HY000)

WITH <table> AS (
    select
        D1.c1 as c1,
        D1.c2 as c2,
        D1.c3 as c3,
    from
        (
......
ROW_NUMBER () OVER (
    ......
    concat (concat (substr (T54109.zzzzz, 1, 4), '/'), substr (T54109.zzzzz,
5, 2))
    ......
)
......
select
    distinct <table>.c1 as c1,
    <table>.c2 as c2,
    <table>.c3 as c3,
    <table>.c4 as c4,
    <table>.c5 as c5
from
    <table>

Changes

Upgraded OBIEE from 10.1.3.4.1 to OBIEE 10.1.3.4.2.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms