Do you have a CSV heading with column names when there is no data in the resulting CSV?
---- Yes, Also we have attached excel sheet for reference.
Are you trying to export all the possible fields? Or is it some limited number of the fields/columns?
--- When we apply filter and get certain data, we try to export all things(all columns that are coming in results)
Is there a chance that some of the records/documents contain large chunks of data?
------ Sometimes it happened but we are facing issue even with small data like 5-10 records.
What value do you have in xpack.reporting.csv.maxSizeBytes?
---- Current value : 1048576000
Previously we were using default value i.e. 10 MB. We then moved to 50 MB and issue didn't fixed so we moved to 100 MB and still issue exists.
Did you see any errors/warnings in the Elasticsearch logs around the time you triggered report generation?
-----I don't think so but not 100% sure.
When you get some occasional non-empty CSV reports, what is their size?
----its depends somestimes 100 kB, sometimes 1-2 MB but currently not getting any data in CSV not a single entry but every time we get CSV heading of all columns.!