SAP Knowledge Base Article - Public

1637505 - No data returns when refreshing reports based of an SAP data source in Crystal Reports

Symptom

  • No data returns when refreshing a report.    
  • Crystal Reports hangs, or returns no data.      
  • Reports based of one of the following SAP data source returns no data in Crystal Reports:
    • SAP BW Query,
    • Customer Relationship Management System (CRM), 
    • ECC,
    • ERP, 
    • SAP Table,
    • ABAP functions,
    • SAP R/3 Table

Environment

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

Reproducing the Issue

  1. Verify on the SAP System the Table, Function, or SAP BW Query returns data.
        
  2. In Crystal Reports, create a new report using the an SAP connection to the Table, Function, or SAP BW Query.
    For example: To connect to SAP Table, select the connection: SAP Table, Cluster, or Function.
      
  3. Add database fields to the Details section of the report.
       
  4. Refresh the report.
          
  5. The report returns no data, or hang.

Cause

  • The SAP Gateway configuration prevents Crystal Reports from retrieving data from the SAP System.
           
  • When looking at the Crystal Reports logs, you will notice the SAP Gateway connection to the SAP System fails with the error:

    SAP: Received return code 1 from RfcWaitForRequest. This is an error. Message CPIC-CALL: 'SAP_CMACCPTP : rc=20
       
    LOCATION  SAP-Gateway on host <Host Name>
    ERROR registration of tp <TP Name> from PROXY host <Host Name> not allowed
    TIME  <Date and Time>
    RELEASE <SAP Version>
    COMPONENT  SAP-Gateway
    VERSION  <Version Number>
    RC   <RC number>
    MODULE gwxxrd.c
    LINE   <Line Number>
    COUNTER  <Number>
       
    SAP: Data reader received error notification. Preparing to go out of scope.


    For information on how to create a log for Crystal Reports, see the SAP Knowledge Base Article: 1220085

Resolution

  • To resolve this issue, modify the SAP Gateway security to allow Crystal Reports to connect to the SAP System.
               
  • To update the SAP Gateway to allow your user, or computer, or external application to connect to the SAP System, contact your SAP BASIS Administrator. 
         
  • Additional Information:
    • Crystal Reports 2013, 2016 TP is: CRW32   
    • Crystal Reports 2020 TP is: CRW64
    • For information on how to configure the SAP Gateway, see SAP Note: 1408081 - Basic settings for reg_info and sec_info    
    • If you have any questions or issues setting security for the SAP Gateway, create a case for the SAP Gateway support, under the component: BC-CST-GW

Keywords

SP3, CR, CR Designer, SAP CRM, CRM, opensql, empty result, no data retrieve, SAP IK , 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