OBIEE 11g: Reports that Access MSAS Fail and Throw the Error: The http return status is 503. The service is unavailable.
Last updated on FEBRUARY 09, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
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).
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