Reporting: Error 500 : An internal server error occurred

I tried to do: Reporting -> Generate CSV in Kibana 6.1.2 and I got following error:

Reporting: Error 500 : An internal server error occurred

I apologize for posting like this, however due to

Body is limited to 7000 characters

that's the only way to do it...

kibana's log (1/3):

kibana11-custom | rison parser error:  missing ','
kibana11-custom | rison parser error:  missing ':'

Please advise.

kibana's log (2/3):

kibana11-custom | {"type":"error","@timestamp":"2018-01-25T22:11:56Z","tags":[],"pid":1,"level":"error","error":{"message":"rison decoder error: missing ':'","name":"Error","stack":"Error: rison decoder error: missing ':'\n    at Error (native)\n    at errcb [as errorHandler] (/usr/share/kibana/plugins/x-pack/node_modules/rison-node/build/rison.js:270:37)\n    at rison.parser.parse [as parse] (/usr/share/kibana/plugins/x-pack/node_modules/rison-node/build/rison.js:333:14)\n    at Object.rison.decode (/usr/share/kibana/plugins/x-pack/node_modules/rison-node/build/rison.js:275:14)\n    at /usr/share/kibana/plugins/x-pack/plugins/reporting/server/routes/main.js:96:33\n    at next (native)\n    at step (/usr/share/kibana/plugins/x-pack/plugins/reporting/server/routes/main.js:30:191)\n    at /usr/share/kibana/plugins/x-pack/plugins/reporting/server/routes/main.js:30:437\n    at /usr/share/kibana/plugins/x-pack/plugins/reporting/server/routes/main.js:30:99\n    at handler (/usr/share/kibana/plugins/x-pack/plugins/reporting/server/routes/main.js:93:5)\n    at Object.internals.handler (/usr/share/kibana/node_modules/hapi/lib/handler.js:96:36)\n    at Items.serial (/usr/share/kibana/node_modules/hapi/lib/handler.js:63:26)\n    at done (/usr/share/kibana/node_modules/hapi/node_modules/items/lib/index.js:31:25)\n    at done (/usr/share/kibana/node_modules/hapi/node_modules/items/lib/index.js:63:25)\n    at pre (/usr/share/kibana/node_modules/hapi/lib/handler.js:52:24)\n    at finalize (/usr/share/kibana/node_modules/hapi/lib/handler.js:281:20)\n    at wrapped (/usr/share/kibana/node_modules/hoek/lib/index.js:875:20)\n    at internals.Response._processPrepare (/usr/share/kibana/node_modules/hapi/lib/response.js:521:16)\n    at internals.Response._prepare (/usr/share/kibana/node_modules/hapi/lib/response.js:460:21)\n    at process.nextTick (/usr/share/kibana/node_modules/hapi/lib/reply.js:152:22)\n    at _comxedTickCallback (internal/process/next_tick.js:73:7)\n    at process._tickDomainCallback (internal/process/next_tick.js:128:9)"},"url":{"protocol":null,"slashes":null,"auth":null,"host":null,"port":null,"hostname":null,"hash":null,"search":"?jobParams=(conflictedTypesFields:!(),fields:!(x,x,x,x,x),indexPatternId:AV8nJsQVoHVxmLru57f9,metaFields:!(_source,_id,_type,_index,_score),searchRequest:(body:(_source:(excludes:!(),includes:!(x,x,x,x,x)),docvalue_fields:!(x),query:(bool:(filter:!(),must:!((match_all:()),(exists:(field:x)),(bool:(minimum_should_match:1,should:!((match_phrase:(x:%27433793%27)),(match_phrase:(x:%27468829%27)),(match_phrase:(x:%27475810%27)),(match_phrase:(x:%27478997%27)),(match_phrase:(x:%27581138%27))))),(range:(x:(format:epoch_millis,gte:1516313516221,lte:1516918316221)))),must_not:!(),should:!())),script_fields:(),sort:!((x:(order:desc,unmapped_type:boolean))),stored_fields:!(x,x,x,x,x),version:!t),index:x+added),title:%27x%20x%20x%27,type:search)","query":{"jobParams":"(conflictedTypesFields:!(),fields:!(x,x,x,x,x),indexPatternId:AV8nJsQVoHVxmLru57f9,metaFields:!(_source,_id,_type,_index,_score),searchRequest:(body:(_source:(excludes:!(),includes:!(x,x,x,x,x)),docvalue_fields:!(x),query:(bool:(filter:!(),must:!((match_all:()),(exists:(field:x)),(bool:(minimum_should_match:1,should:!((match_phrase:(x:'433793')),(match_phrase:(x:'468829')),(match_phrase:(x:'475810')),(match_phrase:(x:'478997')),(match_phrase:(x:'581138'))))),(range:(x:(format:epoch_millis,gte:1516313516221,lte:1516918316221)))),must_not:!(),should:!())),script_fields:(),sort:!((x:(order:desc,unmapped_type:boolean))),stored_fields:!(x,x,x,x,x),version:!t),index:x added),title:'x x x',type:search)"},"pathname":"/api/reporting/generate/csv","path":"/api/reporting/generate/csv?jobParams=(conflictedTypesFields:!(),fields:!(x,x,x,x,x),indexPatternId:AV8nJsQVoHVxmLru57f9,metaFields:!(_source,_id,_type,_index,_score),searchRequest:(body:(_source:(excludes:!(),includes:!(x,x,x,x,x)),docvalue_fields:!(x),query:(bool:(filter:!(),must:!((match_all:()),(exists:(field:x)),(bool:(minimum_should_match:1,should:!((match_phrase:(x:%27433793%27)),(match_phrase:(x:%27468829%27)),(match_phrase:(x:%27475810%27)),(match_phrase:(x:%27478997%27)),(match_phrase:(x:%27581138%27))))),(range:(x:(format:epoch_millis,gte:1516313516221,lte:1516918316221)))),must_not:!(),should:!())),script_fields:(),sort:!((x:(order:desc,unmapped_type:boolean))),stored_fields:!(x,x,x,x,x),version:!t),index:x+added),title:%27x%20x%20x%27,type:search)","href":"/api/reporting/generate/csv?jobParams=(conflictedTypesFields:!(),fields:!(x,x,x,x,x),indexPatternId:AV8nJsQVoHVxmLru57f9,metaFields:!(_source,_id,_type,_index,_score),searchRequest:(body:(_source:(excludes:!(),includes:!(x,x,x,x,x)),docvalue_fields:!(x),query:(bool:(filter:!(),must:!((match_all:()),(exists:(field:x)),(bool:(minimum_should_match:1,should:!((match_phrase:(x:%27433793%27)),(match_phrase:(x:%27468829%27)),(match_phrase:(x:%27475810%27)),(match_phrase:(x:%27478997%27)),(match_phrase:(x:%27581138%27))))),(range:(x:(format:epoch_millis,gte:1516313516221,lte:1516918316221)))),must_not:!(),should:!())),script_fields:(),sort:!((x:(order:desc,unmapped_type:boolean))),stored_fields:!(x,x,x,x,x),version:!t),index:x+added),title:%27x%20x%20x%27,type:search)"},"message":"rison decoder error: missing ':'"}

