Symptom
An exception occurs in Analysis Office.
When checking the error messages in the dialog, they look like the following:
--------------------------------------
Application Exception ([1286-462a-7a] / ID-103042)
...
Invalid program status\: RFC call BICS_PROV_GET_INITIAL_STATE returned an exception: RFC_ERROR_SYSTEM_FAILURE: Incompatible Call Rejected, see note 2295840; Called Incompatible Function :BICS_PROV_GET_INITIAL_STATECPROG:C:\Program Files\Microsoft Office\OfficeDEST:<SYSTEM>_a -
--------------------------------------
--------------------------------------
Application Exception ([1286-462a-7a] / ID-103042)
...
Invalid program status\: RFC call BICS_PROV_SET_STATE returned an exception: RFC_ERROR_SYSTEM_FAILURE: Incompatible Call Rejected, see note 2295840; Called Incompatible Function :BICS_PROV_SET_STATECPROG:C:\Program Files\Microsoft Office\Root\ODEST:BWL_<SYSTEM> -
--------------------------------------
Environment
SAP Analysis for Microsoft Office
Cause
The error occurs because the function module mentioned in the error message is blocklisted in the system, as explained in SAP note 2295840.
Resolution
Create an case to SAP by selecting the component CA-EPT-TAS to check why the function module is blocked.
The workaround is to manually allowlist the function module mentioned in the error message (e.g. BICS_PROV_GET_INITIAL_STATE, BICS_PROV_SET_STATE, etc). More information can be found in SAP notes below:
Keywords
rejected, exception, error, workbook, query, BICS_PROV_GET_INITIAL_STATE, ID-103042, 1286-462a-7a, BICS_PROV_SET_STATE , KBA , blacklist , whitelist , BI-RA-AO-XLA , Excel Addin , Problem