If it is reporting an error with the column missing in the DB then somewhere in the system it thinks it is a real database field. I had the same problem a while back (also because of copying a field). The only way to correct it was to manually add the column to the table (with an alter table add column statement). I could then delete the field thru the admin tool and recreate it again (without doing the copy) to be safe that it was correct everywhere (until the column was in the T table I could not even delete the field thru the admin tool).
Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ron Legters Sent: Monday, October 25, 2010 4:34 PM To: arslist@ARSLIST.ORG Subject: Re: Weird SQL issue - column missing from T table ** Bingo! I would swear this worked on Friday, though. Well, back to the drawing board. Thanks, Ron Legters ITIL Tools & Process Admin -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roger Medsker Sent: Monday, October 25, 2010 2:26 PM To: arslist@ARSLIST.ORG Subject: Re: Weird SQL issue - column missing from T table ** Ron, Check in Admin to see whether this field is "Display Only". If so, it will show up in all of the places you mention AND will not be a column in the T1148 table. Roger Medsker From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ron Legters Sent: Monday, October 25, 2010 4:21 PM To: arslist@ARSLIST.ORG Subject: Weird SQL issue - column missing from T table ** I'm getting an error when I try to save a CRQ - "ARERR [552] Failure during SQL operation to the database : Standard Change". Looking at the SQL log, the problem seems to be this: *** ERROR *** Invalid column name 'C1000000338' It's doing a 'select' from table T1148, which is CHG:TemplateSPGLookup. Field 1000000338 is 'z1D Support Group ID'. When I look in the Admin tool, the field is on the form. If I query the db, there is a field 1000000338 in the 'field' table for schema 1148. The column isn't in the table T1148, though. How do I get it back? I've re-saved the form in the Admin tool with the field in place, but it hasn't helped. If it's any help, I copied this field last Friday from CHG:TemplateSPGLookup to a tab on the Change form for some new workflow I'm building. I didn't do anything else to it, on the lookup form, though. MSSQL 2005 ARS 7.1 Windows ITSM 7.2 Thank you, Ron Legters ITIL Tools & Process Administrator UNIVAR Business Information Services 17425 NE Union Hill Road Redmond, WA 98052 USA +1 425 889 3952 Work ron.legt...@univar.com _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
