njain213
(Naman Jain)
November 30, 2021, 10:28am
1
Hi Team,
On follow up on below issue can anyone help me out?
Hello Team,
In reference to No data after CSV Export - Kibana
I am also facing exact same issue. Could you please help me in fixing it?
Note:- I am using kibana 7.9.3.
Hi,
I've seen Marco has already tried helping you. I have a few more questions to help us understand what's going on:
You say you're getting this for all indices. Did you mean - index patterns?
Can you try creating a non-timebased index pattern, ie. an index pattern without a date field?
Does the issue happen with just the default _source
column selected?
Can you c/p request and response from Discover? (In the Inspect
tab) Feel free to redact all the data you wish to keep private
njain213
(Naman Jain)
December 1, 2021, 11:39am
3
Thanks for your reply @majagrubic
Yes I mean index patterns. Yes issue happened with just default _source column selected. One strange thing I have observed today, when I selected date as 25th Nov I got data in CSV and when I selected 18th Nov again its blank CSV. I am using hot,warm, cold architecture. Is there something I am missing here?
Can you confirm you are seeing data in DIscover for the selected period, just not in the generated report?
njain213
(Naman Jain)
December 1, 2021, 2:18pm
5
Yes I can see data in Discover but not in CSV report.
tsullivan
(Tim Sullivan)
December 8, 2021, 7:24pm
7
Hi, there are a few known issues which you can check into and see if yours is related:
opened 04:28PM - 24 May 21 UTC
closed 10:30PM - 18 Aug 21 UTC
bug
feedback_needed
Feature:Reporting
loe:days
Team:AppServicesSv
impact:high
Hi,
We are running Kibana 7.12.0 on docker with a Nginx reverse proxy in fron… t of it.
The version of the Elastic cluster is also 7.12.0.
After I save the search in Discovery section and do Share, the status of the report shows as completed. However, the downloaded .csv contains only the name of the fields on the first row. The data shown in Discovery is not in the .csv.
These are the reporting settings in kibana.yml:
xpack.reporting.enabled: true
xpack.reporting.queue.timeout: 600000
xpack.reporting.kibanaServer.port: 443
xpack.reporting.kibanaServer.protocol: https
xpack.reporting.kibanaServer.hostname: 0.0.0.0
xpack.reporting.encryptionKey: "..."
xpack.reporting.csv.maxSizeBytes: 1048576000
xpack.reporting.csv.scroll.size: 1048576000
xpack.reporting.csv.scroll.duration: 10m
Can you help us identify the issues ?
Thank you
opened 02:32AM - 22 Jun 20 UTC
closed 12:47AM - 02 Mar 21 UTC
bug
feedback_needed
Feature:Reporting
Team:AppServicesSv
triaged
Team:Reporting Services
**Kibana version:**
7.7.1
**Elasticsearch version:**
7.7.1
**Server OS versi… on:**
Ubuntu 18.04
**Browser version:**
Google Chrome Version 83.0.4103.61
**Browser OS version:**
macOS Catalina 10.15.3
**Original install method (e.g. download page, yum, from source, etc.):**
Docker
**Describe the bug:**
Saved search exports an empty csv if an end time in the future is selected. This comes up when we use the commonly used date ranges like - Today, This Month.
**Steps to reproduce:**
1. Create a dashboard using a saved search
2. Set time range as `This Month`, or any range with a future end date
3. Download the table as csv. The csv will contain only headers, no data.
4. Change the end date to `now`
5. Again download the table as csv. The csv will contain data this time.
**Expected behavior:**
The csv should contain data even if the end date is in future.
**Screenshots (if relevant):**
Not relevant
**Errors in browser console (if relevant):**
No errors in browser.
**Provide logs and/or server output (if relevant):**
No error logs in server.
**Any additional context:**
First learned about the error [here](https://discuss.elastic.co/t/kibana-saved-search-exports-an-empty-csv-if-an-end-time-in-the-future-is-selected/233327)
opened 03:13PM - 08 Aug 19 UTC
closed 08:14PM - 12 Aug 19 UTC
bug
Feature:Reporting
**Kibana version:** 7.3.0
**Elasticsearch version:** 7.3.0
**Server OS ver… sion:** centos:7
**Browser version:** Chrome Version 76.0.3809.87 (Official Build) (64-bit)
**Browser OS version:** MacOS Mojave (Version 10.14.4)
**Original install method (e.g. download page, yum, from source, etc.):** docker.elastic.co/kibana/kibana:7.3.0
**Describe the bug:** Following the instructions in https://github.com/elastic/kibana/pull/34571, I enabled `xpack.reporting.csv.enablePanelActionDownload: true` in the config.
The `Download csv...` button now appears. For saved searches on index patterns with no time column defined the csv is generated fine. However for saved searches on index patterns with a time column the csv files are generated empty (the headers are there but no records, even though I do see rows in the dashboard).
**Steps to reproduce:**
1. Set `xpack.reporting.csv.enablePanelActionDownload: true` in config
2. Create an index pattern with a time column
3. Create a saved search on that index pattern
4. Create a dashboard with that saved search
5. Filter the time so that the dashboard have rows
6. Click on "..." for the saved search panel, and then on "Download csv"
**Expected behavior:**
The csv should have the same rows that the dashboard has.
@joelgriffith @tsullivan
njain213
(Naman Jain)
December 20, 2021, 9:36am
8
My issue is somewhat related to [Reporting] Saved search exports an empty csv if an end time in the future is selected. · Issue #69636 · elastic/kibana · GitHub
but in this link it is mentioned that if we select today or this week in timerange than issue comes but in my case it is coming for old data as well(infact mostly coming when I select last 7 days or 15 days or select particular old date.)
tsullivan
(Tim Sullivan)
December 20, 2021, 4:49pm
9
Hi Naman - which version are you on? 7.15?
tsullivan
(Tim Sullivan)
December 27, 2021, 6:27pm
11
Perhaps the quick ranges you are selecting, last 7 days or last 15 days, still selects an end date in the future.
Here's a key to the quick ranges:
last day: the time range goes from the beginning of today to the end of today (future date)
last 24 hours: the time range goes from 24 hours ago to now
I advise you to upgrade to the latest version. There are plenty of (fixed) bugs in older versions that have no workaround.
system
(system)
Closed
January 24, 2022, 6:27pm
12
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.