Ok, I just did this and this table it not in the list. How can I get this table in the list? Is there a setting on preferences or something that I'm missing?
Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kemes, Lisa Sent: Thursday, March 27, 2008 3:59 PM To: arslist@ARSLIST.ORG Subject: Re: View Forms ** 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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:* arslist@ARSLIST.ORG >> *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 <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" >> html___ >> __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" >> html___ >> > > > > ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org <http://www.arslist.org/> Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com <http://www.rmsportal.com/> ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com <http://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"