Jaspal, Well... in order for "Sync Search database gets wiped out daily" to be true then more had to be going on. The object_search_admin record would not remove all of the related "Sync Search database" data. (Unless the absence of the orbject_search_admin record some how short cuts the admin tool from even trying to find any data in the Sync Search DB forms. I guess that could be the case.)
I also find it a shame that this same functionality (Escalation to rebuild the Sync DB) can not be done if your Server is NOT a windows box. [ AKA: All of this stuff should be server side and preferably one of the *Special* run process type actions. ] Thanks for telling us know about someone is automating this process. By the way: Do you know why they are deleting that record at all? ( I doubt it is really a necessary step.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 4/9/07, Rawat, Jaspal <[EMAIL PROTECTED]> wrote:
** Actually there was an escalation, that I didn't knew abt, which was running nightly. It was a two step run process so that we could have the latest Synced Search DB. 1. Application-Query-Delete-Entry "object_search_admin" 1=1 2. CMD /C ARAdmin.exe -x $SERVER$ -u Webservice -p pipeline -portnum 2112 -s The second run process was not running because the PATH variable was not having the Remedy binaries path included. Jaspal S Rawat
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"

