AW: Port issues with Netcool Gateway connecting to ARS 7.1
James, telnet my.arserver.com 9901 should work. You won't see any output, but the connection get's accepted by the arserverd process. Here's an example. This server listens on TCP-Port 4488 arad...@affhc041:/apps/javaprocs/mobis telnet itsm.telekom.de 4488 Trying 164.29.40.240... Connected to itsm.telekom.de. Escape character is '^]'. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von James Pifer Gesendet: Donnerstag, 19. März 2009 13:29 An: arslist@ARSLIST.ORG Betreff: Port issues with Netcool Gateway connecting to ARS 7.1 We just upgraded our server from Win32/ARS 6.x to Linux/ARS 7.1. We also use Netcool and I'm having trouble getting Netcool's Remedy Gateway to connect to the new server. Couple questions: We're running ARS on port 9901. Clients connect fine and I can see in a netstat -a that it's listening, but nmap from another machine does not see the port 9901 open. I assume it's a TCP port. No firewalls are enabled. Netcool support also wants me to telnet to the server using port 9901 and verify the credentials to login. I do not get a response trying to telnet to the port. Should this work? Any help is appreciated. Thanks, James ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: OT: Format IP Address
Roger, i would accomplish this with a set field SQL. SELECT LPAD(regexp_replace(ip,'(\d*)\.(\d*)\.(\d*)\.(\d*)','\1'),3,'0')||'.'|| LPAD(regexp_replace(ip,'(\d*)\.(\d*)\.(\d*)\.(\d*)','\2'),3,'0')||'.'|| LPAD(regexp_replace(ip,'(\d*)\.(\d*)\.(\d*)\.(\d*)','\3'),3,'0')||'.'|| LPAD(regexp_replace(ip,'(\d*)\.(\d*)\.(\d*)\.(\d*)','\4'),3,'0') FROM (SELECT '10.38.190.9' AS ip FROM dual) All you have to do is replace '10.38.190.9' with '$your_ip_field_name$' HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Nall, Roger Gesendet: Mittwoch, 18. März 2009 22:02 An: arslist@ARSLIST.ORG Betreff: Re: OT: Format IP Address Ravi, The idea is to do this as the data is being processed. We need to do this essentially after the user enters the IP address. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ravi Sent: Wednesday, March 18, 2009 3:58 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Format IP Address If you are looking to perform this for a large set of records, you could use ARS APIs (java or perl) to grab each record, modify the value within your script and update the record in Remedy. Nall, Roger wrote: ** All, ARS 7.01 p4 Oracle 10g Solaris 9 We have a request to format data that is stored in a character field. The data is standard IP addresses: xx.x.xx.xxx The idea is to make each octet three characters by padding zeros. So the previous example would look like: 0xx.00x.0xx.xxx. We are wondering if anyone has any suggestions for doing this when the data is stored in one field. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ -- Thank you, RaVi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: Application-Generate-GUID in a Filter
in Filters you don't need @@: IMHO it won't even work with @@: Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Eli Schilling Gesendet: Mittwoch, 11. März 2009 16:40 An: arslist@ARSLIST.ORG Betreff: Re: Application-Generate-GUID in a Filter ** $PROCESS$ @@ :Application-Generate-GUID From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Suwanski, Ron Sent: Wednesday, March 11, 2009 8:37 AM To: arslist@ARSLIST.ORG Subject: Application-Generate-GUID in a Filter Importance: High ** What is the correct context to use Application-Generate-GUID in a filter to generate an unique number for Set Field? Ron Suwanski Remedy Administrator / Developer DeVry Inc. One Tower Lane Oakbrook Terrace, IL 60181 p: 630.472.2209 f: 630.706.3446 e: rsuwan...@devry.com mailto:rsuwan...@devry.com www.devry.edu http://www.devry.com/ __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are image001.jpg
AW: Adding leading zeroes to Request ID
Rick, the attachments are stored in the database. In your case in table B97C61115. And this one you forgot to update. The path you're seeing in B97 is the original file location. HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Rick Westbrock Gesendet: Mittwoch, 11. März 2009 20:41 An: arslist@ARSLIST.ORG Betreff: Re: Adding leading zeroes to Request ID ** Thanks for the tip about the B table Conny; due to multiple form dependencies I ended up using the direct SQL method rather than rrrChive to update a total of six tables. I did run into a small issue with attachments (luckily there are only 18 records out of 100,000 that have an attachment). The attachments show up in the pool when the record is displayed, including the correct icon for the file type (e.g. Adobe icon for PDF files). However when I click to save or view an attachment I get an ARERR [556] Missing data in the SQL database: (B97C61115) error. I checked the DB and that field appears to be the full path plus file name at the time the file was attached to the record. For record number 097957 here's what the DB showed in the B97 table after updating the C1 column (and the request ID on the form) and which threw the error: 097957 \\emcdm2\groups\mis\remedy\Licensing and Maintenance\2009 Maintenance\SupportQuote186492-Basic.pdf 14355 8976 In the WUT I deleted the attached file and then added it back in and saved the request. Now I can display the attachment with no problem and this is what that same record in the B97 table: 097957 \\emcdm2\groups\MIS\Remedy\Licensing and Maintenance\2009 Maintenance\SupportQuote186492-Basic.pdf 14355 8976 The only difference is that one of the sub-directories is all lower-case before and all upper-case afterwards. Does anyone have an explanation of why that would cause a problem since I'm on MS SQL which is supposed to be case-insensitive. I was under the impression that attachments were stored in the database but the info above leads me to believe that it's actually just storing a pointer to the real location of the files; that would be a problem since most of the other attachments show a path on a D: drive. -Rick Single Remedy application server: Windows Server 2003 SP 2 IIS 6.0 ARS 7.0.1 patch 6 E-mail Engine 7.0.1 p6 Mid-Tier 7.0.1 p6 Tomcat 5.5 Remote Database Server: Windows Server 2003 SP 2 SQL Server 2000 (8.0.76 SP 3 Standard Edition) _ Rick Westbrock PETCO Telecom Engineer ri...@petco.com mailto:ri...@petco.com From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Conny Martin Sent: Wednesday, February 18, 2009 10:44 AM To: arslist@ARSLIST.ORG Subject: AW: Adding leading zeroes to Request ID ** ** If there are attachment fields on your form don't forget to update the B tables. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza Gesendet: Mittwoch, 18. Februar 2009 19:42 An: arslist@ARSLIST.ORG Betreff: Re: Adding leading zeroes to Request ID ** The key is you will need to know your system well. If you want to do what you want to, you will need to know the different relationships that form might have with other forms (such as association tables if you are using the OTB applications etc), where the Request ID is used in the relationships.. Off course you also will need to modify the corresponding entries in the H tables as well. It would be possible to write a SQL script to achieve what you want so long as you know your system well.. Joe From: Rick Westbrock ri...@petco.com To: arslist@ARSLIST.ORG Sent: Wednesday, February 18, 2009 11:05:26 AM Subject: Adding leading zeroes to Request ID ** I ran into a problem today on a form where some previous admin had set the Request ID field (1) to only five digits so after case number 9 was created the NextID value in the arschema table incremented to 10 but the form obviously couldn't create a case with that number so the agents were seeing error messages. My backup admin bumped the field length up to six digits so that agents could immediately start logging tickets again but I plan to increase the field length up to 10 or 15 digits. My question for everyone is what is the best practice to go back and zero-pad all of the existing tickets with five-digit Request ID numbers? It's not strictly necessary for operations but when search results come up defaulting to sort by Request ID these new six-digit request ID cases come up at the top of the list which is not intuitive at all for end users. I do have a dev server on which I will test whatever method I decide upon first and I can
AW: 7.1 mid-tier
Adrian, we were running this setup for about two years without any problems. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von adrian conway Gesendet: Sonntag, 1. März 2009 20:33 An: arslist@ARSLIST.ORG Betreff: 7.1 mid-tier ** Has anyone run the 7.1 mid-tier pointed to a 6.3 ARS server? If so what type of problems have you had with it? __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: How to save huge qual string in Table / Tree Property? RESOLVED
All, BMC has created a new defect ref for this issue. SW00324113 Kind Regards Conny Von: Martin, Conny Gesendet: Freitag, 13. Februar 2009 16:06 An: 'arslist@ARSLIST.ORG' Betreff: AW: How to save huge qual string in Table / Tree Property? RESOLVED Howard, I reported this to BMC. I'm waiting for response. I'll let you know the result. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Charles Baldi Gesendet: Freitag, 13. Februar 2009 16:04 An: arslist@ARSLIST.ORG Betreff: Re: How to save huge qual string in Table / Tree Property? RESOLVED ** Howard, As others on the thread have said, the 4k limit appears to be a database one. The 2k limit is a bug. Chuck On Fri, Feb 13, 2009 at 9:53 AM, Howard Richter hbr4...@gmail.com wrote: ** Chuck, Great news, bowever, is the size limit a bug with that patch or a new feature going forward? Howard On Fri, Feb 13, 2009 at 9:45 AM, Charles Baldi charles.ba...@gmail.com wrote: ** All, I was able to update the table query in question. Here is what I did: 1. Downgraded my Admin tool to 7.1 patch 3 (thanks Conny). This allows creation of qualification strings up to 4k (4096 chars). 2. Since the OOB qual was already at 4081 chars, I could barely add the EXTERNAL() before running out of room. So I took the OOB qual and removed a pile of the superfluous spaces that the Admin tool adds to the qual, such as those around the =, etc. This got the OOB qual down to 3727 chars. 3. Because I'm adding a half-dozen custom fields to the qual, the addition would still put it over the 4k limit, so I added another AND EXTERNAL(custom_do_field) and loaded my addition on Window Open. (thanks Scott and others). The real trick was to remove the extra spaces to make room. It is important to save a copy of the compressed qual for later because if you ever modify the table field, like to add a column, the Admin tool will barf again because it will have expanded the qual with the extra spaces again so that it exceeds the 4k limit. Saving a copy avoids having to remove all the spaces again. Thanks again, Chuck Baldi On Thu, Feb 12, 2009 at 9:22 AM, Charles Baldi charles.ba...@gmail.com wrote: Thanks for all the suggestions. I will see what I can get to work. FYI my Admin tool is at 7.1p4 while the ARServer is at 7.1p5. I will let you all know the result. Regards, Chuck Baldi On Thu, Feb 12, 2009 at 7:17 AM, Carey Matthew Black black@gmail.com wrote: However, you should also be warned that in at least a previous version (v5 or was it v6 era) there was a practical limit to the length of these qualifications. I was never clear if it was a RDBMS limitation or an ARS limitation, but I remember a number like 4000 characters as an upper limit to what actually works. Which was true even if you used the EXTERNAL() operator. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (BRSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Feb 11, 2009 at 6:45 PM, Scott Illari sill...@optonline.net wrote: ** Chuck, I would follow these steps 1) Create a hidden display only character field on the form. Just be sure the DB size of the field is 0 to hold the qualification if it ever grows.
AW: Cant Submit New Record Through View Form
John, ARS 7.x tries to increase the nextid until it finds one that works. ARS 6.3 throws an error. You must update arschema to generate a nextid that's not used in your view form update arschema set nextid = ? where name ='name of your view form' HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von J Kovalcik Gesendet: Dienstag, 24. Februar 2009 16:06 An: arslist@ARSLIST.ORG Betreff: Cant Submit New Record Through View Form ** Listers, I am trying to submit a new record through a view form on an 6.3 server MSSQL 2000 and it is not getting the next request id. It's trying to submit it with the starting id of 1 and it's already there. No workflow involved - just a simple save from the view form. When I duplicate it on my ARS 7.0 server MSSQL 2005, it works perfect. Any Ideas ? Thanks in advance ! John __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: 7.5 on Linux 64-bit?
Lyle, I can confirm that arserverd is a 64Bit executeable on linux arad...@affhc116:/apps/ars/ars750p0/bin file arserverd arserverd: ELF 64-bit LSB executable, AMD x86-64, version 1 (SYSV), for GNU/Linux 2.4.0, dynamically linked (uses shared libs), not stripped Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Lyle Taylor Gesendet: Dienstag, 24. Februar 2009 20:43 An: arslist@ARSLIST.ORG Betreff: 7.5 on Linux 64-bit? ** Hi all, So, we're getting ready to install AR 7.5 on Linux based on the understanding I had gotten from other posts on the list stating that it was 64-bit. I'm starting to question that understanding based on what I'm readying in the installation guide. First, the installation guide indicates that only the UNIX servers are 64-bit (and they don't group Linux with UNIX - it's considered separately). Then on page 50 under Installing AR System 64-bit servers, it says the following: On Linux and Windows, AR System is compiled on 32-bit platforms with compatible 32-bit database connectivity libraries. Consult your operating system and database vendors for information about compatibility support for 32-bit clients on 64-bit operating systems and how those 32-bit clients communicate to a local or remote 64-bit database. I saw the Linux: Expected 64-bit roadmap and interoperability with AR System PDF document that David Easter sent a link to, but that was from July 08, so I don't know if it still reflects reality. Can anyone confirm that the Linux AR Server (arserverd) actually is a 64-bit binary, or is it a 32-bit binary but BMC is only supporting it on 64-bit Linux servers for some reason? Thanks, Lyle Taylor NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: Error Consuming HP SM7.10 Webservice from out of BMC Remedy.
Robert, the admintool is trying to load the file http://www.w3.org/2005/05/xmlmime. Your machine running the admintool must have access to the internet either direct or via http-proxy. In case of http-proxy you have to set up your admintool to use the proxy(see attached screenshot). HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von robert.2.k...@continental-corporation.com Gesendet: Donnerstag, 19. Februar 2009 08:46 An: arslist@ARSLIST.ORG Betreff: Error Consuming HP SM7.10 Webservice from out of BMC Remedy. Dear list, We are trying to consume the Incident Management WebService from HP Service Manager 7.10 from within BMC Remedy. We are getting the below error message, when trying to load the wsdl in Remedy. Also attached the wsdl (I can load it fine in the browser though). Do you have any idea? I'm clueless. Maybe that WS is too complex for Remedy? Thanks in advance! Robert Remedy Server: 7.1.0 patch2 Midtier Version: 7.0.01 patch6 HP Service Manager 7.10 WSDL we use: http://RBGS36PA:13080/SM/7/IncidentManagement.wsdl === ERROR: WSDLException (at /definitions/types/xs:schema/xs:schema): faultCode=OTHER_ERROR: An error occurred trying to resolve schema referenced at 'http://www.w3.org/2005/05/xmlmime', relative to 'http://RBGS36PA.cw01.contiwan.com:13080/SM/7/Common.xsd'.: Connection timed out: connect Additional Details: Connection timed out: connect com.bmc.arsys.ws.util.ARWSException: WSDLException (at /definitions/types/xs:schema/xs:schema): faultCode=OTHER_ERROR: An error occurred trying to resolve schema referenced at 'http://www.w3.org/2005/05/xmlmime', relative to 'http://RBGS36PA.cw01.contiwan.com:13080/SM/7/Common.xsd'.: Connection timed out: connect at com.bmc.arsys.ws.wsdl.WsdlParser.init(WsdlParser.java:114) at com.bmc.arsys.ws.util.WsdlAdminInterface.parseWsdl(WsdlAdminInterface.java:406) at com.bmc.arsys.ws.util.WsdlAdminInterface.parseWSDLIntoMappingString(WsdlAdminInterface.java:213 === Mit freundlichen Grüßen/Best regards Robert Kern Corporate Infrastructure IT Operations - Service Integration - Service Desk IT CI OP SI SD Continental Automotive GmbH Sodener Strasse 9, 65824 Schwalbach, Germany Telefon/Phone: +49 6196872546 Telefax: +49 619 687792546 E-Mail: robert.2.k...@continental-corporation.com www.continental-corporation.com __ Continental Automotive GmbH, Siemensstr. 12, 93055 Regensburg, Germany Geschäftsführer/Managing Directors: Helmut Matschi, Gérard Cordonnier, Harald Stuhlmann Sitz der Gesellschaft/Registered office: Hannover Registergericht/Commercial registry: Hannover, HRB 59424, USt-Id. Nr. DE814950663 ___ Proprietary and confidential. Distribution only by express authority of Continental AG or its subsidiaries. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are attachment: scr.jpg
AW: Workflow objects not displaying in window
Dwayne, this is a common problem. Select Window-Cascade and all open objects will be arranged in the visible area of your Administrator-Window. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Dwayne Martin Gesendet: Mittwoch, 18. Februar 2009 17:26 An: arslist@ARSLIST.ORG Betreff: Workflow objects not displaying in window Dear List, I've been using the 7.1 p3 version of the client Admin tool for probably a year, but something strange has suddenly started happening. I try to display an Active Link or Filter, and it won't appear in the window. The Window menu lists it, but when I select it nothing happens. It appears to be displaying outside the window boundary. If I maximize (resize to fit window) any object that IS displaying, then all objects are maximized, including the ones that were off-screen, and I can work with them. But I can only see one at a time, which is unhandy. Two factors that may be related: 1. I have a dual monitor, but I've had it for years. 2. I am logged into my PC as User rather than Administrator. That just happened two weeks ago so it could have something to do with the problem. Any suggestions? (I know we need to upgrade to 7.5, but that doesn't fit into our schedule just now.) Dwayne Martin James Madison University (ARS 7.1 p3, RH Linux server, Oracle 10.2 db) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: Adding leading zeroes to Request ID
** If there are attachment fields on your form don't forget to update the B tables. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza Gesendet: Mittwoch, 18. Februar 2009 19:42 An: arslist@ARSLIST.ORG Betreff: Re: Adding leading zeroes to Request ID ** The key is you will need to know your system well. If you want to do what you want to, you will need to know the different relationships that form might have with other forms (such as association tables if you are using the OTB applications etc), where the Request ID is used in the relationships.. Off course you also will need to modify the corresponding entries in the H tables as well. It would be possible to write a SQL script to achieve what you want so long as you know your system well.. Joe From: Rick Westbrock ri...@petco.com To: arslist@ARSLIST.ORG Sent: Wednesday, February 18, 2009 11:05:26 AM Subject: Adding leading zeroes to Request ID ** I ran into a problem today on a form where some previous admin had set the Request ID field (1) to only five digits so after case number 9 was created the NextID value in the arschema table incremented to 10 but the form obviously couldn't create a case with that number so the agents were seeing error messages. My backup admin bumped the field length up to six digits so that agents could immediately start logging tickets again but I plan to increase the field length up to 10 or 15 digits. My question for everyone is what is the best practice to go back and zero-pad all of the existing tickets with five-digit Request ID numbers? It's not strictly necessary for operations but when search results come up defaulting to sort by Request ID these new six-digit request ID cases come up at the top of the list which is not intuitive at all for end users. I do have a dev server on which I will test whatever method I decide upon first and I can delete records if needed as part of testing. -Rick Single Remedy application server: Windows Server 2003 SP 2 IIS 6.0 ARS 7.0.1 patch 6 E-mail Engine 7.0.1 p6 Mid-Tier 7.0.1 p6 Tomcat 5.5 Remote Database Server: Windows Server 2003 SP 2 SQL Server 2000 (8.0.76 SP 3 Standard Edition) _ Rick Westbrock PETCO Telecom Engineer ri...@petco.com mailto:ri...@petco.com __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: How to save huge qual string in Table / Tree Property? RESOLVED
Howard, I reported this to BMC. I'm waiting for response. I'll let you know the result. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Charles Baldi Gesendet: Freitag, 13. Februar 2009 16:04 An: arslist@ARSLIST.ORG Betreff: Re: How to save huge qual string in Table / Tree Property? RESOLVED ** Howard, As others on the thread have said, the 4k limit appears to be a database one. The 2k limit is a bug. Chuck On Fri, Feb 13, 2009 at 9:53 AM, Howard Richter hbr4...@gmail.com wrote: ** Chuck, Great news, bowever, is the size limit a bug with that patch or a new feature going forward? Howard On Fri, Feb 13, 2009 at 9:45 AM, Charles Baldi charles.ba...@gmail.com wrote: ** All, I was able to update the table query in question. Here is what I did: 1. Downgraded my Admin tool to 7.1 patch 3 (thanks Conny). This allows creation of qualification strings up to 4k (4096 chars). 2. Since the OOB qual was already at 4081 chars, I could barely add the EXTERNAL() before running out of room. So I took the OOB qual and removed a pile of the superfluous spaces that the Admin tool adds to the qual, such as those around the =, etc. This got the OOB qual down to 3727 chars. 3. Because I'm adding a half-dozen custom fields to the qual, the addition would still put it over the 4k limit, so I added another AND EXTERNAL(custom_do_field) and loaded my addition on Window Open. (thanks Scott and others). The real trick was to remove the extra spaces to make room. It is important to save a copy of the compressed qual for later because if you ever modify the table field, like to add a column, the Admin tool will barf again because it will have expanded the qual with the extra spaces again so that it exceeds the 4k limit. Saving a copy avoids having to remove all the spaces again. Thanks again, Chuck Baldi On Thu, Feb 12, 2009 at 9:22 AM, Charles Baldi charles.ba...@gmail.com wrote: Thanks for all the suggestions. I will see what I can get to work. FYI my Admin tool is at 7.1p4 while the ARServer is at 7.1p5. I will let you all know the result. Regards, Chuck Baldi On Thu, Feb 12, 2009 at 7:17 AM, Carey Matthew Black black@gmail.com wrote: However, you should also be warned that in at least a previous version (v5 or was it v6 era) there was a practical limit to the length of these qualifications. I was never clear if it was a RDBMS limitation or an ARS limitation, but I remember a number like 4000 characters as an upper limit to what actually works. Which was true even if you used the EXTERNAL() operator. -- Carey Matthew Black BMC Remedy AR System Skilled Professional (BRSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On Wed, Feb 11, 2009 at 6:45 PM, Scott Illari sill...@optonline.net wrote: ** Chuck, I would follow these steps 1) Create a hidden display only character field on the form. Just be sure the DB size of the field is 0 to hold the qualification if it ever grows. 2) Update the table field so the qualification is EXTERNAL($Display Only Field$) 3) Have an Active Link set the display only field on
AW: How to save huge qual string in Table / Tree Property?
Hi Chuck, this seems to be a bug in the Admin Tool. We had the same problem, but with Admin Tool 7.1p3 you can put long qualification strings (2000 bytes) into the field. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Charles Baldi Gesendet: Mittwoch, 11. Februar 2009 23:30 An: arslist@ARSLIST.ORG Betreff: How to save huge qual string in Table / Tree Property? ** Hello all, I am trying to update the Table / Tree Property on the HPD:Incident Assoc Search form to let users search for some of their custom fields. However, the Qualification string is so large that the Admin tool will not let me add to it. I can't even re-paste the original qualification back into the field if I remove it. So, BMC must have a trick for pasting a HUGE qualification string here. Does anyone know how to do this? ARS 7.1 p5 ITSM 7.0.03 p8 Thanks in advance, Chuck Baldi __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: Problem Installing 7.5 Developer Studio
Mark, I've seen this while i tried to install 7.5 arserver on a linux box. The problem was related to NFS. The installer wasn't able to determine the correct size of a NFS-Mount. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Mark Keller Gesendet: Donnerstag, 5. Februar 2009 22:31 An: arslist@ARSLIST.ORG Betreff: Problem Installing 7.5 Developer Studio ** Hello. I'm trying to install the 7.5 developer studio. During the installation, the installer thinks that my drive has 0 free space. I have verified that I have admin rights to the machine and that there is indeed space available (about 30 gigs)... Has anyone seen this before? Any suggestions? Thanks! Mark __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: Related to ERROR Message --ARERR [306] Value does not fall within the limits specified for the field
Viswanathan, if you're on Version 7.1 but patchlevel 5 then you hit the following bug which is fixed in patch 5. SW00291689: ARERR 306 occurred frequently even when all the data and forms were correct, but it did not reoccur upon restarting the AR System server. HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Balakumar, Viswanathan Gesendet: Mittwoch, 4. Februar 2009 22:56 An: arslist@ARSLIST.ORG Betreff: Related to ERROR Message --ARERR [306] Value does not fall within the limits specified for the field ** ALL, We are getting the Menu Pattern error in all the forms where ever we have the Pattern match. Like ARERR [306] Value does not fall within the limits specified for the field : (MENU - $MENU$) : HPD:Help Desk : Assigned Support Company Not sure why suddenly this error is coming in all the forms. Did anybody experience something similar? Thanks, VB __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: Filter -- Push field If Qual failing due to Null values
try this ( $Disp Val$ = 'SS Disp Name' ) AND (( $Soft Version$ = 'SS Version' ) or (($Soft Version$ = $NULL$) and ('SS Version' = $NULL$))) Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Zenith Victory Gesendet: Dienstag, 3. Februar 2009 05:10 An: arslist@ARSLIST.ORG Betreff: Re: Filter -- Push field If Qual failing due to Null values ** Hello! Below is the actual push fields if qualification. No problems with the first part of the qualification and as it is a required field and values always exist. If the version is null then on both the target and source forms, then it is not able to find the existing entries. ( $Disp Val$ = 'SS Disp Name' ) AND ( $Soft Version$ = 'SS Version' ) Thanks! Vicky --- On Mon, 2/2/09, Rajeev t239...@gmail.com wrote: From: Rajeev t239...@gmail.com Subject: Re: Filter -- Push field If Qual failing due to Null values To: zenith_vi...@yahoo.com Date: Monday, February 2, 2009, 9:54 PM Hi Vicky, Have you tried comparing the field with the keyword $NULL$ ? If you dont mind, can you paste the qual and I am sure that someone if not me woudl respond with the modification that you would need in the qual. Having said that , what you need to add in your qualification is perhaps AND 'Field X' != $NULL$ Hope this helps. Regards Rajeev On Tue, Feb 3, 2009 at 8:47 AM, Zenith Victory zenith_vi...@yahoo.com http://us.mc01g.mail.yahoo.com/mc/compose?to=zenith_vi...@yahoo.com wrote: ** Hello! Need help with the following. Environment: ARS 6.3;Oracle;AIX;ITSM 5.5 Trying to create a new request(record) by a 'Push Fields' filter action in the target form, basing on the 'Push Fields If' qualification.If 'Field 1' valuein Source form 'A' is equal to 'Field X' value in Target form 'B' AND 'Field 2' value in Source form 'A' is equal to 'Field Y' value; then; 'If No Requests Match' -- Create a new request; 'If any requests match' -- Take no action. Above qualification is working fine as long as the value is not equal to null. We have recurring examples of where 'Field 2' and 'Field Y' are 'null' values. During which, the push field if qualification is not able to identify an existing record and thereby this filter is creating a new record everytime resulting duplicate records. I ran the corresponding query in the database. 'Field 1 = NULL is not returning any records. 'Field 1' IS NULL is returning the exact matching records.What is the Remedy syntax/qualification that I can use in the push field if qualification to achieve the 'IS NULL' result where it is idenfying the existing records with null values. Your assistance is appreciated. Thanks! Vicky __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: URGENT:CRITICAL:Authentication Failed error
it's not a big, but a time consuming task, to restore a backup (perhaps a couple hundred of GIB in size). Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Rakshit Bhandary Gesendet: Freitag, 30. Januar 2009 10:47 An: arslist@ARSLIST.ORG Betreff: Re: URGENT:CRITICAL:Authentication Failed error ** You can ask your DBA to regenerate the table from the back up.. shouldnt be a big task for a skilled DBA.. On Fri, Jan 30, 2009 at 3:04 PM, Sucharita SINGHAL sucharita.sing...@st.com wrote: Hello, We are facing a very critical error on logging in to remedy. It says authentication failed. Today moring we truncated user_cache table. Right Now user_cache has only 8 entries and only these users are able to login into remedy. How can we regenerate user_cache. Or is it because of something else? Even Demo is not able to login. Please suggest what can be done. If Possible give us a call at 0120-400-6247. Thanks Regards Sucharita Remedy Development Team ST Microelectronics Pvt.Ltd. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: URGENT:CRITICAL:Authentication Failed error
Hi Sucharita, to rebuild the user cache you can use arreload. It's located in /ar_install_path/bin arreload -a user_with_admin_rights -p password -f -u User if you don't have access with an admin user you can use arcache to create one. arcache -Ua -e001 -n Demo -lw 1 -g 1 this creates the user Demo with empty password. These examples are for ARS 7.1 Earlyer versions requieres an additional option -s localhost HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Sucharita SINGHAL Gesendet: Freitag, 30. Januar 2009 10:34 An: arslist@ARSLIST.ORG Betreff: URGENT:CRITICAL:Authentication Failed error Hello, We are facing a very critical error on logging in to remedy. It says authentication failed. Today moring we truncated user_cache table. Right Now user_cache has only 8 entries and only these users are able to login into remedy. How can we regenerate user_cache. Or is it because of something else? Even Demo is not able to login. Please suggest what can be done. If Possible give us a call at 0120-400-6247. Thanks Regards Sucharita Remedy Development Team ST Microelectronics Pvt.Ltd. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: possibility of Server group without load balancer?
You don't need a load balancer to use a server group. But you loose the ability to automatically distribute the workload evenly across your arservers and automatic failover from user's POV. Failover of Escalation, DSO etc. will work as this is a feature of the server group. You have to tell the half of your users to use server A and the other half to use server B, to distribute the workload. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von patchsk Gesendet: Donnerstag, 29. Januar 2009 08:51 An: arslist@ARSLIST.ORG Betreff: possibility of Server group without load balancer? We are planning to upgrade our arsystem form single server to a server group. I went through the white paper and the following question still remained as unclear Can someone give information on what is the role of a load balancer in a server group. Can we have a server group with out load balancer ? What we gain/loose with/without load balancer in a server group. Current: ARSystem 6.3, solaris,oracle, db on same box as arserver Upgrate: ARSystem7.1, solaris,oracle, two to four arservers, db on a remote box. Also is there anyone planning to use or any thoughts on AR7.5 in 64 bit, heared this new version can support 64bit. Our current arserverd crashing once the process reaches close to 4 gb ram. Thanks in Advance ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: $OPERATION$ = GET on Get Filter
GET is also defined in ar.h I created a simple Filter. Execute On = Get Entry 1. Action = Message(Note) $OPERATION$ Here is the result HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Joe DeSouza Gesendet: Mittwoch, 28. Januar 2009 08:09 An: arslist@ARSLIST.ORG Betreff: Re: $OPERATION$ = GET on Get Filter ** Thats not right.. QUERY is the correct keyword. Where did you read it was GET? Look at the ar.h header file and you will see QUERY is defined as the OPERATION keyword. Joe From: Amarjit Hothi azstr...@yahoo.com To: arslist@ARSLIST.ORG Sent: Tuesday, January 27, 2009 11:33:14 PM Subject: $OPERATION$ = GET on Get Filter No, Query does not work. Again, I want this to work on a Get Entry Filter, Query works on active links for form mode only. The AR 7.0 workflow objects doc says to use GET keyword on get entry filters. QUERY keyword is not supported in filters. Thanks. -Original Message- From: Scott Illari [mailto:sill...@optonline.net] Sent: January 26, 2009 1:51 PM Subject: No subject given Your qualification should read $OPERATION$ = QUERY...GET is not a valid value for the $OPERATION$ keyword. There are a list of valid values in the help section of your admin tool under the Keywords Section. Hope this helps. Scott Illari -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Amarjit Hothi Sent: Monday, January 26, 2009 1:48 PM To: arslist@ARSLIST.ORG Subject: I am trying to use an $OPERATION$ = GET on a get filter, the filter has a modify and get entry condition but each has a specific condition needs to be met, i.e.: the condition is (($OPERATION$ = GET) AND (some condition)) OR (($OPERATION$ = SET) AND (some other condition)) The $OPERATION$ = GET fails for unknown reasons on a get execution, I know this does not work because I set the filter to $OPERATION$ != SET and the get execution works. Can anyone tell me what I may be doing wrong in this instance? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org http://www.arslist.org/ Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are Outlook.jpg
AW: How to Create Web Service
Pintu, if you really wan't to know how to set up a web service you should read the document Integrating with Plug-ins and Third-Party Products (Integrating-710.pdf). There is a chapter Web Services explaining step by step how to create or consume a web service. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von pintu mallick Gesendet: Sonntag, 25. Januar 2009 09:42 An: arslist@ARSLIST.ORG Betreff: Re: How to Create Web Service ** Hi Rakshit, Ravi, Martin, Thanks a lot for all the information on web service. Let me explain my scenario in details, I can't allow Guest User Login. The external web page I have talked about earlier will be only for those users who don't have access to remedy. 1 So I have to create an external web service [.net or etc..] and consume it into a filter so once the external web service pass the data to ARS, filter will execute and create an incident record via HPD_Incident_Interface_Create form. 2 Other way out may be Use Remedy Web Service and Consume it into a filter. Both the cases I have to pass the data to Filter Via Web Service and I really want to know how to do it. I have created external web service user account on Mit-Tier. Please let me know if you need any specific information. Thanks Regards, Pintu. 2 --- On Sun, 1/25/09, Rakshit Bhandary rbhand...@gmail.com wrote: From: Rakshit Bhandary rbhand...@gmail.com Subject: Re: [ARSLIST] How to Create Web Service To: arslist@ARSLIST.ORG Date: Sunday, January 25, 2009, 1:38 PM ** For anything to with web on Remedy, you got to have Remedy Mid-Tier installed and integrated with your server. As one of our friends mentioned, you can give access to users to create records directly on the form itself. Since you mentioned that these users do not have login IDs to your server, you would have to follow the below steps to accomplish this. 1. First, allow Guest user login on the server. This can be done in the server settings on the Server Information window. 2. Go to your form, allow public submit permissions on the form as well as the fields. 3. So now when the user tries to login, he will be allowed into the server as a guest and he/she will be able to submit the record on your form. Regards, Rakshit On Sat, Jan 24, 2009 at 7:45 PM, Conny Martin conny.mar...@t-systems.com wrote: as far as I know you also need midtier to provide a webservice. Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Ravi Gesendet: Samstag, 24. Januar 2009 13:31 An: arslist@ARSLIST.ORG Betreff: Re: How to Create Web Service if you have mid tier installed, then you can access any form from the web. Take a look at Accessing forms and applications with URLs in Mid-Tier-X.pdf If you donot have mid tier installed, then build the webservice in Remedy like Rakshit mentioned, build some web page with code to access the webservice and submit requests. HTH pintu mallick wrote: ** Hi Rakshit Thanks for your quick response, let me explain my requirement. I want to develop a web page for external users who don't have user account in remedy so they can open the webpage and fill up the necessary inforamation like First Name, Last Name Email ID and Description field and once they submit this information one Incident Ticket will be created on Remedy. Please suggest me how to accomplish this task. Thanks Regards, Pintu --- On *Sat, 1/24/09, Rakshit Bhandary /rbhand...@gmail.com/* wrote: From: Rakshit Bhandary rbhand...@gmail.com Subject: Re: [ARSLIST] How to Create Web Service To: arslist@ARSLIST.ORG Date: Saturday, January 24, 2009, 12:47 PM ** Select the form on which you want to build the webservice. Right click on it. You will get the option for create web service. Which kind of webservice do you want to create? Regards
AW: How to Create Web Service
as far as I know you also need midtier to provide a webservice. Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Ravi Gesendet: Samstag, 24. Januar 2009 13:31 An: arslist@ARSLIST.ORG Betreff: Re: How to Create Web Service if you have mid tier installed, then you can access any form from the web. Take a look at Accessing forms and applications with URLs in Mid-Tier-X.pdf If you donot have mid tier installed, then build the webservice in Remedy like Rakshit mentioned, build some web page with code to access the webservice and submit requests. HTH pintu mallick wrote: ** Hi Rakshit Thanks for your quick response, let me explain my requirement. I want to develop a web page for external users who don't have user account in remedy so they can open the webpage and fill up the necessary inforamation like First Name, Last Name Email ID and Description field and once they submit this information one Incident Ticket will be created on Remedy. Please suggest me how to accomplish this task. Thanks Regards, Pintu --- On *Sat, 1/24/09, Rakshit Bhandary /rbhand...@gmail.com/* wrote: From: Rakshit Bhandary rbhand...@gmail.com Subject: Re: [ARSLIST] How to Create Web Service To: arslist@ARSLIST.ORG Date: Saturday, January 24, 2009, 12:47 PM ** Select the form on which you want to build the webservice. Right click on it. You will get the option for create web service. Which kind of webservice do you want to create? Regards Rakshit On Sat, Jan 24, 2009 at 8:28 AM, pintu mallick pintumall...@yahoo.com mailto:pintumall...@yahoo.com wrote: ** Hi All, How to create external webservice to create Incident Ticket in BMC Remedy. Please share your ideas. Thanks Regards. Thanks __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ -- Thank you, RaVi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: PERFORM-ACTION-ADD-ATTACHMENT that does not attach!
we have a similar workflow to add an Attachment and I ever wondered why they turned off philter-phasing for this filter. Now I know why. -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Misi Mladoniczky Gesendet: Mittwoch, 14. Januar 2009 11:51 An: arslist@ARSLIST.ORG Betreff: Re: PERFORM-ACTION-ADD-ATTACHMENT that does not attach! Hi, Try doing it in a Set-Fields action instead. The problem with Run Process is that it runs in the wrong Filter Phase. Set-Fields: CURRENT TRANSACTION dummyfield = $PROCESS$ PERFORM-ACTION-ADD-ATTACHMENT 103962 C:\FOTOS\$file_name$.jpg I have not tried it, but you may change the Filter Phase by adding `! to the end of the filter name (backquote+exclamationnmark). Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. Hi everyone,  ARS: 7.0.1 Patch04 OS: Windows 2003 server  Here is the command in the filter if action:  PERFORM-ACTION-ADD-ATTACHMENT 103962 C:\FOTOS\$file_name$.jpg  Here an extract from the filter log:   Checking CTM_Images_Load_Image FLTR TID: 000604 RPC ID: 188890 Queue: Fast     Client-RPC: 390620  USER: Demo                                                0: Process FLTR TID: 000604 RPC ID: 188890 Queue: Fast     Client-RPC: 390620  USER: Demo                                                      PERFORM-ACTION-ADD-ATTACHMENT 103962 C:\FOTOS\00109125.jpg FLTR TID: 000604 RPC ID: 188890 Queue: Fast     Client-RPC: 390620  USER: Demo                                        /* Wed Jan 14 2009 09:51:45.2560 */    End of filter processing (phase 3) on CTM_Images - 0008164  As you can see the server does not throw any error but the command does not work as no file is attached. Permissions are set correctly in the attachment pool and the attachment field. So I hope this is not a bug and may be something trivial!!  Have you had a similar problem before?  Thanks in advance frex __ _ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are -- This message was scanned by ESVA and is believed to be clean. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: Upgrade to 7.1 and licenses
I've recently done some upgrades from 6.3 to 7.1 7.1 stores licenses in the database instead of operating system files. With 7.1 comes some new forms bundled within a deployable application (AR System Administration Console). There is a form where you can manage your licenses. You must import the arsystem.lic file from your previous version using the new Add or Remove Licenses form. HTH Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Nall, Roger Gesendet: Mittwoch, 14. Januar 2009 19:28 An: arslist@ARSLIST.ORG Betreff: Upgrade to 7.1 and licenses Wichtigkeit: Hoch ** ARS 7.01 patch 4 Oracle 10g HPUnix When upgrading from 7.0.1 to 7.1 is it necessary to purge the licenses on the server before you begin the upgrade? If this is done, will the upgrade pick up the correct information for the all the licenses on the server? Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM __Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: Help with Set Fields action in a filter.
Hi Ravi, Set Fields Actions occur in phase 1. In this phase you don't have the request_id. It get's generated after phase 1. A possible solution is a Push-Field. Create a filter that fires on Submit. The only Action is a Push Field with qualification 'Request ID' = $Request ID$. In the mapping section set Another_Field = MS + $Request_ID$ (No Match = Error, Any match = Modify First) HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Ravi Gesendet: Sonntag, 11. Januar 2009 12:26 An: arslist@ARSLIST.ORG Betreff: Help with Set Fields action in a filter. Remedy 7.1 Hi: I have a filter with Execute On set to Submit. When the record is created, I want set another field in the record to MS + $Request ID$. I have an action in the If Action tab that is a Set Field which does that. The record always shows just MS for this field. Any ideas why the field does not get the request id value? -- Thank you, RaVi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: How to create many entries in Remedy form at a time from C# code?
This API-call would not help. The purpose of that call is to begin a transaction which you can commit or rollback, but new entry's must still be created with multiple calls to ARCreateEntry after you've called ARBeginBulkEntryTransaction. Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Carey Matthew Black Gesendet: Freitag, 9. Januar 2009 13:12 An: arslist@ARSLIST.ORG Betreff: Re: How to create many entries in Remedy form at a time from C# code? maggie2007, (or should I say d90uri ?) You did not mention what version of AR System API that your dealing with. And I am not sure what is or is not accessable from a C# perspective. However, in the v6.3 C API there is function that you may want to look at ARBeginBulkEntryTransaction. (Assuming that C# is anything like C++ where all C features and functions are available...) Sorry that I can not be of any more help than to just point you at that API call, but I do not write C, nor C#. So the function may or may not help you, but it sounds like what your after to me. Hope that helps. -- 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 Thu, Jan 8, 2009 at 4:52 PM, maggie2007 d90...@yahoo.com wrote: How to create many entries in Remedy form at a time from C# code? I need to create many entries in Remedy form which is on customer's Remedy server (note: I cannot use Remedy Administrator). Similar like SQL server bulk insert. Is there any such command or functions? If not, the only way is to loop for each entry, call Remedy C# API CreateEntry? I just worry that this will be slow. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: How to create many entries in Remedy form at a time from C# code?
Hallo Thilo, Das klingt interessant. Macht sich wahrscheinlich in Umgebungen mit hohen Latenzzeiten im Netz am meisten bemerkbar, da die Kommunaktion mit dem Server reduziert wird. Hast du das schon mal irgendwo eingesetzt? Gibt's das etwa schon im ARSPerl? :-) Mit freundlichen Grüßen Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Thilo Stapff Gesendet: Freitag, 9. Januar 2009 14:03 An: arslist@ARSLIST.ORG Betreff: Re: How to create many entries in Remedy form at a time from C# code? I can indeed confirm that using the BulkEntryTransaction mechanism increases performance, in a quite spectacular way, to say the least. You may expect your programs to run multiple times faster when using BulkEntryTranasaction. Thilo Carey Matthew Black wrote: Conny, I agree that the structure of your client program is not drastically changed by using this feature. I was commenting more on the performance part of the original question. To be clear, I am not doubting your understanding of this function. ( I have not had an opportunity to need to use it yet.) However, I was under the impression that performance would be a reason to use this feature. I would hope that the RDBMS might benefit the most from this approach by reducing it's needs to write to it's disk IO once instead of 1000's of times. Do you know if there is any performance gain by using ARBeginBulkEntryTransaction to commit multiple records in one communication to the AR Server vs not doing this? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: How to create many entries in Remedy form at a time from C# code?
With the Remedy Import Tool you can import a .csv file and this tool is included in Remedy ARS 6.3. There is also a command line version (arimportcmd) you can use for automated imports. HTH Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von maggie2007 Gesendet: Freitag, 9. Januar 2009 16:22 An: arslist@ARSLIST.ORG Betreff: Re: How to create many entries in Remedy form at a time from C# code? It is Remedy 6.3. in ARSystem.NET.chm, public void BeginBulkEntryTransaction(); Initiates a bulk entry transaction. Once this call is made - all subsequent create, delete, set, merge entry operations will be batched together and all of them will be issued only when a SendBulkEntryTransaction call is made. To cancel the bulk txn mode without sending the transaction request to server, CancelBulkEntryTransaction method should be used. BulkCreateEntryReturn is The result detail of one operation, specifically a CreateEntry operation, within a Bulk entry transaction. That seems that I still need to call CreateEntry for each record, didn't see the option to import from some .csv or .xml file for Bulk CreateEntry. Somebody told me that You can create the Bulk entries in the Remedy form, 1. Through AIE (Atrium Integration Engine) you can create as much entry as you want. but for that the CSV file should be prepared first. After that you can upload this manually or through intervals. 2. Thorugh AR Remedy Import Tool, but for this also you should have the CSV/ARX/RPT files ready to import on customers server. Probably this is the good way, but not sure if Atrium Integration Engine is included in Remedy 6.3 and the components are free? -- View this message in context: http://www.nabble.com/How-to-create-many-entries-in-Remedy-form-at-a-time-from-C--code--tp21361747p21374317.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
AW: Dynamic Group Updation
perhaps you've forgotten to put semicolons around the groupid The value in a dynamic group field should look like this ;1234; Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Vijayalakshmi Paulraj Gesendet: Donnerstag, 8. Januar 2009 10:44 An: arslist@ARSLIST.ORG Betreff: Dynamic Group Updation ** Hi All, We have a home grown helpdesk application with huge number of tickets. We are now introducing the dynamic group data restriction in the main helpdesk ticket form, since most of our customers require data restriction. We are introducing this at a very later stage, where we have already got millions of tickets. Can you please help us to find the best way of updating the Dynamic Group in the Tickets form for the existing tickets? We used a simple SQL update - but there is a disadvantage in that, the value is not getting recognised as a Remedy Group in the front end and it behaves as a simple number. Thanks Regards, Vijayalakshmi Paulraj This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. __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
AW: Application Query Delete Entry
If you're using this in an AL you must precede the command with @@: The AL runs on the client and try's to start an executable file named Application-Query-Delete-Entry. -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von ccrashh Gesendet: Donnerstag, 8. Januar 2009 12:53 An: arslist@ARSLIST.ORG Betreff: Re: Application Query Delete Entry Turn on SQL logging on as well. It is probably failing there, and this will tell you why. Also, I would try using a numeric value for the expression: 'chkBoxApplicationStatus' = 0 (or whatever the value is for Delete) Steve On Jan 8, 6:27 am, Kaushal Pandya kaushal.coold...@gmail.com wrote: Hi Friends, I am facing problem with 'Application-Query-Delete-Entry' process. I have written this action like this: Application-Query-Delete-Entry KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete to delete all the record for which 'chkBoxApplicationStatus' = Delete. while running on user tool its giving an error like: The system cannot find the file specified. and in log file it captures: ACTL 1: Run Process ACTL Application-Query-Delete-Entry KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete ACTL Process: Application-Query-Delete-Entry KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete ACTL Failed ACTL Return Code: 01 Any idea what could be the reason for this? Please help to resolve this issue. Thanks in advance, Kaushal. __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: 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
AW: Application Query Delete Entry
I think there is no problem with performance. The only API-Call which you'll see is an ARExecuteProcessForActivelink. From then on all is running within the server. -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von ccrashh Gesendet: Donnerstag, 8. Januar 2009 14:11 An: arslist@ARSLIST.ORG Betreff: Re: Application Query Delete Entry Huh...didn't even notice the Log stating ACTLjust assumed filters. The documentation flags Application-Query-Delete-Entry as Filter only, and not Active Links. Does the lack of a checkbox mean it will work but isn't supported? Or is this just another example of bad documentation? For the record, I think it is bad, performance-wise, to delete x number of records via client-side code. This should be invoked via a filter. Steve On Jan 8, 7:56 am, kush kaushal.coold...@gmail.com wrote: Hi friends, thanks for your help... @@ has solved my problem. Thanks folks for you help once again. - Kaushal. On Jan 8, 5:15 pm, Conny Martin conny.mar...@t-systems.com wrote: If you're using this in an AL you must precede the command with @@: The AL runs on the client and try's to start an executable file named Application-Query-Delete-Entry. -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von ccrashh Gesendet: Donnerstag, 8. Januar 2009 12:53 An: arsl...@arslist.org Betreff: Re: Application Query Delete Entry Turn on SQL logging on as well. It is probably failing there, and this will tell you why. Also, I would try using a numeric value for the expression: 'chkBoxApplicationStatus' = 0 (or whatever the value is for Delete) Steve On Jan 8, 6:27 am, Kaushal Pandya kaushal.coold...@gmail.com wrote: Hi Friends, I am facing problem with 'Application-Query-Delete-Entry' process. I have written this action like this: Application-Query-Delete-Entry KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete to delete all the record for which 'chkBoxApplicationStatus' = Delete. while running on user tool its giving an error like: The system cannot find the file specified. and in log file it captures: ACTL 1: Run Process ACTL Application-Query-Delete-Entry KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete ACTL Process: Application-Query-Delete-Entry KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete ACTL Failed ACTL Return Code: 01 Any idea what could be the reason for this? Please help to resolve this issue. Thanks in advance, Kaushal. __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinumSponsor:www.rmsportal.comARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist:Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: 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
AW: Application Query Delete Entry
If you're using Run Process regardless if filter or AL, it's always fire and forget. The process is started and the workflow isn't waiting for any response. If you're doing a Set-Field $PROCESS$, the workflow will wait for a response. Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von ccrashh Gesendet: Donnerstag, 8. Januar 2009 14:53 An: arslist@ARSLIST.ORG Betreff: Re: Application Query Delete Entry But won't this process, because it is initiated from the client-end, force the client to wait until the whole thing is completed? Or will the API-Call just trigger and then return as a completed process to the client? I don't use client-side Run Processes much, so haven't explored their impact. I could test this, but am lazy :) Steve On Jan 8, 8:16 am, Conny Martin conny.mar...@t-systems.com wrote: I think there is no problem with performance. The only API-Call which you'll see is an ARExecuteProcessForActivelink. From then on all is running within the server. -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von ccrashh Gesendet: Donnerstag, 8. Januar 2009 14:11 An: arsl...@arslist.org Betreff: Re: Application Query Delete Entry Huh...didn't even notice the Log stating ACTLjust assumed filters. The documentation flags Application-Query-Delete-Entry as Filter only, and not Active Links. Does the lack of a checkbox mean it will work but isn't supported? Or is this just another example of bad documentation? For the record, I think it is bad, performance-wise, to delete x number of records via client-side code. This should be invoked via a filter. Steve On Jan 8, 7:56 am, kush kaushal.coold...@gmail.com wrote: Hi friends, thanks for your help... @@ has solved my problem. Thanks folks for you help once again. - Kaushal. On Jan 8, 5:15 pm, Conny Martin conny.mar...@t-systems.com wrote: If you're using this in an AL you must precede the command with @@: The AL runs on the client and try's to start an executable file named Application-Query-Delete-Entry. -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von ccrashh Gesendet: Donnerstag, 8. Januar 2009 12:53 An: arsl...@arslist.org Betreff: Re: Application Query Delete Entry Turn on SQL logging on as well. It is probably failing there, and this will tell you why. Also, I would try using a numeric value for the expression: 'chkBoxApplicationStatus' = 0 (or whatever the value is for Delete) Steve On Jan 8, 6:27 am, Kaushal Pandya kaushal.coold...@gmail.com wrote: Hi Friends, I am facing problem with 'Application-Query-Delete-Entry' process. I have written this action like this: Application-Query-Delete-Entry KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete to delete all the record for which 'chkBoxApplicationStatus' = Delete. while running on user tool its giving an error like: The system cannot find the file specified. and in log file it captures: ACTL 1: Run Process ACTL Application-Query-Delete-Entry KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete ACTL Process: Application-Query-Delete-Entry KP_UserApplicationForm 'chkBoxApplicationStatus' = Delete ACTL Failed ACTL Return Code: 01 Any idea what could be the reason for this? Please help to resolve this issue. Thanks in advance, Kaushal. __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum Sponsor:www.rmsportal.comARSlist:Where the Answers Are __ __ ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinumSponsor:www.rmsportal.comARSlist:Where the Answers Are __ __ ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum Sponsor:www.rmsportal.comARSlist:Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist:Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgPlatinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are __ _ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum
AW: Malloc failed on server CreateMultipleFields
Perhaps a bug which is fixed in patch 6 SW00304771 CreateMultipleFields failed on AR System server 7.1 on a form that had auditing enabled. Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von bruce sisk Gesendet: Montag, 5. Januar 2009 18:15 An: arslist@ARSLIST.ORG Betreff: Malloc failed on server CreateMultipleFields I am receiving this error when trying to migrate an existing form with several new fields. This is a brand new installation of ars 7.1.0 patch 5 with itsm 7.0.3 patch 8. It is a windows 2003 server connecting to a remote Oracle 10.2.0.3.0 - 64bi configured in a RAC. If I try to manually copy and paste multiple fields to the form via the admin tool...I get an Unable to save form box. If I click OK...and resave...I will get the Unable to Save box for each new field being added...then it will save normally. I have never encountered this before...anybody else seen this?? Any ideas?? Bruce Sisk BFS Enterprises PeoplePC Online A better way to Internet http://www.peoplepc.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
AW: how to use Application-Format-Qual-ID
this special run process wouldn't help you. Documentation says: Converts an internal representation of a qualifier into a qualification string using ID format. It deals with qualifiers not request_id formats. What about setting the Default-Value of the request_id field to some stringYEAR ? You have to adjust this every year, but it's simple. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Remedy Maniac Gesendet: Dienstag, 23. Dezember 2008 14:00 An: arslist@ARSLIST.ORG Betreff: how to use Application-Format-Qual-ID ** Dear listers, some of my users would like to have a fancy Request_ID in the following format: some stringYEARId number in 4 digits After many unsuccesfull attempts, I believe the Process Application-Format-Qual-ID could help The problem is I don't get it work. Could somebody give a hint on how to use this Process? Or simpler, if anybody has a better idea, please share. Thanks Serouche __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
AW: AW: how to use Application-Format-Qual-ID
. Conny Martin wrote: ** this special run process wouldn't help you. Documentation says: Converts an internal representation of a qualifier into a qualification string using ID format. It deals with qualifiers not request_id formats. What about setting the Default-Value of the request_id field to some stringYEAR ? You have to adjust this every year, but it's simple. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Remedy Maniac Gesendet: Dienstag, 23. Dezember 2008 14:00 An: arslist@ARSLIST.ORG Betreff: how to use Application-Format-Qual-ID ** Dear listers, some of my users would like to have a fancy Request_ID in the following format: some stringYEARId number in 4 digits After many unsuccesfull attempts, I believe the Process Application-Format-Qual-ID could help The problem is I don't get it work. Could somebody give a hint on how to use this Process? Or simpler, if anybody has a better idea, please share. Thanks Serouche __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
AW: Linux and VMware ESX
Hi Anne, we're running ARS 6.3 und 7.1 on VMWare ESX and SLES 9 (Oracle 10.2.0.4). No Problems. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Ramey, Anne Gesendet: Dienstag, 23. Dezember 2008 15:06 An: arslist@ARSLIST.ORG Betreff: Linux and VMware ESX ** There doesn't seem to be anything recent on the list. Has anyone had experience with ESX VMware and Red Hat 4 for 7.0.03/7.0.01? Problems? Tips? Anne Ramey E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. __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
AW: AW: how to use Application-Format-Qual-ID
meta data that represents run if qualification into what you see in the Admin too and vice versa. Dynamically changing prefixes of Request ID's can be done provided you recache the definition immediately after triggering the change in the default value of the prefix. You can do this using the arsignal command with the -g switch. Having to recache the definitions obviously mean you cannot do it too often (like every 5 minutes) because it would hammer your performance.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Remedy Maniac Sent: Tuesday, December 23, 2008 8:15 AM To: arslist@ARSLIST.ORG Subject: Re: AW: how to use Application-Format-Qual-ID ** I just tried your idea. I get the following: Next available ID produces an Entry ID that overflows Entry ID field -- contact the Administrator (ARERR 305) This is probably because we already have 8000 rows in the form. The idea is to have every year some stringYEAR0001, some stringYEAR0002,some stringYEAR0003,some stringYEAR0004, ... So right now what I do is every year after the first ticket is created I export the row in a arx format. I manually make the change. Then import with the import tool. And this way the next id gets the right format. And we are safe for the rest of the year. But I'd like to have this self-service by Remedy itself. I am starting to doubt in the power of this tool. So it has at least one limitation. Conny Martin wrote: ** this special run process wouldn't help you. Documentation says: Converts an internal representation of a qualifier into a qualification string using ID format. It deals with qualifiers not request_id formats. What about setting the Default-Value of the request_id field to some stringYEAR ? You have to adjust this every year, but it's simple. Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Remedy Maniac Gesendet: Dienstag, 23. Dezember 2008 14:00 An: arslist@ARSLIST.ORG Betreff: how to use Application-Format-Qual-ID ** Dear listers, some of my users would like to have a fancy Request_ID in the following format: some stringYEARId number in 4 digits After many unsuccesfull attempts, I believe the Process Application-Format-Qual-ID could help The problem is I don't get it work. Could somebody give a hint on how to use this Process? Or simpler, if anybody has a better idea, please share. Thanks Serouche __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
AW: email engine logging
Hi Anne, look at page 194 and following in document Administering BMC Remedy Email Engine Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Ramey, Anne Gesendet: Dienstag, 23. Dezember 2008 15:33 An: arslist@ARSLIST.ORG Betreff: email engine logging ** Does anyone know of any way to turn on logging for the email engine so you can actually track/see the transactions, both IMAP and SMTP? Not just the errors, but the transactions that are successful as well? Anne Ramey E-mail correspondence to and from this address may be subject to the North Carolina Public Records Law and may be disclosed to third parties only by an authorized State Official. __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
AW: AW: how to use Application-Format-Qual-ID
Hi Serouche, what about a cron job doing this every year on 31th of December? Kind Regards Conny Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Remedy Maniac Gesendet: Dienstag, 23. Dezember 2008 16:03 An: arslist@ARSLIST.ORG Betreff: Re: AW: how to use Application-Format-Qual-ID ** Many thanks to Conny for the workaround. But I am afraid that won't help. Because I still need the tickets created for this year until 31 Dec 2008 as the actual format. Maybe I can somehow schedule this. But I am not sure whether that's a best way to deal with the problem. And on top of that every year I need to redo the manip. Also changing by hand the 2009 for 2010 But at least the trick is a great start point for me to get more familiar with the Data Dictionary. Probably I'll find my way out of this puzzle. However please do not hesitate of you have a better idea. Or more tips Many thanks Serouche Joe D'Souza wrote: ** Martin just explained what has to be done.. and he pointed out the right table. I thought it was the field_dispprop that had the column defaultvalue. Sorry for pointing out the wrong table name but I wasn't in front of a AR Server database to verify my notes to you.. Cheers Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Conny Martin Sent: Tuesday, December 23, 2008 9:38 AM To: arslist@ARSLIST.ORG Subject: AW: AW: how to use Application-Format-Qual-ID ** Serouche, following should do the trick update arschema set nextid = 1 where name = 'your form name' update field set defaultvalue = 'some string2009' where fieldid = 1 and schemaid = (select schemaid from arschema where name = 'your form name') after that you have to issue arsignal -g your_server_name This causes the arserver to recache all the form and field definitions from the database. Kind Regards Conny PS: you should test this procedure before using it on a production box Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Remedy Maniac Gesendet: Dienstag, 23. Dezember 2008 15:33 An: arslist@ARSLIST.ORG Betreff: Re: AW: how to use Application-Format-Qual-ID ** right now the Request_ID of my form has a default set to some string The ID's are at the moment in the following format: some string20080370, some string20080371, some string20080372, some string20080373, ... Let say the last ID of December 2008 will be some string20080380 Then the first ID of 2009 will be some string20090381 I'd like to avoid this. I'd like to have some string20090001 for the first ID of 2009 So thank you for the arsignal but again I don't see how I should use it. Direct SQL to update the field_dispprop table ? Is that what you meant? With a Run Process for arsignal at some time? Before or after the Direct SQL? Could you tell me more? Thanks Serouche Joe D'Souza wrote: ** Would you be a little more specific as to what you mean by saying 'flip my Request_ID' ? I have so far understood you need to change the prefix. That can be done with a Direct SQL to the database table field_dispprop to change the default for that schemaid. Joe -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of Remedy Maniac Sent: Tuesday, December 23, 2008 9:20 AM To: arslist@ARSLIST.ORG Subject: Re: AW: how to use Application-Format-Qual-ID ** Joe, many thanks for your tips. However, I still do not see how to built something to flip my Request_ID I created 2 triggers to update my T and H tables
AW: New Discovery -- Shared Workflow can possibly cause performance degradation
if I'm not wrong there is a patch correcting this issue. 7.1 p 4 SW00295427 Performance issues occurred with BMC Remedy User after upgrading to version 7.0.01 patch 005. Note: The actual Server Name and Schema Name were replaced in the cache so that BMC Remedy User would not send requests to the AR System server for each field. Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Garrison, Sean (Norcross) Gesendet: Dienstag, 23. Dezember 2008 17:23 An: arslist@ARSLIST.ORG Betreff: New Discovery -- Shared Workflow can possibly cause performance degradation ** Just an fyi, I just discovered an issue in performance in Remedy. I have an active link that does a set fields to a dialog box on 'Instance id' = $Instance id$ that is shared among several forms. I am using the Advanced feature in the active link for the set fields and setting the server name = $SERVER$ and the form name = $SCHEMA$. I am then doing a set fields for Matching Ids. What I noticed is that the API does a ARGetListEntry for every single field in the Schema to set the fields in the dialog which in turn will call all filters for Get Entry for every single field you have on the form. I found that it is faster to create a single active link for each form which will in turn only call the Get Entry filters once and will only retrieve all fields for the record once. The shared workflow still works so I feel bad calling it an issue but based on what I saw it would slow performance considerably. In my case removing the shared workflow shaved off 2.5 seconds off the load time of the form. Thanks, Sean Log examples (for the first 3 fields of a form):(Please forgive me ... I had to edit the log file to get it less than 1000 characters ) Using Shared Workflow: ACTL 0: Set Fields API /* Tue Dec 23 2008 10:42:44.8419 */+GLSF ARGetListField -- schema CKFR:DM:PRD:PurchasedProduct API /* Tue Dec 23 2008 10:42:44.8423 */-GLSF OK API /* Tue Dec 23 2008 10:42:44.8483 */+GLSF ARGetListField -- schema CKFR:DM:PRD:PurchasedProduct changed since Wed Dec 31 19:00:00 1969 API /* Tue Dec 23 2008 10:42:44.8485 */-GLSF OK API /* Tue Dec 23 2008 10:42:44.8582 */+GLEARGetListEntry -- schema CKFR:DM:PRD:PurchasedProduct API /* Tue Dec 23 2008 10:42:44.8604 */-GLE OK API /* Tue Dec 23 2008 10:42:44.8683 */+GE ARGetEntry -- schema CKFR:DM:PRD:PurchasedProduct entryId 141 FLTR /* Tue Dec 23 2008 10:42:44.8694 */Start filter processing -- Operation - GET FLTR CKFR:DM:PRD:PurchasedProduct - 141 FLTR Checking CKFR:DM:PRD:PurchasedProduct-on_GetEntry-SetContractedThrough-001 (500) FLTR -- Failed qualification FLTR /* Tue Dec 23 2008 10:42:44.8760 */ End of filter processing (phase 1) FLTR /* Tue Dec 23 2008 10:42:44.8760 */ Restart of filter processing (phase 3) FLTR /* Tue Dec 23 2008 10:42:44.8760 */Stop filter processing API /* Tue Dec 23 2008 10:42:44.8762 */-GE OK ACTL Request ID (1) = 141 API /* Tue Dec 23 2008 10:42:44.8797 */+GLEARGetListEntry -- schema CKFR:DM:PRD:PurchasedProduct API /* Tue Dec 23 2008 10:42:44.8819 */-GLE OK API /* Tue Dec 23 2008 10:42:44.8882 */+GE ARGetEntry -- schema CKFR:DM:PRD:PurchasedProduct entryId 141 FLTR /* Tue Dec 23 2008 10:42:44.8895 */Start filter processing -- Operation - GET FLTR CKFR:DM:PRD:PurchasedProduct - 141 FLTR Checking CKFR:DM:PRD:PurchasedProduct-on_GetEntry-SetContractedThrough-001 (500) FLTR -- Failed qualification FLTR /* Tue Dec 23 2008 10:42:44.8955 */ End of filter processing (phase 1) FLTR /* Tue Dec 23 2008 10:42:44.8955 */ Restart of filter processing (phase 3) FLTR /* Tue Dec 23 2008 10:42:44.8955 */Stop filter processing API /* Tue Dec 23 2008 10:42:44.8957 */-GE OK ACTL Submitter (2) = adunn API /* Tue Dec 23 2008 10:42:44.8992 */+GLEARGetListEntry -- schema CKFR:DM:PRD:PurchasedProduct API /* Tue Dec 23 2008 10:42:44.9014 */-GLE OK API /* Tue Dec 23 2008 10:42:44.9083 */+GE ARGetEntry -- schema CKFR:DM:PRD:PurchasedProduct entryId 141 FLTR /* Tue Dec 23 2008 10:42:44.9097 */Start filter processing -- Operation - GET FLTR CKFR:DM:PRD:PurchasedProduct - 141 FLTR Checking CKFR:DM:PRD:PurchasedProduct-on_GetEntry-SetContractedThrough-001 (500) FLTR -- Failed qualification FLTR /* Tue Dec 23 2008 10:42:44.9156 */ End of filter processing (phase 1) FLTR /* Tue Dec 23 2008 10:42:44.9156 */ Restart of filter processing (phase 3) FLTR /* Tue Dec 23 2008 10:42:44.9156 */Stop filter processing API /* Tue Dec 23 2008 10:42:44.9158 */-GE OK ACTL Create Date (3) = Friday, June 01, 2007 11:32:34 AM Using Regular Workflow
AW: SQL statement error
You must write Select max(po_number) + 1 FROM AST_PurchaseOrder Then you can map PO Number = $1$ -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Muhlethaler, Laurie Gesendet: Mittwoch, 17. Dezember 2008 20:29 An: arslist@ARSLIST.ORG Betreff: Re: SQL statement error I'm not sure I understand. I want to auto-populate the PO Number field with the next available PO #. I would like to accomplish this through direct SQL rather than creating an additional field(s) and workflow? Laurie Muhlethaler Remedy Developer / Administrator On Wed, 17 Dec 2008 13:15:41 -0600, Kaiser, Norm E CIV USAF AFMC 96 CS/SCCE norm.kai...@eglin.af.mil wrote: Looks like $PO Number$ is a field reference and Remedy is passing the contents of PO Number (not the field name) to SQL, which is likely NULL because the field is empty when you run this. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Muhlethaler, Laurie Sent: Wednesday, December 17, 2008 1:11 PM To: arslist@ARSLIST.ORG Subject: SQL statement error ** Listers ~ I am getting the following error during a SQL set fields action: ARERR [552] Failure during SQL operation to the database : The max function requires 1 argument(s). (SQL Server 174) My SQL command is listed below and I can successfully run it from SQL Server: SELECT max($PO Number$) + 1 FROM AST_PurchaseOrder What am I doing wrong here? Thank you in advance. Windows Server 2003 SQL Server 2005 7.1.00 Patch 002 AR Server 7.0.03 Patch 006 Service Desk Asset Management CMDB - 2.1.00 Patch 002 DSL - 1.0.00 Patch 1516 Laurie Muhlethaler First Republic Bank Remedy Developer / Administrator 415.364.4436 [First Republic Bank logo]http://logos.firstrepublic.com/FRB.jpg The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This message cannot be guaranteed to be secure or error-free. First Republic Bank and its related entities do not take responsibility for, or accept time-sensitive instructions sent by email including orders, funds transfer instructions or stop payments on checks. All instructions of this nature must be handled by direct communication, not email. We reserve the right to monitor and review the content of all email communications sent or received. Emails sent to or from this address may be stored in accordance with regulatory requirements. First Republic Bank is a Division of Merrill Lynch Bank Trust Co., FSB __Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are === = -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. This message cannot be guaranteed to be secure or error-free. First Republic Bank and its related entities do not take responsibility for, or accept time-sensitive instructions sent by email including orders, funds transfer instructions or stop payments on checks. All instructions of this nature must be handled by direct communication, not email. We reserve the right to monitor and review the content of all email communications sent or received. Emails sent to or from this address may be stored in accordance with regulatory requirements. First Republic Bank is a Division of Merrill Lynch Bank Trust Co., FSB ___ 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
AW: please help
You must use the Group form. There is a field Group Definition. If you wan't to add two users you must write: 'User1' or 'User2' If you enclose an identifier in single qoutes it is treated as User, if you enclose it in double quotes it's treated as Group. Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von arsadm Gesendet: Mittwoch, 17. Dezember 2008 20:24 An: arslist@ARSLIST.ORG Betreff: Re: please help Thanks a lot for your quick response. I've one more doubt on this ,If the group is dynamic through User form i cannot assign users to it. So which form i've to use for assigning users to a dynamic group. Thanks, ARSADM LJ LongWing (Head) wrote: You don't. not directly. You find out what groups comprise the computation, and if they are a member of what computes as a member of it, then they are set as a member of that group. _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of arsadm Sent: Wednesday, December 17, 2008 10:45 AM To: arslist@ARSLIST.ORG Subject: please help ** Hi Group, how can i assign a user to a computed group list (special permission group) ? Thanks in advance. ARSADM _ View this message in context: please http://www.nabble.com/please-help-tp21057857p21057857.html help Sent from the ARS http://www.nabble.com/ARS-%28Action-Request-System%29-f716.html (Action Request System) mailing list archive at Nabble.com. __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 -- View this message in context: http://www.nabble.com/please-help-tp21057857p21059608.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
AW: Starting Request ID at a higher number
Update arschema set nextid = 1000 where name = 'Name of your form' -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Timothy Rondeau Gesendet: Mittwoch, 17. Dezember 2008 15:10 An: arslist@ARSLIST.ORG Betreff: Starting Request ID at a higher number Hi, Hoping someone can refresh my memory. I want to start a new form at a higher request ID than 1. So say 1000, I know there is a command to do this. We are on Windows 2003, SQL 2000. ars 7.0.1 Thanks Tim ___ 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