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!

Agile User Asked on May 22, 2020 in Agile PLM (v9).
Add Comment
5 Answer(s)

Correct. Dynamically calculated.

Agile Angel Answered on May 22, 2020.
Add Comment

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.


Agile Angel Answered on May 22, 2020.
Add Comment

@Steve Jones – thanks for the info. Do you happen to know the document ID off hand for that SQL process to clear the table?

Agile User Answered on May 22, 2020.
Add Comment

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.

Agile Angel Answered on May 23, 2020.
Add Comment

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.

Agile User Answered on May 26, 2020.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.