Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Preventing Errored Requests from being Cached

725709Oct 7 2009 — edited Oct 10 2009

We set up our system to stop a request after 10 minutes, if it has not returned results.

When this happens, this is the error message we get:

Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1013, message: ORA-01013: user requested cancel of current operation at OCI call OCIStmtExecute:

The errored requests get cached too. Even if we try to run the a similar request (same facts and dimensions), but filter one of the dimensions (in order to pull-in less data), OBIEE brings the error message immediately (it does not even attempt to run the smaller request with less data).

Is there a way from preventing Errored Requests from being Cached?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2009

Added on Oct 7 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

4 comments

666 views