Thanks all for the responses. I talked to our DBA who dropped the synonym MYSCHEMA.MYVIEW (named so because it used to be a view) and recreated it as a view of the MYSCHEMA DB over the link and the error in Administrator has ceased.
For both aradmin and non-aradmin (a.k.a. MYSCHEMA) synonyms, Administrator would not load the table, even to create a new view form. It would load table only for the full [EMAIL PROTECTED] I did find a bug fix reported for version 6.3 related to using a synonym, so perhaps this related. Of course, I wouldn't be considering any of this at all if ARS would just support Oracle 11 so the Remedy DB could have been upgraded along with the rest of our application databases. :-D Thanks again for the advice. Jill Anderson On Thu, Feb 28, 2008 at 8:39 AM, Tucker, Rob <[EMAIL PROTECTED]> wrote: > ** My memory isn't what it used to be, but I believe you can change the > view pointers at the database level by changing the tablename in the > SCHEMA_VIEW table, then restarting the system. You'll see the underlying > tables for your view fields in this table. > > No Warranty Implied! :) > > Rob Tucker > New Edge Networks > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Grooms, Frederick W > *Sent:* Wednesday, February 27, 2008 3:09 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Updating view forms > > ** 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.MYVIEWto > [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 > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
