Kibana can not generate CSV file ,it show internal server error

Dear all,

When i want to generate CSV file, it show internal server error .Below is log.

{"type":"response","@timestamp":"2023-12-05T18:59:23+08:00","tags":[],"pid":3078,"method":"post","statusCode":200,"req":{"url":"/api/ui_counters/_report","method":"post","headers":{"host":"10.192.104.33:5601","connection":"keep-alive","content-length":"150","dnt":"1","kbn-version":"7.13.3","user-agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0","kbn-system-request":"true","content-type":"application/json","accept":"*/*","origin":"http://10.192.104.33:5601","referer":"http://10.192.104.33:5601/app/discover","accept-encoding":"gzip, deflate","accept-language":"en-US,en;q=0.9"},"remoteAddress":"10.41.210.140","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0","referer":"http://10.192.104.33:5601/app/discover"},"res":{"statusCode":200,"responseTime":1032,"contentLength":15},"message":"POST /api/ui_counters/_report 200 1032ms - 15.0B"}
{"type":"log","@timestamp":"2023-12-05T18:59:28+08:00","tags":["error","plugins","reporting"],"pid":3078,"message":"ResponseError: validation_exception\n    at onBody (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@elastic/elasticsearch/lib/Transport.js:337:23)\n    at IncomingMessage.onEnd (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@elastic/elasticsearch/lib/Transport.js:264:11)\n    at IncomingMessage.emit (events.js:387:35)\n    at endReadableNT (internal/streams/readable.js:1317:12)\n    at processTicksAndRejections (internal/process/task_queues.js:82:21) {\n  meta: {\n    body: { error: [Object], status: 400 },\n    statusCode: 400,\n    headers: {\n      'content-type': 'application/json; charset=UTF-8',\n      'content-length': '381'\n    },\n    meta: {\n      context: null,\n      request: [Object],\n      name: 'elasticsearch-js',\n      connection: [Object],\n      attempts: 0,\n      aborted: false\n    }\n  }\n}"}
{"type":"log","@timestamp":"2023-12-05T18:59:28+08:00","tags":["error","plugins","reporting"],"pid":3078,"message":"ResponseError: validation_exception\n    at onBody (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@elastic/elasticsearch/lib/Transport.js:337:23)\n    at IncomingMessage.onEnd (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@elastic/elasticsearch/lib/Transport.js:264:11)\n    at IncomingMessage.emit (events.js:387:35)\n    at endReadableNT (internal/streams/readable.js:1317:12)\n    at processTicksAndRejections (internal/process/task_queues.js:82:21) {\n  meta: {\n    body: { error: [Object], status: 400 },\n    statusCode: 400,\n    headers: {\n      'content-type': 'application/json; charset=UTF-8',\n      'content-length': '381'\n    },\n    meta: {\n      context: null,\n      request: [Object],\n      name: 'elasticsearch-js',\n      connection: [Object],\n      attempts: 0,\n      aborted: false\n    }\n  }\n}"}
{"type":"log","@timestamp":"2023-12-05T18:59:28+08:00","tags":["error","http"],"pid":3078,"message":"ResponseError: validation_exception\n    at onBody (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@elastic/elasticsearch/lib/Transport.js:337:23)\n    at IncomingMessage.onEnd (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@elastic/elasticsearch/lib/Transport.js:264:11)\n    at IncomingMessage.emit (events.js:387:35)\n    at endReadableNT (internal/streams/readable.js:1317:12)\n    at processTicksAndRejections (internal/process/task_queues.js:82:21) {\n  meta: {\n    body: { error: [Object], status: 400 },\n    statusCode: 400,\n    headers: {\n      'content-type': 'application/json; charset=UTF-8',\n      'content-length': '381'\n    },\n    meta: {\n      context: null,\n      request: [Object],\n      name: 'elasticsearch-js',\n      connection: [Object],\n      attempts: 0,\n      aborted: false\n    }\n  }\n}"}
{"type":"error","@timestamp":"2023-12-05T18:59:28+08:00","tags":[],"pid":3078,"level":"error","error":{"message":"Internal Server Error","name":"Error","stack":"Error: Internal Server Error\n    at HapiResponseAdapter.toInternalError (/app/product/ki/kibana-7.13.3-linux-x86_64/src/core/server/http/router/response_adapter.js:61:19)\n    at Router.handle (/app/product/ki/kibana-7.13.3-linux-x86_64/src/core/server/http/router/router.js:177:34)\n    at runMicrotasks (<anonymous>)\n    at processTicksAndRejections (internal/process/task_queues.js:95:5)\n    at handler (/app/product/ki/kibana-7.13.3-linux-x86_64/src/core/server/http/router/router.js:124:50)\n    at exports.Manager.execute (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@hapi/hapi/lib/toolkit.js:60:28)\n    at Object.internals.handler (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@hapi/hapi/lib/handler.js:46:20)\n    at exports.execute (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@hapi/hapi/lib/handler.js:31:20)\n    at Request._lifecycle (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@hapi/hapi/lib/request.js:370:32)\n    at Request._execute (/app/product/ki/kibana-7.13.3-linux-x86_64/node_modules/@hapi/hapi/lib/request.js:279:9)"},"url":"http://10.192.104.33:5601/api/reporting/generate/csv_searchsource","message":"Internal Server Error"}
{"type":"response","@timestamp":"2023-12-05T18:59:28+08:00","tags":[],"pid":3078,"method":"post","statusCode":500,"req":{"url":"/api/reporting/generate/csv_searchsource","method":"post","headers":{"host":"10.192.104.33:5601","connection":"keep-alive","content-length":"345","dnt":"1","kbn-version":"7.13.3","user-agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0","content-type":"application/json","accept":"*/*","origin":"http://10.192.104.33:5601","referer":"http://10.192.104.33:5601/app/discover","accept-encoding":"gzip, deflate","accept-language":"en-US,en;q=0.9"},"remoteAddress":"10.41.210.140","userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0","referer":"http://10.192.104.33:5601/app/discover"},"res":{"statusCode":500,"responseTime":83,"contentLength":97},"message":"POST /api/reporting/generate/csv_searchsource 500 83ms - 97.0B"}

Hello,

If you are not logging in as super user, you need to make sure you have reporting privileges. Could you please check whether you have reporting privileges?

Also, which version of the stack you are in?

Thanks,
Bhavya

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.