Re: Interview questions
yeah, thats all very well but would you want to tell a ninja that his/her code was wrong ? !!! Mark Rushton IBM Global Services Remedy Engineering Development Team Axton [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 20/02/2008 01:59 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Interview questions ** Well put. Axton On Feb 19, 2008 8:12 PM, William H. Will Du Chene [EMAIL PROTECTED] wrote: Bah! If I am interviewing someone (and there have been a few choice occurances of this in the past which were against my will and my manager had to drag me from my console sessions, kicking, screaming, and clawing cube walls the entire distance to the conference room) I am not looking for what they have done in the past, what books they read, what animals might be on the cover of books, or what degree the person has. When you think about it, these criteria are positively useless. Using the above, the interviewee might well 1.) have seen the books in passing and be able to identify them, 2.) might copy someone elses design concept (what if it is patented, or confidential?), or 3.) have a degree (or not have one at all) in one field, but have been subverted into working with the platform of choice at some point and been doing so for some time. (I once knew a talented AR System developer who was nuts about the product and was darn good with it, but had a Phd in Theoretical Mathmatics. He'd teach an occasional class at a college when time permitted as well. Go figure.) So - you see, most of the criteria that get used so often are - IMHO - bunkus. An ideal candidate is one that is a passionate person; who is not just fond of a platform or a technology, but rather is obsessed with it. A candidate must be willing to learn; to go to bed at night with the technical manual and wake up in the morning with the zipper-like seam across their forehead because they fell asleep face-first on the manual. I don't want someone that is able to recite back what they learning sitting in a classroom at some training center and thinks that it's cool because they now have a cute little cert sitting in a frame on their cube wall. If I were to pick, I'd want the person that gets a smile on their face about the technology, the one that one legs starts jumping up and down when they're talking about the platform, and the one that the heart rate starts to pick up when you show them the latest version of the software. The whole point is not what you know - it's what you can do with that which you do know. I'd hire the person that has notes scribbled all over the manuals, and keeps crib notes stashed in his/her pocket written on napkins and bubble-gum wrappers or a code book (a book where random ideas about system design are sketched out), and I would more than likely file-thirteen the resume of the canidate that has all of the certs, and a zillion years of experience with whatever it is that your working on. Why you may ask? Simple. There is no room in a small cube for an ego that has been developed to such an extent, nor is there an allowance in a budget for the salary that is demanded. Most really good developers are forged in the fires of code, learning, and tribulation - not stamped from a mold, prepackaged and shrink-wrapped for sale. C'mon, you know that this is a fact... How many of us got up one day when were kids and said, I wanna grow up to be an AR System developer? I'd wager that the answer is - ahem - none. We all got drafted. If you're hiring for a position, more than likely you want someone that is going to do the job (maybe the candidate might not be able to at first, and would require some training or getting their hands wet with the technology first), someone who will be obsessed about it, and not someone who is going to cost you a few hundred an hour with perks and travel expenses. You want someone that you can drop into the desert of a server room one day, and the next day when you check on 'em, you can see that they are dug in, got a suntan, a water reservoir, and have some sort of meat cooking over a BBQ spit, rather than finding that your million dollar candidate is parched from calling for room service and looking for the butler. Hire ninjas with very little or nothing to lose, not samurai that come from the court with vast tracts of assets. Just my thoughts... Offered humbly... Best question I ever got as a developer was a request for me to design a Car Of course the interviewer was looking to see if I'd ask questions about the type of Car, Usage, etc If I had just designed it as I wanted, I'd be back in Ohio! Warren -- - Will Du Chene - [EMAIL PROTECTED] http://www.myspace.com/wduchene - ...you're an anti-Microsoft zealot... - Norm Kaiser -
Job Openings - 3 Remedy Positions :-)
Hello Everyone: Our client has 3 Remedy openings. If one, two, or all or these match your interests and qualifications, please respond ASAP with a copy of your Word resume, rate/salary requirements, and a phone number and time to contact you. All interested should contact me by this afternoon (2/20/08), 3 PM, EST. Thanks! See the descriptions below. Job title: Remedy Administrator Term: 5 month Location: McLean, VA Level: 3+years experience Primary skills: 1+ year experience in BMC Remedy ARS server administration Must be able to display knowledge on the server admin level 3+ years of general IT experience Strong system administration skills (UNIX / Windows). Experience Required: 3+ years experience Description: Work as a Remedy tool administrator and security specialist for Incident Management, Change Management, Asset management module and ITSM CMDB in Remedy A R System 7. Specific job duties include: 1. Provisioning of users and groups in various Remedy modules such as Incident Management, Problem Management, Change Management, Asset Management and custom home grown applications within Remedy AR System. 2. Working closely with users to identify their provisioning needs and direct them on how to submit correct tickets. 3. Working with the automation team to provide requirements for the automation solution for user provisioning. 4. Producing reports using SQL/Shell Scripting and validating that no provisioning errors have been made on a monthly basis. 5. Provide support for managing CMDB Job title: Remedy Developer (Mid Level) Term: 5 month Location: McLean, VA Level: 3-7 years experience Primary skills: In depth knowledge of the Remedy tool particularly asset management. Working knowledge in the Remedy reconciliation engine. Experience in developing rules for the reconciliation engine Experience in developing load scripts and developing load scripts utilizing the various mechanisms utilized to load data into Remedy Experience Required: 3 - 7 yrs experience Description: This individual will participate in the completion of the set up and standardization of the asset management load into the Remedy tool. Specific job duties include: Individual will build asset data load mechanisms and reconciliation rules for the Remedy Reconciliation engine Deliverables will be the fixes of current data loads into Remedy, new interim loads of data into remedy, reconciliation rules, and documentation of the products Job title: Remedy Architect (Sr. Level) Term: 4 month Location: McLean, VA Level: 7 years experience Primary skills: In depth knowledge of the Remedy tool and it's various engines, workflow capabilities and deep knowledge of its data model. Working knowledge in the Remedy reconciliation engine. Experience in creating rules and optimizing the reconciliation engine. Experience building the capability to capture asset information in Remedy and the standard reports related to Asset and Configuration management. Experience in leading the implementation of Asset and Configuration management. Experience Required: 7 years experience ITIL Certification preferred Description: Project: Service Asset and Configuration management Specific job duties include: This individual will provide in depth knowledge and guidance to the completion of the set up and standardization of the asset management load into the Remedy tool. Guidance will be in the optimal data model, optimal load mechanism and utilization of the Remedy Reconciliation engine. Deliverables will be a logical and physical data model, load mechanisms and rules in the reconciliation engine. This individual will approve all designs and the overall data model for the load to the tool as it relates in adherence to the ITIL. Have a great day, Linda Linda M. Brown Technical Recruiter Cyquent, Inc. 5410 Edson Lane, Suite 320B Rockville, MD 20852 Office: 240-292-0230, Ext. 304 Direct: 240-292-0234 Fax: 866-509-0331 E-mail: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Satya sent you a friend request on Yaari...
Hi Satya . How are you ? .. Sorry but who are you Best Regards, Ramy Ayoub On 2/19/08, Satya [EMAIL PROTECTED] wrote: Satya Gandhi wants you to join Yaari! Is Satya your friend? Yes, Satya is my friend!http://www.yaari.com/y-register.php?i=8LF8GFOVH76LPGA51201838821 No, Satya isn't my friend. http://www.yaari.com/y-register.php?i=no Please respond or Satya might think you said no :( Thanks, The Yaari Team You are receiving this message because someone you know registered for Yaari and listed you as a contact. If you prefer not to receive this email tell us herehttp://yaari.com/y-email-opt-out.php?param=YXJzbGlzdEBhcnNsaXN0Lm9yZw%3D%3D. If you have any concerns regarding the content of this message, please email [EMAIL PROTECTED] Yaari LLC, 358 Angier Ave, Atlanta, GA 30312 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Forcing Proxy Server Cache to refresh whenever they hit Mid-Tier
Hi all, I just want to throw this question out to everyone. We recently reinstalled our Mid-Tier 6.3 and some people are able to access the web URL and perform tasks on the Incident form but others are getting the errors we were having prior to the re-install. For some other clients, merely flushing their browser cache solved the problem but majority of our clients appear to be proxy server caching and keeps receiving the errors. To those who were having problems, the issue was solved by them having to refresh their proxy server cache (after flushing their browser cache did not work for them.) But then we are managing about 2500+ client users and we can't keep calling everyone and telling them they need to refresh their proxy server cache if flushing browser cache doesn't work for their problem to go away. So I was wondering if there is any way from the Mid-Tier to force the proxy server cache (whatever proxy cache system they have) to refresh either every time it gets hit / one time during their first access of the day / refresh when there is change in the file's last modified date or something along those lines. Is there any provision either in the Mid-Tier config files or from the Remedy Configuration Tool or a code that you add on the Mid-Tier files that would signal the proxy server to refresh the Mid-Tier files that have been cached without having to do the refresh/clear from the client's proxy server cache? Any input would really help. TIA. Elinore ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Oracle Count of Tables
Thanks very much Axton On 19/02/2008, Axton [EMAIL PROTECTED] wrote: ** oops, remove the -1 select b.name , a.table_name , a.num_rows from user_tables a , arschema b where tablespace_name = 'ARSYSTEM' and TO_CHAR(b.schemaid) = SUBSTR(a.table_name,2,LENGTH(a.table_name)) and table_name like 'T%' Axton Grams On Feb 19, 2008 10:19 AM, Axton [EMAIL PROTECTED] wrote: select b.name , a.table_name , a.num_rows from user_tables a , arschema b where tablespace_name = 'ARSYSTEM' and TO_CHAR(b.schemaid) = SUBSTR(a.table_name,2,LENGTH(a.table_name)-1) and table_name like 'T%' Axton Grams On Feb 19, 2008 10:09 AM, Toby White [EMAIL PROTECTED] wrote: ** Thanks Jarl Would it be possilbe to extend the statements to relate the T table numbers to the arschema table. Cheers Toby On 19/02/2008, Jarl Grøneng [EMAIL PROTECTED] wrote: You can do it the hard way and loop trough and count all the tables, or you can query the user_tables table. select table_name, num_rows from user_tables where tablespace_name = 'ARSYSTEM' Regards, Jarl On Feb 19, 2008 11:29 AM, Toby White [EMAIL PROTECTED] wrote: ** Hi Does anyone know how I can count the number of records in each form on an Oracle database. I searched the list and found the way to do it using SQL Server but stuck on getting the solution for Oracle. Thanks Toby __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 __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: Release notes between versions (RESOLVED)
Found some cd's for 4.03, 4.5, 5.0, 5.1 and 5.1.1... But no 5.0.1 Did also found ARWeb 2.0 patch 39 :-) -- Jarl On Feb 19, 2008 10:30 PM, Axton [EMAIL PROTECTED] wrote: ** David, any idea where I can find the 5.0.1 api's, specifically patch 11, for aix, windows, and solaris? tia, Axton On Feb 19, 2008 3:20 PM, Easter, David [EMAIL PROTECTED] wrote: ** For those that want to know how to find them on their own, the What's New for 7.0.0 is here: http://www.bmc.com/supportu/documents/63/17/66317/66317.pdf 6.3 is here: http://www.bmc.com/supportu/documents/78/41/47841/47841.pdf These are found in the document section for AR System. The high level link is here: http://www.bmc.com/support/hou_Support_ProdAllVersions/0,3646,19097_19695_108018_0,00.html -David J. Easter Sr. Product Manager, Service Management Business Unit BMC Software, Inc. 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. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Tuesday, February 19, 2008 11:42 AM To: arslist@ARSLIST.ORG Subject: Re: Release notes between versions (RESOLVED) ** I got it from Axton Thanks a bunch Joe - Original Message From: Axton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 1:37:27 PM Subject: Re: Release notes between versions Here ya go. Axton On Feb 19, 2008 2:22 PM, Joe DeSouza [EMAIL PROTECTED] wrote: ** What I am specifically interested in is the 'Whats New' section of the Release notes for ARS version 6.0 (for whats changed from 5.x to 6.0) Also I'd like the same for whats changed between 6.0 to 6.3 And 6.3 to 7.0 I can get the 7.1 from the currently supported downloads.. Does anyone have an archive of these notes? Joe Never miss a thing. Make Yahoo your homepage. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Never miss a thing. Make Yahoo your homepage. __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: Custom ARS 6.3 apps on ARS 7.1
Hi, I have just done this for our Development Server running ARS V6.on Solaris 9 with Oracle 9.2. This has been successfully upgraded to ARS V7.1 on Solaris 10 with Oracle 10g. We have a mixture of custom apps and ITSM V5.6. So far only one 'gotcha' which was with the command line executable arimportcmd. If you use the -x option on the command line then there is a problem with importing accented characters. Removing this option and ensuring that the server is specified in the arm file. Thanks. Nyall Atul Vohra wrote: ** Hi All, Few weeks back there was a discussion of issues with migrating customized ARS 6.3 solution to ARS 7.1. At that time some one (probably Axton) suggested upgrading remedy to ARS 7.1 but not upgrade ITSM (or whatever they call it now). Question: Has anybody tried the above mentioned approach - upgrade ARS but leave all the apps as is? I was looking into this option and wanted to know if there were any gotchas. Platform: Solaris, Oracle 10g, ARS6.3 - ARS 7.1 Regards Atul __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: Interview questions
That is the engineering answer. A square cover could be turned 45 degrees and would be smaller (lengthwise) than the opening. You can't do that with a round cover. So, yes, that was acceptable. There was another, simpler answer. Manhole covers are round because manholes are round. J.T. Shyman Column Technologies -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Atherly Sent: Wednesday, February 20, 2008 8:07 AM To: arslist@ARSLIST.ORG Subject: Re: Interview questions Why are manhole covers round? If any other shape they could fall in to the hole that they cover. Do I get the job? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 ___ 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
Custom ARS 6.3 apps on ARS 7.1
Hi All, Few weeks back there was a discussion of issues with migrating customized ARS 6.3 solution to ARS 7.1. At that time some one (probably Axton) suggested upgrading remedy to ARS 7.1 but not upgrade ITSM (or whatever they call it now). Question: Has anybody tried the above mentioned approach - upgrade ARS but leave all the apps as is? I was looking into this option and wanted to know if there were any gotchas. Platform: Solaris, Oracle 10g, ARS6.3 - ARS 7.1 Regards Atul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Interview questions
Why are manhole covers round? If any other shape they could fall in to the hole that they cover. Do I get the job? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Custom ARS 6.3 apps on ARS 7.1
Hi Nyall, The setup described by you is almost identical to what we have. If you do not mind can you give me some more info on the steps performed. Did you have issues with the existing groups like APP-Support / APP-Administrator etc since the group ids now are used by SLM-Customer / SLM-Config etc. Regards Atul - Original Message - From: Nyall McCavitt [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Subject: Re: Custom ARS 6.3 apps on ARS 7.1 Date: Wed, 20 Feb 2008 14:02:27 +0100 Hi, I have just done this for our Development Server running ARS V6.on Solaris 9 with Oracle 9.2. This has been successfully upgraded to ARS V7.1 on Solaris 10 with Oracle 10g. We have a mixture of custom apps and ITSM V5.6. So far only one 'gotcha' which was with the command line executable arimportcmd. If you use the -x option on the command line then there is a problem with importing accented characters. Removing this option and ensuring that the server is specified in the arm file. Thanks. Nyall Atul Vohra wrote: ** Hi All, Few weeks back there was a discussion of issues with migrating customized ARS 6.3 solution to ARS 7.1. At that time some one (probably Axton) suggested upgrading remedy to ARS 7.1 but not upgrade ITSM (or whatever they call it now). Question: Has anybody tried the above mentioned approach - upgrade ARS but leave all the apps as is? I was looking into this option and wanted to know if there were any gotchas. Platform: Solaris, Oracle 10g, ARS6.3 - ARS 7.1 Regards Atul __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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Phone Numbers
Carey, Its perfect!!! 'Field' LIKE %[^-0-9]% worked like a charm! I feel like its my birthday already! ;) Huge thanks! Shawn Stonequist -Original Message- From: Carey Matthew Black [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 19, 2008 2:34 PM Subject: Re: Phone Numbers I think this Run if should get the job done. 'Field' LIKE %[^-0-9]% If you have to you might have to go as far as... 'Field' LIKE %[^-0123456789]% or maybe 'Field' LIKE %[^0123456789-]% ( I seem to remember the hyphen need to be first to be understood as not being a range, but I can not find that in the docs at the moment.) Read it as: When the field has a character that is not(^) a hyphen or in the range([0-9]) of 0 to 9. That just does not seem like that long of a Run If to me. :) JMHO: However I would push to not support the hyphen too. they are silly in a phone number. BTW: open and close parentheses are also silly. Phone _numbers_ are numbers... not formatting. That is for reports/display tools to do. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Feb 19, 2008 2:01 PM, Shawn Stonequist [EMAIL PROTECTED] wrote: Greetings List! This may be a bit strange. We have a form that is used populated by one of our customers. The data is sent electronically to third company. Unfortunately, strange characters are being entered into the Phone Number fields, which is causing an issue. The customer is requesting an error message (not a replacement) when anything other than a digit or a hyphen is entered. Does anyone know of a way to do this (other than an extremely long Run If qualification that lists every letter and symbol)? Huge thanks! Shawn Stonequist EMNS, Inc. Remedy 6.3 ___ 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: Interview questions
It goes all the way to the bottom. J.T. Shyman Column Technologies ROFL:ROFL:ROFL:ROFL _^ L__/[]\ LOL===_ \ L \_] II / -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Richard Copits Sent: Wednesday, February 20, 2008 8:22 AM To: arslist@ARSLIST.ORG Subject: Re: Interview questions Buthow deep is the hole? :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Wednesday, February 20, 2008 8:10 AM To: arslist@ARSLIST.ORG Subject: Re: Interview questions That is the engineering answer. A square cover could be turned 45 degrees and would be smaller (lengthwise) than the opening. You can't do that with a round cover. So, yes, that was acceptable. There was another, simpler answer. Manhole covers are round because manholes are round. J.T. Shyman Column Technologies -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Atherly Sent: Wednesday, February 20, 2008 8:07 AM To: arslist@ARSLIST.ORG Subject: Re: Interview questions Why are manhole covers round? If any other shape they could fall in to the hole that they cover. Do I get the job? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 ___ 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 Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ 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: Interview questions
Buthow deep is the hole? :) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Wednesday, February 20, 2008 8:10 AM To: arslist@ARSLIST.ORG Subject: Re: Interview questions That is the engineering answer. A square cover could be turned 45 degrees and would be smaller (lengthwise) than the opening. You can't do that with a round cover. So, yes, that was acceptable. There was another, simpler answer. Manhole covers are round because manholes are round. J.T. Shyman Column Technologies -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Atherly Sent: Wednesday, February 20, 2008 8:07 AM To: arslist@ARSLIST.ORG Subject: Re: Interview questions Why are manhole covers round? If any other shape they could fall in to the hole that they cover. Do I get the job? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 ___ 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 Portions of this message may be confidential under an exemption to Ohio's public records law or under a legal privilege. If you have received this message in error or due to an unauthorized transmission or interception, please delete all copies from your system without disclosing, copying, or transmitting this message. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Custom ARS 6.3 apps on ARS 7.1
Hi, The group IDs is not an issue yet as we have not yet migrated to ITSM V7 and so we don't have the SLM module. We are still running SLA. I installed ARS V7.1 on a new server, pointing at the existing Oracle 9i database. The installation program did the database upgrade. I then obtained a new ARS V7.1 server licence and applied it. Our DBA then exported the Oracle 9i database and imported it into an Oracle 10g database. I then pointed the ARS config to the Oracle 10g database. So far no issues have shown up apart from arimportcmd but the process was only completed this morning. Thanks. Nyall Atul Vohra wrote: Hi Nyall, The setup described by you is almost identical to what we have. If you do not mind can you give me some more info on the steps performed. Did you have issues with the existing groups like APP-Support / APP-Administrator etc since the group ids now are used by SLM-Customer / SLM-Config etc. Regards Atul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Interview questions
Sean, I have not only crashed the ar system server, I've taken down several other systems at the same time. But I was nice enough not to charge the customer for finding those vulnerabilities in their infrastructure!!! :) Marc Simmons On 2/20/08, Garrison, Sean (Norcross) [EMAIL PROTECTED] wrote: ** I always ask a simple one … what are actions that you have taken inside the ar system that have caused the server to crash or caused a major outage and what did you do to resolve them? If they said they never crashed the server … do not hire them! They have very little experience w/ developing in Remedy. I am usually able to assess their problem solving skills are, their experience w/ maintaining the arsystem, and their development skills all w/ this one question. Of course … you have had to crash Remedy several times yourself in a production environment to know the answers :-) Sean *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa *Sent:* Tuesday, February 19, 2008 1:13 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Interview questions ** whew! I thought I was the only one! Lisa -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Mark Rushton *Sent:* Tuesday, February 19, 2008 10:11 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Interview questions ** Dang - 10 years on and still cant answer some of these...!!! Mark Rushton IBM Global Services Remedy Engineering Development Team *Marc Simmons [EMAIL PROTECTED]* Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 19/02/2008 13:55 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Interview questions ** 1. What is the primary table in the AR System data dictionary? 2. How does the AR System manage the data you see in Remedy Forms? 3. Without using DSO or EIE, what are your thoughts for providing a 'STANDARDIZED' methodology for interfacing/integrating with Remedy applications. This customer was actually looking to use C.I.M. or some other open standard solution to interface with Remedy maybe a good discussion for the list!!! 4. How do you trouble shoot AR System server outages to restore access to the system? 5. How does mid-tier work and where does it fit in the client server architecture? 6. Describe how filters work? They were actually looking how filters work in different phases... which led to the next question. 7. Can you force a filter to fire all actions in the first phase? 8. List all of the possible uses for guides. They were looking for walking tables. These are all pretty simple questions. I also get some questions about turning on/off server features using the configuration files (ar.conf/ar.cfg). Hope this helps some, Marc On 2/19/08, *Remedy Service Desk* [EMAIL PROTECTED] wrote: ** Hi All, Hope you are doing well, can I request for Remedy Interview questions? Thanks Service Desk __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- Marc Simmons Remedy Administrator Everyday above ground is a good day... the rest is a choice! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ -- *Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU * __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___ -- Marc Simmons Remedy Administrator Everyday above ground is a good day... the rest is a choice! ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Interview questions
Of course I just check the little box Table Loop Selected Rows Only in the Active Link that calls the guide. The `$ is a hold over from when Guides were first introduced and the Admin tool did not have that option. It is still allowed for backward compatability with old code. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Tuesday, February 19, 2008 4:58 PM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** Hello Christie Limit the active links in the table loop to run only against rows that are selected. To do so, append `$ (backquote character followed by a dollar sign) to the end of the names of the active links contained within the table loop guide. (You do not need to change the name of the active link that calls the guide, the names of the table loop actions, or the name of the active link guide referenced by the call guide.) from the Manual Workflow Objects page 117 kind regards Shafqat Ayaz Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh Uncontrollably, And Never Regret anything that made you Smile.. - Original Message From: Pargeter, Christie [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, February 19, 2008 12:06:23 PM Subject: Re: Interview questions ** What does `$ do? I didn't know about this one...use `! quite a bit. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of john rosquist Sent: Tuesday, February 19, 2008 12:02 PM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** `! has become well used in interviews. So, what is the difference between `! and `$? When would you use one versus the other? John Rosquist Windward - Original Message From: John Atherly [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, February 19, 2008 2:54:21 PM Subject: Re: Interview questions ** Is number 7 answer `! at the end of the filter name? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 Remedy Service Desk [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/19/2008 02:43 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Interview questions ** Hi Marc, These are really helpful to give direction for fresher or new person joining team like me, correct me if I am wrong. 1) ARSchema 2) With transaction(t) table and table schema id in associated in arschema table 3) Web Services , Remedy API, Email templates, Direct SQL, creating view and database trigger and database programming. depending on what suites to client and third party application 4) Creating failure over environments, database back - replication on vmware etc, 5) Big to answer I will update you on this next time, - user interface ,end user component - directly reachable to customers 6) Filter is server side component , depending on fire condition and qualification action will be perform on server. Actions are listed in if actions tab, submit, modify any valid ar server operation. Permission is not issue on filter etc. 7) I don't things so, not possible. 8) Not understanding question - reason I not aware of walking tables I will look in to AR Server advance guide for ar.conf related question, Please provide more question if you have? Thank you for your help. Regards Sunil On Feb 19, 2008 7:25 PM, Marc Simmons [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: ** 1. What is the primary table in the AR System data dictionary? 2. How does the AR System manage the data you see in Remedy Forms? 3. Without using DSO or EIE, what are your thoughts for providing a 'STANDARDIZED' methodology for interfacing/integrating with Remedy applications. This customer was actually looking to use C.I.M. or some other open standard solution to interface with Remedy maybe a good discussion for the list!!! 4. How do you trouble shoot AR System server outages to restore access to the system? 5. How does mid-tier work and where does it fit in the client server architecture? 6. Describe how filters work? They were actually looking how filters work in different phases... which led to the next question. 7. Can you force a filter to fire all actions in the first phase? 8. List all of the possible uses for guides. They were looking for walking tables. These are all pretty simple questions. I also get some questions about turning on/off server features using the configuration files (ar.conf/ar.cfg). Hope this helps some, Marc On 2/19/08, Remedy Service Desk [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: ** Hi All, Hope you are doing well, can I request for Remedy Interview questions? Thanks Service Desk
Re: Interview questions
I always ask a simple one ... what are actions that you have taken inside the ar system that have caused the server to crash or caused a major outage and what did you do to resolve them? If they said they never crashed the server ... do not hire them! They have very little experience w/ developing in Remedy. I am usually able to assess their problem solving skills are, their experience w/ maintaining the arsystem, and their development skills all w/ this one question. Of course ... you have had to crash Remedy several times yourself in a production environment to know the answers :-) Sean From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Tuesday, February 19, 2008 1:13 PM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** whew! I thought I was the only one! Lisa From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mark Rushton Sent: Tuesday, February 19, 2008 10:11 AM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** Dang - 10 years on and still cant answer some of these...!!! Mark Rushton IBM Global Services Remedy Engineering Development Team Marc Simmons [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 19/02/2008 13:55 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Interview questions ** 1. What is the primary table in the AR System data dictionary? 2. How does the AR System manage the data you see in Remedy Forms? 3. Without using DSO or EIE, what are your thoughts for providing a 'STANDARDIZED' methodology for interfacing/integrating with Remedy applications. This customer was actually looking to use C.I.M. or some other open standard solution to interface with Remedy maybe a good discussion for the list!!! 4. How do you trouble shoot AR System server outages to restore access to the system? 5. How does mid-tier work and where does it fit in the client server architecture? 6. Describe how filters work? They were actually looking how filters work in different phases... which led to the next question. 7. Can you force a filter to fire all actions in the first phase? 8. List all of the possible uses for guides. They were looking for walking tables. These are all pretty simple questions. I also get some questions about turning on/off server features using the configuration files (ar.conf/ar.cfg). Hope this helps some, Marc On 2/19/08, Remedy Service Desk [EMAIL PROTECTED]mailto:[EMAIL PROTECTED] wrote: ** Hi All, Hope you are doing well, can I request for Remedy Interview questions? Thanks Service Desk __Platinum Sponsor: www.rmsportal.comhttp://www.rmsportal.com/ ARSlist: Where the Answers Are html___ -- Marc Simmons Remedy Administrator Everyday above ground is a good day... the rest is a choice! __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Unless stated otherwise above: IBM United Kingdom Limited - Registered in England and Wales with number 741598. Registered office: PO Box 41, North Harbour, Portsmouth, Hampshire PO6 3AU __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: Interview questions
This is why I asked what is the position and what is the person's responsibilities - the questions are going to be different based on what you are hiring the person for. On 2/20/08, Pierson, Shawn [EMAIL PROTECTED] wrote: ** A lot of these questions are good, but I'm wondering if they are the right ones given the current climate of BMC and the direction Remedy is going in. For example, asking someone development questions, such as filter phasing, assumes that they are going to be a Remedy Developer. If I were hiring right now, I would prefer to hire someone with experience handling ITSM 7. So my questions would be more along the lines of, A user requests that you add a new approval phase on Change Management. Describe the process of doing this. They should discuss how to decide whether or not the request is going to break Change Management, what forms to use, etc. Shawn PiersonPrivate and confidential as detailed here. 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: Interview questions
A lot of these questions are good, but I'm wondering if they are the right ones given the current climate of BMC and the direction Remedy is going in. For example, asking someone development questions, such as filter phasing, assumes that they are going to be a Remedy Developer. If I were hiring right now, I would prefer to hire someone with experience handling ITSM 7. So my questions would be more along the lines of, A user requests that you add a new approval phase on Change Management. Describe the process of doing this. They should discuss how to decide whether or not the request is going to break Change Management, what forms to use, etc. Shawn Pierson 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: www.rmsportal.com ARSlist: Where the Answers Are
Re: Problem Setting a Date field in Filter
What is NLS_DATE_FORMAT set to? Axton Grams On Wed, Feb 20, 2008 at 10:20 AM, Jerry Niman [EMAIL PROTECTED] wrote: ARS 6.00.03 patch 22 Oracle 9.2.0.1.0 Solaris 8 I am attempting to set a Date field (not a date/time field) in a SET FIELDS action within a filter from the content of a character field on the same form. If the character field contains 25/03/07 the date field is correctly set to 25 March 2007. However if the character field contains 25/03/2007 the date field is set to 25 March 2020, ie the filter only sees the first two digits of the year in the character representation of the date, and defaults the century to 20. the ARDATE environment variable is %d/%m/%Y %H:%M:%S the ARDATEONLY environment variable is %e %B %Y Any ideas? Jerry Jerry NimanTel+44 (0)161-247 1474 Head of ICT ServicesEmail [EMAIL PROTECTED] the Manchester Metropolitan University Mobile +44 (0)7770 638104 Before acting on this email or opening any attachments you should read the Manchester Metropolitan University's email disclaimer available on its website http://www.mmu.ac.uk/emaildisclaimer ___ 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: Problem Setting a Date field in Filter
Axton, It isn't set at all. Where should I set it, and what to? Jerry Jerry NimanTel+44 (0)161-247 1474 Head of ICT ServicesEmail [EMAIL PROTECTED] the Manchester Metropolitan University Mobile +44 (0)7770 638104 Before acting on this email or opening any attachments you should read the Manchester Metropolitan University’s email disclaimer available on its website http://www.mmu.ac.uk/emaildisclaimer Axton [EMAIL PROTECTED] 20 Feb 08 15:47 What is NLS_DATE_FORMAT set to? Axton Grams On Wed, Feb 20, 2008 at 10:20 AM, Jerry Niman [EMAIL PROTECTED] wrote: ARS 6.00.03 patch 22 Oracle 9.2.0.1.0 Solaris 8 I am attempting to set a Date field (not a date/time field) in a SET FIELDS action within a filter from the content of a character field on the same form. If the character field contains 25/03/07 the date field is correctly set to 25 March 2007. However if the character field contains 25/03/2007 the date field is set to 25 March 2020, ie the filter only sees the first two digits of the year in the character representation of the date, and defaults the century to 20. the ARDATE environment variable is %d/%m/%Y %H:%M:%S the ARDATEONLY environment variable is %e %B %Y Any ideas? Jerry Jerry NimanTel+44 (0)161-247 1474 Head of ICT ServicesEmail [EMAIL PROTECTED] the Manchester Metropolitan University Mobile +44 (0)7770 638104 Before acting on this email or opening any attachments you should read the Manchester Metropolitan University's email disclaimer available on its website http://www.mmu.ac.uk/emaildisclaimer ___ 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
Filter can not access WebService...???
Hi all, One of my friend is trying to access the WebService from Filter (SetField action). But at the time of loading it gives the mapping error like Failed to create internal mapping from wsdl ARERR 7012 And the detailed message is something like URI Not Found... But if the path is provided to the browser then it shows the WSDL Does anybody know why this error is occuring? ARS 7.0, Apache Tomcat 5.0 MidTier 6.3 Thanks in Advance.. -- View this message in context: http://www.nabble.com/Filter-can-not-access-WebService...tp15591061p15591061.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: www.rmsportal.com ARSlist: Where the Answers Are
Task variables
I have a couple of questions about tasks and variables: 1) How does information get into system variables (used with task)? 2) If I can't put information into system variables (used with task) and it is not best practices to put information into global [task] variables, how do you pass information between tasks/task groups? Anne Ramey ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Defect: Auto-Close - Change - ITSM 7
Just an FYI - the auto close in Change does not work. This is observed as a bug and already a defect SW00275623 is logged for the same. The defect status is in work in Progress. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Problem Setting a Date field in Filter
Try this: NLS_DATE_FORMAT=Mon DD HH24:MI:SS Axton Grams On Wed, Feb 20, 2008 at 10:51 AM, Jerry Niman [EMAIL PROTECTED] wrote: Axton, It isn't set at all. Where should I set it, and what to? Jerry Jerry NimanTel+44 (0)161-247 1474 Head of ICT ServicesEmail [EMAIL PROTECTED] the Manchester Metropolitan University Mobile +44 (0)7770 638104 Before acting on this email or opening any attachments you should read the Manchester Metropolitan University's email disclaimer available on its website http://www.mmu.ac.uk/emaildisclaimer Axton [EMAIL PROTECTED] 20 Feb 08 15:47 What is NLS_DATE_FORMAT set to? Axton Grams On Wed, Feb 20, 2008 at 10:20 AM, Jerry Niman [EMAIL PROTECTED] wrote: ARS 6.00.03 patch 22 Oracle 9.2.0.1.0 Solaris 8 I am attempting to set a Date field (not a date/time field) in a SET FIELDS action within a filter from the content of a character field on the same form. If the character field contains 25/03/07 the date field is correctly set to 25 March 2007. However if the character field contains 25/03/2007 the date field is set to 25 March 2020, ie the filter only sees the first two digits of the year in the character representation of the date, and defaults the century to 20. the ARDATE environment variable is %d/%m/%Y %H:%M:%S the ARDATEONLY environment variable is %e %B %Y Any ideas? Jerry Jerry NimanTel+44 (0)161-247 1474 Head of ICT ServicesEmail [EMAIL PROTECTED] the Manchester Metropolitan University Mobile +44 (0)7770 638104 Before acting on this email or opening any attachments you should read the Manchester Metropolitan University's email disclaimer available on its website http://www.mmu.ac.uk/emaildisclaimer ___ 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: arserver.exe Memory Usage 7.0.01
Hello All, 7.0.01 Unpatched Sql Server 2005 I was told by support that 7.0.01 had a known memory leak. after about 3 months of continously running, our prod box finally crashed due to no more available memory. Has anyone else been told it's a known memory leak? Thanks, Jase On 2/19/08, Joe DeSouza [EMAIL PROTECTED] wrote: ** Did anyone get any indication from Support that they are likely to organize an effort internally to clean up the current ITSM application to remove the extra overheads by deleting unused objects especially forms from within the application? This is almost an impossible task on a short term engagement unless you have a ready list of what can be safely deleted that is not used in any of the applications. I so wish there is an effort internally by BMC engineering to clean this app up. IMHO this should be among one of the priority fixes in a forthcoming patch... Did BMC Support give an indication to anyone that they are likley to make that effort to clean the applications up? Joe -- Never miss a thing. Make Yahoo your homepage.http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs __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: Defect: Auto-Close - Change - ITSM 7
I never heard about this. I just did a lookup and I can see that indeed Change tickets that were marked Completed over a month ago are still in a Status of Completed. They should be moved to Closed with Status Reason of Successful right? (if they were left there in Completed status for at least 15 days) Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Wednesday, February 20, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Defect: Auto-Close - Change - ITSM 7 Just an FYI - the auto close in Change does not work. This is observed as a bug and already a defect SW00275623 is logged for the same. The defect status is in work in Progress. ___ 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: arserver.exe Memory Usage 7.0.01
Jase We were running ARS 7.0.1 unpatched on a Unix server. We were constandly crashing due to a memory leak. Patch 3 fixed that and stabilized the system. Dan Dan Wangler, Team Lead, STARS Group Phone: 214-567-8304; email: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Client/Server Services, IT Opeations Texas Instruments, Inc. 6500 Chase Oaks Blvd., MS 8401 Plano, Texas, 75023 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jase Brandon Sent: Wednesday, February 20, 2008 10:27 AM To: arslist@ARSLIST.ORG Subject: Re: arserver.exe Memory Usage 7.0.01 ** Hello All, 7.0.01 Unpatched Sql Server 2005 I was told by support that 7.0.01 had a known memory leak. after about 3 months of continously running, our prod box finally crashed due to no more available memory. Has anyone else been told it's a known memory leak? Thanks, Jase On 2/19/08, Joe DeSouza [EMAIL PROTECTED] wrote: ** Did anyone get any indication from Support that they are likely to organize an effort internally to clean up the current ITSM application to remove the extra overheads by deleting unused objects especially forms from within the application? This is almost an impossible task on a short term engagement unless you have a ready list of what can be safely deleted that is not used in any of the applications. I so wish there is an effort internally by BMC engineering to clean this app up. IMHO this should be among one of the priority fixes in a forthcoming patch... Did BMC Support give an indication to anyone that they are likley to make that effort to clean the applications up? Joe Never miss a thing. Make Yahoo your homepage. http://us.rd.yahoo.com/evt=51438/*http:/www.yahoo.com/r/hs __Platinum Sponsor: www.rmsportal.com http://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: arserver.exe Memory Usage 7.0.01
Yes. Axton Grams On Wed, Feb 20, 2008 at 11:27 AM, Jase Brandon [EMAIL PROTECTED] wrote: ** Hello All, 7.0.01 Unpatched Sql Server 2005 I was told by support that 7.0.01 had a known memory leak. after about 3 months of continously running, our prod box finally crashed due to no more available memory. Has anyone else been told it's a known memory leak? Thanks, Jase On 2/19/08, Joe DeSouza [EMAIL PROTECTED] wrote: ** Did anyone get any indication from Support that they are likely to organize an effort internally to clean up the current ITSM application to remove the extra overheads by deleting unused objects especially forms from within the application? This is almost an impossible task on a short term engagement unless you have a ready list of what can be safely deleted that is not used in any of the applications. I so wish there is an effort internally by BMC engineering to clean this app up. IMHO this should be among one of the priority fixes in a forthcoming patch... Did BMC Support give an indication to anyone that they are likley to make that effort to clean the applications up? Joe -- Never miss a thing. Make Yahoo your homepage.http://us.rd.yahoo.com/evt=51438/*http://www.yahoo.com/r/hs __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
ARinside
What is the latest version of ARinside? Where can I find it? Thanks, Toby. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARinside
The site used to be system.devdor.net but that link no longer works, it just takes you to a domain parking page. I've got the installer for 2.07.2 if that helps. -Matt Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Toby White Sent: Wednesday, February 20, 2008 12:10 PM To: arslist@ARSLIST.ORG Subject: ARinside ** What is the latest version of ARinside? Where can I find it? Thanks, Toby. __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: ARinside
Have you tried here? http://www.mattreinfeldt.com/site/component/option,com_docman/task,cat_v iew/gid,35/Itemid,28/ Stephen Remedy Skilled Professional From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Wednesday, February 20, 2008 12:34 PM To: arslist@ARSLIST.ORG Subject: Re: ARinside The site used to be system.devdor.net but that link no longer works, it just takes you to a domain parking page. I've got the installer for 2.07.2 if that helps. -Matt Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Toby White Sent: Wednesday, February 20, 2008 12:10 PM To: arslist@ARSLIST.ORG Subject: ARinside ** What is the latest version of ARinside? Where can I find it? Thanks, Toby. __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: Task variables
I have a couple of questions about tasks and variables: 1) How does information get into system variables (used with task)? 2) If I can't put information into system variables (used with task) and it is not best practices to put information into global [task] variables, how do you pass information between tasks/task groups? Forgot to mention I am using AR 7.0.1 on Linux with ITSM 7.0.2 Patch 4 with Patch 9002 for IM (task management) installed. Anne __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: Filter can not access WebService...???
It could also be a problem of using something in the WSDL that Remedy does not allow. i.e. Remedy does not accept the XML Array type. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Chandre Gowda Sent: Wednesday, February 20, 2008 12:56 PM To: arslist@ARSLIST.ORG Subject: Re: Filter can not access WebService...??? ** Try giving the proxy settings in File-Preferences of your Admin Tool. -Dhttp.proxySet=true -Dhttp.proxyHost=host_name -Dhttp.proxyPort=port_number Also make sure you have JRE installed. Cheers, Chandru On Feb 20, 2008 11:01 AM, smart_aju2007 [EMAIL PROTECTED] wrote: Hi all, One of my friend is trying to access the WebService from Filter (SetField action). But at the time of loading it gives the mapping error like Failed to create internal mapping from wsdl ARERR 7012 And the detailed message is something like URI Not Found... But if the path is provided to the browser then it shows the WSDL Does anybody know why this error is occuring? ARS 7.0, Apache Tomcat 5.0 MidTier 6.3 Thanks in Advance.. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Filter can not access WebService...???
Try giving the proxy settings in File-Preferences of your Admin Tool. -Dhttp.proxySet=true -Dhttp.proxyHost=host_name -Dhttp.proxyPort= port_number Also make sure you have JRE installed. Cheers, Chandru On Feb 20, 2008 11:01 AM, smart_aju2007 [EMAIL PROTECTED] wrote: Hi all, One of my friend is trying to access the WebService from Filter (SetField action). But at the time of loading it gives the mapping error like Failed to create internal mapping from wsdl ARERR 7012 And the detailed message is something like URI Not Found... But if the path is provided to the browser then it shows the WSDL Does anybody know why this error is occuring? ARS 7.0, Apache Tomcat 5.0 MidTier 6.3 Thanks in Advance.. -- View this message in context: http://www.nabble.com/Filter-can-not-access-WebService...tp15591061p15591061.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: 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: Defect: Auto-Close - Change - ITSM 7
This is what Remedy tells me. So since the defect is Work in Progress I will have to create my own workflow / escalation to auto close the Change tickets. On 2/20/08, Lammey, Peter A. [EMAIL PROTECTED] wrote: I never heard about this. I just did a lookup and I can see that indeed Change tickets that were marked Completed over a month ago are still in a Status of Completed. They should be moved to Closed with Status Reason of Successful right? (if they were left there in Completed status for at least 15 days) Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Wednesday, February 20, 2008 11:20 AM To: arslist@ARSLIST.ORG Subject: Defect: Auto-Close - Change - ITSM 7 Just an FYI - the auto close in Change does not work. This is observed as a bug and already a defect SW00275623 is logged for the same. The defect status is in work in Progress. ___ 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
Direct SQL - Using current request ID
Hi List, I've got a button on the AR System Email Messages form that executes an active link with a direct SQL action. The SQL statement needs to get data from the current request, so I'm basing that on the Email ID field. However, I can't seem to get the where clause to work. Here's what I've tried. Statement: WHERE Email_ID = $Email ID$ Result: ARERR [552] Failure during SQL operation to the database : Incorrect syntax near '='. (SQL Server 102) Statement: WHERE Email_ID = '$Email ID$' Result: No item matches active link conditions - I checked the SQL log and see this WHERE Email_ID = ' ' but if I run a report on the form I'm working on I can see the Email ID field is populated. Statement: WHERE Email_ID = $Email ID$ Result: *** ERROR *** An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as or [] are not allowed. Add a name or single space as the alias name. TIA, Matt Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Email Engine Out of Box
Can someone tell me if the Email Engine install should have created an entry in armonitor.cfg? This is for AR 7.0.01. I noticed that the install did not create a dependency between the BMC Remedy Action Request System Server service and BMC Remedy Email Engine service and am left wondering if it also failed to put an entry in armonitor.cfg. Thanks Michael Bardsley ESPN MIT Technical Services Applications Management ESPN Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Direct SQL - Using current request ID
I forgot, we're running ARS 7.0.1 patch 003 and MS SQL 2005. Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Wednesday, February 20, 2008 2:52 PM To: arslist@ARSLIST.ORG Subject: Direct SQL - Using current request ID ** Hi List, I've got a button on the AR System Email Messages form that executes an active link with a direct SQL action. The SQL statement needs to get data from the current request, so I'm basing that on the Email ID field. However, I can't seem to get the where clause to work. Here's what I've tried. Statement: WHERE Email_ID = $Email ID$ Result: ARERR [552] Failure during SQL operation to the database : Incorrect syntax near '='. (SQL Server 102) Statement: WHERE Email_ID = '$Email ID$' Result: No item matches active link conditions - I checked the SQL log and see this WHERE Email_ID = ' ' but if I run a report on the form I'm working on I can see the Email ID field is populated. Statement: WHERE Email_ID = $Email ID$ Result: *** ERROR *** An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as or [] are not allowed. Add a name or single space as the alias name. TIA, Matt Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 __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: Email Engine Out of Box
I don't recall the Email Engine ever being referenced in armonitor.cfg. It's always been a separate service with the only dependency being defined in the registry to make the Email Engine service depend on the AR Server service. But in my last fresh 7.0.1 install even that dependency didn't exist. I'm guessing BMC decided not to link the two any longer, although I don't recall and documentation stating that. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Wednesday, February 20, 2008 2:07 PM To: arslist@ARSLIST.ORG Subject: Email Engine Out of Box Can someone tell me if the Email Engine install should have created an entry in armonitor.cfg? This is for AR 7.0.01. I noticed that the install did not create a dependency between the BMC Remedy Action Request System Server service and BMC Remedy Email Engine service and am left wondering if it also failed to put an entry in armonitor.cfg. Thanks Michael Bardsley ESPN MIT Technical Services Applications Management ESPN Inc. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ *** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: IM 7.x Bug - Need someone to check patch 6 or 7
I have a patch 6 installation and it still uses the LIKE operator Date: Wed, 20 Feb 2008 15:04:34 -0600From: [EMAIL PROTECTED]: IM 7.x Bug - Need someone to check patch 6 or 7To: [EMAIL PROTECTED] In IM 7.02 patch 2 we have the following problem - I need someone to verify if it exists in Patch 6 or 7 of IM 7.0x since I don't have a server free to install on right now. Read below for more details. If you have two (or more) customer (CTM:People) records with the exact same name AND the same phone # (e.g., unknown ###) but different email addresses (i.e., actually different people) and you do a search from the Incident screen you are given the results in the People Search form. If you select the first one you're fine. If you select the second or later one the system selects the first one anyway. This is because the workflow HPD:INC:PCS_100_Search does something really, really stupid. It selects the customer record for the incident based off of Like query using: -Company -First name -Last name -Phone number Why this doesn't just use the People ID is beyond me - this is really sloppy. It's also a very inefficient query. That said - can someone with a patch 6 or 7 install check that active link and see if the second Set Fields action is still a LIKE query? William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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: IM 7.x Bug - Need someone to check patch 6 or 7
IM 7.0.2 Patch 6 The 2nd Set fields is still the way you describe it. HTH, Tim From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Wednesday, February 20, 2008 4:05 PM To: arslist@ARSLIST.ORG Subject: IM 7.x Bug - Need someone to check patch 6 or 7 ** In IM 7.02 patch 2 we have the following problem - I need someone to verify if it exists in Patch 6 or 7 of IM 7.0x since I don't have a server free to install on right now. Read below for more details. If you have two (or more) customer (CTM:People) records with the exact same name AND the same phone # (e.g., unknown ###) but different email addresses (i.e., actually different people) and you do a search from the Incident screen you are given the results in the People Search form. If you select the first one you're fine. If you select the second or later one the system selects the first one anyway. This is because the workflow HPD:INC:PCS_100_Search does something really, really stupid. It selects the customer record for the incident based off of Like query using: -Company -First name -Last name -Phone number Why this doesn't just use the People ID is beyond me - this is really sloppy. It's also a very inefficient query. That said - can someone with a patch 6 or 7 install check that active link and see if the second Set Fields action is still a LIKE query? William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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
IM 7.x Bug - Need someone to check patch 6 or 7
In IM 7.02 patch 2 we have the following problem - I need someone to verify if it exists in Patch 6 or 7 of IM 7.0x since I don't have a server free to install on right now. Read below for more details. If you have two (or more) customer (CTM:People) records with the exact same name AND the same phone # (e.g., unknown ###) but different email addresses (i.e., actually different people) and you do a search from the Incident screen you are given the results in the People Search form. If you select the first one you're fine. If you select the second or later one the system selects the first one anyway. This is because the workflow HPD:INC:PCS_100_Search does something really, really stupid. It selects the customer record for the incident based off of Like query using: -Company -First name -Last name -Phone number Why this doesn't just use the People ID is beyond me - this is really sloppy. It's also a very inefficient query. That said - can someone with a patch 6 or 7 install check that active link and see if the second Set Fields action is still a LIKE query? William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Email Engine Out of Box
I was told by one support person and other users that the dependency should be there as it was in 6.3. I did not get a confident answer from support about the armonitor.cfg entry though. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Wednesday, February 20, 2008 3:38 PM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Out of Box ** I don't recall the Email Engine ever being referenced in armonitor.cfg. It's always been a separate service with the only dependency being defined in the registry to make the Email Engine service depend on the AR Server service. But in my last fresh 7.0.1 install even that dependency didn't exist. I'm guessing BMC decided not to link the two any longer, although I don't recall and documentation stating that. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Wednesday, February 20, 2008 2:07 PM To: arslist@ARSLIST.ORG Subject: Email Engine Out of Box Can someone tell me if the Email Engine install should have created an entry in armonitor.cfg? This is for AR 7.0.01. I noticed that the install did not create a dependency between the BMC Remedy Action Request System Server service and BMC Remedy Email Engine service and am left wondering if it also failed to put an entry in armonitor.cfg. Thanks Michael Bardsley ESPN MIT Technical Services Applications Management ESPN Inc. *** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. __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
Importing picture files; creating new records
Hi Everyone, Quick question and I do apologize for only doing light research on this. Is there a method I can import picture files (jpg) which will be stored in an attachment field on a new record that will be created? I know I can export attachments in .arx file and import those. But these would be just pictures in a folder. This record will be a child record to our Site form and a table field will display the entries. I've never tried to display an attachment filed in a table field so I'm not sure I can do that, but that would be the objective. That way they could just double click on the file and open it. We have to take various pictures related to customer installations and they are looking for a better way to store this info than the server/folder structure they are currently using. I'm thinking one attachment field per record so we can categorize those records for easy searching beyond looking at the individual Site records. Thanks for your suggestions and help. Susan Susan Palmer ShopperTrak ARS v7.0.1P3 - server, users, admin Oracle 10g Windows 2003 server ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Working with Group / GroupList / GroupID
Good Evening for all... I'd like to know if there is a possibility that I use a 'Set Field' or 'Push Field' action on this case: First, let's consider that I work with only one value on 'Group List' field (Form User).. I've created a Filter that work like this: Form Name: User Run If: 'Group List' != $NULL$ If Action: Push Field - Server Name: Current Server - Push Value To: MY_FORM -- Push Field If: ( $Request ID$ != 'Entry-Id') AND ( 'Entry-Id' = $NULL$ ) -- Fields: 'GROUP' = $Group List$ P.S. // Entry-Id and GROUP are from MY_FORM form. Well, what's happenin' ??? My field 'GROUP' (on MY_FORM form) is receiving the ID from the Group that was in $Group List$ field from Form User... I'd like to know if there is a choice that I put the Group Name of these ID in my field 'GROUP' (on MY_FORM form)? What have I done?? I have done an Active Link that makes a 'Set Field' action like this: Form Name: MY_FORM Run If: 'GROUP' != $NULL$ If Action: Set Fields - Server Name: Current Server - Read Value for Field From: Group -- Set Field If: 'Group ID' = $GROUP$ -- Fields: GROUP = $Group Name$ P.S. // Where: // - GROUP is from MY_FORM form; // - 'Group ID' and $Group Name$ are from Group form (Form of AR System) But this isn't running... I received the following message: ARERR [313] Data types are not appropriate for relational operation The preceding message occurred during the execution of active link MY_FORM -- action 1. (ARNOTE 1101) Can anybody help me??? I'm avaiable for question and answers... Thankx a lot in advance... Tadeu Augusto Dutra Pinto - IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - Confiabilidade, Inovação e Qualidade em T.I. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: IM 7.x Bug - Need someone to check patch 6 or 7
Since I had to customize the search dialog to search on Corporate ID and Login ID since the OOTB code failed to do that (and previous 4.x and 5.5x ITSM apps we used here all did), I added those fields to the search qualification, which makes it MUCH more specific. ( 'Company' LIKE ( $z1D Char01$ + % )) AND ( 'Last Name' LIKE ( $z1D Char02$ + % )) AND ( 'First Name' LIKE ( $z1D Char03$ + % )) AND ( 'Phone Number Business' LIKE (( % + $z1D Char04$) + % )) AND ( 'Remedy Login ID' LIKE $z1D Char22$) AND ( 'Corporate ID' LIKE $z1D Char23$) Guess I could have cleaned it up some more, but I have not seen it select the wrong customer with these qualifications. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Wednesday, February 20, 2008 3:28 PM To: arslist@ARSLIST.ORG Subject: Re: IM 7.x Bug - Need someone to check patch 6 or 7 ** Looks like it is still that way in IM 7.0.3 Patch 007. The Set Field If on the 2nd set fields action in the active link is: ( 'Company' LIKE ( $z1D Char01$ + % )) AND ( 'Last Name' LIKE ( $z1D Char02$ + % )) AND ( 'First Name' LIKE ( $z1D Char03$ + % )) AND ( 'Phone Number Business' LIKE (( % + $z1D Char04$) + % )) J.T. Shyman Column Technologies _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Wednesday, February 20, 2008 4:05 PM To: arslist@ARSLIST.ORG Subject: IM 7.x Bug - Need someone to check patch 6 or 7 In IM 7.02 patch 2 we have the following problem - I need someone to verify if it exists in Patch 6 or 7 of IM 7.0x since I don't have a server free to install on right now. Read below for more details. If you have two (or more) customer (CTM:People) records with the exact same name AND the same phone # (e.g., unknown ###) but different email addresses (i.e., actually different people) and you do a search from the Incident screen you are given the results in the People Search form. If you select the first one you're fine. If you select the second or later one the system selects the first one anyway. This is because the workflow HPD:INC:PCS_100_Search does something really, really stupid. It selects the customer record for the incident based off of Like query using: -Company -First name -Last name -Phone number Why this doesn't just use the People ID is beyond me - this is really sloppy. It's also a very inefficient query. That said - can someone with a patch 6 or 7 install check that active link and see if the second Set Fields action is still a LIKE query? William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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: IM 7.x Bug - Need someone to check patch 6 or 7
Looks like it is still that way in IM 7.0.3 Patch 007. The Set Field If on the 2nd set fields action in the active link is: ( 'Company' LIKE ( $z1D Char01$ + % )) AND ( 'Last Name' LIKE ( $z1D Char02$ + % )) AND ( 'First Name' LIKE ( $z1D Char03$ + % )) AND ( 'Phone Number Business' LIKE (( % + $z1D Char04$) + % )) J.T. Shyman Column Technologies _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Wednesday, February 20, 2008 4:05 PM To: arslist@ARSLIST.ORG Subject: IM 7.x Bug - Need someone to check patch 6 or 7 In IM 7.02 patch 2 we have the following problem - I need someone to verify if it exists in Patch 6 or 7 of IM 7.0x since I don't have a server free to install on right now. Read below for more details. If you have two (or more) customer (CTM:People) records with the exact same name AND the same phone # (e.g., unknown ###) but different email addresses (i.e., actually different people) and you do a search from the Incident screen you are given the results in the People Search form. If you select the first one you're fine. If you select the second or later one the system selects the first one anyway. This is because the workflow HPD:INC:PCS_100_Search does something really, really stupid. It selects the customer record for the incident based off of Like query using: -Company -First name -Last name -Phone number Why this doesn't just use the People ID is beyond me - this is really sloppy. It's also a very inefficient query. That said - can someone with a patch 6 or 7 install check that active link and see if the second Set Fields action is still a LIKE query? William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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: Email Engine Out of Box
Michael, If it helps I just did a brand new install of 7.1 and the EE and there is no entry in the armonitor.cfg and there is no dependency for the service. HTH, Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Wednesday, February 20, 2008 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Out of Box ** I was told by one support person and other users that the dependency should be there as it was in 6.3. I did not get a confident answer from support about the armonitor.cfg entry though. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Wednesday, February 20, 2008 3:38 PM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Out of Box ** I don't recall the Email Engine ever being referenced in armonitor.cfg. It's always been a separate service with the only dependency being defined in the registry to make the Email Engine service depend on the AR Server service. But in my last fresh 7.0.1 install even that dependency didn't exist. I'm guessing BMC decided not to link the two any longer, although I don't recall and documentation stating that. Chad Hall (501) 342-2650 _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Wednesday, February 20, 2008 2:07 PM To: arslist@ARSLIST.ORG Subject: Email Engine Out of Box Can someone tell me if the Email Engine install should have created an entry in armonitor.cfg? This is for AR 7.0.01. I noticed that the install did not create a dependency between the BMC Remedy Action Request System Server service and BMC Remedy Email Engine service and am left wondering if it also failed to put an entry in armonitor.cfg. Thanks Michael Bardsley ESPN MIT Technical Services Applications Management ESPN Inc. *** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. __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
ARUtilities / Les Ganton search
Hi all, I am looking for Les Ganton. We have been wanting to purchase ARUtilities but have been having a hard time reaching him. I have tried both [EMAIL PROTECTED] and [EMAIL PROTECTED] and have not heard back from him. Does anybody have any idea if anything has happened to him (I am starting to worry, he has always been responsive)? Thanks, Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Importing picture files; creating new records
Using Pure Remedy code you could have a field in the import be the full picture file name. You could then use the PERFORM-ACTION-ADD-ATTACHMENT field_ID [file_name] command to save the picture to an attachment. Personally we have a form with a single attachment on it. We show a table on the ticket that shows the records in the attachment form that relate to the existing ticket record. When a user clicks on a row in the table a custom AL display's the attachment using the PERFORM-ACTION-OPEN-ATTACHMENT field_ID command. Fred From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Susan Palmer Sent: Wednesday, February 20, 2008 3:32 PM To: arslist@ARSLIST.ORG Subject: Importing picture files; creating new records ** Hi Everyone, Quick question and I do apologize for only doing light research on this. Is there a method I can import picture files (jpg) which will be stored in an attachment field on a new record that will be created? I know I can export attachments in .arx file and import those. But these would be just pictures in a folder. This record will be a child record to our Site form and a table field will display the entries. I've never tried to display an attachment filed in a table field so I'm not sure I can do that, but that would be the objective. That way they could just double click on the file and open it. We have to take various pictures related to customer installations and they are looking for a better way to store this info than the server/folder structure they are currently using. I'm thinking one attachment field per record so we can categorize those records for easy searching beyond looking at the individual Site records. Thanks for your suggestions and help. Susan Susan Palmer ShopperTrak ARS v7.0.1P3 - server, users, admin Oracle 10g Windows 2003 server __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: IM 7.x Bug - Need someone to check patch 6 or 7
Thanks for checking! From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Powell Sent: Wednesday, February 20, 2008 3:16 PM To: arslist@ARSLIST.ORG Subject: Re: IM 7.x Bug - Need someone to check patch 6 or 7 ** IM 7.0.2 Patch 6 The 2nd Set fields is still the way you describe it. HTH, Tim From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Wednesday, February 20, 2008 4:05 PM To: arslist@ARSLIST.ORG Subject: IM 7.x Bug - Need someone to check patch 6 or 7 ** In IM 7.02 patch 2 we have the following problem - I need someone to verify if it exists in Patch 6 or 7 of IM 7.0x since I don't have a server free to install on right now. Read below for more details. If you have two (or more) customer (CTM:People) records with the exact same name AND the same phone # (e.g., unknown ###) but different email addresses (i.e., actually different people) and you do a search from the Incident screen you are given the results in the People Search form. If you select the first one you're fine. If you select the second or later one the system selects the first one anyway. This is because the workflow HPD:INC:PCS_100_Search does something really, really stupid. It selects the customer record for the incident based off of Like query using: -Company -First name -Last name -Phone number Why this doesn't just use the People ID is beyond me - this is really sloppy. It's also a very inefficient query. That said - can someone with a patch 6 or 7 install check that active link and see if the second Set Fields action is still a LIKE query? William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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
Filter logging in 7.1
Hi All, I was trying to do AL and filter logging from 7.1 AR client - but did not log the filter calls. I was logged in as Demo and after further reading found that something has to be enabled on the server side. Can someone please clarify what has to be done so filter logging can be done from the client tool. Platform: ARS 7.1 on Solaris, Oracle 10g Thanks Atul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARUtilities / Les Ganton search
I heard from him just the other day (2/8/08).. TP From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller Sent: Wednesday, February 20, 2008 4:32 PM To: arslist@ARSLIST.ORG Subject: ARUtilities / Les Ganton search ** Hi all, I am looking for Les Ganton. We have been wanting to purchase ARUtilities but have been having a hard time reaching him. I have tried both [EMAIL PROTECTED] and [EMAIL PROTECTED] and have not heard back from him. Does anybody have any idea if anything has happened to him (I am starting to worry, he has always been responsive)? Thanks, Jason __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: Direct SQL - Using current request ID
What is your execute action for your active link? Is this for a new record being submitted into the form? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Wednesday, February 20, 2008 1:58 PM To: arslist@ARSLIST.ORG Subject: Re: Direct SQL - Using current request ID ** I forgot, we're running ARS 7.0.1 patch 003 and MS SQL 2005. Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Wednesday, February 20, 2008 2:52 PM To: arslist@ARSLIST.ORG Subject: Direct SQL - Using current request ID ** Hi List, I've got a button on the AR System Email Messages form that executes an active link with a direct SQL action. The SQL statement needs to get data from the current request, so I'm basing that on the Email ID field. However, I can't seem to get the where clause to work. Here's what I've tried. Statement: WHERE Email_ID = $Email ID$ Result: ARERR [552] Failure during SQL operation to the database : Incorrect syntax near '='. (SQL Server 102) Statement: WHERE Email_ID = '$Email ID$' Result: No item matches active link conditions - I checked the SQL log and see this WHERE Email_ID = ' ' but if I run a report on the form I'm working on I can see the Email ID field is populated. Statement: WHERE Email_ID = $Email ID$ Result: *** ERROR *** An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as or [] are not allowed. Add a name or single space as the alias name. TIA, Matt Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 __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
Changing Company Name on 7.0.01
Hello All, I am getting several requests to change the Company field in version 7.0.01 Ex. Joe's Computers is now changing it's name to Joseph's Computers. Field ID 11. When I search this field ID in ARutilities, it returns 417 references to that field. Has anyone come up with a way to change Company name and ensure it is propogated throughout the database? Other than a monster SQL script to update the field in all locations, I don't think this is possible. My current answer to this question is: Set Joe's computers to Obsolete and recreate as Joseph's Computers. But then we lost historical reporting data, etc. Has anyone else encountered this? I just thought we couldn't possibly be the only company who has dealt with this situation. 7.0.01 Unpatched SQL Server 2005 Thanks, Jase ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Email Engine Out of Box
Dependencies if you are on Windows are created in the registry using the key DependOnService. This can be done manually if it doesn't exist. Use regedt32 to create this key. The armonitor file only holds all the startup information such as startup parameters etc. Hope this helps.. Cheers Joe - Original Message From: Bardsley, Michael [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 2:52:32 PM Subject: Re: Email Engine Out of Box ** I was told by one support person and other users that the dependency should be there as it was in 6.3. I did not get a confident answer from support about the armonitor.cfg entry though. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Wednesday, February 20, 2008 3:38 PM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Out of Box ** I don’t recall the Email Engine ever being referenced in armonitor.cfg. It’s always been a separate service with the only dependency being defined in the registry to make the Email Engine service depend on the AR Server service. But in my last fresh 7.0.1 install even that dependency didn’t exist. I’m guessing BMC decided not to link the two any longer, although I don’t recall and documentation stating that. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG ] On Behalf Of Bardsley, Michael Sent: Wednesday, February 20, 2008 2:07 PM To: arslist@ARSLIST.ORG Subject: Email Engine Out of Box Can someone tell me if the Email Engine install should have created an entry in armonitor.cfg? This is for AR 7.0.01. I noticed that the install did not create a dependency between the BMC Remedy Action Request System Server service and BMC Remedy Email Engine service and am left wondering if it also failed to put an entry in armonitor.cfg. Thanks Michael Bardsley ESPN MIT Technical Services Applications Management ESPN Inc. Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Filter logging in 7.1
Client-Side Logging Group Server Information/Log Files tab from the AR System Administration Console within the User Tool. By default should be set to Administrator. As long as your Demo account still has Administrator permissions, you should be able to turn on Client side Filter logging. Leonard Neely Column Technologies _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Atul Vohra Sent: Wednesday, February 20, 2008 2:17 PM To: arslist@ARSLIST.ORG Subject: Filter logging in 7.1 ** Hi All, I was trying to do AL and filter logging from 7.1 AR client - but did not log the filter calls. I was logged in as Demo and after further reading found that something has to be enabled on the server side. Can someone please clarify what has to be done so filter logging can be done from the client tool. Platform: ARS 7.1 on Solaris, Oracle 10g Thanks Atul __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: Interview questions
Wow - I've been working with Remedy for 8 years or so and I've never had the second one happen! The first one on the other hand.. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, February 20, 2008 4:31 PM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** One of the questions I would ask is the error about violation of unique indexes. What do you do when you get this error. An experienced developer would know that this error can happen on both the user tool in case the system tries to create a duplicate record due to a conflict with the nextid in case it has been reset earlier OR can happen on the admin tool while creating new objects if there is a conflict with the containers ID that can happen sometimes due to data corruption for whatever reasons.. I'd be more interested in the later part of the answers as if that occurs its most likely an experienced developer who would know what got to be done next to get it working.. Joe - Original Message From: John Atherly [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 7:07:07 AM Subject: Re: Interview questions Why are manhole covers round? If any other shape they could fall in to the hole that they cover. Do I get the job? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i6 2sR8HDtDypao8Wcj9tAcJ __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: Filter logging in 7.1
I believe that there is a minimum permissions level that is set on the server side for client side logging. Ensure that you are a member of whatever group is specified there. Rick On Wed, Feb 20, 2008 at 2:17 PM, Atul Vohra [EMAIL PROTECTED] wrote: ** Hi All, I was trying to do AL and filter logging from 7.1 AR client - but did not log the filter calls. I was logged in as Demo and after further reading found that something has to be enabled on the server side. Can someone please clarify what has to be done so filter logging can be done from the client tool. Platform: ARS 7.1 on Solaris, Oracle 10g Thanks Atul __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: Importing picture files; creating new records
Great news Frederick ... thanks for the information !! Susan On Wed, Feb 20, 2008 at 3:57 PM, Grooms, Frederick W [EMAIL PROTECTED] wrote: ** Using Pure Remedy code you could have a field in the import be the full picture file name. You could then use the PERFORM-ACTION-ADD-ATTACHMENT field_ID [file_name] command to save the picture to an attachment. Personally we have a form with a single attachment on it. We show a table on the ticket that shows the records in the attachment form that relate to the existing ticket record. When a user clicks on a row in the table a custom AL display's the attachment using the PERFORM-ACTION-OPEN-ATTACHMENT field_ID command. Fred -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Susan Palmer *Sent:* Wednesday, February 20, 2008 3:32 PM *To:* arslist@ARSLIST.ORG *Subject:* Importing picture files; creating new records ** Hi Everyone, Quick question and I do apologize for only doing light research on this. Is there a method I can import picture files (jpg) which will be stored in an attachment field on a new record that will be created? I know I can export attachments in .arx file and import those. But these would be just pictures in a folder. This record will be a child record to our Site form and a table field will display the entries. I've never tried to display an attachment filed in a table field so I'm not sure I can do that, but that would be the objective. That way they could just double click on the file and open it. We have to take various pictures related to customer installations and they are looking for a better way to store this info than the server/folder structure they are currently using. I'm thinking one attachment field per record so we can categorize those records for easy searching beyond looking at the individual Site records. Thanks for your suggestions and help. Susan Susan Palmer ShopperTrak ARS v7.0.1P3 - server, users, admin Oracle 10g Windows 2003 server __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: IM 7.x Bug - Need someone to check patch 6 or 7
Hey, they still have code in this beast that tries to match on Full Name (we have 13,000 customers where Full name is not unique out of 130,000+). I probably worked around that too. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Wednesday, February 20, 2008 4:24 PM To: arslist@ARSLIST.ORG Subject: Re: IM 7.x Bug - Need someone to check patch 6 or 7 ** Again, thanks for checking. Code like this makes me crazy. If you have the People ID available - and you are selecting a specific record - why on earth would you not use where people ID = people ID. A four-way Like search on a form that is holding 1,000,000 records = bad idea. And since this is designed/marketed as an enterprise app it shouldn't be this way. A million or more customer records should be anticipated as the norm. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Wednesday, February 20, 2008 3:28 PM To: arslist@ARSLIST.ORG Subject: Re: IM 7.x Bug - Need someone to check patch 6 or 7 ** Looks like it is still that way in IM 7.0.3 Patch 007. The Set Field If on the 2nd set fields action in the active link is: ( 'Company' LIKE ( $z1D Char01$ + % )) AND ( 'Last Name' LIKE ( $z1D Char02$ + % )) AND ( 'First Name' LIKE ( $z1D Char03$ + % )) AND ( 'Phone Number Business' LIKE (( % + $z1D Char04$) + % )) J.T. Shyman Column Technologies _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Wednesday, February 20, 2008 4:05 PM To: arslist@ARSLIST.ORG Subject: IM 7.x Bug - Need someone to check patch 6 or 7 In IM 7.02 patch 2 we have the following problem - I need someone to verify if it exists in Patch 6 or 7 of IM 7.0x since I don't have a server free to install on right now. Read below for more details. If you have two (or more) customer (CTM:People) records with the exact same name AND the same phone # (e.g., unknown ###) but different email addresses (i.e., actually different people) and you do a search from the Incident screen you are given the results in the People Search form. If you select the first one you're fine. If you select the second or later one the system selects the first one anyway. This is because the workflow HPD:INC:PCS_100_Search does something really, really stupid. It selects the customer record for the incident based off of Like query using: -Company -First name -Last name -Phone number Why this doesn't just use the People ID is beyond me - this is really sloppy. It's also a very inefficient query. That said - can someone with a patch 6 or 7 install check that active link and see if the second Set Fields action is still a LIKE query? William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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: ARUtilities / Les Ganton search
Thanks Tim, that's better then 1/27/08 when I last heard from him. On Wed, Feb 20, 2008 at 2:19 PM, Timothy Powell [EMAIL PROTECTED] wrote: ** I heard from him just the other day (2/8/08)…… TP *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Jason Miller *Sent:* Wednesday, February 20, 2008 4:32 PM *To:* arslist@ARSLIST.ORG *Subject:* ARUtilities / Les Ganton search ** Hi all, I am looking for Les Ganton. We have been wanting to purchase ARUtilities but have been having a hard time reaching him. I have tried both [EMAIL PROTECTED] and [EMAIL PROTECTED] and have not heard back from him. Does anybody have any idea if anything has happened to him (I am starting to worry, he has always been responsive)? Thanks, Jason __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: Changing Company Name on 7.0.01
The good news: we have to do it too The bad news: We're moving to a new server and we're just going to do it as part of the migration in the Export Data/Search-Replace/Import fashion. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jase Brandon Sent: Wednesday, February 20, 2008 4:24 PM To: arslist@ARSLIST.ORG Subject: Changing Company Name on 7.0.01 ** Hello All, I am getting several requests to change the Company field in version 7.0.01 Ex. Joe's Computers is now changing it's name to Joseph's Computers. Field ID 11. When I search this field ID in ARutilities, it returns 417 references to that field. Has anyone come up with a way to change Company name and ensure it is propogated throughout the database? Other than a monster SQL script to update the field in all locations, I don't think this is possible. My current answer to this question is: Set Joe's computers to Obsolete and recreate as Joseph's Computers. But then we lost historical reporting data, etc. Has anyone else encountered this? I just thought we couldn't possibly be the only company who has dealt with this situation. 7.0.01 Unpatched SQL Server 2005 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
Re: IM 7.x Bug - Need someone to check patch 6 or 7
Again, thanks for checking. Code like this makes me crazy. If you have the People ID available - and you are selecting a specific record - why on earth would you not use where people ID = people ID. A four-way Like search on a form that is holding 1,000,000 records = bad idea. And since this is designed/marketed as an enterprise app it shouldn't be this way. A million or more customer records should be anticipated as the norm. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Wednesday, February 20, 2008 3:28 PM To: arslist@ARSLIST.ORG Subject: Re: IM 7.x Bug - Need someone to check patch 6 or 7 ** Looks like it is still that way in IM 7.0.3 Patch 007. The Set Field If on the 2nd set fields action in the active link is: ( 'Company' LIKE ( $z1D Char01$ + % )) AND ( 'Last Name' LIKE ( $z1D Char02$ + % )) AND ( 'First Name' LIKE ( $z1D Char03$ + % )) AND ( 'Phone Number Business' LIKE (( % + $z1D Char04$) + % )) J.T. Shyman Column Technologies From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Wednesday, February 20, 2008 4:05 PM To: arslist@ARSLIST.ORG Subject: IM 7.x Bug - Need someone to check patch 6 or 7 In IM 7.02 patch 2 we have the following problem - I need someone to verify if it exists in Patch 6 or 7 of IM 7.0x since I don't have a server free to install on right now. Read below for more details. If you have two (or more) customer (CTM:People) records with the exact same name AND the same phone # (e.g., unknown ###) but different email addresses (i.e., actually different people) and you do a search from the Incident screen you are given the results in the People Search form. If you select the first one you're fine. If you select the second or later one the system selects the first one anyway. This is because the workflow HPD:INC:PCS_100_Search does something really, really stupid. It selects the customer record for the incident based off of Like query using: -Company -First name -Last name -Phone number Why this doesn't just use the People ID is beyond me - this is really sloppy. It's also a very inefficient query. That said - can someone with a patch 6 or 7 install check that active link and see if the second Set Fields action is still a LIKE query? William Rentfrow, Principal Consultant [EMAIL PROTECTED] C 701-306-6157 O 952-432-0227 __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: Filter logging in 7.1
Atul File-Server Information-Log Files tab around the bottom have a look at the field Client Side Logging Group and set it to the appropriate group. but if you are logged in as Demo, you must have Admin privileges, so I don't understand why you cannot do filter logging from the User Tool? If that fails then set the Filter Logging to on by clicking the tick box on the Log Files tab. let me know if this works Shafqat Ayaz Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh Uncontrollably, And Never Regret anything that made you Smile.. - Original Message From: Atul Vohra [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 2:17:02 PM Subject: Filter logging in 7.1 ** Hi All, I was trying to do AL and filter logging from 7.1 AR client - but did not log the filter calls. I was logged in as Demo and after further reading found that something has to be enabled on the server side. Can someone please clarify what has to be done so filter logging can be done from the client tool. Platform: ARS 7.1 on Solaris, Oracle 10g Thanks Atul __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Interview questions
A long long long time ago a client of mine once had this issue.. I had gone under the covers, and realized that it the ARS was trying to create this object with the same ID that already existed (I think it was for AL's) but the ID in the container table was not updated. We never were able to find out how that may have happened but we attributed it to possible database timeouts as they were experiencing a few of those during that time.. On another occassion a lister here had experienced the same thing and I was able to help him/her restore their system.. The thing about such errors is usually it doesn't give you details as to which table or container this error is resulting from, and one way to find out is an SQL log during the operation. I'm not sure there could be another method to find this out as this is a DB problem.. Joe - Original Message From: William Rentfrow [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 4:33:55 PM Subject: Re: Interview questions ** Wow - I've been working with Remedy for 8 years or so and I've never had the second one happen! The first one on the other hand.. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, February 20, 2008 4:31 PM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** One of the questions I would ask is the error about violation of unique indexes. What do you do when you get this error. An experienced developer would know that this error can happen on both the user tool in case the system tries to create a duplicate record due to a conflict with the nextid in case it has been reset earlier OR can happen on the admin tool while creating new objects if there is a conflict with the containers ID that can happen sometimes due to data corruption for whatever reasons.. I'd be more interested in the later part of the answers as if that occurs its most likely an experienced developer who would know what got to be done next to get it working.. Joe - Original Message From: John Atherly [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 7:07:07 AM Subject: Re: Interview questions Why are manhole covers round? If any other shape they could fall in to the hole that they cover. Do I get the job? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: ARUtilities / Les Ganton search
Ditto Here.. we just got our license keys for ARUtilities last week... 02/14/08 Thanks, Jase Brandon On 2/20/08, Timothy Powell [EMAIL PROTECTED] wrote: ** I heard from him just the other day (2/8/08)…… TP *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Jason Miller *Sent:* Wednesday, February 20, 2008 4:32 PM *To:* arslist@ARSLIST.ORG *Subject:* ARUtilities / Les Ganton search ** Hi all, I am looking for Les Ganton. We have been wanting to purchase ARUtilities but have been having a hard time reaching him. I have tried both [EMAIL PROTECTED] and [EMAIL PROTECTED] and have not heard back from him. Does anybody have any idea if anything has happened to him (I am starting to worry, he has always been responsive)? Thanks, Jason __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: Email Engine Out of Box
Neither does my client here - and we are on windows.. But if it is critical that you need that dependency, its not hard to do from the registry if you are on windows.. I do not see it as a priority for us here as we have bigger issues than that :-) that we are dealing with.. If you need to know how let me know.. Cheers Joe - Original Message From: Brian Gillock [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 3:21:27 PM Subject: Re: Email Engine Out of Box ** Michael, If it helps I just did a brand new install of 7.1 and the EE and there is no entry in the armonitor.cfg and there is no dependency for the service. HTH, Brian From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Wednesday, February 20, 2008 12:53 PM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Out of Box ** I was told by one support person and other users that the dependency should be there as it was in 6.3. I did not get a confident answer from support about the armonitor.cfg entry though. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hall Chad - chahal Sent: Wednesday, February 20, 2008 3:38 PM To: arslist@ARSLIST.ORG Subject: Re: Email Engine Out of Box ** I don’t recall the Email Engine ever being referenced in armonitor.cfg. It’s always been a separate service with the only dependency being defined in the registry to make the Email Engine service depend on the AR Server service. But in my last fresh 7.0.1 install even that dependency didn’t exist. I’m guessing BMC decided not to link the two any longer, although I don’t recall and documentation stating that. Chad Hall (501) 342-2650 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Bardsley, Michael Sent: Wednesday, February 20, 2008 2:07 PM To: arslist@ARSLIST.ORG Subject: Email Engine Out of Box Can someone tell me if the Email Engine install should have created an entry in armonitor.cfg? This is for AR 7.0.01. I noticed that the install did not create a dependency between the BMC Remedy Action Request System Server service and BMC Remedy Email Engine service and am left wondering if it also failed to put an entry in armonitor.cfg. Thanks Michael Bardsley ESPN MIT Technical Services Applications Management ESPN Inc. *** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Changing Company Name on 7.0.01
BMC was supposedly going to release a utility for that this year (2008), but if they release something like Data Management (patch 9003) it will only work half-way, and only half of the time (and only with jato bottles strapped to its butt). If they release it on the same schedule we have seen for updating Incident Task Templates (patch 9002), you should see it sometime in calendar year 2009. You'll probably have to give them Doug Mueller's stock answer for people requesting customizations to ITSM 7: several iterations of NO. We have not faced company renaming (and plan to reject it outright), but we have seen some shuffling of support group names which is almost as bad since you have to move the support staff over and reassign the related records; your obsolete/recreate solution is the only one available to us right now. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing IT Center http://itsm.unt.edu/ _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jase Brandon Sent: Wednesday, February 20, 2008 4:24 PM To: arslist@ARSLIST.ORG Subject: Changing Company Name on 7.0.01 ** Hello All, I am getting several requests to change the Company field in version 7.0.01 Ex. Joe's Computers is now changing it's name to Joseph's Computers. Field ID 11. When I search this field ID in ARutilities, it returns 417 references to that field. Has anyone come up with a way to change Company name and ensure it is propogated throughout the database? Other than a monster SQL script to update the field in all locations, I don't think this is possible. My current answer to this question is: Set Joe's computers to Obsolete and recreate as Joseph's Computers. But then we lost historical reporting data, etc. Has anyone else encountered this? I just thought we couldn't possibly be the only company who has dealt with this situation. 7.0.01 Unpatched SQL Server 2005 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
ARS Server 7.1 and Email Engine dependency.. (correction)
Out of curiosity I just had a look, and we do have a dependency.. and it did come OTB. I'm pretty sure we didn't do that manually.. At least I didn't.. Cheers Joe Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
BMC Podcasts...
Not that I am looking start up the usual beat up on support for off shoring thread but I saw this headline at the top of my gmail and though some might find this interesting. *Getting More from Global Sourcing (Offshoring) by Automating Application Problem Resolution* http://talk.bmc.com/podcasts/podcast-gishri2/ Jason ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Interview questions
Me, either. I have seen that error occur when adding a unique index to a field containing data that violates it. Multiple NULL values are the most frequent culprit. Rick On Wed, Feb 20, 2008 at 2:33 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** Wow - I've been working with Remedy for 8 years or so and I've never had the second one happen! The first one on the other hand.. -- *From:* Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] *On Behalf Of *Joe DeSouza *Sent:* Wednesday, February 20, 2008 4:31 PM *To:* arslist@ARSLIST.ORG *Subject:* Re: Interview questions ** One of the questions I would ask is the error about violation of unique indexes. What do you do when you get this error. An experienced developer would know that this error can happen on both the user tool in case the system tries to create a duplicate record due to a conflict with the nextid in case it has been reset earlier OR can happen on the admin tool while creating new objects if there is a conflict with the containers ID that can happen sometimes due to data corruption for whatever reasons.. I'd be more interested in the later part of the answers as if that occurs its most likely an experienced developer who would know what got to be done next to get it working.. Joe - Original Message From: John Atherly [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 7:07:07 AM Subject: Re: Interview questions Why are manhole covers round? If any other shape they could fall in to the hole that they cover. Do I get the job? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 -- Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ__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: Direct SQL - Using current request ID
Just for the purposes of testing, I added a button to the form so I could test with existing records. In the end I want to have it fire on submit. I was able to hard code the entry ID into the direct SQL statement to make it work this afternoon, so I know the statement is good. I just need it to interpret that entry ID somehow. Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of William Rentfrow Sent: Wednesday, February 20, 2008 5:20 PM To: arslist@ARSLIST.ORG Subject: Re: Direct SQL - Using current request ID ** What is your execute action for your active link? Is this for a new record being submitted into the form? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Wednesday, February 20, 2008 1:58 PM To: arslist@ARSLIST.ORG Subject: Re: Direct SQL - Using current request ID ** I forgot, we're running ARS 7.0.1 patch 003 and MS SQL 2005. Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gayford, Matthew C. Sent: Wednesday, February 20, 2008 2:52 PM To: arslist@ARSLIST.ORG Subject: Direct SQL - Using current request ID ** Hi List, I've got a button on the AR System Email Messages form that executes an active link with a direct SQL action. The SQL statement needs to get data from the current request, so I'm basing that on the Email ID field. However, I can't seem to get the where clause to work. Here's what I've tried. Statement: WHERE Email_ID = $Email ID$ Result: ARERR [552] Failure during SQL operation to the database : Incorrect syntax near '='. (SQL Server 102) Statement: WHERE Email_ID = '$Email ID$' Result: No item matches active link conditions - I checked the SQL log and see this WHERE Email_ID = ' ' but if I run a report on the form I'm working on I can see the Email ID field is populated. Statement: WHERE Email_ID = $Email ID$ Result: *** ERROR *** An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as or [] are not allowed. Add a name or single space as the alias name. TIA, Matt Matthew C. Gayford Technology Research Development Information Technology Systems Division University of North Carolina Wilmington (910) 962-7177 __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: Filter logging in 7.1
v7.1 ... Login to the AR User tool as an Administrator. Navigate to the : AR System Administration Console ( from the Home Page Application List field) Then navigate to: -- System (from the Vertical Nav bar) -- General -- Server Information (Item) Then that opens the form AR System Administration: Server Information. On the Log Files (tab) the field 'Client-Side Logging Group:' value is the group that the user MUST be an explict member of. ( In versions prior to v7.1 this was in the admin tool. It is not there anymore.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. - Original Message From: Atul Vohra [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 2:17:02 PM Subject: Filter logging in 7.1 ** Hi All, I was trying to do AL and filter logging from 7.1 AR client - but did not log the filter calls. I was logged in as Demo and after further reading found that something has to be enabled on the server side. Can someone please clarify what has to be done so filter logging can be done from the client tool. Platform: ARS 7.1 on Solaris, Oracle 10g Thanks Atul ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Working with Group / GroupList / GroupID
Tadeu, I can explain it, but the solution is not so easy. The field 'Group' (on MY_FORM) is a character field. However the 'Group ID' field on Group is an integer field. Your database is complaining because your comparing an Char with an Int. I would suggest that you create your own MyGroup form and populate it with data from the AR System Group form. That way you can have an Integer 'Group ID' field and a 'Group ID As String' field too. ( Without risking changes to the AR System Group form.) Then you can do your test against the MyGroup form and the 'Group ID As String' field. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Feb 20, 2008 at 4:42 PM, Tadeu Augusto Dutra Pinto [EMAIL PROTECTED] wrote: ** Good Evening for all... I'd like to know if there is a possibility that I use a 'Set Field' or 'Push Field' action on this case: First, let's consider that I work with only one value on 'Group List' field (Form User).. I've created a Filter that work like this: Form Name: User Run If: 'Group List' != $NULL$ If Action: Push Field - Server Name: Current Server - Push Value To: MY_FORM -- Push Field If: ( $Request ID$ != 'Entry-Id') AND ( 'Entry-Id' = $NULL$ ) -- Fields: 'GROUP' = $Group List$ P.S. // Entry-Id and GROUP are from MY_FORM form. Well, what's happenin' ??? My field 'GROUP' (on MY_FORM form) is receiving the ID from the Group that was in $Group List$ field from Form User... I'd like to know if there is a choice that I put the Group Name of these ID in my field 'GROUP' (on MY_FORM form)? What have I done?? I have done an Active Link that makes a 'Set Field' action like this: Form Name: MY_FORM Run If: 'GROUP' != $NULL$ If Action: Set Fields - Server Name: Current Server - Read Value for Field From: Group -- Set Field If: 'Group ID' = $GROUP$ -- Fields: GROUP = $Group Name$ P.S. // Where: // - GROUP is from MY_FORM form; // - 'Group ID' and $Group Name$ are from Group form (Form of AR System) But this isn't running... I received the following message: ARERR [313] Data types are not appropriate for relational operation The preceding message occurred during the execution of active link MY_FORM -- action 1. (ARNOTE 1101) Can anybody help me??? I'm avaiable for question and answers... Thankx a lot in advance... Tadeu Augusto Dutra Pinto -IT Web Services ATM Cinq Technologies http://www.cinq.com.br [EMAIL PROTECTED] Fone: 41 3018-2833 - Cinq Fone: 41 2107-5736 - HSBC Outsourcing - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Interview questions
I can think of a situation where you want to loop through all records (not check the only selected rows) and only have certain workflow fire on the selected rows, and other workflow fire on all rows...:) _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Wednesday, February 20, 2008 7:45 AM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** Of course I just check the little box Table Loop Selected Rows Only in the Active Link that calls the guide. The `$ is a hold over from when Guides were first introduced and the Admin tool did not have that option. It is still allowed for backward compatability with old code. Fred _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Tuesday, February 19, 2008 4:58 PM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** Hello Christie Limit the active links in the table loop to run only against rows that are selected. To do so, append `$ (backquote character followed by a dollar sign) to the end of the names of the active links contained within the table loop guide. (You do not need to change the name of the active link that calls the guide, the names of the table loop actions, or the name of the active link guide referenced by the call guide.) from the Manual Workflow Objects page 117 kind regards Shafqat Ayaz Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh Uncontrollably, And Never Regret anything that made you Smile.. - Original Message From: Pargeter, Christie [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, February 19, 2008 12:06:23 PM Subject: Re: Interview questions ** What does `$ do? I didn't know about this one...use `! quite a bit. _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of john rosquist Sent: Tuesday, February 19, 2008 12:02 PM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** `! has become well used in interviews. So, what is the difference between `! and `$? When would you use one versus the other? John Rosquist Windward - Original Message From: John Atherly [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Tuesday, February 19, 2008 2:54:21 PM Subject: Re: Interview questions ** Is number 7 answer `! at the end of the filter name? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 Remedy Service Desk [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 02/19/2008 02:43 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Interview questions ** Hi Marc, These are really helpful to give direction for fresher or new person joining team like me, correct me if I am wrong. 1) ARSchema 2) With transaction(t) table and table schema id in associated in arschema table 3) Web Services , Remedy API, Email templates, Direct SQL, creating view and database trigger and database programming... depending on what suites to client and third party application 4) Creating failure over environments, database back - replication on vmware etc, 5) Big to answer I will update you on this next time, - user interface ,end user component - directly reachable to customers 6) Filter is server side component , depending on fire condition and qualification action will be perform on server. Actions are listed in if actions tab, submit, modify any valid ar server operation. Permission is not issue on filter etc. 7) I don't things so, not possible. 8) Not understanding question - reason I not aware of walking tables I will look in to AR Server advance guide for ar.conf related question, Please provide more question if you have? Thank you for your help. Regards Sunil On Feb 19, 2008 7:25 PM, Marc Simmons mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] wrote: ** 1. What is the primary table in the AR System data dictionary? 2. How does the AR System manage the data you see in Remedy Forms? 3. Without using DSO or EIE, what are your thoughts for providing a 'STANDARDIZED' methodology for interfacing/integrating with Remedy applications. This customer was actually looking to use C.I.M. or some other open standard solution to interface with Remedy maybe a good discussion for the list!!! 4. How do you trouble shoot AR System server outages to restore access to the system? 5. How does mid-tier work and where does it fit in the client server architecture? 6. Describe how filters work? They were actually looking how filters work in different phases... which led to the next question. 7. Can you force a filter to fire all actions in the first phase? 8. List all of the possible uses for guides. They were
Re: Filter logging in 7.1
Thank you Carey...I was beginning to think I was the only one that knew that you had to be EXPLICITLY listed as a memberI can't tell you how often I must change the server from 'Public' to something else because someone thinks you can set it to public and have everyone do itif you set it to Public, then you need to add public to your group list to be able to client side filter log...I have normally created a 'Logging' group and set the server to that group and then added those people to that group if I want them to be able to log...:) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Wednesday, February 20, 2008 6:07 PM To: arslist@ARSLIST.ORG Subject: Re: Filter logging in 7.1 v7.1 ... Login to the AR User tool as an Administrator. Navigate to the : AR System Administration Console ( from the Home Page Application List field) Then navigate to: -- System (from the Vertical Nav bar) -- General -- Server Information (Item) Then that opens the form AR System Administration: Server Information. On the Log Files (tab) the field 'Client-Side Logging Group:' value is the group that the user MUST be an explict member of. ( In versions prior to v7.1 this was in the admin tool. It is not there anymore.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. - Original Message From: Atul Vohra [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 2:17:02 PM Subject: Filter logging in 7.1 ** Hi All, I was trying to do AL and filter logging from 7.1 AR client - but did not log the filter calls. I was logged in as Demo and after further reading found that something has to be enabled on the server side. Can someone please clarify what has to be done so filter logging can be done from the client tool. Platform: ARS 7.1 on Solaris, Oracle 10g Thanks Atul ___ 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: Filter logging in 7.1
My issue here is I was logged in as Demo - why Demo should have problems with logging. - Original Message - From: LJ Longwing [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Subject: Re: Filter logging in 7.1 Date: Wed, 20 Feb 2008 18:40:15 -0700 Thank you Carey...I was beginning to think I was the only one that knew that you had to be EXPLICITLY listed as a memberI can't tell you how often I must change the server from 'Public' to something else because someone thinks you can set it to public and have everyone do itif you set it to Public, then you need to add public to your group list to be able to client side filter log...I have normally created a 'Logging' group and set the server to that group and then added those people to that group if I want them to be able to log...:) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Wednesday, February 20, 2008 6:07 PM To: arslist@ARSLIST.ORG Subject: Re: Filter logging in 7.1 v7.1 ... Login to the AR User tool as an Administrator. Navigate to the : AR System Administration Console ( from the Home Page Application List field) Then navigate to: -- System (from the Vertical Nav bar) -- General -- Server Information (Item) Then that opens the form AR System Administration: Server Information. On the Log Files (tab) the field 'Client-Side Logging Group:' value is the group that the user MUST be an explict member of. ( In versions prior to v7.1 this was in the admin tool. It is not there anymore.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. - Original Message From: Atul Vohra [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 2:17:02 PM Subject: Filter logging in 7.1 ** Hi All, I was trying to do AL and filter logging from 7.1 AR client - but did not log the filter calls. I was logged in as Demo and after further reading found that something has to be enabled on the server side. Can someone please clarify what has to be done so filter logging can be done from the client tool. Platform: ARS 7.1 on Solaris, Oracle 10g Thanks Atul ___ 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: Filter logging in 7.1
If the server is set to something other that Administrator, then Demo may not be an explicit member of that group. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Atul Vohra Sent: Wednesday, February 20, 2008 6:52 PM To: arslist@ARSLIST.ORG Subject: Re: Filter logging in 7.1 My issue here is I was logged in as Demo - why Demo should have problems with logging. - Original Message - From: LJ Longwing [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Subject: Re: Filter logging in 7.1 Date: Wed, 20 Feb 2008 18:40:15 -0700 Thank you Carey...I was beginning to think I was the only one that knew that you had to be EXPLICITLY listed as a memberI can't tell you how often I must change the server from 'Public' to something else because someone thinks you can set it to public and have everyone do itif you set it to Public, then you need to add public to your group list to be able to client side filter log...I have normally created a 'Logging' group and set the server to that group and then added those people to that group if I want them to be able to log...:) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Wednesday, February 20, 2008 6:07 PM To: arslist@ARSLIST.ORG Subject: Re: Filter logging in 7.1 v7.1 ... Login to the AR User tool as an Administrator. Navigate to the : AR System Administration Console ( from the Home Page Application List field) Then navigate to: -- System (from the Vertical Nav bar) -- General -- Server Information (Item) Then that opens the form AR System Administration: Server Information. On the Log Files (tab) the field 'Client-Side Logging Group:' value is the group that the user MUST be an explict member of. ( In versions prior to v7.1 this was in the admin tool. It is not there anymore.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. - Original Message From: Atul Vohra [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 2:17:02 PM Subject: Filter logging in 7.1 ** Hi All, I was trying to do AL and filter logging from 7.1 AR client - but did not log the filter calls. I was logged in as Demo and after further reading found that something has to be enabled on the server side. Can someone please clarify what has to be done so filter logging can be done from the client tool. Platform: ARS 7.1 on Solaris, Oracle 10g Thanks Atul __ __ ___ 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: Filter logging in 7.1
Something that would be nice to have is the ability to make a group a member of another group. Axton Grams On Wed, Feb 20, 2008 at 9:00 PM, LJ Longwing [EMAIL PROTECTED] wrote: If the server is set to something other that Administrator, then Demo may not be an explicit member of that group. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Atul Vohra Sent: Wednesday, February 20, 2008 6:52 PM To: arslist@ARSLIST.ORG Subject: Re: Filter logging in 7.1 My issue here is I was logged in as Demo - why Demo should have problems with logging. - Original Message - From: LJ Longwing [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Subject: Re: Filter logging in 7.1 Date: Wed, 20 Feb 2008 18:40:15 -0700 Thank you Carey...I was beginning to think I was the only one that knew that you had to be EXPLICITLY listed as a memberI can't tell you how often I must change the server from 'Public' to something else because someone thinks you can set it to public and have everyone do itif you set it to Public, then you need to add public to your group list to be able to client side filter log...I have normally created a 'Logging' group and set the server to that group and then added those people to that group if I want them to be able to log...:) -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Wednesday, February 20, 2008 6:07 PM To: arslist@ARSLIST.ORG Subject: Re: Filter logging in 7.1 v7.1 ... Login to the AR User tool as an Administrator. Navigate to the : AR System Administration Console ( from the Home Page Application List field) Then navigate to: -- System (from the Vertical Nav bar) -- General -- Server Information (Item) Then that opens the form AR System Administration: Server Information. On the Log Files (tab) the field 'Client-Side Logging Group:' value is the group that the user MUST be an explict member of. ( In versions prior to v7.1 this was in the admin tool. It is not there anymore.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. - Original Message From: Atul Vohra [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 2:17:02 PM Subject: Filter logging in 7.1 ** Hi All, I was trying to do AL and filter logging from 7.1 AR client - but did not log the filter calls. I was logged in as Demo and after further reading found that something has to be enabled on the server side. Can someone please clarify what has to be done so filter logging can be done from the client tool. Platform: ARS 7.1 on Solaris, Oracle 10g Thanks Atul __ __ ___ 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Old api
Does anyone have the *.lib files for the 5.1.2 windows c api? Thanks, Axton Grams ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Interview questions
To simulate the other, try setting your next id for any object to an already existing ID, and then try creating that object.. That's what happened at a customer site, I only have a guess as to how it MAY have happened, but no confirmation... If you do simulate it do not forget to set the Id back to what it should be.. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Wednesday, February 20, 2008 6:26 PM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** Me, either. I have seen that error occur when adding a unique index to a field containing data that violates it. Multiple NULL values are the most frequent culprit. Rick On Wed, Feb 20, 2008 at 2:33 PM, William Rentfrow [EMAIL PROTECTED] wrote: ** Wow - I've been working with Remedy for 8 years or so and I've never had the second one happen! The first one on the other hand.. From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: Wednesday, February 20, 2008 4:31 PM To: arslist@ARSLIST.ORG Subject: Re: Interview questions ** One of the questions I would ask is the error about violation of unique indexes. What do you do when you get this error. An experienced developer would know that this error can happen on both the user tool in case the system tries to create a duplicate record due to a conflict with the nextid in case it has been reset earlier OR can happen on the admin tool while creating new objects if there is a conflict with the containers ID that can happen sometimes due to data corruption for whatever reasons.. I'd be more interested in the later part of the answers as if that occurs its most likely an experienced developer who would know what got to be done next to get it working.. Joe - Original Message From: John Atherly [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, February 20, 2008 7:07:07 AM Subject: Re: Interview questions Why are manhole covers round? If any other shape they could fall in to the hole that they cover. Do I get the job? John Atherly American Power Conversion [EMAIL PROTECTED] 401-789-5735 Ext. 2120 1-800-788-2208 Ext. 2120 Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. __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___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.9/1290 - Release Date: 2/20/2008 8:45 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are