2539597 - Error: "The remote server returned an error: (500) Internal Server Error" in HANA scenario

When using Analysis Office against HANA database, the error below is occurring after exactly 10 minutes waiting for a response from HANA:

"The remote server returned an error: (500) Internal Server Error"

SAP BusinessObjects Analysis, edition for Microsoft Office

This issue is related to a timeout when connected to HANA database. It occurs when AO is waiting for a response from HANA and this is taking some time.

By default, there is no timeout defined in Analysis for Office side when connecting to HANA, so the default value configured in HANA side is used (usually 10 minutes).

In AO side, the setting that controls the timeout is "HanaHttpConnectionTimeout". This can be changed to a value higher than the timeout defined in HANA to avoid the error.

More information about the settint "HanaHttpConnectionTimeout" can be found in Administrator Guide of AO, available in http://help.sap.com/boao.

More information about how to change the settings can be found in SAP note 2083067.

timeout, server, error, 500, hana, view, performance, exception , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-CON , Please use component BI-RA-AO-XLA , Problem