www-infrastructure-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kathey Marsden (Commented) (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (INFRA-4026) Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
Date Thu, 13 Oct 2011 16:45:11 GMT

    [ https://issues.apache.org/jira/browse/INFRA-4026?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13126714#comment-13126714
] 

Kathey Marsden commented on INFRA-4026:
---------------------------------------

I don't do this every day but maybe two or three times a year and then run extensive queries
locally using the exported data, certainly much less pressure on Jira  than run those queries
against Jira itself.  

Is there a way to run standard SQL queries against Jira?  The querying ability in Jira seems
to have improved with JQL but  I don't see a standard SQL interface yet? Still i would be
limited to the 1000 results, so probably not practical to use. 

Whatever the new solution for each of us individually, it seems like it would be appropriate
if restricting capabilities to give some notice.  How about putting it back for three months
 and make an announcement that you will limit to 1000 Jan 15, 2012?   This way  people can
have a chance to adjust their tooling dependent on the functionality instead of having this
hit by surprise during very busy times.


Thank you for your consideration.



                
> Jira no longer allows export of more than 1000 issues. Gives HTTP Status 403 - You are
not allowed to get a result set of more than 1000 results. 
> --------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: INFRA-4026
>                 URL: https://issues.apache.org/jira/browse/INFRA-4026
>             Project: Infrastructure
>          Issue Type: Bug
>      Security Level: public(Regular issues) 
>          Components: JIRA
>            Reporter: Kathey Marsden
>
> Occasionally I will export  the DERBY Jira issues so I can perform queries on them with
Derby Jira VTI provided in the Derby Demos. See http://wiki.apache.org/db-derby/HowToRunJiraVtiReports.
 Once the issues are dumped I can run lots of analytic queries with the VTI without taxing
 Jira and without manual intervention.
> I have noticed that recently though, that the maximum rows returned from Jira has been
reduced to 1000.  
> e.g. 
> https://issues.apache.org/jira/sr/jira.issueviews:searchrequest-xml/temp/SearchRequest.xml?pid=10594&sorter/field=issuekey&sorter/order=DESC&tempMax=6000&reset=true&decorator=none
> now yields an error:
> HTTP Status 403 - You are not allowed to get a result set of more than 1000 results.
Current search returns 5450 results
> type Status report
> message You are not allowed to get a result set of more than 1000 results. Current search
returns 5450 results
> description Access to the specified resource (You are not allowed to get a result set
of more than 1000 results. Current search returns 5450 results) has been forbidden.
> Can you please restore the previous defaults so the data dump can occur ?
> .

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message