I second Carey's idea of turning on SQL logging to see what the problem is.
However, were those fields named "create" and "modify" buttons perhaps? Certain fields (trim, buttons, display-only fields) do not appear on the SQL view therefore ARS won't rebuild the view when you change these fields. Try changing the database name (on the Database tab of field properties) of a regular field, or, add and remove a regular field. That should trigger a view rebuild. HTH, Davin Davin Lindner-Green Rapid Technologies Inc. [EMAIL PROTECTED] Office: +1.303.948.1014 ** www.raptek.com ** * BMC Level 1 Support Partner * BMC Software Solutions Partner * BMC Education Partner -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Wednesday, February 13, 2008 2:07 PM To: [email protected] Subject: Re: Form sql view not found Thanks, Jason. I googled "oracle sql keywords" and compared it to my query of field names from my form. I found a field named "create" and one named "modify", so I renamed them. That didn't work. So I renamed fields with more than one word in the name if one of the words was a key, like "Date needed". But still no luck. My list of keywords may not be complete. It doesn't include "Function". I don't have a field with that name, but there might be other bad ones not on the list. Dwayne ---- Original message ---- >Date: Wed, 13 Feb 2008 12:19:30 -0800 >From: Jason Miller <[EMAIL PROTECTED]> >Subject: Re: Form sql view not found >To: [email protected] > > ** > Do you have any fields that are the same as SQL > keywords? I remember years ago having form that > would give us a message that the view could not be > created when we imported the def. Turns out there > was a field called Function and MS SQL was getting > hung up on it. Once we name the field Function1 the > view would create. > > Jason > > > On 2/13/08, Dwayne Martin <[EMAIL PROTECTED]> wrote: > > Thanks, Fred. I tried that but got: > > "Creation of one of the SQL views for the form > failed within the SQL database. > Operation completed successfully, but the SQL view > is not in place. (ARWARN 69)." > > Dwayne > > ---- Original message ---- > >Date: Wed, 13 Feb 2008 10:39:50 -0600 > >From: "Grooms, Frederick W" > <[EMAIL PROTECTED]> > >Subject: Re: Form sql view not found > >To: [email protected] > > > >Add an optional field to the form and ARS should > re-create the view. > >Anytime you add or remove fields from a form the > Remedy server will drop > >and re-create the database view. > > > >Fred > > > >-----Original Message----- > >From: Action Request System discussion > list(ARSList) > >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne > Martin > >Sent: Wednesday, February 13, 2008 10:22 AM > >To: [email protected] > >Subject: Form sql view not found > > > >Hello Everyone, > > > >We have a form named "LA:SoftwareInstall." For > years we have queried > >the database using the view name > "la_softwareinstall." Now that view is > >no longer present. If I look at a list of all > our views on the database > >(Oracle 10.2 db) I see views for the other forms, > but nothing resembling > >"la_softwareinstall." It is missing in both our > test and live > >databases. > > > >Last year we copied our existing database to a > new server, then > >installed the 7.1 ARS system on top of it. Is it > possible that the > >"la_softwareinstall" view somehow got left behind > in the database copy? > > > >Is there an easy way to get it back again? I > know we could use a > >complicated "create view" statement directly in > Oracle, but would that > >even be wise? > > > >Dwayne Martin > >James Madison University > > > >_______________________________________________________________________ ________ > >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" > > __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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
