2468726 - Error: 'No RFC authorization for function module BAPI_MDPROVIDER_GET_STREAMINFO.' when refreshing a report based on an SAP BW Query in Crystal Reports

• 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."
     
     
        
       
  Followed by:
  
     "Database Connector Error: 'No RFC authorization for function module BAPI_MDPROVIDER_GET_STREAMINFO."
     
     

• SAP Crystal Reports 2013
• SAP Crystal Reports 2016
• SAP Crystal Reports 2020

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."

• 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.

• 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 found in the Attachments section:

     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 2013, 2016 and 2020.

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

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020