OBIEE Error messages

One of the things that I’d like Oracle to improve is the Analytics error messages (both in the Repository and in the Answers). Sometimes, they’re just too broad – for example – Internal Assertion Error 46036 – which could mean anything: from corrupted RPD after transitioning or upgrading to logical levels not being set correctly in the hierarchy levels. Next set of errors that people have problems with is the installation errors  – usually those aren’t very descriptive as well, however, with time you sort of learn to distinguish those. Third problem is the debugging .cpp errors appearing in the RPD or Answers (such as – which should have been caught by system and a human-error message to appear – such as “.cpp, line 506
This application has requested to terminate the runtime in an unusual way”. Overall, troubleshooting OBIEE is a logical step-by-step process well-described in their Oracle Business Intelligence Troubleshooting Guide, however, by making error messages human-friendlier -they’d make OBIEE consultants job easier.

8 thoughts on “OBIEE Error messages”

  1. Can you please tell where the OBIEE Troubleshooting Guide actually is? I have looked through the various sources (OTN, the documentation indexes/weg catalogs, etc.) but have not been able to spot a specific document by that name.

    Your help would be appreciated.

    Regards,
    Dan Phillips

  2. Can you please tell where the OBIEE Troubleshooting Guide actually is?,I have been searching for it since long. Reply will be highly apprecited. devnagesatyahoo.com

  3. Hi ,
    i think problem in Filter or Logical joins . but i am unable to fix this problem . i tried number of ways still not at resolved . please some one can help step by step what to do . below is error message .

    Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
    State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 14026] Unable to navigate requested expression: FILTER(Ending Period Balance (Original):[DAggr(Fact – GL Postings – BalSheet.Ending Period Balance (Original) by [ Dim – Arts Adjustment.Adjustment ID] SB Dim – FDM Hierarchy (Answers) Total)] USING Dim – GL Chartfield Hierarchy (Account).Account Level 4 ID in ([ ‘DEFERRED_ACQ’] )). Please fix the metadata consistency warnings. (HY000)
    SQL Issued: SELECT “Original – Balance Sheet”.”DAC-Direct and Assumed – Activity Amount (Original)” saw_0, “Original – Balance Sheet”.”DAC-Direct and Assumed – Starting Balance (Original)” saw_1, “Dim – Arts Adjustment”.”Adjustment ID” saw_2 FROM “Financial Statements (Answers)” ORDER BY saw_2

  4. Hi,

    My rpd have 10 Dimension tables and One Main Fact table under that three(3) aggrgated or derived fact tables .

    Once run the report i need the result 8 dimension tables have to pull data from Three (3) derived tables and 2 Dimension tables have to pull from Main Fact table.
    But i am getting out put result in report all dimension tables pulling data from Main Fact table only .

    How i have to configure or setup to get data like this 8 dimension tables from 3 Derived fact tables and 2 Dimension tables from One mail Fact table.

    Please adivse further steps — — – —-

  5. Hi,

    My rpd have 10 Dimension tables and One Main Fact table under that three(3) aggrgated or derived fact tables .

    Once run the report i need the result 8 dimension tables have to pull data from Three (3) derived tables and 2 Dimension tables have to pull from Main Fact table.
    But i am getting out put result in report all dimension tables pulling data from Main Fact table only .

    How i have to configure or setup to get data like this 8 dimension tables from 3 Derived fact tables and 2 Dimension tables from One main Fact table.

    Please adivse further steps — — – —-

  6. hi
    i am getting the errors like
    1.error;1067The process terminate unexpectedly
    2.[nqserror:46036]Internal Assertion: when i am installation the obiee software

  7. what does this error mean
    —————————
    Oracle BI Administration Tool
    —————————
    [nQSError: 16001] ODBC error state: 08001 code: -30082 message: [IBM][CLI Driver] SQL30082N Attempt to establish connection failed with security reason “15” (“PROCESSING FAILURE”). SQLSTATE=08001
    .
    —————————
    OK
    —————————

  8. What does this mean?
    —————————
    Oracle BI Administration Tool
    —————————
    There was an error while updating row count for “DSNT”..”Q6APPREP”.”STR_DEPT_MUMD_DLY”:

    [nQSError: 16001] ODBC error state: 57011 code: -904 message: [IBM][CLI Driver][DB2] SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: “00C900A3″, type of resource: “00000200”, and resource name: “L6APPRE3.SSTDPMD0″. SQLSTATE=57011
    .

    [nQSError: 16015] SQL statement execution failed.

    Do you want to continue?
    —————————
    Yes No
    —————————

Leave a Reply