Take an SQL log and see what SQL the AR System throws to the database server at the time you get that error.
Joe ________________________________ From: "Kemes, Lisa" <lisa.ke...@tycoelectronics.com> To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 12:27:21 PM Subject: Re: View Forms and Synoyms.... Thanks Fred. I tried this, but I'm still getting the error. (Even though it's not captured on the SQL logs for some reason) */SELECT count(*) from all_tab_columns where table_name = 'COST_CENTER_V' and owner = 'DCC' */OK */SELECT table_name from all_synonyms where synonym_name = 'COST_CENTER_V' and owner = 'DCC' */OK Lisa -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Wednesday, May 27, 2009 12:12 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms.... Try adding in the owner of your synonym. Here is an excerpt of the server SQL Log. This is with 7.1.0 Patch 007 on Solaris w/Oracle 10i (Remote DB) Attempting to create a View Form on "USER_VIEWS" <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0270 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'ARADMIN' <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0325 */OK <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0327 */ SELECT table_name from all_synonyms where synonym_name = 'USER_VIEWS' and owner = 'ARADMIN' <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0574 */OK <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:49:37.0575 */ Error - can't find table USER_VIEWS (owner = ARADMIN). Attempting to create a View Form on "SYS.USER_VIEWS" <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:51:30.7681 */ SELECT count(*) from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:51:30.7696 */OK <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:51:30.7699 */ SELECT column_name,data_type,data_length,data_precision,data_scale from all_tab_columns where table_name = 'USER_VIEWS' and owner = 'SYS' <SQL > <Queue: Admin> <Client-RPC: 390600> <USER: fwgrooms> /* Wed May 27 2009 10:51:30.7771 */OK Fred ________________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Kemes, Lisa Sent: Wednesday, May 27, 2009 10:14 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms.... Yes it does work from the SQL Client. Sorry, I should have specified that..... Lisa ________________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe DeSouza Sent: Wednesday, May 27, 2009 11:01 AM To: arslist@ARSLIST.ORG Subject: Re: View Forms and Synoyms.... I thought I'd ask you the very obvious question... Can you query the view form as aradmin from the SQL client when logged in as aradmin using that same view name??? Joe ________________________________________ From: "Kemes, Lisa" <lisa.ke...@tycoelectronics.com> To: arslist@ARSLIST.ORG Sent: Wednesday, May 27, 2009 10:44:30 AM Subject: View Forms and Synoyms.... Got a ticket into BMC, we are having problems using Synonyms for our View Forms. Getting "Requested Database table not found. Please check the spelling (table name is case-sensitive) ARERR 481." We are on 7.01 patch 3. I thought this bug was fixed with SW00180955? Oracle 10i Windows 2003 Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-810-2124 fax lisa.ke...@tycoelectronics.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
