SAP Knowledge Base Article - Public

2886035 - Error: '/CRYSTAL/OSQL_EXECUTE_QUERY doesn't exist on server side', when trying to create a report of 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 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:
  2. Load the SAP Integration Kit Transports corresponding to the exact version of Crystal Reports used to the SAP System:
  3. Update the 'hosts' file of the computer where Crystal Reports is installed with host name and IP Address like:
  4. In Crystal Reports, under the menu "SAP", select "Create New Report from a Query..."
     
  5. Log into the SAP system.
      
  6. Error is displayed

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

  • Ask the SAP BASIS Administrator to add the Authorization for function module FUNCTION_IMPORT_INTERFACE
  • Also, review the required Authorizations found in the attached document of the SAP Knowledge Base Article 1615056

See Also

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

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