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
- Open the AFO workbook and connect to the backend.
- Fill the query prompt.
- Turn off Wi-Fi on the computer.
- Execute the following API: `Application.Run("SAPGetProperty", "IsConnected", "DS_1")`.
Cause
Resolution
- 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.
- 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
SAP Knowledge Base Article - Public