Increase the query cache size to prevent Query Expired issue
This technote explains the Query Expired error message that can occur when using IBM Rational Team Concert, and describes how to resolve it.
The Eclipse client or the Web client sometimes shows a Query Expired error message when running a query:
Only part of the query runs.
The query returns some results but does not report the total number of work items.
For more information, see jazz.net work item 76944
This problem applies to both 1.X and 2.0, and both to the Eclipse UI and the Web UI.
Diagnosing the problem
The problem occurs intermittently
- The problem occurs when the server is under load.
- This problems might also occur during the CSV Export of 1.X and 2.X up to RC1, where the truncation can happen.
Resolving the problem
Increasing the Query Cache Size solves the problem:
- Go to the Rational Team Concert server's Admin WebUI: https://<server_URL>/jazz/admin
- Select Advanced Properties.
- Search the "com.ibm.team.repository.service.internal.QueryService" section.
- Increase the Query Cache size: Are the default and proposed values part of this step? I will format them accordingly. --> YES
Proposed new value: 150
- Save your changes
- Stop and restart the server
Jazz and Rational Team Concert have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.