List,
Our Dev server started crashing a few days ago and we had a VERY hard time
trying to identify the cause. After several days of trial and error, one of
the developers on the team noticed that a field length in the DB was not the
same as a field length in Remedy. After further troubleshooting it was
found that the server stopped responding after doing a query/insert into
that table using that field ID....the only 'fix' I could find to get them
back in sync was to delete the field and re-create it. We haven't had the
server crash since I did that....so it got me thinking that there might be
other fields with similar problems, so I started looking...I was shocked by
what I found and want to run it by some other people on the list to see if
they come across similar results. The Query I have provided below is
running just fine on SQL Server 2008 R2...I don't know the equivalent for
Oracle...but I would like to know if other people find a large amount of
columns where the two values don't match. With the below Query I came up
with 382 mismatches, many of which are on system generated forms, but a
majority of which are on my custom forms. This is an OLD system...it's been
around since at least 6.0...and upgraded and modified in almost every major
revision since its inception. We are currently on 7.6.4 SP1....and I can
confirm with a form that I created yesterday...I created a 255 character
field...then shrunk it to 30, and it is on my list of mismatches....curious
about your results...please reply back :)
select a.name, f.fieldName, fc.maxLength as 'RemedyMaxLength',
c.CHARACTER_MAXIMUM_LENGTH as 'DBMaxLength'
from arschema a
inner join field f on f.schemaId = a.schemaId
inner join field_char fc on a.schemaId = fc.schemaId and f.fieldId =
fc.fieldId
inner join INFORMATION_SCHEMA.COLUMNS c on c.TABLE_NAME =
'T'+CAST(a.schemaId AS char) AND 'C'+CAST(fc.fieldId as char) =
c.column_name
where fc.maxLength != c.CHARACTER_MAXIMUM_LENGTH
AND c.CHARACTER_MAXIMUM_LENGTH != 2147483647
and f.fieldId != 1
Name Field Name RemedyMaxLength DBMaxLength
AR System Currency Label Catalog Short Description 4 254
AR System Currency Ratios Short Description 4 254
Alert Events UNUSED 5 254
Server Events Unused_Descr 3 254
Server Statistics Short Description 3 254
User Password 30 255
User Computed Grp List 255 4000
AR System Administrator Preference Short Description 128 254
AR System User Central File Short Description 128 254
AR System User Preference Short Description 128 254
ReportSelection OriginalFormServer 128 254
ReportType Short Description 128 254
FB:Alarm Events Monitor ID 15 254
FB:History Short Description 128 254
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
