# Large CSV export issue

**URL:** <https://discuss.elastic.co/t/large-csv-export-issue/245976>\
**Category:** Kibana\
**Created:** [August 22, 2020, 8:08am UTC](https://discuss.elastic.co/t/large-csv-export-issue/245976 "2020-08-22T08:08:53Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![adnanahmed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adnanahmed/32/45836_2.png) [@adnanahmed](https://discuss.elastic.co/u/adnanahmed)\
**Post date:** [August 22, 2020, 8:08am UTC](https://discuss.elastic.co/t/large-csv-export-issue/245976/1 "2020-08-22T08:08:53Z")

</div>

Hi Friends,

we are using ELK 7.9 version. We are having problem with CSV export of "Saved search" through our Dashboard, it got hanged if size of CSV gets more than 150 MB nevertheless we are able to export csv when we are exporting saved search from discover (not a dashboard widget).  
kibana.yml parameters

server.maxPayloadBytes: 10485760  
xpack.reporting.queue.timeout: 3600000  
xpack.reporting.csv.maxSizeBytes: 400000000  
elasticsearch.requestTimeout: 30000000  
xpack.reporting.csv.scroll.size: 1500  
xpack.reporting.csv.scroll.duration: 8m  
kibana.autocompleteTimeout: 1000000  
kibana.autocompleteTerminateAfter: 100000000

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [August 24, 2020, 3:51pm UTC](https://discuss.elastic.co/t/large-csv-export-issue/245976/2 "2020-08-24T15:51:20Z")

</div>

Have you tried the debugging steps indicated in our `Reporting troubleshooting`? [https://www.elastic.co/guide/en/kibana/current/reporting-troubleshooting.html#reporting-troubleshooting-system-requirements](https://www.elastic.co/guide/en/kibana/current/reporting-troubleshooting.html#reporting-troubleshooting-system-requirements)

What error message are you seeing, exactly?

How much memory does Kibana have access to, is it the default 1Gb?

---

<div class="post-metadata">

**Author:** ![adnanahmed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adnanahmed/32/45836_2.png) [@adnanahmed](https://discuss.elastic.co/u/adnanahmed)\
**Post date:** [August 26, 2020, 11:24am UTC](https://discuss.elastic.co/t/large-csv-export-issue/245976/3 "2020-08-26T11:24:27Z")

</div>

Hi Wylie Conlon,

Thanks for your reply.

when csv download start it says " your csv download will start momentarily" while after 6 minutes it came up with msg "we couldnot download csv this time.

kibana memory allocation is 4GB (4096 MB).

Moreover when we put limit on csv size for say 100 MB csv downloads successfully with partial data with in applied limit of 100 MB but when we exceed this limit to 200 MB it stuck up processing and failed as stated before.

---

<div class="post-metadata">

**Author:** ![wylie](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/wylie/32/81794_2.png) [@wylie](https://discuss.elastic.co/u/wylie)\
**Post date:** [August 26, 2020, 3:16pm UTC](https://discuss.elastic.co/t/large-csv-export-issue/245976/4 "2020-08-26T15:16:26Z")

</div>

Are you sure that Kibana has access to the full 4Gb of memory? There is a node setting that you may need to configure: [https://www.elastic.co/guide/en/kibana/current/production.html#memory](https://www.elastic.co/guide/en/kibana/current/production.html#memory)

---

<div class="post-metadata">

**Author:** ![adnanahmed](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/adnanahmed/32/45836_2.png) [@adnanahmed](https://discuss.elastic.co/u/adnanahmed)\
**Post date:** [August 27, 2020, 10:09am UTC](https://discuss.elastic.co/t/large-csv-export-issue/245976/5 "2020-08-27T10:09:45Z")

</div>

Yes Wylie,

we have it configured, see screenshot.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/e/fe96586d25f3397914e167247567b5564a3a3058.png)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [September 24, 2020, 10:09am UTC](https://discuss.elastic.co/t/large-csv-export-issue/245976/6 "2020-09-24T10:09:47Z")

</div>

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