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: arslist@ARSLIST.ORG 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"
