SAP Knowledge Base Article - Public

2886035 - Error: '/CRYSTAL/OSQL_EXECUTE_QUERY doesn't exist on server side', when trying to create a report on a BEx Query in Crystal Reports

Symptom

  • Error when creating a report of a BEx Query.
  • Unable to create a report based on a BEx 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" 

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
         
  • SAP BW 7.50
  • SAP GUI: 750 Hotfix 1 or higher
  • SAP BI AddOn 7.5 SP08 or higher

Reproducing the Issue

  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'

Cause

  • 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

Resolution

  • To be able to connect to a BEx 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.

See Also

Keywords

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

Product

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