Re: Table for BMC.IMPORT.TOPO
Have you looked into using the BMC Drift Management Tool? Yes, I believe that is what I was thinking about. I haven't used it myself, but wanted to point out that there is comparison functionality built into the CMDB that you may want to look into if you weren't aware that it was there. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Thursday, January 14, 2010 4:36 PM To: arslist@ARSLIST.ORG Subject: Re: Table for BMC.IMPORT.TOPO ** Are you referring to running a job that does a comparison? In a message dated 1/14/2010 4:29:59 P.M. Eastern Standard Time, tayl...@ldschurch.org writes: ** There are not separate tables for each of the database - all datasets are stored in the same table in the database. The only thing that distinguishes the data in one dataset and another is a field that indicates which dataset a given record belongs to. The CMDB already contains the ability to run a comparison between datasets off the CMDB Console. Does that functionality not give you what you are looking for? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Thursday, January 14, 2010 2:25 PM To: arslist@ARSLIST.ORG Subject: Table for BMC.IMPORT.TOPO ** Hi All, I am trying to compare the data between BMC.IMPORT.TOPO and BMC.ASSET. I was going to try a comparison using Business Objects reports. How would you compare the results between these two datasets since are the same table BMC.ASSET. Does anyone know the name of the table that stores the data in the Discovery datastore? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Table for BMC.IMPORT.TOPO
No Sent from my iPhone On Jan 15, 2010, at 3:48 AM, Peter Romain p.romain.arsl...@parsolutions.co.uk wrote: Have you looked into using the BMC Drift Management Tool? Yes, I believe that is what I was thinking about. I haven't used it myself, but wanted to point out that there is comparison functionality built into the CMDB that you may want to look into if you weren't aware that it was there. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Thursday, January 14, 2010 4:36 PM To: arslist@ARSLIST.ORG Subject: Re: Table for BMC.IMPORT.TOPO ** Are you referring to running a job that does a comparison? In a message dated 1/14/2010 4:29:59 P.M. Eastern Standard Time, tayl...@ldschurch.org writes: ** There are not separate tables for each of the database - all datasets are stored in the same table in the database. The only thing that distinguishes the data in one dataset and another is a field that indicates which dataset a given record belongs to. The CMDB already contains the ability to run a comparison between datasets off the CMDB Console. Does that functionality not give you what you are looking for? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Thursday, January 14, 2010 2:25 PM To: arslist@ARSLIST.ORG Subject: Table for BMC.IMPORT.TOPO ** Hi All, I am trying to compare the data between BMC.IMPORT.TOPO and BMC.ASSET. I was going to try a comparison using Business Objects reports. How would you compare the results between these two datasets since are the same table BMC.ASSET. Does anyone know the name of the table that stores the data in the Discovery datastore? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Friday Humor: Male Philosophizing
When a man steals your wife, there is no better revenge than to let him keep her. David Bissonette After marriage, husband and wife become two sides of a coin; they just can't face each other, but still they stay together. Sacha Guitry By all means marry. If you get a good wife, you'll be happy. If you get a bad one, you'll become a philosopher. Socrates Woman inspires us to great things, and prevents us from achieving them. Anonymous The great question... which I have not been able to answer... is, What does a woman want? Dumas I had some words with my wife, and she had some paragraphs with me. Sigmund Freud 'Some people ask the secret of our long marriage. We take time to go to a restaurant two times a week. A little candlelight, dinner, soft music and dancing. She goes Tuesdays, I go Fridays.' Anonymous 'There's a way of transferring funds that is even faster than electronic banking. It's called marriage.' Sam Kinison 'I've had bad luck with both my wives. The first one left me, and the second one didn't.' James Holt McGavra Two secrets to keep your marriage brimming 1. Whenever you're wrong, admit it, 2. Whenever you're right, shut up. Patrick Murra The most effective way to remember your wife's birthday is to forget it once Nash You know what I did before I married? Anything I wanted to. Anonymous My wife and I were happy for twenty years. Then we met. Henny Youngman A good wife always forgives her husband when she's wrong. Rodney Dangerfield A man inserted an 'ad' in the classifieds: 'Wife wanted'. Next day he received a hundred letters. They all said the same thing: 'You can have mine.' Anonymous First Guy (proudly): 'My wife's an angel!' Second Guy: 'You're lucky, mine's still alive.' Anonymous SEND THIS TO ALL THE GUYS TO GIVE THEM A GOOD LAUGH..AND TO THOSE LADIES WITH A SENSE OF HUMOR WHO CAN HANDLE IT! Or your computer screen will turn pink with flowers and butterflies haha ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Performance Issue - Urgent
To add to what Hugo and others suggested, when you report performance issues. it would also be nice to add where you are really seeing drop in the performance. Is it generally doing anything that you are experiencing problems with (which in case it could be you run short of hardware resources) or is it in a specific area of the application (where you may require to tune the apps using tips that Hugo pointed out) Without that its hard to really tell - its like phoning your doctor and saying hey I have a problem and I think I'm not well and not really telling him what you are experiencing and yet expect the doctor to fix you with some magic portion.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Hyunkel v2.0 Sent: Thursday, January 14, 2010 12:21 PM To: arslist@ARSLIST.ORG Subject: Re: Performance Issue - Urgent ** The minimal requirements of RAM are 2GB+ for ARS 7.1 and ITSM 7.3. On the other hand you must check a couple of things first: * Are you using indexes on the forms other than the predefined ones? * If you monitor your DB, are you seeing locked tables or an unusual size increase on one table (specially B'X' or H'X') * Do you have escalations modifying a large ammount of data on short intervals? * Do you manage the DB in other way than the one that uses ARS? * Are you seeing API Calls fails on the API log? * Do you perform a specific task when you notice the bad performance? * Which kind of client are you using (Fat OR Web), and the clients behave the same? * What are you seeing in performance manager regarding arserverd process? Best Regards. Hugo Ruesga perotsystems® US 972.577.7000 MX +52 (33) 3332.3868 P Please consider the environment before printing this email The information contained in and transferred with this electronic message is intended only for the recipient(s) designated above, it is protected by law and it may contain information which is privileged and confidential. If you are not the intended recipient, please do not read, copy, or use it, and do not disclose it to others. Please notify the sender of the delivery error by replying to this message, and then delete it from your system. Thank you. -- Date: Thu, 14 Jan 2010 18:57:16 +0200 From: ramyay...@gmail.com Subject: Performance Issue - Urgent To: arslist@ARSLIST.ORG ** *** List , I m wondering how I can point figure why remedy application is slow , is it memory ,CPU or What which the value for CPU and Memory reasonable rather than good the question now why Remedy it goes to paging rather than using the free available memory and how could tune this. ARS Version: 7.1 ITSM: 7,3 OS : Windows 2003 (VMWARE) DATABASE: SQL 2005 Regards, Ramy ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Table for BMC.IMPORT.TOPO
All those responding are correct, use existing AR and CMDB functions when they are available and adequate. But for analytical purposes some sql is helpful. Below is an sql query that compares the 'Name' value for all records that have a reconciled record in each data set. The query can be enhanced to include a larger subset of output fields. It could also incorporate outer joins to show records that do not have a corresponding reconciled partner. select a.name, t.name from BMC_CORE_BMC_BaseElement a join BMC_CORE_BMC_BaseElement t on a.ReconciliationIdentity = t.ReconciliationIdentity and a.datasetid = 'BMC.ASSET' and t.datasetid = 'BMC.IMPORT.TOPO' Hope this helps. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pat Zandi Sent: Friday, January 15, 2010 6:52 AM To: arslist@ARSLIST.ORG Subject: Re: Table for BMC.IMPORT.TOPO No Sent from my iPhone On Jan 15, 2010, at 3:48 AM, Peter Romain p.romain.arsl...@parsolutions.co.uk wrote: Have you looked into using the BMC Drift Management Tool? Yes, I believe that is what I was thinking about. I haven't used it myself, but wanted to point out that there is comparison functionality built into the CMDB that you may want to look into if you weren't aware that it was there. Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Thursday, January 14, 2010 4:36 PM To: arslist@ARSLIST.ORG Subject: Re: Table for BMC.IMPORT.TOPO ** Are you referring to running a job that does a comparison? In a message dated 1/14/2010 4:29:59 P.M. Eastern Standard Time, tayl...@ldschurch.org writes: ** There are not separate tables for each of the database - all datasets are stored in the same table in the database. The only thing that distinguishes the data in one dataset and another is a field that indicates which dataset a given record belongs to. The CMDB already contains the ability to run a comparison between datasets off the CMDB Console. Does that functionality not give you what you are looking for? Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kathy Morris Sent: Thursday, January 14, 2010 2:25 PM To: arslist@ARSLIST.ORG Subject: Table for BMC.IMPORT.TOPO ** Hi All, I am trying to compare the data between BMC.IMPORT.TOPO and BMC.ASSET. I was going to try a comparison using Business Objects reports. How would you compare the results between these two datasets since are the same table BMC.ASSET. Does anyone know the name of the table that stores the data in the Discovery datastore? _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Conversion of Plain text to HTML without a template.
Define a header template with the html and body tags, then set that as the default in your email configuration. That will force everything to be in html. When you send the emails use all the html tags in the email except the html and body tags. Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu From: Mahendra Mahalkar [mailto:mahendra.mahal...@gmail.com] Sent: Wednesday, January 13, 2010 8:01 AM Subject: Conversion of Plain text to HTML without a template. ** Hi Listers, I am working on email notification. In the email messages the default outgoing messages are send by the plain text with the message in the tab Plain text in AR System Email Messages form. How can we make this message appear in the tab HTML forcefully in the AR System Email Messages from SYS:Notification Messages form? I don't want to ues the template method. Thanks Regards, Mahendra Mahalkar _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Changing AIE user
Good morning, I've been looking into what is required to change the user that AIE logs in as. I know the obvious one of changing it in the AIE console under the Configuration menu and selecting Integration Engine App., but that seems to prevent my Data Exchanges from firing correctly. Is there somewhere else that I should modify what user is used by AIE? Thanks, Shawn Pierson Remedy Developer | Southern Union 5444 Westheimer Rd. Houston, TX 77056 | 713.989.7226 Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Changing AIE user
Yes, you need to update your eie.cfg file too. Here are the steps I wrote for myself to do this. Replace the with the appropriate information. You need to do this if you are not going to use Demo / blank as the admin password v Backup the aie.cfg file first v On a command line go to C:\Program Files\BMC Software\BMC Atrium Integration Engine\servername-0\service\conf v Run ..\bin\eiecfedit -x servername -s servername -l username -p password v Verify it updated the file v Go to AIE Console v Configuration / Integration Engine App. v Update User Name Password to match here Note: this was written for ARS 7.1 ITSM 7.0.3 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, January 15, 2010 7:23 AM To: arslist@ARSLIST.ORG Subject: Changing AIE user ** Good morning, I've been looking into what is required to change the user that AIE logs in as. I know the obvious one of changing it in the AIE console under the Configuration menu and selecting Integration Engine App., but that seems to prevent my Data Exchanges from firing correctly. Is there somewhere else that I should modify what user is used by AIE? Thanks, Shawn Pierson Remedy Developer | Southern Union 5444 Westheimer Rd. Houston, TX 77056 | 713.989.7226 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: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Changing AIE user
Shawn, That should be the only place you need to change it. However, you need to make sure that the user account which you use has the appropriate permissions to access and write to the tables/forms involved in the exchange. For example: If the exchange is populating the CMDB, does the user have Administrator or permissions to create/update CI's? HTH Leonard Neely Column Technologies From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, January 15, 2010 7:23 AM To: arslist@ARSLIST.ORG Subject: Changing AIE user ** Good morning, I've been looking into what is required to change the user that AIE logs in as. I know the obvious one of changing it in the AIE console under the Configuration menu and selecting Integration Engine App., but that seems to prevent my Data Exchanges from firing correctly. Is there somewhere else that I should modify what user is used by AIE? Thanks, Shawn Pierson Remedy Developer | Southern Union 5444 Westheimer Rd. Houston, TX 77056 | 713.989.7226 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: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Changing AIE user
Correction - Christie's post is correct. I misread your post, and thought you are referring to the login for Connections Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Friday, January 15, 2010 8:04 AM To: arslist@ARSLIST.ORG Subject: Re: Changing AIE user ** Shawn, That should be the only place you need to change it. However, you need to make sure that the user account which you use has the appropriate permissions to access and write to the tables/forms involved in the exchange. For example: If the exchange is populating the CMDB, does the user have Administrator or permissions to create/update CI's? HTH Leonard Neely Column Technologies From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, January 15, 2010 7:23 AM To: arslist@ARSLIST.ORG Subject: Changing AIE user ** Good morning, I've been looking into what is required to change the user that AIE logs in as. I know the obvious one of changing it in the AIE console under the Configuration menu and selecting Integration Engine App., but that seems to prevent my Data Exchanges from firing correctly. Is there somewhere else that I should modify what user is used by AIE? Thanks, Shawn Pierson Remedy Developer | Southern Union 5444 Westheimer Rd. Houston, TX 77056 | 713.989.7226 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: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Pinnacle Integration
Does anyone have some documentation handy on integrating ARS 7.0 or higher with Pinnacle 6.3? Our telecom team will be upgrading in a couple months and I am trying to get the research and integration plan together before they go live with the new version. Any help would be greatly appreciated! Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Changing AIE user
I should also mention that in 7.5/7.6, the command is aiecfedit and the parameters are different e.g (aie_install_dir\service\bin\aiecfedit.exe -l login_name-p password -y complete path of install directory (pg 218 AIE 7.5 User Guide). Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Friday, January 15, 2010 8:20 AM To: arslist@ARSLIST.ORG Subject: Re: Changing AIE user ** Correction - Christie's post is correct. I misread your post, and thought you are referring to the login for Connections Leonard Neely From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Leonard Neely - FOJ Sent: Friday, January 15, 2010 8:04 AM To: arslist@ARSLIST.ORG Subject: Re: Changing AIE user ** Shawn, That should be the only place you need to change it. However, you need to make sure that the user account which you use has the appropriate permissions to access and write to the tables/forms involved in the exchange. For example: If the exchange is populating the CMDB, does the user have Administrator or permissions to create/update CI's? HTH Leonard Neely Column Technologies From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, January 15, 2010 7:23 AM To: arslist@ARSLIST.ORG Subject: Changing AIE user ** Good morning, I've been looking into what is required to change the user that AIE logs in as. I know the obvious one of changing it in the AIE console under the Configuration menu and selecting Integration Engine App., but that seems to prevent my Data Exchanges from firing correctly. Is there somewhere else that I should modify what user is used by AIE? Thanks, Shawn Pierson Remedy Developer | Southern Union 5444 Westheimer Rd. Houston, TX 77056 | 713.989.7226 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: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Changing AIE user
Thanks Christie. I left off my version number by accident but I am also on the versions you listed, so this works. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pargeter, Christie :CO IS Sent: Friday, January 15, 2010 9:52 AM To: arslist@ARSLIST.ORG Subject: Re: Changing AIE user ** Yes, you need to update your eie.cfg file too. Here are the steps I wrote for myself to do this. Replace the with the appropriate information. You need to do this if you are not going to use Demo / blank as the admin password * Backup the aie.cfg file first * On a command line go to C:\Program Files\BMC Software\BMC Atrium Integration Engine\servername-0\service\conf * Run ..\bin\eiecfedit -x servername -s servername -l username -p password * Verify it updated the file * Go to AIE Console * Configuration / Integration Engine App. * Update User Name Password to match here Note: this was written for ARS 7.1 ITSM 7.0.3 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Pierson, Shawn Sent: Friday, January 15, 2010 7:23 AM To: arslist@ARSLIST.ORG Subject: Changing AIE user ** Good morning, I've been looking into what is required to change the user that AIE logs in as. I know the obvious one of changing it in the AIE console under the Configuration menu and selecting Integration Engine App., but that seems to prevent my Data Exchanges from firing correctly. Is there somewhere else that I should modify what user is used by AIE? Thanks, Shawn Pierson Remedy Developer | Southern Union 5444 Westheimer Rd. Houston, TX 77056 | 713.989.7226 Private and confidential as detailed herehttp://www.sug.com/disclaimers/default.htm#Mail. If you cannot access hyperlink, please e-mail sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Friday Humor: Male Philosophizing
Joe.. I am literallyLaughing out Loud!!! Good ones and thanks for the Friday Humor.. :-) On Fri, Jan 15, 2010 at 6:58 AM, Joe D'Souza jdso...@shyle.net wrote: When a man steals your wife, there is no better revenge than to let him keep her. David Bissonette After marriage, husband and wife become two sides of a coin; they just can't face each other, but still they stay together. Sacha Guitry By all means marry. If you get a good wife, you'll be happy. If you get a bad one, you'll become a philosopher. Socrates Woman inspires us to great things, and prevents us from achieving them. Anonymous The great question... which I have not been able to answer... is, What does a woman want? Dumas I had some words with my wife, and she had some paragraphs with me. Sigmund Freud 'Some people ask the secret of our long marriage. We take time to go to a restaurant two times a week. A little candlelight, dinner, soft music and dancing. She goes Tuesdays, I go Fridays.' Anonymous 'There's a way of transferring funds that is even faster than electronic banking. It's called marriage.' Sam Kinison 'I've had bad luck with both my wives. The first one left me, and the second one didn't.' James Holt McGavra Two secrets to keep your marriage brimming 1. Whenever you're wrong, admit it, 2. Whenever you're right, shut up. Patrick Murra The most effective way to remember your wife's birthday is to forget it once Nash You know what I did before I married? Anything I wanted to. Anonymous My wife and I were happy for twenty years. Then we met. Henny Youngman A good wife always forgives her husband when she's wrong. Rodney Dangerfield A man inserted an 'ad' in the classifieds: 'Wife wanted'. Next day he received a hundred letters. They all said the same thing: 'You can have mine.' Anonymous First Guy (proudly): 'My wife's an angel!' Second Guy: 'You're lucky, mine's still alive.' Anonymous SEND THIS TO ALL THE GUYS TO GIVE THEM A GOOD LAUGH..AND TO THOSE LADIES WITH A SENSE OF HUMOR WHO CAN HANDLE IT! Or your computer screen will turn pink with flowers and butterflies haha ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
AR? ar.ini?
I've got a strange problem. I have one user on a pc that can't see all the results list fields when opening a form. Only two are there, Request ID and Short Description. Other Remedy users can see all the columns that are set up for that form. Oddly enough, it's my Remedy Admin account that can't see the columns, but only when I'm logged into Windows as a regular user. When logged in as a sysadmin, the columns are there. But that's confusion because when logged into Windows as a non-sysadmin and Remedy not as an Administrator, I can see the columns. Are those columns part of the form definition file, or are they related to the AR or ar.ini file? I deleted all the files from the HOME directory that my Remedy Admin account was using, but for some reason it won't pick up the real form definition? Pretty much all my hair is gone on this one, I've pulled it out! Drew Shuller Soto Cano ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: AR? ar.ini?
Hi Drew This sounds like a permissions issue on the columns. I have some table fields with columns that only specific groups can see. If I log in as Admin I don't see those columns, but if I log in as a member of one of those groups I do. FYI Mark -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller Sent: Friday, January 15, 2010 1:41 PM To: arslist@ARSLIST.ORG Subject: AR? ar.ini? I've got a strange problem. I have one user on a pc that can't see all the results list fields when opening a form. Only two are there, Request ID and Short Description. Other Remedy users can see all the columns that are set up for that form. Oddly enough, it's my Remedy Admin account that can't see the columns, but only when I'm logged into Windows as a regular user. When logged in as a sysadmin, the columns are there. But that's confusion because when logged into Windows as a non-sysadmin and Remedy not as an Administrator, I can see the columns. Are those columns part of the form definition file, or are they related to the AR or ar.ini file? I deleted all the files from the HOME directory that my Remedy Admin account was using, but for some reason it won't pick up the real form definition? Pretty much all my hair is gone on this one, I've pulled it out! Drew Shuller Soto Cano ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: AR? ar.ini?
Hi guys, not table field columns, the colums in the Results list when you run a query from the user tool. I forgot: Remedy 6.3, Win 2003. Christopher, I've deleted the cached files, several times. It's pretty odd. I wonder if I should recreate the Remedy user account I'm using as Admin? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: AR? ar.ini?
do you have a custom view of that form? Not sure if you deleted that from the cache also. On Fri, Jan 15, 2010 at 12:49 PM, Drew Shuller d...@io.com wrote: Hi guys, not table field columns, the colums in the Results list when you run a query from the user tool. I forgot: Remedy 6.3, Win 2003. Christopher, I've deleted the cached files, several times. It's pretty odd. I wonder if I should recreate the Remedy user account I'm using as Admin? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Poartitioning
Hi All, Is anyone in particular leveraging oracle partitioning to help with performance and scalability? I am investigating options other than archiving to a seperate form since that method breaks reports that require access across a large span of data, unless you build unions between tables in a seperate environment, that would require considerable extra work in customizing the Analytics universe within ITSM 7.5, and affect the upgrade path repeatedly. I'd also like to respect the OOB functionality of being able to link requests together. If we archive requests to a different form, we will lose the ability (without customization) to navigate to a request from the relationships tab of either the CI, other Incident, Problem record if it is archived to a seperate form. The only think I can think of is using table partitioning, but I'd like to see if others have got the expected results using this method, or if there are any other methods you may be using. Thanks Randeep _ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Pinnacle Integration
Hi Robert, Are you integrated with Pinnacle now? We have integration with Pinnacle (I forget the version) and ARS 6.3. It's done using a form interface and SQL calls (filters) that interacts bi-directionally. I have no documentation and even less time, but if you have some specific questions please don't hesitate to ask. Tom Lamy UNH IT From: herd-dispatch-boun...@mailman.stanford.edu [herd-dispatch-boun...@mailman.stanford.edu] On Behalf Of Robert Fults [rfu...@fiu.edu] Sent: Friday, January 15, 2010 11:23 AM To: herd-dispa...@lists.stanford.edu; arslist@ARSLIST.ORG Subject: [HERD] Pinnacle Integration Does anyone have some documentation handy on integrating ARS 7.0 or higher with Pinnacle 6.3? Our telecom team will be upgrading in a couple months and I am trying to get the research and integration plan together before they go live with the new version. Any help would be greatly appreciated! Sincerely, Robert Fults Remedy Dev. Florida International University Email: rfu...@fiu.edumailto:rfu...@fiu.edu http://uts.fiu.edu ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Fast/List Concurrent settings?
Here is an interesting question for you thread experts out there. How many concurrent 'creates' does your system support? Creates being a generic term for any given process that your system supports. The system that I support is a home grown quote/order management system and last year we stood up a web service interface for people to be able to generate quotes from their systems and get pricing back. The initial interface was setup to handle 3 concurrent creates...but as soon as it was a success we started getting slammed with several hundred at a time and choking our system. Through rigorous testing and tweaking over the last couple of weeks I have been able to get roughly 60 concurrent going through the system with reasonable performanceso at this point I have my Fast set to 30/100 min/maxconfirmed that I'm not maxing anything specific outbut I personally have never run above 20ish threads as a high because most transactions are short and a fast thread count of 20 will handle hundreds of users in 'normal' operation.so I was just wondering how many requests you guys have your system to handle concurrentlyand just for verification...I'm talking about 'all of them hit the button within a second of each other' type of concurrent...not 'I hove 400 people logged on concurrently' ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Fast/List Concurrent settings?
I would think that one of the larger software-related issues that would affect the number of concurrent Inserts would be the Index structure. I am sure you know this, but for the benefit of those who don't, indexes are meant to help us search on a form more easily. However, above a certain number (around 8 for a Remedy form), that cause performance degradation when creating a new record, because each of the indexes has to be updated as part of the creation process. If a system is seeing slow creates, that's the first thing I check. One other thing to think about is that since each thread can cache 5 processes (that's the last number I heard, anyway) in addition to the one currently being handled, you could, with 10 Fast (Single-API) threads, handle 60 concurrent create processes without a transaction loss. There would probably be a bit of a delay for those farther back in the queue, but if you had a reasonably robust system, most users wouldn't notice it much. I seriously doubt all but a very few systems have to handle anything resembling that kind of concurrent load, with the exception of those who have a large number of system (i.e. NMS) generated records. Also look at the Entry ID Block size when doing this test. If - AND ONLY IF - you are regularly having large numbers of concurrent inserts, you can set the Entry ID Block size to something like 10 to cut down the number of requests to the DB for Entry IDs. That is alleged to help with create times, though I have not seen that be the case in practical use. Rick On Fri, Jan 15, 2010 at 2:27 PM, LJ Longwing lj.longw...@gmail.com wrote: ** Here is an interesting question for you thread experts out there. How many concurrent 'creates' does your system support? Creates being a generic term for any given process that your system supports. The system that I support is a home grown quote/order management system and last year we stood up a web service interface for people to be able to generate quotes from their systems and get pricing back. The initial interface was setup to handle 3 concurrent creates...but as soon as it was a success we started getting slammed with several hundred at a time and choking our system. Through rigorous testing and tweaking over the last couple of weeks I have been able to get roughly 60 concurrent going through the system with reasonable performanceso at this point I have my Fast set to 30/100 min/maxconfirmed that I'm not maxing anything specific outbut I personally have never run above 20ish threads as a high because most transactions are short and a fast thread count of 20 will handle hundreds of users in 'normal' operation.so I was just wondering how many requests you guys have your system to handle concurrentlyand just for verification...I'm talking about 'all of them hit the button within a second of each other' type of concurrent...not 'I hove 400 people logged on concurrently' _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Fast/List Concurrent settings?
I completely agree with everything you saidbut as you mentioned, if you have 60 submits and have 10 threads...you are only handling 10 of those 60 concurrentlyso if each transaction takes an average of say...10 seconds...the first 10 will complete in 10, the next 10 in 20, and so on with the final set of 10 taking a full 60 seconds from time to complete to process. If your external application has a timeout of say45 seconds then you are only going to be able to handle 40 of the 60 submitted concurrently and as such would have a 1/3 failure ratein that situation would you then set your threads to say15 to make it so that you could handle 60 in 40 seconds or would you take it to 60 to be able to handle 60 in 10 seconds? _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Friday, January 15, 2010 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Fast/List Concurrent settings? ** I would think that one of the larger software-related issues that would affect the number of concurrent Inserts would be the Index structure. I am sure you know this, but for the benefit of those who don't, indexes are meant to help us search on a form more easily. However, above a certain number (around 8 for a Remedy form), that cause performance degradation when creating a new record, because each of the indexes has to be updated as part of the creation process. If a system is seeing slow creates, that's the first thing I check. One other thing to think about is that since each thread can cache 5 processes (that's the last number I heard, anyway) in addition to the one currently being handled, you could, with 10 Fast (Single-API) threads, handle 60 concurrent create processes without a transaction loss. There would probably be a bit of a delay for those farther back in the queue, but if you had a reasonably robust system, most users wouldn't notice it much. I seriously doubt all but a very few systems have to handle anything resembling that kind of concurrent load, with the exception of those who have a large number of system (i.e. NMS) generated records. Also look at the Entry ID Block size when doing this test. If - AND ONLY IF - you are regularly having large numbers of concurrent inserts, you can set the Entry ID Block size to something like 10 to cut down the number of requests to the DB for Entry IDs. That is alleged to help with create times, though I have not seen that be the case in practical use. Rick On Fri, Jan 15, 2010 at 2:27 PM, LJ Longwing lj.longw...@gmail.com wrote: ** Here is an interesting question for you thread experts out there. How many concurrent 'creates' does your system support? Creates being a generic term for any given process that your system supports. The system that I support is a home grown quote/order management system and last year we stood up a web service interface for people to be able to generate quotes from their systems and get pricing back. The initial interface was setup to handle 3 concurrent creates...but as soon as it was a success we started getting slammed with several hundred at a time and choking our system. Through rigorous testing and tweaking over the last couple of weeks I have been able to get roughly 60 concurrent going through the system with reasonable performanceso at this point I have my Fast set to 30/100 min/maxconfirmed that I'm not maxing anything specific outbut I personally have never run above 20ish threads as a high because most transactions are short and a fast thread count of 20 will handle hundreds of users in 'normal' operation.so I was just wondering how many requests you guys have your system to handle concurrentlyand just for verification...I'm talking about 'all of them hit the button within a second of each other' type of concurrent...not 'I hove 400 people logged on concurrently' _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Fast/List Concurrent settings?
If your submits are taking 10 seconds each, you have a significant problem, my friend! Rick On Fri, Jan 15, 2010 at 2:52 PM, LJ Longwing lj.longw...@gmail.com wrote: ** I completely agree with everything you saidbut as you mentioned, if you have 60 submits and have 10 threads...you are only handling 10 of those 60 concurrentlyso if each transaction takes an average of say...10 seconds...the first 10 will complete in 10, the next 10 in 20, and so on with the final set of 10 taking a full 60 seconds from time to complete to process. If your external application has a timeout of say45 seconds then you are only going to be able to handle 40 of the 60 submitted concurrently and as such would have a 1/3 failure ratein that situation would you then set your threads to say15 to make it so that you could handle 60 in 40 seconds or would you take it to 60 to be able to handle 60 in 10 seconds? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Rick Cook *Sent:* Friday, January 15, 2010 3:39 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Fast/List Concurrent settings? ** I would think that one of the larger software-related issues that would affect the number of concurrent Inserts would be the Index structure. I am sure you know this, but for the benefit of those who don't, indexes are meant to help us search on a form more easily. However, above a certain number (around 8 for a Remedy form), that cause performance degradation when creating a new record, because each of the indexes has to be updated as part of the creation process. If a system is seeing slow creates, that's the first thing I check. One other thing to think about is that since each thread can cache 5 processes (that's the last number I heard, anyway) in addition to the one currently being handled, you could, with 10 Fast (Single-API) threads, handle 60 concurrent create processes without a transaction loss. There would probably be a bit of a delay for those farther back in the queue, but if you had a reasonably robust system, most users wouldn't notice it much. I seriously doubt all but a very few systems have to handle anything resembling that kind of concurrent load, with the exception of those who have a large number of system (i.e. NMS) generated records. Also look at the Entry ID Block size when doing this test. If - AND ONLY IF - you are regularly having large numbers of concurrent inserts, you can set the Entry ID Block size to something like 10 to cut down the number of requests to the DB for Entry IDs. That is alleged to help with create times, though I have not seen that be the case in practical use. Rick On Fri, Jan 15, 2010 at 2:27 PM, LJ Longwing lj.longw...@gmail.comwrote: ** Here is an interesting question for you thread experts out there. How many concurrent 'creates' does your system support? Creates being a generic term for any given process that your system supports. The system that I support is a home grown quote/order management system and last year we stood up a web service interface for people to be able to generate quotes from their systems and get pricing back. The initial interface was setup to handle 3 concurrent creates...but as soon as it was a success we started getting slammed with several hundred at a time and choking our system. Through rigorous testing and tweaking over the last couple of weeks I have been able to get roughly 60 concurrent going through the system with reasonable performanceso at this point I have my Fast set to 30/100 min/maxconfirmed that I'm not maxing anything specific outbut I personally have never run above 20ish threads as a high because most transactions are short and a fast thread count of 20 will handle hundreds of users in 'normal' operation.so I was just wondering how many requests you guys have your system to handle concurrentlyand just for verification...I'm talking about 'all of them hit the button within a second of each other' type of concurrent...not 'I hove 400 people logged on concurrently' _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Fast/List Concurrent settings?
LOL.consider this RickConsider a 'submit' to be an interface that allows ALL attributes needed to completely configure a change with a single button press. This may be a bad example...if it is I'm sorry...I really don't do ITSMbut the submit in question on our system actually averages about 40 seconds. Makes no less than 4 calls to other external systems via web services and performs more calculations than I care to think about. That being what it iswhat would you do in that situation? _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Friday, January 15, 2010 3:55 PM To: arslist@ARSLIST.ORG Subject: Re: Fast/List Concurrent settings? ** If your submits are taking 10 seconds each, you have a significant problem, my friend! Rick On Fri, Jan 15, 2010 at 2:52 PM, LJ Longwing lj.longw...@gmail.com wrote: ** I completely agree with everything you saidbut as you mentioned, if you have 60 submits and have 10 threads...you are only handling 10 of those 60 concurrentlyso if each transaction takes an average of say...10 seconds...the first 10 will complete in 10, the next 10 in 20, and so on with the final set of 10 taking a full 60 seconds from time to complete to process. If your external application has a timeout of say45 seconds then you are only going to be able to handle 40 of the 60 submitted concurrently and as such would have a 1/3 failure ratein that situation would you then set your threads to say15 to make it so that you could handle 60 in 40 seconds or would you take it to 60 to be able to handle 60 in 10 seconds? _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Friday, January 15, 2010 3:39 PM To: arslist@ARSLIST.ORG Subject: Re: Fast/List Concurrent settings? ** I would think that one of the larger software-related issues that would affect the number of concurrent Inserts would be the Index structure. I am sure you know this, but for the benefit of those who don't, indexes are meant to help us search on a form more easily. However, above a certain number (around 8 for a Remedy form), that cause performance degradation when creating a new record, because each of the indexes has to be updated as part of the creation process. If a system is seeing slow creates, that's the first thing I check. One other thing to think about is that since each thread can cache 5 processes (that's the last number I heard, anyway) in addition to the one currently being handled, you could, with 10 Fast (Single-API) threads, handle 60 concurrent create processes without a transaction loss. There would probably be a bit of a delay for those farther back in the queue, but if you had a reasonably robust system, most users wouldn't notice it much. I seriously doubt all but a very few systems have to handle anything resembling that kind of concurrent load, with the exception of those who have a large number of system (i.e. NMS) generated records. Also look at the Entry ID Block size when doing this test. If - AND ONLY IF - you are regularly having large numbers of concurrent inserts, you can set the Entry ID Block size to something like 10 to cut down the number of requests to the DB for Entry IDs. That is alleged to help with create times, though I have not seen that be the case in practical use. Rick On Fri, Jan 15, 2010 at 2:27 PM, LJ Longwing lj.longw...@gmail.com wrote: ** Here is an interesting question for you thread experts out there. How many concurrent 'creates' does your system support? Creates being a generic term for any given process that your system supports. The system that I support is a home grown quote/order management system and last year we stood up a web service interface for people to be able to generate quotes from their systems and get pricing back. The initial interface was setup to handle 3 concurrent creates...but as soon as it was a success we started getting slammed with several hundred at a time and choking our system. Through rigorous testing and tweaking over the last couple of weeks I have been able to get roughly 60 concurrent going through the system with reasonable performanceso at this point I have my Fast set to 30/100 min/maxconfirmed that I'm not maxing anything specific outbut I personally have never run above 20ish threads as a high because most transactions are short and a fast thread count of 20 will handle hundreds of users in 'normal' operation.so I was just wondering how many requests you guys have your system to handle concurrentlyand just for verification...I'm talking about 'all of them hit the button within a second of each other' type of concurrent...not 'I hove 400 people logged on concurrently' _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers Are_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: Where the Answers
Re: Fast/List Concurrent settings?
LJ, can you simplify the submit process such that the web service call amounts to nothing more than saving a record and then do all the extra processing required to do the real submission asynchronously, so to speak. For example, the web service call simply saves a new record to a processing form and then completes. Then any extra processing required on that record happens in an escalation so that it doesn't delay the client and allows maximum throughput from the perspective of the client. Taking an approach like that could increase your submission throughput from the client's perspective, although you still have real limits on what the system can actually handle (due to CPU limits, etc.). Lyle From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of LJ Longwing Sent: Friday, January 15, 2010 4:02 PM To: arslist@ARSLIST.ORG Subject: Re: Fast/List Concurrent settings? ** LOL.consider this RickConsider a 'submit' to be an interface that allows ALL attributes needed to completely configure a change with a single button press. This may be a bad example...if it is I'm sorry...I really don't do ITSMbut the submit in question on our system actually averages about 40 seconds. Makes no less than 4 calls to other external systems via web services and performs more calculations than I care to think about. That being what it iswhat would you do in that situation? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rick Cook Sent: Friday, January 15, 2010 3:55 PM To: arslist@ARSLIST.ORG Subject: Re: Fast/List Concurrent settings? ** If your submits are taking 10 seconds each, you have a significant problem, my friend! Rick On Fri, Jan 15, 2010 at 2:52 PM, LJ Longwing lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote: ** I completely agree with everything you saidbut as you mentioned, if you have 60 submits and have 10 threads...you are only handling 10 of those 60 concurrentlyso if each transaction takes an average of say...10 seconds...the first 10 will complete in 10, the next 10 in 20, and so on with the final set of 10 taking a full 60 seconds from time to complete to process. If your external application has a timeout of say45 seconds then you are only going to be able to handle 40 of the 60 submitted concurrently and as such would have a 1/3 failure ratein that situation would you then set your threads to say15 to make it so that you could handle 60 in 40 seconds or would you take it to 60 to be able to handle 60 in 10 seconds? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Friday, January 15, 2010 3:39 PM To: arslist@ARSLIST.ORGmailto:arslist@ARSLIST.ORG Subject: Re: Fast/List Concurrent settings? ** I would think that one of the larger software-related issues that would affect the number of concurrent Inserts would be the Index structure. I am sure you know this, but for the benefit of those who don't, indexes are meant to help us search on a form more easily. However, above a certain number (around 8 for a Remedy form), that cause performance degradation when creating a new record, because each of the indexes has to be updated as part of the creation process. If a system is seeing slow creates, that's the first thing I check. One other thing to think about is that since each thread can cache 5 processes (that's the last number I heard, anyway) in addition to the one currently being handled, you could, with 10 Fast (Single-API) threads, handle 60 concurrent create processes without a transaction loss. There would probably be a bit of a delay for those farther back in the queue, but if you had a reasonably robust system, most users wouldn't notice it much. I seriously doubt all but a very few systems have to handle anything resembling that kind of concurrent load, with the exception of those who have a large number of system (i.e. NMS) generated records. Also look at the Entry ID Block size when doing this test. If - AND ONLY IF - you are regularly having large numbers of concurrent inserts, you can set the Entry ID Block size to something like 10 to cut down the number of requests to the DB for Entry IDs. That is alleged to help with create times, though I have not seen that be the case in practical use. Rick On Fri, Jan 15, 2010 at 2:27 PM, LJ Longwing lj.longw...@gmail.commailto:lj.longw...@gmail.com wrote: ** Here is an interesting question for you thread experts out there. How many concurrent 'creates' does your system support? Creates being a generic term for any given process that your system supports. The system that I support is a home grown quote/order management system and last year we stood up a web service interface for people to be able to
Re: Fast/List Concurrent settings?
Actually, that's not that far from what ITSM does on a submit, although without the WS part. As Lyle suggested, separate out the Web Service calls so that the initial submit isn't waiting on returned values to clear it from the Fast queue. Perhaps after the Submit, put it into a Pending (whatever) Status, and then send the WS after it. When they are done, change the Status to allow it to proceed to the next phase of carbon-based processing. Rick On Fri, Jan 15, 2010 at 3:02 PM, LJ Longwing lj.longw...@gmail.com wrote: ** LOL.consider this RickConsider a 'submit' to be an interface that allows ALL attributes needed to completely configure a change with a single button press. This may be a bad example...if it is I'm sorry...I really don't do ITSMbut the submit in question on our system actually averages about 40 seconds. Makes no less than 4 calls to other external systems via web services and performs more calculations than I care to think about. That being what it iswhat would you do in that situation? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Rick Cook *Sent:* Friday, January 15, 2010 3:55 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Fast/List Concurrent settings? ** If your submits are taking 10 seconds each, you have a significant problem, my friend! Rick On Fri, Jan 15, 2010 at 2:52 PM, LJ Longwing lj.longw...@gmail.comwrote: ** I completely agree with everything you saidbut as you mentioned, if you have 60 submits and have 10 threads...you are only handling 10 of those 60 concurrentlyso if each transaction takes an average of say...10 seconds...the first 10 will complete in 10, the next 10 in 20, and so on with the final set of 10 taking a full 60 seconds from time to complete to process. If your external application has a timeout of say45 seconds then you are only going to be able to handle 40 of the 60 submitted concurrently and as such would have a 1/3 failure ratein that situation would you then set your threads to say15 to make it so that you could handle 60 in 40 seconds or would you take it to 60 to be able to handle 60 in 10 seconds? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Rick Cook *Sent:* Friday, January 15, 2010 3:39 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Fast/List Concurrent settings? ** I would think that one of the larger software-related issues that would affect the number of concurrent Inserts would be the Index structure. I am sure you know this, but for the benefit of those who don't, indexes are meant to help us search on a form more easily. However, above a certain number (around 8 for a Remedy form), that cause performance degradation when creating a new record, because each of the indexes has to be updated as part of the creation process. If a system is seeing slow creates, that's the first thing I check. One other thing to think about is that since each thread can cache 5 processes (that's the last number I heard, anyway) in addition to the one currently being handled, you could, with 10 Fast (Single-API) threads, handle 60 concurrent create processes without a transaction loss. There would probably be a bit of a delay for those farther back in the queue, but if you had a reasonably robust system, most users wouldn't notice it much. I seriously doubt all but a very few systems have to handle anything resembling that kind of concurrent load, with the exception of those who have a large number of system (i.e. NMS) generated records. Also look at the Entry ID Block size when doing this test. If - AND ONLY IF - you are regularly having large numbers of concurrent inserts, you can set the Entry ID Block size to something like 10 to cut down the number of requests to the DB for Entry IDs. That is alleged to help with create times, though I have not seen that be the case in practical use. Rick On Fri, Jan 15, 2010 at 2:27 PM, LJ Longwing lj.longw...@gmail.comwrote: ** Here is an interesting question for you thread experts out there. How many concurrent 'creates' does your system support? Creates being a generic term for any given process that your system supports. The system that I support is a home grown quote/order management system and last year we stood up a web service interface for people to be able to generate quotes from their systems and get pricing back. The initial interface was setup to handle 3 concurrent creates...but as soon as it was a success we started getting slammed with several hundred at a time and choking our system. Through rigorous testing and tweaking over the last couple of weeks I have been able to get roughly 60 concurrent going through the system with reasonable performanceso at this point I have my Fast set to 30/100
Re: Fast/List Concurrent settings?
Just to make sure that I understand, the requesting system is waiting 40 seconds for the quote to be returned? Does the quote return need to done as soon as possible or can there be a minute or two before the return? Maybe have them only submit the record and not trigger the processing workflow. Then have an escalation that will process the new record(s) and then make a call to a web service on requester's end that is designed to accept the return from a previous transaction. It would take some redesigning on both sides but would alleviate the waiting and hanging on to threads/connections. The other thing might be to offload some of the Remedy processing (if there is a lot) to more efficient scripts and/or direct database actions. Web services can be a wonderful thing but not always the fastest. Jason On Fri, Jan 15, 2010 at 3:02 PM, LJ Longwing lj.longw...@gmail.com wrote: ** LOL.consider this RickConsider a 'submit' to be an interface that allows ALL attributes needed to completely configure a change with a single button press. This may be a bad example...if it is I'm sorry...I really don't do ITSMbut the submit in question on our system actually averages about 40 seconds. Makes no less than 4 calls to other external systems via web services and performs more calculations than I care to think about. That being what it iswhat would you do in that situation? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Rick Cook *Sent:* Friday, January 15, 2010 3:55 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Fast/List Concurrent settings? ** If your submits are taking 10 seconds each, you have a significant problem, my friend! Rick On Fri, Jan 15, 2010 at 2:52 PM, LJ Longwing lj.longw...@gmail.comwrote: ** I completely agree with everything you saidbut as you mentioned, if you have 60 submits and have 10 threads...you are only handling 10 of those 60 concurrentlyso if each transaction takes an average of say...10 seconds...the first 10 will complete in 10, the next 10 in 20, and so on with the final set of 10 taking a full 60 seconds from time to complete to process. If your external application has a timeout of say45 seconds then you are only going to be able to handle 40 of the 60 submitted concurrently and as such would have a 1/3 failure ratein that situation would you then set your threads to say15 to make it so that you could handle 60 in 40 seconds or would you take it to 60 to be able to handle 60 in 10 seconds? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Rick Cook *Sent:* Friday, January 15, 2010 3:39 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Fast/List Concurrent settings? ** I would think that one of the larger software-related issues that would affect the number of concurrent Inserts would be the Index structure. I am sure you know this, but for the benefit of those who don't, indexes are meant to help us search on a form more easily. However, above a certain number (around 8 for a Remedy form), that cause performance degradation when creating a new record, because each of the indexes has to be updated as part of the creation process. If a system is seeing slow creates, that's the first thing I check. One other thing to think about is that since each thread can cache 5 processes (that's the last number I heard, anyway) in addition to the one currently being handled, you could, with 10 Fast (Single-API) threads, handle 60 concurrent create processes without a transaction loss. There would probably be a bit of a delay for those farther back in the queue, but if you had a reasonably robust system, most users wouldn't notice it much. I seriously doubt all but a very few systems have to handle anything resembling that kind of concurrent load, with the exception of those who have a large number of system (i.e. NMS) generated records. Also look at the Entry ID Block size when doing this test. If - AND ONLY IF - you are regularly having large numbers of concurrent inserts, you can set the Entry ID Block size to something like 10 to cut down the number of requests to the DB for Entry IDs. That is alleged to help with create times, though I have not seen that be the case in practical use. Rick On Fri, Jan 15, 2010 at 2:27 PM, LJ Longwing lj.longw...@gmail.comwrote: ** Here is an interesting question for you thread experts out there. How many concurrent 'creates' does your system support? Creates being a generic term for any given process that your system supports. The system that I support is a home grown quote/order management system and last year we stood up a web service interface for people to be able to generate quotes from their systems and get pricing back. The initial interface was setup to handle 3
Re: Fast/List Concurrent settings?
As an aside, technically your submits are going through the Fast (single-API) threads, while your updates from Web Services would use the List (multiple-API) threads. That's if your submit is allowed to finish and then the ensuing record is updated by the WS. If the WS return values are part of the Submit process, then you have long transactions processing through and clogging up your Fast threads, which is not what they are intended to handle. That will be the case regardless of the source of the external data retrieval process or source, though the time they take may be affected by using DB vs. WS. Rick On Fri, Jan 15, 2010 at 3:35 PM, Jason Miller jason.mil...@gmail.comwrote: ** Just to make sure that I understand, the requesting system is waiting 40 seconds for the quote to be returned? Does the quote return need to done as soon as possible or can there be a minute or two before the return? Maybe have them only submit the record and not trigger the processing workflow. Then have an escalation that will process the new record(s) and then make a call to a web service on requester's end that is designed to accept the return from a previous transaction. It would take some redesigning on both sides but would alleviate the waiting and hanging on to threads/connections. The other thing might be to offload some of the Remedy processing (if there is a lot) to more efficient scripts and/or direct database actions. Web services can be a wonderful thing but not always the fastest. Jason On Fri, Jan 15, 2010 at 3:02 PM, LJ Longwing lj.longw...@gmail.comwrote: ** LOL.consider this RickConsider a 'submit' to be an interface that allows ALL attributes needed to completely configure a change with a single button press. This may be a bad example...if it is I'm sorry...I really don't do ITSMbut the submit in question on our system actually averages about 40 seconds. Makes no less than 4 calls to other external systems via web services and performs more calculations than I care to think about. That being what it iswhat would you do in that situation? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Rick Cook *Sent:* Friday, January 15, 2010 3:55 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Fast/List Concurrent settings? ** If your submits are taking 10 seconds each, you have a significant problem, my friend! Rick On Fri, Jan 15, 2010 at 2:52 PM, LJ Longwing lj.longw...@gmail.comwrote: ** I completely agree with everything you saidbut as you mentioned, if you have 60 submits and have 10 threads...you are only handling 10 of those 60 concurrentlyso if each transaction takes an average of say...10 seconds...the first 10 will complete in 10, the next 10 in 20, and so on with the final set of 10 taking a full 60 seconds from time to complete to process. If your external application has a timeout of say45 seconds then you are only going to be able to handle 40 of the 60 submitted concurrently and as such would have a 1/3 failure ratein that situation would you then set your threads to say15 to make it so that you could handle 60 in 40 seconds or would you take it to 60 to be able to handle 60 in 10 seconds? -- *From:* Action Request System discussion list(ARSList) [mailto: arsl...@arslist.org] *On Behalf Of *Rick Cook *Sent:* Friday, January 15, 2010 3:39 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Fast/List Concurrent settings? ** I would think that one of the larger software-related issues that would affect the number of concurrent Inserts would be the Index structure. I am sure you know this, but for the benefit of those who don't, indexes are meant to help us search on a form more easily. However, above a certain number (around 8 for a Remedy form), that cause performance degradation when creating a new record, because each of the indexes has to be updated as part of the creation process. If a system is seeing slow creates, that's the first thing I check. One other thing to think about is that since each thread can cache 5 processes (that's the last number I heard, anyway) in addition to the one currently being handled, you could, with 10 Fast (Single-API) threads, handle 60 concurrent create processes without a transaction loss. There would probably be a bit of a delay for those farther back in the queue, but if you had a reasonably robust system, most users wouldn't notice it much. I seriously doubt all but a very few systems have to handle anything resembling that kind of concurrent load, with the exception of those who have a large number of system (i.e. NMS) generated records. Also look at the Entry ID Block size when doing this test. If - AND ONLY IF - you are regularly having large numbers of concurrent inserts, you can set the Entry ID Block size to something like 10
ARS on Solaris with Database on MSSQL
Hello Listeners, Did anyone have experience to setup the ARS running on Solaris Sparc, with Database server using MSSQL 2008? As the selection of Microsoft SQL from Database Platform is dimmed. My expected configuration, ARS server, SUN Sparce running Solaris 10 Database server, MSSQL 2008 Thanks for help. --- MICHAEL WONG System Support Consultant ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: AR? ar.ini?
Hi, You can do one more thing delete your remedy account and recreate. I dont know why but sometimes its happen. I have faced this problem before try and let me know. Thanks Regards, Manoj Jain On Sat, Jan 16, 2010 at 12:10 AM, Drew Shuller d...@io.com wrote: I've got a strange problem. I have one user on a pc that can't see all the results list fields when opening a form. Only two are there, Request ID and Short Description. Other Remedy users can see all the columns that are set up for that form. Oddly enough, it's my Remedy Admin account that can't see the columns, but only when I'm logged into Windows as a regular user. When logged in as a sysadmin, the columns are there. But that's confusion because when logged into Windows as a non-sysadmin and Remedy not as an Administrator, I can see the columns. Are those columns part of the form definition file, or are they related to the AR or ar.ini file? I deleted all the files from the HOME directory that my Remedy Admin account was using, but for some reason it won't pick up the real form definition? Pretty much all my hair is gone on this one, I've pulled it out! Drew Shuller Soto Cano ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.netsponsor%3armisoluti...@verizon.netARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are