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 Voice: 941-766-6199 | Wireless: 407-310-4070 | Fax: 941-766-6199 Email: janet.ma...@embarq.com Voice | Data | Internet | Wireless | Entertainment This e-mail is the property of EMBARQ and may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender and delete all copies of the message. -----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 Voice: 941-766-6199 | Wireless: 407-310-4070 | Fax: 941-766-6199 Email: janet.ma...@embarq.com Voice | Data | Internet | Wireless | Entertainment This e-mail is the property of EMBARQ and may contain confidential and privileged material for the sole use of the intended recipient(s). Any review, use, distribution or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive for the recipient), please contact the sender and delete all copies of the message. -----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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
