PM62793: Field added to indexed record type in CQFTS not searchable without fieldname: before the search term

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 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