Increase the query cache size to prevent Query Expired issue

Technote (troubleshooting)


Problem(Abstract)

This technote explains the Query Expired error message that can occur when using IBM Rational Team Concert, and describes how to resolve it.

Symptom

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


Environment

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:

  1. Go to the Rational Team Concert server's Admin WebUI: https://<server_URL>/jazz/admin
  2. Select Advanced Properties.
  3. Search the "com.ibm.team.repository.service.internal.QueryService" section.
  4. Increase the Query Cache size: Are the default and proposed values part of this step? I will format them accordingly. --> YES
    Default value:65
    Proposed new value: 150



  5. Save your changes
  6. Stop and restart the server



Leverage the Jazz Community

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.
Refer to technote 1319600 for details and links.


Related information

jazz.net work item 76944

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Rational Team Concert
Work Items

Software version:

1.0, 1.0.1, 1.0.1.1, 2.0

Operating system(s):

Linux, Windows

Reference #:

1390693

Modified date:

2009-06-24

Translate my page

Machine Translation

Content navigation