Hi Lisa, Most if this reply is for troubleshooting issue between difference db servers. If not may it live long in the archives and be useful to somebody down the road...
Are these databases on different servers? If so I think you have to link the servers before you can create a view form (it's been a while since I created a view form against a remote Oracle db). You said that the SQL Developer was able to login and see the view with aradmin, was that on the db server that the view resides on? If not make sure the view is accessible from the Remedy db server using database tools before you getting into troubleshooting the Remedy end. By the looks of the view name you supplied it is not across servers or that is the problem, you are not telling the Remedy db server what host/TNS name where to find the view. And of course if they are on difference servers check firewalls, etc. Can you tnsping the remove server from the Remedy db server. HTH, Jason On Thu, Mar 27, 2008 at 12:59 PM, Kemes, Lisa < [EMAIL PROTECTED]> wrote: > ** Thanks, I'm going to try this....Everything points to the fact that > this should work. > > I'll let you know! > > > Lisa > > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk > *Sent:* Thursday, March 27, 2008 3:51 PM > > *To:* [email protected] > *Subject:* Re: View Forms > > ** If you can log into the database as ARADMIN and see the tables then you > should be able to create the Remedy view. It would seem to me that you > might just want to create a simple form that runs the query "select > table_name from user_tables order by 1" so that you can see the list of > tables (and any odd naming) that are available to the Remedy server. Often > times this is a simple way to make sure you get the name right. If you run > an active link with a set fields / sql command and make that your sql > statement, you can then populate a field with the table name so that you can > just cut and paste. > > On Thu, Mar 27, 2008 at 2:32 PM, Grooms, Frederick W < > [EMAIL PROTECTED]> wrote: > > > ** If they are not owned by aradmin, are you including the owner name? > > > > Fred > > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa > > *Sent:* Thursday, March 27, 2008 2:29 PM > > > > *To:* [email protected] > > *Subject:* Re: View Forms > > > > ** These are not ARS tables. Just plain old tables from an Oracle > > database. Our DBA was able to log into SQL developer with the aradmin > > account and see these tables just fine. For some reason, my admin tool must > > not be using the aradmin account for view forms? I'm connected to our ARS > > database so it's working in that respect..... > > > > These are not owned by aradmin either, but it is in the permission > > group. > > > > <sigh> > > > > > > Lisa > > > > > > ------------------------------ > > *From:* Action Request System discussion list(ARSList) [mailto: > > [EMAIL PROTECTED] *On Behalf Of *Brian Goralczyk > > *Sent:* Thursday, March 27, 2008 1:44 PM > > *To:* [email protected] > > *Subject:* Re: View Forms > > > > ** Not true. She doesn't need the T table. First off, if it isn't an > > ARS table there might (probably won't) be a T table unless it was created > > manually. However, you can still use the view instead. If it is a Remedy > > created table, then the view name has a specific format. All none > > alphanumeric characters are replaced with an underscore. Also, view names > > in an Oracle (and I assume the others) database is only 30 characters long > > if Remedy created the view. So if your view (form) name is longer than 30 > > characters just drop the exceeding characters. There is one other caveat in > > case you have more than one view name that is the same until past the 30 > > character limit. The last letter (number 30) is replaced by a sequential > > number starting with the second form and incrementing for each form. Check > > out my examples but please don't name your forms as such or think that I > > have mine named like this. > > > > Form Name: CTM:People Site AP:Administration Join > > View Name: ctm_people_site_ap_administrat > > > > Form Name: CTM:People Site AP:Administration Role Join > > View Name: ctm_people_site_ap_administra2 > > > > Please only use this as an example. I didn't verify my thoughts from > > off the top of my head. > > > > Also, if you want the list of views just run this: select view_name from > > user_views order by 1 > > > > That will work in an Oracle db for sure. > > > > Also, I have not found a case sensitivity for form or field names when > > writing SQL queries. > > > > HTH, > > > > Brian Goralczyk > > > > On Thu, Mar 27, 2008 at 11:27 AM, Drew Shuller <[EMAIL PROTECTED]> wrote: > > > > > Yes, if it's owned by aradmin, she'll need the T table. > > > > > > Drew > > > > > > On Thu, 27 Mar > > > 2008, Nisha Ramtri wrote: > > > > > > > Lisa, > > > > > > > > This error normally occurs when the table name that is being > > > provided is > > > > different from the actual name in the db. Check for the name, > > > spelling of > > > > the table in the database. The table name is case sensitive also. > > > Hence take > > > > care of that as well while providing the name of the table. Also > > > make sure > > > > that the table is in the aradmin d/b. Hope that helps. > > > > > > > > Rgd, > > > > Nisha. > > > > > > > > > > > > On 3/27/08, Kemes, Lisa <[EMAIL PROTECTED]> wrote: > > > >> > > > >> ** Also, I am typing the table name in CAPS. > > > >> > > > >> > > > >> Lisa > > > >> > > > >> > > > >> ------------------------------ > > > >> *From:* Action Request System discussion list(ARSList) [mailto: > > > >> [EMAIL PROTECTED] *On Behalf Of *Kemes, Lisa > > > >> *Sent:* Thursday, March 27, 2008 12:05 PM > > > >> *To:* [email protected] > > > >> *Subject:* View Forms > > > >> > > > >> > > > >> ** > > > >> > > > >> I'm trying to create a View Form that connects to a table on an > > > Oracle > > > >> database and I'm getting the error message: > > > >> > > > >> "Requested database table not found. Please check the spelling > > > (table > > > >> name is case-sensitive) (ARERR 481)." > > > >> > > > >> The table has aradmin added to the permission list. Is there > > > anything > > > >> else I'm missing? > > > >> > > > >> AR Server 7.01 Patch 6 > > > >> Windows 2003 app Server > > > >> > > > >> *Lisa Kemes * > > > >> AR System Developer > > > >> Tyco Electronics > > > >> 717-810-2408 tel > > > >> 717-810-2124 fax > > > >> [EMAIL PROTECTED] > > > >> > > > >> __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" > > > > > > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the > > Answers Are" html___ > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > html___ > > > > __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"
