Actually there is no "Update" to the search database tables. If you
watch your SQL logs on the server when you kick off the sync you will
see that the Admin tool deletes all records in the object_search_ref and
object_search_details forms. (It does this 1 at a time and that is why
it takes so long) What I have done (so I don't go deleting and
creating forms all the time) is to truncate the tables with a filter on
Submit/Modify/Merge of the object_search_admin form.
Do the following:
On the admin form add 2 DisplayOnly integer fields (zRefID and
zDetailsID)
Add a filter on Submit/Modify/Merge of the admin form
Name : object_search_admin-TruncateOldData`!
Run-If : 'TR.Run/Not Run' = 1
Actions:
Set Fields from SQL
SELECT SCHEMAID FROM ARSCHEMA WHERE NAME='object_search_details'
zDetailsID = $1$
Set Fields from SQL
SELECT SCHEMAID FROM ARSCHEMA WHERE NAME='object_search_ref'
zRefID = $1$
Direct SQL
TRUNCATE TABLE T$zDetailsID$
Direct SQL
TRUNCATE TABLE H$zDetailsID$
Direct SQL
TRUNCATE TABLE B$zDetailsID$
Direct SQL
TRUNCATE TABLE T$zRefID$
Direct SQL
TRUNCATE TABLE H$zRefID$
Direct SQL
TRUNCATE TABLE B$zRefID$
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of FRANK, GORDON CTR DISA JSSC
Sent: Wednesday, January 09, 2008 10:09 AM
To: arslist@ARSLIST.ORG
Subject: Re: Admin tool crashes when sync search database (UNCLASSIFIED)
Classification: UNCLASSIFIED
Caveats: NONE
Are you doing an update each time? The update takes more resources.
I always do it like this:
1. Delete the "object" forms.
There are three: object_search_ref, object_search_details,
object_search_admin 2. Execute Tools, Set Up Search Database
This will reinitialize the three "object" forms 3. Run Tools,
Sync Search Database, Update Search Database
You'll need to leave the Admin Tool up when doing it this way.
The net effect is the same, but because you are not doing an "update"
cycle, it will take less resources and therefore will finish quicker.
You can also substitute the command line execution for step 3 above. I
would always set up the sync search through the Admin Tool because it is
quicker.
aradmin -u <user name> -x <server> -s
Gordon M. Frank
DISA\Verizon FNS
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L Contr
OC-ALC/ITMA
Sent: Wednesday, January 09, 2008 10:24 AM
To: arslist@ARSLIST.ORG
Subject: Admin tool crashes when sync search database
**
Hi all, I have a coworker who has an issue where when he starts to synch
his search database, his admin tool immediately crashes and the sync
never completes. He has to go in to remedy and reset it there.
He's running Admin Tool 6.3 P23 on Windows XP with a Server 2k3 and SQL
Server 2k
Thanks,
Gary Opela, Jr
Sr. Remedy Developer
Leader Communications, Inc.
405 736 3211
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
Classification: UNCLASSIFIED
Caveats: NONE
________________________________________________________________________
_______
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum
Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
