Check to make sure Char field doesn't contain a Percent sign (%)
I know you can do a Run If with LIKE %[a-z]% to check for the existence of alpha characters from a to z in a field. However, how can you check to see if a char field contains a % sign? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Check to make sure Char field doesn't contain a Percent sign (%)
Sigh...nevermind. Answered my own question: use %[%]% ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Need help for upgrading ARS( Custom build code ) 5.x to 7.x
First, you should go to 6.x then 7.x. If you use the email engine, good luck :) Also, be aware that system fields like Submitter and Last Modified By changed in length (so if you had them in a certain layout, all of a sudden the expand box will appear and might overlap the field to it's right). We had that happen on a whole bunch of forms. I think we download some tool to run through all the forms and set the Expand Box option on those fields to Hide. On Jul 13, 8:12 am, cyberhut iamfo...@gmail.com wrote: Hi All, Can anyone provide me the details with steps on how to upgrade remedy ARS from 5.x to 7.x. The task is to upgrade with data , interfaces. And also suggest me whether i should upgrade first to 6.x and then to 7.x. Thanks in advance, -- View this message in context:http://www.nabble.com/Need-help-for-upgrading-ARS%28-Custom-build-cod... Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: Close Window
Well...I would have code on the table double-click (that is, remove the table's usual Table Drill Down check and capture the Table Double- Click in an active link). On this active link, I would do an Open Window (Modify, though I would normally use a Dialog and have a Save button or some such). Then, on the same active link I would pass an Event to the Child window (the one you just opened in Modify mode). On the child window, have an AL that triggers on the event to set, say, a flag field that says Close on Modify - I assume you meant After Modify in your question, since you mentioned opening Assigned Tickets from a table - the AL to Close Window would have that flag as a Run If qualification. That way, only if the Modify form is opened via a double-click on a table field will you cause the Close Window action On Modify. Hope that helps. Steve On Jul 9, 10:48 am, Brittain, Mark mbritt...@navisite.com wrote: Hi All, Not sure if I can do this one but thought I would ask. I want to do a close window After Submit but only if a record is displayed as itself without a list (e.g. Display Type = Detail Only). Typically users find their assigned tickets using a table field on a display only form. They display the ticket by double clicking on a ticket. The above action works fine in this case. However if they did a search of tickets, getting a list (split window), when they save the ticket, the whole list closes. Is there a qualification that says execute if the window is display only? Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.commailto:mbritt...@navisite.com (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visitwww.NaviSite.comToday. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: Where the Answers Are
Re: ITSM naming convention sucks
Out of curiousity...what do you do if the code triggers on more than one action?: CC_NIM:Btn_OpenIncidentTask-MRC_Somefield-000-OpenHelpDesk Like that? On Mar 24, 5:56 am, Coleman, Gavin gavin.cole...@computacenter.com wrote: In my opinion, ITSP followed some best naming conventions. Well considering that as far as know the naming convention is not explained anywhere in the ITSP or ITSM documentation, I can't see how you can believe that. Remedy allows you up to 80 characters to name workflow items, and it seems that ITSP and ITSM does not use all of these characters. My Active Link workflow has a naming convention as follows 1. Prefix for custom work (CC_) 2. Form abbreviation (NIM:) - New Incident Console 3. Execute on abbreviation (MRC - Menu Row Choice, Btn - Button, WL - Window Loaded). If more than one Execute on is specified, then the abbreviation I use is the most relevant 4. Name of Button, Table, Field etc (E.g. Btn_OpenIncidentTask) 5. Execution Order (-000-) 6. Details of Actions (OpenHelpDesk) Thus, we get CC_NIM:Btn_OpenIncidentTask-000-OpenHelpDesk If an AL or Filter is part of a Guide, then the suffix _GUIDE is applied. If the AL or Filter calls a Guide, then the suffix _CallGuide is applied. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: ITSM naming convention sucks
So then you would scamble through looking at each one to see what each Active Link in the guide actually does? How about: HPD-HD-CUS:xxx-1_CheckForExistingCustomer HPD-HD-CUS:xxx-2_SetCustomerInfoFromContactForm etc. Not sure what the other descriptive text could be...but xxx indicates that it triggers in a guide and nowhere else...I find it easier to find code if it is clearly labelled. On Mar 24, 12:46 pm, Joe DeSouza joe_rem...@yahoo.com wrote: Its a good naming convention - I won't go so far as to say its the best. There are a few things in the ITSP naming convention that I personally do not favor. For eg. AL's found in a guide that are used specifically in the guide alone and nowhere else.. Why different kind of names for each? Why do we need to know what each do? As a developer when looking at the list I would rather see them named as a functional name what the guide does. For eg if the Guide sets customer information and there are 5 AL's in that guide ordered 1 to 5 I would name them something like HPD:GuideSetCustomerInfo01 HPD:GuideSetCustomerInfo02 HPD:GuideSetCustomerInfo03 HPD:GuideSetCustomerInfo04 HPD:GuideSetCustomerInfo05 And name the Guide something like HPD:GuideSetCustomerInfo This is just one odd example of how it would make it easier for a developer to trace what someone else has worked on without running workflow logs for everything.. Joe From: Mahesh Chandra mchand...@gmail.com To: arsl...@arslist.org Sent: Monday, March 23, 2009 11:54:31 PM Subject: Re: ITSM naming convention sucks ** As per ITSP naming convention the standard format of an Active Link is: [z][SchemaCode]:[#]-[Field Name/Button/Function]-[Firing Condition][###E]-[Description]-[IndicatorSuffix][Status] Where z (lowercase) The lowercase z in front of the active link name indicates a Global Workflow Filter Schema Code Schema Code (Reference Schema Code in case of Global Active Link) - 3 Uppercase characters (usually the same as the entry-id prefix of the schema) # Grouping Code: 0 = Initialization (Window Open, Query, Set Defaults, Display, Copy to New) 1 = Execution (Submit, Modify) 2 = Post Execution (After Submit, After Modify) 3 = Close (Window Close) 4 – 5 (Unassigned/Reserved) 9 = In session (Button, Return, Menu/Row Choice, Gain Focus, Lose Focus0 z = Guide (Active Links Called by Guides only) ###[E] Execution Order (3 digits). Append E if Else Action exists Description Functional Description of the Workflow performed Indicator Suffix E = Error N = Note W = Warning R = Run Process Q = SQL G = Call Guide J### - Goto execution order PCDE = Push where CDE is the 3 character code Status + = New Workflow, requires testing (once tested the prefix can be removed) @ = Existing Workflow has been temporarily deactivated # = Existing deactivated workflow with the intent of deleting from the system HPD:INC: ContactSearch_120_GPn-G Even though this piece of workflow doesn’t exist in ITSP, I think this is the breakout. HPD Module Name INC 3 Character Schema Code stored in SYS:Form List (ITSP) and Schema Names (ITSM 7) ContactSearch Field Name 120 Execution Order Gpn (not sure) G Indicator Suffix for Call Guide In my opinion, ITSP followed some best naming conventions. Thanks Mahesh On Fri, Mar 20, 2009 at 8:15 AM, Matt Worsdell m...@worsy.co.uk wrote: Not BMC's fault, ITSM is based on ITSP which was produced by a VAR (name withheld to protect the guilty). -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of ccrashh Sent: 20 March 2009 12:53 To: arsl...@arslist.org Subject: ITSM naming convention sucks BMC has to be kidding with their ITSM suite's naming convention...for instance: On the HPD:HelpDesk form, the Customer Search button (inexplicably called Contact Search even though it is under the Customer Information section) has several Active Links associated to it (31 or so). If you were to go to the list of active links and sort by name, the first one that appears is: HPD:INC:ContactSearch_120_GPn-G However, the first one that triggers is: HPD:INC:ContactSearch_Info_035_GetPersonInfo Which is 19th in the list of 31 Active Links. WTF. Why would anyone do things this way? How can any real Remedy ARS developer work with this crap without wanting to put his/her fist through the monitor? Here's a tip...fix the naming convention! For example: HPD-INC-CUS:SR-b035-GetPersonInfo ... HPD-INC-CUS:SR-b120-GPn-G --- of course, this should be renamed to something more explicit like: HPD-INC-CUS:SR-b120-CallGuide_CF (CF being an acronym for the ContactFound guide...which I would rename to HD-INC-CF:ContactFound) See, now this naming convention makes sense. Broken down it is the HPD module INC form
ITSM naming convention sucks
BMC has to be kidding with their ITSM suite's naming convention...for instance: On the HPD:HelpDesk form, the Customer Search button (inexplicably called Contact Search even though it is under the Customer Information section) has several Active Links associated to it (31 or so). If you were to go to the list of active links and sort by name, the first one that appears is: HPD:INC:ContactSearch_120_GPn-G However, the first one that triggers is: HPD:INC:ContactSearch_Info_035_GetPersonInfo Which is 19th in the list of 31 Active Links. WTF. Why would anyone do things this way? How can any real Remedy ARS developer work with this crap without wanting to put his/her fist through the monitor? Here's a tip...fix the naming convention! For example: HPD-INC-CUS:SR-b035-GetPersonInfo ... HPD-INC-CUS:SR-b120-GPn-G --- of course, this should be renamed to something more explicit like: HPD-INC-CUS:SR-b120-CallGuide_CF (CF being an acronym for the ContactFound guide...which I would rename to HD-INC-CF:ContactFound) See, now this naming convention makes sense. Broken down it is the HPD module INC form (though, I would change this to HD probably to match the form's actual acronym) CUS (for Customer - so we know this has something to do with the Customer information on the form) SR - for Search (so if this were the Create button, I would use CR, and MD for Modify) b - for button (other abbreviations would be s = submit, m=modify, mc = menu choice, etc.) 035 or 120 - execution order GetPersonInfo - or other - description of the functionality (can be followed by things like -E for Error, or -G for a Goto, etc.) So, if I were to modify all the ALs accordingly, sorting by name gives us the Active Links in order of their functionality and execution order within that functionality. What BMC has provided is total crap...'natch. And my contract may require me to work on this...double sigh. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: ITSM naming convention sucks
Ah...that might explain some of the different naming conventions I have seen across modules. Man, this is going to be a pain... ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: LDAP integration in Remedy V6.3
Sorry, responded to you rather than the group. What do you mean by ...SID to the fields that are presented to the LDAP? On Feb 25, 9:39 am, Dan Fraser daniel.fra...@sbcglobal.net wrote: I am currently running Remedy V6.3 integrated with Windows Active Directory. My question is, how can I add the SID to the fields that are presented to the LDAP ___ UNSUBSCRIBE or access ARSlist Archives atwww.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
Remedy ODBC Drivers and 7.1
Has anyone else seen this issue? When trying to run an embedded Crystal Report, we got the error: An error occurred while generating the Crystal Report: 0x80047e48 - Logon Failed (ARERR 1904) What we discovered is that the AR System ODBC driver existed as a Data Source but did not have a server name (that is, if you go to Windows Start/Administrative Tools/Data Sources (ODBC), there should be a line for the AR System ODBC driver...if not, you can add it). Now, if there is no AR System ODBC driver listed as a User Data Source, you can still run the report via a 6.3 User Tool. The User Data Source is created and set properly (i.e. with a server name). However, if you run the report from a 7.1 User tool, it does NOT create the data source. As well, on SOME machines, even if the data source is there but there is no Server Name, you get the error above - on other machines, as long as the Data Source exists, the report runs even if there is no Server Name. We can't figure out why, and what is happening. BMC says that this is as designed - that is, each Client Workstation has to manually set the AR System ODBC driver. Sigh. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
SOLVED: Attachments and Webservices
Solved it myself: Using VB.NET, attach a webservice (in the sample below I called the attached webservice wsTestAttach) to the project (use the Web Reference structure): Imports System.IO Private Sub btnCreateAttach_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCreateAttach.Click Dim myService As wsTestAttach.TestAttachmentService = New wsTestAttach.TestAttachmentService Dim myName As wsTestAttach.AuthenticationInfo = New wsTestAttach.AuthenticationInfo Dim sName As String Dim od As New OpenFileDialog Dim input As FileStream If od.ShowDialog() = DialogResult.OK Then input = File.OpenRead(od.FileName) End If Dim fi As FileInfo = New FileInfo(od.FileName) Dim ltemp As Long = fi.Length Dim ilung As Integer = Convert.ToInt32(ltemp) Dim doc(ilung) As Byte input.Read(doc, 0, ilung) input.Close() sName = od.FileName.Substring(od.FileName.LastIndexOf(\) + 1) myService.OpCreate(sName, doc, ilung, assign to text, short desc, wsTestAttach.StatusType.Assigned, someuser) End Sub ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Attachments and Webservices
I have a webservice that only has one operation (Create). There is an attachment field on the form I want to populate. I can easily create the webservice, but can find no sample code (vb.net) to test consuming the ws. The attachment field is looking for the following values: attachmentName (string) attachmentData (base64Binary) attachmentOrigSize (integer) Has anyone had any luck publishing a webservice that takes an attachment? Do you have some vb.net snippet I can use to test it? Thanks for any help. Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Remedy Deve3loper Studio 7.5???
@Elry... That's good to know. I haven't had a chance to work with it yet, but will try to download it at home soon. I was worried that it was geared to work with the ITSM suite and the piss poor naming convention, among other bloated issues, that BMC/Remedy employs :) lol Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
arsvcdsp process
Everything I have read about this process (Application Dispatcher - arsvcdsp) points to it being used with the Approval server and the Application Pending form. But by default, upon installing ARS, this process gets started. Is this (arsvcdsp) the Application Dispatcher referenced in these documents? And, if so, does this mean that this process is not required at all? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Remedy license usage monitoring utility
Well, I don't know about a free one, but you can check out www.wave-form.com. We use their product here and it does everything we need it to do. Plus, it's a Remedy module you install. Very nice, very compact. There's a trial version you can download. Steve On Feb 5, 1:59 pm, Rootuja Ghatge rgha...@centerbeam.com wrote: Hi all, Is there a free utility/tool out there to monitor measure licenses usage (both Fixed Floating) that can be used to review the peak time usage derive some conclusions from there as to how many and what type of licenses to buy? Thanks in advance, Rootuja _ Rootuja Ghatge Senior Application Developer CenterBeam, Inc. 30 Rio Robles San Jose, CA 95134 Direct (408) 750-0718 Fax (408) 750-0559http://www.centerbeam.comhttp://www.centerbeam.com/ This email may contain confidential and privileged material for the sole use of the intended recipient. Any review or distribution by others is strictly prohibited. If you are not the intended recipient please contact the sender and delete all copies. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: WARNING: don't use 6.3 User tool with 7.1 Server
Sorry about the length of time getting back to you all... Yes, I logged a ticket with BMC. They were able to reproduce the issue (amazing, eh?). So they have opened a bug report. Not sure of the number. On Jan 13, 5:00 pm, Bryan Waters bryancwat...@gmail.com wrote: Have you logged a defect with BMC? If so, can you please share? Thanks, Bryan -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Elry Sent: Tuesday, January 13, 2009 7:06 AM To: arsl...@arslist.org Subject: Re: WARNING: don't use 6.3 User tool with 7.1 Server Hey ccrashhh Long time no parler dudecomment ca va... I agree - we just started our UAT and TRA - we quickly discovered this to be an issue. Glad to see someone else out there can replicate. Have a good one eh... On Jan 6, 8:52 am, ccrashh ccra...@gmail.com wrote: They are certainly compatible (User 6.3 vs 7.1 Server)...with one annoying exception: your forms and code will ALWAYS cache. That's right...each and every time you open a form using User 6.3 on a 7.1 Server installation of Remedy ARS, it will overwrite the existing arf and arv files. Fun times. In as large an organization as I am in, it takes time to rollout certain tools. We decided to upgrade the backend while the QA people dicked around with the 7.1 User tool. They still haven't approved it for rollout, but we were assured by BMC/Remedy that things would be hunky-dory. Not so much. We have users all over the world, and many are now complaining that the application is so slow as to be unusable. We tested packet traffic using Wireshark and noticed that opening a form in Query mode with a 6.3 User tool on a 6.3 Server meant around 10 packets with a total size of about 1900 bytes. Opening the same form in the same way against a 7.3 Server had 215 packets and about 190,000 bytes. A factor in size of about a 100. We then realized that the 6.3 User tool was forcing a constant recache of the forms/ code. Sigh. Just a heads up to any in a situation like this. If Users are complaining about slow speeds with the arserver 7.1, check which version of the User tool they are using. ___ 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: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: Escalation question
I set up a very robust scheduler application. I made it act a bit like the Windows Task Scheduler. You can set up a very specific schedule at which you want something to happen/trigger...every 2nd Saturday of the month, for instance. It works by calculating when the first trigger time will be. Then, when that date/time is reached (uses an Escalation that triggers using that date/time field, of course) code calculates the next trigger time. Steve On Feb 3, 1:00 pm, Pruitt, Christopher J christopher.pru...@eds.com wrote: I have been trying to figure out a way to make an Escalation run on the Second Saturday of every month. I know you can schedule it to run at during a specific Hour of the Day, or Day of the Month or even a Week Day but none of these options allow you to run it on a specific day of the Month where it is, say a Second Saturday or Third Monday, etc. Anyone had any success in this area of Escalation scheduling? Configuration: AR System 7.1 Oracle 10g Sun Solaris OS 5.9 Christopher Pruitt Consultant Specialist EDS, an HP Company mailto: christopher.pru...@eds.com We deliver on our commitments so you can deliver on yours. Confidentiality Notice: This message and any files transmitted with it are intended for the sole use of the entity or individual to whom it is addressed, and may contain information that is confidential, privileged, and exempt from disclosure under applicable law. If you are not the intended addressee for this e-mail, you are hereby notified that any copying, distribution, or dissemination of this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately destroy, erase, or discard this message. Please notify the sender immediately by return e-mail if you have received this e-mail by mistake. ___ UNSUBSCRIBE or access ARSlist Archives atwww.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
Solaris 10 and Remedy ARS
We had an interesting problem with a test envirornment. Even if we set the ar.conf file to register with the portmapper, we got an RPCBind error (Authentication Failure). We discovered that the latest version of Solaris uses some different settings. We found the following solution at http://www.mail-archive.com/arsperl-us...@arsperl.org/msg00610.html: 1. the portmapper (rpcbind) is under the control of the Service Management Facility (SMF) on solaris10. SMF seems (to me, at least) very bloated with lots of gratuitous stuff, including properties. One of the properties for rpc/bind is config/local_only which apparently controls whether the portmapper can be reached from other hosts. It was set to true, so other hosts were out of luck. I set it to false using: svccfg -s svc:/network/rpc/bind svc:/network/rpc/bind setprop config/local_only = false svc:/network/rpc/bind quit svcadm refresh svc:/network/rpc/bind 2. the 2nd cause was also related to a property, config/ enable_tcpwrappers, which was set to true, meaning access to rpcbind was filtered by tcpwrappers, so I added a line to /etc/hosts.allow as follows: rpcbind: ALL And made sure /etc/hosts.allow was readable by rpcbind (chmod 644 /etc/hosts.allow). Just a heads up. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: How to create many entries in Remedy form at a time from C# code?
I'm afraid you will have to use CreateEntry...trying to do any kind of bulk insert is a royal pain, since you also have to get the NextID from arschema and increment it. The safest way is, definitely, the Remedy APIs. Steve On Jan 8, 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. -- View this message in context:http://www.nabble.com/How-to-create-many-entries-in-Remedy-form-at-a-... Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: Where the Answers Are
Re: 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
Re: Active Link works on dev; not on prod
My question exactly. I thought the same thing, but would have to test. If they don't work (and I would never rely on LASTCOUNT) I would take the table field qualification and simply build a SQL Count statement to return the number of matching records. It would be safer, especially if the User has the number of records to be returned set to a smaller number in the User tool - not sure if that screws things up eitherAND if table chunking affects things. Steve On Jan 7, 5:44 pm, Joe DeSouza joe_rem...@yahoo.com wrote: Does LASTCOUNT and COLCOUNT($ID$) work correctly when table chunking is enabled? I don't remember so just thinking out loud here before you think its the solution.. Joe From: Opela, Gary L CTR USAF AFMC 72 CS/SCBAH gary.opela@tinker.af.mil To: arsl...@arslist.org Sent: Wednesday, January 7, 2009 4:29:56 PM Subject: Re: Active Link works on dev; not on prod Hey, that looks like it might just work. I don't know why they don't call it ROWCOUNT. From the 6.3 documentation: COLCOUNT (column) or (table) int For a table or results list field, returns the total number of rows. For a column field, returns the total number of non-NULL rows in a given column. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Greg Donalson Sent: Wednesday, January 07, 2009 3:27 PM To: arsl...@arslist.org Subject: Re: Active Link works on dev; not on prod Hi Gary, You can always do 'Ticket Count' = COLCOUNT($tbl_Tickets$). I would suggest using this - I do not like to rely on LASTCOUNT. Greg Donalson Schlumberger Desk - 713-513-2331 Cell - 281-515-6538 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 3:15 PM To: arsl...@arslist.org Subject: Re: Active Link works on dev; not on prod The solution; use the $LASTCOUNT$ keyword. Since I'm running it immediately after refreshing the table, it should always pull the correct count. Gary -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, January 07, 2009 2:54 PM To: arsl...@arslist.org Subject: Re: Active Link works on dev; not on prod ** I thought setting an Integer field equal to a table puts the row number of the currently selected row into the Integer field Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Opela, Gary L CTR USAF AFMC 72 CS/SCBAH Sent: Wednesday, January 07, 2009 2:50 PM To: arsl...@arslist.org Subject: Active Link works on dev; not on prod AR Server 6.3/ WUT 6.3/ Windows 2k3/ MSSQLServer So, I just developed a form and some active links on dev, then imported them into prod, and one of the ALs doesn't work. So, the active link does a set fields. It sets 'Ticket Count' = $tbl_Tickets$ On dev, this will set the Ticket Count integer field to the number of records in the tbl_Tickets table. This works fine in dev, but not in prod. Below are the logs from each table refresh: Dev: WFLG /* Wed Jan 07 2009 14:35:26 */ WFLG Workflow Trace Log -- ON ACTL /* Wed Jan 07 2009 14:35:28 */ ACTL Start active link processing -- Operation - On Menu Choice ACTL For Schema - HD: My Stats ACTL Linked to field - Table Properties: (536870936) ACTL On screen type - CREATE ACTL Checking HD: MS: Set Table Qual on Table Properties: Change (10) ACTL - Passed qualification -- perform if actions ACTL 0: Set Fields ACTL Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( 'Create Date' = 04/01/2008) ACTL Checking HD: MS: Refresh tbl_My Tickets (50) ACTL - Passed qualification -- perform if actions ACTL 0: Set Characteristics ACTL For field -- Tickets (536870932) ACTL Refresh field ACTL 1: Set Fields ACTL Ticket Count: (536870937) = 21 ACTL /* Wed Jan 07 2009 14:35:28 */ ACTL Stop active link processing - On Menu Choice WFLG /* Wed Jan 07 2009 14:35:34 */ WFLG Workflow Trace Log -- OFF Prod: WFLG /* Wed Jan 07 2009 14:34:54 */ WFLG Workflow Trace Log -- ON ACTL /* Wed Jan 07 2009 14:35:02 */ ACTL Start active link processing -- Operation - On Menu Choice ACTL For Schema - HD: My Stats ACTL Linked to field - Table Properties: (536870936) ACTL On screen type - CREATE ACTL Checking HD: MS: Set Table Qual on Table Properties: Change (10) ACTL - Passed qualification -- perform if actions ACTL 0: Set Fields ACTL Table Qual (536870935) = ( 'Submitter' = $\USER$) AND ( 'Create Date' = 04/01/2008) ACTL Checking HD: MS: Refresh tbl_My Tickets (50) ACTL - Passed qualification -- perform if actions ACTL 0: Set
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
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 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
WARNING: don't use 6.3 User tool with 7.1 Server
They are certainly compatible (User 6.3 vs 7.1 Server)...with one annoying exception: your forms and code will ALWAYS cache. That's right...each and every time you open a form using User 6.3 on a 7.1 Server installation of Remedy ARS, it will overwrite the existing arf and arv files. Fun times. In as large an organization as I am in, it takes time to rollout certain tools. We decided to upgrade the backend while the QA people dicked around with the 7.1 User tool. They still haven't approved it for rollout, but we were assured by BMC/Remedy that things would be hunky-dory. Not so much. We have users all over the world, and many are now complaining that the application is so slow as to be unusable. We tested packet traffic using Wireshark and noticed that opening a form in Query mode with a 6.3 User tool on a 6.3 Server meant around 10 packets with a total size of about 1900 bytes. Opening the same form in the same way against a 7.3 Server had 215 packets and about 190,000 bytes. A factor in size of about a 100. We then realized that the 6.3 User tool was forcing a constant recache of the forms/ code. Sigh. Just a heads up to any in a situation like this. If Users are complaining about slow speeds with the arserver 7.1, check which version of the User tool they are using. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: how to open a window on a set field action with multiple request match
Simple. Do a SQL Count first, using the same qualification as your statement but written as: SELECT COUNT(*) FROM .. Then have an Active Link trigger if this number is greater that 1. On the Open Window, use the qualification statement and have the Window Type set to Modify and the Display Type set to List Only. This should open the Results list as specified in the form's properties. An alternative is to do an Open Window to a new form that has a table field and pass the qualification, which you use with a EXTERNAL ($passedqualification$) in the table's qualification. This has the added benefit of allowing you to customize which columns are displayed. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to submit and modify incidents/problems through email.
The ARSystem Email Messages form will automatically parse and submit tickets if the format of the incoming email is as follows: char-set: windows-1252 # # File exported Tue Jan 6 09:04:16 2009 # Schema: Some_Form Server: SomeServer Login: Password: Action: Submit # Values: Submit, Query Format: Short # Values: Short, Full Z_Short_Desc !8!: N/A Z_Assigned_To !4!: Submitter !2!: $USER$ Status !7!: Active # Values: Inactive, Active You create this .arm file by clicking Tools/Export Mail Templates and choosing the form and view you want to use (you can create a nice little EmailTemplateView which contains only the fields you want someone to be able to access via email). If an email comes into the ARSystem Email Messages form with that format above, APIs will automatically parse it out and submit (or whatever is set as the Action) a ticket to the form listed as the Schema: Steve On Jan 5, 6:54 am, Salma salmabeg...@gmail.com wrote: Hi Steve, I didnt know there is OOTB functionality to subit incidents through emails . Can u please explain me more on this . Regards, Salma ccrashh wrote: Er...everyone seems to be assuming that you are using the Out-of-the- box (OOTB) crap...I mean...solution from BMC/Remedy. Is this the case? Are you asking about processing emails in a OOTB environment or a custom application? Steve ___ UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org Platinum Sponsor:www.rmsportal.comARSlist: Where the Answers Are -- View this message in context:http://www.nabble.com/How-to-submit-and-modify-incidents-problems-thr... Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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
Re: File / Send Mail feature question
Actually, the Subject line gets populated with the form's Current View name. For instance, if your schema name is SHR_ApplicationSettings, and View1's singular Alias is Application Setting, then the Subject of the email will be Application Setting. If you opened it in View2 and it's singular Alias was Blah then that will be the contents of the Subject line. Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Creating Decrementing value in Table
Why would there be a perfomance impact? How are you adding this new record? You already know that the highest value is 5, so when you add a new record (in your example called Test6) that the new Order ID would be the current max order id + 1. So when you do a Push Fields to create a new record, you push 6 to the order id. I really am curious as to how adding a new record is causing you to have performance issues. Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: How to submit and modify incidents/problems through email.
Er...everyone seems to be assuming that you are using the Out-of-the- box (OOTB) crap...I mean...solution from BMC/Remedy. Is this the case? Are you asking about processing emails in a OOTB environment or a custom application? Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Creating Decrementing value in Table
I think the easiest approach is, as Mike said, an Update SQL statement: UPDATE childtablename SET counter = counter - 1 WHERE parentrequestid = '$request_id$' AND counter '$counterbeingdeleted$' childtablename = the schema of the child form counter = field on the childtablename that stores the 1, 2, 3, etc. parentrequestid = I am assuming you have some foreign key stored on the childtable that is the Request ID of the parent record. counterbeingdeleted = the counter value of the record being deleted (ie 2). This way you don't have to run through a Push Fields filter. Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: OT: ARUtilities holiday special (ending soon)
It can be worth the effort, if you have a good contract. They come in piles sometimes, then dry up for a while. SI Systems has always treated me well. The only feature from RDP that I think would be good to have is it's ability to tell you all the code that impacts a field (uses it in Run If, Set Fields If, Set Fields, Push Fields If, Push Fields, Table Qualification, Table Field Column, Menu, etc) That's really handy. Steve On Dec 17, 6:19 pm, rem...@arutilities.com wrote: Hey Steve, Tell me some of the things that RDP does that ARUtilities should, and I will give you a free license key for ARUtilities 7.0 If i can add some new features everyone would be happy, and I haven't had the chance to look at RDP. And, yes, still at CGI. I am wondering though how i would be able to break out into the self employment world that you did. Do you know the best headhunter to contact? And is it worth the effort? Les You are such a shill :) Heh. Downloaded your latest version. My contract, if you remember, is at DFAIT, and we are having huge issues with RDP. Though ARUtilities doesn't fully replace RDP, it has some tools we can use. Been trying to get the manager here to put in a purchase request. Steve O'Leary PS: still at CGI? On Dec 17, 11:12 am, rem...@arutilities.com wrote: Hello everyone, This is just a note to let you know that ARUtilities is available at a very special price until January 1st 2009. ARUtilities is a tool set used by many Remedy Developers around the world ___ 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
Re: Vista Issues with 7.0 User tool.
Isn't it always out of our control? Sigh :) Good luck with it. Let us know your findings...I am sure many of us will hit the same issue at some point. Steve On Dec 17, 11:29 am, Begosh, Kevin kevin.beg...@lmco.com wrote: That is out of my control :) Kevin Begosh, RSP Tech Ops Enterprise Business Services 301-791-3540 Phone 410-422-3623 Cell kevin.beg...@lmco.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of ccrashh Sent: Wednesday, December 17, 2008 11:28 AM To: arsl...@arslist.org Subject: Re: Vista Issues with 7.0 User tool. Not to be trite, but the solution is probably to downgrade to XP :). Our department took one look at the resource hog that is Vista, and the crap that is the new version of Office and ran screaming...thank god. But yeah, as someone else posted, the spellchecker caused some issues when we tested it out. There were others that screwed up apps, but they had more to do with drivers. Steve On Dec 16, 1:28 pm, Begosh, Kevin kevin.beg...@lmco.com wrote: We are currently having some issues with a Vista user enterprise edition with the user tool. He is using the user tool version 7.0 and when he clicks on any of the quick links or navigation bars nothing happens. He is able to open forms from the object list but none of the quick links appear to work. We are on AR Server 7.1 patch 4, UNIX OS. Has anyone heard of this or had any issue with this. BMC said that there has been no reports of any issues with this. Kevin Begosh, RSP 301-791-3540 Phone 410-422-3623 Cell ___ 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 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
Re: set fields by process error
Have you tried this? SET FIELDS: process_char to echo + $Emain Body$ + | /home/ aramey/html2text-0.003/html2text.pl And then simply doing the PROCESS as: $PROCESS$ $process_char$ Steve On Dec 11, 10:44 am, Ramey, Anne anne.ra...@its.nc.gov wrote: I am getting an exit code: 127 set fields action error when trying to use the following in a set fields action to strip HTML from an email body: $PROCESS$ echo $Email Body$ | /home/aramey/html2text-0.003/html2text.pl The process works fine when I run it from the command line: btw, it does work from the command line: r...@ncc db# echo h2Test header/h2brtestbr Anne Ramey test | /home/aramey/html2text-0.003/html2text.pl Starting /home/aramey/html2text-0.003/html2text.pl ... Test header === test Anne Ramey test Anyone know what exit code 127 means? or see any syntax errors? I can't find the set field error exit codes anywhere in the documentation. AR System 7.0.1 Patch 5, ITSM 7.0.03 patch 7 on Red Hat Linux. Oracle backend. Thanks, 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. ___ 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
Re: Demote ARS 7.1 to ARS 6.3
I agree with the above posts - I don't think you can run a standard downgrade like that. Easiest approach is to remove everything from your staging server, clear out the database, reinstall ARServer 6.3, then import the code/data from your Production server. This would be safer than attempting to tweak things to downgrade it live. On Dec 16, 12:58 pm, Amy abel...@schoolspecialty.com wrote: Our ARS environment is completely messed up and I need to revert back to our old configuration so that our staging server can mirror our production server. Right now staging has ARS 7.1 with ITSM 6.3. I need it to be ARS 6.3 with ITSM 6.3. The server is on RedHat Linux. 1. Is there any uninstall required for ARS 7.1 other than removing the files from the server? 2. Do I need to worry about the ITSM installation or will I need to uninstall/reinstall it? 3. Is there anything else I should know before I start?? I am the Remedy admin, NOT the UNIX admin, but since no one has time to do this right now I will be performing the installations myself. Unfortunately none of the UNIX admins or consultants who have done this before wrote anything down so pretty much all I have is the BMC documentation. Any help you could provide would be much appreciated! Thanks! Amy Belile Remedy OracleAS Portal Engineer School Specialty 3195 Wilson Dr NW Grand Rapids MI 49534 920-882-5630 Phone abel...@schoolspecialty.comwww.schoolspecialty.com Helping educators engage and inspire students of all ages and abilities to learn. ___ 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
Re: Sybase V15 - PATH keyword
Actually, we just discovered it is, in fact, a Sybase issue. They have released a patch that removes PATH as a keyword. Go figure...BMC passed the buck and they were correct :) Steve On Dec 17, 12:25 pm, Frank Caruso caruso.fr...@gmail.com wrote: Not exactly but am having similar issue upgrading to Sybase15. The installer needs to enclose keywords in quotes but it does not. BMC is calling it a Sybase issue On Dec 17, 2008, at 10:54 AM, ccrashh ccra...@gmail.com wrote: We are trying to install ARS 7.1 onto a Sybase V15 database, and are getting errors due to the PATH keyword. Some of the Remedy base forms use PATH as a fieldname, which is causing errors during install. Has anyone else come across this issue? Are you aware of a workaround? ___ 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
Re: Vista Issues with 7.0 User tool.
Not to be trite, but the solution is probably to downgrade to XP :). Our department took one look at the resource hog that is Vista, and the crap that is the new version of Office and ran screaming...thank god. But yeah, as someone else posted, the spellchecker caused some issues when we tested it out. There were others that screwed up apps, but they had more to do with drivers. Steve On Dec 16, 1:28 pm, Begosh, Kevin kevin.beg...@lmco.com wrote: We are currently having some issues with a Vista user enterprise edition with the user tool. He is using the user tool version 7.0 and when he clicks on any of the quick links or navigation bars nothing happens. He is able to open forms from the object list but none of the quick links appear to work. We are on AR Server 7.1 patch 4, UNIX OS. Has anyone heard of this or had any issue with this. BMC said that there has been no reports of any issues with this. Kevin Begosh, RSP 301-791-3540 Phone 410-422-3623 Cell ___ 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
Re: OT: ARUtilities holiday special (ending soon)
You are such a shill :) Heh. Downloaded your latest version. My contract, if you remember, is at DFAIT, and we are having huge issues with RDP. Though ARUtilities doesn't fully replace RDP, it has some tools we can use. Been trying to get the manager here to put in a purchase request. Steve O'Leary PS: still at CGI? On Dec 17, 11:12 am, rem...@arutilities.com wrote: Hello everyone, This is just a note to let you know that ARUtilities is available at a very special price until January 1st 2009. ARUtilities is a tool set used by many Remedy Developers around the world. For product details visit:http://www.arutilities.com/remedydevelopers.html I would like to thank everyone for your continued support. supp...@arutilities.com feedb...@arutilities.comhttp://www.arutilities.com Les Ganton ___ 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
Sybase V15 - PATH keyword
We are trying to install ARS 7.1 onto a Sybase V15 database, and are getting errors due to the PATH keyword. Some of the Remedy base forms use PATH as a fieldname, which is causing errors during install. Has anyone else come across this issue? Are you aware of a workaround? ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Core Fields Expand Box
Someone asked this way back in 2007, but no one replied. In typical hamfisted fashion, BMC has shoved out a modification that impacts every regular form - that is, the core character fields have increased from 30 to 254. This means, of course, that if you left the Expand Box option to Default in the field properties, every one of the fields (Submitter, Last Modified By, and Assigned To) has an Expand Box showing. In most cases, this has caused the GUI on our forms to look ridiculous. Does anyone know of a quick way to change the Expand Box option to Hide? I was hoping for a cool SQL statement like UPDATE field_dispprop SET something to something WHERE fieldid=4 The above would update all Assigned To fields. Of course, the option for the expand box is in the proplong or propshort columns so it looks like crap and is essentially unmodifiable. Anyone know of an API call for this? Thanks for any help ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Core Fields Expand Box
You can't change the length of Core fields - unless you mean try to do it at the database level? Steve ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Core Fields Expand Box
Yes, thank you (I sent you an email). Thanks again. Steve On Nov 28, 10:23 am, Martin, Conny [EMAIL PROTECTED] wrote: Hi, We've done this using the Java-API. If you are interested in some code snippet, let me know. Kind Regards Conny -Ursprüngliche Nachricht- Von: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Im Auftrag von ccrashh Gesendet: Freitag, 28. November 2008 15:56 An: [EMAIL PROTECTED] Betreff: Core Fields Expand Box Someone asked this way back in 2007, but no one replied. In typical hamfisted fashion, BMC has shoved out a modification that impacts every regular form - that is, the core character fields have increased from 30 to 254. This means, of course, that if you left the Expand Box option to Default in the field properties, every one of the fields (Submitter, Last Modified By, and Assigned To) has an Expand Box showing. In most cases, this has caused the GUI on our forms to look ridiculous. Does anyone know of a quick way to change the Expand Box option to Hide? I was hoping for a cool SQL statement like UPDATE field_dispprop SET something to something WHERE fieldid=4 The above would update all Assigned To fields. Of course, the option for the expand box is in the proplong or propshort columns so it looks like crap and is essentially unmodifiable. Anyone know of an API call for this? Thanks for any help ___ 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 at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: BMC Remedy ARS + ITSM Interview Questions
I had an interview with RIM in the spring, and the first question they asked me was: What is an Active Link? It would like asking someone who has been teaching for more than 10 years to recite the alphabet. The interview essentially went downhill from there. On Nov 28, 7:44 am, Frank, Gordon M. (CMS/CTR) [EMAIL PROTECTED] wrote: Some of the responses I am seeing on ARSList are a little complex. Here's some more common questions (remember your Resume will tell your capabilities): 1. What is the difference between and Active Link and a Filter? 2. What is a .def file used for? 3. What is a .arx file? 4. Who is Doug Mueller? 5. What is a use for an Active Link Guide? 6. What type of field it the Worklog field? 7. Name two DBMSs in which Remedy ARS can run on top of? 8. What does ARS stand for? 9. What are the core fields? 10. What does $MENU$ do? And so on. You'd be amazed at the number of interviews I've conducted and the interviewee couldn't answer these basic questions. A database question I like to ask is: What's the difference between SYSMAN and SYSTEM in an Oracle world? A very simple UNIX question is: What does LS do? Gordon M. Frank Remedy Skilled Professional ITIL V3 Certified Lockheed Martin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Salma Sent: Thursday, November 27, 2008 2:02 AM To: [EMAIL PROTECTED] Subject: BMC Remedy ARS + ITSM Interview Questions Dear Team, As i have completed my 1 year with ARS and ITSM application , planning to take up some interviews. Please can any one help me with some interview questions which are commonly asked . So that i can prepared for my interview . Please post me all the question which you guys faced during ur interviews . And also apart from ARS or ITSM , any possibilty of asking questions from other topics like Database, OS , Network , If yes please let me the same . Thanks in advance , Salma -- View this message in context:http://www.nabble.com/BMC-Remedy-ARS-%2B-ITSM-Interview-Questions-tp2071 p2071.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ 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
Count Rows selected
I know I can count the number of rows selected in a table by using a table loop guide. The actual counting isn't the issue. What I would like to do is count when I select the rows. For instance, if I select a row in a table, the Menu/Row Choice active links on that table trigger. If I shift-click or ctrl-click another row in the table, the Menu/Row Choice active links DON'T trigger. Short of creating a button that says Count Number of Rows Selected, does anyone have a way to count the rows selected AS you are selecting them? I tried playing with Gain Focus and Lose Focus events, but that didn't work (sometimes the count was right, but the rows weren't highlighted). Thanks for any help. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org