2886035 - Error: '/CRYSTAL/OSQL_EXECUTE_QUERY doesn't exist on server side', when creating a report on an SAP BW Query in Crystal Reports

• Error when creating a report of a BEx Query.
• Unable to create a report based on a SAP BW Query in Crystal Reports.
• When trying to create a report based using the SAP toolbar connection in Crystal Reports, it generates the error
  
     "Data base connector Error: /CRYSTAL/OSQL_EXECUTE_QUERY doesn't exist on server side."
  
  
• When performing an OpenSQL traces, it shows the error:
    
      "/CRYSTAL/OSQL_EXECUTE_QUERY doesn't exist on server side" 

• SAP Crystal Reports 2016
• SAP Crystal Reports 2020
       
• SAP BW 7.50

1. Install a supported version of: SAP Business Explorer(BI Add-On) ,SAP GUI and crystal reports tool:
• 1229206 - Front end check tool SAPBExC.xla (BW 3.x and BI 7.x)
   
2. Load the SAP Integration Kit Transports corresponding to the exact version of Crystal Reports used to the SAP System:
• 2177314 - Version of SAP Integration Kit Transports required for Crystal Reports to connect to an SAP System
   
3. Update the 'hosts' file of the computer where Crystal Reports is installed with host name and IP Address like:
• 2824998 - Crystal Reports hang when refreshing a report based on SAP Table, Cluster, or Function
   
4. In Crystal Reports, under the menu "SAP", select "Create New Report from a Query..."
      
5. Enter the credential to login to an SAP system.
   
   It then display the error:  '/CRYSTAL/OSQL_EXECUTE_QUERY doesn't exist on server side'

• When performing an RFC traces on the SAP System, it shows the following errors: 
• RFC_ERROR_INFO.key: RFC_NO_AUTHORITY
• RFC_ERROR_INFO.message: No RFC authorization for function module FUNCTION_IMPORT_INTERFACE.
       
• Issue is due to the SAP User not having the RFC authorization for function module FUNCTION_IMPORT_INTERFACE

• To be able to connect to am SAP BW Query in Crystal Reports, ask the SAP BASIS Administrator of the SAP System to:
       
1. Add Authorization for the function module: FUNCTION_IMPORT_INTERFACE
       
2. Review the required Authorizations found in the document attached to the SAP Knowledge Base Article 1615056, and add any additional required Authorizations.

• 1615056 - How to connect to SAP datasources from Crystal Reports?
• 1220085 - How to trace report connectivity to SAP data sources, like SAP Tables or BEx Queries, from Crystal Reports?
• 2177314 - Version of SAP Integration Kit Transports required for Crystal Reports to connect to an SAP System
• 2291164: Tutorial "How to activate traces for SAP Logon Control" [VIDEO]
• 1229206 - Front end check tool SAPBExC.xla (BW 3.x and BI 7.x)
• 1921554 - How to verify the version of the SAP Integration Kit Transports loaded on the SAP Netweaver or SAP BW System? [Video]
• 2824998 - Crystal Reports hang when refreshing a report based off SAP Table, Cluster, or Function

BEx Frontend, 2016, 2013, wdtlog, CR, BI, client , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem