I suspected as much. I would clear out that form (or at least the stuff that's supposed to be gone) before proceeding with the install.
Rick On Thu, Aug 21, 2008 at 1:31 PM, Begosh, Kevin <[EMAIL PROTECTED]>wrote: > ** Rick, > I think that the issue is our sys:action form is not deleting it's > records. When patch 8 runs it tries and install the patch and look through > 800,000 records to delete 10 and the processor cannot take it. For some > reason the records on sys:action are not being deleted when they should. > Has anyone ever ran into that. We have about 800,000 records on that form > and there should not be that many. > > > Kevin Begosh, RSP > > External Initiatives > > System Design & Integration > > 301-791-3540 Phone > > 410-422-3623 Cell > > [EMAIL PROTECTED] > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Rick Cook > *Sent:* Tuesday, August 19, 2008 11:33 AM > > *To:* arslist@ARSLIST.ORG > *Subject:* Re: ITSM Application Patch 8 Install Error > > ** If you re-run the install with Filter and Escalation logs on, then > monitor the arerror log until you see it happening, you will see the > offending workflow object in the other logs. Then you can look at the > actual actions therein to see what it's trying to do and know how to help it > get done. > > Rick > > On Tue, Aug 19, 2008 at 8:24 AM, Begosh, Kevin <[EMAIL PROTECTED]>wrote: > >> ** well the issue that I am having is I do not now what it is doing or >> how to find out what it is doing. Every record on the form sys:action is in >> the enabled status. >> >> >> Kevin Begosh, RSP >> >> External Initiatives >> >> System Design & Integration >> >> 301-791-3540 Phone >> >> 410-422-3623 Cell >> >> [EMAIL PROTECTED] >> >> >> ------------------------------ >> *From:* Action Request System discussion list(ARSList) [mailto: >> [EMAIL PROTECTED] *On Behalf Of *Rick Cook >> *Sent:* Tuesday, August 19, 2008 11:13 AM >> *To:* arslist@ARSLIST.ORG >> >> *Subject:* Re: ITSM Application Patch 8 Install Error >> >> ** What that command does is query every record in the form - >> regardless of whether it's already found its search criteria - for EACH >> record it's trying to delete. The errors are not as severe as they sound, >> but it does take WAY more time than necessary. It should be using the API >> call that contains a query (see the API manual for the exact name - >> something like Application-Delete-Query). That runs through the form ONCE. >> >> However, since you probably can't alter their install procedures, the >> better course is to figure out what it's trying to do and do it before it >> gets there; i.e. if it's trying to remove some rows from SYS:Action, make >> sure that form is free of deletable records before it makes it's call. That >> at least will make the call process less slowly. >> >> Rick >> >> On Tue, Aug 19, 2008 at 7:44 AM, Begosh, Kevin <[EMAIL PROTECTED]>wrote: >> >>> ** well the form that the patch is trying to delete records from is >>> sys:action. I am not sure why it is trying to delete records. From the >>> error I put in the original email I do not think the issue is with the >>> delete, there is a error occurring with each delete and I am not sure why >>> this is happening and why the install is trying to do that. >>> >>> >>> Kevin Begosh, RSP >>> >>> External Initiatives >>> >>> System Design & Integration >>> >>> 301-791-3540 Phone >>> >>> 410-422-3623 Cell >>> >>> [EMAIL PROTECTED] >>> >>> >>> ------------------------------ >>> *From:* Action Request System discussion list(ARSList) [mailto: >>> [EMAIL PROTECTED] *On Behalf Of *Rick Cook >>> *Sent:* Tuesday, August 19, 2008 10:40 AM >>> *To:* arslist@ARSLIST.ORG >>> *Subject:* Re: ITSM Application Patch 8 Install Error >>> >>> ** Kevin, are you seeing a corresponding entry in the Filter/Escalation >>> logs? I think what's happening is that there's one or the other that's >>> deleting a bunch of entries from a form, and it's getting hung up, like an >>> Escalation that ties up a thread or a DB timeout or something. If you can >>> track down the form that's in the delete command, maybe you could just do >>> the delete manually and see if that frees up the rest of the install. >>> >>> Rick >>> >>> On Tue, Aug 19, 2008 at 7:28 AM, Begosh, Kevin <[EMAIL PROTECTED]>wrote: >>> >>>> ** I have experienced the same thing before as well but I guys I should >>>> have clarified this, no it is not doing anything. The second time we let >>>> it >>>> run for about 20 hours and it still never finished. The actually logs are >>>> not getting updated either, like the patch logs. The second time it took >>>> me >>>> only about 3 mins to get to 85% and then it just stopped. >>>> >>>> >>>> Kevin Begosh, RSP >>>> >>>> 301-791-3540 Phone >>>> >>>> 410-422-3623 Cell >>>> >>>> ------------------------------ >>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>> [EMAIL PROTECTED] *On Behalf Of *Ramey, Anne >>>> *Sent:* Tuesday, August 19, 2008 10:20 AM >>>> *To:* arslist@ARSLIST.ORG >>>> *Subject:* Re: ITSM Application Patch 8 Install Error >>>> >>>> ** >>>> >>>> Do you get to a point where you stop getting logs and nothing at all is >>>> happening on either server. If you are still actively getting logs, it is >>>> probably just busy doing something (and failing) and not hung up. How long >>>> did you wait? It could take hours depending on the systems and their power >>>> and speed. >>>> >>>> >>>> >>>> I haven't applied patch 8 myself (recently applied patch 7), this is >>>> just some patching experience on a number of products. >>>> >>>> >>>> >>>> Anne >>>> ------------------------------ >>>> >>>> *From:* Action Request System discussion list(ARSList) [mailto: >>>> [EMAIL PROTECTED] *On Behalf Of *Begosh, Kevin >>>> *Sent:* Tuesday, August 19, 2008 10:13 AM >>>> *To:* arslist@ARSLIST.ORG >>>> *Subject:* ITSM Application Patch 8 Install Error >>>> >>>> >>>> >>>> We are upgrading to ITSM Application patch 8 from patch 7. We have >>>> tried to install this two times and both time it hangs up during the >>>> install. One time at 66% and one time at 85%. I keep getting these error >>>> messages in the arerror.log >>>> >>>> >>>> >>>> 390603 : Failure during an attempt to perform an application command >>>> (ARERR 4554) >>>> Application-Delete-Entry "SYS:Action" 000000001254025 >>>> >>>> It is over and over again with different ID's. The oracle process is >>>> also running at 100% when it gets stuck. >>>> >>>> >>>> >>>> We are on Solaris 5.10 and Oracle 10.2.0.3.0. ARServer 7.1 patch 4 >>>> >>>> >>>> >>>> Kevin Begosh, RSP >>>> >>>> 301-791-3540 Phone >>>> >>>> 410-422-3623 Cell >>>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>>> html_____Platinum Sponsor: www.rmsportal.com ARSlist: "Where the >>>> Answers Are" html___ >>>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>>> html___ >>> >>> >>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>> html___ >>> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >>> html___ >> >> >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ >> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" >> html___ >> > > __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"