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"
