[
https://issues.apache.org/jira/browse/DERBY-6530?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14016553#comment-14016553
]
Rick Hillegas commented on DERBY-6530:
--------------------------------------
One fix would be to get the JIRA administrators to raise the limit to the
default (which is 1000, I think). See
https://confluence.atlassian.com/display/JIRAKB/Export+More+Than+1000+Results+to+Excel
. When I google this error message, it is suggested that JIRA will fall over
with an OutOfMemory error if your query returns too many results. The
commentators helpfully suggest that we are morons for expecting this api to
handle more than 200 results.
Maybe a streaming api would be better for our purposes. I don't know whether
the SOAP protocol allows a large response to be chunked into a stream of
smaller packets.
> Release Notes Generator may hit limit maximum of 200 issues
> ------------------------------------------------------------
>
> Key: DERBY-6530
> URL: https://issues.apache.org/jira/browse/DERBY-6530
> Project: Derby
> Issue Type: Improvement
> Components: Build tools
> Affects Versions: 10.10.2.0
> Reporter: Myrna van Lunteren
>
> For the 10.10.2 release I tried to generate the release notes by doing this
> step:
> Then the Release Manager builds RELEASE-NOTES.html:
> cd tools/release
> ant -Drelnotes.src.reports=/path/to/report_directory
> -Djira.user=<jira user name>
> -Djira.password=<password for that user>
> -Drelease.version=<version of the release in JIRA>
> genrelnotes
> as documented on this page:
> http://wiki.apache.org/db-derby/ReleaseNoteProcess
> However, this returned 359 issues and (apparently) JIRA has (now) a limit of
> 200 issues downloadable at once, for I got this error:
> C:\derby\10.10\tools\release\build.xml:156:
> java.lang.IllegalArgumentException: JQL query 'project = DERBY AND resolution
> = fixed AND fixversion in ("10.10.1.4", "10.10.1.1")' failed
> (com.atlassian.jira.rpc.exception.RemoteException: Error occurred during
> searching: 'You are not allowed to get a result set of more than 200 results.
> Current search returns 359 results'.)
> I worked around this by splitting the issues in doc, test, and other issues
> and then manually cutting-and-pasting and adjusting the Release notes, but we
> should make a better fix.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
