Symptom
Some users in specific machines receive the error "Provider Selection Object:Initialization issue" when trying to run a query.
It was observed that this might happen 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
Reproducing the Issue
- Open AO and select any query as datasource;
- Confirm exception.
Resolution
Delete the cache files from below directory for all users on affected computers
"%APPDATA%\SAP AG\SAP BusinessObjects Advanced Analysis\cache"
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