Hi Jamie, I had an issue once on a production 7.6.0.4 system where an FTS reindex was "active" for over a week. No reindexing was actually and new indexing was running hours behind the live data.
After restarting the server, I recommenced the reindexing process and it completed within 12 hours. Not sure about everyone elses experiences, but i've regularly had to reindex the FTS database due to corruption of individual records On 08/11/2012, at 8:37 AM, "Jamie" <[email protected]> wrote: We are currently working with BMC on upgrading our Remedy environment from 7.5 to 7.6.04 by using their upgrade method and utilizing DDM. Before this version, we had never utilized FTS, but we have just kicked off hte re-index processs for our production envrionment and it has been running for over 66hrs right now, and stil has 24 more forms to go through. HPD:Help Desk alone has been running for 14+ hours and has still not completed; it has 648942 rows of data. We are pretty close to being straight out of the box, and BMC is recommending we remove some fields and forms from FTS indexing as they are saying it will reduce the index time and that these fields/forms will not benefit form being indexed. Apparently, they have done some internal review and at some point will be removing a bunch of fields/forms from FTS in future release (beyond 8.0). BMC is saying that removing these fields/forms from FTS will not impact applicaiton functionality and performance, however I have some concerns with excluding them if they were intially put for FTS as OOB fields. Has anyone else ran into this issue where kicking off FTS for the first time on an upgrade and taking this long? We have ARS, ITSM, RKM, SRM, SLM, IBRSD, CMDB all installed as well. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"

