Re: RPC: Program not registered
Try switching the server over to development mode. Sent from my BlackBerry -Original Message- From: Abdul Haque Sender: "Action Request System discussion list(ARSList)" Date: Sat, 13 Aug 2011 17:03:53 To: Reply-To: arslist@ARSLIST.ORG Subject: Re: RPC: Program not registered *Its not install, the server is running properly, but this happens only when I save a filter or active link, the server gets automatically r*e*started. regards * On 13 August 2011 16:27, Patrick Zandi wrote: > Is thus an install. I had to choose port.. Just change ar.confirm > > Sent from my iPhone so typo's or funky words can and do happen! > > On Aug 13, 2011, at 8:38 AM, Abdul Haque Khan > wrote: > > > when i m trying to save (Mostly Approvals or Making edit in Active links > or Filters) getting below ERRORs. > > > > 390600 : Insufficient server memory for running this process. (ARERR 300) > > CopyCache > > AR System server terminated — fatal error occurred in ARSERVER (ARNOTE > 21) Action Request System(R) Server Version 7.6.04 SP1 201104191058 > > (c) Copyright 1991-2011 BMC Software, Inc. > > > > Cannot establish a network connection to the AR System server (BMCREPORT > (0) : RPC: Program not registered) ARERR - 90 > > > > Any Help would be appreciated. > > > > >___ > > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > > >___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" > -- BEST REGARDS Abdul Haque +966531861850 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: How can we display date feilds in emails in local time.
Hi Ron, This has been an issue right from the beginning and the best way to solve it is as Andrew suggested. However if this is not acceptable you could do the following. Copy the date/time into a character field before it is saved to the server and then the server won't touch it and put that into your email instead. Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Ron Tavares Sent: 26 May 2011 16:06 To: arslist@ARSLIST.ORG Subject: How can we display date feilds in emails in local time. ** Good Morning, When recipients receive email notifications with date fields on them, (example Change Request start time), the time is displayed in the email server time rather than the user's local time. I guess this makes sense since the email server has no way of knowing what time zone the recipients are in. Nevertheless, looks like BMC has a bug for this, (SW00257640). I'm sure many of you have come across this complaint before. Is there a clever way of dealing with this? ARS 7.1 Windows OS Thanks, .ron _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _ avast! Antivirus <http://www.avast.com> : Outbound message clean. Virus Database (VPS): 26/05/2011 Tested on: 26/05/2011 17:14:55 avast! - copyright (c) 1988-2011 AVAST Software. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: Hidden Fields
Hi Lisa, Taking the fields out of the view the users get should fix the problem. Brian Brian Bishop Goldstag Consultants Ltd +44(0)7973 746832 -Original Message- From: "Kemes, Lisa" Sender: "Action Request System discussion list(ARSList)" Date: Fri, 19 Nov 2010 17:21:19 To: Reply-To: arslist@ARSLIST.ORG Subject: Hidden Fields Is there any way (other than creating a view or permissions) to not only hide a field via the field properties, but to hide these fields to keep people from adding them to reports as well. I have hidden temp fields and I don't want the customer to choose these fields when creating reports (there would be no reason for them to). I think the answer is that there is no other way, but just wanted to make sure. Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-602-9460 cell lisa.ke...@te.com ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
Re: 'ISNUMBER' function?
I had to do something like this a long time ago. I needed to confirm that a value was all numeric. I used the REPLACE function to replace all numeric characters with nothing and if after doing it there was still a value left the string must have at least one alpha or special character in it. This ought to work regardless of language and use of special characters. Brian Brian Bishop Goldstag Consultants Ltd +44(0)7973 746832 -Original Message- From: "Mueller, Doug" Sender: "Action Request System discussion list(ARSList)" Date: Thu, 16 Sep 2010 12:18:12 To: Reply-To: arslist@ARSLIST.ORG Subject: Re: 'ISNUMBER' function? John, Actually, you would need LIKE "%[a-zA-Z]%" to allow for upper and lower case letters if you are in a case sensitive database environment (or just to be sure in case insensitive too). AND, this will work only if the serial number uses only ENGLISH characters if there are characters. This is pretty likely for a serial number so this will likely work. It would not necessarily be sufficient in other languages if characters can be present that are not the 26 letters of the English alphabet. Of course, this also assumes that special characters are not allowed because they will have the same issues with converting to numbers as characters. Doug Mueller From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Reiser, John J Sent: Thursday, September 16, 2010 10:10 AM To: arslist@ARSLIST.ORG Subject: Re: 'ISNUMBER' function? ** Use a Run If qualification of 'Serial Number' LIKE "%[a-z]%" The if action sets Int_temp to 0 Else action sets Int_Temp to $Serial Number$ --- John J. Reiser Senior Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bao, Hui-Qing Sent: Thursday, September 16, 2010 12:50 PM To: arslist@ARSLIST.ORG Subject: EXTERNAL: 'ISNUMBER' function? ** All, I wish Remedy provide some kind of function like 'ISNUMBER' I have a character field 'Serial Number', I want to know If the value of this field is a character value or number value. If it is all digit, I need to convert it to integer then apply some workflows based on the data range.. I created an integer field 'Int_temp' and assign 'Serial Number' to this integer field 'Int_temp' = $Serial Number$; Below are the result I got Serial Number Int_temp 67A908675 67 A6789A6 0 067859 67859 If the result is 0, I know the Serial number must be a character value. But for Serial number 67A908675, the result is 67, even the serial number is a character value with the value of 67A908675 . So, is there any easy way to find out if a Character field is number or not? Thanks, Huiqing _ This electronic message and any files transmitted with it contains information from iDirect, which may be privileged, proprietary and/or confidential. It is intended solely for the use of the individual or entity to whom they are addressed. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please delete it and immediately notify the sender. _ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Upgrade of Analytics from 2.5 to 7.6
Hi All, I am attempting to upgrade Analytic from 2.5 to 7.6. I was given the impression that I could do this without upgrading BOXI. But this turns out not to be true as even though the upgrade went fine none of the reports will run unless we are on Web Intelligence version 12.1.0.0. So now I am trying to upgrade BOXI 3.0 to 3.1 but the upgrade wont allow it. Any advise on the correct path would be apprteciated. Thanks Brian ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
Re: RPC Timeout Errors
Hi Tommy, Funny thing I was getting this error this morning on my laptop which has a 7.5 p3 dev studio talking to a 7.5 p2 server (on laptop also). I couldn't understand why I was getting problems. Then I found my Remedy service was re-starting and when I looked at arerror .log I found the following. Fri Feb 05 10:50:55 2010 390620 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 05 10:50:55 2010 0xc005 Fri Feb 05 10:50:55 2010 390620 : AR System server terminated -- fatal error encountered (ARNOTE 21) Fri Feb 05 10:52:17 2010 390603 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 05 10:52:17 2010 Timestamp: 1265367138.0780 Thread Id: 5280 Version: 7.5.00 Patch 002 200906100308 Jun 10 2009 04:29:02 ServerName: rem1 Database: SQL -- SQL Server Hardware: Intel Pentium OS: Windows XP 5.1 RPC Id: 65 RPC Call: 10003 (GCE) RPC Queue: 390603 User: AR_ESCALATOR Protocol Version: 0 Client IP Address: Form: SRD:MultipleQuestionResponse Logging On: Code: c005 Operation: read Access Addr: 682BF888 Stack Begin: Stack End Fri Feb 05 10:52:17 2010 390603 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 05 10:52:17 2010 0xc005 Fri Feb 05 10:52:17 2010 390603 : AR System server terminated -- fatal error encountered (ARNOTE 21) Fri Feb 05 11:05:51 2010 390600 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 05 11:05:51 2010 Timestamp: 1265367952.6400 Thread Id: 6088 Version: 7.5.00 Patch 002 200906100308 Jun 10 2009 04:29:02 ServerName: rem1 Database: SQL -- SQL Server Hardware: Intel Pentium OS: Windows XP 5.1 RPC Id: 941 RPC Call: 39 RPC Queue: 390600 Client: User bbishop from Developer Studio (protocol 14) at IP address 192.168.66.131 Form: Logging On: Code: c005 Operation: write Access Addr: Stack Begin: Stack End Fri Feb 05 11:05:51 2010 390600 : AR System server terminated when a signal/exception was received by the server (ARNOTE 20) Fri Feb 05 11:05:51 2010 0xc005 Fri Feb 05 11:05:51 2010 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) Fri Feb 05 11:05:51 2010 390600 : Malloc failed on server (ARERR 300) Fri Feb 05 11:05:51 2010 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) Fri Feb 05 11:05:54 2010 AssignEng : Cannot establish a network connection to the AR System server (rem1 (0) : RPC: Program not registered) ARERR - 90 Fri Feb 05 11:05:55 2010 BRIE : Cannot establish a network connection to the AR System server (rem1 (0) : RPC: Program not registered) ARERR - 90 Fri Feb 05 11:05:55 2010 : Action Request System(R) Server Version 7.5.00 Patch 002 200906100308 (c) Copyright 1991-2009 BMC Software, Inc. Fri Feb 05 11:06:54 2010 AssignEng : Cannot establish a network connection to the AR System server (rem1 (0) : RPC: Program not registered) ARERR - 90 Fri Feb 05 11:06:55 2010 Dispatch : Cannot establish a network connection to the AR System server (rem1 (0) : RPC: Program not registered) ARERR - 90 Fri Feb 05 11:06:55 2010 BRIE : Cannot establish a network connection to the AR System server (rem1 (0) : RPC: Program not registered) ARERR - 90 Fri Feb 05 11:07:54 2010 AssignEng : Cannot establish a network connection to the AR System server (rem1 (0) : RPC: Program not registered) ARERR - 90 Fri Feb 05 11:07:55 2010 Dispatch : Cannot establish a network connection to the AR System server (rem1 (0) : RPC: Program not registered) ARERR - 90 Fri Feb 05 11:07:55 2010 BRIE : Cannot establish a network connection to the AR System server (rem1 (0) : RPC: Program not registered) ARERR - 90 Fri Feb 05 15:54:47 2010 : Action Request System(R) Server Version 7.5.00 Patch 002 200906100308 (c) Copyright 1991-2009 BMC Software, Inc. Note everything stopped happening after the last issue at 11:07 yet prior to that every 10 mis or so the remedy service was re-starting. All I did was put the server into dev mode and stop escalations running. Perhaps you should look into your arerror.log and see what is going on! Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tommy Morris Sent: 05 February 2010 15:46 To: arslist@ARSLIST.ORG Subject: RPC Timeout Errors ** Development Environment Windows 2003 Enterprise Server R2 sp2 Dual Xeon 2.66ghz 6gb RAM ARS 7.5p3 CMDB 7.6 ITSM 7.6 Remote Oracle 11g We have started receiving RPC Timeout (91) errors when attempting to save objects through the developer tool. Does anyone know if there is a maximum number of developers that can connect? I have 4 developers who report the
Re: SLM 7.1 and business time add Question
Hi Dan, I had a request like this many years ago with the SLA module version 5. There is no way to do this, in my opinion, without building bespoke workflow which is what I did. The trouble is it was a long time ago and I am having difficulty remembering what I did. However, I can recall that having created the initial target d/t, I then checked where it sat within the business rules defined. Then got workflow to adjust it to the end of day. In your scenario you could add two days and then get workflow to move it to the end of day. So having calculated the Target D/T you bespoke workflow will obtain just the date and add 17 hours to it to give you 5pm Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Daniel Bloom Sent: 01 February 2010 15:21 To: arslist@ARSLIST.ORG Subject: SLM 7.1 and business time add Question ** I need to define targets based on Calendar working days rather than hours. i.e. 2 days means that end of the second business day following today (a bank's defintion of business days). I don't see where that is (obviously) possible in SLM 7.1, has anyone else had to create this? I also need to use business time add to figure out a future date similarly. So far I can only get it to give me 8 a.m. (start of business day) and then adjust the date to 5 p.m. (their end of business day), even when calculating by days. Does this exist in 7.5? (it sounds specialized but as I say banks and many others use it as the definition of two business days for an OLA or SLA). thanks Dan _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.733 / Virus Database: 271.1.1/2654 - Release Date: 02/01/10 07:35:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Random Email Recipient
If you want to ensure no one manager is inundated, hold a count on the manager record of how many times they have been used. This could then become your selection criteria. The lowest count gets the next email. If you get complaints from the managers about the load being shared equally, you can show them the count details. If I remember correctly, the SHR:People form in ITSM 6 has a Manager flag so you don't need to do this in a separate form. You could just pick another manager from this form. Add a field to it to hold a count and you should be up and running. Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joseph Kasell Sent: 26 January 2010 12:46 To: arslist@ARSLIST.ORG Subject: Re: Random Email Recipient ** Lyle, Thank you for the response. We're tracking along the same lines about defining a group of managers to select from. My question is how to automate the selection of a random alternate manager. I was thinking about a separate form with a table from which to use a filter guide to walk through the table and select a manager. But then the question is making sure that the selection of a manager is done equitably so that no one manager is inundated. I may be making this more difficult that I should, and wanted to know how others may have approached this. Joseph Kasell Global IT Services Information Services Navy Federal Credit Union ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: AL not firing
When a window is opened as a dialog window the data does not appear automatically. Normally an active link has to retrieve it with a set fields action from the server using something passed up from the form that the dialog is opened from (in theory you could pass all data up from the form but, in my opinion, this is unlikely). So I would check to see if this is the case and if it is make sure your active link is firing after it. Firing on "window open" should be adequate as long as you have the sequence correct. When the window loaded option was introduced all Remedy developers had to go through their workflow and move the "window open" option to "window loaded" to get the functionality back. Only then to find it didn't work on dialog windows and had to go back and put workflow for dialog windows to "window open" again. Very often it was difficult to identify workflow specific to dialog windows, particularly with the ITSM product at that time, so most developers took the easy option to click both window open and window loaded. In my opinion this is an anomaly. If I want to set a value into a field say on a normal window, I have to fire the AL on window loaded. Yet the same action on a Dialog window has to be done on a window open! Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Martinez, Marcelo A Sent: 19 January 2010 22:22 To: arslist@ARSLIST.ORG Subject: Re: AL not firing ** "Display" is also checked. Thanks Chuck! Any other ideas? From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Charles Baldi Sent: Tuesday, January 19, 2010 4:18 PM To: arslist@ARSLIST.ORG Subject: Re: AL not firing ** Your AL needs to fire on "Display" because that is when the data is available. Window Open happens before your data is loaded. Regards, Chuck Baldi On Tue, Jan 19, 2010 at 4:43 PM, Martinez, Marcelo A wrote: Needs help figuring out why an AL is not firing. I have an AL that fires on the Change form when a user selects category tier 1. The action is to show a hidden page. Here's an example. IF CatTier1 = Network THEN show network testing page ELSE hidden IF CatTier1 = Software THEN show application testing page ELSE hidden IF CatTier1 = Telecomm THEN show telecomm testing page ELSE hidden Now... I am working on the "Approval Central" . if a user goes and views a change ticket that is pending his/her approval, clicks 'view', then Infrastructure Change, then clicks "View Change"... the corresponding testing tab (page) does not show up. I have gone into the CHG:Infrastructure Change form and made sure that the custom tabs (pages) are in the "Dialog View" view (which is the correct view that pops up when you hit the button).. I have looked at my Active Links and selected Execute On: Window Open But when I check the AL log I see that the AL I have created fails.. not sure why. The criteria is the same. I'd hate to have to write new workflow for performing the same functions. Thanks, Marcelo ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor:rmisoluti...@verizon.net <mailto:sponsor%3armisoluti...@verizon.net> ARSlist: "Where the Answers Are" _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.730 / Virus Database: 270.14.151/2633 - Release Date: 01/19/10 17:49:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: AR? ar.ini?
Hi Drew, Have you checked if the additional columns are way over to the right on the results list and out of view. This is what happened to me recently as an Administrator on a 6.3 system. I had two forms with no defined result list fields so by default got short description. I added fields to the results list and one form was fine but the other continued to show just short description. I eventually noticed that all the others were way over on the right and that short description was taking up the whole window. Brian Bishop -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Drew Shuller Sent: 15 January 2010 18:41 To: arslist@ARSLIST.ORG Subject: AR? ar.ini? I've got a strange problem. I have one user on a pc that can't see all the results list fields when opening a form. Only two are there, Request ID and Short Description. Other Remedy users can see all the columns that are set up for that form. Oddly enough, it's my Remedy Admin account that can't see the columns, but only when I'm logged into Windows as a regular user. When logged in as a sysadmin, the columns are there. But that's confusion because when logged into Windows as a non-sysadmin and Remedy not as an Administrator, I can see the columns. Are those columns part of the form definition file, or are they related to the AR or ar.ini file? I deleted all the files from the HOME directory that my Remedy Admin account was using, but for some reason it won't pick up the real form definition? Pretty much all my hair is gone on this one, I've pulled it out! Drew Shuller Soto Cano ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.730 / Virus Database: 270.14.149/2630 - Release Date: 01/18/10 07:35:00 No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.730 / Virus Database: 270.14.149/2630 - Release Date: 01/18/10 07:35:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
ARERR 9217
Hi All, I am having some problems on my Demo system on my laptop. I have installed the following. ARserver 7.5 patch 2 Mid-Tier 7.5 patch 2 with tomcat and IIS ITSM 7.5 patch 1 CMDB 7.5 patch 1 SLM 7.5 SRM 2.2 patch 3 Using SQL 2005 I have made the sample SRM data available and all the options bar one fail to work and give me the following error when accessed from the Mid-Tier. ARERR [9217] File not found. Either the file requested is not present or the URL supplied is bad The one that does work is the Password Reset which opens up the dialog window correctly. Any ideas on what might be causing this would be helpful. I don't want to create any new Service Requests as I want to keep the installation as OOTB so that I can test a migration of all products to 7.6 Many thanks Brian Bishop ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Data Management Tool for ITSM 7.6
No, I am just saying where you can find the spreadsheets which is what Barbara asked. When I used them recently I had to run the data management install to create the directory structure to get access to the spreadsheets. What I can't tell you is whether the data management console is part of the ITSM install or part of running the data management install as I didn't pay enough attention to it. What I can tell you is that the loading of the sample data into 7.6 didn't go as smoothly as it did in 7.5. A lot of the data threw up errors in the console. Brian Brian Bishop Goldstag Consultants Ltd +44(0)7973 746832 -Original Message- From: dcharters Date: Mon, 30 Nov 2009 18:00:48 To: Subject: Re: Data Management Tool for ITSM 7.6 Brian, Are saying that when using ITSM 7.6 you should not use the Dataloader tool in the ARS installer? On Mon, 30 Nov 2009 21:51:13 +, brian.bishop wrote > When you unzip ITSM 7.6 you will find a data management install. If > you run the install it will create a directory structure which > includes the 7.6 spreadsheets. You will find empty spreadsheets and > also sample ones loaded with sample data. It is exactly the same as > 7.5 but has a 7.6 directory as well. > > Brian > > --Original Message-- > From: Barbara Siebert > Sender: Action Request System discussion list(ARSList) > To: arslist@ARSLIST.ORG > ReplyTo: arslist@ARSLIST.ORG > Subject: Data Management Tool for ITSM 7.6 > Sent: Nov 30, 2009 19:04 > > Where can I find the spreadsheets for ITSM 7.6 to load the > foundation data? Patch 9005 is for ITSM 7.5 and will not load on a > 7.6 system. It says that you must have patch 3 or greater. Well, > 7.6 doesn't have a patch 3. > > Thanks for your assistance, > Barb > > Barbara Siebert > Senior Consultant > QMX Support Services > cell phone: 949-637-7522 > _ __ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the > Answers Are" > > Brian Bishop > Goldstag Consultants Ltd > +44(0)7973 746832 -- Open WebMail Project (http://openwebmail.org) ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Data Management Tool for ITSM 7.6
When you unzip ITSM 7.6 you will find a data management install. If you run the install it will create a directory structure which includes the 7.6 spreadsheets. You will find empty spreadsheets and also sample ones loaded with sample data. It is exactly the same as 7.5 but has a 7.6 directory as well. Brian --Original Message-- From: Barbara Siebert Sender: Action Request System discussion list(ARSList) To: arslist@ARSLIST.ORG ReplyTo: arslist@ARSLIST.ORG Subject: Data Management Tool for ITSM 7.6 Sent: Nov 30, 2009 19:04 Where can I find the spreadsheets for ITSM 7.6 to load the foundation data? Patch 9005 is for ITSM 7.5 and will not load on a 7.6 system. It says that you must have patch 3 or greater. Well, 7.6 doesn't have a patch 3. Thanks for your assistance, Barb Barbara Siebert Senior Consultant QMX Support Services cell phone: 949-637-7522 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" Brian Bishop Goldstag Consultants Ltd +44(0)7973 746832
Re: RKM 7.5
Hi Patrick, I have now solved this with some excellent help form a BMC Support person in India. We un-installed RKM 7.5 patch 1and installed RKM 7.5 instead. It worked fine with no problems at all. I doubt if I will move to patch 1 though! As I see BMC support criticised at times in ARlist, I would like to take this opportunity to thank them on their excellent response to my issue, which included a webex session on my server and 90 mins of the individuals time. Brian Bishop Goldstag Consultants Ltd +44(0)7973 746832 -Original Message- From: patrick zandi Date: Fri, 13 Nov 2009 17:26:51 To: Subject: Re: RKM 7.5 I have specifically installed this.. but was informed (because I was going too) following the readme, and installation instructions Very Carefully... and it will work perfectly. IF you have the older version previous 7.1, you have alot of deleting users, groups, forms, AL, workflow. On Fri, Nov 13, 2009 at 4:57 AM, wrote: > Hi all, > > Has anybody successfully installed RKM 7.5? I am trying to on a MS 2003 web > server running IIS 6 and failing. Issues I have had so far are:- > > 1. Install of integration with ITSM failed when it attempted to load the > RKM def file and supposedly got an error from it. > > 2. Tomcat fails on startup seemingly trying to connect to a database using > a login of RKMAdmin. > > I resolved 1. By importing all the def files manually with no problems. BMC > have confirmed that having done this my install should be ok. > > 2 is not resolved. Why is it trying to connect to a database when at no > time during the install did it ask for any details about a database? > > Any observations\suggestions would be appreciated. > > Many thanks > Brian > Brian Bishop > Goldstag Consultants Ltd > +44(0)7973 746832 > > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum > Sponsor:rmisoluti...@verizon.netARSlist: > "Where the Answers Are" > -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
RKM 7.5
Hi all, Has anybody successfully installed RKM 7.5? I am trying to on a MS 2003 web server running IIS 6 and failing. Issues I have had so far are:- 1. Install of integration with ITSM failed when it attempted to load the RKM def file and supposedly got an error from it. 2. Tomcat fails on startup seemingly trying to connect to a database using a login of RKMAdmin. I resolved 1. By importing all the def files manually with no problems. BMC have confirmed that having done this my install should be ok. 2 is not resolved. Why is it trying to connect to a database when at no time during the install did it ask for any details about a database? Any observations\suggestions would be appreciated. Many thanks Brian Brian Bishop Goldstag Consultants Ltd +44(0)7973 746832 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: SLA time Calculations
Hi Mark, You will need to do the following. 1. Create a date time field to hold the d/t a call is placed into Pending 2. Create a date time field to hold the d/t a call is taken out of Pending 3. Create an integer field to hold the time a call is in pending in seconds 4. Create an integer field to hold the time a call has been worked on in seconds 5. Build workflow that calculates the amount of time a call has been in pending, in seconds, when it is removed from pending and place the result in field at 3. Adding it to what is already there. 6. Create a date time field to hold the d/t a call moves into WIP the first time if you don't have one 7. Create as 6. Above for when call is Closed 8. Create a char field to hold epoch time a call has been worked on 9. Create workflow to calculate the time between a call going into WIP and going to Closed and place the result in field created at4. 10. Create workflow to take the pending seconds from the work seconds and convert the result to hours and mins and place the result in the field created at 8. The field holding hrs and mins is used for display purposes and the field holding the time in seconds allows you to work out average fix times. If you work a 9 to 5 day don't forget to you business time to calculate time differences. This should give you an idea of where to go if you don't have the SLA module. Brian Bishop Goldstag Consultants Ltd +44(0)7973 746832 -Original Message- From: "Brittain, Mark" Date: Mon, 19 Oct 2009 14:17:27 To: Subject: SLA time Calculations Hi All, Does anyone have a good way of tracking the work time of an issue? In my case the issue could be in a Status of Work in Progress, Pending or Closed. What I need to be able to determine is Closed-time minus Create Date minus Pending-time = Time-worked Status History does not work because the Status could go back and forth between Work in Progress and Pending several times during the life of the issue. Suspect this will get complicated but would like to keep this as simple as possible. ARS 6.3 patch 20 Thanks Mark Mark Brittain Remedy Developer NaviSite mbritt...@navisite.com<mailto:mbritt...@navisite.com> (315) 453-2912 x5418 (Phone) (315) 317.2897 (Cell) Reduce Cost of IT with Managed Hosting and Application Services from NaviSite. Visit www.NaviSite.com Today. This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: ARS 7.5 P2/ITSM Install Issue
I disagree, I have installed server 7.5 patch 2 with cmdb 7.5 patch 1 and ITSM 7.5.01 patch 1 without any issues in a windows environment with sql 2005. Do the server install and then ensure you have licences for all the products you want to install and the server. Then do a database back up and then install Atrium 7.5 patch 1. You can check your versions in the SHARE:Application_Properties form which I believe, but am not certain, is where the installer looks. Brian Bishop -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Raj Sent: 14 August 2009 17:16 To: arslist@ARSLIST.ORG Subject: Re: ARS 7.5 P2/ITSM Install Issue Yup, Janie is right. Install AR System 7.5.00 Patch 002 , then there is Patch 002 for CMDB 7.5.00 . Before Installing CMDB you need to license AR System Server and all the licenses you need and then do the CMDB (7.5.00 P 2)install and then ITSM Suite. On Aug 14, 9:58 am, Janie Sprenger wrote: > What version is your CMDB on ? I believe this needs to be on Patch 2 as > well. > > HTH, > > Janie > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Mark Lev > Sent: Friday, August 14, 2009 6:24 AM > To: arsl...@arslist.org > Subject: ARS 7.5 P2/ITSM Install Issue > > ** > > Good Morning, > > Windows Server, SQL Server, ARS 7.5/P2, ITSM 7.5 > > ARS Install 7.5 and patch 2 installed OK. > > When trying to install ITSM it says P2 isn't installed and stops. > > Anyone seen this before? > > Thanks, > > Mark > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > ___ > 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" No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.392 / Virus Database: 270.13.56/2302 - Release Date: 08/14/09 06:10:00 No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 8.5.392 / Virus Database: 270.13.56/2302 - Release Date: 08/14/09 06:10:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Blank Atrium Core Console
Hi Christopher, Thanks for this. The KB article identified the problem which was the atrium directory hadn't been built. I suspect that this was due to my doing an upgrade/overwrite of my 7.1 system with the 7.5 install. Thus ending up with a 7.1 directory structure rather than a 7.5. It wouldn't re-build it so I had to extract it from the zip file and build it manually. Many thanks Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: 03 August 2009 00:16 To: arslist@ARSLIST.ORG Subject: Re: Blank Atrium Core Console ** There is a long list of steps to obtain possible fixes detailed by BMC Support in KB article 20014080 on their support web. The #3 item on the first list was all I needed here for IE 7 and IE 8; it says it was resolved by AtriumCore 7.5.00 Patch002, but since that was the only version we installed, that is not true. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brian Bishop Sent: Sunday, August 02, 2009 11:37 AM To: arslist@ARSLIST.ORG Subject: Blank Atrium Core Console ** Hi All, Windows Environment SQL 2005 ARserver 7.5 patch 2 CMDB 7.5 patch 1 ITSM 7.5.01 patch 1 I have a problem with a blank Atrium Core Console on the above installation. It opens fine and gives me the blue background but the options aren't built. I had no errors in the install logs and am baffled as to what could be causing this as the previous installation I did which was the same, but for ARServer 7.5 being patch 1, the console worked fine. Any suggestions would be welcome. Many thanks Brian Bishop _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.392 / Virus Database: 270.13.38/2274 - Release Date: 07/31/09 05:58:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Blank Atrium Core Console
Hi All, Windows Environment SQL 2005 ARserver 7.5 patch 2 CMDB 7.5 patch 1 ITSM 7.5.01 patch 1 I have a problem with a blank Atrium Core Console on the above installation. It opens fine and gives me the blue background but the options aren't built. I had no errors in the install logs and am baffled as to what could be causing this as the previous installation I did which was the same, but for ARServer 7.5 being patch 1, the console worked fine. Any suggestions would be welcome. Many thanks Brian Bishop ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Open Spaces ITSM Recruitment in London - BMC ITSM Opportunities in the UK
Hi Ross, Is this the job you were going to put my CV in for at CapGemini? If it is has there been any response? If it isn't can I be considered for it? Best regards Brian Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of remedypeople Sent: 22 July 2009 11:42 To: arslist@ARSLIST.ORG Subject: Open Spaces ITSM Recruitment in London - BMC ITSM Opportunities in the UK Hi there, it's Ross here from Open Spaces ITSM Recruitment in London. A new role has just come in that may be of interest to you, I am currently looking for 2 experienced BMC Remedy ITSM Consultants for a permanent role at a major Global Systems Integrator. You can be based anywhere in Europe, the role will cover the whole of Europe with work 60% in the UK, 30% France and 10% Germany, Poland etc. Expect a salary of 60-80k with a benefits package of approx + 19%. Here are the full details: Develop service management solutions based around the BMC ITSM application Take lead solution architect role Be a recognised expert on ITSM deployment Build industry leading, deliverable and profitable solutions that are closely aligned with the clients objectives and culture, supported by clear sales messages, centred on the ITSM module set Support the sales team in the pre-qualification process Evaluate customer requirements and translate them into operational services Essential Skills: Two years exposure to the ITSM application (incident, problem, change, asset and SLM) Understanding of the capabilities of the standard ITSM application 10 years delivering service management solutions ITIL Certification to Manager level Desirable Skills: French language skills RAC Certification from BMC .Able to work in the EU unrestricted If this is of interest, please contact me ASA, if you're not but know of any other Remedy or ITSM people that are looking please let me know, and if I dont know them and place them Ill be sending you a case of Champagne. Speak soon and best regards Ross McMahon Senior Account Manager For and on behalf of Open Spaces Ltd Tel: +44 (0) 1932 562900 Mob: +44 (0) 7940 329433 Fax: +44 (0) 1932 567160 EMail: r...@openspaces.co.uk www.openspaces.co.uk -- View this message in context: http://n2.nabble.com/Open-Spaces-ITSM-Recruitment-in-London---BMC-ITSM-Opportunities-in-the-UK-tp3302328p3302328.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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" Checked by AVG - www.avg.com Version: 8.5.375 / Virus Database: 270.13.22/2253 - Release Date: 07/21/09 18:02:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Application Entry points not doing anything
Hi Jason, I have seen the same issue on a 7.5 patch 1 install user tool. I spent quite some time trying to figure out why the links to the Incident and Problem management consoles did nothing yet the other links worked. It was from a user tool installed on the server, windows 2003 running 7.5 and ITSM 7.5, but I found that if I logged on as the same user, Demo, from my laptop running XP pro it worked. I sat looking at it for some time but couldn't figure it out. I know find, 2 weeks later, that it works on the server now! However I now have another issue where I have a user who cannot see any of the links to the Asset consoles, even though they are in the correct roles, unless I put them in the Administrator group. I have checked permissions on the forms and all is fine. So if there is anybody out there who understands how this works, please share. My installation is Server 7.5 patch 1 on a windows 2003 server using Oracle 10g. User tool is 7.5 patch 1 as well. Full ITSM 7.5.01 as well. Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jason Sent: 01 July 2009 07:53 To: arslist@ARSLIST.ORG Subject: Application Entry points not doing anything ** Has anyone seen this (and have a fix or workaround) on the Windows User Tool? Using 7.1 P5 on XP workstations. We have 2 computers that display the application entry points, but nothing happens when you click on them. Server is 7.1 P5 Tried removing the tool and re-installing Tried to copy the ar_wut.js from a good machine to the bad Any thoughts before I tell them to reinstall the box? Thanks Jason _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ Checked by AVG - www.avg.com Version: 8.5.375 / Virus Database: 270.13.1/2211 - Release Date: 06/30/09 11:37:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: ITSM Patch 3 (UNCLASSIFIED)
But if you look carefully you will see that this product actually consists of ITSM Applications version 7.5.01! Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Tony Worthington Sent: 26 June 2009 13:44 To: arslist@ARSLIST.ORG Subject: Re: ITSM Patch 3 (UNCLASSIFIED) It is listed in the EPD section if you are licensed under the new suite model. "BMC Remedy IT Service Management Suite." I suggest a conversation with your sales contacts if you are not familiar... Tony Worthington Sr. Technical Analyst Kohl's Department Stores N56 W17000 Ridgewood Drive Menomonee Falls, WI 53051 262.703.7763 (phone) <mailto:tony.worthing...@kohls.com> tony.worthing...@kohls.com <http://www.kohls.com/> www.kohls.com From: Peter Romain To: arslist@ARSLIST.ORG Date: 06/26/2009 05:44 AM Subject: Re: ITSM Patch 3 (UNCLASSIFIED) Sent by: "Action Request System discussion list(ARSList)" _ Can you tell me where to find this patch as it doesn't show in the EPD or Remedy patch areas. > Not patch three ... version 03 of the 7.5 Suite. > > Analytics 2.5.01 (from 2.5.00) > Dashboards 2.5.01 (from 2.5.00) > > > Tony Worthington > Sr. Technical Analyst > Kohl's Department Stores > N56 W17000 Ridgewood Drive > Menomonee Falls, WI 53051 > 262.703.7763 (phone) > tony.worthing...@kohls.com > www.kohls.com > > > > > From: > "TUCK, JAMES M CTR DISA JSSC" > To: > arslist@ARSLIST.ORG > Date: > 06/25/2009 10:28 AM > Subject: > ITSM Patch 3 (UNCLASSIFIED) > Sent by: > "Action Request System discussion list(ARSList)" > > > > Classification: UNCLASSIFIED > Caveats: NONE > > Patch 3 for ITSM Suite 7.5 is available on the EPD site. > > James M. (Mike) Tuck > > Senior Engineer - Software Systems > Verizon Federal Network Systems, LLC > > Classification: UNCLASSIFIED > Caveats: NONE > > ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > ** > CONFIDENTIALITY NOTICE: > This is a transmission from Kohl's Department Stores, Inc. > and may contain information which is confidential and proprietary. > If you are not the addressee, any disclosure, copying or distribution or > use of the contents of this message is expressly prohibited. > If you have received this transmission in error, please destroy it and > notify us immediately at 262-703-7000. > > CAUTION: > Internet and e-mail communications are Kohl's property and Kohl's reserves > the right to retrieve and read any message created, sent and received. > Kohl's reserves the right to monitor messages by authorized Kohl's > Associates at any time > without any further consent. > ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" _ CONFIDENTIALITY NOTICE: This is a transmission from Kohl's Department Stores, Inc. and may contain information which is confidential and proprietary. If you are not the addressee, any disclosure, copying or distribution or use of the contents of this message is expressly prohibited. If you have received this transmission in error, please destroy it and notify us immediately at 262-703-7000. CAUTION: Internet and e-mail communications are Kohl's property and Kohl's reserves the right to retrieve and read any message created, sent and received. Kohl's reserves the right to monitor messages by authorized Kohl's Associates at any time without any further consent. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.92/2202 - Release Date: 06/26/09 05:53:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" <>
Re: ITSM 7.5 Install
Hi Joe, I have sorted my issue out. The problem seems to be with running the user tool on the server which is windows 2003. When I connect with the user tool from my laptop it works fine and will open the Incident and Problem management consoles. When I do it from the user tool on the server, they don’t work. Go figure!!! Best of luck with your issues! But keep in the back of your mind that it is these strange behaviours which keep us in work!!! Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: 15 June 2009 20:25 To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.5 Install ** I am battling with almost similar problems on AIX. After upgrading to ARS 7.5, some of my stuff stopped working. My customer here is not using ITSM but ITSP, and the ITSP application itself seems to be working but the upgrade has messed up:- 1) The plugins - Admin and reporting don't seem to work anymore 2) SRM application seems to not work as the Request Entry page's DV field doesn't seem to work. 3) The armonitor daemon for some reason doesn't seem to recognize the server has successfully started. (WE are MAINLY concerned about this one) 4) There might be other problems too that we are yet to uncover :-) Joe _ From: Brian Bishop To: arslist@ARSLIST.ORG Sent: Monday, June 15, 2009 12:39:56 PM Subject: Re: ITSM 7.5 Install ** Hi Robert, This was a fresh install using the 7.5 patch 1 installer. I have checked logs and there are no errors or workflow shown as firing when the Incident or Problem management console links are selected. There are no error messages shown and if I select active link logging, there is nothing in the log file. All other consoles on the home page open with no problems. If I select the Entry Point it opens with no problems. I have re-started the server as well. I have tried importing the workflow again but I think this has made things worse as I still don’t get the Problem management Console opening but when I select the Change Management console Link I get that opening along with the Problem management consoles. I can find no patch 3 for ITSM 7.5.1 products on the patch download page. If you go to EPD there is an ITSM 7.5.3 listed there but when you go into it all products seem to be 7.5.1. I have a feeling that I will need to restore the database prior to loading ITSM products and start again. Any ideas would be welcomed! Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Molenda Sent: 15 June 2009 16:03 To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.5 Install ** Was this a fresh install of the 7_5_Patch 1 installer - or a patch install..?? Also BMC release ITSM 7_5_Patch 3 the begining of June :( might want to put that patch on to see. Are you getting ANY error message? What does an Act Link Trace show? HTH Robert Molenda 2009/6/15 Brian Bishop ** Hi All, I have just completed the loading of ITSM7.5 patch 1 to a windows server 2003 with oracle 10g database. I have a strange problem where the Incident and Problem Management consoles will not open from the link on the home page in the user tool. Yet if I search for the entry point from the Open icon and select it, the console quite happily opens. All other consoles for the user, appadmin, open as you would expect. Any ideas as to what may be at fault? Thanks Brian Bishop _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.71/2178 - Release Date: 06/15/09 17:54:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: ITSM 7.5 Install
Hi Robert, This was a fresh install using the 7.5 patch 1 installer. I have checked logs and there are no errors or workflow shown as firing when the Incident or Problem management console links are selected. There are no error messages shown and if I select active link logging, there is nothing in the log file. All other consoles on the home page open with no problems. If I select the Entry Point it opens with no problems. I have re-started the server as well. I have tried importing the workflow again but I think this has made things worse as I still don’t get the Problem management Console opening but when I select the Change Management console Link I get that opening along with the Problem management consoles. I can find no patch 3 for ITSM 7.5.1 products on the patch download page. If you go to EPD there is an ITSM 7.5.3 listed there but when you go into it all products seem to be 7.5.1. I have a feeling that I will need to restore the database prior to loading ITSM products and start again. Any ideas would be welcomed! Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Robert Molenda Sent: 15 June 2009 16:03 To: arslist@ARSLIST.ORG Subject: Re: ITSM 7.5 Install ** Was this a fresh install of the 7_5_Patch 1 installer - or a patch install..?? Also BMC release ITSM 7_5_Patch 3 the begining of June :( might want to put that patch on to see. Are you getting ANY error message? What does an Act Link Trace show? HTH Robert Molenda 2009/6/15 Brian Bishop ** Hi All, I have just completed the loading of ITSM7.5 patch 1 to a windows server 2003 with oracle 10g database. I have a strange problem where the Incident and Problem Management consoles will not open from the link on the home page in the user tool. Yet if I search for the entry point from the Open icon and select it, the console quite happily opens. All other consoles for the user, appadmin, open as you would expect. Any ideas as to what may be at fault? Thanks Brian Bishop _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.69/2176 - Release Date: 06/15/09 05:54:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
ITSM 7.5 Install
Hi All, I have just completed the loading of ITSM7.5 patch 1 to a windows server 2003 with oracle 10g database. I have a strange problem where the Incident and Problem Management consoles will not open from the link on the home page in the user tool. Yet if I search for the entry point from the Open icon and select it, the console quite happily opens. All other consoles for the user, appadmin, open as you would expect. Any ideas as to what may be at fault? Thanks Brian Bishop ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: Need to make an error message more friendly.
Hi Nyall, Assuming you are pushing the value of the field Menu on form A1 to the field Menu on form A2. First of all ask yourself is it necessary to have a pattern match of $MENU$ on the menu field on form A2. If it is, then ask yourself why the values for Menu in form A1 don’t match those in form A2. If there is a valid reason that 2008A can appear in form A1 but not in A2, then what do you want to happen? Logically you don’t want an entry to be created in form A2. So, if you don’t want an entry created in form A2 when the Menu value in form A1 is 2008A, you need to create some workflow that checks if the value in form A1 is also valid for form A2. If the check confirms it is valid, do the push, if it isn’t don’t do the push. If you get the workflow correct the user will not be aware that this decision action is happening and they will never get this obscure message again. If however you do want the entry to be created then you need to either replace, or remove, the menu value in form A1 prior to the push to form A2. The same workflow as above to check if it is valid but rather than not doing the push, do it with the 2008A replaced with a valid value or remove it. This will be decided by whether the field menu in form A2 is a required field or not. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of MCCAVITT Nyall Sent: 27 May 2009 15:38 To: arslist@ARSLIST.ORG Subject: Need to make an error message more friendly. ** Hi, Environment: ARS V7.1 (Solaris) running with a remote Oracle 10g database. One of my users has complained that the standard error message from Remedy for a certain condition is not very user-friendly and I cannot see an easy way of making the message more friendly. Any suggestions would be welcome. The simplified situation is this: One one form, called A1, for this example, I have a field called 'Menu' which has a menu attached to it. The values in this menu are 2008A, 2008B, 2008C and 2008D. There is a button on this field which when clicked on copies the data from form A1 to form A2 by means of an Active Link. This second form also has a field called 'Menu' with an attached menu, but in the case the menu values are 2008B, 2008C, 2008D i.e. the value 2008A is missing from the menu on the form A2. When an entry is being created on form A1 with a value of 2008A in the 'Menu' field and then the button is clicked on the user receives the following error message: ARERR [306] Value does not fall within the limits specified for the field : (Pattern - $MENU$) : 536870913 The error message itself is clear enough as to why the error has occurred but the problem is that is uses the Database ID to identify the field where the problem is. This is OK for an Administrator but the user would like to have the name of the field i.e. the database label value. Personally I would like to have the database label value, the form name and the data value that has caused this error. Thanks in advance. Nyall _ Nyall McCavitt CND/COE/VI/SQ (BE.25) Tel: +33 (0)1 69 88 73 02 This message and any files transmitted with it are legally privileged and intended for the sole use of the individual(s) or entity to whom they are addressed. If you are not the intended recipient, please notify the sender by reply and delete the message and any attachments from your system. Any unauthorised use or disclosure of the content of this message is strictly prohibited and may be unlawful. Nothing in this e-mail message amounts to a contractual or legal commitment on the part of EUROCONTROL, unless it is confirmed by appropriately signed hard copy. Any views expressed in this message are those of the sender. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.339 / Virus Database: 270.12.40/2135 - Release Date: 05/27/09 07:50:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" <>
Re: Calculate Gaps in Schedule
Hi Lisa, You could look at taking the on call end date of person A and subtracting it from the on call start date of person B. If the end result is say greater than an hour, you could advise somebody. In fact you could make this part of the process when entering the dates so that an individual is made aware that their on call is starting at an unacceptable time after their colleagues finishes. You could make it a warning or an error depending on the severity of it. I would probably give them an overriding option which shows that they are aware of the gap and then email the groups manager in the background. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: 20 May 2009 17:33 To: arslist@ARSLIST.ORG Subject: Calculate Gaps in Schedule ** Is there an easy way I can notify a user if there are gaps in his on call schedule? If person A from Group A is on call from May 1st 12:00am to May 5th 12:00am And Person B from Group A is on call from May 7th 12:00am to May 12th 12:00am I'd like to create some sort of calculation to capture the "gaps" for a user, to warn them that nobody is on call from May 5th at 12:01am to May 6th at 11:59pm. It might not even have to be that detailed, maybe just a "yes" or "no" that there are gaps and I can just notify the admin and they would have to check it themselves….. The data is on a table so I could do a loop and the Date Fields are Date/Time Fields….. ARS 7.01 Patch 3 Windows 2003 Oracle 10i Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.329 / Virus Database: 270.12.34/2121 - Release Date: 05/18/09 17:55:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" <>
Re: Filter Table Looping - Phase Issue
Hi Bala, Many years ago I had to set DSO up to distribute to one or more servers. The list was variable but was defined by the group a case was assigned to. I added a field to the help desk form to hold the servers that the DSO transfer needed to be sent to. This field was completed by the selection of an assigned group and checking which server was their primary server. If the server concerned wasn’t already specified in the field it was added. Then filters firing the specific DSO action for each server would check this field. If the server existed in the list the filter would fire. The field was pushed to all servers to facilitate the return of updates. This was all done as independent copies. This only left the issue of locking down the records. So when the workflow retrieved the primary server for the currently assigned group, it was also placed in its own field and was used to activate active link workflow to stop updating of the record on the wrong server. Today you could do something similar with Assigned Group as well. A method like this can all be done without requiring a table. Your table query defining the servers you need to do a DSO transfer to, could be used to complete the field instead. And as it is driving workflow it doesn’t need to be full server names. It just needs to be a code that tells you it is server A as opposed to server B. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Bala Patel Sent: 15 May 2009 18:57 To: arslist@ARSLIST.ORG Subject: Re: Filter Table Looping - Phase Issue ** All, I had a question about Filter table looping and phases. I am creating a table field on a form that will be used to DSO tickets to each selected server that has been added into the tables form. When I save the ticket, the table field should be looped through. A distributed transfer should be performed for each server that is in the loop. The issue I am having is that I have to add the `! to the end of the filter which makes everything happen during Phase I. The Distributed Transfer fails since it is happening in phase I. The DSO transfer should happen during a later phase and not phase I. If I take the `! off the filter, then the filter loops and uses only the first record value for each record in the table field. Does anyone know of another method to do this or a way around this? ARS 7.1 Custom applications SQL 2005 Windows 2003 Server Thanks very much. Bala _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.329 / Virus Database: 270.12.31/2116 - Release Date: 05/15/09 06:16:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" <>
Re: EE 7.1 p006 Install Issues
Hi William, My understanding is that it is cumulative. It is the method I use 99% of the time and have never had issues with it. I have also jumped like you are proposing as well. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow Sent: 14 May 2009 16:33 To: arslist@ARSLIST.ORG Subject: Re: EE 7.1 p006 Install Issues ** Remind me again - when you use the file install replacement method is it cumulative? For example - if I install 7.1 p001 can I just do the file replacment method directly to 006? Or is it 1 > 2 > 3 > 4 > 5 > 6. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com <http://www.stratacominc.com/> Blog, www.williamrentfrow.com <http://www.williamrentfrow.com/> 715-410-8156 C _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Thursday, May 14, 2009 10:18 AM To: arslist@ARSLIST.ORG Subject: Re: EE 7.1 p006 Install Issues ** What I find bad is that the installer fails if the links already exist. That link should exist from the ARS Server installation. Fred From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow Sent: Thursday, May 14, 2009 9:58 AM To: arslist@ARSLIST.ORG Subject: Re: EE 7.1 p006 Install Issues That's plan D :) BMC has responded this morning with some manual steps we needed to take because the installer was presuming some file permissions. We're tried it out and naturally it blew up. The Unix admins are looking at it now - needless to say this is a fairly secure environment and BMC"s fairly loose security policy for installers is not remotely possible here. I do find it interesting that they changed the installer to exit if these links can't be made. The prior patches didn'twe may need to revert. William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com <http://www.stratacominc.com/> Blog, www.williamrentfrow.com <http://www.williamrentfrow.com/> 715-410-8156 C _ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Brian Bishop Sent: Thursday, May 14, 2009 5:28 AM To: arslist@ARSLIST.ORG Subject: Re: EE 7.1 p006 Install Issues ** Hi William, Can you not do the patch upgrade via the file method instead? I very rarely use the patch installer as I find I have better control with the file method. I can move the files to be replaced into a directory called pre_patch6 and if the patch creates any issues I can take it out quite easily. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" <>
Re: EE 7.1 p006 Install Issues
Hi William, Can you not do the patch upgrade via the file method instead? I very rarely use the patch installer as I find I have better control with the file method. I can move the files to be replaced into a directory called pre_patch6 and if the patch creates any issues I can take it out quite easily. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow Sent: 13 May 2009 19:50 To: arslist@ARSLIST.ORG Subject: EE 7.1 p006 Install Issues ** Today has not been good for installs The email engine 7.1 patch 006 will not install on Solaris with a remote Oracle database. This is a non-root install. The installer fails when it tries to create a link to the arsystem.cat file. This file has been made writable/executable by the user ID doing the install. Install log excerpt below We have had our Unix admins follow the instructions for creating the link which is in the installer instructions and the installer still fails at this point. Prior versions of the EE install did not fail and exit at this point - they simply told the user to fix this after the install. It's rather annoying that BMC changed the installer in that fashion and I have no ability to revert to an earlier version because we are coordinating matching installs with an outside development company who is building to a certain specification. Due to SOX and security reasons there is no instance where we will be allowed to do this install as root either (Excerpt below has path names changed for customer privacy) May 13 13:19:18->WARNING: /usr/lib/locale/C/LC_MESSAGES/arsystem.cat link does not exist. May 13 13:19:18->Please create a link /usr/lib/locale/C/LC_MESSAGES/arsystem.cat with the user having write permissions to it. May 13 13:19:18->You can use following command to do that: May 13 13:19:18->ln -s /xxx/yyy/a00/ar/servername/locale//arsystem.cat /usr/lib/locale/C/LC_MESSAGES/arsystem.cat May 13 13:19:18->Installation can not proceed until /usr/lib/locale/C/LC_MESSAGES/arsystem.cat exists and writeable! May 13 13:19:18->Press enter key once you are done May 13 13:22:28-> William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com Corporate Website, www.stratacominc.com Blog: www.williamrentfrow.com 715-410-8156 C _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.329 / Virus Database: 270.12.27/2112 - Release Date: 05/13/09 07:04:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" <>
Re: What would $--1$ relate to?
Dave, The value $--1$ is a Remedy keyword conversion that means $NULL$. So in your case it is checking that the fields are NULL. Here is a list of keywords conversions I compiled many years ago which may have been added to since doing it. $-1$ = $USER$ $-2$ = $TIMESTAMP$ $--1$= $NULL$ $-6$ = $SERVER$ $-5$ = $SCHEMA$ $-0$=$DEFAULT$ $-4$=$DATE$ $-14$=$LASTCOUNT$ $-13$=$LASTID$ $-3$-$TIME$ $-7$=$WEEKDAY$ Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Barber, David Sent: 07 May 2009 13:44 To: arslist@ARSLIST.ORG Subject: What would $--1$ relate to? ** Seen on a macro/search - field 1 = $--1$ and also a little later in the same search - field 2 = $--1$ The first field is an assignee, but the second is just a flag. Not exactly obvious what it does at all. Any ideas? Ta Dave This e-mail has been scanned for viruses by the Cable & Wireless e-mail security system - powered by MessageLabs. For more information on a proactive managed e-mail security service, visit http://www.cw.com/uk/emailprotection/ The information contained in this e-mail is confidential and may also be subject to legal privilege. It is intended only for the recipient(s) named above. If you are not named above as a recipient, you must not read, copy, disclose, forward or otherwise use the information contained in this email. If you have received this e-mail in error, please notify the sender (whose contact details are above) immediately by reply e-mail and delete the message and any attachments without retaining any copies. Cable and Wireless plc Registered in England and Wales.Company Number 238525 Registered office: 3rd Floor, 26 Red Lion Square, London WC1R 4HQ _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.287 / Virus Database: 270.12.21/2101 - Release Date: 05/07/09 05:57:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" <>
Re: Filter Phasing and Escalations
Hi Lyle, I always take the old fashioned approach with escalations. That is to use the escalation to just “touch” the record and then get a filter to pick up that touch and do the work. This would normally be through a filter guide unless I only have one action to take. So the steps I go through is as follows. 1. Create a display only selection field on the form which the escalation will set if the escalations qualification is met. 2. Create a filter, that runs at 0, to pick up this field setting and do the work. If there are several things to do I may use a filter guide. 3. Add a final action to the filter to do a go to Execution order 1001 to ensure none of the other filters run. This has two benefits. Reduces the work to be done and ensures no error messages stop the process. This does mean that you must keep filter Execution order 0 for this type of work only but I haven’t found that to be a problem personally. Brian Bishop Goldstag Consultants Ltd tel: +44 (0)7973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Lyle Taylor Sent: 05 May 2009 02:57 To: arslist@ARSLIST.ORG Subject: Re: Filter Phasing and Escalations ** Let me clarify a bit. The documentation states that you can add the Run Process action Application-Release-Pending between each of the actions to get what I’m looking for and mentions that it can be used in escalations. However, since it normally runs in phase 3, you have to use the special filter naming convention to override filter phasing for it to be applied properly between the push fields actions. I guess my question boils down to this: do filter phases apply in escalations, and if they do, can you add `! to the escalation name to override phasing just like you do with filters? Thanks, Lyle From: Lyle Taylor Sent: Monday, May 04, 2009 4:05 PM To: 'arslist@ARSLIST.ORG' Subject: Filter Phasing and Escalations Hi All, Can anyone tell me if filter phasing applies to escalations? I have a three-step process involving two forms, and I need to guarantee that certain actions happen in a specific order. I’m also trying to process records in batches, so I have an escalation that does something like this: 1. Set the status of all records in Form A to “Process” 2. Set the field “Process Now” in Form B 3. Set the status of all records in Form A whose status is still “Process” to “No Configuration Matched” Basically, Form A contains records to be processed, and new records can be added to it at any time. Form B contains configurations that map back to zero or more records in Form A. At intervals, I set the status of all new records in Form A to Process. Then I trigger the processing of those records from Form B by setting a field that triggers the processing workflow. As part of that, the status of all records that got processed get set to a status that indicates they have been processed. I then want to set the status of any remaining records that were tagged for processing but that didn’t match any configurations in Form B to “No Configuration Matched”. So, the question is, how can I guarantee that all records get processed in action 1 before action 2 gets processed, and that all records affected by processing related to action 2 (including affected records in Form A) get processed before action 3 fires? Does that make sense? Thanks, Lyle NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.287 / Virus Database: 270.12.17/2095 - Release Date: 05/04/09 06:00:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" <>
Re: SUBSTRC using 3rd parameter
Andreas, You should find a replace will do this for you. Just try REPLACE ($field name$,”.”,””) Brian Bishop Goldstag Consultants Ltd tel: 07973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Andreas Munch Sent: 07 April 2009 09:59 To: arslist@ARSLIST.ORG Subject: SUBSTRC using 3rd parameter ** Hey everyone ARS 6.03.00 MSSQL 2005 Problem: Actually this proberbly is a novice question, but… I'm trying to remove the "."'s from the ARS Version information, pushing it to a Form containing users client version. This version information comes as a string eg. "6.03.00" or "7.1.00". For comparison of client versions I need to remove the "."'s from then string ending up with only digits which I then can assign to an integer field. I'm using then command (for the first part) SUBSTRC($Version$, 0, STRSTRC($Version$, ".")-1) but are getting an error message as: "Unexpected character (ARERR 2291) zIntVersionMajor [Assign line error at position 29]". If I'm trying to only provide the two first parameters I'm not getting the error message, but the third one is the error trigger. Trying to do other stuff it seems like I'm not allowed to use the 3rd parameter. What can be then mistake I'm doing while using the SUBSTRC function with all 3 parameters causing then error message? A. Munch __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.283 / Virus Database: 270.11.44/2044 - Release Date: 04/06/09 18:59:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" <>
Re: Am I making this more difficult than it is?
Hi Lisa, I would suggest you want to check if either the start date or end date falls within the date range used. Thus to do this you would need the following. (“Start date of record being submitted” => “Start date of record submitted” AND “Start date of record being submitted” =< “End date of record submitted”) OR (“End date of record being submitted” => “Start date of record submitted” AND “End date of record being submitted” =< “End date of record submitted”) This would tell you if either the start date or end date fall within the range already allocated. Brian Bishop Goldstag Consultants Ltd tel: 07973 746832 <http://www.linkedin.com/in/brianpbishop> Linkedin From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: 03 April 2009 19:12 To: arslist@ARSLIST.ORG Subject: FW: Am I making this more difficult than it is? ** I have a record with a Start Date field of: 4/12/2009 12:00:00 AM and an End Date field of: 4/30/2009 12:00:00 AM. If someone were to create another record with a Start Date of: 4/1/2009 12:00:00 AM and an End Date field of 4/15/2009 12:00:00 AM, I want it to error because this would "overwrite" (not really) the other record. This is for my On Call system. Therefore, if these 2 records are allowed to exist, you would have more than one person on call (as a primary) for the same dates (4/12, 4/13, 4/14 and 4/15). Hope this makes sense! I actually have these records on a table and I would like to walk through the table to make sure the records with the Start Date field: 4/1 and End Date field: 4/15 does not get created. AR System 7.0 Oracle 10g Windows 2003 Server Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" html___ No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.5.283 / Virus Database: 270.11.40/2039 - Release Date: 04/03/09 06:19:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" <>
Re: Wildcard question
Hi Mark, If you want to make sure that it is a maximum of 8 digits do the following. Do a a/l set fields into an display only integer field of LENGTHC($field name$) Follow it up with a second a/l that has a qualification of integer field is >8 and throws an error message This will allow anything from 0 to 8 characters. If I want to ensure a character field is numeric only I do the following. a/l or filter set fields into a display only char field REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPL ACE($ISSINumber$, "0", ""), "1", ""), "2", ""), "3", ""), "4", ""), "5", ""), "6", ""), "7", ""), "8", ""), "9", "") follow this up with either a second action checking length and if it is greater than 0 there must be other characters beside numeric, or check if it is NULL. The replace will take away all numeric values and if anything is left it can't be purely numeric. For your second problem check if it is E% or I% if it isn't throw an error message. If it is then check if the field is __.% That is two underscores a full stop and then % for anything. All these checks will need to be a NOT 'fieldname' LIKE Brian Bishop Goldstag Consultants Ltd tel: 07973 746832 -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Mark Milke Sent: 19 February 2009 16:05 To: arslist@ARSLIST.ORG Subject: Wildcard question Hi Listers, I'm still on ARS 6.3. I need to make an AL that checks if a value of a char fields is made of max. 8 digits. I did this: 'fieldname' LIKE "[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]" but this works only if I enter exact 8 digits... Then I need to check if the value in the char field begins with E or I, the second character is alphanumeric and the third character is a "." The lenght of the value doesn't matter in this case. I'm trying: ('fieldname' LIKE "E[A-Z].%") OR ('fieldname' LIKE "I[A-Z].%") but it fails. What am I missing here? Thanks, Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" No virus found in this incoming message. Checked by AVG - www.avg.com Version: 8.0.237 / Virus Database: 270.10.25/1958 - Release Date: 02/18/09 20:55:00 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
Re: permissions issues again
Hi Gary, Have you tried adding the submitter group to the fields concerned with write access? You original email suggests that submitter doesn't have write access. I believe Remedy will only check on the submitter and allow write access if the submitter group is on the field. Brian Bishop Tel: +44(0)7973 746832 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: 30 June 2008 21:01 To: arslist@ARSLIST.ORG Subject: Re: permissions issues again ** So far just one user, but no other users which are set up for read only access have tried updating one of their tickets yet. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, June 30, 2008 2:22 PM To: arslist@ARSLIST.ORG Subject: Re: permissions issues again Ok so the questions all answered yes... Is it all users or just this one user? _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Monday, June 30, 2008 12:17 PM To: arslist@ARSLIST.ORG Subject: Re: permissions issues again ** No luck. Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W Sent: Monday, June 30, 2008 10:05 AM To: arslist@ARSLIST.ORG Subject: Re: permissions issues again Just to check ... User is the submitter (field 2) of the record? The field in question has Submitter (with R/W rights) in the permissions? The server is set for Submitter Mode Locked? Fred _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gary Opela (Corporate) Sent: Monday, June 30, 2008 9:57 AM To: arslist@ARSLIST.ORG Subject: permissions issues again I have a user who has a read license and is unable to modify her own ticket. The fields on which she is erroring have Public read, and then an explicit group with modify rights. The user is a member of that explicit group. Also, the Allow any user to submit flag is checked. Yet, my user still receives: You do not have a right license, and Unable to modify field: Status errors. Any idea which subtlety I'm missing? Thanks, Gary Opela, Jr., RSP Remedy Engineer Leader Communications, Inc. http://www.5pointleader.com http://www.lcibest.com Best Product, Best People, Best PriceTM An ISO 9001:2000 Certified, CMMIR Level 3 Rated Company __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html_Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html_Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Has any one used MS SQL Express edition 2005 on arserver 7.1?
I have Version 7.1 installed on my laptop with MS SQL express 2005. It works fine. Only issue I had was with identifying the server. My install expected \SQLEXPRESS after my laptop name which is what I used when installing SQL. It was actually easier than using full blown SQL! Brian Bishop Goldstag Consultants Ltd Tel: +44(0)7973 746832 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Howard Richter Sent: 07 March 2008 02:13 To: arslist@ARSLIST.ORG Subject: Has any one used MS SQL Express edition 2005 on arserver 7.1? ** Good morning, evening or afternoon all, Has anyone been able to used the MS SQL express edition on arserver 7.1? Thanks, hbr -- Howard Richter ITIL Foundation Certified Red Hat Certified Technician CompTIA Linux+ Certified [EMAIL PROTECTED] Resume = http://hotjobs.yahoo.com/resumes/hrichter_1/masterresume20(2) __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
Re: Separation of Duties
Hi Elmo, >From your email it looks like you have had to place staff in the Administrator group to allow them to use the Remedy Application Configuration console. If this is the case it is because Remedy never got the permissions correct for the console to allow the role of APP-Administrator to run it. On all versions of ITSM up to and including version 6 they never sorted this out and took the cheap and easy solution to advise all people who raised it as an issue, to put people in the full Administrator group. The solution is to get the module to work for APP-Administrator which isn't difficult. Just go through it with two logins, one as a full Administrator and one as APP-Administrator and fix all the permission issues. Once this has been done you will need to give APP-Administrator write access to all the fields in the User and Group form and it should then work as designed. Finally take Administrator away from those staff who do this work and you should be ok. This is the only correct solution to your problem that I know off and is the first work I would undertake after installing and patching these products. It was about two days work. Brian Bishop Goldstag Consultants Ltd Tel: +44(0)7973 746832 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Gentry, Elmo - Raleigh, NC Sent: 05 March 2008 16:02 To: arslist@ARSLIST.ORG Subject: Separation of Duties ** Overview: I need to separate the Admin permission (creating Forms, AL's, Filters, everything in the admin tool, etc) from everything in the Configuration Manager console (CTI's, Location, Groups, etc). I need to duplicate ALL of Configuration Manager console actions with a non-Admin, Sub-Admin like permissions. Any thoughts or suggestions? Preferable easy thoughts and/or suggestions. J Currently running ITSM 5.6; Problem, Change and Asset. ITSM 7 is not really an option at this time Thanks, Elmo Gentry Remedy Application Development Business Systems Analyst United States Postal Service 4200 Wake Forest Rd Raleigh, NC 27668-9000 [EMAIL PROTECTED] <http://blue.usps.gov/> United States Postal Service Logo with Eagle __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" <>
Re: EXTERNAL command problems
Hi Andy, Just an observation on this. I always use the field id no when doing external qualifications. Stops the issues you have been having and will continue to work even if the field db name is changed at a later date. Brian Bishop +44(0)7973 746832 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mayfield, Andy L. Sent: 08 October 2007 16:30 To: arslist@ARSLIST.ORG Subject: Re: EXTERNAL command problems Thanks to all for the responses. I was the naming issue. I was using the display name versus the database name. Once I changed that and verified my """"""'s (via Gidd's awesome educational viewlets, thanks much Gidd)it appears to working properly. Once again the list saves the day. Andy L. Mayfield Sr. System Operation Specialist Alabama Power Company Office: 205-226-1805 Cell: 205-288-9140 SoLinc: 10*19140 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Arner, Todd Sent: Friday, October 05, 2007 1:18 PM To: arslist@ARSLIST.ORG Subject: Re: EXTERNAL command problems Are the field label and DB name the same for Assigned Group? If they are different you will want to make sure to use the DB name in the table qualification. The label name will work if searching from the form itself but you need the DB name for the table qualification. Try copying the search string to the table qualification and see if it works. Hope that makes sense. Todd Arner Great Lakes ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Difference between "Missed" and "Missed Goal": Remedy SLA 6
Hi Maus, When loading the SLA 6.0 it is important that you load all the patches for it. There are many workflow errors in the module OOTB. The next thing to be aware of is that the status Missed Goal is a status value added in version 6.0 (I cant recall it in 5.6 although I could be wrong). To me Missed Goal is the same as In Process but I have passed my SLA Due Date. Missed is the status given when the SLA has been completed and has Missed its SLA Due Date. Now having said this the most important thing is the Status of Missed Goal If you have your SLAs set up in groups and SLAs change if the priority changes you would expect the new SLA (created when you changed the priority) would inherit details from the current one and the current one would disappear. This does in fact happen and is what goes on in the filter guide SLA:Measurement:TakeOver. However if you look at the filter SLA:Measurement:TakeOver_Lookup you will see that the set fields if qualification is as follows. ( 'SLA_Main Group' = $SLA_Main Group$) AND ( 'Application_InstanceID' = $Application_InstanceID$) AND ( 'SLA_InstanceID' != $SLA_InstanceID$) AND (( 'MeasurementStatus' = "In Process") OR ( 'MeasurementStatus' = "Pending") OR ( 'MeasurementStatus' = "Attached")) Thus it does not pick up data from an SLA with a measurement Status of Missed Goal. So if you change priority of a call and the current SLA on that call has this status you will end up with 2 slas running. The original which will never complete as the finish criteria has changed (priority is now different) and a second one which will finish, eventually, with a status of Missed or Met. However it will have started at the wrong date/time which will be based on the priority change rather than when the call was logged. Finally, the notification issues you are having could relate to a fault in the ownership take over where when it deletes the original SLA and its notifications (if there are any) it also deletes the new notifications as well leaving you with none. This is fixed in patch 1498. Brian Bishop _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mau Remedy Sent: 04 July 2007 02:59 To: arslist@ARSLIST.ORG Subject: Difference between "Missed" and "Missed Goal": Remedy SLA 6 ** Hello friends Long time since last posting. Here´s an easy one: We´ve been stuck with Remedy SLA 6.0 fundamental concepts, trying to understand the difference between "missed" and "missed goal", when monitoring attached SLAs in Helpdesk cases. SLAs are pretty straight forward, there are two different SLAs: Response and Resolution Time ... Term and Conditions include something like Impact=High and Priority=High, Goals include start measuring Response time when Status=Assigned and stop it when Status=WIP, in the other hand the second SLA goal starts measuring Resolution time when Status is WIP and stop it when it´s Resolved. Milestones include notifications to different users. Why is that two different helpdesk cases with the same data, sometimes show different SLA status, like Missed and sometimes Missed Goal, and sometimes we verify that milestones are not being met, notifications not sent. Please would you explain SLA status flow Thanks Maus __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Diary Field Issue
Jaya, If the solution works for you bar the missing TR value, then force a commit down to the database on form 1 before you do the set fields in form 2. You can do this with an Application-Release-Pending command run before the push fields (Phase 2) operation. Alternatively do the submit to form 2 with an active link firing after modify. Or if the entry in form 2 already exists then get an after modify active link to "touch" the record to cause the set fields action to fire. Brian Bishop _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: 16 March 2007 11:46 To: arslist@ARSLIST.ORG Subject: Re: Diary Field Issue Hmm .. in that case I wonder if a direct SQL to update the diary field contents would yield better results? Want to give that a shot? Joe - Original Message From: jaya munjal <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Friday, March 16, 2007 3:14:38 AM Subject: Re: Diary Field Issue ** Hi Joe Thanks for your suggestion. I tried this, but the set field only gets the DB Value and not the TR.Value of the dairy field, as the data is still not updated in the database. Secondly the issue comes with the value of Time stamp. Please let me know if you have any other work around. Many Thanks for your help Regards Jaya Joe DeSouza <[EMAIL PROTECTED]> wrote: Jaya, Approach your problem from a slightly different angle... Instead of doing a Push Field from the main form to form 2 which is working as designed by copying only the TR value of the Diary field, do a Set Field filter on form 2, on 'Submit'. Set fields will copy the whole shebang TR + DB value... Hope this helps. Joe D'Souza - Original Message From: jaya munjal <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Thursday, March 15, 2007 2:26:36 AM Subject: Diary Field Issue ** Hi Listerner I am facing a problem while working with Diary Fields. Below is the scenario that I want to implement When ever the status is set to Closed on Form 1, it pushes the data to Form 2. There is a work log field( Diary Field) that also needs to be pushed to Form 2( Dairy Field). Issue As per design only current TR.Value of Diary field is being pushed. I require the complete worklog to be pushed. Any suggestions or workaround would highly be appreciated. Thanks Jaya _ Need Mail bonding? Go to the Yahoo! <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOAR fcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=39654 6091> Mail Q&A for great <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOAR fcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=39654 6091> tips from Yahoo! Answers users. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Problems connecting to Oracle following 10g client install...
Rick, I tried upgrading an oracle 9.2 database from version 5.1.2 to 7.0.1 on my laptop. I installed the Oracle 10g client and used this as instructed. I could never get the service to start. It would always time out. I watched what Remedy was up to through Enterprise Manager and could see it talking to the database, presumably trying to build its cache. It would keep starting more and more connections. It was driving me crazy until I was advised by a colleague that you cannot upgrade from 5.1.2 to 7.0.1. You have to go through version 7.0.0 first. I don't know what the problem is though. I have now done an install of 7.0.0 over my 7.0.1 and it starts ok. I have yet to upgrade this to 7.0.1 though through lack of free time. I also want to restore the database back to 5.1.2 and try the upgrade to 7.0.0 and then 7.0.1 to see what the result is. But have yet to find the time! Brian Bishop -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Phillips Sent: 05 February 2007 17:59 To: arslist@ARSLIST.ORG Subject: Re: Problems connecting to Oracle following 10g client install... Thanks for the quick reply. I pasted a copy of tnsnames.ora in the new 10g \Network\Admin folder, but am still getting the same error. tnsping shows the correct use of sqlnet.ora and tnsnames.ora, so that looks good. Not sure what to try next. rp On Feb 5, 12:13 pm, "Grooms, Frederick W" <[EMAIL PROTECTED]> wrote: > Usually each client has it's own tnsnames.ora file. Check the install folder>\Network\Admin for a tnsnames.ora file. You may need to > copy the 9i one into the 10g folder. > > Fred > > > > -Original Message- > From: Action Request System discussion list(ARSList) > > [mailto:[EMAIL PROTECTED] On Behalf Of Rick Phillips > Sent: Monday, February 05, 2007 11:03 AM > To: [EMAIL PROTECTED] > Subject: Problems connecting to Oracle following 10g client install... > > Hello all, > > Windows 2000 AS > Ora 9i > ARS 5.1.2 upgraded to 7.0.1 > > I installed the 10g client, but am unable to start arserver following > the 7.0.1 upgrade. Found no errors in the install log, but found the > following in the arerror.log > > Mon Feb 05 11:13:38 2007 ORA-06401: NETCMN: invalid driver > designator > > Mon Feb 05 11:13:38 2007 390600 : Cannot initialize contact with SQL > database (ARERR 551) > > Mon Feb 05 11:13:38 2007 Stop server > > Mon Feb 05 11:13:38 2007 390600 : AR System server terminated -- fatal > error encountered (ARNOTE 21) > > I can connect via SQL Plus as ARAdmin. > > I have my old 9i client installed, and tnsnames.ora is in the 9i path. > Was the 10g client installation supposed to create a new or modify the > old tnsnames.ora file? > > Tia, > > Rick > > ___- > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.orgARSlist:"Where the Answers Are"- Hide quoted text - > > - Show quoted text - ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Ticket Query (part deux)
Forget the last 4 lines. Just do a query on the Request ID field of > the integer value. So taking Johns solution do a set fields from arschema on the nextid, deduct the number 10,20,50 whatever from it and then query Request ID > integer value. It will find all the tickets after that number. If, however, some have been deleted you may not get the full amount you asked for. Brian Bishop _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Reiser, John J Sent: 25 January 2007 22:36 To: arslist@ARSLIST.ORG Subject: Re: Ticket Query (part deux) This is just expanded off of what Dave Morgan wrote. And it works I tested all but the Open window part. This is all done on the form in question. You could set an integer field with select nextID from arschema where name = '$SCHEMA$' by returning $1$ - 10 Then set a character field to $IntegerField$ Then use the Character field ( with appropriate trapping and LPAD for a Prefix) to query 'Request ID' >= $CharacterField$ Fire the Open window with a Button or Menu choice. Last 10 records returned. HTH, John J. Reiser Software Development Analyst Remedy Administrator/Developer Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: Thursday, January 25, 2007 4:04 PM To: arslist@ARSLIST.ORG Subject: Re: Ticket Query (part deux) ** You could always use a table field. Not sure the context of what you are trying to accomplish. Axton On 1/25/07, Richard Crosby <[EMAIL PROTECTED]> wrote: ** Hello, I posted this question before and it did not elicit any responses. Therefore, I asked BMC support and the response I received was, "I am sorry I just dont know of a way you can limit the returned entires." (punctuation and spelling errors left intact). The question was: How would I go about querying the last "N" tickets? Meaning, I'd like to create a macro (or know the syntax) with a variable ("N") to pull up just the last 10, 20, 50, 100 , etc. records recently created. Can anyone help answer if this is do-able or not? Thanks, Richard __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: SLA Scenario - how to setup
Hi Tomas, The easiest solution for your example would be to set the SLA up to stop the clock when the status of Pending is set. Then when Group B look at the case they put it into Pending to stop the clock and leave it there until the supplier delivers the part. When it arrives take the case out of Pending and the SLA clock will start again giving you what you need. Your example is a classic case of when to use the "stop the clock" feature in the SLA module. This should be explained in the SLA users Manual. Brian Bishop -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Števove Tomáš Sent: 16 January 2007 08:12 To: arslist@ARSLIST.ORG Subject: SLA Scenario - how to setup Hello all, I have problem how to setup SLA for this scenario: Our supplier give us the time, when he delivery commodity. Our SLA goal is "supplier time + all 18 bussiness hours with case". We used SLA 6.0. Because my english is not very good I write here example: Bussiness time: Mo-Fr 8-17 1.) we receive case with priority Medium on Monday 11:00. (SLA start and SLA Due Day is Wednesday 11:00) 2.) group A analyses case and finds out, that we need new component from our supplier. 2.) Group A forward case to the group B on Tuesday 13:00 3.) Group B contacts supplier and supplier give us the time when he delivery component. 4.) Group B setup supplier time in case for example Thursday 8:00. 5.) New SLA Due Day is - Thursday 15:00. 6.) Group B received component and return case to the group A. If group closed case before Thursday 15:00, the SLA is met. As you see new SLA Due Day after contact supplier is return as suppier time + (18 hours - elapsed time). My questions: is it possible to setup this scenario in SLA 6.0 and if yes, how could I do that? Could it be setup in one SLA, or must be more SLA? How could I setup Terms and Condition and Goal on SLA? Problem with Goal in SLA is, that field is integer. Any help would be appreciated. Thank you Tomas Stevove Software Specialist Email: [EMAIL PROTECTED] ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: Upgrade from 5.12 to 7.0 - Service Fails
Hi Carina, For most of today I have been working on exactly the same problem. I even get the same error message as you. The only difference is I am upgrading from 5.1.2 to 7.0.1 and my database is 9i so I am connecting through the 10g client. The upgrade goes fine suggesting that during the upgrade process Remedy communicates with the database. But when I try to start the service manually it takes a long time, and uses a lot of memory, before it tells me it hasn't started in a timely manner. I have watched Remedy connecting to the database through Enterprise Manager and every thread gets stuck doing a query to the Role table. I am beginning to suspect that the issue is that I have SLA 6.0 module installed in the database and the processes from this version aren't compatible with 7.0.1 server. Next step is going to be restore a version of the 5.1.2 database without the SLA module, # out the sla programs in monitor.conf and go again. I probably wont do this until tomorrow as the database takes quite a while to restore on my laptop where I am trying this out. Brian Bishop -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carina Burns Sent: 27 December 2006 14:51 To: arslist@ARSLIST.ORG Subject: Upgrade from 5.12 to 7.0 - Service Fails Hey Y'all, I'm doing an upgrade/migration. I have a test instance of my data on Oracle 10g and a test server running Win2003svr. If I run the install fresh against an empty AR schema, all installs fine and the service starts with no issue. I then drop my ARAdmin user, recreate the user, and then import my 5.12 AR schema data. When I run the AR Server install again and choose the upgrade option. It installs successfully, successfully upgrades the database but then the service refuses to start. The arsql.log and dbquery.log contain nothing out of the ordinary. The only error message is in the ar_install.log "The AR System Server could not be started. You can start it manually using the Services icon in the Control Panel." (Uh, no I can't manually start it) "This error occurred after the installation of the AR System was completed. To correct this error, import the sample applications from the samples subdirectory." Well, I would do that if I could start the service so that I could connect with the Admin tool and import the definitions. I've cleared the schema, uninstalled the ARServer, I've tried running the upgrade install unchecking the sample application option, and numerous other variations and I get the same results, the service won't start after upgrade. I remember a few upgrades back, there was an issue with the Demo id not having admin rights. On our system, Demo has only browser permissions. That's the next thing I will try to alter I guess to see if it makes any difference. Has anyone else run in to this? Perhaps I should go to ARS 6.0 before going to 7.0? The tech working my ticket I have open with BMC says that shouldn't be necessary. Thanks ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
Re: AR Email HTML Template
** Hi, If the template is specific to that email, then you will need to specify it as part of the filter. If however the template is generic, like a header format with company log etc, that you want on every email, you can specify this in the configuration record for outgoing emails. Then you wont need to amend your filters at all. I hope this makes sense. Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Siti Hawa Bee SHAIK FARID Sent: 15 November 2006 02:22 To: arslist@ARSLIST.ORG Subject: Re: AR Email HTML Template Hi Brian, I did this way later in the evening yesterday and yeah it works. However i only do it in the filter HPD:HPDNotifyAssignee01 I got many other filters. So must I do the same for the rest of the notification filters? Call the template in the content as well? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 14 November, 2006 18:11 To: arslist@ARSLIST.ORG Subject: Re: AR Email HTML Template ** When using templates and specifying fields from the form in the template, you must ensure you select those fields under the Include Fields option in the email filter. I find it easier to set this to all then you don't have to keep going back to it if you add another field to the template. Brian Bishop From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Siti Hawa Bee SHAIK FARID Sent: 14 November 2006 05:41 To: arslist@ARSLIST.ORG Subject: Re: AR Email HTML Template Hi Caissie, I'm having the same issue as well so I did try your html template. However, I'm having problem displaying the field in the template. I had included the template in the template form, n the email footer template. I had restarted the email engine and simulate a case but the fields were not reflected. Is there anything that I had miss out? L Can I send you a separate email on the screen shot? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Dan Caissie Sent: Monday, November 13, 2006 1:24 PM To: arslist@ARSLIST.ORG Subject: Re: AR Email HTML Template I'm willing to share. Have fun. Dan Caissie Remedy Administrator / Developer United Natural Foods, Inc 260 Lake rd Dayville, CT 06241 (860) 779-2800 Ext: 32380 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: deleted AL deleted - still fires
** I have recently experienced join forms disappearing (CHG:Change_SLA and CHG:Change_SLA_OUT ) yet there were still entries for them in the ARSCHEMA table causing me real annoyance when I tried to import them from another system. I couldn’t understand it until a read this little excerpt from the read me for patch 18 server on 6.3 SW00230914 Data Dictionary Corruption when errors occur during import in place. I very quickly upgraded to patch 18 (I was on patch 17) and have had no problems since. Though not your problem it does show that Remedy can mess up the data dictionary without us realising. I feel that BMC should make us more aware of issues like these instead of letting us stumble across it. Brian Bishop From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of patrick zandi Sent: 14 November 2006 15:01 To: arslist@ARSLIST.ORG Subject: Re: deleted AL deleted - still fires ** have had this happen alot ? I have actually never seen this.. I am wondering if it is the combination I am using.. I can do this.. however.. I was looking for people.. to respond if it happened to them alot.. and what the situation was... On 11/14/06, McKenzie, James J C-E LCMC HQISEC/L3 <[EMAIL PROTECTED]> wrote: ** Patrick: It is still in the database. Look in the Active Link storage forms and see if it still there. You should be able to delete it from there. I assume that the AL is not showing in the listing thus this will take database manipulation, which I am sure that you can accomplish. James McKenzie L-3 GSI From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of patrick zandi Sent: Tuesday, November 14, 2006 7:48 AM To: arslist@ARSLIST.ORG Subject: deleted AL deleted - still fires ** I have an Active link. that I was playing with.. it was not giving me the results that I wanted.. Then the Admintool said suddenly.. oh that AL does not exsist on server while trying to save.. I then decided I will abandon this approach and deleted the AL .. But Now when I bring up the form, Have logged in several times, Have logged in and out of admintool serveral times.. - AL is gone from the list. Have Deleted te folders under User accounts area.. that hold the cached files.. But it is still there.. running and I cannot remove it.. Any solutions ? Idea;s Patrick Zandi __20060125___This posting was submitted with HTML in it___ -- Patrick Zandi __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: AR Email HTML Template
** When using templates and specifying fields from the form in the template, you must ensure you select those fields under the Include Fields option in the email filter. I find it easier to set this to all then you don’t have to keep going back to it if you add another field to the template. Brian Bishop From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Siti Hawa Bee SHAIK FARID Sent: 14 November 2006 05:41 To: arslist@ARSLIST.ORG Subject: Re: AR Email HTML Template Hi Caissie, I'm having the same issue as well so I did try your html template. However, I'm having problem displaying the field in the template. I had included the template in the template form, n the email footer template. I had restarted the email engine and simulate a case but the fields were not reflected. Is there anything that I had miss out? L Can I send you a separate email on the screen shot? From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dan Caissie Sent: Monday, November 13, 2006 1:24 PM To: arslist@ARSLIST.ORG Subject: Re: AR Email HTML Template I'm willing to share. Have fun. Dan Caissie Remedy Administrator / Developer United Natural Foods, Inc 260 Lake rd Dayville, CT 06241 (860) 779-2800 Ext: 32380 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Bulk remove users part II
Mike, If you create a form to hold the "variable" submitter name, build workflow to create an entry in it which meets your requirements. i.e if thet are all in a certain group add a filter to SHR:People that checks if the user doing the submit is in that group and if they are push an entry to the new form. Set the push so it creates only one record. Then add a display only selection field to the SHR:People called Delete Entry with a single value of Yes. Build a inner join form between the SHR:People and the new form joining on the submitter field. Then build an escalation to run overnight on the join form with no qualification so that it finds all the records and do a set fields on the Delete Entry field. Finally build a filter on the SHR:People form to do the application delete when this field is set to Yes. If you are deleting people who may have entries in the user form you will need to extend the delete across to this form by again touching a similar delete record field causing another application delete on that form. Same goes for the SHR:Assignment form. I hope this helps Brian Bishop +44(0)7973 746832 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Michael LoSapio Sent: 31 August 2006 20:40 To: arslist@ARSLIST.ORG Subject: Bulk remove users part II All, So, I read what a bunch of you had posted and spoke with Remedy Support. The "BEST" thing I could come up with was an escalation to run on the SHR:People with the Run If qualification being something like 'Submitter'="Mike" then run process Application-Delete-Entry "SHR:People" "Request ID" So, I was basically told me there was NO way to script the removal process to run nightly without ANY actual manual intervention. ie: we would need to change the RUN IF qualification manually in order to remove entries in the form. Is this in fact correct?... there is no way to run a nightly process which traverses through an imported list of "Submitters" and removes them all from the system?? Is there a way to create a variable in the escalation's RUN IF string... or can I execute it off a command line. I was pretty shocked to hear this too, being new to the AR system and reading all the documentation about how it is supposed to adapt to YOUR business needs and not adapt your business needs to the system. Any input would be greatly appreciated. -Mike ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Hidden permissions
Axton, I have to disagree with you. If I want a form to hold data which menus will be built from, I don't want anybody being able to change the data accept those given access to the form, like APP-Administrator. But to allow menus to be built for all users I have to give access to them to the actual data. Hence using Public Hidden access on the form. How can you explain away the word "hidden" if a macro will quite happily make it visible! All it is hiding it from is the list of forms on the Object List. Brian Bishop -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Axton Sent: 19 April 2006 17:38 To: arslist@ARSLIST.ORG Subject: Re: Hidden permissions Hidden does not imply any type of security what-so-ever. If you realy need to protect/restrict something then revoke/apply the permissions appropriately. Same goes for fields as well. Axton Grams On 4/19/06, Brian Bishop <[EMAIL PROTECTED]> wrote: > ** > > > Hi Sarah, > > > > This issue is also applicable to the User Tool. If you write a macro to open > a form, as a basic user, and then amend the macro to open a form with just > "Public Hidden" access it will open and give you access to the data. I > raised this as a security issue with Remedy but was told it was "as > designed" so had to raise an enhancement requesting the facility to be able > to create forms that users can access data in but not be able to open. > > > > Mind you I thought that was what hidden forms were!! > > > > > Brian Bishop > > > > > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Evans, Sarah (Outsourcing) > Sent: 19 April 2006 10:18 > To: arslist@ARSLIST.ORG > Subject: Hidden permissions > > > > > Hi > > > > I've found on the product defects this: > > > > ID SW00222152: It is still in the status of New. > > > > The form can still be accessed through Mid-Tier directly if Hidden > permissions are set on the form. > > > > Has the person who logged it heard anything back from Remedy? If so what > did they say? > > > > Also anyone at Remedy is there a time estimate for this fix? > > > > Thanks > > > Sarah > > > > This e-mail and any attachment is for authorised use by the intended > recipient(s) only. It may contain proprietary material, confidential > information and/or be subject to legal privilege. It should not be copied, > disclosed to, retained or used by, any other party. If you are not an > intended recipient then please promptly delete this e-mail and any > attachment and all copies and inform the sender. Thank you. > __20060125___This posting was submitted > with HTML in it___ __20060125___This > posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Hidden permissions
** Hi Sarah, This issue is also applicable to the User Tool. If you write a macro to open a form, as a basic user, and then amend the macro to open a form with just “Public Hidden” access it will open and give you access to the data. I raised this as a security issue with Remedy but was told it was “as designed” so had to raise an enhancement requesting the facility to be able to create forms that users can access data in but not be able to open. Mind you I thought that was what hidden forms were!! Brian Bishop From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Evans, Sarah (Outsourcing) Sent: 19 April 2006 10:18 To: arslist@ARSLIST.ORG Subject: Hidden permissions Hi I’ve found on the product defects this: ID SW00222152: It is still in the status of New. The form can still be accessed through Mid-Tier directly if Hidden permissions are set on the form. Has the person who logged it heard anything back from Remedy? If so what did they say? Also anyone at Remedy is there a time estimate for this fix? Thanks Sarah This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___