Fixes are available
Rational ClearQuest Fix Pack 03 (8.0.0.3) for 8.0
Rational ClearQuest Fix Pack 11 (8.0.0.11) for 8.0
Rational ClearQuest Fix Pack 12 (8.0.0.12) for 8.0
Rational ClearQuest Fix Pack 13 (8.0.0.13) for 8.0
Rational ClearQuest Fix Pack 14 (8.0.0.14) for 8.0
Rational ClearQuest Fix Pack 15 (8.0.0.15) for 8.0
Rational ClearQuest Fix Pack 16 (8.0.0.16) for 8.0
Rational ClearQuest Fix Pack 17 (8.0.0.17) for 8.0
Rational ClearQuest Fix Pack 18 (8.0.0.18) for 8.0
Rational ClearQuest Fix Pack 19 (8.0.0.19) for 8.0
Rational ClearQuest Fix Pack 20 (8.0.0.20) for 8.0
Rational ClearQuest Fix Pack 21 (8.0.0.21) for 8.0
APAR status
Closed as program error.
Error description
Field added to indexed record type in CQFTS not searchable without fieldname: before the search term Steps to Reproduce: 1.) Create SAMPL database using defect tracking schema with connection name CqFTS. 2.) Run the following command FTSA command '--init_cq_fts' cqperl cqtsadmin.pl --username admin --password '' --dbset cqfts --userdb sampl --ftshome c:\CQ.Search --init_cq_fts 3) Edit the generated Entity file so that you have only 1 record type: 'Defect' in this file. In addition, remove 1 or more fields from the list of fields CQ FTS Entity File: C:/CQ.Search/cqfts_sampl/Entity-cqfts-sampl.txt 4) Complete the FTS setup by running the FTSA command '--setup_cq-fts' cqperl cqtsadmin.pl --username admin --password '' --dbset cqfts --userdb sampl --ftshome c:\CQ.Search --setup_cq_fts 5) In the FTSA doc, read the step to add a new field and run the FTSA command to add / remove the record-type A.)Edit the file cqtsadmin-TextSearch-SAMPL.xml, and change the value for the XML tag?removeRecordType? from: ?newValue required='no'??/newValue? to: ?newValue required='no'?Defect?/newValue? If you are removing multiple record types, use a semicolon (?;?) to separate them. B)Edit the file cqtsadmin-TextSearch-SAMPL.xml and change the value for the XML tag?addRecordType? from: ?newValue required='no'??/newValue? to: ?newValuerequired='no'?Defect=Description,Headline,Keywords,Note _Entry?/newValue? 6.)At the command prompt, issue the following command, which first removes the record type and then adds it with the new field: cqperl cqtsadmin.pl --username admin --password '' --dbset cqfts --userdb SAMPL --ftshome C:\CQ.Search --remove_record_type --add_record_type
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * **************************************************************** * PROBLEM DESCRIPTION: * **************************************************************** * RECOMMENDATION: * **************************************************************** In ClearQuest Full-Text Search, fields added to an indexed record type are not searchable without fieldname: before the search term.
Problem conclusion
A fix is available in ClearQuest 8.0.0.3. CQ 7.1.x users need to go to the following link to get the 1.0.0.03-D120425 version of the CQ Full Text Search Admin tool: https://www-304.ibm.com/support/docview.wss?uid=swg24026182
Temporary fix
Comments
APAR Information
APAR number
PM62793
Reported component name
CLEARQUEST WIN
Reported component ID
5724G3600
Reported release
712
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-04-18
Closed date
2012-06-25
Last modified date
2012-06-25
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
CLEARQUEST WIN
Fixed component ID
5724G3600
Applicable component levels
R712 PSN
UP
Document Information
Modified date:
25 June 2012