Bingo! I would swear this worked on Friday, though. Well, back to the drawing board.
Thanks, Ron Legters ITIL Tools & Process Admin From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Roger Medsker Sent: Monday, October 25, 2010 2:26 PM To: [email protected] 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:[email protected]] On Behalf Of Ron Legters Sent: Monday, October 25, 2010 4:21 PM To: [email protected] 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 [email protected]<mailto:[email protected]> _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
