Unable to export large report (more 5000 rows) with grouping.

[vtsykun]

STR

• Create report with group by any field (not PK)
• Add count(ID) column to report
  
• report must have more 5000 rows
• export report datagrid

Actual result

Count of rows on csv file and datagrid is equals, but export ended partially, only 5000 first records of report was export correctly. The next 5000 (the next chunks) records are repeated/duplicate from beginning of report. There are not records of the last datagrid page in the result.

Expected result
CSV export and datagrid must be equals

[anyt]

Hi @vtsykun,
What version of oro platform are you using?

[vtsykun]

Hi @anyt
oro/platform 3.1.7

[anyt]

Thank you. As a workaround, you can change the batch size to the report rows count

# services.yml
parameters:
    oro_importexport.export.size_of_batch: 5000

[anyt]

Internal ticket id #BAP-18931