I tried this on a very simple form and still had error messages.
Your best bet may be to recreated the View form.
Drew
On Wed,
27 Feb 2008, Grooms, Frederick W wrote:
I don't know of a way to change the Remedy view location other than
exporting to a def, modifying the def, deleting the form and
re-importing from the modified def. Importing in place (without
deleting the form) might work.
Have you tried creating a local Remedy db view of the remote data.
Basically drop the synonym and do:
Create or Replace View MYSCHEMA.MYVIEW
as
select * from [EMAIL PROTECTED];
No changes to Remedy will then be necessary.
Fred
________________________________
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Jill E
Sent: Wednesday, February 27, 2008 5:00 PM
To: arslist@ARSLIST.ORG
Subject: Updating view forms
Greetings,
In an ARS 7.0.1 / RHEL4 64bit / Oracle 10g environment, I created a view
form to look at a view of another schema in the same database as Remedy.
That schema was moved to another Oracle database so now a DB link must
be employed. This is fine except that I need to update the view form in
ARS so that it knows to look in the new location.
How can I update the view form definition to look at a different
database location?
Specifically, I want to change
Form Properties > View Information > Table Name value from
MYSCHEMA.MYVIEW to [EMAIL PROTECTED],
Field Properties > Database tab > View Information > Table value,
or use some other means to update the view form to use a new table name
value.
I tried a workaround by creating a synonym, which works fine in SQLPlus
for running queries as aradmin like "select * from MYSCHEMA.MYVIEW where
id='foo'" but each time I open the view form in Remedy Administrator,
the error "Requested database table not found. Please check the spelling
(table name is case-sensitive) (ARERR 481)" is reported and I am not
able to get AR to use the synonym, even to create new view form, like I
am with SQLPlus. I've found old bugs relating to synonyms, but I am not
tied to using this approach to solve the problem anyway.
Thanks for any advice you can offer!
Jill Anderson
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
