Symptom
The following exception occurs in Analysis Office when refreshing a workbook or running a query:
"An exception occurred in one of the data sources.
SAP BI Add-in has disconnected all data sources.
If you want to restart, press the Restart button below. (ID-111006)"
---
The error in AO trace is as follows:
">>>> Bali Exception:
Invalid program status\: RFC call BICS_PROV_MASS_ADD_STRU_MEMBER returned an exception: RFC_ERROR_SYSTEM_FAILURE: ?????????????????????? - GETWA_NOT_ASSIGNED
com.sap.ip.bi.base.exception.BIBaseRuntimeException.<init>(BIBaseRuntimeException:77)"
---
When the issue occurs, a dump can be found in ST22 tcode:
"Category ABAP programming error
Runtime Errors GETWA_NOT_ASSIGNED
ABAP Program SAPLRSBOLAP_BICS_PROVIDER_MASS
Application Component BW-BEX-ET
Date and Time 23.01.2024 09:06:14
What happened?
Error in the ABAP application program.
The current ABAP program "SAPLRSBOLAP_BICS_PROVIDER_MASS" had to be terminated
because it found a
statement that could not be executed.
Error analysis
An attempt was made to access a field symbol that has not been assigned
yet (data segment number "-1")."
Environment
SAP Analysis for Microsoft Office 2.8
Reproducing the Issue
1. Run a query or a workbook.
2. Input a value for a prompt.
3. Error.
Cause
Program error
Resolution
Apply note 2820712 - BICS : Formula scenario is dumping using dependend formula
Keywords
Bali Exception, BIBaseRuntimeException, AO, Analysis for Excel, Analysis for Office, A4O, AFO , KBA , BI-RA-AO-XLA , Excel Addin , Problem