Symptom
Exception while opening a query after an upgrade in the BW system.
The following entries can be found in the traces of Analysis Office (see SAP note 2129389):
------------------------------------------------------------------------------
RFC call BICS_PROV_GET_INITIAL_STATE returned an exception: RFC_ERROR_SYSTEM_FAILURE: Unexpected token in parameter E_TH_META_CHARACTERISTICS of the current basXML document: '�' at position 22754
Bali Exception:
Error\: Provider Selection Object: Initialization Issue
... or ...
Unexpected token while discarding PREDEFINED_MEMBERS_ORDER in content of parameter E_TH_STATE_CHARACTERISTIC of the current basXML document
---------------------------------------
Environment
- SAP Analysis for Microsoft Office
- SAP Analysis for Microsoft Office, edition for SAP Analytics Cloud
Reproducing the Issue
- Open AO and select any query as datasource;
- Confirm exception.
Resolution
Delete the cache files according to the steps below:
- Open Analysis for Office
- Navigate to File--> Analysis -> Customize Analysis -> Options -> Platform
- Click "Clear Cache"
- Close Analysis for Office and make sure that all Excel sessions are closed.
- On the affected PC, open the Windows File Explorer.
- Navigate to the following path: %APPDATA%\SAP AG\SAP BusinessObjects Advanced Analysis\cache
- Delete the file for the system to which the user is facing the issue
- Open Analysis for Office and test the scenario again.
Keywords
Analysis for Office, AO, A4O, BICS_PROV_GET_INITIAL_STATE, exception, RFC_ERROR_SYSTEM_FAILURE, launcher, error on opening , KBA , BI-RA-AO-XLA , Excel Addin , Problem
SAP Knowledge Base Article - Public