No data after CSV Export - Kibana

Elastic Stack Kibana
1

Continuing the discussion from Reporting - CSV Export: contains partial data:

Hi Team,

currently we are facing two issues related to csv Export.

  1. If index is frozen then how to export data in csv as we are getting empty data in csv.
  2. If index is not frozen still we are getting empty data in csv.

Sometime we get data/partial data in csv.

Could you please provide solution for this issue.

Note:- We are using kibana 7.9.3.

2

Hey @krish0608 ,

Thanks for bumping the topic.

Could you maybe provide a bit more context for your problem?

  1. Do you have a CSV heading with column names when there is no data in the resulting CSV?
  2. Are you trying to export all the possible fields? Or is it some limited number of the fields/columns?
  3. Is there a chance that some of the records/documents contain large chunks of data?
  4. What value do you have in xpack.reporting.csv.maxSizeBytes?
  5. Did you see any errors/warnings in the Elasticsearch logs around the time you triggered report generation?
  6. When you get some occasional non-empty CSV reports, what is their size?

Thanks in advance for your reply.

Best regards,
Mike

3

Hi @dokmic Preformatted text

  1. 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.

  2. 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)

  3. 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.

  4. 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.

  1. 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.

  1. 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.!

MicrosoftTeams-image
MicrosoftTeams-image807×119 3.7 KB

4

Hi Team,

Any Update??

5

can someone help me regarding it??

6

Hi, there are a few known issues which you can check into and see if yours is related:

7

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.