Agile 933 Full Text Search – initial indexing
If Full Text Search was never enabled in a 933 environment that has been in used for 5+ years, does it just taking turning the functionality on and letting the system index all those files or are there SQL commands that should be run due to this circumstance and will this indexing action bring the system down entirely or just slow down the performance? What can we do to get the initial indexing completed with minimal user interruption?
Thank you in advance!
Sorry for the last answer to the wrong post. Indexing will not bring the system down but probably should do it during a quiet time anyway. You can initiate indexing from the Admin client. There are two controls under the Full Text Search node.
“Update Content URLs” will go though all attachments with extensions listed in the “Index File Types” field and prep them to be considered for indexing. Takes ~ a minute
“Index Attachments” will perform the indexing.
I suggest testing with a file type that does not have many attachments. then add the additional file types after you know the process is working. If the test did not work then you will have to resort to SQL to clear indexing tables and basically do a reset. This is documented in Oracle Support.
@Steve Jones – thanks for the info. Do you happen to know the document ID off hand for that SQL process to clear the table?
Starting with 9.3.4 this would be the procedure.
If you are on 9.3.3 or earlier then there are patches involved and a different procedure.
Thanks, yes, I’m on 9.3.3. I believe I have found the applicable patches needed prior to activating the FTS indexing, the main concern was being able to begin the indexing while still being able to utilize the system without downtime or significant performance issues affecting daily use.