Advanced Search Issue
The usp_reindex proc is rebuilding the database indexes - this needs to be done periodically (weekly, or nightly if there are high volumes of record creation / deletion).
The keyword indexes are managed by the Archer queuing service.
You can initiate a keyword index rebuild through the Archer Control Panel. There, you also specify what server is maintaining the indexes, and the location where they are stored.
This location needs to be accessible by all web/service servers in the environment using the same path. In a multi- web/service server environment, this would need to be a UNC path to a share that the service account has access to.