OBIEE 11g: Reports that Access MSAS Fail and Throw the Error: The http return status is 503. The service is unavailable. (Doc ID 2205528.1)

Last updated on FEBRUARY 09, 2017

Applies to:

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

Symptoms

Whenever a user goes to a Dashboard page that has multiple reports (for example, 6+ reports) that access the same Microsoft Analysis Services 2008 (MSAS) datasource, some of the reports will succeed and return results, and the other reports will fail and return the following error:

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: URL: http://<server name or IP address>/msmdpump.dll. The http return status is 503. The service is unavailable. (HY000)

Whenever the user goes to the Dashboard page, it is random as to which of the reports will succeed and which of them will fail.

If the user clicks on the Refresh link for a failed report, it will re-execute successfully and return results.

The Connection Pool in the RPD for the MSAS datasource has Maximum Connections set to 100, and the URL matches the URL in the error (http://<server name or IP address>/msmdpump.dll).

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