So, the field missing from the T table was, in fact, a display-only field and 
it was supposed to be. The problem I was having was getting a SQL error after 
saving a request, and the log said the problem was this field wasn't in the 
table.

What was happening is that I had a menu attached to a character field, which 
used as one of its qualifications a value from a field on the CRQ that had the 
same ID as this 'missing' field. This field gets a value when the tab it's on 
gets focus. After submit, the menu couldn't find the value, since the field 
wasn't populated yet, and for some reason tried to query this other table for 
it.

I solved this by creating a second menu that doesn't use this value, and 
attached it to the character field, and then attaching the first menu with a 
change fields action after the qualifier field gets populated.

Thanks,
Ron Legters
ITIL Tools & Process Admin


-----Original Message-----
From: Action Request System discussion list(ARSList) 
[mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W
Sent: Tuesday, October 26, 2010 6:57 AM
To: arslist@ARSLIST.ORG
Subject: Re: Weird SQL issue - column missing from T table

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"

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"

Reply via email to