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"
