Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Report is failing intermittently.

Received Response
21
Views
7
Comments
3587245
3587245 Rank 2 - Community Beginner
edited Aug 13, 2024 5:48PM in Oracle Analytics Cloud and Server

Problem Summary

---------------------------------------------------

Report is failing intermittently.

Problem Description

---------------------------------------------------

Report is giving display error in irregular intervals. It is working for sometime without any issue and failing all of sudden after some time.The report and prompts are both coming directly from Hyperion. sometime when we clear cache in RPD of it is working fine .

Frontend error : 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: 96002] Please have your System Administrator look at the log for more details on this error. (HY000)

Backend Error : 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: 96002] Essbase Error: Unknown Member C2681 - Software Engineering ICS used in query (HY000)

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi,

    it looks like your cache has Essbase in a state where C2681 did not exist, I would suggest it would be worth building into your Essbase database refreshes a post refresh plan to delete OBIEE cache, or put some other mechanism in place to refresh your Essbase cache on a regular basis.

    I am not following your comment 'the report .... is coming directly from Hyperion' - if so where is OBIEE in the picture?!

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    It's nice that you simply re-post issues which you receive to solve in here. Especially since you provide zero actual information like version, host OS or literally anything.

    This is a community forum - not a free shop to get your work done.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    "Report" being used as a synonym for "analysis" is pretty much the standard here, Robert. I try to point this out but people can't be bothered to grasp that those are two completely different things based on two completely different technologies.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Understood, apologies and agreed.

    Analysis  :-)

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @Robert Angel Not you...the OP :-P

    "I am not following your comment 'the report .... is coming directly from Hyperion' - if so where is OBIEE in the picture?!"  <--- I was reinforcing the point of report vs OBI (vs Hyperion)

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    O right, makes sense.

    I was trying to ascertain if there was something people pulled from Web Reports and OBIEE was just the middle man, or if this truly is an OBIEE analysis...

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Bingo. That is why - in theory - things have proper names and one should use those names.

    Because "I am sawing this piece of wood with my screwdriver" does not make any sense even though a saw and a screwdriver are both tools.

    Alas as we can see on a daily basis - that's just a theory.