Hey Carey....:)...it was me that put that Escalation in place. You are correct...when the object_search_admin record is deleted the admin tool turns off the option of searching...weird huh. Jaspal and I work together on my current project so I just answered internally...but to answer your question...I was trying to automate the process some months back and found that it would not run properly from the command line of my escalation if this record still existed...I could run it just fine from the GUI but the command line wouldn't work (I have no idea why)...so I found when I deleted the search DB and ran it as a 'blank DB' it would run fine...I then found that all I needed to do was delete that one record and it ran fine...so I automated the delete and re-creation to happen nightly....I just forgot to add the Admin into the path on our new dev boxes...:)
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Monday, April 09, 2007 11:34 AM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database getting Wiped out daily 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"