Customer has CRM 2020R2. Running a report called Person List by Company. I think it's a standard one. Either way it isn't a complex report. The customer wants a list of all person records out, to include their name, company name, contact email address, person title, and the primary user on the person record. So 5 fields. Searching on company name, sorting on person last name, no grouping.

Run the report with any or no search criteria and it runs to the screen no problem. PDF, no problem. Excel, problem. Logs show this:

START - doEndpointPost URL: localhost:443/.../spreadsheetTask
FINISHED - doEndpointPost time-taken: 120375ms. HTTP status code: -1
ERROR generating excel file. HTTP status:200 Message: The connection with the server was terminated abnormally
1 ERROR generating excel file. Message - Error generating report. .

In the temporary report files, when I run the report, the XML file is generating properly and if I copy it and open it in Excel, it opens. But if I run it to export tot Excel from CRM, it fails. Just to note, Excel opens with a product activation warning saying the product has not been activated. I have asked the customer to resolve that. It is Excel 2016 32bit. Anything else I should check?

The desktop size limit was increased from 2048kb to 65535kb. Reports query and build timeouts increased from 60 and 90 to 240 respectively. Max memory for report generator was 512mb. Tried 256mb and also 1024mb.