Report not working

Hey,

I checked other entries but none matched my problem/version.
I have two systems, both using the opendistro docker images 1.13.2 for elasticsearch and kibana.
One i did a fresh install on, there the reports are working. But on the other system i updated from 1.1.0, there the reports are not working. I have some errors, but according to other posts from different sources (stackoverflow, …) these can be ignored.
These are e.g.:
{“type”:“log”,"@timestamp":“2021-07-23T08:01:32Z”,“tags”:[“error”,“elasticsearch”,“data”],“pid”:1,“message”:"[version_conflict_engine_exception]: [search-telemetry:search-telemetry]: version conflict, required seqNo [8901], primary term [7]. current document has seqNo [8902] and primary term [7]"}
{“type”:“log”,"@timestamp":“2021-07-23T08:04:31Z”,“tags”:[“error”,“elasticsearch”,“data”],“pid”:1,“message”:"[illegal_argument_exception]: request [/_license] contains unrecognized parameter: [accept_enterprise]"}

The report generation starts, but it never finishes. In the log i see after a long time that the report is finished, but I can never download it.
{“type”:“response”,"@timestamp":“2021-07-23T08:01:46Z”,“tags”:,“pid”:1,“method”:“get”,“statusCode”:200,“req”:{“url”:"/api/reporting/generateReport/yLli0noBQIvN2Jb0KJ_z?timezone=Europe%2FZurich",“method”:“get”,“headers”:{“host”:“10.180.226.198:5601”,“user-agent”:“Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0”,“accept”:"/",“accept-language”:“en-US,en;q=0.5”,“accept-encoding”:“gzip, deflate, br”,“referer”:“https://10.180.226.198:5601/app/opendistro_kibana_reports",“content-type”:“application/json”,“kbn-version”:“7.10.2”,“connection”:“keep-alive”,“securitytenant”:"user”},“remoteAddress”:“10.180.224.15”,“userAgent”:“Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0”,“referer”:“https://10.180.226.198:5601/app/opendistro_kibana_reports"},“res”:{“statusCode”:200,“responseTime”:368025,“contentLength”:9},“message”:"GET /api/reporting/generateReport/yLli0noBQIvN2Jb0KJ_z?timezone=Europe%2FZurich 200 368025ms - 9.0B”}

I can open the dashboard I want to have the report about and it does not take very long to open.

I hope you have any hints on how to solve this problem.

BR,
Lukas

@reporting-team Thoughts on this one?

Bump

If anybody has ideas on this, please post them…

@v05
Hi, just want to clarity your issue first.
You said “after upgrade, there are reports not working.” The error log you posted can be ignored, you are right. I wonder if the “reports take too long to generate” is what you mean by “reports not working”?

1 Like

Hey @CyberGod,
Thank you for your reply!
When I want to create a report in the webinterface, I can’t download the report. In the log file I see that the generation of the report takes very long:
{“host”:“10.180.226.198:5601”,“user-agent”:“Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0”,“accept”:"/",“accept-language”:“en-US,en;q=0.5”,“accept-encoding”:“gzip, deflate, br”,“referer”:“https://10.180.226.198:5601/app/opendistro_kibana_reports",“content-type”:“application/json”,“kbn-version”:“7.10.2”,“connection”:“keep-alive”,“securitytenant”:"user”},“remoteAddress”:“10.180.224.15”,“userAgent”:“Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:68.0) Gecko/20100101 Firefox/68.0”,“referer”:“https://10.180.226.198:5601/app/opendistro_kibana_reports"},“res”:{“statusCode”:200,“responseTime”:368025,“contentLength”:9},“message”:"GET /api/reporting/generateReport/yLli0noBQIvN2Jb0KJ_z?timezone=Europe%2FZurich 200 368025ms - 9.0B”}

I hope that makes it clear.

Got you. I saw the response time is 368025ms and contains 9.0 B data, which doesn’t make sense. I never seen this kind of issue before. But could your do the following things to help us debug?

  1. Does it fail for all types of reports? csv, png and pdf for all sources (Dashboards/visualize/Discover page)
  2. Can you go the reporting homepage and see if there’s a record being genereted in the table? Even tho you didn’t get it from browser, but since the 200 is returned, I think there will be a record being added to ES. If you download from the menu button on Dashboard page, it should be named as “on-demand report-xxx”. Please also try download the report again from there
1 Like

Holy moly. That’s a 2/3 of a byte a MINUTE.

Both pdf and png reports are not working.
An entry gets created in the Reports as well as in the Report definitions section on the reports page.
If I create a on demand report directly from the Dashboard page it also is not working. I see the “Generating report” popup, but it never finishes.

No hints on this one? I have the impression that the problem is the upgrade from a former version to the most recent. Can it be that the data in one of the opendistro indexes is wrong/did not migrate properly?