SAP Knowledge Base Article - Public

2987175 - Error: 'No more memory available to add rows to an internal table.' when refreshing a report based on SAP data source in Crystal Reports

Symptom

  • Error: 'No more memory available to add rows to an internal table.' 
  • When refreshing a report based on SAP Table in Crystal Reports, it fails with the error.
  • In another environment, the same report based on SAP Table refresh successfully in Crystal Reports.
  • When refreshing a report in Crystal Reports based on SAP Table, Cluster or Function, it fail with the error:
      
      "Failed to execute query: 'No more memory available to add rows to an internal table.' 
       Redesign your query or contact the data source maintainer to solve the problem."

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
          
  • SAP NetWeaver 7.4
  • SAP NetWeaver 7.5

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 refreshing the report, it fails with the error:  "No more memory available to add rows to an internal table."    

Cause

  • The SAP System fails due to not enough memory to process the data. More memory is required on the SAP System to process the fetched data.
           
  • In more details: When the report is executed, a system dump is generated on the SAP System side.
    In transaction: ST22, the system dumps reference a memory allocation error. The issue is not on the Crystal Reports side, but on the SAP System side.    

Resolution

Contact your SAP BASIS Administrator to increase the SAP System memory allocation.

See Also

2840590 - Troubleshooting SAP Memory Dumps - Guided Answers

Keywords

CR , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BC-CST-MM , Memory Management , Problem

Product

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