02-06-2014 10:18 AM
Good day all,
On yesterday,the staff created a 100 word records in the morning and an offline index was ran during the night. However when the staff went to conduct searches on the 100 records. The search was on the word pending, it yield maybe 20 records this morning. However when they did a search by date created mostly all of the record appears. Is there a delay in offline Index processing with TRIM v6.2? Thanks.
02-07-2014 05:42 AM
Here's the skinny on the offline indexing.
In OFFLINE mode the table is locked upfront for any read or write, and then the new index gets built from the old index, while holding a lock on the table. No read or write operation is permitted on the table while the index is being rebuilt. Only when the operation is done is the lock on the table released and reads and writes are allowed again.
02-07-2014 11:21 PM
What are you clicking or doing to perform an Offline Index?
What application did you do this in?
You aren't using any TRIM terminology that we're aware of. :)
NOT A HP EMPLOYEE
02-10-2014 10:14 AM
My apologies, I should have eplained better. The indexing occurs on the back end (i.e. SQL Server Database) started by our system admin. So basically the Information workers are seeing a delay in newly accessed records showing up in TRIM.
02-10-2014 10:17 AM
How are they searching? What method(s)?
TRIM has two delayed actions: title word indexing and content indexing. Both are managed by the event server. Neither (should) require daily/nightly intervention by a SQL Server administrator. What steps, specifically, is this SQL Admin performing?
02-10-2014 10:25 AM
Not sure of what steps he took. But there was a request from the TRIM Admin to run the index for some reason. I believe some records were out of whack. Also I believe the served by Context looking a records with word "Pending" in it. Its part of a work flow process. Then they searched by Date created using the prior day's date. I hope this makes sense.
02-10-2014 11:34 AM
If you searched for a value of "pending" with the "Document Content" search method, but are not getting full results then the content index is not up-to-date. You need to check the event server to see how far it is behind. 6R2 uses ISYS for the underlying content index engine. Maybe it's throwing errors? Check server log directory for logs and look in those for errors.