Re: How to install a second instance?
Axton, You can use the same oracle instance, just a different schema. Instead of the default schema, aradmin, use a different name, like aradmin02. If you run the installer and provide the oracle system account password, the installer should be capable of creating a new account, aradmin02. I'm not sure how to do it. Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Field/context-sensitive help
Michael, I know this thread is a bit old, but I thought I would chip in all the same... I am not sure what you mean by a normal programming language, however, here is one way to approach this idea in ARS... The trick will be to trigger the workflow. Since you want the trigger to be user focuses on Field ID/Field Name then you will need an active link for every field that the user can set focus to. Think of these Active Links as HTML attributes of a form field of onMouseOver or onFocus. ( Not that I would call HTML a normal programming language. :) Now what you likely want to trigger is a reusable subroutine. In ARS you can think of an Active Link guide as that kind of construct if you can correctly identify all that you need to do in a generic way for the function/Sub to be generic enough to work for all cases. In this case I think you can do exactly that. And to finish the programming speak... ARS only has a global scope for all active links on a given form. So your Guides do not loose access to any of the fields on the form when they are called, and any changes to the values that they make will be retained after the guide finishes. [Oh.. and there is a special case for communicating between forms in a session, and between forms of the same class(form name) but those are other programming concepts in ARS best addressed in other threads.] In the Active Link Guide you need one or two more Active Links. The first active link does a SetField action to get the data from the form that holds the help text using the keywords $SCHEMA$, and $FIELDID$ (or $FIELDNAME$ if you prefer, but I would go with FIELDID) and it would return the HelpText value from the other form to a local field on the screen for the user. The second one might add some default text to the returned HelpText field if it is still null, and maybe do some extra workflow to request someone to write some helptext for the field. (Like open a ticket, or do a Push action to trigger some emails to be sent, etc...) Another approach would be to not have a form to hold this data. You could also use the keyword $FIELDHELP$ to get the help that has been defined for the field via the Admin tool too. However I do see the advantages to holding this data in a data form and not in the ARS Object definitions if the help information changes often enough. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 7/25/07, Durrant, Michael M. - ITSD [EMAIL PROTECTED] wrote: ** Here's my idea - tell me if I'm crazy: I want to create a form with the following: Form Name Field ID/Field Name Help Text When a user focuses on Field ID/Field Name on Form Name, a text field would be set with the contents of Help Text. I know I could do this with a truckload of Active Links - but I really don't want to I know how I could do it in a normal programming environment - how can I do it in Remedy? Thanks, Michael ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: INI values
David, Actually if your users are using a preference server, (and they should be IMHO) then that setting is part of the AR System User Preferences form. ( It is just a field, so set the value for the user, or add a filter to force the value to be set to the right thing. ) Do you really want/need to manage the INI files on all the client hosts? -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 7/26/07, Shellman, David [EMAIL PROTECTED] wrote: ** Does QueryonReturn=1 ring any bells? Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Wednesday, July 25, 2007 4:52 PM To: arslist@ARSLIST.ORG Subject: INI values ** Any of you old timers have a list of the undocumented settings that could be added to the ar.ini file? I think I'm looking for the OnReturn setting that triggered the search window to launch when the Enter key was pressed. Anyone get them to work with the 7.x client? Thanks, Dave Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] Tyco Electronics MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: INI values
I was only looking to modify one or two files for special people. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 08:58:52 2007 Subject: Re: INI values David, Actually if your users are using a preference server, (and they should be IMHO) then that setting is part of the AR System User Preferences form. ( It is just a field, so set the value for the user, or add a filter to force the value to be set to the right thing. ) Do you really want/need to manage the INI files on all the client hosts? -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 7/26/07, Shellman, David [EMAIL PROTECTED] wrote: ** Does QueryonReturn=1 ring any bells? Dave From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shellman, David Sent: Wednesday, July 25, 2007 4:52 PM To: arslist@ARSLIST.ORG Subject: INI values ** Any of you old timers have a list of the undocumented settings that could be added to the ar.ini file? I think I'm looking for the OnReturn setting that triggered the search window to launch when the Enter key was pressed. Anyone get them to work with the 7.x client? Thanks, Dave Dave Shellman Phone: (717) 810-3687 Fax:(717) 810-2124 email: [EMAIL PROTECTED] Tyco Electronics MS 161-043 PO Box 3608 Harrisburg, PA 17105-3607 __20060125___This posting was submitted with HTML in it___ __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: View Field HTML Email Templates
Shawn, I think I would send a second email. Then have that email be picked up by the Email engine and routed into a ticket so that the work of sending the snail mail could be tracked too. The body of the second email (picked up in to an ARS form by the Email Engine) should be what your after. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 7/27/07, Shawn Stonequist [EMAIL PROTECTED] wrote: Greetings List!!! I've setup a series of HTML Email templates for one of our customers that successfully sends under various conditions when the end-user list in the entry has an email address- everything works perfectly! Now, this customer wants to be able to make a printout to be snail-mailed to end-users that do not have email addresses. I had two thoughts on how to do this, but neither has been successful: 1) Create a View Field, with a Set Field action that pulls the HTML Email Template, then the user can right-click and print. 2) Send the user to an HTML webpage that displays the HTML Email Template. I prefer #1, since any updates will be applied to both x-mails at the same time, however, on neither of these options have I been able to get the values to populate (e.g. #$$Last Name$$# in the email is still #$$Last Name$$# in the View field, even though the Last Name should display Smith instead). Any ideas? My only other thought was to email the user, and they would then print from their email, though this would involve several more steps and a waiting period, which they would prefer to avoid. Thanks SOOO much!!! Shawn Stonequist EMNS, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Newbie help with creating a SQL menu
Hi: I have created a menu that should list value for all fields in a database. The SQL command for the menu I am using is the following. select distinct(LOCATION) from REMEDY.LOCATIONS I have associated this menu with a field in my form. When I click on the pulldown menu for the field, I get the following error ARERR [90] Cannot establish a network connection to the AR System server : 192.168.2.219 (0) : RPC: Program not registered The database I am connecting to is the database remedy uses and the database runs on a different server. I can log into that database fine using a sqlplus client. 1. Is there anything else I need to do for the SQL menu to work? 2. How does the sql menu know what is the password for the REMEDY user in the database? 3. How does it know the ORACLE_SID to be used for this query? Thanks Ray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Job Posting - Lead Remedy Developer
Microsoft did it -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Ron Legters Sent: Friday, July 27, 2007 4:16 PM To: arslist@ARSLIST.ORG Subject: Re: Job Posting - Lead Remedy Developer ...and if you know who made off with our carriage returns, we'd appreciate getting them back. ;-) Ron Legters Tools Administrator Data Systems Services Univar USA Inc. 425.889.3952 Office 425.889.4111 Fax www.univarusa.com From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of mj2carlson Sent: Friday, July 27, 2007 11:32 AM To: arslist@ARSLIST.ORG Subject: Job Posting - Lead Remedy Developer ** http://utdirect.utexas.edu/pnjobs/pnjobsvw.WBX?job_nbr=070720019319 The University of Texas at Austin Job Posting Job title Senior Systems Analyst Posting number 07-07-20-01-9319 Date available Immediately Monthly salary $ 4275 negotiable depending on qualifications. Hours per week 40.00 Standard from 800AM to 500PM Location Austin (main campus) Purpose of position This position will be responsible for providing the technical vision and architecture of an enterprise-wide, mission critical solution constructed on the BMC Remedy Action Request System application server platform. Essential functions Act as a subject matter expert on Remedy applications for BMC Remedy Service Management 7.x and related architecture. Provide system/application design engineering solutions that align with Remedy and industry standards. Work proactively to ensure high performance, high reliability and rapid trouble resolution of Remedy ARS workflow. Lead and mentor other Remedy developers. Responsible for development of and lifecycle maintenance for service management workflows using Remedy AR System and Remedy Service Management suite. Define Remedy development standards and practices. Build integration plans and Remedy architecture/development roadmap that identify deliverables and values to the business. Show ownership and accountability for support of Remedy systems. Evaluate third-party tool solutions as required. Conduct training to educate customers and team members regarding Remedy support and development. Document all engineered solutions including ongoing maintenance requirements. Evaluate and recommend improvement measures. Required qualifications Bachelor's degree. Three years of experience in systems design, analysis and programming. 5+ years experience in Remedy systems development/architecture (ARS 6.x, ITSM suite custom development). Experience defining and leading IT improvement projects. Solid understanding of UNIX and Windows-based operating systems. Solid understanding of networking/distributed computing environment concepts. Technical documentation of system application development functional requirements and project planning. Experience with Change Management/Change Control tools. Working understanding of SQL and relational databases. Working understanding of XML concepts and implementations. Ability to communicate effectively, both written and oral. Equivalent combination of relevant education and experience may be substituted as appropriate. View this message in context: Job Posting - Lead Remedy Developer http://www.nabble.com/Job-Posting---Lead-Remedy-Developer-tf4159522.htm l#a11834561 Sent from the ARS (Action Request System) mailing list archive http://www.nabble.com/ARS-%28Action-Request-System%29-f716.html at Nabble.com. __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: How to install a second instance?
The installer will ask you for the schema name/arserver instance name, just provide the values (other than aradmin/hostname) to the installer and it should take care of it for you. Axton Grams On 7/29/07, Mark Milke [EMAIL PROTECTED] wrote: Axton, You can use the same oracle instance, just a different schema. Instead of the default schema, aradmin, use a different name, like aradmin02. If you run the installer and provide the oracle system account password, the installer should be capable of creating a new account, aradmin02. I'm not sure how to do it. Thanks Mark ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Newbie help with creating a SQL menu
1. Is there anything else I need to do for the SQL menu to work? Shouldn't be 2. How does the sql menu know what is the password for the REMEDY user in the database? It already has sessions to the Oracle instance used by Remedy; it just uses those 3. How does it know the ORACLE_SID to be used for this query? It already has sessions to the Oracle instance used by Remedy; it just uses those, meaning it runs the sql against the Remedy instance as the remedy schema owner Your arerr90 is more than likely indicative of another problem. Check the arerror.log file for more info. Axton Grams On 7/29/07, Ray [EMAIL PROTECTED] wrote: Hi: I have created a menu that should list value for all fields in a database. The SQL command for the menu I am using is the following. select distinct(LOCATION) from REMEDY.LOCATIONS I have associated this menu with a field in my form. When I click on the pulldown menu for the field, I get the following error ARERR [90] Cannot establish a network connection to the AR System server : 192.168.2.219 (0) : RPC: Program not registered The database I am connecting to is the database remedy uses and the database runs on a different server. I can log into that database fine using a sqlplus client. 1. Is there anything else I need to do for the SQL menu to work? 2. How does the sql menu know what is the password for the REMEDY user in the database? 3. How does it know the ORACLE_SID to be used for this query? Thanks Ray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Field/context-sensitive help
If you do want to store the help text in the remedy data dictionary (not in a Remedy form), but do not want to use the admin tool to manage it (i.e., you want non-remedy admin/developer types to manage it), Stephen Heider has authored an app on ARSwiki that allows you to manage the help text using this method without requiring the admin tool: ARS_EditWUTHelp: Edit the Help Text for ARS fields, which is visible within the Windows User Tool http://arswiki.org/projects/dotnetutil http://arswiki.org/projects/dotnetutil/downloads This software is available under the gnu gpl license and requires .net 2.0 and the Remedy .net api. Axton Grams On 7/29/07, Carey Matthew Black [EMAIL PROTECTED] wrote: Michael, I know this thread is a bit old, but I thought I would chip in all the same... I am not sure what you mean by a normal programming language, however, here is one way to approach this idea in ARS... The trick will be to trigger the workflow. Since you want the trigger to be user focuses on Field ID/Field Name then you will need an active link for every field that the user can set focus to. Think of these Active Links as HTML attributes of a form field of onMouseOver or onFocus. ( Not that I would call HTML a normal programming language. :) Now what you likely want to trigger is a reusable subroutine. In ARS you can think of an Active Link guide as that kind of construct if you can correctly identify all that you need to do in a generic way for the function/Sub to be generic enough to work for all cases. In this case I think you can do exactly that. And to finish the programming speak... ARS only has a global scope for all active links on a given form. So your Guides do not loose access to any of the fields on the form when they are called, and any changes to the values that they make will be retained after the guide finishes. [Oh.. and there is a special case for communicating between forms in a session, and between forms of the same class(form name) but those are other programming concepts in ARS best addressed in other threads.] In the Active Link Guide you need one or two more Active Links. The first active link does a SetField action to get the data from the form that holds the help text using the keywords $SCHEMA$, and $FIELDID$ (or $FIELDNAME$ if you prefer, but I would go with FIELDID) and it would return the HelpText value from the other form to a local field on the screen for the user. The second one might add some default text to the returned HelpText field if it is still null, and maybe do some extra workflow to request someone to write some helptext for the field. (Like open a ticket, or do a Push action to trigger some emails to be sent, etc...) Another approach would be to not have a form to hold this data. You could also use the keyword $FIELDHELP$ to get the help that has been defined for the field via the Admin tool too. However I do see the advantages to holding this data in a data form and not in the ARS Object definitions if the help information changes often enough. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 7/25/07, Durrant, Michael M. - ITSD [EMAIL PROTECTED] wrote: ** Here's my idea - tell me if I'm crazy: I want to create a form with the following: Form Name Field ID/Field Name Help Text When a user focuses on Field ID/Field Name on Form Name, a text field would be set with the contents of Help Text. I know I could do this with a truckload of Active Links - but I really don't want to I know how I could do it in a normal programming environment - how can I do it in Remedy? Thanks, Michael ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Newbie help with creating a SQL menu
Hi Axton: I donot see anything in arerror.log. I have enabled logging on the remedy user client and donot see anything there as well. Not sure if his matters. This REMEDY user is not one created by remedy. It's a user our db admin has created for readonly access to a few views and tables. Thanks Ravi Axton wrote: 1. Is there anything else I need to do for the SQL menu to work? Shouldn't be 2. How does the sql menu know what is the password for the REMEDY user in the database? It already has sessions to the Oracle instance used by Remedy; it just uses those 3. How does it know the ORACLE_SID to be used for this query? It already has sessions to the Oracle instance used by Remedy; it just uses those, meaning it runs the sql against the Remedy instance as the remedy schema owner Your arerr90 is more than likely indicative of another problem. Check the arerror.log file for more info. Axton Grams On 7/29/07, Ray [EMAIL PROTECTED] wrote: Hi: I have created a menu that should list value for all fields in a database. The SQL command for the menu I am using is the following. select distinct(LOCATION) from REMEDY.LOCATIONS I have associated this menu with a field in my form. When I click on the pulldown menu for the field, I get the following error ARERR [90] Cannot establish a network connection to the AR System server : 192.168.2.219 (0) : RPC: Program not registered The database I am connecting to is the database remedy uses and the database runs on a different server. I can log into that database fine using a sqlplus client. 1. Is there anything else I need to do for the SQL menu to work? 2. How does the sql menu know what is the password for the REMEDY user in the database? 3. How does it know the ORACLE_SID to be used for this query? Thanks Ray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Newbie help with creating a SQL menu
I am not sure to which user you are referring. Any sql menu will run as the db user that remedy is configured to use to connect to the db. Axton On 7/29/07, Ray [EMAIL PROTECTED] wrote: Hi Axton: I donot see anything in arerror.log. I have enabled logging on the remedy user client and donot see anything there as well. Not sure if his matters. This REMEDY user is not one created by remedy. It's a user our db admin has created for readonly access to a few views and tables. Thanks Ravi Axton wrote: 1. Is there anything else I need to do for the SQL menu to work? Shouldn't be 2. How does the sql menu know what is the password for the REMEDY user in the database? It already has sessions to the Oracle instance used by Remedy; it just uses those 3. How does it know the ORACLE_SID to be used for this query? It already has sessions to the Oracle instance used by Remedy; it just uses those, meaning it runs the sql against the Remedy instance as the remedy schema owner Your arerr90 is more than likely indicative of another problem. Check the arerror.log file for more info. Axton Grams On 7/29/07, Ray [EMAIL PROTECTED] wrote: Hi: I have created a menu that should list value for all fields in a database. The SQL command for the menu I am using is the following. select distinct(LOCATION) from REMEDY.LOCATIONS I have associated this menu with a field in my form. When I click on the pulldown menu for the field, I get the following error ARERR [90] Cannot establish a network connection to the AR System server : 192.168.2.219 (0) : RPC: Program not registered The database I am connecting to is the database remedy uses and the database runs on a different server. I can log into that database fine using a sqlplus client. 1. Is there anything else I need to do for the SQL menu to work? 2. How does the sql menu know what is the password for the REMEDY user in the database? 3. How does it know the ORACLE_SID to be used for this query? Thanks Ray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Newbie help with creating a SQL menu
Ray, My suggestion is to connect to your AR System instance with SQL Plus as the user aradmin. Then execute the sql statement. This eliminates any issue with the AR System. Any resulting Oracle error will be displayed. If the table doesn't have a public synonym you will proably need to execute the sql statement in the form of select value from [EMAIL PROTECTED] I remember this after I try select select value from [EMAIL PROTECTED] and get a table doesn't exist error. Often the other instance may require the same user name aradmin instead of a user named remedy. There's probably a way to connect as another user but I haven't tried and it may complicate the sql statement. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 13:13:51 2007 Subject: Re: Newbie help with creating a SQL menu Hi Axton: I donot see anything in arerror.log. I have enabled logging on the remedy user client and donot see anything there as well. Not sure if his matters. This REMEDY user is not one created by remedy. It's a user our db admin has created for readonly access to a few views and tables. Thanks Ravi Axton wrote: 1. Is there anything else I need to do for the SQL menu to work? Shouldn't be 2. How does the sql menu know what is the password for the REMEDY user in the database? It already has sessions to the Oracle instance used by Remedy; it just uses those 3. How does it know the ORACLE_SID to be used for this query? It already has sessions to the Oracle instance used by Remedy; it just uses those, meaning it runs the sql against the Remedy instance as the remedy schema owner Your arerr90 is more than likely indicative of another problem. Check the arerror.log file for more info. Axton Grams On 7/29/07, Ray [EMAIL PROTECTED] wrote: Hi: I have created a menu that should list value for all fields in a database. The SQL command for the menu I am using is the following. select distinct(LOCATION) from REMEDY.LOCATIONS I have associated this menu with a field in my form. When I click on the pulldown menu for the field, I get the following error ARERR [90] Cannot establish a network connection to the AR System server : 192.168.2.219 (0) : RPC: Program not registered The database I am connecting to is the database remedy uses and the database runs on a different server. I can log into that database fine using a sqlplus client. 1. Is there anything else I need to do for the SQL menu to work? 2. How does the sql menu know what is the password for the REMEDY user in the database? 3. How does it know the ORACLE_SID to be used for this query? Thanks Ray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Installing AR, Email, Approval, CMDB ITSM on a failover server
Dear listers, We are in the process of setting up new hardware platform for Remedy server in our environment and I am not too sure how to install the AR Server on the failover server. Any help in this area would be really valuable. Here are the details: Oracle 10g R2 on a Linux Cluster AR Server 7.0.1 p2, Email Engine, FB, Approval Server, CMDB, ITSM 6.x on a W2K3 server AR Mid-Tier 7.0.1 p2 on Linux boxes distributed across various geographies Since the failover server is going to talk to the same Oracle instance as the production server, I am not entirely clear how to go about setting the secondary server with all the binaries and applications. Thanks in advance, -- Shyam ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Field/context-sensitive help
You have a similay application here: http://www.rrr.se/en/products/2.html#rrrhelptext -- Jarl On 7/29/07, Axton [EMAIL PROTECTED] wrote: If you do want to store the help text in the remedy data dictionary (not in a Remedy form), but do not want to use the admin tool to manage it (i.e., you want non-remedy admin/developer types to manage it), Stephen Heider has authored an app on ARSwiki that allows you to manage the help text using this method without requiring the admin tool: ARS_EditWUTHelp: Edit the Help Text for ARS fields, which is visible within the Windows User Tool http://arswiki.org/projects/dotnetutil http://arswiki.org/projects/dotnetutil/downloads This software is available under the gnu gpl license and requires .net 2.0 and the Remedy .net api. Axton Grams On 7/29/07, Carey Matthew Black [EMAIL PROTECTED] wrote: Michael, I know this thread is a bit old, but I thought I would chip in all the same... I am not sure what you mean by a normal programming language, however, here is one way to approach this idea in ARS... The trick will be to trigger the workflow. Since you want the trigger to be user focuses on Field ID/Field Name then you will need an active link for every field that the user can set focus to. Think of these Active Links as HTML attributes of a form field of onMouseOver or onFocus. ( Not that I would call HTML a normal programming language. :) Now what you likely want to trigger is a reusable subroutine. In ARS you can think of an Active Link guide as that kind of construct if you can correctly identify all that you need to do in a generic way for the function/Sub to be generic enough to work for all cases. In this case I think you can do exactly that. And to finish the programming speak... ARS only has a global scope for all active links on a given form. So your Guides do not loose access to any of the fields on the form when they are called, and any changes to the values that they make will be retained after the guide finishes. [Oh.. and there is a special case for communicating between forms in a session, and between forms of the same class(form name) but those are other programming concepts in ARS best addressed in other threads.] In the Active Link Guide you need one or two more Active Links. The first active link does a SetField action to get the data from the form that holds the help text using the keywords $SCHEMA$, and $FIELDID$ (or $FIELDNAME$ if you prefer, but I would go with FIELDID) and it would return the HelpText value from the other form to a local field on the screen for the user. The second one might add some default text to the returned HelpText field if it is still null, and maybe do some extra workflow to request someone to write some helptext for the field. (Like open a ticket, or do a Push action to trigger some emails to be sent, etc...) Another approach would be to not have a form to hold this data. You could also use the keyword $FIELDHELP$ to get the help that has been defined for the field via the Admin tool too. However I do see the advantages to holding this data in a data form and not in the ARS Object definitions if the help information changes often enough. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 7/25/07, Durrant, Michael M. - ITSD [EMAIL PROTECTED] wrote: ** Here's my idea - tell me if I'm crazy: I want to create a form with the following: Form Name Field ID/Field Name Help Text When a user focuses on Field ID/Field Name on Form Name, a text field would be set with the contents of Help Text. I know I could do this with a truckload of Active Links - but I really don't want to I know how I could do it in a normal programming environment - how can I do it in Remedy? Thanks, Michael ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Installing AR, Email, Approval, CMDB ITSM on a failover server
We simply mount the filesystem on the failover server since the fs is not local. All the files are the same, with a few exceptions. Since each node has a different hostname, we update the Server-Name parameter in ar.conf (awk/sed) during the failover. This is done in the arsystem script, which resides in the arsystem/bin directory. One other exception is eie, since the eie instance names seem to be bound to the hostname/Server-Name for whatever reason. We have a common hostname that is shared between the two servers, the server that gets the hostname is handled by Veritas vcs, as are the filesystem, monitoring/failover operations. We monitor the armonitor process to trigger the failover; this way we give armonitor a chance to correct things before failing over. Axton Grams On 7/29/07, Shyam Attavar [EMAIL PROTECTED] wrote: ** Dear listers, We are in the process of setting up new hardware platform for Remedy server in our environment and I am not too sure how to install the AR Server on the failover server. Any help in this area would be really valuable. Here are the details: Oracle 10g R2 on a Linux Cluster AR Server 7.0.1 p2, Email Engine, FB, Approval Server, CMDB, ITSM 6.x on a W2K3 server AR Mid-Tier 7.0.1 p2 on Linux boxes distributed across various geographies Since the failover server is going to talk to the same Oracle instance as the production server, I am not entirely clear how to go about setting the secondary server with all the binaries and applications. Thanks in advance, -- Shyam __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Installing AR, Email, Approval, CMDB ITSM on a failover server
Axton, Since the AR System is on a Win server couldn't he simply do an install on the failover server with it pointing to the production Oracle instance? The install would run as an upgrade using the same server name and all the binaries, etc would be in the same directory structure. He would need to make sure that all the config files from the production server were copied to the fail over server. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 15:08:22 2007 Subject: Re: Installing AR, Email, Approval, CMDB ITSM on a failover server We simply mount the filesystem on the failover server since the fs is not local. All the files are the same, with a few exceptions. Since each node has a different hostname, we update the Server-Name parameter in ar.conf (awk/sed) during the failover. This is done in the arsystem script, which resides in the arsystem/bin directory. One other exception is eie, since the eie instance names seem to be bound to the hostname/Server-Name for whatever reason. We have a common hostname that is shared between the two servers, the server that gets the hostname is handled by Veritas vcs, as are the filesystem, monitoring/failover operations. We monitor the armonitor process to trigger the failover; this way we give armonitor a chance to correct things before failing over. Axton Grams On 7/29/07, Shyam Attavar [EMAIL PROTECTED] wrote: ** Dear listers, We are in the process of setting up new hardware platform for Remedy server in our environment and I am not too sure how to install the AR Server on the failover server. Any help in this area would be really valuable. Here are the details: Oracle 10g R2 on a Linux Cluster AR Server 7.0.1 p2, Email Engine, FB, Approval Server, CMDB, ITSM 6.x on a W2K3 server AR Mid-Tier 7.0.1 p2 on Linux boxes distributed across various geographies Since the failover server is going to talk to the same Oracle instance as the production server, I am not entirely clear how to go about setting the secondary server with all the binaries and applications. Thanks in advance, -- Shyam __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Installing AR, Email, Approval, CMDB ITSM on a failover server
Oops, saw linux next to Oracle and though it was Remedy. He could do an upgrade install to get the binaries in place. It is also possible to mount file systems on Windows boxes as well, but you have to have the infrastructure. Things are not so simple as copying a file system on Windows though, with the registry and the other weird things that have to be done. The trouble comes with the apps. I am not sure if you can do the installation without importing the workflow/data for those apps. Axton Grams On 7/29/07, Shellman, David [EMAIL PROTECTED] wrote: Axton, Since the AR System is on a Win server couldn't he simply do an install on the failover server with it pointing to the production Oracle instance? The install would run as an upgrade using the same server name and all the binaries, etc would be in the same directory structure. He would need to make sure that all the config files from the production server were copied to the fail over server. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 15:08:22 2007 Subject: Re: Installing AR, Email, Approval, CMDB ITSM on a failover server We simply mount the filesystem on the failover server since the fs is not local. All the files are the same, with a few exceptions. Since each node has a different hostname, we update the Server-Name parameter in ar.conf (awk/sed) during the failover. This is done in the arsystem script, which resides in the arsystem/bin directory. One other exception is eie, since the eie instance names seem to be bound to the hostname/Server-Name for whatever reason. We have a common hostname that is shared between the two servers, the server that gets the hostname is handled by Veritas vcs, as are the filesystem, monitoring/failover operations. We monitor the armonitor process to trigger the failover; this way we give armonitor a chance to correct things before failing over. Axton Grams On 7/29/07, Shyam Attavar [EMAIL PROTECTED] wrote: ** Dear listers, We are in the process of setting up new hardware platform for Remedy server in our environment and I am not too sure how to install the AR Server on the failover server. Any help in this area would be really valuable. Here are the details: Oracle 10g R2 on a Linux Cluster AR Server 7.0.1 p2, Email Engine, FB, Approval Server, CMDB, ITSM 6.x on a W2K3 server AR Mid-Tier 7.0.1 p2 on Linux boxes distributed across various geographies Since the failover server is going to talk to the same Oracle instance as the production server, I am not entirely clear how to go about setting the secondary server with all the binaries and applications. Thanks in advance, -- Shyam __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
ITSM 7: Change Mgmt Performance Issues
Hi All, We have ITSM installed on a Load balancer environment (Solaris + Oracle). When the logs into the system, through the user tool and clicks on Change Management Console, it takes a lot of time to load that, may be 30-45 seconds. Is there anyway to optimise this performance issue? It also takes probably same amount of time to create a new change ticket. Regards, Veeral Oza, Application Developer, Column Technologies, Cell: 224-587-0765 Desk: 847-632-3327 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Installing AR, Email, Approval, CMDB ITSM on a failover server
I almost did the same thing when I saw the linux reference. So it would require an install as an upgrade to get the directory and registry settings correct. Also sounds like a good idea to do a full export of forms and workflow first so that they could be reimported after the upgrade so that any mods to system forms would not be lost by the upgrade over write of forms and workflow. I need to do this in the next few weeks so it's been on my mind. Thanks for the workflow reminder. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 16:05:41 2007 Subject: Re: Installing AR, Email, Approval, CMDB ITSM on a failover server Oops, saw linux next to Oracle and though it was Remedy. He could do an upgrade install to get the binaries in place. It is also possible to mount file systems on Windows boxes as well, but you have to have the infrastructure. Things are not so simple as copying a file system on Windows though, with the registry and the other weird things that have to be done. The trouble comes with the apps. I am not sure if you can do the installation without importing the workflow/data for those apps. Axton Grams On 7/29/07, Shellman, David [EMAIL PROTECTED] wrote: Axton, Since the AR System is on a Win server couldn't he simply do an install on the failover server with it pointing to the production Oracle instance? The install would run as an upgrade using the same server name and all the binaries, etc would be in the same directory structure. He would need to make sure that all the config files from the production server were copied to the fail over server. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 15:08:22 2007 Subject: Re: Installing AR, Email, Approval, CMDB ITSM on a failover server We simply mount the filesystem on the failover server since the fs is not local. All the files are the same, with a few exceptions. Since each node has a different hostname, we update the Server-Name parameter in ar.conf (awk/sed) during the failover. This is done in the arsystem script, which resides in the arsystem/bin directory. One other exception is eie, since the eie instance names seem to be bound to the hostname/Server-Name for whatever reason. We have a common hostname that is shared between the two servers, the server that gets the hostname is handled by Veritas vcs, as are the filesystem, monitoring/failover operations. We monitor the armonitor process to trigger the failover; this way we give armonitor a chance to correct things before failing over. Axton Grams On 7/29/07, Shyam Attavar [EMAIL PROTECTED] wrote: ** Dear listers, We are in the process of setting up new hardware platform for Remedy server in our environment and I am not too sure how to install the AR Server on the failover server. Any help in this area would be really valuable. Here are the details: Oracle 10g R2 on a Linux Cluster AR Server 7.0.1 p2, Email Engine, FB, Approval Server, CMDB, ITSM 6.x on a W2K3 server AR Mid-Tier 7.0.1 p2 on Linux boxes distributed across various geographies Since the failover server is going to talk to the same Oracle instance as the production server, I am not entirely clear how to go about setting the secondary server with all the binaries and applications. Thanks in advance, -- Shyam __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Newbie help with creating a SQL menu
Axton, Dave: I changed the Server name to the IP address of the remedy server instead of the database server and it works. Any idea if I can connect to a database table that is not the remedy database? If yes, how would I do that? Thanks Ray Shellman, David wrote: Ray, My suggestion is to connect to your AR System instance with SQL Plus as the user aradmin. Then execute the sql statement. This eliminates any issue with the AR System. Any resulting Oracle error will be displayed. If the table doesn't have a public synonym you will proably need to execute the sql statement in the form of select value from [EMAIL PROTECTED] I remember this after I try select select value from [EMAIL PROTECTED] and get a table doesn't exist error. Often the other instance may require the same user name aradmin instead of a user named remedy. There's probably a way to connect as another user but I haven't tried and it may complicate the sql statement. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 13:13:51 2007 Subject: Re: Newbie help with creating a SQL menu Hi Axton: I donot see anything in arerror.log. I have enabled logging on the remedy user client and donot see anything there as well. Not sure if his matters. This REMEDY user is not one created by remedy. It's a user our db admin has created for readonly access to a few views and tables. Thanks Ray Axton wrote: 1. Is there anything else I need to do for the SQL menu to work? Shouldn't be 2. How does the sql menu know what is the password for the REMEDY user in the database? It already has sessions to the Oracle instance used by Remedy; it just uses those 3. How does it know the ORACLE_SID to be used for this query? It already has sessions to the Oracle instance used by Remedy; it just uses those, meaning it runs the sql against the Remedy instance as the remedy schema owner Your arerr90 is more than likely indicative of another problem. Check the arerror.log file for more info. Axton Grams On 7/29/07, Ray [EMAIL PROTECTED] wrote: Hi: I have created a menu that should list value for all fields in a database. The SQL command for the menu I am using is the following. select distinct(LOCATION) from REMEDY.LOCATIONS I have associated this menu with a field in my form. When I click on the pulldown menu for the field, I get the following error ARERR [90] Cannot establish a network connection to the AR System server : 192.168.2.219 (0) : RPC: Program not registered The database I am connecting to is the database remedy uses and the database runs on a different server. I can log into that database fine using a sqlplus client. 1. Is there anything else I need to do for the SQL menu to work? 2. How does the sql menu know what is the password for the REMEDY user in the database? 3. How does it know the ORACLE_SID to be used for this query? Thanks Ray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Newbie help with creating a SQL menu
Ray, There are so many ways this could have been set up within Oracle. It could be just a table in the same Oracle instance as your AR System tables. It could have been set up with a link from one instance to another. Depending on how the DBA's set it up can make a difference on the actual select statement. Best advice I can offer is talk to your DBA's. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 17:49:33 2007 Subject: Re: Newbie help with creating a SQL menu Axton, Dave: I changed the Server name to the IP address of the remedy server instead of the database server and it works. Any idea if I can connect to a database table that is not the remedy database? If yes, how would I do that? Thanks Ray Shellman, David wrote: Ray, My suggestion is to connect to your AR System instance with SQL Plus as the user aradmin. Then execute the sql statement. This eliminates any issue with the AR System. Any resulting Oracle error will be displayed. If the table doesn't have a public synonym you will proably need to execute the sql statement in the form of select value from [EMAIL PROTECTED] I remember this after I try select select value from [EMAIL PROTECTED] and get a table doesn't exist error. Often the other instance may require the same user name aradmin instead of a user named remedy. There's probably a way to connect as another user but I haven't tried and it may complicate the sql statement. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 13:13:51 2007 Subject: Re: Newbie help with creating a SQL menu Hi Axton: I donot see anything in arerror.log. I have enabled logging on the remedy user client and donot see anything there as well. Not sure if his matters. This REMEDY user is not one created by remedy. It's a user our db admin has created for readonly access to a few views and tables. Thanks Ray Axton wrote: 1. Is there anything else I need to do for the SQL menu to work? Shouldn't be 2. How does the sql menu know what is the password for the REMEDY user in the database? It already has sessions to the Oracle instance used by Remedy; it just uses those 3. How does it know the ORACLE_SID to be used for this query? It already has sessions to the Oracle instance used by Remedy; it just uses those, meaning it runs the sql against the Remedy instance as the remedy schema owner Your arerr90 is more than likely indicative of another problem. Check the arerror.log file for more info. Axton Grams On 7/29/07, Ray [EMAIL PROTECTED] wrote: Hi: I have created a menu that should list value for all fields in a database. The SQL command for the menu I am using is the following. select distinct(LOCATION) from REMEDY.LOCATIONS I have associated this menu with a field in my form. When I click on the pulldown menu for the field, I get the following error ARERR [90] Cannot establish a network connection to the AR System server : 192.168.2.219 (0) : RPC: Program not registered The database I am connecting to is the database remedy uses and the database runs on a different server. I can log into that database fine using a sqlplus client. 1. Is there anything else I need to do for the SQL menu to work? 2. How does the sql menu know what is the password for the REMEDY user in the database? 3. How does it know the ORACLE_SID to be used for this query? Thanks Ray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Newbie help with creating a SQL menu
Ray, In general all ARS workflow/objects should point at ARS servers. The only exceptions that I can currently think of would be: A) Calls to ARS Plugin Servers(Via Filter SetField actions) ARS Plugin Servers can be hosted on non ARS Server hardware, but typically are installed on ARS servers by default. B) Calls to Web Services (Via Filter SetField actions) C) View fields can be pointed at any http/https server. D ) hum... What else ( I am likely missing something but at the moment I can not think of anything else.) In specific the ARS server currently (as of v7) really only knows about one RDBMS and only one specific DB. If you can workout the SQL details in your RDBMS so that you can expose an external RDBMS(table or other such item) as if it exists inside the specific DB that ARS is connected to then you likely can use that item. ( There are still some restrictions due to how ARS works, but there are workarounds that you can also do to mesh most RDBMS stuff into a form that ARS can use too. ) In specific I have seen Oracle solutions with Linked Servers (to establish the username password / connection information) with a local RDBMS View object to expose remote/external Oracle data as if it existed in the local table space. And if the RDBMS View has characteristics that conform to the ARS form design then an ARS View Form can be pointed at the local RDMBS View object. HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 7/29/07, Ray [EMAIL PROTECTED] wrote: Axton, Dave: I changed the Server name to the IP address of the remedy server instead of the database server and it works. Any idea if I can connect to a database table that is not the remedy database? If yes, how would I do that? Thanks Ray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Newbie help with creating a SQL menu
If you want to access a table in the same oracle instance, but in a different schema, use this syntax for the table name: schema.tableName If you want to access data in a remote schema, (1) create a database link in Oracle, then (2), use this syntax for the table name: remoteSchema.tableName@DbLinkName Axton Grams On 7/29/07, Ray [EMAIL PROTECTED] wrote: Axton, Dave: I changed the Server name to the IP address of the remedy server instead of the database server and it works. Any idea if I can connect to a database table that is not the remedy database? If yes, how would I do that? Thanks Ray Shellman, David wrote: Ray, My suggestion is to connect to your AR System instance with SQL Plus as the user aradmin. Then execute the sql statement. This eliminates any issue with the AR System. Any resulting Oracle error will be displayed. If the table doesn't have a public synonym you will proably need to execute the sql statement in the form of select value from [EMAIL PROTECTED] I remember this after I try select select value from [EMAIL PROTECTED] and get a table doesn't exist error. Often the other instance may require the same user name aradmin instead of a user named remedy. There's probably a way to connect as another user but I haven't tried and it may complicate the sql statement. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 13:13:51 2007 Subject: Re: Newbie help with creating a SQL menu Hi Axton: I donot see anything in arerror.log. I have enabled logging on the remedy user client and donot see anything there as well. Not sure if his matters. This REMEDY user is not one created by remedy. It's a user our db admin has created for readonly access to a few views and tables. Thanks Ray Axton wrote: 1. Is there anything else I need to do for the SQL menu to work? Shouldn't be 2. How does the sql menu know what is the password for the REMEDY user in the database? It already has sessions to the Oracle instance used by Remedy; it just uses those 3. How does it know the ORACLE_SID to be used for this query? It already has sessions to the Oracle instance used by Remedy; it just uses those, meaning it runs the sql against the Remedy instance as the remedy schema owner Your arerr90 is more than likely indicative of another problem. Check the arerror.log file for more info. Axton Grams On 7/29/07, Ray [EMAIL PROTECTED] wrote: Hi: I have created a menu that should list value for all fields in a database. The SQL command for the menu I am using is the following. select distinct(LOCATION) from REMEDY.LOCATIONS I have associated this menu with a field in my form. When I click on the pulldown menu for the field, I get the following error ARERR [90] Cannot establish a network connection to the AR System server : 192.168.2.219 (0) : RPC: Program not registered The database I am connecting to is the database remedy uses and the database runs on a different server. I can log into that database fine using a sqlplus client. 1. Is there anything else I need to do for the SQL menu to work? 2. How does the sql menu know what is the password for the REMEDY user in the database? 3. How does it know the ORACLE_SID to be used for this query? Thanks Ray ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Guided Entry
Christie, Ref: AdvancedGuide-630.pdf page: 34 Note: Interactive guides are not supported on the Web. But I think this same kind of thing could be done with a reentering active link guide design. If you have a guide with 10 steps you would also need 10 labels. Each active link in the guide sets a hidden field to the next label value and a visible field to an instruction for the user. The button next to the visible field calls the Active Link Guide again. Each active link knows about the value that it should set the hidden field and the visible field values for. So if the first active link would work when the hidden field is null (Run If) and set the hidden field to one and the visible field to bla1 and then exit the guide. The second would (Run If) 'Hidden' = one then set 'Hidden' = two and Visible to bla2 and exit guide. etc... Now it would not prevent the user from skipping steps or getting totally out of sync with the instructsions, but you could also have a restart or a back button too. (Which you can not do with the interactive guide design of ARS.) And if you got really really fancy you might be able to have enough gain/lose focus active links to even force the user to interact/set the fields in the order that you need too. But that likely is much harder than it sounds. :) HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 7/27/07, Robert Halstead [EMAIL PROTECTED] wrote: I believe that in the mid-tier the prompt bar option is ignored and functions as a message box. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Server Clustering and Load Balancing
We've used F5 Big IPs to load balance two AR Servers and 2 Mid Tier servers since 2003. It works great. Its configured to monitor a given port every 15 seconds to make sure the application server is alive (port 9030 for AR Server, port 443 for Mid Tier). If at any point a server doesn't respond it redirects user traffic to the other server in the group. Works very nice. Chad Hall (501) 342-2650 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Robert Halstead Sent: Friday, July 27, 2007 4:31 PM To: arslist@ARSLIST.ORG Subject: Re: Server Clustering and Load Balancing We just recently got a server group up and running in our environment. We're using Big IP F5 to load balance between the two servers. So far we have had no problems load balencing between them except for the hardware itself. The F5 doesn't do fail over very well unless the whole server box goes down. On 7/27/07, Jase Brandon [EMAIL PROTECTED] wrote: ** Hello All, Due to growing performance issues, We are exploring the possibility of moving our existing server to a clustered environment and utilizing load balancing technologies. I wondered if anyone has any best case scenarios/success stories or any information at all regarding this topic. Thanks in Advance, Jase Brandon Remedy Administration/Development Customer Support Systems Group Desk - (615) - 320-4494 Cell - (334) - 318-5426 [EMAIL PROTECTED] DaVita Inc. __20060125___This posting was submitted with HTML in it___ -- A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed. Robert Halstead ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are * The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank you. * ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Installing AR, Email, Approval, CMDB ITSM on a failover server
Re: Installing AR, Email, Approval, CMDB ITSM on a failover serverDave and Axton, Thanks for your suggestions. I really appreciate your insight and sharing this with the rest of us Cheers, -- Shyam - Original Message - From: Shellman, David Newsgroups: gmane.comp.crm.arsystem.general To: arslist@ARSLIST.ORG Sent: Sunday, July 29, 2007 1:25 PM Subject: Re: Installing AR, Email, Approval, CMDB ITSM on a failover server I almost did the same thing when I saw the linux reference. So it would require an install as an upgrade to get the directory and registry settings correct. Also sounds like a good idea to do a full export of forms and workflow first so that they could be reimported after the upgrade so that any mods to system forms would not be lost by the upgrade over write of forms and workflow. I need to do this in the next few weeks so it's been on my mind. Thanks for the workflow reminder. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 16:05:41 2007 Subject: Re: Installing AR, Email, Approval, CMDB ITSM on a failover server Oops, saw linux next to Oracle and though it was Remedy. He could do an upgrade install to get the binaries in place. It is also possible to mount file systems on Windows boxes as well, but you have to have the infrastructure. Things are not so simple as copying a file system on Windows though, with the registry and the other weird things that have to be done. The trouble comes with the apps. I am not sure if you can do the installation without importing the workflow/data for those apps. Axton Grams On 7/29/07, Shellman, David [EMAIL PROTECTED] wrote: Axton, Since the AR System is on a Win server couldn't he simply do an install on the failover server with it pointing to the production Oracle instance? The install would run as an upgrade using the same server name and all the binaries, etc would be in the same directory structure. He would need to make sure that all the config files from the production server were copied to the fail over server. Dave -- [EMAIL PROTECTED] (Wireless) - Original Message - From: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG To: arslist@ARSLIST.ORG arslist@ARSLIST.ORG Sent: Sun Jul 29 15:08:22 2007 Subject: Re: Installing AR, Email, Approval, CMDB ITSM on a failover server We simply mount the filesystem on the failover server since the fs is not local. All the files are the same, with a few exceptions. Since each node has a different hostname, we update the Server-Name parameter in ar.conf (awk/sed) during the failover. This is done in the arsystem script, which resides in the arsystem/bin directory. One other exception is eie, since the eie instance names seem to be bound to the hostname/Server-Name for whatever reason. We have a common hostname that is shared between the two servers, the server that gets the hostname is handled by Veritas vcs, as are the filesystem, monitoring/failover operations. We monitor the armonitor process to trigger the failover; this way we give armonitor a chance to correct things before failing over. Axton Grams On 7/29/07, Shyam Attavar [EMAIL PROTECTED] wrote: ** Dear listers, We are in the process of setting up new hardware platform for Remedy server in our environment and I am not too sure how to install the AR Server on the failover server. Any help in this area would be really valuable. Here are the details: Oracle 10g R2 on a Linux Cluster AR Server 7.0.1 p2, Email Engine, FB, Approval Server, CMDB, ITSM 6.x on a W2K3 server AR Mid-Tier 7.0.1 p2 on Linux boxes distributed across various geographies Since the failover server is going to talk to the same Oracle instance as the production server, I am not entirely clear how to go about setting the secondary server with all the binaries and applications. Thanks in advance, -- Shyam __20060125___This posting was submitted with HTML in it___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the
Re: Email engine and large number of groups
Actually, though undocumented, this setting works on 6.3 patch 20. We've been using for a few months. Chad Hall (501) 342-2650 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Saturday, July 28, 2007 9:17 AM To: arslist@ARSLIST.ORG Subject: Re: Email engine and large number of groups Hi, I saw this setting, but since the email engine version is 6.3 it does not help... -- Jarl On 7/28/07, Davies, J.T. [EMAIL PROTECTED] wrote: Hi Jarl, I can't believe I'm responding at 2:30 in the morning (PDT). In version 7, there's an option for the EmailDaemon.properties file to prevent this from happening: Com.remedy.arsys.emaildaemon.FetchUserGroupInfoOnDemand = true / false Page 238 of the 7.0 Email Engine book. Instead of caching the user/group tables...it pulls info on demand. (I'm not sure if you're running that version or not...) J.T. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Saturday, July 28, 2007 1:27 AM To: arslist@ARSLIST.ORG Subject: Email engine and large number of groups Hi, An integration went for an unkown reason maniac, and there was approx 15000 groups on the server (read groups)! The email engine took more then 2 hours to start... The email engine is not designed for 18000 groups on the server... -- Jarl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are *** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
Re: Email engine and large number of groups
Thanks! Will try to install patch 20 -- Jarl On 7/30/07, Hall Chad - chahal [EMAIL PROTECTED] wrote: Actually, though undocumented, this setting works on 6.3 patch 20. We've been using for a few months. Chad Hall (501) 342-2650 -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Saturday, July 28, 2007 9:17 AM To: arslist@ARSLIST.ORG Subject: Re: Email engine and large number of groups Hi, I saw this setting, but since the email engine version is 6.3 it does not help... -- Jarl On 7/28/07, Davies, J.T. [EMAIL PROTECTED] wrote: Hi Jarl, I can't believe I'm responding at 2:30 in the morning (PDT). In version 7, there's an option for the EmailDaemon.properties file to prevent this from happening: Com.remedy.arsys.emaildaemon.FetchUserGroupInfoOnDemand = true / false Page 238 of the 7.0 Email Engine book. Instead of caching the user/group tables...it pulls info on demand. (I'm not sure if you're running that version or not...) J.T. -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Jarl Grøneng Sent: Saturday, July 28, 2007 1:27 AM To: arslist@ARSLIST.ORG Subject: Email engine and large number of groups Hi, An integration went for an unkown reason maniac, and there was approx 15000 groups on the server (read groups)! The email engine took more then 2 hours to start... The email engine is not designed for 18000 groups on the server... -- Jarl ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are *** The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system. Thank You. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:Where the Answers Are
