Executing a query results in error message "CRJAZ8201E"

Troubleshooting

Problem

Attempt to execute a Work Item query in IBM Rational Workflow Management (EWM) results in error "CRJAZ8201E: Could not execute query".

Symptom

In ccm.log, you 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

Resolving The Problem

To solve the issue, run the repotools-ccm -rebuildTextIndices command to rebuild the fulltext indexes in EWM.

Steps:

Shut down the application server
Back up the 'indices' folder. The location of the folder is defined as com.ibm.team.jfs.index.root.directory in teamserver.properties. The teamserver.properties file locates in ../<server_installation_path>/server/conf/
Run repotools-ccm -rebuildTextIndices. Ensure the command runs successfully.
Start the server

Note: indexing can take some time to run. The amount of time used is directly related to the number of work items to be indexed.

[{"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->Work Items->Queries"}],"ARM Case Number":"TS007549989","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Product Synonym

Rational Team Concert;EWM

Was this topic helpful?

Document Information

Modified date:
17 November 2021

UID

swg21692979

Tips