SAP Knowledge Base Article - Public

3316062 - API Error when opening an Analysis for Office workbook

Symptom

When opening an Analysis for Office workbook that contains VBA an issue appears.
The following error appears on error display or on the LOG:

  • Could not retrieve a Reentrance Ticket for system <system>
  • API Error SAPGetMember ErrGeneral: A general error occured and could not be handled well
  • 29b7-9992<Nested exception> See inner exception below for mote details Invalid program status': RFC cal BICS_PROV_SET_STATE returned an excepter: RFC_ERROR_SYSTEM_FAILURE Name or password is incorrect (repeat logon)

A NCO LOG is needed and there appears:

  • RfcAbapMessageException: Incompatible Call Rejected, see note 2295840; Called Incompatible Function :BICS_CONS_EXECUTE_PLANNING_FUNCPROG:C:\Program Files\Microsoft Office\Root\<system>--- see log for details

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

  1. Open a workbook with API/VBA;
  2. When loading the issue appears.

Cause

Outbound / Inbound calls from external to RFC FM are blocked when the FM is blacklisted and the UCON-Check is active

Resolution

This situation is not related to Analysis for Office workbook or API, but the BASIS / BW. 

The following note needs to be applied: 

2295840-Outbound / Inbound calls from external to RFC FM are blocked when the FM is blacklisted and the UCON-Check is active

Keywords

KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions