SAP Knowledge Base Article - Public

3096438 - Element E_QUERY_DOC_APPL_ID of container metadata BICS_PROV_OPEN unknown

Symptom

When insert data source in Analysis Office, exception below occurs.

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

This issue may occur only on one PC and cannot be reproduced on other PCs.

Environment

SAP Analysis for Microsoft Office

Reproducing the Issue

Open AO and select any query as data source.

AO trace log file (see note 2129389) contains the following error:

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

 com.sap.ip.bi.bics.dataaccess.resource.impl.bi.selector.ProviderSelectionObject.doPostProcessing(ProviderSelectionObject:2267)
 com.sap.ip.bi.base.application.service.rfcproxy.base.RfcFunction.execute(RfcFunction:95)

Cause

The affected user has an issue with the metadata.

Resolution

Delete the metadata cache for the affected user as per below steps:

  • On the affected PC, please open the Windows File Explorer.
  • Navigate to the following path: %APPDATA%\SAP AG\SAP BusinessObjects Advanced Analysis\cache
    There, you will find a list of all cached systems.
  • Delete the file for the system to which the user is not able to connect to.
  • Open Analysis for Office and test the user scenario again.

Keywords

Analysis for Office, AO, exception, Element, E_QUERY_DOC_APPL_ID, BICS_PROV_OPEN, metadata, RFC_ERROR_SYSTEM_FAILURE, , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office 2.8