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] <mailto:[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: [email protected] 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] <mailto:[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: [email protected] 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] <mailto:[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: [email protected] 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: [email protected] 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: [email protected] 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___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
