Re: Sync Search Database crashes Admin Tool and then Freezes
Gary, what version/patch of AR System are you using? Rick On Mon, Aug 25, 2008 at 12:10 PM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] wrote: Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ 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
Re: Sync Search Database crashes Admin Tool and then Freezes
Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Sync Search Database crashes Admin Tool and then Freezes
6.03, no patch. I thought we were at 19, but I guess not. I know it works, the guy before me did it, and he had to do some maneuvering to get it working. I think he deleted the three object forms, and then next time he ran the sync, it recreated them and worked. I was hoping someone out there had done that so they could confirm that would indeed fix the issue before I tried doing it. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Monday, August 25, 2008 2:17 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** Gary, what version/patch of AR System are you using? Rick On Mon, Aug 25, 2008 at 12:10 PM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] wrote: Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Sync Search Database crashes Admin Tool and then Freezes
Thanks Joe, that's what I was trying to confirm. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 25, 2008 2:19 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo http://www.yahoo.com/ IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Sync Search Database crashes Admin Tool and then Freezes
We had this issue and Remedy issue a hotfix DLL file. On Mon, Aug 25, 2008 at 3:10 PM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] wrote: Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ 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
Re: Sync Search Database crashes Admin Tool and then Freezes
Well shoot, I deleted the forms, but it still crashes my admin tool. Oh well, I guess it's back to the old way of doing it... manually digging through all filters and active links... Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 25, 2008 2:19 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo http://www.yahoo.com/ IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Sync Search Database crashes Admin Tool and then Freezes
The latest patch to AR System 7.1 (patch 4) seems to fix this. Might try it again, if you can use that patch to Admin/Server. Rick On Mon, Aug 25, 2008 at 12:19 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo http://www.yahoo.com/ IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Sync Search Database crashes Admin Tool and then Freezes
I was on 6.03 patch 18 and they had me switch to the latest 6.03 patch at the time (24) and the crashing stopped for me. ARS 6.3 Patch 24 HD 6.0 Oracle 10 w/9 libraries Oracle lives on a remote server Windows 2003 4 gig on app server and 8 gig on DB server -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:23 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes Well shoot, I deleted the forms, but it still crashes my admin tool. Oh well, I guess it's back to the old way of doing it... manually digging through all filters and active links... Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 25, 2008 2:19 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo http://www.yahoo.com/ IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ 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
Re: Sync Search Database crashes Admin Tool and then Freezes
That is what has always happened to me.. I guess the reason why Remedy support asks you to delete the forms is just to clear them out and restart the process. It didn't help me ever.. Often before my admin tool crashed I would run out of system resources on my client - the process nearly hogged all my client memory resource.. In my opinion the database structure has simply grown out too large for this process to handle. I have even tried the operation in a admin only mode, and didn't get too far.. I've even tried the operation on the command line hoping that might work.. still no go.. I've even tried helping the process by truncating the t and h tables and resetting the nextid's to 1 making them look as though the operation was never ever run.. That didn't help me either.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:22:54 PM Subject: Re: Sync Search Database crashes Admin Tool and then Freezes Well shoot, I deleted the forms, but it still crashes my admin tool. Oh well, I guess it's back to the old way of doing it... manually digging through all filters and active links... Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 25, 2008 2:19 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo http://www.yahoo.com/ IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Sync Search Database crashes Admin Tool and then Freezes
Rick, I haven't tried 6.03 patch 24 nor 7.1 Patch 4 as yet.. but its interesting you say that has fixed it cause now I'd be curious to give it a shot.. Did you update only your admin tool to that patch or did it require a server upgrade to 7.1 P4 as well? It used to be a nice to have feature when it worked for the most part so would be good to have it working again.. Joe - Original Message From: Rick Cook [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:26:16 PM Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** The latest patch to AR System 7.1 (patch 4) seems to fix this. Might try it again, if you can use that patch to Admin/Server. Rick On Mon, Aug 25, 2008 at 12:19 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Sync Search Database crashes Admin Tool and then Freezes
Wow, Joe, you really worked hard on this :) My database is very small though, so I think there are other issues at hand. I only have 65 forms, 646 ALS, and 255 filters, and that's including the sample stuff, and all of the AR System forms that are installed by default. I don't want to patch right now, as I'll be moving to 7.1 within a few months anyways. Thanks for all the help. I was hoping there was a solution available. I might try a different version of the admin tool and see if that helps. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 25, 2008 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** That is what has always happened to me.. I guess the reason why Remedy support asks you to delete the forms is just to clear them out and restart the process. It didn't help me ever.. Often before my admin tool crashed I would run out of system resources on my client - the process nearly hogged all my client memory resource.. In my opinion the database structure has simply grown out too large for this process to handle. I have even tried the operation in a admin only mode, and didn't get too far.. I've even tried the operation on the command line hoping that might work.. still no go.. I've even tried helping the process by truncating the t and h tables and resetting the nextid's to 1 making them look as though the operation was never ever run.. That didn't help me either.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:22:54 PM Subject: Re: Sync Search Database crashes Admin Tool and then Freezes Well shoot, I deleted the forms, but it still crashes my admin tool. Oh well, I guess it's back to the old way of doing it... manually digging through all filters and active links... Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 25, 2008 2:19 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo http://www.yahoo.com/ http://www.yahoo.com/ IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have
Re: Sync Search Database crashes Admin Tool and then Freezes
I have to agree with Rick on this issue. I had similar problems with the Sync Search DB crashing my Admin tool when I was running Admin 7.0.1 Patch 8. I upgraded to Admin 7.1 Patch 4, and have since been able to run the Sync Search DB operation without any problems. We are also running the full ITSM 7 Suite of applications. James Van Sickle Remedy Developer Office: 972-409-4902 Mobile: 214-399-1254 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 25, 2008 2:40 PM To: arslist@ARSLIST.ORG Subject: Re: [ARSLIST] Sync Search Database crashes Admin Tool and then Freezes Rick, I haven't tried 6.03 patch 24 nor 7.1 Patch 4 as yet.. but its interesting you say that has fixed it cause now I'd be curious to give it a shot.. Did you update only your admin tool to that patch or did it require a server upgrade to 7.1 P4 as well? It used to be a nice to have feature when it worked for the most part so would be good to have it working again.. Joe - Original Message From: Rick Cook [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:26:16 PM Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** The latest patch to AR System 7.1 (patch 4) seems to fix this. Might try it again, if you can use that patch to Admin/Server. Rick On Mon, Aug 25, 2008 at 12:19 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo http://www.yahoo.com/ IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ _ This email and its attachments, if any, are intended for the personal use of the named recipient(s) and may contain confidential, privileged, or proprietary information. If you are not a named recipient, or an agent responsible for delivering it to a named recipient, you have received this email in error. In that event, please (a) immediately notify me by reply email, (b) do not review, copy, save, forward, or print this email or any of its attachments, and (c) immediately delete and/or destroy this email and its attachments and all
Re: Sync Search Database crashes Admin Tool and then Freezes
I updated just the admin tool to patch 24 at first. It worked fine. Later on did the server. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 25, 2008 2:40 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** Rick, I haven't tried 6.03 patch 24 nor 7.1 Patch 4 as yet.. but its interesting you say that has fixed it cause now I'd be curious to give it a shot.. Did you update only your admin tool to that patch or did it require a server upgrade to 7.1 P4 as well? It used to be a nice to have feature when it worked for the most part so would be good to have it working again.. Joe - Original Message From: Rick Cook [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:26:16 PM Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** The latest patch to AR System 7.1 (patch 4) seems to fix this. Might try it again, if you can use that patch to Admin/Server. Rick On Mon, Aug 25, 2008 at 12:19 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo http://www.yahoo.com/ IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Sync Search Database crashes Admin Tool and then Freezes
Thanks Claire, that's what I was going to try and do. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Sanford, Claire Sent: Monday, August 25, 2008 3:10 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** I updated just the admin tool to patch 24 at first. It worked fine. Later on did the server. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, August 25, 2008 2:40 PM To: arslist@ARSLIST.ORG Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** Rick, I haven't tried 6.03 patch 24 nor 7.1 Patch 4 as yet.. but its interesting you say that has fixed it cause now I'd be curious to give it a shot.. Did you update only your admin tool to that patch or did it require a server upgrade to 7.1 P4 as well? It used to be a nice to have feature when it worked for the most part so would be good to have it working again.. Joe - Original Message From: Rick Cook [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:26:16 PM Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** The latest patch to AR System 7.1 (patch 4) seems to fix this. Might try it again, if you can use that patch to Admin/Server. Rick On Mon, Aug 25, 2008 at 12:19 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo http://www.yahoo.com/ IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Re: Sync Search Database crashes Admin Tool and then Freezes
I only had to update Admin, though you should remember to match versions with your AR Server. Rick On Mon, Aug 25, 2008 at 12:39 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Rick, I haven't tried 6.03 patch 24 nor 7.1 Patch 4 as yet.. but its interesting you say that has fixed it cause now I'd be curious to give it a shot.. Did you update only your admin tool to that patch or did it require a server upgrade to 7.1 P4 as well? It used to be a nice to have feature when it worked for the most part so would be good to have it working again.. Joe - Original Message From: Rick Cook [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:26:16 PM Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** The latest patch to AR System 7.1 (patch 4) seems to fix this. Might try it again, if you can use that patch to Admin/Server. Rick On Mon, Aug 25, 2008 at 12:19 PM, Joe DeSouza [EMAIL PROTECTED]wrote: ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo http://www.yahoo.com/ IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Sync Search Database crashes Admin Tool and then Freezes
Yes thats always a good thing to have the same main version :-) I think I'll give it a shot with a 7.1 P4 Admin tool and a 7.1 P3 server and see how it goes.. Joe - Original Message From: Rick Cook [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 4:22:28 PM Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** I only had to update Admin, though you should remember to match versions with your AR Server. Rick On Mon, Aug 25, 2008 at 12:39 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Rick, I haven't tried 6.03 patch 24 nor 7.1 Patch 4 as yet.. but its interesting you say that has fixed it cause now I'd be curious to give it a shot.. Did you update only your admin tool to that patch or did it require a server upgrade to 7.1 P4 as well? It used to be a nice to have feature when it worked for the most part so would be good to have it working again.. Joe - Original Message From: Rick Cook [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:26:16 PM Subject: Re: Sync Search Database crashes Admin Tool and then Freezes ** The latest patch to AR System 7.1 (patch 4) seems to fix this. Might try it again, if you can use that patch to Admin/Server. Rick On Mon, Aug 25, 2008 at 12:19 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** Gary, It doesn't always work.. What Remedy support reccommends when these crashes occur is to redo the sync database forms by deleting them.. There are 3 of these forms and they all begin with object_ After deleting these forms, rebuild them and then see if it helps.. The primary cause why the sync operation fails is if it is run against a significantly large database - size in terms of structure - thousands of forms, and active links and filters etc.. I was never able to run it on ITSM 7 databases - it either failed by crashing the admin tool or sometimes even though it looks like it has completed with the end message that the search completed, it is actually incomplete. Many of the forms do not have anything in the sync database tables thus showing blank space in the Related Workflow tab.. Over the past year or so I have actually given up on ever expecting this feature to work on large databases such as the ITSM database.. Hope this helps.. Joe - Original Message From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, August 25, 2008 3:10:12 PM Subject: Sync Search Database crashes Admin Tool and then Freezes Sorry for the no subject, my original email had a subject, but it was sent incorrectly and errored. Thanks Roger, that gets the sync to stop. There was a trick out there that some people used that would fix the issue where it would crash the admin tools. I believe it involved deleting some forms. Does anyone remember the issue, because I'm still crashing my admin tool every time I try to sync. Thanks, Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Monday, August 25, 2008 2:06 PM To: arslist@ARSLIST.ORG Subject: ** Gary, Go to the object_search_admin form and set the Run/Not Run to 0. Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Monday, August 25, 2008 2:02 PM To: arslist@ARSLIST.ORG Subject: Hi all, I know that I've seen it on here before, but due to changing jobs, I do not have my vast archive of emails through which I could search. Whenever you sync your search dataset, and it causes your admin tool to crash, then you open your admin tool, it still says it's searching, and never finishes, what is it you do in order to rectify the situation and get a new search database synced? I have seen it done before, but forgot how. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
