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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
