2468726 - Error: 'No RFC authorization for function module BAPI_MDPROVIDER_GET_STREAMINFO.' when refreshing a report based off a BEx Query in Crystal Reports

SAP Knowledge Base Article - Public

2468726 - Error: 'No RFC authorization for function module BAPI_MDPROVIDER_GET_STREAMINFO.' when refreshing a report based off a BEx Query in Crystal Reports

Symptom

  • BEx Query report fails to refresh.
  • Error: No RFC Authorization for BAPI_MDPROVIDER_GET_STREAMINFO.
  • Some user are able to successfully refresh the report, but with other user it fails.
  • When refreshing a report based off an SAP BW BEx Query in Crystal Reports, it fails with the errors:
     
       "Failed to retreive data from the database."
       
        BW_Error_01.png
          
         
    Followed by:

       "Database Connector Error: 'No RFC authorization for function module BAPI_MDPROVIDER_GET_STREAMINFO."
       
        BW_Error_02.png

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. In Crystal Reports, open a report based off an SAP BW BEx Query.
     
  2. Refresh the report, and select the SAP BW System, and enter the SAP User name and password.
     
    It then fails with the errors:
      
       "Failed to retreive data from the database."

    Followed by:

       "Database Connector Error: 'No RFC authorization for function module BAPI_MDPROVIDER_GET_STREAMINFO."

Cause

  • The SAP User does not have all the necessary authorizations on the SAP BW System to be able to access and execute a BW BEx Query.
       
  • More specifically, this error occurs when the SAP User does not have the following authorization:
             
    • Authorization object: S_RFC
      • RFC_TYPE: FUGR
      • RFC_NAME: RSOB
      • ACTV: 16

            But there is many more authorizations that are required on the SAP BW System to be able to report off a BEx Query.

Resolution

  • To be able to report off an SAP BW BEx Query in Crystal Reports, request the SAP System Administrator to set the appropriate authorizations on the SAP BW System for the SAP User.

For a list of necessary authorizations for refreshing a report based off an SAP BW BEx Query, consult the document:

BusinessObjects XI Integration for SAP Installation Guide.

In the "Authorizations" chapter, there is a description of each authorizations needed for each type of connection and actions.
        
Note: Even though the document was written for XI 3.1, the information is valid for Crystal Reports 2008, 2011, 2013 and 2016.

Keywords

CR, BExQuery, SAP Intergration Kit , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Attachments

xi3-1_bip_sap_install_en.pdf