# Reporting: Error 500 : An internal server error occurred **URL:** \ **Category:** Kibana\ **Created:** [January 25, 2018, 10:18pm UTC](https://discuss.elastic.co/t/reporting-error-500-an-internal-server-error-occurred/117130 "2018-01-25T22:18:24Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\ **Post date:** [January 25, 2018, 10:18pm UTC](https://discuss.elastic.co/t/reporting-error-500-an-internal-server-error-occurred/117130/1 "2018-01-25T22:18:24Z")
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. ---
**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\ **Post date:** [January 25, 2018, 10:18pm UTC](https://discuss.elastic.co/t/reporting-error-500-an-internal-server-error-occurred/117130/2 "2018-01-25T22:18:50Z")
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 ':'"} ``` ---
**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\ **Post date:** [January 25, 2018, 10:19pm UTC](https://discuss.elastic.co/t/reporting-error-500-an-internal-server-error-occurred/117130/3 "2018-01-25T22:19:05Z")
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"} ``` ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [January 26, 2018, 4:05pm UTC](https://discuss.elastic.co/t/reporting-error-500-an-internal-server-error-occurred/117130/4 "2018-01-26T16:05:22Z")
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. ---
**Author:** ![alexus](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/alexus/32/12696_2.png) [@alexus](https://discuss.elastic.co/u/alexus)\ **Post date:** [January 26, 2018, 4:11pm UTC](https://discuss.elastic.co/t/reporting-error-500-an-internal-server-error-occurred/117130/5 "2018-01-26T16:11:03Z")
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? ---
**Author:** ![LeeDr](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/leedr/32/9289_2.png) [@LeeDr](https://discuss.elastic.co/u/LeeDr)\ **Post date:** [January 26, 2018, 8:33pm UTC](https://discuss.elastic.co/t/reporting-error-500-an-internal-server-error-occurred/117130/6 "2018-01-26T20:33:33Z")
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. ---
**Author:** ![zloban](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/zloban/32/4663_2.png) [@zloban](https://discuss.elastic.co/u/zloban)\ **Post date:** [February 1, 2018, 1:11pm UTC](https://discuss.elastic.co/t/reporting-error-500-an-internal-server-error-occurred/117130/7 "2018-02-01T13:11:45Z")
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 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [March 1, 2018, 1:11pm UTC](https://discuss.elastic.co/t/reporting-error-500-an-internal-server-error-occurred/117130/8 "2018-03-01T13:11:47Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.