Re: How to install a second instance?

2007-07-29 Thread Mark Milke
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.

Re: Field/context-sensitive help

2007-07-29 Thread Carey Matthew Black
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

Re: INI values

2007-07-29 Thread Carey Matthew Black
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

Re: INI values

2007-07-29 Thread Shellman, David
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

Re: View Field HTML Email Templates

2007-07-29 Thread Carey Matthew Black
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.

Newbie help with creating a SQL menu

2007-07-29 Thread Ray
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

Re: Job Posting - Lead Remedy Developer

2007-07-29 Thread Grooms, Frederick W
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

Re: How to install a second instance?

2007-07-29 Thread Axton
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

Re: Newbie help with creating a SQL menu

2007-07-29 Thread Axton
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

Re: Field/context-sensitive help

2007-07-29 Thread Axton
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

Re: Newbie help with creating a SQL menu

2007-07-29 Thread Ray
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.

Re: Newbie help with creating a SQL menu

2007-07-29 Thread Axton
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

Re: Newbie help with creating a SQL menu

2007-07-29 Thread Shellman, David
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

Installing AR, Email, Approval, CMDB ITSM on a failover server

2007-07-29 Thread Shyam Attavar
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

Re: Field/context-sensitive help

2007-07-29 Thread Jarl Grøneng
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

Re: Installing AR, Email, Approval, CMDB ITSM on a failover server

2007-07-29 Thread Axton
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

Re: Installing AR, Email, Approval, CMDB ITSM on a failover server

2007-07-29 Thread Shellman, David
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

Re: Installing AR, Email, Approval, CMDB ITSM on a failover server

2007-07-29 Thread Axton
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,

ITSM 7: Change Mgmt Performance Issues

2007-07-29 Thread Oza, Veeral
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

Re: Installing AR, Email, Approval, CMDB ITSM on a failover server

2007-07-29 Thread Shellman, David
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

Re: Newbie help with creating a SQL menu

2007-07-29 Thread Ray
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

Re: Newbie help with creating a SQL menu

2007-07-29 Thread Shellman, David
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

Re: Newbie help with creating a SQL menu

2007-07-29 Thread Carey Matthew Black
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

Re: Newbie help with creating a SQL menu

2007-07-29 Thread Axton
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:

Re: Guided Entry

2007-07-29 Thread Carey Matthew Black
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

Re: Server Clustering and Load Balancing

2007-07-29 Thread Hall Chad - chahal
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

Re: Installing AR, Email, Approval, CMDB ITSM on a failover server

2007-07-29 Thread Shyam Attavar
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:

Re: Email engine and large number of groups

2007-07-29 Thread Hall Chad - chahal
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

Re: Email engine and large number of groups

2007-07-29 Thread Jarl Grøneng
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