Reporting: Error 500 : An internal server error occurred

Elastic Stack Kibana
1

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.

2

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 ':'"}
3

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"}
4

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.

5

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

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.

7

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
8

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