SAP Knowledge Base Article - Public

1220084 - Error: "Connection closed without message", when refreshing a report based on an SAP data source in Crystal Reports

Symptom

  • Error: Connection closed without message.
        
  • When attempting to view a report, it displays an error, and returns no data.
       
  • When refreshing a report based on an SAP datasource, like SAP ECC, ERP,... it fails with the error:
    "Database Connector Error: Connection closed without message (CM_NP_DATA_RECEIVED)"
        
  • When enabling tracing for the OpenSQL database driver, the following error message is logged in the file db_opensql_xxxx.log:
    "SAP: Received return code 6 from RfcWaitForRequest. This is an error. Message connection closed without message (CM_NO_DATA_RECEIVED)"

  • A system dump is generated on the SAP System side whenever this report is run. In Transaction: ST22, the system dumps reference the following keyword: TSV_TNEW_PAGE_ALLOC_FAILED

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
          
  • SAP Netweaver 7.x

Reproducing the Issue

  1. In Crystal Reports, create a new report, using the connection: "SAP Table, Cluster, or Function"
  2. Select the SAP System to connect to, and enter the user credentials.
  3. Select a table, then add a couple of database fields to the report.
  4. When refershing the report, it fails with the error:
        
    "Database Connector Error: Connection closed without message (CM_NP_DATA_RECEIVED)"

Cause

  • The SAP System fails due to a memory allocation.  It is likely that more memory is required on the SAP Server to process the fetched data.
  • A second cause for this error will be the SAP System has a time out to limit for how long an application can run, and if this time out is reach it will stop the process.

Resolution

  • For Memory Allocation issue on SAP Netweaver:
    • Contact your SAP BASIS Administrator to increase the SAP System memory allocation.
         
        
  • For SAP Netweaver Time out:
    • Contact your SAP BASIS Administrator to increase the time out on SAP Netweaver; or
    • A potential solution will be to execute the report in Batch Mode on SAP Netweaver.
      To configure the SAP BusinessObjects BI Server to run SAP data source reports in Batch Mode in SAP Netweaver, see the SAP Knowledge Base Article 1396581

Keywords

CR, SAP Table, No data, CM_NP_DATA_RECEIVED , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016