CSV download for Saved search is returning error in Kibana

curiousmind · April 15, 2021, 2:25am

Opendistro version 1.12.0
When I try to download “saved search” in Kibana, it gives me an error in the UI as shown in the below picture.

any idea why this might be happening?

jasonrojas · April 16, 2021, 11:33pm

I was just looking into this too.
Looks like there are similar reports here:

github.com/opendistro-for-elasticsearch/kibana-reports

Error in CSV report

opened 08:17AM - 19 Feb 21 UTC

closed 07:12PM - 13 May 21 UTC

Artain

bug

## Version Opendistro Elasticsearch 1.13.0 standalone linux Opendistro Kibana …1.13.0 standalone linux ## Error description If the saved discover table includes a null value the csv export will fail with the error message: ``` [08:16:09.781] [error][opendistroReportsKibana][plugins] Failed to generate report: TypeError: Cannot read property 'toString' of null log [08:16:09.782] [error][opendistroReportsKibana][plugins] TypeError: Cannot read property 'toString' of null at sanitize (/srv/opendistroforelasticsearch-kibana/plugins/opendistroReportsKibana/server/routes/utils/dataReportHelpers.ts:227:18) at getEsData (/srv/opendistroforelasticsearch-kibana/plugins/opendistroReportsKibana/server/routes/utils/dataReportHelpers.ts:172:34) at convertEsDataToCsv (/srv/opendistroforelasticsearch-kibana/plugins/opendistroReportsKibana/server/routes/utils/savedSearchReportHelper.ts:266:18) at generateReportData (/srv/opendistroforelasticsearch-kibana/plugins/opendistroReportsKibana/server/routes/utils/savedSearchReportHelper.ts:151:10) at process._tickCallback (internal/process/next_tick.js:68:7) error [08:16:07.104] Error: Internal Server Error at HapiResponseAdapter.toError (/srv/opendistroforelasticsearch-kibana/src/core/server/http/router/response_adapter.js:132:19) at HapiResponseAdapter.toHapiResponse (/srv/opendistroforelasticsearch-kibana/src/core/server/http/router/response_adapter.js:86:19) at HapiResponseAdapter.handle (/srv/opendistroforelasticsearch-kibana/src/core/server/http/router/response_adapter.js:81:17) at Router.handle (/srv/opendistroforelasticsearch-kibana/src/core/server/http/router/router.js:164:34) at process._tickCallback (internal/process/next_tick.js:68:7) ```

CyberGod · July 14, 2021, 7:08pm

Issue fixed and merged to OpenDistro Reporting dev branch(not released), as well as released with Openseach-Dashboards 1.0 @jasonrojas @curiousmind

Topic		Replies	Views
CSV Reporting Error if any date field has null values - OpenSearch Version 2.15 - Reporting Plugin releases , discuss , troubleshoot	0	49	July 19, 2024
Internal Server Error when using Reporting Reporting Plugin	1	1354	May 10, 2021
Reporting plugin throwing error in kibana Reporting Plugin	3	702	March 13, 2023
CSV Export Of Logs Open Source Elasticsearch and Kibana	5	8040	January 22, 2021
CSV report from discover security problem Security	4	449	April 19, 2021

CSV download for Saved search is returning error in Kibana

Related topics