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.
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.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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!
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