# CSV Report generation fails with large KQL query
**URL:** https://discuss.elastic.co/t/csv-report-generation-fails-with-large-kql-query/245636
**Category:** Kibana
**Tags:** elastic-stack-reporting, kql-kibana-query-language
**Created:** [August 19, 2020, 3:27pm UTC](https://discuss.elastic.co/t/csv-report-generation-fails-with-large-kql-query/245636 "2020-08-19T15:27:11Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@tomervain](https://discuss.elastic.co/u/tomervain)
#### Post date: [August 19, 2020, 3:27pm UTC](https://discuss.elastic.co/t/csv-report-generation-fails-with-large-kql-query/245636/1 "2020-08-19T15:27:11Z")
Hello,
I am running Elasticsearch + Kibana 7.8.0 on a virtual machine, everything in the cluster is operating fine with no issues.
In the last few days, I was trying to run a long query (written in KQL) in the search bar (Discover), showing my good results after taking a while to process and I got the warning that it is capturing results beyond the regular timeout.
After rendering all results, I wanted to generate and download a CSV report as I usually do, only to be prompted with a failure message (after 3 attempts) after it reached timeout.
The number of hits in the results wasn't that large to be an issue and I also tried a shorter time range with no success.
Then I tried to change the xpack.reporting configuration, setting:
`xpack.reporting.queue.timeout` from 120000 (default) to 300000 and 600000, still getting the same failure as before (but with longer queue processing time).
I suspect it may be something to do with generating a report with a "heavy" KQL query, but I am not sure.
If there is any additional debugging to do or some insights about this issue, please help to solve it.
Thanks.
---
### Author:  [@myasonik](https://discuss.elastic.co/u/myasonik)
#### Post date: [August 20, 2020, 9:11pm UTC](https://discuss.elastic.co/t/csv-report-generation-fails-with-large-kql-query/245636/2 "2020-08-20T21:11:36Z")
Hey @tomervain, this sounds a lot like a bug report which are super useful!
If you could, collect whatever logs or browser errors Kibana and ES might be spitting out and file a bug report in [Kibana on Github](https://github.com/elastic/kibana/issues/new?template=Bug_report.md).
Tagging your issue with "bug", "triaged\_needed", "Feature:Reporting", and "Team:Reporting Services" will get it the quickest attention.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [September 17, 2020, 9:11pm UTC](https://discuss.elastic.co/t/csv-report-generation-fails-with-large-kql-query/245636/3 "2020-09-17T21:11:38Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.