opensearch dashboards report generate is not working

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):

opensearch-dashboards:v2.3.0

Describe the issue:

All OpenSearch pods are up and running:

But OpenSearch dashboards report generate is not working

When try to generate report we are seeing attached error screen and attached logs.

In pod we are seeing error like “no handler found for uri [/_plugins/_reports/on_demand” as below.

[“error”,“plugins”,“reportsDashboards”],“pid”:7,“message”:"Failed to generate report: no handler found for uri [/_plugins/_reports/on_demand]

We are just trying to understand is there any configuration missing while installing occne or open search.

Or is there any pre-request steps need to do before generating report.

even Create report definition also giving same kind of error.

Configuration:

Relevant Logs or Screenshots:

{“type”:“response”,“@timestamp”:“2024-01-29T08:11:06Z”,“tags”:,“pid”:7,“method”:“get”,“statusCode”:404,“req”:{“url”:“/api/v1/multitenancy/tenant”,“method”:“get”,“headers”:{“host”:“10.75.229.123”,“connection”:“keep-alive”,“accept”:“/”,“pragma”:“no-cache”,“accept-language”:“en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7,zh-TW;q=0.6”,“osd-xsrf”:“reporting”,“user-agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36”,“content-type”:“application/json”,“referer”:“http://10.75.229.123/cne-23-4-rc2/dashboard/app/discover",“accept-encoding”:"gzip, deflate”},“remoteAddress”:“10.233.87.192”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36”,“referer”:“http://10.75.229.123/cne-23-4-rc2/dashboard/app/discover"},“res”:{“statusCode”:404,“responseTime”:3,“contentLength”:9},“message”:"GET /api/v1/multitenancy/tenant 404 3ms - 9.0B”}
{“type”:“log”,“@timestamp”:“2024-01-29T08:11:06Z”,“tags”:[“error”,“plugins”,“reportsDashboards”],“pid”:7,“message”:“Failed to generate report: no handler found for uri [/_plugins/_reports/on_demand] and method [PUT] :: {"path":"/_plugins/_reports/on_demand","query":{},"body":"{\"beginTimeMs\":1706514965951,\"endTimeMs\":1706515865951,\"reportDefinitionDetails\":{\"id\":\"f3b048f0-be7d-11ee-88ed-a3bf25ceb5b1\",\"lastUpdatedTimeMs\":1706515866367,\"createdTimeMs\":1706515866367,\"reportDefinition\":{\"name\":\"On_demand_report\",\"isEnabled\":true,\"source\":{\"description\":\"In-context report download\",\"type\":\"SavedSearch\",\"id\":\"3ed780c0-bb5c-11ee-9063-c9d0bcd9d8b1\",\"origin\":\"http://0.0.0.0:5601/cne-23-4-rc2/dashboard\\\“},\\\“format\\\”:{\\\“duration\\\”:\\\“PT15M\\\”,\\\“fileFormat\\\”:\\\“Csv\\\”,\\\“limit\\\”:10000},\\\“trigger\\\”:{\\\“triggerType\\\”:\\\“Download\\\”},\\\“delivery\\\”:{\\\“configIds\\\”:[\\\”\\\“],\\\“title\\\”:\\\”\\\“,\\\“textDescription\\\”:\\\”\\\“,\\\“htmlDescription\\\”:\\\”\\\“}}},\\\“status\\\”:\\\“Success\\\”,\\\“inContextDownloadUrlPath\\\”:\\\”/app/discover#/view/3ed780c0-bb5c-11ee-9063-c9d0bcd9d8b1?_g=(filters:!(),refreshInterval:(pause:!t,value:0),time:(from:‘2024-01-29T07:56:05.951Z’,to:‘2024-01-29T08:11:05.951Z’))&_a=(columns:!(_source),filters:!(),index:de087b30-afa0-11ee-9063-c9d0bcd9d8b1,interval:auto,query:(language:kuery,query:‘’),sort:!())\"}","statusCode":400,"response":"{\"error\":\"no handler found for uri [/_plugins/_reports/on_demand] and method [PUT]\"}"}”}
{“type”:“log”,“@timestamp”:“2024-01-29T08:11:06Z”,“tags”:[“error”,“plugins”,“reportsDashboards”],“pid”:7,“message”:“StatusCodeError: no handler found for uri [/_plugins/_reports/on_demand] and method [PUT]\n at respond (/usr/share/opensearch-dashboards/node_modules/elasticsearch/src/lib/transport.js:349:15)\n at checkRespForFailure (/usr/share/opensearch-dashboards/node_modules/elasticsearch/src/lib/transport.js:306:7)\n at HttpConnector. (/usr/share/opensearch-dashboards/node_modules/elasticsearch/src/lib/connectors/http.js:173:7)\n at IncomingMessage.wrapper (/usr/share/opensearch-dashboards/node_modules/lodash/lodash.js:4991:19)\n at IncomingMessage.emit (events.js:412:35)\n at endReadableNT (internal/streams/readable.js:1333:12)\n at processTicksAndRejections (internal/process/task_queues.js:82:21) {\n status: 400,\n displayName: ‘BadRequest’,\n path: ‘/_plugins/_reports/on_demand’,\n query: {},\n body: {\n error: ‘no handler found for uri [/_plugins/_reports/on_demand] and method [PUT]’\n },\n statusCode: 400,\n response: ‘{"error":"no handler found for uri [/_plugins/_reports/on_demand] and method [PUT]"}’,\n toString: [Function (anonymous)],\n toJSON: [Function (anonymous)]\n}”}
{“type”:“response”,“@timestamp”:“2024-01-29T08:11:06Z”,“tags”:,“pid”:7,“method”:“post”,“statusCode”:400,“req”:{“url”:“/api/reporting/generateReport?timezone=Asia%2FCalcutta&dateFormat=MMM%20D%2C%20YYYY%20%40%20HH%3Amm%3Ass.SSS&csvSeparator=%2C”,“method”:“post”,“headers”:{“host”:“10.75.229.123”,“connection”:“keep-alive”,“content-length”:“881”,“accept”:“/”,“pragma”:“no-cache”,“accept-language”:“en-US,en;q=0.9,zh-CN;q=0.8,zh;q=0.7,zh-TW;q=0.6”,“osd-xsrf”:“reporting”,“user-agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36”,“content-type”:“application/json”,“origin”:“http://10.75.229.123”,“referer”:“http://10.75.229.123/cne-23-4-rc2/dashboard/app/discover",“accept-encoding”:"gzip, deflate”},“remoteAddress”:“10.233.87.192”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36”,“referer”:“http://10.75.229.123/cne-23-4-rc2/dashboard/app/discover"},“res”:{“statusCode”:400,“responseTime”:20,“contentLength”:9},“message”:"POST /api/reporting/generateReport?timezone=Asia%2FCalcutta&dateFormat=MMM%20D%2C%20YYYY%20%40%20HH%3Amm%3Ass.SSS&csvSeparator=%2C 400 20ms - 9.0B”}
{“type”:“log”,“@timestamp”:“2024-01-31T06:46:11Z”,“tags”:[“error”,“plugins”,“reportsDashboards”],“pid”:7,“message”:“Failed to create report definition: no handler found for uri [/_plugins/_reports/definition] and method [POST] :: {"path":"/_plugins/_reports/definition","query":{},"body":"{\"reportDefinition\":{\"name\":\"Provisioninglogs\",\"isEnabled\":true,\"source\":{\"description\":\"Provisioning logs\",\"type\":\"SavedSearch\",\"id\":\"3ed780c0-bb5c-11ee-9063-c9d0bcd9d8b1\",\"origin\":\"http://0.0.0.0:5601/cne-23-4-rc2/dashboard\\\“},\\\“format\\\”:{\\\“duration\\\”:\\\“PT732H11M26.333S\\\”,\\\“fileFormat\\\”:\\\“Csv\\\”,\\\“limit\\\”:10000},\\\“trigger\\\”:{\\\“triggerType\\\”:\\\“OnDemand\\\”},\\\“delivery\\\”:{\\\“configIds\\\”:[],\\\“title\\\”:\\\”\\\“,\\\“textDescription\\\”:\\\”\\\“,\\\“htmlDescription\\\”:\\\”\\\“}}}\”,\“statusCode\”:400,\“response\”:\"{\\\“error\\\”:\\\"no handler found for uri [/_plugins/_reports/definition] and method [POST]\"}"}”}
{“type”:“response”,“@timestamp”:“2024-01-31T06:46:11Z”,“tags”:,“pid”:7,“method”:“post”,“statusCode”:400,“req”:{“url”:“/api/reporting/reportDefinition”,“method”:“post”,“headers”:{“host”:“10.75.229.123”,“connection”:“keep-alive”,“content-length”:“464”,“user-agent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36”,“osd-version”:“2.3.0”,“content-type”:“application/json”,“accept”:“/”,“origin”:“http://10.75.229.123”,“referer”:“http://10.75.229.123/cne-23-4-rc2/dashboard/app/reports-dashboards",“accept-encoding”:"gzip, deflate”,“accept-language”:“en-US,en;q=0.9”},“remoteAddress”:“10.233.122.128”,“userAgent”:“Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/121.0.0.0 Safari/537.36”,“referer”:“http://10.75.229.123/cne-23-4-rc2/dashboard/app/reports-dashboards"},“res”:{“statusCode”:400,“responseTime”:21,“contentLength”:9},“message”:"POST /api/reporting/reportDefinition 400 21ms - 9.0B”}

Hi Team, Any updates on this?

Hello @pmhanaga ,
I just worked through an issue vaguely related.
My issue was users couldnt generate / download CSV exports via the reports plugin.

My solution was:

  1. duplicate the reports_full_access “role” as company_reports_full_access
  2. Edit company_reports_full_access role - goto “index permissions”, For “Index” add the indexes/aliases they use (or put * or whatever), For “Index permission” add the single permission of indices:monitor/settings/get
  3. Click Update (to save changes)
  4. Now click on company_reports_full_access and then “Mapped Users” and map your users / backend roles etc.

Now that solution doesnt directly correspond with your error message but it might get you moving forward in the right direction.

Good luck.