I am on a pure custom app on Oracle so my calculations and SQL may differ somewhat from what you need.
Basically I have an SQL script that does the following: Update Ticket t Set t.MTTR = nvl(t.DATE_RESOLVED,TO_EPOCH(SYSTIME))-t.CREATE_DATE Where t.Status <= 2; Commit; Ticket is the database view name of my Ticket form Nvl is an Oracle function that if DATE_RESOLVED is null uses the second parameter. I think Sybase uses NZ TO_EPOCH is a function I created to convert the Oracle database Date/Time to the Remedy version SYSTIME is the Oracle value for current date and time Status 2 = Resolved (on my app) I have a cron job execute this every 15 minutes (that's what my business requirements were for this) Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mahan, Janet L[EQ] Sent: Thursday, April 02, 2009 10:07 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 That is exactly what I am trying to do. The MTTR fields display in a table for the users but if the ticket is not modified they are not current so the escalation fires and modifies tickets that have not been updated in 4 minutes and then the filters calculate the MTTR. How do you do it with SQL directly? Janet Mahan Network Systems Administrator II EMBARQ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Thursday, April 02, 2009 10:53 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 The question is what are you trying to update on the tickets? We have several different automated updates that we run. One is to update an MTTR timer field each hour. We do that with SQL directly. Another updates a field that kicks off workflow. We do that with a tiny cron'ed ARSPerl program. Also are you doing all the work in the escalation or is the escalation just changing a single field and Filters do the rest? Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mahan, Janet L[EQ] Sent: Thursday, April 02, 2009 9:23 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Ok, let me ask something else related to my issue. Does anyone have a recommendation of the best way to update all open tickets every 5 minutes other than an escalation? The escalation seems to fill the memory up and kill the server and my interval does not work correctly. Thanks Janet Mahan Network Systems Administrator II EMBARQ -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, April 01, 2009 2:00 PM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Looking below it looks like you are on a Sun V240. What OS Version "uname -a" and what is your "ulimit -a" values. Also check your disk space "df -k" Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mahan, Janet L[EQ] Sent: Wednesday, April 01, 2009 11:27 AM To: arslist@ARSLIST.ORG Subject: Re: Memory issue on sybase ARS 6.0.1 Any ideas? Janet Mahan -----Original Message----- From: Mahan, Janet L[EQ] Sent: Tuesday, March 31, 2009 2:18 PM To: Mahan, Janet L[EQ]; arsl...@listserv.rbugs.com Subject: RE: Memory issue on sybase ARS 6.0.1 Also get these errors: ARERR [160] Decompression has failed ARERR [300] Malloc failed on server Janet Mahan -----Original Message----- From: Janet Mahan [mailto:janet.ma...@embarq.com] Sent: Tuesday, March 31, 2009 1:20 PM To: arsl...@listserv.rbugs.com Cc: Mahan, Janet L[EQ] Subject: Memory issue on sybase ARS 6.0.1 Does anyone have any suggestions how to fix a memory issue where the arserverd process grows so that the processes die with malloc errors. It seems to be related to escalations that I have updating tickets every 4 or 6 minutes. I have opened tickets with BMC but our version is not really supported. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"