2780439 - Invalid program status\: RFC call BICS_PROV_OPEN returned an exception

Opening a workbook or inserting a datasource after a BW upgrade raises an exception.

Invalid program status\: RFC call BICS_PROV_OPEN returned an exception: RFC_ERROR_SYSTEM_FAILURE: Element E_SUPPORT_FORMULA_MODE of container metadata BICS_PROV_OPEN unknown

SAP Analysis for Microsoft Office

1) Open Analysis for Office

2) Select Analysis->Insert Data Source-> Select Data Source for Analysis....

3) Try to insert any query

In some cases the data type BICS_PROV_RFC_GET_INIT_STATE_E (which is a structure) becomes inactive after an upgrade.

1) Open transaction SE11

2) Enter BICS_PROV_RFC_GET_INIT_STATE_E in the Data type field

3) Click on Display to display its status

4) If the structure BICS_PROV_RFC_GET_INIT_STATE_E is not active, please activate it!

It is also possible that the status is shown as "Active", but it still needs to be re-activated.

  BICS_PROV_OPEN, Invalid program status, com.sap.ip.bi.bics.dataaccess.resource.impl.bi.selector.ProviderSelectionObject.doPostProcessing, Application Exception, E_SUPPORT_FORMULA_MODE , KBA , BI-RA-AO-XLA , Excel Addin , BW-BEX-ET-WJR-BICS , BI Consumer Services , BI-RA-BICS-BW , BICS BW Provider , Problem