SAP Knowledge Base Article - Public

3728498 - unexpected "true" return value from SAPGetProperty API method with IsConnected property when Wi-Fi is disconnected

Symptom

  • The API method SAPGetProperty with the IsConnected property returns "true" instead of the expected "false" value when the Wi-Fi network is disconnected.
  • This issue occurs when a planning function is launched via Excel VBA after the Wi-Fi network is turned off.

Environment

Excel Addin

Reproducing the Issue

  1. Open the AFO workbook and connect to the backend.
  2. Fill the query prompt.
  3. Turn off Wi-Fi on the computer.
  4. Execute the following API: `Application.Run("SAPGetProperty", "IsConnected", "DS_1")`.

Cause

Resolution

  1. The connection related to the data source used in the macro is part of a connection pool, which means it remains open and ready for reuse to enhance performance.
  2. The macro does not trigger a PING due to performance considerations, which is why turning off the Wi-Fi does not impact the SAPGetProperty macro.

Keywords

SAPGetProperty, IsConnected, AFO workbook, Excel VBA, Wi-Fi disconnected, connection pool, API method, unexpected return value, backend connection, planning function, PING mechanism , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office 2.8