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"