SAP Knowledge Base Article - Public

2402858 - Error: 'Function module "/CRYSTAL/OSQL_AUTH_REQUIRED" not found', when connecting to SAP Tables from Crystal Reports

Symptom

  • Fails to connect to SAP Table.
  • Error: 'Function module "/CRYSTAL/OSQL_AUTH_REQUIRED" not found.'
  • When attempting to connect to SAP Tables from Crystal Reports, it generates an error.

Environment

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

Reproducing the Issue

  1. In Crystal Reports, under the menu "File" select "New - Blank Report..."
  2. In the "Database Expert", under "Create New Connection", double click on "SAP Table, Cluster, or Function"
      
     Open SQL - 01.png 
        
       
  3. It then fails with the error: ''Function module "/CRYSTAL/OSQL_AUTH_REQUIRED" not found.'

Cause

  • When connecting to SAP Tables, Crystal Reports communicate with functions loaded on the SAP System by the SAP Integration Kit Transports.
        
  • If the functions does not exist, it will fails with this error, because the function module "/CRYSTAL/OSQL_AUTH_REQUIRED" is part of the Open SQL Connectivity transport, and it has not been loaded on the SAP System.

Resolution

  • Load the Open SQL Connectivity transport, corresponding to the version of Crystal Reports used on the SAP System.
       
    Below are the general steps on how to do so:
           
    1. Download or locate the product installation or updates of SAP Crystal Reports, that correspond to the version of Crystal Reports used.
         
      Note: The product installation and updates contains the SAP Integration Kit Transports that needs to be loaded on the SAP System. Those are not installed with Crystal Reports, it has to be manually loaded by the SAP BASIS Administrator on the SAP System.
                   
    2. Unzip the product installation or updates of Crystal Reports.
              
    3. Navigate to the following path: Collaterals/Add-Ons/SAP/Transport  
          
    4. Open the file: transports_EN.txt, and locate the Open SQL Connectivity transport, and it will indicate the transport file that need to be loaded on the SAP System for this connectivity type.
         
      Below is an example of how it will look like:
        
      * Open SQL Connectivity transport (K900754.R21 and R900754.R21)
      * Info Set Connectivity transport (K900780.r21 and R900780.r21)
      * Row-level Security Definition transport (K900689.r21 and R900689.r21)
      * Cluster Definition transport (K900690.r21 and R900690.r21)
      * Authentication Helpers transport (K900691.r21 and R900691.r21)
       
      In this example, the transport files to use the Open SQL Connectivity transport are: K900754.R21 and R900754.R21
      Again this is an example, the file name will be different depending on the version of Crystal Reports used.
              
    5. Request to the SAP BASIS Administrator to load the Open SQL Connectivity Transport to the SAP System.
            
    6. Also, request the SAP BASIS Administrator to review the SAP Knowledge Base Article below, which contains general information on what are the requirements to be able to successfully connect to an SAP System from Crystal Reports:
        
            1615056 - How to connect to SAP datasources from Crystal Reports?

Keywords

CR, SAP IK , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016