Symptom
You are trying to export a report to XLSX or XML format, you receive an error message after the report is loaded:
- Report cannot be opened; report an case
- Failed to open report "Internal Server Error" - report an case.
You may also get the same error Message when you send the report as E-Mail Attachments a Xlsx or XML format. In both cases no report data is displayed and you can only close the report screen.
Environment
- SAP Cloud for Customer
- SAP Business By Design
Reproducing the Issue
Scenario One:
- Go to the Work Center Business Analytics.
- Go to the View Design Report.
- Find and Execute the report you would like to download.
- Click on the "Share" icon and select "Report in Microsoft Excel in XML Format"
Scenario Two:
- Go to the Work Center Business Analytics.
- Go to the View Design Report.
- Find and Open the report you would like to send as E-Mail Attachments a Xlsx or XML format.
- Click on the "Share" icon and select "As Email Link (Microsoft Excel in XML Format)"
- Add a valid E-Mail address.
In both cases after some time the following error message shows up: Report cannot be open - please report an case.
Cause
In many cases the cause is due to the huge data that is being fetched in the report and that leads to a time out.
Report has more formatting information so the file size becomes big and during processing it leads to memory issues and these reported dumps are encountered.
If it is a custom report (possibly based on a custom data source), the modeling of that report or the data source may not be optimal.
Resolution
To avoid the Dump (time out) use the following options:
- Use CSV Format and open it in Excel for the same amount of data. In case it is needed to see the data in XML or XLXS format, please reduce the amount of records with a selection on some variables in the report to limit the data.
- If you need to send the report as an E-Mail Attachment, broadcast the report and choose the CSV format.
- Reduce the report data by adding variables in the report selection.
- For custom data sources and reports, it is strongly recommended that they adhere to the best practices of modeling analytical objects. You will find a complete list in the KBA 2366796 - Best Practices for Modelling Data Sources and Reports - Performance . If you need assistance with optimising your reports, please contact your implementation partner.
Keywords
xlsx format, XML format, Export report, send Report as E-Mail attachment, Report cannot be opened, report an case, , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To