Re: HOW-TO Change a string?
**
IMO there should be an alternative to STRSTR which should start from the right side of a string. Also a function to reverse a string would be helpful. Of course you could solve your problem when only one of these two functions would be available in AR System.
Put an enhancement request in for it and who knows and for now solve it on the DB level.--MichielOn 7/26/06, Mathieu Pitre
[EMAIL PROTECTED] wrote:
Yes I am using Oracle but my client
gave me an memory error msg when I used your SQL command.
Look at what I tried:
SELECT SUBSTR
('$DocFileAndPath$',(INSTR ('$DocFileAndPath$','\',-1))+1) FROM
DUAL
The $DocFileAndPath$ is my string.
Mathieu Pitre
IT Business Systems Analyst
Production Operation
Computer
Sciences Corporation
Pratt Whitney Canada, Plant 1
Sametime: Mathieu Pitre
office: 450-647-8008 x7030
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
Eric Cleereman (IT)
[EMAIL PROTECTED]
Sent by: Action Request System
discussion list(ARSList) arslist@ARSLIST.ORG
26/07/2006 10:48 AM
Please respond to
arslist@ARSLIST.ORG
To
arslist@ARSLIST.ORG
cc
Subject
Re: HOW-TO Change a string?
Hi Mathieu,
Don't know if you are using Oracle, but if you are, try the following SQL:
SELECT SUBSTR ('\\path\...\FileName.ext',(INSTR ('\\path\...\FileName.ext','\',-1))+1)
FROM DUAL
This will return only the file name and extension.
Eric Cleereman
-Original Message-
From: Action Request System discussion list(ARSList)
[mailto:arslist@ARSLIST.ORG]On Behalf Of Mathieu Pitre
Sent: Wednesday, July 26, 2006 10:42 AM
To: arslist@ARSLIST.ORG
Subject: HOW-TO Change a string?
Hi all,
I would like to know how to modify the following string whitin a Set field
Action:
\\path\path\path\path\FileName.ext
I would like to separate the file name out of the file path. The path can
always change and the file name too. I am trying to find the location
(integer) of the last \ by using the STRSTRC function but it
returns 0
since the path always starts with a \.
Any suggestion?
Mathieu Pitre
ARS 6.3
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
___
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
__20060125___This posting was submitted with HTML in it___
Re: Data Driven Notifications
** Wouldn't building filters even from data submitted via a form require the documentation and approvals since it is a code change?I once built a basic SLA module using a server-side table loop to check EXTERNAL qualifications and then push a record to a form to collect the statistics. I would imagine that you could do something similar except instead of pushing records for statistics you would be pushing to the email message form. Another project that I started was to create a rules form on incoming emails (mostly for quick email integrations and to avoid the same documentation and approvals you mentioned). One of my ideas was to give my users a console that would allow them to turn the rules off and on and manage who the email was sent to. I was not going to allow them to create rules (that could be dangerous). As emails are submitted to the email message form the ones where the Message Type is Incoming are pushed to a message processing form where a server-side table loop (yeah another one) ran to check the rules configured in another form and decide if any action needed to be taken. This was also cool because I could do validation here such as not allow an update to an request where the sending email address was different then what was expected (a specific system, requester, etc).As far as I got was updating Help Desk requests but the design was flexible to allow updates to any form depending on the rules config. One cool thing was I went as far as to include the attachments from the email. If there was already an attachment in Attachment Field1 on the HD it would then use the next one and so on. A hybrid of both these may give you what you are looking for. The console may be very handy to allow your users to do some basic changes and take some burden off the admin.Jason On 7/26/06, Susan Palmer [EMAIL PROTECTED] wrote: ** Wouldn't it be a similar principle as SLA's, although I haven't looked at them in recent versions, they build a filter based on what you put in the data form. Susan On 7/26/06, Rick Cook [EMAIL PROTECTED] wrote: Take a look at ITSM v7 if you can - I think they use that basicmethodology.I know that it can be done, but it won't be a quick build. Rick-Original Message-From: Action Request System discussion list(ARSList)[mailto: arslist@ARSLIST.ORG] On Behalf Of Heider, StephenSent: Wednesday, July 26, 2006 11:34 AM To: arslist@ARSLIST.ORGSubject: Data Driven Notifications List,I plan to create a new help desk system from scratch by the end of theyear.We have ARS 6.3 and HD 5.5. When finished there will be noHD/ITSM, only ARS.The new help desk will be based on ARS 7.0 and SQLServer 2005 with a sprinkling of ARS API.Net 7.0, VB.Net 2005 and ASP2.0.Because of the new Sarbanes-Oxley requirements I want to design the new system to be as data-driven as possible.Changing a single filter takesa lot more documentation and approvals than changing the contents of afield on a form.Remedy notifications are things that get modified occasionally. Sometimes a certain group must have a notification, and then later theydon't or want it to go to someone else or want the trigger conditionchanged, etc.I have begun to contemplate how best to make most or all of the notification trigger conditions and message content pull from aform instead of hard-coding within filters.ARS is a flexible product and I am 99% sure this can be accomplished.Ihave a couple ideas.Has anyone done this before?Any approaches that you could recommend.Stephen___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARS slow to start
** Thanks, I'll give that a try CliffA -Original Message-From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Thad EsserSent: 26 July 2006 18:45To: arslist@ARSLIST.ORGSubject: Re: ARS slow to start** SQL logging will be your definitive source. We had an issue with long startup times that the SQL logs revealed was caused by one of our view forms. This view form pointed to a table on another database that had "suddenly" been decommissioned. It didn't affect anything once ARS was up, but when starting, it was trying to access that external table and wouldn't move on until it received the timeout. Thad"Perfection is achieved, not when there is nothing more to add, but when there is nothing left to take away." - Antoine de Saint-Exupéry "Jarl Grøneng" [EMAIL PROTECTED] Sent by: "Action Request System discussion list(ARSList)" arslist@ARSLIST.ORG 07/26/2006 10:34 AM Please respond toarslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS slow to start Turn on sql logging and examine which sql statement that takes long time.We had similar issue, and it was because Oracle wold not use index onthe arreferenece table. As soon as that was fixed the problem wasfixed.--JarlOn 7/26/06, Cliff A [EMAIL PROTECTED] wrote: Hi We have just upgraded our development server to oracle9i. I noticed after this that remedy was taking 3 times as long to start but put it down to the fact that we had v5.1.2. However, I have just installed arsv6.3 patch17 and there is still an very long delay in the remedy startup. I have added ulimit -n 8192 to the strat up script but to no discernible improvement - it still takes 26 minutes to come up. Has anyone else had similar problems? NB O/S is solaris 9. top command shows this... Memory: 1.2G real, 556M free, 509M swap in use, 1.4G swap free Many thanks for any help. Cliff ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ==IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.==__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Oblicore SLA Management
** Hi List Any one done integration with Oblicore SLA Management? ARsystem 6.01.01 Helpdesk 5.1 Patch 1492 OS: Windows 2003 DB: Oracle 9.02 Best regards, Rami S Ayoub __20060125___This posting was submitted with HTML in it___
Re: Time Difference b/w Web and Native Client ?
OT: If it takes 3-30 minutes to complete and is being initiated from a button, do you receive the process timeout message? Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tarun Kumar SHARMA Sent: Thursday, July 27, 2006 12:58 AM To: arslist@ARSLIST.ORG Subject: Time Difference b/w Web and Native Client ? Hello, We are doing some activity on 'button' click and this activity is quite heavy. This process is searching an entry in SHR:Assignment form and do some comparison with every record of assignment and finally transfers this record to a separate form with all other checks. Nearly 30-35 remedy objects(filters and active links) are used in this process. This activity is taking 30 minutes on Native Client; when we did this on Web, it is surprisingly taking 3 minutes for the whole activity. We compare the results of both and found no mismatch. Everything was looking fine except the time difference. Can you please suggest why so much difference in time ? Regards, Tarun Sharma ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Time Difference b/w Web and Native Client ?
Tarun, Did you test the Mid-tier after you tested the User tool? ( Maybe your RDBMS cached some table in memory and made the second time the process was run faster due to the in memory cache?) Also... How much activity is there in Active links for this? (AKA: are you looping over a table field?) If so then how the Mid-Tier deals with processing active link workflow might have something to do with that part being different. But I really think it is more likely to be the other idea.) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/27/06, Tarun Kumar SHARMA [EMAIL PROTECTED] wrote: Hello, We are doing some activity on 'button' click and this activity is quite heavy. This process is searching an entry in SHR:Assignment form and do some comparison with every record of assignment and finally transfers this record to a separate form with all other checks. Nearly 30-35 remedy objects(filters and active links) are used in this process. This activity is taking 30 minutes on Native Client; when we did this on Web, it is surprisingly taking 3 minutes for the whole activity. We compare the results of both and found no mismatch. Everything was looking fine except the time difference. Can you please suggest why so much difference in time ? Regards, Tarun Sharma ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ITSM 7.0 Overview Console - Plug-in Error
Create a new private queue in admin tool (Server Information - Server Ports and Queue) and note its RPC Program Number. Open the form 'CAI Plugin Registry' and look for the entry with PluginID = CAIPLUGIN (our form has only one entry..) Modify the registry to reflect the new private queue no = RPC Program Number of new queue. Restart the server. As I said this is a workaround and the problem will return after a while. Anjali, How did you managed to Modify (create) the 'CAI Plugin Registry' record. In my system the Save button is not active. Regards, Tamas ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Mid-Tier 6.3 Patch 17 ARERR 9217
Lucero, Michelle - IST contractor wrote: Meanwhile we are checking IUSR permissions on the Mid-Tier installation directory. Please NOTE: These errors do not occur against the same ARServer 6.3, patch 11, with Mid-Tier 6.3, patch 13 nor with Mid-Tier Version 7.0.00 Patch 001 Thanks, Michelle On different servers Mid-Tier 6.3, Patch 17; Mid-Tier 6.3, Patch 13; Mid-Tier 7.0, Patch 01 Windows 2003/IIS 6.0/Servlet Exec 5.0 P06 Hi Michelle, you might ran into that Error because your ARS Server has an prior Patch Version than on your Mid-Tier. When we upgraded our 6.3 to p16 it was recommended to bring both Systems to Patch Level 16. You should find this info in the readme.txt from the Installer Package. regards, Simon ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS Upgrade from 5.1 to 7.0
We've kicked off a project to upgrade from 5.1 to 7.0. We're too early in the process to provide any insight but perhaps we can share experiences along the way and help each other out. Besides the AR System upgrade we're going to new servers, moving the DB into a MS SQL 2005 cluster off of the ARS server, and putting the two primary production servers behind a Cisco load balancer, which means using server groups for the first time. We're also upgrading the TelAlert notification software. We have 30 in-house developed applications and no out of the box apps. Bruce Hendershot Air Products and Chemicals, Inc. [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan Sent: Tuesday, July 25, 2006 9:08 AM To: arslist@ARSLIST.ORG Subject: Re: ARS Upgrade from 5.1 to 7.0 Hello, I'm currently working on an cluster upgrade from a v5.1.2 straight to v7 - all applications running on that boxes have been developed in-house (the out-of-the-box applications are running on a separate environment) and the first tests have been successful without any issues worth mentioning. We're running on Oracle Solaris with a huge client base using both Midtier and fat clients. George On 7/25/06, Mayfield, Andy L. [EMAIL PROTECTED] wrote: I tried searching the archives for this topic, but didn't have much luck. I am trying to decide whether to upgrade to 6.3 or go ahead and go to 7.0. We are currently running version 5.1. Are there any known issues with upgrading from 5.1 to 7.0? Would it be an easier transition to go to 6.3 then to 7.0 at some point in the future? We run just the base ARS package. Thanks, Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: ARS Upgrade from 5.1 to 7.0
Oh Bruce are you going to have fun. C -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Hendershot,Bruce D. Sent: Thursday, July 27, 2006 9:04 AM To: arslist@ARSLIST.ORG Subject: Re: ARS Upgrade from 5.1 to 7.0 We've kicked off a project to upgrade from 5.1 to 7.0. We're too early in the process to provide any insight but perhaps we can share experiences along the way and help each other out. Besides the AR System upgrade we're going to new servers, moving the DB into a MS SQL 2005 cluster off of the ARS server, and putting the two primary production servers behind a Cisco load balancer, which means using server groups for the first time. We're also upgrading the TelAlert notification software. We have 30 in-house developed applications and no out of the box apps. Bruce Hendershot Air Products and Chemicals, Inc. [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan Sent: Tuesday, July 25, 2006 9:08 AM To: arslist@ARSLIST.ORG Subject: Re: ARS Upgrade from 5.1 to 7.0 Hello, I'm currently working on an cluster upgrade from a v5.1.2 straight to v7 - all applications running on that boxes have been developed in-house (the out-of-the-box applications are running on a separate environment) and the first tests have been successful without any issues worth mentioning. We're running on Oracle Solaris with a huge client base using both Midtier and fat clients. George On 7/25/06, Mayfield, Andy L. [EMAIL PROTECTED] wrote: I tried searching the archives for this topic, but didn't have much luck. I am trying to decide whether to upgrade to 6.3 or go ahead and go to 7.0. We are currently running version 5.1. Are there any known issues with upgrading from 5.1 to 7.0? Would it be an easier transition to go to 6.3 then to 7.0 at some point in the future? We run just the base ARS package. Thanks, Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Deleted Groups
** Kathy, This won't help you now, but it mayfor the future. Create an escalation that runs nightly which uses runmacro to export the data from User and Groups.Then if anything like this happens again you could empty the Groups form, import all the groups, followed by running the arsignal command. HTH. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy MorrisSent: Wednesday, July 26, 2006 3:01 PMTo: arslist@ARSLIST.ORGSubject: Deleted Groups ** Hi, someone (not I), imported the groups 3 times into the group form in the update mode. The result wasmultiple duplicate groups within the Group form (ie. multiple administrator groups, customize group, etc...) Now the application is hanging when we try to do anything with the group form. Any ideas on how to fix this. I deleted the duplicate entries within the group form. Restarted the server. The application still hangs.__20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARS Upgrade from 5.1 to 7.0
** Enjoy the minor changes of: C2 'Entry-Id' is now 255 characters and you get the Expand Box on the end automatickly C4 'Assigned To' is now 255 characters and you get the Expand Box on the end automatickly C5 'Modified By' is now 255 characters and you get the Expand Box on the end automatickly we have to clean up custom screens imported. aught to do wonders with old ITSM table imports where c2, c4, c5 used to be limited by the system to 30 characters. And the Status-History tables will have the expansion to 255 chars for the Modified By fields. Paul W Killion III, Systems MGMT PROF-ADVISORY Hendershot,Bruce D. [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/27/2006 08:03 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS Upgrade from 5.1 to 7.0 We've kicked off a project to upgrade from 5.1 to 7.0. We're too early in the process to provide any insight but perhaps we can share experiences along the way and help each other out. Besides the AR System upgrade we're going to new servers, moving the DB into a MS SQL 2005 cluster off of the ARS server, and putting the two primary production servers behind a Cisco load balancer, which means using server groups for the first time. We're also upgrading the TelAlert notification software. We have 30 in-house developed applications and no out of the box apps. Bruce Hendershot Air Products and Chemicals, Inc. [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan Sent: Tuesday, July 25, 2006 9:08 AM To: arslist@ARSLIST.ORG Subject: Re: ARS Upgrade from 5.1 to 7.0 Hello, I'm currently working on an cluster upgrade from a v5.1.2 straight to v7 - all applications running on that boxes have been developed in-house (the out-of-the-box applications are running on a separate environment) and the first tests have been successful without any issues worth mentioning. We're running on Oracle Solaris with a huge client base using both Midtier and fat clients. George On 7/25/06, Mayfield, Andy L. [EMAIL PROTECTED] wrote: I tried searching the archives for this topic, but didn't have much luck. I am trying to decide whether to upgrade to 6.3 or go ahead and go to 7.0. We are currently running version 5.1. Are there any known issues with upgrading from 5.1 to 7.0? Would it be an easier transition to go to 6.3 then to 7.0 at some point in the future? We run just the base ARS package. Thanks, Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___
Re: notify via SMS mobile phone messages
Thanks Michiel.I agree with you about the GSM modem. It's rarely having a good signal in a computer room.On the other hand, it also cost another cell phone number which is hard to get funded.About using the email to SMS solution, it has a downside that assignees could only be notified by either email or SMS if we utilize the email address field to send the SMS.If one of my customer would like to notify assignees via SMS for urgency and also viaemail for more detailed ticket information, then we might have a problem. AFAIK some of the SMS service vendors also provides API service. Users can write a small program to send a SMS message by following their protocol which is mostly a special formatted URL with parameters in it. So I intend to find a program to sniff the AR server\db directory ,extract the notification message then do the SMS things. Thanks.djhuang2006/7/26, Michiel Beijen [EMAIL PROTECTED]: You COULD buy an GSM modem, insert a sim and place it in your server.Then you could use some CLI program to send SMSs with it. But thereare a lot of drawbacks to this, one of them is that in most computerrooms mobile phones (and also your SMS modem) would not have great connection. Another is that these things are most of the time reallyslow.I would encourage you to look into an E-mail to SMS gateway solution.There are lots of these available on the Internet, just google for it. Then you could just use the regular e-mail notification, you wouldonly need to add a few extra bits n pieces for the number of the cellphone you'd be sending to.Regards,MichielOn 7/25/06, djhuang [EMAIL PROTECTED] wrote: Hi Roger,AFAIK, there're two ways of sending SMS from a computer to mobile phones.One is send a email contains SMS to a gateway then the gateway would help to deliver tothe cell phone. The other is to use a CLI program to transfer with parameters specified.But I think the second one would be better, wouldn't it?Thanks. djhuang 2006/7/25, Nall, Roger [EMAIL PROTECTED] : ** We do this all the time. The biggest issues are: · Data limitation – I believe you are limited to 175 characters total and this includes the Subject. · You should only accommodate this for internet SMS devices. · You would need to have a field in the user's profile that contains the SMS address. You would need to capture this value in your Notification routines. HTH, Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile USA Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-490-3296 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of djhuang Sent: Tuesday, July 25, 2006 11:11 AM To: arslist@ARSLIST.ORG Subject: notify via SMS mobile phone messages Hi! I currently have a working ITSM Helpdesk system but have been asked to notify our assignees via SMS message.Since SMS messages is not a default method, so I guess there would be some integrating work to do. Is there anyone could give me suggestions to accomplish this? Thanks. djhuang ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it__ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: 7.0 Installation
** If Approval Server and Assignment Engine are installed prior to CMDB will that cause problems? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kelly DeaverSent: Monday, July 24, 2006 8:20 AMTo: arslist@ARSLIST.ORGSubject: Re: 7.0 Installation ** Mike got it right. I'll add a little explanation to clarify - 1. ARS 7.0 (of course) At this point, stop and add any license you don't already have. You can't install v7 apps that are not licensed. (See a very long thread on that subject in the archives) 2. No set order on these within the group but here again, you are building the foundation so do before the apps isa good practice. Email Engine 7.0Flashboards 7.0FTS 3. CMDB 2.0 CMDB has become a base required by Incident, Problem, Change, Assetand SLA 4. Approval Server 7.0 Assignment Engine Leveraged by the other apps so here again, a requirement before you install them. 5. Incident Management Problem Management Change Management Asset Management SLA New in 7, it no longer matters the order in which you install these, unlike in the past when you needed to install Help Desk before Asset or Change 6. Other things that can be installed any time after AR Server as they don't conflict with or require anything else- EIE, Remedy Link for SQL, Remedy Link for Oracle.-Kelly DeaverDirector, ITSM PracticeXinify[EMAIL PROTECTED] Original Message Subject: Re: 7.0 InstallationFrom: Mike Parker [EMAIL PROTECTED]Date: Thu, July 20, 2006 9:15 amTo: arslist@ARSLIST.ORGHi Pam:I've done (doing) mine in the following order:ARS 7.0Email Engine 7.0Flashboards 7.0FTSCMDB 2.0Approval Server 7.0Assignment EngineIncident ManagementProblem ManagementChange ManagementAsset ManagementSLAThe installation steps from CMDB and after comes out of the installation guide.From: Pam Hollis [EMAIL PROTECTED]Reply-To: arslist@ARSLIST.ORGTo: arslist@ARSLIST.ORGSubject: 7.0 InstallationDate: Thu, 20 Jul 2006 10:04:48 -0400I am getting ready to Install 7.0 and all of ITSM Suite. What order doyou recommend installing software. Is this correct - or should they be ina diffent order. Of course I know to make sure all of the Database, OS,Web, etc software is installed priror to starting these installations.AR System 7.0AR Email EngingeMid-TiereApproval ServerHelp DeskChangeAssetCMDBThanksPamAR System 7.0Oracle 10gLinux SuseITSM Suite 7.0 all applications___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org_FREE pop-up blocking with the new MSN Toolbar get it now! http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: ARS Upgrade from 5.1 to 7.0
** I thought C-1 is Request ID and C 2 is Submitter. Did this change? Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile USA Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-490-3296 sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Paul W Killion Sent: Thursday, July 27, 2006 9:18 AM To: arslist@ARSLIST.ORG Subject: Re: ARS Upgrade from 5.1 to 7.0 ** Enjoy the minor changes of: C2 'Entry-Id' is now 255 characters and you get the Expand Box on the end automatickly C4 'Assigned To' is now 255 characters and you get the Expand Box on the end automatickly C5 'Modified By' is now 255 characters and you get the Expand Box on the end automatickly we have to clean up custom screens imported. aught to do wonders with old ITSM table imports where c2, c4, c5 used to be limited by the system to 30 characters. And the Status-History tables will have the expansion to 255 chars for the Modified By fields. Paul W Killion III, Systems MGMT PROF-ADVISORY Hendershot,Bruce D. [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/27/2006 08:03 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS Upgrade from 5.1 to 7.0 We've kicked off a project to upgrade from 5.1 to 7.0. We're too early in the process to provide any insight but perhaps we can share experiences along the way and help each other out. Besides the AR System upgrade we're going to new servers, moving the DB into a MS SQL 2005 cluster off of the ARS server, and putting the two primary production servers behind a Cisco load balancer, which means using server groups for the first time. We're also upgrading the TelAlert notification software. We have 30 in-house developed applications and no out of the box apps. Bruce Hendershot Air Products and Chemicals, Inc. [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of George Barsan Sent: Tuesday, July 25, 2006 9:08 AM To: arslist@ARSLIST.ORG Subject: Re: ARS Upgrade from 5.1 to 7.0 Hello, I'm currently working on an cluster upgrade from a v5.1.2 straight to v7 - all applications running on that boxes have been developed in-house (the out-of-the-box applications are running on a separate environment) and the first tests have been successful without any issues worth mentioning. We're running on Oracle Solaris with a huge client base using both Midtier and fat clients. George On 7/25/06, Mayfield, Andy L. [EMAIL PROTECTED] wrote: I tried searching the archives for this topic, but didn't have much luck. I am trying to decide whether to upgrade to 6.3 or go ahead and go to 7.0. We are currently running version 5.1. Are there any known issues with upgrading from 5.1 to 7.0? Would it be an easier transition to go to 6.3 then to 7.0 at some point in the future? We run just the base ARS package. Thanks, Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Deleted Groups
Kathy, There should be a Group.arx file on the server in the AR System install directory. This is the file that is used by the ar system install script to import the default groups such as Administrator, Customize etc. Once you locate the file, you can use the import tool to restore the system groups. One thing to keep in mind is to ensure you set the proper preferences on the import tool on the 'Duplicate Entry' tab. Kind regards, Saby Remedy Consultant --- Joe DeSouza [EMAIL PROTECTED] wrote: Kathy, I would try restoring the T and H tables that belong to the group form and the group_cache and restart the AR Server after these restores... Also before restarting the AR Server after the restore of the T table beloinging to the Group form, I would reset the nextid column in the arschema so that I would not receive a 'unique index violated' error while creating new groups in the future... Good luck... Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Kathy Morris [EMAIL PROTECTED] To: arslist@ARSLIST.ORG Sent: Wednesday, July 26, 2006 3:20:36 PM Subject: Re: Deleted Groups ** The admin imported duplicates so I deleted the ones such as the customize group. There were some labeled modify 6 for like the customize group. Instead of 0006. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Data Driven Notifications
Stephen: In ARS 6.3+, there are enough tools available to have very flexible data driven notification rules. As you are contemplating your design, you want to pay attention to EXTERNAL() in filters (that pretty much takes care of how to trigger the notify) as was mentioned earlier and the special Run Process commands such as Application-Parse-Qual-Filter, Application-Map-Names-To-Ids, Application-Copy-Field-Value etc (for the form where you will let people specify the rules, or the qualifications). ITSM appliations have a handy form for entering/modifying filter run if qualifications that you can use on your form where notification rules are maintained. The form name escapes me right now. Note that specifying the rules means understanding filter Run Ifs, so it takes a fair amount of understanding for somebody to maintain the rules. Also, as was pointed out earlier, though data driven notifications allow you to change notifications without code change, no matter how a notification is changed, it is in essence a change in behavior of the application with all the associated risks. So, data driven method does simplify actual rule changes and deployment for the developer, but depending on how strongly the Change Management process is implemented in your organization, you may still have to go through regular Change Management. I have built such a feature. I'm in a hurry now [don't ask why :) ], but I will be glad to share details later. Regards. --- Heider, Stephen [EMAIL PROTECTED] wrote: Jason, I think this is close to what I am looking for. The EXTERNAL() function in the Run If of a filter looks promising. I could build the qualification string in another filter that runs prior to the EXTERNAL() filter. This would take care of the triggering. Next I would need to create a screen that allows authorized users to easily create or modify triggering conditions. The screen would need to have options to test fields. For example the Status field: Did it change? Was it less than Resolved before? Was it just changed to Pending?, etc. Rick, I am installing Service Desk 7 now. From what I have read it may take til tomorrow to complete - it's in a VM environment. I will examine how SD7 handles this. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jason Miller Sent: Thursday, July 27, 2006 5:43 AM To: arslist@ARSLIST.ORG Subject: Re: Data Driven Notifications ** Wouldn't building filters even from data submitted via a form require the documentation and approvals since it is a code change? I once built a basic SLA module using a server-side table loop to check EXTERNAL qualifications and then push a record to a form to collect the statistics. I would imagine that you could do something similar except instead of pushing records for statistics you would be pushing to the email message form. Another project that I started was to create a rules form on incoming emails (mostly for quick email integrations and to avoid the same documentation and approvals you mentioned). One of my ideas was to give my users a console that would allow them to turn the rules off and on and manage who the email was sent to. I was not going to allow them to create rules (that could be dangerous). As emails are submitted to the email message form the ones where the Message Type is Incoming are pushed to a message processing form where a server-side table loop (yeah another one) ran to check the rules configured in another form and decide if any action needed to be taken. This was also cool because I could do validation here such as not allow an update to an request where the sending email address was different then what was expected (a specific system, requester, etc).As far as I got was updating Help Desk requests but the design was flexible to allow updates to any form depending on the rules config. One cool thing was I went as far as to include the attachments from the email. If there was already an attachment in Attachment Field1 on the HD it would then use the next one and so on. A hybrid of both these may give you what you are looking for. The console may be very handy to allow your users to do some basic changes and take some burden off the admin. Jason On 7/26/06, Susan Palmer [EMAIL PROTECTED] wrote: ** Wouldn't it be a similar principle as SLA's, although I haven't looked at them in recent versions, they build a filter based on what you put in the data form. Susan On 7/26/06, Rick Cook [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Take a look at ITSM v7 if you can - I think they use that basic methodology. I know that it can be done, but it won't be a quick build.
Re: ARS Upgrade from 5.1 to 7.0
** Opps C2 still Submitter. Was thinking along the right lines.. Is it Friday yet. Paul W Killion III, Systems MGMT PROF-ADVISORY Information Technology Services Americas, Global Services, IBM - BNSF 2400 Western Center Blvd. - Fort Worth, Texas 76137 Office - 817-352-3464 This Transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Nall, Roger [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/27/2006 08:41 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS Upgrade from 5.1 to 7.0 ** I thought C-1 is Request ID and C 2 is Submitter. Did this change? Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile USA Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-490-3296 sf49fanv AIM IM RogerNall Yahoo IM From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Paul W Killion Sent: Thursday, July 27, 2006 9:18 AM To: arslist@ARSLIST.ORG Subject: Re: ARS Upgrade from 5.1 to 7.0 ** Enjoy the minor changes of: C2 'Entry-Id' is now 255 characters and you get the Expand Box on the end automatickly C4 'Assigned To' is now 255 characters and you get the Expand Box on the end automatickly C5 'Modified By' is now 255 characters and you get the Expand Box on the end automatickly we have to clean up custom screens imported. aught to do wonders with old ITSM table imports where c2, c4, c5 used to be limited by the system to 30 characters. And the Status-History tables will have the expansion to 255 chars for the Modified By fields. Paul W Killion III, Systems MGMT PROF-ADVISORY Hendershot,Bruce D. [EMAIL PROTECTED] Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 07/27/2006 08:03 Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: ARS Upgrade from 5.1 to 7.0 We've kicked off a project to upgrade from 5.1 to 7.0. We're too early in the process to provide any insight but perhaps we can share experiences along the way and help each other out. Besides the AR System upgrade we're going to new servers, moving the DB into a MS SQL 2005 cluster off of the ARS server, and putting the two primary production servers behind a Cisco load balancer, which means using server groups for the first time. We're also upgrading the TelAlert notification software. We have 30 in-house developed applications and no out of the box apps. Bruce Hendershot Air Products and Chemicals, Inc. [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George Barsan Sent: Tuesday, July 25, 2006 9:08 AM To: arslist@ARSLIST.ORG Subject: Re: ARS Upgrade from 5.1 to 7.0 Hello, I'm currently working on an cluster upgrade from a v5.1.2 straight to v7 - all applications running on that boxes have been developed in-house (the out-of-the-box applications are running on a separate environment) and the first tests have been successful without any issues worth mentioning. We're running on Oracle Solaris with a huge client base using both Midtier and fat clients. George On 7/25/06, Mayfield, Andy L. [EMAIL PROTECTED] wrote: I tried searching the archives for this topic, but didn't have much luck. I am trying to decide whether to upgrade to 6.3 or go ahead and go to 7.0. We are currently running version 5.1. Are there any known issues with upgrading from 5.1 to 7.0? Would it be an easier transition to go to 6.3 then to 7.0 at some point in the future? We run just the base ARS package. Thanks, Andy L. Mayfield System Operation Specialist Alabama Power Company Office: 8-226-1805 __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __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 Groups
If you delete your administrator login name, and have no other administrator login to use, you can run arreload - no user to validate to. I've never trashed my Groups form, but suspect that it would behave the same way (Administrator group no longer valid, therefore no members). arcache can be used to create an administrator group as well as to create an administrator login name if necessary in the cached copy of Group and/or User. As of ARS 6.x, it's documented in Configuring AR System in AR System server components and external utilities (External Utilities section). Stephen - if Groups was corrupted, wouldn't arsignal simply reproduce the corruption? In other words, what does the -g option for arsignal actually read? I've always thought it was similar to arreload for Groups. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] Heider, Stephen [EMAIL PROTECTED]To: arslist@ARSLIST.ORG cc: Sent by: Action Subject: Re: Deleted Groups Request System discussion list(ARSList) [EMAIL PROTECTED] ORG 07/27/2006 09:09 Please respond to arslist ** Kathy, This won't help you now, but it may for the future. Create an escalation that runs nightly which uses runmacro to export the data from User and Groups. Then if anything like this happens again you could empty the Groups form, import all the groups, followed by running the arsignal command. HTH. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Wednesday, July 26, 2006 3:01 PM To: arslist@ARSLIST.ORG Subject: Deleted Groups ** Hi, someone (not I), imported the groups 3 times into the group form in the update mode. The result was multiple duplicate groups within the Group form (ie. multiple administrator groups, customize group, etc...) Now the application is hanging when we try to do anything with the group form. Any ideas on how to fix this. I deleted the duplicate entries within the group form. Restarted the server. The application still hangs. __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
Re: Deleted Groups
Mike, If the tables that comprise the Group form are corrupt then you would like need to restore the SQL tables from backup or possibly re-import the .def file that includes the Group form. From what I gather the issue is with the contents of the Group form instead of tables. According to the 6.3 docs, arsignal -g Causes the server to reload group and data dictionary from the database If the Group form is emptied and repopulated then arsignal should re-read the Group form entries. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Mike White Sent: Thursday, July 27, 2006 9:59 AM To: arslist@ARSLIST.ORG Subject: Re: Deleted Groups If you delete your administrator login name, and have no other administrator login to use, you can run arreload - no user to validate to. I've never trashed my Groups form, but suspect that it would behave the same way (Administrator group no longer valid, therefore no members). arcache can be used to create an administrator group as well as to create an administrator login name if necessary in the cached copy of Group and/or User. As of ARS 6.x, it's documented in Configuring AR System in AR System server components and external utilities (External Utilities section). Stephen - if Groups was corrupted, wouldn't arsignal simply reproduce the corruption? In other words, what does the -g option for arsignal actually read? I've always thought it was similar to arreload for Groups. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] Heider, Stephen [EMAIL PROTECTED]To: arslist@ARSLIST.ORG cc: Sent by: Action Subject: Re: Deleted Groups Request System discussion list(ARSList) [EMAIL PROTECTED] ORG 07/27/2006 09:09 Please respond to arslist ** Kathy, This won't help you now, but it may for the future. Create an escalation that runs nightly which uses runmacro to export the data from User and Groups. Then if anything like this happens again you could empty the Groups form, import all the groups, followed by running the arsignal command. HTH. Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Wednesday, July 26, 2006 3:01 PM To: arslist@ARSLIST.ORG Subject: Deleted Groups ** Hi, someone (not I), imported the groups 3 times into the group form in the update mode. The result was multiple duplicate groups within the Group form (ie. multiple administrator groups, customize group, etc...) Now the application is hanging when we try to do anything with the group form. Any ideas on how to fix this. I deleted the duplicate entries within the group form. Restarted the server. The application still hangs. __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
String manipulation via API
** Is it possible to perform substr-type actions via API call (I'm guessing ARSetEntry)? If so, can someone provide an example of what that would look like? I'm not much of a C programmer, so use small words, please. :) Thanks! Rick CookRemedy Approved Consultant Denali Advanced Integration (253) 278-4112 __20060125___This posting was submitted with HTML in it___
Re: String manipulation via API
Rick, Before I went there.. I would look at the Scripting plugin the Remedy released as a general purpose plugin for ARS server. (Developers community download) The Java one would work quite well to getting to a real Regexp ability to parse/substitute with a very low cost of ownership for the customer. (No plugin development required, only scripting language knowledge required.) And as I recall the Java Scripting plugin came with a sample script that dealt with using Regexps in it. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/27/06, Rick Cook [EMAIL PROTECTED] wrote: ** Is it possible to perform substr-type actions via API call (I'm guessing ARSetEntry)? If so, can someone provide an example of what that would look like? I'm not much of a C programmer, so use small words, please. :) Thanks! Rick Cook • Remedy Approved Consultant • Denali Advanced Integration • (253) 278-4112 __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Oracle/ARS 6.3 ?s
** We are upgrading a test environment for our 6.3 upgrade. Our DBAs are questioning Remedy's specified need for the 9i DB client to access the 10 database. Since I'm not savvy on Oracle, any feedback on this?? HPUX 11 Oracle 10r2 ARS 6.3 (well, that's where we are going, currently 5.0) Thanks! Jamie Blodgett Rinker Materials CONFIDENTIALITY: The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication, and the information contained in it, is strictly prohibited. If you are not the intended recipient, please contact the sender and immediately destroy all copies of the original message. __20060125___This posting was submitted with HTML in it___
Re: Data Driven Notifications
Stephen- Good for you. Building from scratch is the only way to go, IMHO. I have an app with data-driven notifications (and messages) now, but not as complicated as you spelled out. Our requirements were to allow notification content to be changed, allow fields from the source ticket to be inserted (or not), and allow recipients to opt in or out of certain notifications. What I don't have is a way to change a notification's trigger conditions, but that could easily be added (see below). It was easier than I expected. Basically, I created a form to store notification content, and stored all the notifications by a title and a number. Users can change the notification content by querying the form by title (i.e. the Rehire message). When triggered, the system then queries notification content by number, (Set-fields to a hidden display-only field) and sends the notification from there. To accomplish the requirement of allowing fields to be included, I added a field drop-down with all the fields approved to be in notifications, and when a user selects one, add it as a field reference, like so: Warning: assocFirst assocLast has a higher job grade than SupvFirst SupvLast. Then before a filter sends a notification, it first replaces all the field references with their values from the ticket. All notifications are sent to groups. So users (with certain restrictions) can add or remove themselves from notification groups by updating their user record. And finally, the notifications make use of HTML content templates, so they all look pretty. You could add the ability to change a notifications' trigger by use of the EXTERNAL feature. You'd have to make a rather involved user interface on the notification content form, with the end result being the creation of a Run-If qualification, stored with the notification. Then each notification filter must become two filters - one that triggers on every submit (and/or modify) and pulls the qualification, and a second that runs using the EXTERNAL function with that qualification. -Aaron * Email: [EMAIL PROTECTED] -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Wednesday, July 26, 2006 2:34 PM To: arslist@ARSLIST.ORG Subject: Data Driven Notifications List, I plan to create a new help desk system from scratch by the end of the year. We have ARS 6.3 and HD 5.5. When finished there will be no HD/ITSM, only ARS. The new help desk will be based on ARS 7.0 and SQL Server 2005 with a sprinkling of ARS API.Net 7.0, VB.Net 2005 and ASP 2.0. Because of the new Sarbanes-Oxley requirements I want to design the new system to be as data-driven as possible. Changing a single filter takes a lot more documentation and approvals than changing the contents of a field on a form. Remedy notifications are things that get modified occasionally. Sometimes a certain group must have a notification, and then later they don't or want it to go to someone else or want the trigger condition changed, etc. I have begun to contemplate how best to make most or all of the notification trigger conditions and message content pull from a form instead of hard-coding within filters. ARS is a flexible product and I am 99% sure this can be accomplished. I have a couple ideas. Has anyone done this before? Any approaches that you could recommend. Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org SunCom is the wireless company that's committed to doing things differently. Things we want you to know. This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication may contain material protected by the attorney-client privilege. If you are not the intended recipient or the person responsible for delivering the e-mail to the intended recipient, be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Oracle/ARS 6.3 ?s
Jamie, Maybe I have seen this from DBA's to often but... Tell your DBA's to get over it and it will work. Follow the directions and it will work. The not so technical side of the details... The ARS server is compiled and linked to specific versions of Oracle client libs. So the ARS server only speaks a specific version of Oracle to the Oracle server. However, Remedy does not distribute those libs so that you can use the most current patch of them from Oracle for your specific conditions. In short, follow the directions and it will work. :) ( Do you see a trend yet? :) I hope that does not sound to harsh. However, I really get frustrated by people who are intelligent enough to read the directions then they decide that they are so intelligent that the directions must not apply to them. As if they know more than the people who wrote, tested, and sold the product that the instructions were designed for. :) They are users, so start being a user. There is no shame in following the directions. Even if they are wrong some of the time. Do it, test it, fix it only if needed. :) -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. Never ascribe to malice, that which can be explained by incompetence. On 7/27/06, Blodgett, Jamie [EMAIL PROTECTED] wrote: ** We are upgrading a test environment for our 6.3 upgrade. Our DBAs are questioning Remedy's specified need for the 9i DB client to access the 10 database. Since I'm not savvy on Oracle, any feedback on this?? HPUX 11 Oracle 10r2 ARS 6.3 (well, that's where we are going, currently 5.0) Thanks! Jamie Blodgett Rinker Materials ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Oracle/ARS 6.3 ?s
** Remedy 6.3 was compiled to link to the 9i client only. The 9i client can talk to an Oracle 10 server, but the Remedy binaries will only talk tothe 9i client From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Blodgett, JamieSent: Thursday, July 27, 2006 9:43 AMTo: arslist@ARSLIST.ORGSubject: Oracle/ARS 6.3 ?s ** We are upgrading a test environment for our 6.3 upgrade. Our DBAs are questioning Remedy's specified need for the 9i DB client to access the 10 database. Since I'm not savvy on Oracle, any feedback on this?? HPUX 11 Oracle 10r2 ARS 6.3 (well, that's where we are going, currently 5.0) Thanks! Jamie Blodgett Rinker MaterialsCONFIDENTIALITY: The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication, and the information contained in it, is strictly prohibited. If you are not the intended recipient, please contact the sender and immediately destroy all copies of the original message. __20060125___This posting was submitted with HTML in it___
Re: Time Difference b/w Web and Native Client ?
Tarun, Our Bangalore operation has similar problems. I'm assuming your web server in the Europe also? Remember, when you process data in this way using the user tool the data is going back and forth over this link, which probably has high latency and low bandwidth. It's all driven by active links after all (maybe even some client side table walking?). On the web, this operation has a much shorter journey (and probably 1GB bandwidth in the server centre). Hence, it'll respond a lot faster. Rgds, Darren Houldcroft LogicaCMG - Remedy TA 250 Brook Drive, Green Park, Reading, RG2 6UA T: +44 (0) 118 9650 453 M: +44 (0) 7968 475 015 E: [EMAIL PROTECTED] W: http://www.logicacmg.com -Original Message- From: Tarun Kumar SHARMA [mailto:[EMAIL PROTECTED] Sent: 27 July 2006 11:57 To: Houldcroft, Darren Subject: RE: Time Difference b/w Web and Native Client ? Hello Darren, I have checked logging, which is disabled. User tool is in India and Server is in Europe. So your 2nd point might be the answer. But we are using many other activities on WEB as well as on User Tool and never seen such a huge difference of processed time. Thanks a lot. Regards, Tarun -Original Message- From: Houldcroft, Darren [mailto:[EMAIL PROTECTED] Sent: Thursday, July 27, 2006 1:39 PM To: Tarun Kumar SHARMA Subject: RE: Time Difference b/w Web and Native Client ? Tarun, Must ask the obvious first - have you got logging accidentally enabled on your user tool? Assuming not, what is the distance between the user tool and the server? The user tool is a bandwidth hungry animal and doesn't work as well over the small pipes you'd get for a long distance WAN connection. Rgds, Darren Houldcroft LogicaCMG - Remedy TA 250 Brook Drive, Green Park, Reading, RG2 6UA T: +44 (0) 118 9650 453 M: +44 (0) 7968 475 015 E: [EMAIL PROTECTED] W: http://www.logicacmg.com -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Tarun Kumar SHARMA Sent: 27 July 2006 05:58 To: arslist@ARSLIST.ORG Subject: Time Difference b/w Web and Native Client ? Hello, We are doing some activity on 'button' click and this activity is quite heavy. This process is searching an entry in SHR:Assignment form and do some comparison with every record of assignment and finally transfers this record to a separate form with all other checks. Nearly 30-35 remedy objects(filters and active links) are used in this process. This activity is taking 30 minutes on Native Client; when we did this on Web, it is surprisingly taking 3 minutes for the whole activity. We compare the results of both and found no mismatch. Everything was looking fine except the time difference. Can you please suggest why so much difference in time ? Regards, Tarun Sharma ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org 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. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Mid-Tier 6.3 Patch 17 ARERR 9217
Thanks for the tip. Thankfully, patch 17 is only on our dev mid-tier. Our production mid-tier is still on P13. We had installed Mid-Tier Patch 17, per Remedy Tech Support to test some Flashboard issues. But, then that begs the question, why does Mid-Tier 7.0 Patch 01 work without issue against the same AR Server? Thanks, Michelle -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Simon Hensler Sent: Thursday, July 27, 2006 7:18 AM To: arslist@ARSLIST.ORG Subject: Re: Mid-Tier 6.3 Patch 17 ARERR 9217 Lucero, Michelle - IST contractor wrote: Meanwhile we are checking IUSR permissions on the Mid-Tier installation directory. Please NOTE: These errors do not occur against the same ARServer 6.3, patch 11, with Mid-Tier 6.3, patch 13 nor with Mid-Tier Version 7.0.00 Patch 001 Thanks, Michelle On different servers Mid-Tier 6.3, Patch 17; Mid-Tier 6.3, Patch 13; Mid-Tier 7.0, Patch 01 Windows 2003/IIS 6.0/Servlet Exec 5.0 P06 Hi Michelle, you might ran into that Error because your ARS Server has an prior Patch Version than on your Mid-Tier. When we upgraded our 6.3 to p16 it was recommended to bring both Systems to Patch Level 16. You should find this info in the readme.txt from the Installer Package. regards, Simon ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Incident Management install woes
Hi, I have Oracle 10G R2 on Windows Server 2003 and ARS 7. My Incident Management 7 install took hours and the log files report many errors. The vast majority of .arx and .def files failed to import. Several times during the install the following error was displayed 'Driver command completed with error' I OK'd this, and the install appeared to resume and eventually completed without any Remedy-like notification that there were problems. Any ideas what might be wrong? I installed all the prerequisites in the specified order and licenced ARS and Incident Management beforehand. Thanks Kieran O'Hare Programmer Information Systems Services 200/201 Pearse St. Trinity College Dublin 2 Phone +353 1 8962774 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
preventing a help desk ticket to be closed when task are open.
I am trying to make it so a help desk ticket can not be closed is there are and open child task attached to it. I'd like to hear your take on this. AR 6.3 SQL 2003 Windows Server 2003 Thanks, Dan ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Deleted Groups
You're getting into deep expletive deleted. If by system basically hangs, you mean that the server process is executing, but unresponsive, you'll need to stop/restart it. Deleting Group would likely clear cache (although I've never personally done it). It would also undo/negate arreload (of group cache). And it would invalidate your users - they're no longer members of a group. You need the Administrator group (1). If you deleted Group form, it's gone. The only way I know to add a group, by other than an update to Group form, is to run arcache with the -Ga option to create it. Check the documentation for other options (-i1 for Group ID 1/Administrator, -c0 for Group category 0/regular, etc.). Afterwards, if User cache is OK, you should be able to login in and import group.def and group.arx to recover the remaining groups. If user cache is gone as well, you'll need to re-run arcache with the -Ua option (plus others) to add an administrator id. Easy enough to find out - try to log in or run arreload (which requries you to specify a valid login). Good luck. You're having a bad day. Mike White Office: 813-978-2192 E-mail: [EMAIL PROTECTED] Kathy Morris [EMAIL PROTECTED]To: arslist@ARSLIST.ORG OL.COM cc: Sent by: Action Subject: Re: Deleted Groups Request System discussion list(ARSList) [EMAIL PROTECTED] ORG 07/27/2006 12:39 Please respond to arslist ** I tried arreload, arcache. Then I deleted the group form, and tried to import a clean version of the group form with new data. The system basically hangs. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: preventing a help desk ticket to be closed when task are open.
** This is ITSM Help or your own help desk application?On 7/27/06, Dan Caissie [EMAIL PROTECTED] wrote: I am trying to make it so a help desk ticket can not be closed is there areand open child task attached to it. I'd like to hear your take on this.AR 6.3SQL 2003Windows Server 2003Thanks,Dan___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineer www.specificintegration.com703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: preventing a help desk ticket to be closed when task are open.
You could have a display only field that is set with any value if there is an open child ticket. Give the users an error message if the field is not null. HTH, Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile USA Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-490-3296 sf49fanv AIM IM RogerNall Yahoo IM -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dan Caissie Sent: Thursday, July 27, 2006 12:58 PM To: arslist@ARSLIST.ORG Subject: preventing a help desk ticket to be closed when task are open. I am trying to make it so a help desk ticket can not be closed is there are and open child task attached to it. I'd like to hear your take on this. AR 6.3 SQL 2003 Windows Server 2003 Thanks, Dan ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: preventing a help desk ticket to be closed when task are open.
** Sorry about that ITSM Help Desk Dan Caissie Remedy Administrator / Developer United Natural Foods, Inc 260 Lake rd Dayville, CT 06241 (860) 779-2800 Ext: 32380 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank Caruso Sent: Thursday, July 27, 2006 1:02 PM To: arslist@ARSLIST.ORG Subject: Re: preventing a help desk ticket to be closed when task are open. ** This is ITSM Help or your own help desk application? On 7/27/06, Dan Caissie [EMAIL PROTECTED] wrote: I am trying to make it so a help desk ticket can not be closed is there are and open child task attached to it. I'd like to hear your take on this. AR 6.3 SQL 2003 Windows Server 2003 Thanks, Dan ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer www.specificintegration.com 703-376-1249 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: preventing a help desk ticket to be closed when task are open.
Add a field to the task that is HD Status - just copy the field right off of the HD form. Add 1 piece of workflow that always pushes the HD status to the tasks on modify. Add 1 piece of workflow that generates an error (and prevents closure) if the HD status = Resolved and the Task status Resolved. William Rentfrow Principal Consultant, StrataCom [EMAIL PROTECTED] O 952-432-0227 C 701-306-6157 -Original Message- From: Action Request System discussion list(ARSList) on behalf of Dan Caissie Sent: Thu 7/27/2006 12:04 PM To: arslist@ARSLIST.ORG Subject: Re: preventing a help desk ticket to be closed when task are open. ** Sorry about that ITSM Help Desk Dan Caissie Remedy Administrator / Developer United Natural Foods, Inc 260 Lake rd Dayville, CT 06241 (860) 779-2800 Ext: 32380 From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Thursday, July 27, 2006 1:02 PM To: arslist@ARSLIST.ORG Subject: Re: preventing a help desk ticket to be closed when task are open. ** This is ITSM Help or your own help desk application? On 7/27/06, Dan Caissie [EMAIL PROTECTED] wrote: I am trying to make it so a help desk ticket can not be closed is there are and open child task attached to it. I'd like to hear your take on this. AR 6.3 SQL 2003 Windows Server 2003 Thanks, Dan ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer www.specificintegration.com 703-376-1249 __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
Error Messages Web Services
** ARS 6.3 patch 16 SQL 2K WIN2K I have never worked with Web Services so please excuse my ignorance. Part of the testing plan that has been laid out for this is for the system that Remedy is calling to return an error message. My question is how will Remedy handle this error message? Would something actually be returned to the user? Any help is greatly appreciated. Thanks, Roger A. Nall OSSNMS Sr. Remedy Administrator/Developer T-Mobile USA Desk: 973-644-3963 Cell: 973-652-6723 FAX: 973-490-3296 sf49fanv AIM IM RogerNall Yahoo IM __20060125___This posting was submitted with HTML in it___
Re: preventing a help desk ticket to be closed when task are open.
** 1. Create a filter that does a set fields action looking for any tasks with that HD tickets ID that are less than closed. Save the result in a temp field. Thsi will run of the HSD ticket status is changing to Closed.2. Create another filter that checks the Temp field and if it is not null then pop and error message that says there are tasks still open. On 7/27/06, William Rentfrow [EMAIL PROTECTED] wrote: Add a field to the task that is HD Status - just copy the field right off of the HD form.Add 1 piece of workflow that always pushes the HD status to the tasks on modify.Add 1 piece of workflow that generates an error (and prevents closure) if the HD status = Resolved and the Task status Resolved. William RentfrowPrincipal Consultant, StrataCom[EMAIL PROTECTED]O 952-432-0227C 701-306-6157-Original Message-From: Action Request System discussion list(ARSList) on behalf of Dan Caissie Sent: Thu 7/27/2006 12:04 PMTo: arslist@ARSLIST.ORGSubject: Re: preventing a help desk ticket to be closed when task are open.**Sorry about that ITSM Help Desk Dan CaissieRemedy Administrator / DeveloperUnited Natural Foods, Inc260 Lake rdDayville, CT 06241(860) 779-2800Ext: 32380 From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Frank CarusoSent: Thursday, July 27, 2006 1:02 PMTo: arslist@ARSLIST.ORGSubject: Re: preventing a help desk ticket to be closed when task are open.** This is ITSM Help or your own help desk application?On 7/27/06, Dan Caissie [EMAIL PROTECTED] wrote:I am trying to make it so a help desk ticket can not be closed is there areand open child task attached to it.I'd like to hear your take on this.AR 6.3SQL 2003 Windows Server 2003Thanks,Dan___UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org --Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com703-376-1249 __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-- Frank CarusoSpecific Integration, Inc.Senior Remedy Engineerwww.specificintegration.com 703-376-1249 __20060125___This posting was submitted with HTML in it___
Re: Deleted Groups
** Kathy, Whats happening is the server process is looking for your group form and the user form when executing any request, and not finding one of them it hangs... You need to back track.. it might not be straight forward.. I'd first check to see what was the ID if the group form in the arschema - off course if you have deleted this form - thatrecord will bemissing but you could try to restore'last goodbackup' of the arschema.. On doing so,check what the schema IDof thegroup form in the arschema was.. Then restore theT, H tables belonging to that schema ID. Restore the data that was in these tables.. Make sure that the nextid in the arschema for the group form is consistent with the number of records existing in the T table of the group form after the restore - if not update it so that you will not get a violation of any unique index later... Also make sure that after youare done with these restore you restore the group_cache table from the last good backup... I would also check to see if there might be an inconsistency on the arcontainer table as you don't want to be denied a nextid for a new schemayou want to create after all theserestoration work is done... Lastly good luck.. you need it! Cheers Joe D'Souza Remedy Developer / Consultant, BearingPoint, Virginia. - Original Message From: Kathy Morris [EMAIL PROTECTED]To: arslist@ARSLIST.ORGSent: Thursday, July 27, 2006 12:39:00 PMSubject: Re: Deleted Groups** I tried arreload, arcache. Then I deleted the group form, and tried to import a clean version of the group form with new data. The system basically hangs. __20060125___This posting was submitted with HTML in it___
JOB: Permanent Remedy Developer Position in San Francisco, CA
Hi, UCSF is looking for a Permanent Remedy Developer. For details, go to http://www.ucsfhr.ucsf.edu/careers/, and search on Req Number 19588BR. Thanks, Helen Tao Lead Remedy Developer [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Incident Management install woes
Similar situation... I am installing the Incident 7.0 module today. After a few hours I received this error: Error Number: 0x80040707 Description There was no description. When I clicked OK I received this error: start of error message An error (-5012 : 0x8000) has occurred while running setup. Please make sure you have finished any previous setup and closed other applications. If the error still occurs, please contact your vendor: MBC Software, Inc. (http//www.bmc.com). Error Code: -5012 : 0x8000 Error Information: Ctor\ObjectWrapper.cpp (332) Ctor\ObjectWrapper.cpp (201) SetupDLL\SetupDLL.cpp (1397) PAPP:BMC Remedy Incident Management PVENDOR:BMC Software, Inc. (http://www.bmc.com) PGUID:79F12E66-C4A0-4899-9C59-D0BD23BC9E21 $10.1.0.238 @Windows Service Pack 1 (3790) IE 6.0.3790.1830 end of error message I checked this solution from InstallSheild but all registry entries are fine. http://consumer.installshield.com/kb.asp?id=Q108167. There is plenty of disk space and I am installing with a Local Administrator account (Windows Server 2003). I will to try the installation again. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare Sent: Thursday, July 27, 2006 11:49 AM To: arslist@ARSLIST.ORG Subject: Incident Management install woes Hi, I have Oracle 10G R2 on Windows Server 2003 and ARS 7. My Incident Management 7 install took hours and the log files report many errors. The vast majority of .arx and .def files failed to import. Several times during the install the following error was displayed 'Driver command completed with error' I OK'd this, and the install appeared to resume and eventually completed without any Remedy-like notification that there were problems. Any ideas what might be wrong? I installed all the prerequisites in the specified order and licenced ARS and Incident Management beforehand. Thanks Kieran O'Hare Programmer Information Systems Services 200/201 Pearse St. Trinity College Dublin 2 Phone +353 1 8962774 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
OT: Filenames from BMC
rant I think we may want to take up a collection to give to BMC to hire someone to name files in a meaningful way. Many of the documentation manuals, for example, have names like CMRN70.pdf. Every modern operating system can handle long filenames. Why can't they name it something like ChangeManagementReleaseNotes_700.pdf? /rant Stephen ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Deleted Groups
QUICK CORRECTION! arcache will work as it writes straight to the DB tables. so try using that and restart the server as long as your group_cache table and the group form exists and the group form has the relevant schema id. arreload will not work as it goes through the api. Its been a long day! --- Sabyson Fernandes [EMAIL PROTECTED] wrote: Kathy, Does the AR System server come up or does it report anything in the arerror.log? Take a look at the arerror.log file and it may give some indication on what is going on. In your email you have not specified if you managed to sucessfully import the Group form from a def file. I'm not sure how sucessful this will be as I remember in past releases the Group form had to have a specific id in the arschema table. I think this was 10 (not sure what release you are running or if that is still the case). If the AR Server is failing to start the arreload/arcache is not going to help as they connect through the Remedy api and requires the server to be running. In this case, your best and probably only option maybe to restore the DB from a backup and try restarting the server or re-installing the server with the DB upgrade option. If the ar server is running, then you may not be allowing arcache and arreload. Check this in your admin tool under server preferences - advanced tab. You can also check this directly in the ar.conf/ar.cfg file and set appropriately. Also do you have specific ports you use or the default register with portmapper? If you do not use portmapper then you have to set the ARTCPPORT variable for arcache to work. If you change the entries in the ar.conf/ar.cfg file you need to run arsignal -c server name so the server reads the config file. Once this is done you can then run arcache utility to create entries in the group_cache table and user_cache table Group cache entry: ./arcache -Ga -e001 -i 1 -t 2 -n Administrator -s server name -d User cache entry: ./arcache -Ua -e99 -n tempuser -p -g1; -lw 1 -s -d Now attempt to login to the Admin tool and if succesful, check if the group form exists. If it does then login to the import tool using the tempuser account just created and import the Group.arx file to restore the default groups (available on the server install directory). Login to the user tool and create an admin user. Hope this helps. Regards, Saby --- Kathy Morris [EMAIL PROTECTED] wrote: I tried arreload, arcache. Then I deleted the group form, and tried to import a clean version of the group form with new data. The system basically hangs. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Permanent Remedy Developer Position in San Francisco, CA
You can look that up on the website - basically min. is about 65K, max is about $108k plus benefits. (Not that I'm looking - just doing market research...) Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ocampo, Erwin Sent: Thursday, July 27, 2006 10:59 AM To: arslist@ARSLIST.ORG Subject: Re: Permanent Remedy Developer Position in San Francisco, CA Helen, What is the salary range assuming you meet the experience requirements? Thanks, Erwin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Helen Tao Sent: Thursday, July 27, 2006 10:15 AM To: arslist@ARSLIST.ORG Subject: JOB: Permanent Remedy Developer Position in San Francisco, CA Hi, UCSF is looking for a Permanent Remedy Developer. For details, go to http://www.ucsfhr.ucsf.edu/careers/, and search on Req Number 19588BR. Thanks, Helen Tao Lead Remedy Developer [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Permanent Remedy Developer Position in San Francisco, CA
And that seems low to me, given that we can't even buy a condo for much less than a millionhmm and SF is one of the most expensive cities in the country. LOL :) Candace -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Thursday, July 27, 2006 11:08 AM To: arslist@ARSLIST.ORG Subject: Re: Permanent Remedy Developer Position in San Francisco, CA You can look that up on the website - basically min. is about 65K, max is about $108k plus benefits. (Not that I'm looking - just doing market research...) Rick -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ocampo, Erwin Sent: Thursday, July 27, 2006 10:59 AM To: arslist@ARSLIST.ORG Subject: Re: Permanent Remedy Developer Position in San Francisco, CA Helen, What is the salary range assuming you meet the experience requirements? Thanks, Erwin -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Helen Tao Sent: Thursday, July 27, 2006 10:15 AM To: arslist@ARSLIST.ORG Subject: JOB: Permanent Remedy Developer Position in San Francisco, CA Hi, UCSF is looking for a Permanent Remedy Developer. For details, go to http://www.ucsfhr.ucsf.edu/careers/, and search on Req Number 19588BR. Thanks, Helen Tao Lead Remedy Developer [EMAIL PROTECTED] __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org - * This message contains information from Silicon Valley Bank, or from one of its affiliates, that may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify the sender immediately by telephone or by replying to this transmission. This message may include indicative rate information relating to one or more products offered through Silicon Valley Bank, or affiliated broker-dealer, SVB Securities. Rates and yields shown are provided for informational purposes only, are not guaranteed, and are subject to market conditions and availability. Nothing in this communication shall constitute a solicitation or recommendation to buy or sell a particular security. Columbia Cash Reserves, Columbia Treasury Reserves, Columbia Institutional Cash Reserves, SVB Securities Liquid Reserves, SVB Securities Institutional Liquid Reserves and SVB Securities Horizon Shares are offered through SVB Securities, a registered broker- dealer and non-bank affiliate of Silicon Valley Bank. Investments in these products require the involvement of a licensed representative of SVB Securities. Investment products offered through SVB Securities are not insured by the FDIC or any other Federal Government Agency, are not deposits of or guaranteed by Silicon Valley Bank or its affiliates, and may lose value. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Deleted Groups
** Kathy, I tested the emptying of the Group form and re-importing today. Both when deleting the Group records and when importing Group records it took a very long time. I had thought it locked up. I was able to get it to work by letting it have as much time as it needed - about 30 minutes. Is it possible that it just needs more time? Stephen From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy MorrisSent: Thursday, July 27, 2006 2:42 PMTo: arslist@ARSLIST.ORGSubject: Re: Deleted Groups ** Yes, I was able to successfully import the Group form from Prod to Dev. However when I try to import the group.arx into the group form, the application hangs. I am on 6.3 AR, patch 17. I use the default ports. I reinstalled an upgrade of AR Server 6.3. __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Deleted Groups
** This is a good question I thought the applicationwas hung, because I import all the time and it doesn't usually take 30 minutes for about 20 groups. __20060125___This posting was submitted with HTML in it___
Re: OT: Visio / ARS
** Thank you, I tried with the SQL ODBC driver and got it to work. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Michiel Beijen Sent: Wednesday, July 26, 2006 10:35 AM To: arslist@ARSLIST.ORG Subject: Re: OT: Visio / ARS ** In despite of the odbc driver beiing developed for Crystal Reports, you can use it to populate for instance MS Excel, MS Access or SQL Server databases - with limitations. However, you can not use it to 'reverse engineer' the database as MS Visio 2003 does. See the errors listed underneath. This is because the ODBC driver does not seem to provide certain details about the columns that Visio uses. If you set up an ODBC connection to your database (either Oracle or MS SQL) instead of using the AR System ODBC driver you should be fine. -- Michiel Reverse engineering from database 'arserver' on server ''... Extracting columns of table 'AP-Sample:Company'. Error! Cannot extract column definition for the table/view 'AP-Sample:Company'. The definition is not available or you may not have sufficient privileges. Please check with your database administrator. Extracting columns of table 'AP-Sample:Lunch Scheduler'. Error! Cannot extract column definition for the table/view 'AP-Sample:Lunch Scheduler'. The definition is not available or you may not have sufficient privileges. Please check with your database administrator. Extracting columns of table 'AP-Sample:Lunch-Detail'. Error! Cannot extract column definition for the table/view 'AP-Sample:Lunch-Detail'. The definition is not available or you may not have sufficient privileges. Please check with your database administrator. Visio is checking the reverse engineered model ... Fixing up the diagram ... Tables reverse engineered : 3; Time taken (in secs) : 5.41 Check Clauses Reverse Engineered : 0; Time Taken (in secs) : 0.00 Primary Keys reverse engineered : 0; Time taken (in secs) : 0.00 Foreign Keys reverse engineered : 0; Time taken (in secs) : 0.00 Indexes reverse engineered : 0; Time taken (in secs) : 0.00 Triggers reverse engineered : 0; Time taken (in secs): 0.00 Views Reverse Engineered : 0; Time Taken (in secs) : 0.00 Procedures reverse engineered : 0; Time taken (in secs): 0.00 Total elapsed time(in secs): 5.42 On 7/25/06, Lammey, Peter A. [EMAIL PROTECTED] wrote: ** I dont think so. I tried it with the ODBC setting checked and with it unchecked and I still got the same result. I doubt this can work since the ODBC driver was compiled and setup specifically for Crystal Reports. Thanks Peter Lammey ESPN MIT Technical Services Applications Management 860-766-4761 mitted with HTML in it___ __20060125___This posting was submitted with HTML in it___
Re: Incident Management install woes
This looks like a memory error Stephen. I got lots of those trying to install 6.x apps where we had McAfee running. We solved the problem by disabling McAfee, after which installation proceeded fine, but not sure if that is the case in your situation. :) Candace -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, July 27, 2006 10:27 AM To: arslist@ARSLIST.ORG Subject: Re: Incident Management install woes Similar situation... I am installing the Incident 7.0 module today. After a few hours I received this error: Error Number: 0x80040707 Description There was no description. When I clicked OK I received this error: start of error message An error (-5012 : 0x8000) has occurred while running setup. Please make sure you have finished any previous setup and closed other applications. If the error still occurs, please contact your vendor: MBC Software, Inc. (http//www.bmc.com). Error Code: -5012 : 0x8000 Error Information: Ctor\ObjectWrapper.cpp (332) Ctor\ObjectWrapper.cpp (201) SetupDLL\SetupDLL.cpp (1397) PAPP:BMC Remedy Incident Management PVENDOR:BMC Software, Inc. (http://www.bmc.com) PGUID:79F12E66-C4A0-4899-9C59-D0BD23BC9E21 $10.1.0.238 @Windows Service Pack 1 (3790) IE 6.0.3790.1830 end of error message I checked this solution from InstallSheild but all registry entries are fine. http://consumer.installshield.com/kb.asp?id=Q108167. There is plenty of disk space and I am installing with a Local Administrator account (Windows Server 2003). I will to try the installation again. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kieran O'Hare Sent: Thursday, July 27, 2006 11:49 AM To: arslist@ARSLIST.ORG Subject: Incident Management install woes Hi, I have Oracle 10G R2 on Windows Server 2003 and ARS 7. My Incident Management 7 install took hours and the log files report many errors. The vast majority of .arx and .def files failed to import. Several times during the install the following error was displayed 'Driver command completed with error' I OK'd this, and the install appeared to resume and eventually completed without any Remedy-like notification that there were problems. Any ideas what might be wrong? I installed all the prerequisites in the specified order and licenced ARS and Incident Management beforehand. Thanks Kieran O'Hare Programmer Information Systems Services 200/201 Pearse St. Trinity College Dublin 2 Phone +353 1 8962774 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org - * This message contains information from Silicon Valley Bank, or from one of its affiliates, that may be confidential and privileged. If you are not an intended recipient, please refrain from any disclosure, copying, distribution or use of this information and note that such actions are prohibited. If you have received this transmission in error, please notify the sender immediately by telephone or by replying to this transmission. This message may include indicative rate information relating to one or more products offered through Silicon Valley Bank, or affiliated broker-dealer, SVB Securities. Rates and yields shown are provided for informational purposes only, are not guaranteed, and are subject to market conditions and availability. Nothing in this communication shall constitute a solicitation or recommendation to buy or sell a particular security. Columbia Cash Reserves, Columbia Treasury Reserves, Columbia Institutional Cash Reserves, SVB Securities Liquid Reserves, SVB Securities Institutional Liquid Reserves and SVB Securities Horizon Shares are offered through SVB Securities, a registered broker- dealer and non-bank affiliate of Silicon Valley Bank. Investments in these products require the involvement of a licensed representative of SVB Securities. Investment products offered through SVB Securities are not insured by the FDIC or any other Federal Government Agency, are not deposits of or guaranteed by Silicon Valley Bank or its affiliates, and may lose value. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Documentum and Remedy...
** Has anyone done any type of integration between Documentum and Remedy, preferably searched attachments in Documentum through Remedy, add documents to Documentum through Remedy and display documents in Documentum in Remedy Alexander P. Gray Operations Planning Manager, ITS/ICS COE, Infrastructure Technology [EMAIL PROTECTED] [EMAIL PROTECTED] --- 703. 676. 2375 (office) 703. 932. 9979 (nextel) 703. 676.2931 (fax) __20060125___This posting was submitted with HTML in it___
Import Error
Hi guys, I'm trying to import a file but receiving the following errors. Total length of all fields involved in an index is greater than the maximum length allowed: (ARERR 210) The following item was not imported: HPD:HelpDesk (ARERR 55). ARS 6.0 Oracle 8i Any word of wisdom. Thanks in advance. Dipen _ Dont just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/ ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Incident Management install woes
Did an incident 7.0 install yesterday. All items in the html log showed as successful. Environment Specs: App Server (Sunfire 440 2x1.2ghz 4gb Memory) - LANG/LC_ALL=en_US.UTF-8 Oracle 10.2.0 client - NLS_LANG=american Remote Oracle 9.2 db (Sunfire 880 4x1.2ghz 8gb memory) - Instance uses UTF-8 character set App Specs (Listed in order of installation) - ARServer 7.0 p001 - Email 7.0 p001 - FB History Daemon 7.0 p001 - Approval 7.0 - Assignment Engine 7.0 - CMDB 2.0 - Incident 7.0 - Problem 7.0 - Change 7.0 - Asset 7.0 ARServer install info - This was a new install - All languages were installed for ARServer - Portmappper was not used Special considerations: - We already had a tablespace, db user, rollback segment, and temp tablespace in place prior to the install. I updated the install script to not require Oracle system access for the installation, for security considerations. - Patch to allow the install not requiring system access (Oracle/Solarips only): --- ar_install.bak Mon Jul 24 10:41:19 2006 +++ ar_install Mon Jul 24 21:36:28 2006 @@ -10739,6 +10739,11 @@ done $RM /tmp/drop_user.ora$$ /dev/null 21 +echo User action required: Empty the following files\n +echo clear the contents of /tmp/arinit.ora\n +echo Press enter to when complete\n +read n /dev/tty + lecho Building the ORACLE database may take a few minutes. lecho Please wait lecho - Installed as a non-root user (all apps) - FB install script required changes to accomplish this Problems we ran into: - Installing all languages causes the import of 2k record into the localized messages form. To work around this, I crafted a license file I put in place prior to the install - The ARServer install script exited abnormally. During the FB forms install, the install exited with an invalid operator error. This was corrected by updating the install script. - Patch to correct (only applipes to new installs): --- ar_install.bak Mon Jul 24 10:41:19 2006 +++ ar_install Mon Jul 24 21:36:28 2006 @@ -11780,6 +11785,7 @@ # Stage 6 : Set up sample forms and Demo +ARS_VER=0; export ARS_VER STAGE=6 LogOnly Stage 6: `date` if [ $FRESH_INSTALL -eq 1 ]; then - Expected to see an approval server process, but it is now a plugin. - During the install of Problem, Change, and Asset, the import of the following data (arx) failed: - Form: PDL:ESIDversioninfo - Records: 1 - Data File: /app name/ar/pdl/workflow/en/./PDL_ESIDversioninfo_cfg.arx - This record failed to import because the entry id was 003 for all 3 of the referenced apps, but was 001 during the install of Incident. The record was identical with the exception of the eid, but violated a unique index. Axton Grams On 7/27/06, Jason Miller [EMAIL PROTECTED] wrote: ** Here is a tip on Stephen's tip regarding Windows Task Manager... CTRL+SHIFT+ESC will also bring it up. Very helpful especially when in a Remote Desktop connection and Ctrl+Alt+Delete wants to control your local machine and not the remote machine. Also a great tool for watching processes is a free app Process Explorer by Sysinternals. It will show you TCP/IP connections that an app is using (i.e. aruser.exe), resource usage by process, show you DLL info and what DLLs an app is using. You can even set it to replace the Windows Task Manager so it is invoked with CTRL+SHIFT+ESC. http://www.sysinternals.com/Utilities/ProcessExplorer.html Microsoft just acquired them last week so who knows how long this will be here for free, you may want to check it out soon. Jason On 7/27/06, Heider, Stephen [EMAIL PROTECTED] wrote: BTW, here's a tip... When installing Incident (on Windows) or any of the mammoth installations from BMC keep the Task Manager open and the Performance tab selected. If you have already started the installation press Ctrl+Alt+Delete and select Task Manager. With the installation program hiding all windows and taking up the entire screen I did not notice the error message I detailed in the previous message - it was hiding behind the install window. It could have been there for an hour or more. When the Task Manager is open it allows you to see your task bar and any open windows. The Performance tab will also show the CPU utilization. If it drops to less than 5% for an extended period of time it could be the installation locked up. If so, at least you won't be waiting for hours. Stephen -Original Message- From: Action Request System discussion list(ARSList) [mailto: [EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, July 27, 2006 1:27 PM To: arslist@ARSLIST.ORG Subject: Re: Incident Management install woes Similar situation... I am installing the Incident 7.0 module today. After a few hours I received this error: Error Number: 0x80040707 Description There