kibana's log (3/3):

kibana11-custom | {"type":"response","@timestamp":"2018-01-25T22:11:56Z","tags":[],"pid":1,"method":"post","statusCode":500,"req":{"url":"/api/reporting/generate/csv?jobParams=(conflictedTypesFields%3A!()%2Cfields%3A!(x%2Cx%2Cx%2Cx%2Cx)%2CindexPatternId%3AAV8nJsQVoHVxmLru57f9%2CmetaFields%3A!(_source%2C_id%2C_type%2C_index%2C_score)%2CsearchRequest%3A(body%3A(_source%3A(excludes%3A!()%2Cincludes%3A!(x%2Cx%2Cx%2Cx%2Cx))%2Cdocvalue_fields%3A!(x)%2Cquery%3A(bool%3A(filter%3A!()%2Cmust%3A!((match_all%3A())%2C(exists%3A(field%3Ax))%2C(bool%3A(minimum_should_match%3A1%2Cshould%3A!((match_phrase%3A(x%3A'433793'))%2C(match_phrase%3A(x%3A'468829'))%2C(match_phrase%3A(x%3A'475810'))%2C(match_phrase%3A(x%3A'478997'))%2C(match_phrase%3A(x%3A'581138')))))%2C(range%3A(x%3A(format%3Aepoch_millis%2Cgte%3A1516313516221%2Clte%3A1516918316221))))%2Cmust_not%3A!()%2Cshould%3A!()))%2Cscript_fields%3A()%2Csort%3A!((x%3A(order%3Adesc%2Cunmapped_type%3Aboolean)))%2Cstored_fields%3A!(x%2Cx%2Cx%2Cx%2Cx)%2Cversion%3A!t)%2Cindex%3Ax%20added)%2Ctitle%3A'x%20x%20x'%2Ctype%3Asearch)","method":"post","headers":{"connection":"upgrade","host":"kibana.x.com","x-real-ip":"x.x.x.x","x-forwarded-for":"x.x.x.x","content-length":"2","accept":"application/json, text/plain, */*","origin":"https://kibana.x.com","kbn-version":"6.1.2","save-data":"on","user-agent":"Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.99 Safari/537.36","content-type":"application/json;charset=UTF-8","referer":"https://kibana.x.com/app/kibana","accept-encoding":"gzip, deflate, br","accept-language":"en-US,en;q=0.9"},"remoteAddress":"x.x.x.x","userAgent":"x.x.x.x","referer":"https://kibana.x.com/app/kibana"},"res":{"statusCode":500,"responseTime":237,"contentLength":9},"message":"POST /api/reporting/generate/csv?jobParams=(conflictedTypesFields%3A!()%2Cfields%3A!(x%2Cx%2Cx%2Cx%2Cx)%2CindexPatternId%3AAV8nJsQVoHVxmLru57f9%2CmetaFields%3A!(_source%2C_id%2C_type%2C_index%2C_score)%2CsearchRequest%3A(body%3A(_source%3A(excludes%3A!()%2Cincludes%3A!(x%2Cx%2Cx%2Cx%2Cx))%2Cdocvalue_fields%3A!(x)%2Cquery%3A(bool%3A(filter%3A!()%2Cmust%3A!((match_all%3A())%2C(exists%3A(field%3Ax))%2C(bool%3A(minimum_should_match%3A1%2Cshould%3A!((match_phrase%3A(x%3A'433793'))%2C(match_phrase%3A(x%3A'468829'))%2C(match_phrase%3A(x%3A'475810'))%2C(match_phrase%3A(x%3A'478997'))%2C(match_phrase%3A(x%3A'581138')))))%2C(range%3A(x%3A(format%3Aepoch_millis%2Cgte%3A1516313516221%2Clte%3A1516918316221))))%2Cmust_not%3A!()%2Cshould%3A!()))%2Cscript_fields%3A()%2Csort%3A!((x%3A(order%3Adesc%2Cunmapped_type%3Aboolean)))%2Cstored_fields%3A!(x%2Cx%2Cx%2Cx%2Cx)%2Cversion%3A!t)%2Cindex%3Ax%20added)%2Ctitle%3A'x%20x%20x'%2Ctype%3Asearch) 500 237ms - 9.0B"}

I'm told that is indeed a bug which is being fixed in 6.2.0. We're currently testing 6.2.0 for release in a few weeks.

Thank you for your replay, I'm glad to see Elastic is aware of the issue.

Does that mean we won't see the fix until 6.2.0? like 6.1.3?

6.1.3 will probably be released next week, but it won't have this fix in it. It probably won't be considered critical enough to get in a patch release like 6.1.4.

But it is already merged into the upcoming 6.2.0 release.

I had the same issue.
When using && instead of AND in the search query kibana promt me with

Blockquote Reporting: Error 500 : An internal server error occurred

2 Likes

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