JQL Query in Confluence "Unable to generate JSON output" for more than one JIRA 5.0.6 Issue

JIRA 5.0.6
Confluence 4.2.6
Host: ESXi 4.1
Guest OS: FreeBSD 9.0, openjdk6-b24, Apache 2.2 mod_proxy and name-based virtual host to wiki.domain.tld & jira.domain.tld

While following these documented processes for inserting the results of a JQL query

the Jira Issues Macro, such as project = DRA on the Confluence Page never gets past this error message once it attempts to render the page:

Unable to generate JSON output class java.io.IOException

The EDIT page properly shows the macro JIRA | project = DRA. The EDIT and Rendered Page show individual JIRA Issues perfectly, just not the list.

Anonymous access to JIRA Issues does not resolve the issue.

Below is a snippet of the logs/atlassian-confluence.log:

2012-07-05 11:46:00,949 WARN [http-8090-9] [confluence.extra.jira.JiraIssuesServlet] doGet An IO Exception has been encountered: Unable to generate JSON output
 -- url: /plugins/servlet/issue-retriever | userName: admin | referer: http://wiki.domain.tld/display/DRA/Dashboard
java.io.IOException: Unable to generate JSON output
	at com.atlassian.confluence.extra.jira.JsonFlexigridResponseGenerator.generate(JsonFlexigridResponseGenerator.java:324)
	at com.atlassian.confluence.extra.jira.JiraIssuesServlet.getResult(JiraIssuesServlet.java:210)
	at com.atlassian.confluence.extra.jira.JiraIssuesServlet.doGet(JiraIssuesServlet.java:120)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
... snip...
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
	at java.lang.Thread.run(Thread.java:679)
Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: -1
	at java.lang.String.substring(String.java:1949)
	at com.atlassian.confluence.extra.jira.JsonFlexigridResponseGenerator.getOutputAsString(JsonFlexigridResponseGenerator.java:269)
	at com.atlassian.confluence.extra.jira.JsonFlexigridResponseGenerator.generate(JsonFlexigridResponseGenerator.java:320)
	... 132 more

Request support for how to further troubleshoot and ultimately resolve the perceived lack of JQL functionality in Confluence.


P.S. Please use the same markup/down between Answers Atlassian and Confluence/JIRA from Support.

3 answers

Mr. Kazatchkov correctly identified this as a bug with the default language in JIRA being English (en) as opposed to either English UK (en-uk) or English US (en-us). Apparently, the lack of the "-" character causes this StringIndexOutOfBoundsException.

Change the default Language in JIRA from English (Default) to English US did the trick for me.

A big thanks to the Atlassian Support Team for identifying the fix! Great job.

How to fix, the default language is Chinese.

How to fix, the default language is Chinese.

I already have English UK/US but an issue appears with one particular jira-issue.

Any ideas what should I check in current jira-issue to avoid an error?

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

783 views 33 5
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you