# CSV Export fails after size exceeds threshold

**URL:** <https://discuss.elastic.co/t/csv-export-fails-after-size-exceeds-threshold/150869>\
**Category:** Kibana\
**Created:** [October 3, 2018, 11:09am UTC](https://discuss.elastic.co/t/csv-export-fails-after-size-exceeds-threshold/150869 "2018-10-03T11:09:12Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![georgeRD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/georgerd/32/77165_2.png) [@georgeRD](https://discuss.elastic.co/u/georgeRD)\
**Post date:** [October 3, 2018, 11:09am UTC](https://discuss.elastic.co/t/csv-export-fails-after-size-exceeds-threshold/150869/1 "2018-10-03T11:09:12Z")

</div>

Hi all,

We're running an Elasticsearch/Kibana installation v. 6.2.3, with x-pack basic license activated. CSV exports are executed successfully up to a certain file size (~800KB). If the columns or rows are increased in the search to export, the export fails after 3 attempts. We suspected this was due to timeouts so we increased the timeout and file size settings in kibana.yml but the issue persists. Current settings available below:

xpack.reporting.queue.pollInterval: 60000  
xpack.reporting.queue.timeout: 240000  
xpack.reporting.csv.maxSizeBytes: 52428800

Additional plugins running:

- own\_home
- searchguard

The successful exports are ready in just a few seconds. We cannot find anything peculiar in the kibana logs, searching for csv we can view the requests at the reporting api.

Any ideas are more than welcome.

---

<div class="post-metadata">

**Author:** ![georgeRD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/georgerd/32/77165_2.png) [@georgeRD](https://discuss.elastic.co/u/georgeRD)\
**Post date:** [October 3, 2018, 4:27pm UTC](https://discuss.elastic.co/t/csv-export-fails-after-size-exceeds-threshold/150869/2 "2018-10-03T16:27:20Z")

</div>

Following some further investigation, we ended up with the following:

- the issue was related to own\_home, which uses hapijs to load a proxy server between Kibana and Elasticsearch
- hapijs by default restricts payloads up to 1MB, so exports larger than that were doomed to fail
- the solution was to change init\_proxy.js in own\_home to allow for larger payloads.

This thread can be considered closed.

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [October 3, 2018, 4:43pm UTC](https://discuss.elastic.co/t/csv-export-fails-after-size-exceeds-threshold/150869/3 "2018-10-03T16:43:14Z")

</div>

Great , Thanks for posting the conclusion you arrived at.

Cheers  
Rashmi

---

<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:** [October 31, 2018, 4:43pm UTC](https://discuss.elastic.co/t/csv-export-fails-after-size-exceeds-threshold/150869/4 "2018-10-31T16:43:15Z")

</div>

Closed on October 31, 2018, 4:43pm UTC

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