That is interesting. I was actually wondering if it was an "ARS" problem.
I have seen a condition where the View/table is renamed to a "temporary standard" name (value like "name"_a or something like that) then the new table is built and the data is moved between the two tables and the "name"_a then deleted. Maybe there was a point in time that the temp table/view name was not removed and that is what is hanging the "create a view" for that form? Another option/possibility would be that the RDBMS layer is messed up at a permission level. Maybe the RDBMS user that the ARS server uses no longer has the ability to create those objects? ( If other forms can be updated/created then that can be ruled out.) Maybe one of those possibilities will help? I would suggest that you watch the SQL logs (and maybe even at the RDBMS layer instead of at the App server layer) to see what is actually being done to the DB by ARS. That should show you the root problem. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On Feb 13, 2008 3:19 PM, Jason Miller <[EMAIL PROTECTED]> wrote: > ** > 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"
