IBM Support

Executing a query results in error message "CRJAZ8201E"

Troubleshooting


Problem

Attempts to execute a Work Item query using IBM Rational Team Concert (RTC) resutls in the error "CRJAZ8201E: Could not execute query".

Symptom

In your ccm.log file you can also find a corresponding error message:


2014-12-12 15:53:28,330 [WebContainer : 22 @@ 15:53 user-name <com.ibm.team.workitem.newQuery/XXXX@f72cb2f4-f6fa-4123-8fa4-ac4ece019eaf> /ccm/service/com.ibm.team.workitem.common.internal.rest.IQueryRestService/getResultSet] WARN .team.repository.servlet.AbstractTeamServerServlet - CRJAZ1163I TeamRepositoryException processing POST request for com.ibm.team.workitem.common.internal.rest.IQueryRestService.postGetResultSet(). CRJAZ1170I The request was made by user "user-name" from "your-server-name".CRJAZ1166I The stack trace hash is 037EDF0CDF05BB61C53A3073DEB1AA30EF5CD538.
com.ibm.team.repository.common.TeamRepositoryException: CRJAZ8201E: Could not execute query ( [Text: test] [Constrain Type: com.ibm.team.workitem.WorkItem] [ID: null] [Type: null] [Search Scope: com.ibm.team.workitem.WorkItem com.ibm.team.workitem.Attachment ] )
at com.ibm.team.fulltext.service.internal.FullTextServiceImpl.find(FullTextServiceImpl.java:150)
at com.ibm.team.fulltext.service.internal.FullTextServiceImpl.find(FullTextServiceImpl.java:119)
..

at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1862)
Caused by: com.ibm.team.fulltext.common.FulltextException: CRJAZ8201E: Could not execute query ( [Text: test] [Constrain Type: com.ibm.team.workitem.WorkItem] [ID: null] [Type: null] [Search Scope: com.ibm.team.workitem.WorkItem com.ibm.team.workitem.Attachment ] )
at com.ibm.team.fulltext.common.internal.query.QueryManagerImpl.doFind(QueryManagerImpl.java:296)
at com.ibm.team.fulltext.common.internal.query.QueryManagerImpl.find(QueryManagerImpl.java:175)
at com.ibm.team.fulltext.service.internal.FullTextServiceImpl.find(FullTextServiceImpl.java:141)
... 92 more
Caused by: java.io.FileNotFoundException: /XXXX/XXXX/clmindex/ccm/indices/workitemindex/_p1jBsYLdEeCg4JjUOW95KQ/com.ibm.team.workitem.WorkItem/_gdue_2.del (No such file or directory)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:230)
at org.apache.lucene.store.MMapDirectory.openInput(MMapDirectory.java:218)
at org.apache.lucene.store.FSDirectory.openInput(FSDirectory.java:345)
at org.apache.lucene.util.BitVector.<init>(BitVector.java:266)
..
com.ibm.team.fulltext.common.internal.index.IndexManagerImpl.access$0(IndexManagerImpl.java:704)
at com.ibm.team.fulltext.common.internal.index.IndexManagerImpl$1.search(IndexManagerImpl.java:641)
at com.ibm.team.fulltext.common.internal.query.QueryManagerImpl.execute(QueryManagerImpl.java:563)
at com.ibm.team.fulltext.common.internal.query.QueryManagerImpl.doFind(QueryManagerImpl.java:294)
... 94 more

Cause

Cause is unknown.

Resolving The Problem

To solve this issue you need to run the repotools-ccm reindex all command.
If that will not help use the following steps:

  1. Shut down your application server.

  2. Made a backup of the folder with indices. The location of this folder you can find in teamserver.properties file as a com.ibm.team.jfs.index.root.directory parameter. The teamserver.properties file you will find in the path ../server_installation_path/server/conf/

  3. Remove this folders form the default location

  4. Run the command repotools-ccm reindex all

  5. Start the server after the repotools command will finish


Note that indexing can take some time, which is directly related with the amount of Work Items, after it ends all your queries should work as expected.

Internal Use Only

This technote was generated by Technote Kickstart 1.1.0.85 based on Rational Customer Support PMR 78422,010,618.
View the associated PMR's text via Wellspring at: http://eclient.lenexa.ibm.com:9082/DocFetcher/source/PMR/78422.010.618%20O14/12/12

[{"Product":{"code":"SSCP65","label":"Rational Team Concert"},"Business Unit":{"code":"BU005","label":"IoT"},"Component":"Work Items","Platform":[{"code":"PF016","label":"Linux"}],"Version":"5.0.2","Edition":""}]

Document Information

Modified date:
16 June 2018

UID

swg21692979