OBIEE 11g : Users Are Not Able To Access The Reports (Doc ID 2132870.1)

Last updated on AUGUST 11, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.151020 and later
Information in this document applies to any platform.

Symptoms

On Oracle Business Intelligence Enterprise Edition (OBIEE) 11g,

While Accessing the reports from Analytics, Reports are erroring out as below.

1.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: 46073] Operation 'open()' on file '/bidw/Middleware/instances/instance1/tmp/OracleBIServerComponent/coreapplication_obis1/obis_temp/nQS_4239_3398_68522490.TMP' failed with error: (2) ².Please have your System Administrator look at the log for more details on this error. (HY000)

 2. Error
  View Display Error
  Please have your System Administrator look at the log for more details on this error.
  Error Details
 Error Codes: QITMDW79:
No such file or directory

Following error can be found in sawlog.log

[OBIPS] [ERROR:31] [] [saw.xmlDocumentCache.cleanup] [ecid: 005CGi9QWfs5uXSpICc9yf00012E000000,0:147847] [tid: 583567104] Path not found: '/bidw/Middleware/instances/instance1/tmp/OracleBIPresentationServicesComponent/coreapplication_obips1/sawrptcache/10b9/gvq5c0e60nqv00tcu0v9698tpq.sawrqc'
No such file or directory[[

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