Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Iterating Query results limited to 512

Hi,

I have a simple java client that gets some query results and perform iteration on the workitems.
However, after the 512th workitem I get "QueryExpiredException: Query _GF2HwNEXEd-CJZ9ARNJOag expired".

Any suggestions?

0 votes


Accepted answer

Permanent link
Moti,

the question is 3.5 years old by now and maybe you found out yourself. Just in case it is still relevant for your work, I found an answer. It appears that IWorkSpaceManager.MAX_QUERY_RESULT is set to 512. To get all queried items nonetheless there is sample code in this jazz.net forum entry: https://jazz.net/forum/questions/128536/is-it-possible-to-fetch-changesets-greater-than-iworkspacemanagermax_query_size-using-ichangesetsearchcriteria

If this answers your question as well, please mark this as accepted.

- Arne
Moti Wertheimer selected this answer as the correct answer

0 votes

Comments

AND you can never really work away from the query expiry timeout on the server 


the recommendation I posted a couple months ago 
was GET the data ASAP into a local hash, then process the workitems from the hash..

in our project, it took 6-20 hours to process all the workitems in the query results.
we finally changed to the hash model, and it took 12 seconds to get all the workitems in the query, and 14 hours to process after that.  but the query never times out now. 
(set to 5 minutes (300 seconds) on the server by default)

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 10,938

Question asked: Oct 06 '10, 4:57 a.m.

Question was seen: 4,279 times

Last updated: Apr 03 '14, 11:19 a.m.

Confirmation Cancel Confirm