IBM Support

Increase the query cache size to prevent Query Expired issue

Troubleshooting


Problem

This technote explains the Query Expired error message that can occur when using IBM Engineering Workflow Management (EWM) or IBM Egineering Test Management (ETM), 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

It can also manisfest itself with an error in the log, for instance qm.log, where you would see a message similar to:

com.ibm.team.repository.common.QueryExpiredException: Query _CkBvAJ1GEd6T3bqwlzEkIQ expired.

Cause

The application stores result queries in a cache, the default value is 65, which means that it will store the result of 65 queries.
When the cache is full and a new query is executed, the new query result are added to the cache and the oldest one is removed.

Environment

This problem applies to both 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 can also occur during the CSV export.

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:
    Default value: 65
    Proposed new value: 150
  5. Save your changes (This change does not require a server restart and take effect immediately)
After increasing this value, monitor the logs to see if the frequency of the QueryExpiredException error has reduced and if necessary increase the value further.
The maximum value this setting can be set to will depend on the resources available on the server.

Related Information

[{"Type":"MASTER","Line of Business":{"code":"LOB59","label":"Sustainability Software"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"ARM Category":[{"code":"a8m0z000000blk0AAA","label":"Workflow Management-\u003EWork Items-\u003EQueries"}],"ARM Case Number":"TS009975227","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Document Information

Modified date:
13 October 2022

UID

swg21390693