Oracle Communities

Oracle Analytics and AI

Child Item

Report is failing intermittently.

3587245

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)

Find more posts tagged with

Accepted answers

All comments

Robert Angel

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]

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]

"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

Understood, apologies and agreed.

Analysis :-)

[Deleted User]

@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

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]

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.