[jira] [Commented] (DERBY-6530) Release Notes Generator may hit limit maximum of 200 issues

["Rick Hillegas (JIRA)" <ji...@apache.org>]

    [ 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)