ITSM 76.04 SP2 Oracle 11g / RedHat Linux 5.5 Strange issue after applying FTS to fields on the SYS:PredefinedQuries form. We added FTS to the Query Text Tier 1,2 and 3 fields. After saving the form changes FTS ran and searched on that form worked. However, when I add a new record to that form and supply a value ONLY for the Query Text Tier 1 field the FTS does not work. The entries in the ftsindex .log file appear to be correct but when searching against that column for the record that was just created it fails. If I modify that record (make a change to the Query Text Tier 1 field) then FTS starts working for that record. If I create and entry on that form and supply values for all three fields (Query Text Tier 1,2 and 3) then the FTS indexing works on create of the recrod. We are not having issues with FTS anywhere else in the system.
Anyone else out there seeing this kind of behavior? Thank you Frank C. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
