Yea, I have never seen it on a field before. But at least it was an easy fix.
On Fri, Mar 28, 2008 at 1:22 PM, Grooms, Frederick W < [EMAIL PROTECTED]> wrote: > I have seen something like this before. All I had to do was just open > the form in the Admin tool and change the database name of the field. > When the Admin tool saved the form it created the view automatically. > > Fred > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Elry > Sent: Friday, March 28, 2008 12:10 PM > To: [email protected] > Subject: ARWARN 69: SQL view is not in place > > Hi Folks: > > (A) Environment: > Windows Server 2003 > MSSQL Database 2000 > ARS: 7.1.00 Build 200708221849 > > (B) Error Message > "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)." > > > (C) Root Cause: > Keyword "Function" not trapped. > Reserved Keywords: > http://msdn2.microsoft.com/en-us/library/aa238507(SQL.80).aspx > > (D) SQL Profiler Create Statement (partial): > CREATE VIEW WLV > (Request_ID,Submitter,Create_Date,Assigned_To,Last_Modified_By, > Modified_Date,Status,Short_Description,Rollback_x) > > Normally keywords are trapped and changed into something that won't > appear as a keyword: > i.e. "Rollback" as a field becomes "Rollback_x" > > There may be other keywords that are not being trapped. The downside to > this is that I did not see this prior to running a large amount of > workflow involving a form with this keyword. This resulted in my > spending 6 hours last night rebuilding the server. > > Has anyone else had this experience? > > > _______________________________________________________________________________ > 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"
