Re: finding a good spam killer for remedy
Are the original emails generated by end-users just using a regular email client? Or are they created through some process and/or template? If it's the latter, why not add something specific to the subject line, something the spammers don't know? For example, suppose your system is called Acme Help Desk. You could configure your process/template to send emails with a specific subject like AHD: Trouble Ticket Request or something similar. Then set up a rule that deletes any incoming mail that doesn't have AHD: somewhere in the subject line. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Remedy Maniac Sent: Friday, February 13, 2009 2:22 AM To: arslist@ARSLIST.ORG Subject: finding a good spam killer for remedy dear all, I have been asked to find some way of reducing the number of spams ending in one of our schemas. Obviously and unfortunately, the existing tools are not capable of blocking all the spams. The email lifecycle is quiet a bit cumbersome but I have to live with it. Emails are sent to IMAP server. On my remeyd box, fetchmail pools them and give them to procmailrc. This later does first checks, formats then the emails to fit a certain criterias and give them to the email engine. Upon arrival in the Email Box, my Remedy workflow fires and creates the necessary tickets for Helpdesk or other in-house schema that I wrote. So my idea is to plug something like spamassassin to the procmail. Does anybody have any experience of infos regarding this spam killer? Or any other further hints/tips would be very welcomed. Serouche ___ 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
Re: Setting up Remedy Redundancy Server
Redundancy is immediate, disaster recovery is large-scale. For example, if a hard drive fails on your Remedy server, redundancy (failover) kicks in and ensures service is not interrupted. On the other hand, if a hurricane comes through and destroys your entire data center, that's when you execute your disaster recovery plan. Disaster recovery entails things like having servers in different geographic locations, offsite storage of backup media, long-term storage of backup media, etc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Salma Begum Sent: Thursday, February 05, 2009 10:56 PM To: arslist@ARSLIST.ORG Subject: Re: Setting up Remedy Redundancy Server Dear All, Thnaks you All. Now i m confused with Redudndacy and Disaster Recovery . Can any one explain me this please . If redundacy and disaster recovery both r different concepts then should i go for both the things . If yes can anyone please tell me wat are things i need to do to achive this . Thanks in Advance. Regards, Salma Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE wrote: Just be aware that if you point both servers to a single database, you have not implemented a true hot failover system unless you create a failover machine for the database. So in that model you would not a primary Remedy box and a backup Remedy box and a primary database box and a backup database box. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Thursday, February 05, 2009 1:39 AM To: arslist@ARSLIST.ORG Subject: Re: Setting up Remedy Redundancy Server ** Yes you need to point the second server to the same database Yes you need to purchase a hot backup server license that to the best of my knowledge is 50% of the original license cost. Server Groups is a different concept where you buy a server license for the same cost as the original and have both the servers up at the same time for high availability. This is different from a hot backup. Joe From: Salma Begum salmabeg...@gmail.com To: arslist@ARSLIST.ORG Sent: Thursday, February 5, 2009 2:06:51 AM Subject: Setting up Remedy Redundancy Server Dear All, I have a requirement to setup a failover (Redudancy ) server . i.e. i will have 2 servers Server A and Server B . Server A is my Production server. when ever this goes down the secondary server should come up immediately . Do i need to point both the servers to same database or should i have 2 different databses. Also request you to give me some hint about Licensing . Do i need topurchase separate licenses for secondary as production server. i think these is called as server grouping in Remedy . As i dont hvae much idea abt this request all to give there valuable inputs. Please correct me if i have mentioned some thing wrong . This is just my point of view. Regards, Salma __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are -- View this message in context: http://n2.nabble.com/Setting-up-Remedy-Redundancy-Server-tp2273556p22791 99.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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
Re: Setting up Remedy Redundancy Server
Just be aware that if you point both servers to a single database, you have not implemented a true hot failover system unless you create a failover machine for the database. So in that model you would not a primary Remedy box and a backup Remedy box and a primary database box and a backup database box. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Thursday, February 05, 2009 1:39 AM To: arslist@ARSLIST.ORG Subject: Re: Setting up Remedy Redundancy Server ** Yes you need to point the second server to the same database Yes you need to purchase a hot backup server license that to the best of my knowledge is 50% of the original license cost. Server Groups is a different concept where you buy a server license for the same cost as the original and have both the servers up at the same time for high availability. This is different from a hot backup. Joe From: Salma Begum salmabeg...@gmail.com To: arslist@ARSLIST.ORG Sent: Thursday, February 5, 2009 2:06:51 AM Subject: Setting up Remedy Redundancy Server Dear All, I have a requirement to setup a failover (Redudancy ) server . i.e. i will have 2 servers Server A and Server B . Server A is my Production server. when ever this goes down the secondary server should come up immediately . Do i need to point both the servers to same database or should i have 2 different databses. Also request you to give me some hint about Licensing . Do i need topurchase separate licenses for secondary as production server. i think these is called as server grouping in Remedy . As i dont hvae much idea abt this request all to give there valuable inputs. Please correct me if i have mentioned some thing wrong . This is just my point of view. Regards, Salma __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Jr. Remedy Developer Needed
You also can't get a top secret if you're having a secret affair on your wife (*cough* Clinton! *cough*). The rules, you see, apply to everyone else. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Steve Michadick Sent: Tuesday, January 27, 2009 6:59 AM To: arslist@ARSLIST.ORG Subject: Re: Jr. Remedy Developer Needed You also can not get a Top Secret clearance if you have too much debt, have traveled to multiple countries that are hostile to the U.S., associated with known terrorists, etc. But wait...don't we know someone like that? H...someone that NEEDS to have a Top Secret clearance in order to do his job? Someone with the title President of the United States of America? Sorry, couldn't help myself. Steve Michadick Remedy Engineer MCNOSC -Original Message- From: VanSickle, James W [mailto:james.vansic...@contractor.cmc.com] Sent: Monday, January 26, 2009 11:26 AM Subject: Re: Jr. Remedy Developer Needed ** Sorry, but you're not eligible. As a US citizen, I can't even be married to a foreign national if I want to get Secret or Top Secret clearance. James Van Sickle Remedy Developer Office: 972-409-4902 Mobile: 214-263-9340 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of kiran kodali Sent: Sunday, January 25, 2009 8:31 PM To: arslist@ARSLIST.ORG Subject: Re: [ARSLIST] Jr. Remedy Developer Needed ** Hi Abdullah, I am Kiran Kodali. I am interested in this position. I have one question, I am on my H1B, am i eligible for that Secret clearance? Plz let me know. Thanks. On 1/25/09, Abdullah Baytops ab...@thedigitalcorp.com wrote: ** Digital Foundation is looking for a Jr. Remedy Developer for a project located in the Washington, DC area. Person ideally should would have a Secret clearance but a the ability to be cleared will be fine. Looking for someone with experience in BMC Remedy 7.1 (Incident, Asset and Change Management) also experience with SQL Server 2005. Please send resumes and Salary requirements to ab...@thedigitalcorp.com . The position requires on-site support and remote work periodically. Thanks in advance __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ -- Regards, Kiran Kodali Ph: 940-231-8524 __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ The sender of this e-mail is a contractor to Commercial Metals Company or subsidiaries (collectively CMC). The sender is not an employee of CMC and has no authority, express or implied, to bind CMC to any transaction or contract. CMC allows contractors to utilize this email address extension only in the course of providing services specifically covered by the terms of their engagement. No other use is authorized. CMC expressly disclaims liability for any unauthorized use. __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ 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
Re: Jr. Remedy Developer Needed
I've worked directly for the DoD for past 17 years. From my direct experience, what you're saying is not correct. Neither the organization hiring you nor any boss in the food chain can determine whether you do get a full security clearance. They *can* influence you NOT getting a clearance (anybody can, really), but they cannot see that you do get one. In the Department of Defense, some unit commanders do have the authority to grant INTERIM security clearances while the actual investigation is ongoing; however, the actual investigation is conducted by an outside agency, the Defense Security Service (DSS). Thus, your local boss can't just pick up the phone, call the DSS, and say, Hey, we really need this guy. Push him through. What can negatively affect your chances of getting a security clearance? All of the following: - Being married to a foreign national, especially one from a nation unfriendly to the US - Contacts (friends, business partners, etc.) with foreign nationals, especially those from nations unfriendly to the US - Excessive indebtedness - A history of past or present financial irresponsibility (repossessions, foreclosures, bankruptcy, poor credit score) - Drug use, both past and present - Alcohol abuse, both past and present - Any type of psychological or emotional treatment - Any criminal history - Any membership in any group or association with subversive motives (Communist party, racist groups, militias, etc.) - Anything that may subject you to blackmail Now, just because one of these items may be true in your case doesn't mean you're instantly disqualified. For example, if you're married to a foreign national, that doesn't mean you're instantly disqualified; however, your spouse and his/her family and connections WILL be investigated. If anything sketchy is uncovered, you may not get a clearance. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Tuesday, January 27, 2009 9:56 AM To: arslist@ARSLIST.ORG Subject: Re: Jr. Remedy Developer Needed Please consider the enormous number of senior military personnel who have served overseas and taken spouses from foreign countries. Surely all of those people are not suddenly disqualified from high-ranking military service simply because their spouses are citizens of other countries? It has been my experience that your ability to get a clearance is largely determined by 1. How badly the organization hiring you needs you, 2. How high up the chain of authority they are 3. How senior the decision-making official in charge of the project is 4. Not to give false hope to green-card holders and felons. You still have to be a citizen in good standing. Jennifer Meyer -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Moore, Christopher Allen Sent: Tuesday, January 27, 2009 10:23 AM To: arslist@ARSLIST.ORG Subject: Re: Jr. Remedy Developer Needed James, that's odd- I was cleared for a TS in 2002 while married to a Canadian citizen who didn't yet have a green card. Chris -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of VanSickle, James W Sent: Monday, January 26, 2009 12:20 PM To: arslist@ARSLIST.ORG Subject: Re: Jr. Remedy Developer Needed My information comes from security officials that I spoke with directly within the Pentagon and National Security Agency. Based on their policies, someone who presently does not have security clearance cannot be cleared if they are currently married to a foreign national. However, an already cleared individual is allowed to marry a foreign national, provided that individual does not spawn any red flags during the security review. This was around 2003 to 2004 so I am not clear on whether this policy was in place or heavily enforced before 9/11. However, the fact I was (and still am) married to a Greek national shut down my interview faster than I could say my own name. James Van Sickle Remedy Developer Office: 972-409-4902 Mobile: 214-263-9340 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Wheeler, Dylan Sent: Monday, January 26, 2009 11:14 AM To: arslist@ARSLIST.ORG Subject: Re: [ARSLIST] Jr. Remedy Developer Needed Where did you get that info from? I'm married to a foreign national and although it's inactive, I got my Secret clearance no problem. Dylan Quoting VanSickle, James W james.vansic...@contractor.cmc.com: Sorry, but you're not eligible. As a US citizen, I can't even be married to a foreign national if I want to get Secret or Top Secret clearance. James Van Sickle Remedy Developer Office: 972-409-4902 Mobile: 214-263-9340 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of kiran
Re: Objects in Admin Tool off the Screen
Thanks, dude! That did it. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Axton Sent: Wednesday, January 14, 2009 10:54 AM To: arslist@ARSLIST.ORG Subject: Re: Objects in Admin Tool off the Screen ** Select menu option in the admin tool: Window- Cascase Then close the object. Next time you open an object, they will be in the view. Axton Grams The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. On Wed, Jan 14, 2009 at 9:53 AM, Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE norm.kai...@eglin.af.mil wrote: ** Help. I've had this happen before and I've fixed it before but, of course, I can't remember how. Somehow my Admin tool got set where whenever you double click a server object (AL, filter, etc.), the object's property window is somewhere way off the screen and the vertical and horizontal scrollbars are super long. So you can't see the object. Somehow you can reset the tool so that the default window coordinates are, like, 50, 50. Anyone know? Thanks, Norm __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Objects in Admin Tool off the Screen
Help. I've had this happen before and I've fixed it before but, of course, I can't remember how. Somehow my Admin tool got set where whenever you double click a server object (AL, filter, etc.), the object's property window is somewhere way off the screen and the vertical and horizontal scrollbars are super long. So you can't see the object. Somehow you can reset the tool so that the default window coordinates are, like, 50, 50. Anyone know? Thanks, Norm ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Remedy 7 Upgrade Project Plan (with Milestones)
Haha...Bing probably got his hopes up thinking, Sweet! Someone replied to my thread! There's hope! only to have them dashed by evil Gary's cynicism! -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 14, 2009 9:35 AM To: arslist@ARSLIST.ORG Subject: Re: Remedy 7 Upgrade Project Plan (with Milestones) I have one with just a few milestones: Milestone 1: Begin Milestone 2: False Sense of Hope Milestone 3: Unwelcomed Sense of Reality Milestone 4: Manic Depression Milestone 5: Desperation Milestone 6: Quit your Job Milestone 7: Go Fishing That's pretty much it. Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bradford Bingel Sent: Wednesday, January 14, 2009 9:29 AM To: arslist@ARSLIST.ORG Subject: Remedy 7 Upgrade Project Plan (with Milestones) ** Our large client has an equally large Remedy 7 upgrade planned for later this year. Another consulting firm has been engaged for that planning effort and has presented an initial project plan and list of milestones. Our services have (so far) been limited to developing project management best practices and PM mentoring, but now the client has asked us to weigh in on the proposed upgrade plan. At first glance it appears to overly cumbersome, requiring large amounts of additional consulting services. The client has implied they're concerned they are being used to shore up that vendor's sagging revenues in today's economy. We're inclined to agree, but promised we would seek out an objective, third-party opinion -- namely yours, the ARSlist faithful. If you're willing please share your project plans (with key milestones), suggestions, concerns, and gotcha's for a typical Remedy upgrade. Ideally we're looking for a list of 10-20 key milestones, with prerequisite tasks and any dependencies. Many thanks in advance! -- Bing Bradford Bingel (Bing) ITM3 California b...@itm3.com (email) 925-260-6394 (mobile) __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ 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
Re: My New Job!
Yes, congratulations, Mark. I predict we will see many more consummate Remedy pros like you reinvent themselves and branch out into other non-Remedy things. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Meyer, Jennifer L Sent: Wednesday, January 07, 2009 9:10 AM To: arslist@ARSLIST.ORG Subject: Re: My New Job! ** Congratulations, Mark! I hope we'll still hear from you on occasion? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Sent: Wednesday, January 07, 2009 9:54 AM To: arslist@ARSLIST.ORG Subject: OT: My New Job! Listers, friends, and former colleagues My long job search has ended :) Next week, I start a new position with THE University of Texas! (here in Austin). And while they do use Remedy somewhere on campus, I will not. I will be using every other skill I have used over the last 12 or so years of Remedy development and consulting. All of the project lead/coordinating, requirements gathering, solution design, consensus building, customer management Thanks to everyone who helped in my job search! It was very nice to know that so many people, friends and strangers alike, were willing to reach out and help. Thank you, and goodnight! Mark Blankenship The University of Texas Office of Information Management and Analysis (I'm the guy with the big s**t eating grin on his face) __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
Re: Active Link works on dev; not on prod
Permissions? -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arslist@ARSLIST.ORG Subject: Active Link works on dev; not on prod ** AR Server 6.3/ WUT 6.3/ Windows 2k3/ MSSQLServer So, I just developed a form and some active links on dev, then imported them into prod, and one of the ALs doesn't work. So, the active link does a set fields. It sets 'Ticket Count' = $tbl_Tickets$ On dev, this will set the Ticket Count integer field to the number of records in the tbl_Tickets table. This works fine in dev, but not in prod. Below are the logs from each table refresh: Dev: WFLG /* Wed Jan 07 2009 14:35:26 */ WFLG Workflow Trace Log -- ON ACTL /* Wed Jan 07 2009 14:35:28 */ ACTL Start active link processing -- Operation - On Menu Choice ACTL For Schema - HD: My Stats ACTL Linked to field - Table Properties: (536870936) ACTL On screen type - CREATE ACTL Checking HD: MS: Set Table Qual on Table Properties: Change (10) ACTL - Passed qualification -- perform if actions ACTL 0: Set Fields ACTL Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( 'Create Date' = 04/01/2008) ACTL Checking HD: MS: Refresh tbl_My Tickets (50) ACTL - Passed qualification -- perform if actions ACTL 0: Set Characteristics ACTL For field -- Tickets (536870932) ACTL Refresh field ACTL 1: Set Fields ACTL Ticket Count: (536870937) = 21 ACTL /* Wed Jan 07 2009 14:35:28 */ ACTL Stop active link processing - On Menu Choice WFLG /* Wed Jan 07 2009 14:35:34 */ WFLG Workflow Trace Log -- OFF Prod: WFLG /* Wed Jan 07 2009 14:34:54 */ WFLG Workflow Trace Log -- ON ACTL /* Wed Jan 07 2009 14:35:02 */ ACTL Start active link processing -- Operation - On Menu Choice ACTL For Schema - HD: My Stats ACTL Linked to field - Table Properties: (536870936) ACTL On screen type - CREATE ACTL Checking HD: MS: Set Table Qual on Table Properties: Change (10) ACTL - Passed qualification -- perform if actions ACTL 0: Set Fields ACTL Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( 'Create Date' = 04/01/2008) ACTL Checking HD: MS: Refresh tbl_My Tickets (50) ACTL - Passed qualification -- perform if actions ACTL 0: Set Characteristics ACTL For field -- Tickets (536870932) ACTL Refresh field ACTL 1: Set Fields ACTL Ticket Count: (536870937) = 0 ACTL /* Wed Jan 07 2009 14:35:03 */ ACTL Stop active link processing - On Menu Choice WFLG /* Wed Jan 07 2009 14:35:09 */ WFLG Workflow Trace Log - OFF Any help is greatly appreciated. Gary __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: XtremeAir (NEW INTERFACE) (UNCLASSIFIED)
I get a TCP error when I try to go to the link below. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kurniadi Sent: Tuesday, December 30, 2008 12:14 PM To: arslist@ARSLIST.ORG Subject: Re: XtremeAir (NEW INTERFACE) (UNCLASSIFIED) I've installed the Adobe AIR, and opening XtremeAIR with it. The GUI is displayed, but can't login yet. This is the error message that I got after login: Error: [IOErrorEvent type=ioError bubbles=false cancelable=false eventPhase=2 text=Error #2032 errorID=2032]. URL: http://www.buoyantsolutions.net:8080/xmlgateway/servlet/XMLGateway?serve r=pegasusaction=querytype=arstemplate=remFlexGetTeamMembersauthKey=7 7query=('700033535'=mmcdonald)jession=7FB59DFDDC82050C177F4DE8BEB275 DFtm=1230660212312 Do i miss something? Thanks. Kurniadi On Wed, Dec 31, 2008 at 12:33 AM, Gidd g...@buoyantsolutions.net wrote: Mike, I am working on a viewlet and will send a link shortly. Good suggestion too ! ___ 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
JOBAIDS?
Is anyone here familiar with a bundle of resources called JOBAIDS? Another developer I work with says she needs it...I'm not familiar with it. Anyone know about it and where I might get it? Thanks, Norm ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: JOBAIDS?
That's what I suspected, too, but this admin insists it's some executables she used in a Remedy class. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Thursday, December 18, 2008 1:49 PM To: arslist@ARSLIST.ORG Subject: Re: JOBAIDS? ** I'm pretty sure that jobs aids are just a fancy term for documentation. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Thursday, December 18, 2008 1:42 PM To: arslist@ARSLIST.ORG Subject: JOBAIDS? ** Is anyone here familiar with a bundle of resources called JOBAIDS? Another developer I work with says she needs it...I'm not familiar with it. Anyone know about it and where I might get it? Thanks, Norm __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Private and confidential as detailed here http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access hyperlink, please e-mail sender. __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: SQL statement error
Looks like $PO Number$ is a field reference and Remedy is passing the contents of PO Number (not the field name) to SQL, which is likely NULL because the field is empty when you run this. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie Sent: Wednesday, December 17, 2008 1:11 PM To: arslist@ARSLIST.ORG Subject: SQL statement error ** Listers ~ I am getting the following error during a SQL set fields action: ARERR [552] Failure during SQL operation to the database : The max function requires 1 argument(s). (SQL Server 174) My SQL command is listed below and I can successfully run it from SQL Server: SELECT max($PO Number$) + 1 FROM AST_PurchaseOrder What am I doing wrong here? Thank you in advance. Windows Server 2003 SQL Server 2005 7.1.00 Patch 002 AR Server 7.0.03 Patch 006 Service Desk Asset Management CMDB - 2.1.00 Patch 002 DSL - 1.0.00 Patch 1516 Laurie Muhlethaler First Republic Bank Remedy Developer / Administrator 415.364.4436 [First Republic Bank logo]http://logos.firstrepublic.com/FRB.jpg The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This message cannot be guaranteed to be secure or error-free. First Republic Bank and its related entities do not take responsibility for, or accept time-sensitive instructions sent by email including orders, funds transfer instructions or stop payments on checks. All instructions of this nature must be handled by direct communication, not email. We reserve the right to monitor and review the content of all email communications sent or received. Emails sent to or from this address may be stored in accordance with regulatory requirements. First Republic Bank is a Division of Merrill Lynch Bank Trust Co., FSB __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: SQL statement error
What I was trying to say in my original reply (and communicated poorly) was that $PO Number$ tells Remedy to translate what's currently in the PO Number field and poke it into the SQL statement. So if PO Number currently contains the value skizzle, you'll end up passing... max(skizzle) + 1 FROM AST_PurchaseOrder to the database! Which results in...error! So you need to supply the actual field name, as it's represented in the database, which is probably PO_Number. So the SQL would be... max(PO_Number) + 1 FROM AST_PurchaseOrder And then just set PO Number in the SET FIELDS action to $1$. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie Sent: Wednesday, December 17, 2008 1:38 PM To: arslist@ARSLIST.ORG Subject: Re: SQL statement error Yes - that's exactly what I'm doing. I am doing it via a Set Fields action. I don't want to do this through a Direct SQL If Action, do I? Laurie Muhlethaler Remedy Developer / Administrator On Wed, 17 Dec 2008 13:31:06 -0600, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH gary.opela@tinker.af.mil wrote: Do a set fields from direct SQL. Have your sql query be: SELECT max($PO Number$) + 1 FROM AST_PurchaseOrder Map your PO Number field at the bottom to $1$ Is this what you are doing? Thanks, Gary Opela, Jr. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie Sent: Wednesday, December 17, 2008 1:29 PM To: arslist@ARSLIST.ORG Subject: Re: SQL statement error I'm not sure I understand. I want to auto-populate the PO Number field with the next available PO #. I would like to accomplish this through direct SQL rather than creating an additional field(s) and workflow? Laurie Muhlethaler Remedy Developer / Administrator On Wed, 17 Dec 2008 13:15:41 -0600, Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE norm.kai...@eglin.af.mil wrote: Looks like $PO Number$ is a field reference and Remedy is passing the contents of PO Number (not the field name) to SQL, which is likely NULL because the field is empty when you run this. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie Sent: Wednesday, December 17, 2008 1:11 PM To: arslist@ARSLIST.ORG Subject: SQL statement error ** Listers ~ I am getting the following error during a SQL set fields action: ARERR [552] Failure during SQL operation to the database : The max function requires 1 argument(s). (SQL Server 174) My SQL command is listed below and I can successfully run it from SQL Server: SELECT max($PO Number$) + 1 FROM AST_PurchaseOrder What am I doing wrong here? Thank you in advance. Windows Server 2003 SQL Server 2005 7.1.00 Patch 002 AR Server 7.0.03 Patch 006 Service Desk Asset Management CMDB - 2.1.00 Patch 002 DSL - 1.0.00 Patch 1516 Laurie Muhlethaler First Republic Bank Remedy Developer / Administrator 415.364.4436 [First Republic Bank logo]http://logos.firstrepublic.com/FRB.jpg The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This message cannot be guaranteed to be secure or error-free. First Republic Bank and its related entities do not take responsibility for, or accept time-sensitive instructions sent by email including orders, funds transfer instructions or stop payments on checks. All instructions of this nature must be handled by direct communication, not email. We reserve the right to monitor and review the content of all email communications sent or received. Emails sent to or from this address may be stored in accordance with regulatory requirements. First Republic Bank is a Division of Merrill Lynch Bank Trust Co., FSB __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 == = = --- - -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons
Overcoming the 60 Second Timeout in 6.3
Hi all: Is anyone aware of a trick that allows you to overcome the 60 second timeout on ARS 6.3? Thanks, Norm ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Overcoming the 60 Second Timeout in 6.3
No, sorry...the process timeout. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Halstead Sent: Tuesday, December 16, 2008 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: Overcoming the 60 Second Timeout in 6.3 ** Timeout on what exactly? Connecting to the server with the user tool? On Tue, Dec 16, 2008 at 12:15 PM, Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE norm.kai...@eglin.af.mil wrote: ** Hi all: Is anyone aware of a trick that allows you to overcome the 60 second timeout on ARS 6.3? Thanks, Norm __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Robert Halstead __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Re: Overcoming the 60 Second Timeout in 6.3
Well, yeah, you can, but the maximum value is 60 seconds in 6.3. I believe that maximum in 7.x is 600 seconds now...I could be mistaken, of course. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Tuesday, December 16, 2008 3:47 PM To: arslist@ARSLIST.ORG Subject: Re: Overcoming the 60 Second Timeout in 6.3 I believe in the Server Configuration you can change the Process timeout value -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, December 16, 2008 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Overcoming the 60 Second Timeout in 6.3 No, sorry...the process timeout. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Halstead Sent: Tuesday, December 16, 2008 3:35 PM To: arslist@ARSLIST.ORG Subject: Re: Overcoming the 60 Second Timeout in 6.3 ** Timeout on what exactly? Connecting to the server with the user tool? On Tue, Dec 16, 2008 at 12:15 PM, Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE norm.kai...@eglin.af.mil wrote: ** Hi all: Is anyone aware of a trick that allows you to overcome the 60 second timeout on ARS 6.3? Thanks, Norm __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Robert Halstead __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___
Re: FW: OT-BMC Software cut 350 jobs, including 50 here in Houston
Agreed. And if you want to help speed the recovery, GO BUY SOMETHING! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Warren Baltimore Sent: Wednesday, December 10, 2008 9:08 AM To: arslist@ARSLIST.ORG Subject: Re: FW: OT-BMC Software cut 350 jobs, including 50 here in Houston ** Nothing says Merry Christmas quite like a pink slip. It's happening all over. Bad times. Here's to a quick recovery. Warren On Wed, Dec 10, 2008 at 8:50 AM, Barber, David [EMAIL PROTECTED] wrote: ** Sadly not, as mentioned by David J. Easter on the list last week : http://finance.yahoo.com/news/BMC-Software-to-cut-350-jobs-apf-13759414. html Here's wishing those laid off the best of luck finding alternative employment - hope the holiday period is kind to them. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rudolf Schwarzkopf Sent: 10 December 2008 11:44 To: arslist@ARSLIST.ORG Subject: Re: FW: OT-BMC Software cut 350 jobs, including 50 here in Houston ** Friday Humor? On Tue, Dec 9, 2008 at 4:38 PM, Sanford, Claire [EMAIL PROTECTED] wrote: ** I sent this on Friday __ From: Sanford, Claire Sent: Friday, December 05, 2008 1:13 PM To: 'arslist@ARSLIST.ORG' Subject:OT-BMC Software cut 350 jobs, including 50 here in Houston BMC Software cut 350 jobs, including 50 here in Houston By BRAD HEM Copyright 2008 Houston Chronicle Dec. 5, 2008, 12:03PM BMC Software will cut 350 jobs, including 50 in its hometown of Houston, by the end of the month, the company said today in a regulatory filing. The cuts are expected to cost the company $18 million to $23 million in severance and other termination costs, which will be booked in the third and fourth quarters of 2009, BMC said. Company leaders committed to make the cuts on Nov. 20 and notified employees this morning. The layoffs will hit a variety of types of workers in several countries where the company operates. The company has about 1,100 workers in Houston and about 5,900 worldwide. BMC said future work force reductions may be needed if global economic conditions continue to deteriorate. [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ This e-mail has been scanned for viruses by the Cable Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Warren R. Baltimore II Remedy Developer 410-533-5367 __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: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Thanks! Good article. I wasn't aware of the Select-Query-Hint: NOLOCK option for the ar.cfg. While I certainly don't doubt the power of Oracle, if Oracle doesn't lock the table or row during a query, you run the risk of uncommitted or stale being returned by the query...which is exactly the drawback of NOLOCK. So as I see it, switching to Oracle would not overcome that risk. So I'm considering trying the NOLOCK option, but the dangers of stale/dirty data being returned really worry me. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Martin, Conny Sent: Thursday, December 04, 2008 2:03 AM To: arslist@ARSLIST.ORG Subject: AW: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) There is an option in ar.conf Select-Query-Hint: NOLOCK Documentation says: The text to be used in a query hint (in the WITH clause of a SELECT statement) when queries are supplied to SQL Server databases. This parameter works only on queries triggered by GLE, GLEWF, and GME API calls. If this configuration item is an empty string or is not present, no WITH clause is generated. Consult your SQL Server to determine the appropriateness of using this feature in your environment. The Select-Query-Hint option is commonly used with a NOLOCK setting for allowing queries to execute without being blocked by simultaneous updates, thereby improving performance. For example, to allow SQL Server to read data in the process of being updated and avoid blocking, specify: Select-Query-Hint: NOLOCK Here is a useful site explaining NOLOCK http://articles.techrepublic.com.com/5100-10878_11-6185492.html Using NOLOCK has some drawbacks. If you don't want these drawbacks use Oracle! Oracle never put's locks on tables/rows that are read by a select statement. Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Im Auftrag von LJ Longwing Gesendet: Donnerstag, 4. Dezember 2008 03:31 An: arslist@ARSLIST.ORG Betreff: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) I completely agree that we are talking about a like statement on a wide table that won't use an index with over 500K records in it...this is a 'bad' thing to say the leastbut according to my DBA, you can instruct SQL to not block other query/update/insert to the table while the inefficient query is being run...while this isn't ideal...it makes it so that it's not blocking. It's dirty, not because it's inefficient, but because it's possible for the data to change before it's all given to you...and I agree that this is likely to happen on any DBany db that allows searching on the diary fields. One 'solution' that you could look into that others recommended earlier in the thread is to use the Full Text Search capability reintroduced in the 7.x worldit is a separate indexing service that indexes specific fields that you want to search on (diary fields especially) and allows for efficient searching of those records without hurting the DB. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 4:54 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, that's called SQL injection, but that doesn't apply here, as Remedy guards against it through parameterized statements. In this case, the dirty query isn't really dirty, it's just inefficient. That is, searching a massive diary field against a half million records, which Remedy allows you to do out-of-the-box. I hope Doug is monitoring this thread, as I think what I'm describing could happen on ANY database. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Wednesday, December 03, 2008 4:43 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) I'm told by my DBA that it's possible to write 'dirty' queries that won't lock the DB, but I haven't been able to figure out how to make Remedy run them...it's basically an appendage to the end of the sql statement. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 2:14 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, it looks like I found it. Microsoft SQL handles lock escalation dynamically. The escalation can, well, escalate to a table lock. Here's Microsoft article on the issue: http://support.microsoft.com/kb/323630 I ran the Profiler, and sure enough, that's exactly what's happening! The fix? Write better, smaller queries. Damn. -Original
Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Thanks for the reply. I'm familiar with the FTS option, but unfortunately it's not an option because of a) Cost b) The site is running 6.3 and cannot upgrade (I don't think FTS licenses are available for 6.3) and c) Cost! Good suggestion, anyway. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Wednesday, December 03, 2008 8:31 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) I completely agree that we are talking about a like statement on a wide table that won't use an index with over 500K records in it...this is a 'bad' thing to say the leastbut according to my DBA, you can instruct SQL to not block other query/update/insert to the table while the inefficient query is being run...while this isn't ideal...it makes it so that it's not blocking. It's dirty, not because it's inefficient, but because it's possible for the data to change before it's all given to you...and I agree that this is likely to happen on any DBany db that allows searching on the diary fields. One 'solution' that you could look into that others recommended earlier in the thread is to use the Full Text Search capability reintroduced in the 7.x worldit is a separate indexing service that indexes specific fields that you want to search on (diary fields especially) and allows for efficient searching of those records without hurting the DB. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 4:54 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, that's called SQL injection, but that doesn't apply here, as Remedy guards against it through parameterized statements. In this case, the dirty query isn't really dirty, it's just inefficient. That is, searching a massive diary field against a half million records, which Remedy allows you to do out-of-the-box. I hope Doug is monitoring this thread, as I think what I'm describing could happen on ANY database. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Wednesday, December 03, 2008 4:43 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) I'm told by my DBA that it's possible to write 'dirty' queries that won't lock the DB, but I haven't been able to figure out how to make Remedy run them...it's basically an appendage to the end of the sql statement. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 2:14 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, it looks like I found it. Microsoft SQL handles lock escalation dynamically. The escalation can, well, escalate to a table lock. Here's Microsoft article on the issue: http://support.microsoft.com/kb/323630 I ran the Profiler, and sure enough, that's exactly what's happening! The fix? Write better, smaller queries. Damn. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading Sent: Wednesday, December 03, 2008 2:30 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Is there something going on with that table that locks it when someone searches? Maybe it is as simple as changing the lockmode from table to row? Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 14:18 To: arslist@ARSLIST.ORG Subject: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) *** UPDATE *** Well, it appears I don't have to toilet paper my own house after all. As I reported below, I attempted to fix my problem with spotty, intermittent performance by increasing my fast and list threads from 5 to 30. That did nothing. I still have the same problem. The issue is most definitely related to diary searches, but I would *expect* that a diary search would not so drastically impact ALL users as it does. I can understand the person who invoked the diary search having a problem, but considering there are so many other threads available and CPU utilization remains under 10%, I would think other users would not be impacted so dramatically. But it never fails...I can reproduce the problem 100% of the time. I kick off a diary search
Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
*** ADDITIONAL THOUGHTS *** So I was thinking about this last night on the drive home. Here is what I believe is the anatomy of the problem: 1) The Remedy client allows end user to construct their own queries, including against diary fields 2) End users query diary fields 3) Because of the voluminous amount of data in the diary field and because searching a diary is effectively performing a LIKE against that voluminous amount of data, that puts a heavy query load on the underlying DB 4) The underlying DB locks the table during such a query to prevent itself from returning stale/uncommitted/dirty data 5) Because the table is locked, other users attempting to do a search or commit lock up until the table is unlocked Now the thing that makes me wonder is step 3. Most assuredly, performing a LIKE statement against a voluminous amount of data in a diary field is intensive. However, the CPU utilization during this operation remains under 10%. One would think that if the query is burdensome, the CPU would peg out at 100% to complete the request faster. Is it, perhaps, not the processor that's causing the query to return so slowly? Perhaps it's a memory issue? I'm going to monitor memory consumption by the SQL process to test this hypothesis. Thoughts? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Martin, Conny Sent: Thursday, December 04, 2008 2:03 AM To: arslist@ARSLIST.ORG Subject: AW: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) There is an option in ar.conf Select-Query-Hint: NOLOCK Documentation says: The text to be used in a query hint (in the WITH clause of a SELECT statement) when queries are supplied to SQL Server databases. This parameter works only on queries triggered by GLE, GLEWF, and GME API calls. If this configuration item is an empty string or is not present, no WITH clause is generated. Consult your SQL Server to determine the appropriateness of using this feature in your environment. The Select-Query-Hint option is commonly used with a NOLOCK setting for allowing queries to execute without being blocked by simultaneous updates, thereby improving performance. For example, to allow SQL Server to read data in the process of being updated and avoid blocking, specify: Select-Query-Hint: NOLOCK Here is a useful site explaining NOLOCK http://articles.techrepublic.com.com/5100-10878_11-6185492.html Using NOLOCK has some drawbacks. If you don't want these drawbacks use Oracle! Oracle never put's locks on tables/rows that are read by a select statement. Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Im Auftrag von LJ Longwing Gesendet: Donnerstag, 4. Dezember 2008 03:31 An: arslist@ARSLIST.ORG Betreff: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) I completely agree that we are talking about a like statement on a wide table that won't use an index with over 500K records in it...this is a 'bad' thing to say the leastbut according to my DBA, you can instruct SQL to not block other query/update/insert to the table while the inefficient query is being run...while this isn't ideal...it makes it so that it's not blocking. It's dirty, not because it's inefficient, but because it's possible for the data to change before it's all given to you...and I agree that this is likely to happen on any DBany db that allows searching on the diary fields. One 'solution' that you could look into that others recommended earlier in the thread is to use the Full Text Search capability reintroduced in the 7.x worldit is a separate indexing service that indexes specific fields that you want to search on (diary fields especially) and allows for efficient searching of those records without hurting the DB. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 4:54 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, that's called SQL injection, but that doesn't apply here, as Remedy guards against it through parameterized statements. In this case, the dirty query isn't really dirty, it's just inefficient. That is, searching a massive diary field against a half million records, which Remedy allows you to do out-of-the-box. I hope Doug is monitoring this thread, as I think what I'm describing could happen on ANY database. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Wednesday, December 03, 2008 4:43 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) I'm told by my DBA that it's possible to write 'dirty' queries that won't lock the DB
Re: SSO CAC Authentication
It's not too hard doing it on the Midtier, but doing it on the client is much more involved. Like Jennifer Meyer said, to do it on the client, there's a whitepaper out there somewhere. Good luck! I don't know anyone who's done it successfully... -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abdullah Baytops Sent: Tuesday, December 02, 2008 11:35 AM To: arslist@ARSLIST.ORG Subject: SSO CAC Authentication ** Hello Listers Does anyone have any information on how to begin with an CAC auth. for a government client? We have a requirement to have users have the ability to login using SSO CAC cards. Has anyone done this yet or is there a product to make this a seamless intergration any information would be appreciated. V/R Abdul Baytops Web: www.thedigitalcorp.com http://www.thedigitalcorp.com Email: [EMAIL PROTECTED] __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: SSO CAC Authentication
Yes, Jason, you are 100% right to my knowledge. I remember that being their solution advertised about a year and a half ago and it only works in version 7.0 (if memory serves me correctly). So when I considered that solution I said to myself, A) We're running 6.3, so it wouldn't work anyway and B) Trying to compile and/or interface with a dll distribute it to all clients would be extraordinarily difficult. Am I right that the dll has to be on each client? Awhile back I wrote an application that did single sign on for Remedy that I hoped would satisfy the DoD mandate, but it didn't. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Sent: Wednesday, December 03, 2008 9:02 AM To: arslist@ARSLIST.ORG Subject: Re: SSO CAC Authentication ** The white paper is just about useless. It provides the base code for a dll that the v7+ user tool will check for when it's opening. The dll base code supplies a static username, password, and preference server/port/rpc. If you're not a programmer, you'll need to hire one to build an application that the dll can call, collect or generate login credentials, and then supply that information to the user tool. (BMC will not provide any support for this. All they will give you is the base code that will let your programmer know what values to provide for authentication.) The major problem with the dll is that it still requires a username and password. Your external application will need to pull or build that information then supply it to the system. If you're using the mid-tier too, you'll need to build a solution that works to retrieve login credentials from both clients. The downside to the dll is security. There's no way to force the use of the dll. It's simply a file that resides on the client machine. If you delete it, you'll get the regular login prompt. If anybody reverse engineers the dll and identifies how you're retrieving/building the login credentials, they can then log in as anybody. Anybody accept admins. Admins will still need to login manually. The dll doesn't work for the Admin tool. The dll doesn't work well with the alert tool either. It'll login, but in the 7.0 version(haven't tried with 7.1) it would prompt you for a username when trying to open any alerts unless an instance of the usertool is already running. There is a working group comprised of BMC and DOD Remedy Developers, etc... that are working on a solution. However, I haven't heard from them in quite some time so I wouldn't hold your breath. Jason Bess Bess Development Corp From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, December 3, 2008 5:35:52 PM Subject: Re: SSO CAC Authentication It's not too hard doing it on the Midtier, but doing it on the client is much more involved. Like Jennifer Meyer said, to do it on the client, there's a whitepaper out there somewhere. Good luck! I don't know anyone who's done it successfully... -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abdullah Baytops Sent: Tuesday, December 02, 2008 11:35 AM To: arslist@ARSLIST.ORG Subject: SSO CAC Authentication ** Hello Listers Does anyone have any information on how to begin with an CAC auth. for a government client? We have a requirement to have users have the ability to login using SSO CAC cards. Has anyone done this yet or is there a product to make this a seamless intergration any information would be appreciated. V/R Abdul Baytops Web: www.thedigitalcorp.com http://www.thedigitalcorp.com/ http://www.thedigitalcorp.com http://www.thedigitalcorp.com/ Email: [EMAIL PROTECTED] __Platinum Sponsor: www.rmsportal.com http://www.rmsportal.com/ ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://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: SSO CAC Authentication
The workaround I came up with was to automatically login by pulling information from environment variables. Yep! That's pretty much exactly what I did. I even changed the file associations so that when the user double clicked the ARTask attachment in email, my custom app kicked in and did the same type of authentication and then fired up the User client, but the Air Force balked because the solution was not directly re-validating the user from the CAC; it was instead trusting that the OS had previously validated the user from the CAC. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Sent: Wednesday, December 03, 2008 9:24 AM To: arslist@ARSLIST.ORG Subject: Re: SSO CAC Authentication ** Correct, the dll needs to be on each client. I've run into the same issue with DOD clients. The workaround I came up with was to automatically login by pulling information from environment variables. Then once logged in, re-check environment variables, log the users information, and exit the app if OS and Remedy information didn't match. Not a perfect solution but, the autonotifications to the admins and security folks allow for quick response to anybody trying to bypass the system. From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, December 3, 2008 6:12:33 PM Subject: Re: SSO CAC Authentication Yes, Jason, you are 100% right to my knowledge. I remember that being their solution advertised about a year and a half ago and it only works in version 7.0 (if memory serves me correctly). So when I considered that solution I said to myself, A) We're running 6.3, so it wouldn't work anyway and B) Trying to compile and/or interface with a dll distribute it to all clients would be extraordinarily difficult. Am I right that the dll has to be on each client? Awhile back I wrote an application that did single sign on for Remedy that I hoped would satisfy the DoD mandate, but it didn't. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Sent: Wednesday, December 03, 2008 9:02 AM To: arslist@ARSLIST.ORG Subject: Re: SSO CAC Authentication ** The white paper is just about useless. It provides the base code for a dll that the v7+ user tool will check for when it's opening. The dll base code supplies a static username, password, and preference server/port/rpc. If you're not a programmer, you'll need to hire one to build an application that the dll can call, collect or generate login credentials, and then supply that information to the user tool. (BMC will not provide any support for this. All they will give you is the base code that will let your programmer know what values to provide for authentication.) The major problem with the dll is that it still requires a username and password. Your external application will need to pull or build that information then supply it to the system. If you're using the mid-tier too, you'll need to build a solution that works to retrieve login credentials from both clients. The downside to the dll is security. There's no way to force the use of the dll. It's simply a file that resides on the client machine. If you delete it, you'll get the regular login prompt. If anybody reverse engineers the dll and identifies how you're retrieving/building the login credentials, they can then log in as anybody. Anybody accept admins. Admins will still need to login manually. The dll doesn't work for the Admin tool. The dll doesn't work well with the alert tool either. It'll login, but in the 7.0 version(haven't tried with 7.1) it would prompt you for a username when trying to open any alerts unless an instance of the usertool is already running. There is a working group comprised of BMC and DOD Remedy Developers, etc... that are working on a solution. However, I haven't heard from them in quite some time so I wouldn't hold your breath. Jason Bess Bess Development Corp From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, December 3, 2008 5:35:52 PM Subject: Re: SSO CAC Authentication It's not too hard doing it on the Midtier, but doing it on the client is much more involved. Like Jennifer Meyer said, to do it on the client, there's a whitepaper out there somewhere. Good luck! I don't know anyone who's done it successfully... -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Abdullah Baytops Sent: Tuesday, December 02, 2008 11:35 AM To: arslist@ARSLIST.ORG Subject: SSO CAC Authentication ** Hello Listers Does anyone have any information on how to begin with an CAC auth. for a government client? We have a requirement to have users have the ability to login using SSO CAC cards. Has anyone done this yet
Re: SSO CAC Authentication
Well, there's really two issues (for DoD, at least): SSO and CAC authentication. DoD wants a solution that does both. Jason pointed out, [Passlogix] doesn't make the CAC required to access Remedy. If that's true, it's out as far as DoD is concerned. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Scott Hammons Sent: Wednesday, December 03, 2008 12:40 PM To: arslist@ARSLIST.ORG Subject: Re: SSO CAC Authentication ** Agreed for the most part. However, to the end users this gives them the perception that this is SSO. The minimal additional security part can be debated. Most companies I've worked in )commerial and government) have users storing credentials in spreadsheets, in notepad files, in sticky notes (all of the common security issues I'm sure others have seen). Additionally, I've seen where the password policies are documented but not enforced. At least with the Passlogix product set it does provide the password management capability to simulate the SSO process to the end users, centrally and securely store the credentials (supports major encryption algorithms (AES, Blowfish, etc...), and supports CAC authentication systems. The application also works with the majority of applications and doesn't require any modification of the application itself. Is this true SSO? I would say not because true SSO would have applications accepting authentication from a single authentication authority and until the industry and product vendors can work together on a standard integration it will be hard to achieve. Applications from vendors like Passlogix make it easier to simulate an SSO environment. So whenever I hear about SSO integration I think there is a bigger question to be answered here and that is do I implement a solution to meet the requirements of one application (and then have to do this every time a application wants SSO) or do I provide a solution that would work for a majority of the applications that the end users are using and would provide additional security that auditors would be looking for? Just my .02. Scott From: Action Request System discussion list(ARSList) [EMAIL PROTECTED] On Behalf Of Jason [EMAIL PROTECTED] Sent: Wednesday, December 03, 2008 12:44 PM To: arslist@ARSLIST.ORG Subject: Re: SSO CAC Authentication ** Passlogix provides a password management system. It is no more secure than the automatic authentication processes we've already discussed. It is merely a program that stores the end users' username and password for individual websites and applications and sends it to the appropriate application when activated. While you can use CAC authentication to access the stored information. It doesn't make the CAC required to access Remedy. These types of applications only provide ease of use for the end user and minimal additional security by encouraging more complex passwords. From: Scott Hammons [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, December 3, 2008 7:12:31 PM Subject: Re: SSO CAC Authentication All, There are products out there that will meet the DOD requirements. One of the industry leaders in the SSO market is Passlogix and they support CAC authentication as well. Website: www.passlogix.com http://www.passlogix.com/ One good thing about their SSO solution is that it will work for most applications (not just Remedy). Hope this helps. Scott From: Action Request System discussion list(ARSList) [ mailto:ars__Platinum Sponsor: www.rmsportal.com ARSlist: ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Mid-Tier passwords
Bob, does the login.jsp appear in the browser at all and it says something like logon failed or something like that? Or does the login.jsp not appear at all? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Decou, Candace M Sent: Wednesday, December 03, 2008 1:56 PM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier passwords ** Bob - on the IIS 6 make sure you specify IUSR_SERVERNAME has explicit permissions to the Mid-Tier and WEB-INF directory structures. I think there is another user perhaps that may also need permissions, but that's one place you might start. Not sure on the Sun server. Hope this helps. Candace From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bob Rowe Sent: Tuesday, December 02, 2008 10:59 AM To: arslist@ARSLIST.ORG Subject: Mid-Tier passwords ** I have been loading and trying to configure Mid-Tier 7.1 all day. I have: Sun Web Server 7, Mid-Tier 7.1, ARS 7.1, ITSM suite 7.0.03, all running on Windows 2003 and MS SQL 2005. I also loaded the Mid-Tier on IIS 6 this morning, then again on the Sun Web Server where it now resides. The problem is, I cannot log in, either with IE 6 as Administrator using the default password (arsystem in the docs) or as a user using the username and password in the system. I can get into the web server with the username and password I added on installation, but I can't login to the Mid-Tier from IE 6 or the WUT. I am trying to set up a demo laptop to show SRM and I really do need the web services up and running. What am I doing wrong? Thanks in advance. -- Bob Rowe, Remedy Action Request System Development and Administration [EMAIL PROTECTED] The golden rule is to test everything in the light of reason and experience, no matter from where it comes. Mohandas K. Gandhi __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
UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
*** UPDATE *** Well, it appears I don't have to toilet paper my own house after all. As I reported below, I attempted to fix my problem with spotty, intermittent performance by increasing my fast and list threads from 5 to 30. That did nothing. I still have the same problem. The issue is most definitely related to diary searches, but I would *expect* that a diary search would not so drastically impact ALL users as it does. I can understand the person who invoked the diary search having a problem, but considering there are so many other threads available and CPU utilization remains under 10%, I would think other users would not be impacted so dramatically. But it never fails...I can reproduce the problem 100% of the time. I kick off a diary search, and everyone's client stops responding. It's almost like (I know this is dreaded and sometimes over-reported), but it's almost like a memory leak in the server app. Restarting the service, naturally, rectifies the situation and Remedy just hums along until someone else does a diary search. Now, I understand I can block diary searches. But my issue is wondering why diary searches impact EVERYONE. Ideas? Norm -Original Message- From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 5:39 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, a little bird (ahem...cough...Doug...cough) suggested I double up my list and fast threads, which I've done, and that seems -- at least on the surface -- to have corrected the problem. I did have multiple threads, but I guess just not enough. If that was the problem, I'm going to toilet paper my own house. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 5:02 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Never mind.. I guess I should read the entire thread before responding. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 4:17 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) We had a similar problem recently. We found that an Active Link was causing our problem. It was a newly created Active Link that was somehow corrupted and caused the server to hang. It might be worth a look. Check to see if any objects have been created or modified recently. Good Luck. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Tuesday, November 25, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to investigate whether you can use BMC or SQL Full Text search options to improve the performance. Alternatively, I've found it helps to interview the culprits to understand how they are utilizing the system to do their job. Often you can add an indexed field that allows them to categorize/track what they are looking for on a repeat basis. Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 8:25 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Good suggestion...I'm pretty familiar with the new worklog model in version 7 and its advantages and disadvantages. Unfortunately, that entails a very large coding effort, which I'm not able to do on this system. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Benedetto Cantatore Sent: Tuesday, November 25, 2008 8:12 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) ** Norm, Perhaps you need to steal an idea from version 7 and make the worklogs a parent-child relationship with the main form. This would accomodate the individuals that need to get to specific information in the worklog and ease up the burden on your database. If you can install version 7 on a server, you'll see how it works and adopt it. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 11/25/08 8:56 AM Yeah, I suspected the same thing going in, but free disk space is abundant. Only about 20
Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Yes, it does look like the table gets locked during the query...but the question is, how do you prevent that? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading Sent: Wednesday, December 03, 2008 2:30 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Is there something going on with that table that locks it when someone searches? Maybe it is as simple as changing the lockmode from table to row? Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 14:18 To: arslist@ARSLIST.ORG Subject: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) *** UPDATE *** Well, it appears I don't have to toilet paper my own house after all. As I reported below, I attempted to fix my problem with spotty, intermittent performance by increasing my fast and list threads from 5 to 30. That did nothing. I still have the same problem. The issue is most definitely related to diary searches, but I would *expect* that a diary search would not so drastically impact ALL users as it does. I can understand the person who invoked the diary search having a problem, but considering there are so many other threads available and CPU utilization remains under 10%, I would think other users would not be impacted so dramatically. But it never fails...I can reproduce the problem 100% of the time. I kick off a diary search, and everyone's client stops responding. It's almost like (I know this is dreaded and sometimes over-reported), but it's almost like a memory leak in the server app. Restarting the service, naturally, rectifies the situation and Remedy just hums along until someone else does a diary search. Now, I understand I can block diary searches. But my issue is wondering why diary searches impact EVERYONE. Ideas? Norm -Original Message- From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 5:39 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, a little bird (ahem...cough...Doug...cough) suggested I double up my list and fast threads, which I've done, and that seems -- at least on the surface -- to have corrected the problem. I did have multiple threads, but I guess just not enough. If that was the problem, I'm going to toilet paper my own house. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 5:02 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Never mind.. I guess I should read the entire thread before responding. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 4:17 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) We had a similar problem recently. We found that an Active Link was causing our problem. It was a newly created Active Link that was somehow corrupted and caused the server to hang. It might be worth a look. Check to see if any objects have been created or modified recently. Good Luck. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Tuesday, November 25, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to investigate whether you can use BMC or SQL Full Text search options to improve the performance. Alternatively, I've found it helps to interview the culprits to understand how they are utilizing the system to do their job. Often you can add an indexed field that allows them to categorize/track what they are looking for on a repeat basis. Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 8:25 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Good suggestion...I'm pretty familiar with the new worklog model in version 7
Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Well, it looks like I found it. Microsoft SQL handles lock escalation dynamically. The escalation can, well, escalate to a table lock. Here's Microsoft article on the issue: http://support.microsoft.com/kb/323630 I ran the Profiler, and sure enough, that's exactly what's happening! The fix? Write better, smaller queries. Damn. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading Sent: Wednesday, December 03, 2008 2:30 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Is there something going on with that table that locks it when someone searches? Maybe it is as simple as changing the lockmode from table to row? Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 14:18 To: arslist@ARSLIST.ORG Subject: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) *** UPDATE *** Well, it appears I don't have to toilet paper my own house after all. As I reported below, I attempted to fix my problem with spotty, intermittent performance by increasing my fast and list threads from 5 to 30. That did nothing. I still have the same problem. The issue is most definitely related to diary searches, but I would *expect* that a diary search would not so drastically impact ALL users as it does. I can understand the person who invoked the diary search having a problem, but considering there are so many other threads available and CPU utilization remains under 10%, I would think other users would not be impacted so dramatically. But it never fails...I can reproduce the problem 100% of the time. I kick off a diary search, and everyone's client stops responding. It's almost like (I know this is dreaded and sometimes over-reported), but it's almost like a memory leak in the server app. Restarting the service, naturally, rectifies the situation and Remedy just hums along until someone else does a diary search. Now, I understand I can block diary searches. But my issue is wondering why diary searches impact EVERYONE. Ideas? Norm -Original Message- From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 5:39 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, a little bird (ahem...cough...Doug...cough) suggested I double up my list and fast threads, which I've done, and that seems -- at least on the surface -- to have corrected the problem. I did have multiple threads, but I guess just not enough. If that was the problem, I'm going to toilet paper my own house. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 5:02 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Never mind.. I guess I should read the entire thread before responding. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 4:17 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) We had a similar problem recently. We found that an Active Link was causing our problem. It was a newly created Active Link that was somehow corrupted and caused the server to hang. It might be worth a look. Check to see if any objects have been created or modified recently. Good Luck. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Tuesday, November 25, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to investigate whether you can use BMC or SQL Full Text search options to improve the performance. Alternatively, I've found it helps to interview the culprits to understand how they are utilizing the system to do their job. Often you can add an indexed field that allows them to categorize/track what they are looking for on a repeat basis. Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF
Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Well, Microsoft SQL is known as very robust DB. The issue is the query being passed to it. Unfortunately, because of the WUT's open querying system, the end user can define very poor queries and pass it to the underlying DB. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading Sent: Wednesday, December 03, 2008 4:10 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) I noticed that you can turn off the escalation and set the tables to lock row. The problem appears that it might be an overall performance hit, according to Microsoft. You could run your ARServer on a Windows server with the DB on an alternative OS with a more robust DB Just a thought. BTW, I have little to no experience with Microsoft's SQL server, so I will have to defer to someone with more experience in that realm... At least you know what is going on. Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 15:14 To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, it looks like I found it. Microsoft SQL handles lock escalation dynamically. The escalation can, well, escalate to a table lock. Here's Microsoft article on the issue: http://support.microsoft.com/kb/323630 I ran the Profiler, and sure enough, that's exactly what's happening! The fix? Write better, smaller queries. Damn. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading Sent: Wednesday, December 03, 2008 2:30 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Is there something going on with that table that locks it when someone searches? Maybe it is as simple as changing the lockmode from table to row? Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 14:18 To: arslist@ARSLIST.ORG Subject: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) *** UPDATE *** Well, it appears I don't have to toilet paper my own house after all. As I reported below, I attempted to fix my problem with spotty, intermittent performance by increasing my fast and list threads from 5 to 30. That did nothing. I still have the same problem. The issue is most definitely related to diary searches, but I would *expect* that a diary search would not so drastically impact ALL users as it does. I can understand the person who invoked the diary search having a problem, but considering there are so many other threads available and CPU utilization remains under 10%, I would think other users would not be impacted so dramatically. But it never fails...I can reproduce the problem 100% of the time. I kick off a diary search, and everyone's client stops responding. It's almost like (I know this is dreaded and sometimes over-reported), but it's almost like a memory leak in the server app. Restarting the service, naturally, rectifies the situation and Remedy just hums along until someone else does a diary search. Now, I understand I can block diary searches. But my issue is wondering why diary searches impact EVERYONE. Ideas? Norm -Original Message- From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 5:39 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, a little bird (ahem...cough...Doug...cough) suggested I double up my list and fast threads, which I've done, and that seems -- at least on the surface -- to have corrected the problem. I did have multiple threads, but I guess just not enough. If that was the problem, I'm going to toilet paper my own house. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 5:02 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Never mind.. I guess I should read the entire thread before responding. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield
Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Well, that's called SQL injection, but that doesn't apply here, as Remedy guards against it through parameterized statements. In this case, the dirty query isn't really dirty, it's just inefficient. That is, searching a massive diary field against a half million records, which Remedy allows you to do out-of-the-box. I hope Doug is monitoring this thread, as I think what I'm describing could happen on ANY database. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of LJ Longwing Sent: Wednesday, December 03, 2008 4:43 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) I'm told by my DBA that it's possible to write 'dirty' queries that won't lock the DB, but I haven't been able to figure out how to make Remedy run them...it's basically an appendage to the end of the sql statement. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 2:14 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, it looks like I found it. Microsoft SQL handles lock escalation dynamically. The escalation can, well, escalate to a table lock. Here's Microsoft article on the issue: http://support.microsoft.com/kb/323630 I ran the Profiler, and sure enough, that's exactly what's happening! The fix? Write better, smaller queries. Damn. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Darrell Reading Sent: Wednesday, December 03, 2008 2:30 PM To: arslist@ARSLIST.ORG Subject: Re: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Is there something going on with that table that locks it when someone searches? Maybe it is as simple as changing the lockmode from table to row? Darrell Reading Systems Engineer Phone 479.204.5739 [EMAIL PROTECTED] Wal-Mart Stores, Inc. 805 Moberly Lane, MS-0560-68 Bentonville, AR 72716 Save Money. Live Better -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Wednesday, December 03, 2008 14:18 To: arslist@ARSLIST.ORG Subject: UPDATE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) *** UPDATE *** Well, it appears I don't have to toilet paper my own house after all. As I reported below, I attempted to fix my problem with spotty, intermittent performance by increasing my fast and list threads from 5 to 30. That did nothing. I still have the same problem. The issue is most definitely related to diary searches, but I would *expect* that a diary search would not so drastically impact ALL users as it does. I can understand the person who invoked the diary search having a problem, but considering there are so many other threads available and CPU utilization remains under 10%, I would think other users would not be impacted so dramatically. But it never fails...I can reproduce the problem 100% of the time. I kick off a diary search, and everyone's client stops responding. It's almost like (I know this is dreaded and sometimes over-reported), but it's almost like a memory leak in the server app. Restarting the service, naturally, rectifies the situation and Remedy just hums along until someone else does a diary search. Now, I understand I can block diary searches. But my issue is wondering why diary searches impact EVERYONE. Ideas? Norm -Original Message- From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 5:39 PM To: 'arslist@ARSLIST.ORG' Subject: RE: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Well, a little bird (ahem...cough...Doug...cough) suggested I double up my list and fast threads, which I've done, and that seems -- at least on the surface -- to have corrected the problem. I did have multiple threads, but I guess just not enough. If that was the problem, I'm going to toilet paper my own house. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 5:02 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Never mind.. I guess I should read the entire thread before responding. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 4:17 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) We had a similar problem recently. We found that an Active Link was causing our problem
Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Yeah, I suspected the same thing going in, but free disk space is abundant. Only about 20% of the disk is used. I have concluded that the issue is the diary searches. I suspected that this was a problem about a month ago, so I created a form and a filter that would capture a record every time a user did a diary search. Sure enough, I discovered users were doing diary searches dozens of times per day. There are now over 500,000 tickets in this system, and each ticket contains diary entries of up to 30 pages (or more) in length. Users were repeatedly searching for things like, The ticket was placed on hold because the customer is unavailable. To prove the theory, I had the administrator at the site repeatedly log on to her User client. That is, TOOL...LOGIN...TOOLS...LOGIN...TOOLS...LOGIN...etc. The User client would faithfully log her on to Remedy in under a second. I told her, Keep doing it! while I went to my client and issued a diary search. Bam! She could no longer log in. She got the dreaded, Setting server port... message that never went away. So I have locked down the diary field to prevent these searches, but I'm already hearing all sorts of dissent: That puts us out of business! We HAVE to be able to search the worklog! So now I'm considering other options. I suppose the only thing I can do is set up some type of archival system, but that comes with two problems: 1) Users will hate it and 2) It doesn't really solve the problem. Putting a voluminous amount of free text on another form and telling users, Go search there, still puts a huge burden on the database to sift through all that garbage. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, November 24, 2008 8:09 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) ** Another thing could be your disk space getting full on the Remedy server. We had that issue recently when one of the operation some user would do would eventually timeout and would create a temp file on the servers Windows Temp directory that would grow and keep growing even if the user quit the user tool from the client. The disk would eventually be full and the AR Server would get extremely slow and eventually impossible to login. Bouoncing the Remedy Service would kill that temp file and release all the used space.. Joe From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 12:58:53 PM Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Yes, that's my suspicion. I have a big suspicion that people are searching the worklog diary field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTRUSA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where
Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Good suggestion...I'm pretty familiar with the new worklog model in version 7 and its advantages and disadvantages. Unfortunately, that entails a very large coding effort, which I'm not able to do on this system. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Benedetto Cantatore Sent: Tuesday, November 25, 2008 8:12 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) ** Norm, Perhaps you need to steal an idea from version 7 and make the worklogs a parent-child relationship with the main form. This would accomodate the individuals that need to get to specific information in the worklog and ease up the burden on your database. If you can install version 7 on a server, you'll see how it works and adopt it. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 11/25/08 8:56 AM Yeah, I suspected the same thing going in, but free disk space is abundant. Only about 20% of the disk is used. I have concluded that the issue is the diary searches. I suspected that this was a problem about a month ago, so I created a form and a filter that would capture a record every time a user did a diary search. Sure enough, I discovered users were doing diary searches dozens of times per day. There are now over 500,000 tickets in this system, and each ticket contains diary entries of up to 30 pages (or more) in length. Users were repeatedly searching for things like, The ticket was placed on hold because the customer is unavailable. To prove the theory, I had the administrator at the site repeatedly log on to her User client. That is, TOOL...LOGIN...TOOLS...LOGIN...TOOLS...LOGIN...etc. The User client would faithfully log her on to Remedy in under a second. I told her, Keep doing it! while I went to my client and issued a diary search. Bam! She could no longer log in. She got the dreaded, Setting server port... message that never went away. So I have locked down the diary field to prevent these searches, but I'm already hearing all sorts of dissent: That puts us out of business! We HAVE to be able to search the worklog! So now I'm considering other options. I suppose the only thing I can do is set up some type of archival system, but that comes with two problems: 1) Users will hate it and 2) It doesn't really solve the problem. Putting a voluminous amount of free text on another form and telling users, Go search there, still puts a huge burden on the database to sift through all that garbage. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, November 24, 2008 8:09 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) ** Another thing could be your disk space getting full on the Remedy server. We had that issue recently when one of the operation some user would do would eventually timeout and would create a temp file on the servers Windows Temp directory that would grow and keep growing even if the user quit the user tool from the client. The disk would eventually be full and the AR Server would get extremely slow and eventually impossible to login. Bouoncing the Remedy Service would kill that temp file and release all the used space.. Joe From: Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Monday, November 24, 2008 12:58:53 PM Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Yes, that's my suspicion. I have a big suspicion that people are searching the worklog diary field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTRUSA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get
Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Yeah, I've already considered that. I've already interviewed the people who are the culprits and gotten their story. They tell me they look for specific solutions that they typed in long ago because they can't remember how they fixed it. They just remember a few keywords. So they search against the keywords they remember to pull up the solution. The system in question has a separate Solution field where they are supposed to document the solution so they can avoid this problem, but they don't use it. So it's a case of the, You guys really should use the Solution field, and they're like, OK, we'll do that, and they never do. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Tuesday, November 25, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to investigate whether you can use BMC or SQL Full Text search options to improve the performance. Alternatively, I've found it helps to interview the culprits to understand how they are utilizing the system to do their job. Often you can add an indexed field that allows them to categorize/track what they are looking for on a repeat basis. Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 8:25 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Good suggestion...I'm pretty familiar with the new worklog model in version 7 and its advantages and disadvantages. Unfortunately, that entails a very large coding effort, which I'm not able to do on this system. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Benedetto Cantatore Sent: Tuesday, November 25, 2008 8:12 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) ** Norm, Perhaps you need to steal an idea from version 7 and make the worklogs a parent-child relationship with the main form. This would accomodate the individuals that need to get to specific information in the worklog and ease up the burden on your database. If you can install version 7 on a server, you'll see how it works and adopt it. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 11/25/08 8:56 AM Yeah, I suspected the same thing going in, but free disk space is abundant. Only about 20% of the disk is used. I have concluded that the issue is the diary searches. I suspected that this was a problem about a month ago, so I created a form and a filter that would capture a record every time a user did a diary search. Sure enough, I discovered users were doing diary searches dozens of times per day. There are now over 500,000 tickets in this system, and each ticket contains diary entries of up to 30 pages (or more) in length. Users were repeatedly searching for things like, The ticket was placed on hold because the customer is unavailable. To prove the theory, I had the administrator at the site repeatedly log on to her User client. That is, TOOL...LOGIN...TOOLS...LOGIN...TOOLS...LOGIN...etc. The User client would faithfully log her on to Remedy in under a second. I told her, Keep doing it! while I went to my client and issued a diary search. Bam! She could no longer log in. She got the dreaded, Setting server port... message that never went away. So I have locked down the diary field to prevent these searches, but I'm already hearing all sorts of dissent: That puts us out of business! We HAVE to be able to search the worklog! So now I'm considering other options. I suppose the only thing I can do is set up some type of archival system, but that comes with two problems: 1) Users will hate it and 2) It doesn't really solve the problem. Putting a voluminous amount of free text on another form and telling users, Go search there, still puts a huge burden on the database to sift through all that garbage. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Monday, November 24, 2008 8:09 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) ** Another thing could be your disk space getting full on the Remedy server. We had that issue recently when one of the operation some user would do would eventually timeout and would create a temp file on the servers Windows Temp directory that would grow and keep growing even if the user quit the user tool from the client. The disk would eventually be full and the AR Server would get extremely slow and eventually impossible to login
Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) (U)
Because the final work log entry is rarely the solution. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hennigan, Sandra H CTR OSD-CIO Sent: Tuesday, November 25, 2008 10:39 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) (U) UNCLASSIFIED What about creating workflow to copy the final Work Log entry to the Solution Description field? Sandra Hennigan OSD Enterprise Remedy Administrator Office # 703-601-0789 Apparently, there is nothing that cannot happen today. Mark Twain -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 11:32 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Yeah, I've already considered that. I've already interviewed the people who are the culprits and gotten their story. They tell me they look for specific solutions that they typed in long ago because they can't remember how they fixed it. They just remember a few keywords. So they search against the keywords they remember to pull up the solution. The system in question has a separate Solution field where they are supposed to document the solution so they can avoid this problem, but they don't use it. So it's a case of the, You guys really should use the Solution field, and they're like, OK, we'll do that, and they never do. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Tuesday, November 25, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to investigate whether you can use BMC or SQL Full Text search options to improve the performance. Alternatively, I've found it helps to interview the culprits to understand how they are utilizing the system to do their job. Often you can add an indexed field that allows them to categorize/track what they are looking for on a repeat basis. Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 8:25 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Good suggestion...I'm pretty familiar with the new worklog model in version 7 and its advantages and disadvantages. Unfortunately, that entails a very large coding effort, which I'm not able to do on this system. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Benedetto Cantatore Sent: Tuesday, November 25, 2008 8:12 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) ** Norm, Perhaps you need to steal an idea from version 7 and make the worklogs a parent-child relationship with the main form. This would accomodate the individuals that need to get to specific information in the worklog and ease up the burden on your database. If you can install version 7 on a server, you'll see how it works and adopt it. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 11/25/08 8:56 AM Yeah, I suspected the same thing going in, but free disk space is abundant. Only about 20% of the disk is used. I have concluded that the issue is the diary searches. I suspected that this was a problem about a month ago, so I created a form and a filter that would capture a record every time a user did a diary search. Sure enough, I discovered users were doing diary searches dozens of times per day. There are now over 500,000 tickets in this system, and each ticket contains diary entries of up to 30 pages (or more) in length. Users were repeatedly searching for things like, The ticket was placed on hold because the customer is unavailable. To prove the theory, I had the administrator at the site repeatedly log on to her User client. That is, TOOL...LOGIN...TOOLS...LOGIN...TOOLS...LOGIN...etc. The User client would faithfully log her on to Remedy in under a second. I told her, Keep doing it! while I went to my client and issued a diary search. Bam! She could no longer log in. She got the dreaded, Setting server port... message that never went away. So I have locked down the diary field to prevent these searches, but I'm already hearing all sorts of dissent: That puts us out of business! We HAVE to be able to search the worklog! So now I'm considering other options. I suppose the only thing I can do is set up some type of archival system, but that comes with two problems: 1) Users will hate it and 2) It doesn't really solve
Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Well, a little bird (ahem...cough...Doug...cough) suggested I double up my list and fast threads, which I've done, and that seems -- at least on the surface -- to have corrected the problem. I did have multiple threads, but I guess just not enough. If that was the problem, I'm going to toilet paper my own house. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 5:02 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Never mind.. I guess I should read the entire thread before responding. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: Tuesday, November 25, 2008 4:17 PM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) We had a similar problem recently. We found that an Active Link was causing our problem. It was a newly created Active Link that was somehow corrupted and caused the server to hang. It might be worth a look. Check to see if any objects have been created or modified recently. Good Luck. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Tuesday, November 25, 2008 9:27 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to investigate whether you can use BMC or SQL Full Text search options to improve the performance. Alternatively, I've found it helps to interview the culprits to understand how they are utilizing the system to do their job. Often you can add an indexed field that allows them to categorize/track what they are looking for on a repeat basis. Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Tuesday, November 25, 2008 8:25 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Good suggestion...I'm pretty familiar with the new worklog model in version 7 and its advantages and disadvantages. Unfortunately, that entails a very large coding effort, which I'm not able to do on this system. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Benedetto Cantatore Sent: Tuesday, November 25, 2008 8:12 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) ** Norm, Perhaps you need to steal an idea from version 7 and make the worklogs a parent-child relationship with the main form. This would accomodate the individuals that need to get to specific information in the worklog and ease up the burden on your database. If you can install version 7 on a server, you'll see how it works and adopt it. Ben Cantatore Remedy Manager (914) 457-6209 Emerging Health IT 3 Odell Plaza Yonkers, New York 10701 [EMAIL PROTECTED] 11/25/08 8:56 AM Yeah, I suspected the same thing going in, but free disk space is abundant. Only about 20% of the disk is used. I have concluded that the issue is the diary searches. I suspected that this was a problem about a month ago, so I created a form and a filter that would capture a record every time a user did a diary search. Sure enough, I discovered users were doing diary searches dozens of times per day. There are now over 500,000 tickets in this system, and each ticket contains diary entries of up to 30 pages (or more) in length. Users were repeatedly searching for things like, The ticket was placed on hold because the customer is unavailable. To prove the theory, I had the administrator at the site repeatedly log on to her User client. That is, TOOL...LOGIN...TOOLS...LOGIN...TOOLS...LOGIN...etc. The User client would faithfully log her on to Remedy in under a second. I told her, Keep doing it! while I went to my client and issued a diary search. Bam! She could no longer log in. She got the dreaded, Setting server port... message that never went away. So I have locked down the diary field to prevent these searches, but I'm already hearing all sorts of dissent: That puts us out of business! We HAVE to be able to search the worklog! So now I'm considering other options. I suppose the only thing I can do is set up some type of archival system, but that comes with two problems: 1) Users will hate it and 2) It doesn't really solve the problem. Putting
Intermittent, Spotty ARS Performance
Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Intermittent, Spotty ARS Performance
1.4.2_14 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Meyer, Jennifer L Sent: Monday, November 24, 2008 11:07 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance ** What java version are you running? Jennifer Meyer From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:03 PM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __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
Re: Intermittent, Spotty ARS Performance
Haven't tried logging on; however, when this happened last I coincidentally had the Admin tool already opened, so I poked around and was able to open objects (ALs, forms, etc.) without a problem. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Martin, Conny Sent: Monday, November 24, 2008 11:19 AM To: arslist@ARSLIST.ORG Subject: AW: Intermittent, Spotty ARS Performance ** Hi Norm, Can you log on with Remedy Administrator while the server ist not responding? Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Im Auftrag von LJ Longwing Gesendet: Montag, 24. November 2008 18:15 An: arslist@ARSLIST.ORG Betreff: Re: Intermittent, Spotty ARS Performance ** I'm assuming there are no messages going into the arerror.log or anything like that? How about the armonitor.log? Try turning on Thread logging (very small output) and see if you can see anything happening with threads at the time it hangs. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 10:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __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
Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED)
Yes, that's my suspicion. I have a big suspicion that people are searching the worklog diary field. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE ___ 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
Searching Diaries WAS: Intermittent, Spotty ARS Performance
OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE ___ 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: Searching Diaries WAS: Intermittent, Spotty ARS Performance
How do you block searches done on the Advanced Query Bar? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge Sent: Monday, November 24, 2008 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance We prevent our users from searching the work log on production server via an active link firing on search. It's a given performance killer. They have to use the reporting server to search the work log. HTH, Rootuja _ Rootuja Ghatge Senior Application Developer CenterBeam, Inc. 30 Rio Robles San Jose, CA 95134 Direct (408) 750-0718 Fax (408) 750-0559 http://www.centerbeam.com This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE ___ 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 ___ 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: Searching Diaries WAS: Intermittent, Spotty ARS Performance
No...can't do that. Thanks for the suggestion, but that won't work. Users still need to construct advanced searches. I just need to block them from skirting my AL that blocks them from searching the worklog. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Monday, November 24, 2008 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance Just turn off the advanced search option from the Form - Current View - Properties - Menu Access menu. -Matt Matthew C. Gayford Application Developer Remedy Administrator University of North Carolina Wilmington (910) 962-7177 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance How do you block searches done on the Advanced Query Bar? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge Sent: Monday, November 24, 2008 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance We prevent our users from searching the work log on production server via an active link firing on search. It's a given performance killer. They have to use the reporting server to search the work log. HTH, Rootuja _ Rootuja Ghatge Senior Application Developer CenterBeam, Inc. 30 Rio Robles San Jose, CA 95134 Direct (408) 750-0718 Fax (408) 750-0559 http://www.centerbeam.com This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE
Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance
Well, thanks to Gary Opela (who contacted me privately), I figured it out. I just had to search the Form Action Field Search Bar for %Worklog%. That did the trick! -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Monday, November 24, 2008 2:47 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance Just turn off the advanced search option from the Form - Current View - Properties - Menu Access menu. -Matt Matthew C. Gayford Application Developer Remedy Administrator University of North Carolina Wilmington (910) 962-7177 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance How do you block searches done on the Advanced Query Bar? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rootuja Ghatge Sent: Monday, November 24, 2008 2:35 PM To: arslist@ARSLIST.ORG Subject: Re: Searching Diaries WAS: Intermittent, Spotty ARS Performance We prevent our users from searching the work log on production server via an active link firing on search. It's a given performance killer. They have to use the reporting server to search the work log. HTH, Rootuja _ Rootuja Ghatge Senior Application Developer CenterBeam, Inc. 30 Rio Robles San Jose, CA 95134 Direct (408) 750-0718 Fax (408) 750-0559 http://www.centerbeam.com This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 12:19 PM To: arslist@ARSLIST.ORG Subject: Searching Diaries WAS: Intermittent, Spotty ARS Performance OK, I'm pretty confident the problem was being caused by users constantly searching the worklog diary field on a form with 200,000+ tickets. I was able to reproduce the behavior multiple times by doing a diary search myself. So...that leads me to wonder, how do the rest of the ARSListers handle diary searches? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michaud, Christopher W Mr CTR USA MEDCOM USAMITC Sent: Monday, November 24, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Re: Intermittent, Spotty ARS Performance (UNCLASSIFIED) Classification: UNCLASSIFIED Caveats: NONE Norm, You may want to look closer at the SQL side. Look for locks. Perhaps someone querying a diary or un-indexed field. Also, are you using SQL replication? In particular, are snapshots turned on? Christopher Michaud -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: Monday, November 24, 2008 11:03 AM To: arslist@ARSLIST.ORG Subject: Intermittent, Spotty ARS Performance ** Hi everyone: This problem has me perplexed. At a site I support, the Remedy server inexplicably stops responding to requests. It's very intermittent. It runs fine for awhile, then seemingly without warning, it just hangs. Users attempting to log on get stuck at the Setting server port dialog, which eventually times out. Other users who are already logged who try to pull up a ticket get stuck at a blank screen that never comes back. To resolve the issue, they have to bounce the Remedy server service. The system works for awhile...until it hangs up again. Any ideas what might be causing this? - I have monitored CPU utilization when this occurs, and the CPU hums along at about 3% - 5% utilization - Network utilization is flat-lined whenever this occurs (i.e., no spike) - Memory utilization appears normal - CNET bandwidth tests resolve to better than dedicated T1 performance (for what that's worth) Any thoughts are greatly appreciated. The interesting thing is, we have the same exact Remedy apps running on the same exact type of server in the same exact environment in four other locations, and those four other locations never experience any problems. Norm Remedy ARS 6.3 Microsoft SQL 2000 SP4 Microsoft Windows 2000 SP2 100% Custom Apps - No ITSM __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Classification: UNCLASSIFIED Caveats: NONE
Re: how can I capture system ID
Gok: I assume by LAN ID you mean the user's username? If you're trying to capture this through the Midtier, you could try this: Create a little Java function in a .jsp file and put it in your shared folder on your Midtier: Name the file something like /arsys/shared/get_remote_user.jsp. get_remote_user.jsp contains: function env_ip_var() { var return_value = %=request.getRemoteUser()%; return (return_value) } In the Web Header content of the form you want to capture this on, add... SCRIPT src=/arsys/shared/get_remote_user.jsp language=JavaScript/SCRIPT To set a field with the data from the JavaScript functions do the following in an active link... Run Process Command Line: javascript:window.F().DoSet(env_hostname()); Be sure to change with the field ID of the field you want to set. I think this might work. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of gok's Sent: Thursday, November 13, 2008 8:38 AM To: arslist@ARSLIST.ORG Subject: how can I capture system ID HI, I want set to capture user id or lan ID how can I do that. I am using ARS 7.0 database sybase -- View this message in context: http://www.nabble.com/how-can-I-capture-system-ID-tp20481624p20481624.ht ml Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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: how can I capture system ID
Yes, the method below will capture the user's network (OS) username, NOT the ARS username. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of gok's Sent: Thursday, November 13, 2008 11:25 AM To: arslist@ARSLIST.ORG Subject: Re: how can I capture system ID HI, Thank you for you responce's I mean OS log in ID not ARS log in ID. If any body got ideas please post thank you. Kaiser Norm E CIV USAF 96 CS/SCCE wrote: Gok: I assume by LAN ID you mean the user's username? If you're trying to capture this through the Midtier, you could try this: Create a little Java function in a .jsp file and put it in your shared folder on your Midtier: Name the file something like /arsys/shared/get_remote_user.jsp. get_remote_user.jsp contains: function env_ip_var() { var return_value = %=request.getRemoteUser()%; return (return_value) } In the Web Header content of the form you want to capture this on, add... SCRIPT src=/arsys/shared/get_remote_user.jsp language=JavaScript/SCRIPT To set a field with the data from the JavaScript functions do the following in an active link... Run Process Command Line: javascript:window.F().DoSet(env_hostname()); Be sure to change with the field ID of the field you want to set. I think this might work. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of gok's Sent: Thursday, November 13, 2008 8:38 AM To: arslist@ARSLIST.ORG Subject: how can I capture system ID HI, I want set to capture user id or lan ID how can I do that. I am using ARS 7.0 database sybase -- View this message in context: http://www.nabble.com/how-can-I-capture-system-ID-tp20481624p20481624.ht ml Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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 -- View this message in context: http://www.nabble.com/how-can-I-capture-system-ID-tp20481624p20484321.ht ml Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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: how can I capture system ID
Let's start over, Gok...how about this: Welcome to ARSList! We're glad to have you. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of gok's Sent: Thursday, November 13, 2008 3:07 PM To: arslist@ARSLIST.ORG Subject: Re: how can I capture system ID Yes you'r exactly right but there is small change the user will have chance to select multiple records and the user's will have there own specific location (many_to_many)..so if for example if you'r end user if you want to import any document you will go to you'r sirectory on share point ..I believ you got my pointso ...I want to create a dynami URL which takes every user to their specific locations so that they can retrive the documents..this is what I want but thank's a lot lister's for helping me after very bad start for me . Thanks Theo Fondse wrote: Gok, It sounds to me like you want to integrate Microsoft SharePoint with a Remedy (ARS 7.0.0) Form. You want to create a button on the Remedy form to pop up a document stored on SharePoint. This means building a URL in a character field that contains the Windows login name of the user (LAN ID) and then passing the URL to the browser that will open up the document from SharePoint. Is this correct? Do you intend to use Mid-Tier or The Remedy User Tool as front-end? Or do you intend for the Remedy server to automatically download the document from SharePoint and attach it to an attachment field? Do you also want to submit a document to SharePoint? Best Regards, Theo J. Fondse Systems Engineer Remedy Integrated Solutions (Pty.) Ltd. South Africa -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE Sent: 13 November 2008 16:54 To: arslist@ARSLIST.ORG Subject: Re: how can I capture system ID Gok: I assume by LAN ID you mean the user's username? If you're trying to capture this through the Midtier, you could try this: Create a little Java function in a .jsp file and put it in your shared folder on your Midtier: Name the file something like /arsys/shared/get_remote_user.jsp. get_remote_user.jsp contains: function env_ip_var() { var return_value = %=request.getRemoteUser()%; return (return_value) } In the Web Header content of the form you want to capture this on, add... SCRIPT src=/arsys/shared/get_remote_user.jsp language=JavaScript/SCRIPT To set a field with the data from the JavaScript functions do the following in an active link... Run Process Command Line: javascript:window.F().DoSet(env_hostname()); Be sure to change with the field ID of the field you want to set. I think this might work. Norm -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of gok's Sent: Thursday, November 13, 2008 8:38 AM To: arslist@ARSLIST.ORG Subject: how can I capture system ID HI, I want set to capture user id or lan ID how can I do that. I am using ARS 7.0 database sybase -- View this message in context: http://www.nabble.com/how-can-I-capture-system-ID-tp20481624p20481624.ht ml Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are -- View this message in context: http://www.nabble.com/how-can-I-capture-system-ID-tp20481624p20489544.ht ml Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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
OT:smart-questions.html WAS: how can I capture LanID ?
Some of the info in that document is very good, but a lot of it is just a bunch of excuse-making and rationalization of the unnecessarily rude and condescending behavior on tech forums nowadays...behavior that FORTUNATELY does not exist much (if at all) here on ARSList. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Remedy Maniac Sent: Wednesday, November 12, 2008 2:32 AM To: arslist@ARSLIST.ORG Subject: Re: how can I capture LanID ? gok's wrote: can any one say how can i capture my lan ID please. also read again http://www.catb.org/~esr/faqs/smart-questions.html specially the notes about courtesy also about questions not to ask actually many thanks to Axton for having sent this link That was useful to me Serouche ___ 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: DSO Question
Man, that's a heck of a lot of data to be pushing down the pipe via DSO. This statement... we would like that when server A is unavailable ...begs the question, Why is server A unavailable at times? -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rudolf Schwarzkopf Sent: Tuesday, October 28, 2008 9:44 PM To: arslist@ARSLIST.ORG Subject: DSO Question ** Hi List, We have two ITSM 7 servers, each one used by different groups of users. However, we would like that when server A is unavailable, its users will be able to connect to server B. This way server B would hold server A data as well as its own data. Server A will just have server A data. In order to do that, we thought about using DSO. Has anyone configured DSO to synchronize ITSM 7.x servers? I know that a lot of mapping would need to be done in order to have the servers synched (Incident/Problem/Change/SLM/Foundation data). Is there any detailed documentation or mappings from BMC that can be used? I've found a white paper from BMC that describes how to configure ID prefixes to use DSO. However it is not detailed and a whole analysis will be required to know all the forms/fields that need to be mapped/synched. Is it feasible to synch Foundation data? (Remembering that IDs will be different in both servers, since server B is also used by another group of users). For instance, when an incident goes from server A to backup server B, if a field holds the support group ID, in server B the synched support group ID might be different. Or issued like this should not happen? Would DSO be the best approach to achieve this objective? Has anyone implemented another solution to achieve this kind of objective? Thanks, Rudolf __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: ARS - Database Change
Microsoft SQL? Easy -- detach database, copy database files, attach database on new server. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jase Brandon Sent: Thursday, October 02, 2008 11:08 AM To: arslist@ARSLIST.ORG Subject: ARS - Database Change ** Hello All, I think this is an easy question, but with the server information moved to the Client with 7.1, I am not sure how to answer this. We are going to be doing an install on our dev server for Asset and Change. A request has been made to copy our database over to a test server, and point the dev server to use the database on test. What is the correct process for doing this? Thanks, Jase __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