SAP Knowledge Base Article - Public

2142911 - Cannot Export Large Volume of Data to Excel

Symptom

You are not able to extract a large volume of data from the system to Excel.

Reproducing the Issue

  1. Go to Customers work center.
  2. Click on Accounts view.
  3. Select All in the dropdown list.
  4. Click on gear icon and then Export to Microsoft Excel.
  5. Click Download.
  6. A loading screen appears and after few minutes you will receive an error message similar to the following:
    "The website cannot display the page
    Internet Explorer cannot display the webpage
    HTTP 500 Internal Server Error
    500 SAP Internal Server Error"

Cause

The limit in "Export to excel" form data sets is not by number of rows. The reason why download fails is because of file size or memory dump.
If the file is too big then the session times out before the file can be downloaded.

Resolution

1. For Business By Design product  there is a restriction:

The export to excel functionality can handle export of data up to around 10 000 records.
You have to work with smaller data sets by adjusting the search parameters so that the creation of the spreadsheet is optimized.

  1. On the screen you are trying to export the data click on Show Advanced Filter.
  2. You have to apply more filtering criteria to reduce the total number of rows to around 10K so you can export the data required in chunks.
  3. Click on gear icon and then Export to Microsoft Excel.

2. In C4C 'to do mass data extraction recommendation is to use the Data Workbench (Workcenter in C4C) and there 'Export.' - It does the download in a background job. And break it into multiple files.

Keywords

KBA , LOD-CRM-EMP , Employee , How To

Product

SAP Business ByDesign all versions ; SAP Cloud for Customer add-ins all versions