SAP Knowledge Base Article - Preview

3647497 - Error "An exception occurred in one of the data sources." when running a query in Analysis for Microsoft Office

Symptom

When running a query in Analysis for Microsoft Office and changing the prompt value for the second time, get the following error message: 

-------
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 (111006).
-------

In AO trace file (SAP Note 2129389), the following errors are recorded:
-----------------------------------
>> Arguments[0]: RFC call BICS_PROV_GET_INITIAL_STATE returned an exception: RFC_ERROR_SYSTEM_FAILURE: Field symbol has not been assigned yet. - GETWA_NOT_ASSIGNED
Bali Exception:
Error\: Provider Selection Object: Initialization Issue
-------------------------------------

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP Analysis for Microsoft Office 2.8
  • SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud 2.8
  • SAP Business Warehouse
  • SAP BW4/HANA
  • SAP NetWeaver

Product

SAP Analysis for Microsoft Office 2.8 ; SAP Analysis for Microsoft Office 2.8, edition for SAP Analytics Cloud ; SAP BW/4HANA all versions ; SAP NetWeaver all versions ; SAP S/4HANA all versions

Keywords

GETWA_NOT_ASSIGNED, RFC_ERROR_SYSTEM_FAILURE, BICS_PROV_GET_INITIAL_STATE, Field symbol, AO, runtime error , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-OT-OLAP , Analyzing Data , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.