Re: Not Matching Lengths (server hang)

2012-02-24 Thread Tommy Morris
Rebook -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Thursday, February 23, 2012 4:58 PM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths (server hang) Nike -Original Message- From

Not Matching Lengths

2012-02-23 Thread LJ LongWing
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

Re: Not Matching Lengths

2012-02-23 Thread pascale . sterrett
Seeing the same issue on all 9 servers. This is from one of them AR System Email User Instruction Templates Short Description 60 254 AR System Email Templates Short Description 60 254 AR System Email MessagesShort Description 60 254 AR System Email

Re: Not Matching Lengths

2012-02-23 Thread Andrew C Goodall
...@daimler.com Sent: Thursday, February 23, 2012 11:31 AM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths ** Seeing the same issue on all 9 servers. This is from one of them AR System Email User Instruction TemplatesShort Description 60254 AR System Email Templates

Re: Not Matching Lengths

2012-02-23 Thread pascale . sterrett
on our plate already ;-) Thank you, Pascale Sterrett ago...@jcpenney.com Sent by: arslist@ARSLIST.ORG 02/23/2012 09:39 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Not Matching Lengths ** I ran the query and returned 878 rows. I’m not too concerned

Re: Not Matching Lengths

2012-02-23 Thread LJ LongWing
list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of pascale.sterr...@daimler.com Sent: Thursday, February 23, 2012 10:44 AM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths ** I did not post the customized ones. But I do see the majorities of those are also from Join forms

Re: Not Matching Lengths

2012-02-23 Thread LJ LongWing
AM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths ** I ran the query and returned 878 rows. I'm not too concerned with the ones where the RemedyMaxLength is smaller than the DBMaxlength, but I am concerned about the ones where the DBMaxlength is less than the RemedyMaxLength - it's

Re: Not Matching Lengths

2012-02-23 Thread Danaceau, Chris (CONTR)
-903-8741 Contractor to the Department Of Energy -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Thursday, February 23, 2012 12:20 PM To: arslist@ARSLIST.ORG Subject: Not Matching Lengths List, Our Dev

Re: Not Matching Lengths

2012-02-23 Thread JD Hood
handle 150…that’ll cause issues. ** ** *From:* Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] *On Behalf Of *Andrew C Goodall *Sent:* Thursday, February 23, 2012 10:40 AM *To:* arslist@ARSLIST.ORG *Subject:* Re: Not Matching Lengths ** ** ** I

Re: Not Matching Lengths

2012-02-23 Thread Wirasat Siddiqi
To: arslist@ARSLIST.ORG Date: 02/23/2012 02:10 PM Subject:Re: Not Matching Lengths Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** On a 7.6.04p2 ITSM Pre-Config Stack Installer environment (MS SQLServer) There's 931 fields with different lengths. Exactly

Re: Not Matching Lengths

2012-02-23 Thread Mueller, Doug
@ARSLIST.ORG Subject: Not Matching Lengths 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

Re: Not Matching Lengths

2012-02-23 Thread Jose Huerta
will be 1 more than your AR System definition). Doug Mueller -Original Message- From: Action Request System discussion list(ARSList) [mailto: arslist@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Thursday, February 23, 2012 9:20 AM To: arslist@ARSLIST.ORG Subject: Not Matching Lengths

Re: Not Matching Lengths

2012-02-23 Thread Tommy Morris
@ARSLIST.ORG Subject: Re: Not Matching Lengths ** I ran the query and returned 878 rows. I'm not too concerned with the ones where the RemedyMaxLength is smaller than the DBMaxlength, but I am concerned about the ones where the DBMaxlength is less than the RemedyMaxLength - it's those that could cause

Re: Not Matching Lengths

2012-02-23 Thread John Sundberg
@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Thursday, February 23, 2012 9:20 AM To: arslist@ARSLIST.ORG Subject: Not Matching Lengths 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

Re: Not Matching Lengths

2012-02-23 Thread pascale . sterrett
an issue. Thank you, Pascale Sterrett tommy.mor...@radioshack.com Sent by: arslist@ARSLIST.ORG 02/23/2012 12:21 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Not Matching Lengths ** So are most of you seeing this on join forms? Just curious, we ran

Re: Not Matching Lengths (server hang)

2012-02-23 Thread LJ LongWing
: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Thursday, February 23, 2012 12:46 PM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths Everyone, Just a couple of comments on this thread (including lots of comments that have come

Re: Not Matching Lengths

2012-02-23 Thread LJ LongWing
c.CHARACTER_MAXIMUM_LENGTH and a.schemaType 2 order by a.name, f.fieldName -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Thursday, February 23, 2012 12:46 PM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths

Re: Not Matching Lengths (server hang)

2012-02-23 Thread Mueller, Doug
] On Behalf Of LJ LongWing Sent: Thursday, February 23, 2012 12:45 PM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths (server hang) Dougthat does make sense...thank you for the in depth analysislet me ask you this question. I was going through my system doing performance tuning. I found

Re: Not Matching Lengths (server hang)

2012-02-23 Thread LJ LongWing
:52 PM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths (server hang) LJ, Not sure what was causing the problem in your situation. Obviously the answer is that it could have been any number of things I just don't know what. As it was a crash, it is obviously something that the system

Re: Not Matching Lengths (server hang)

2012-02-23 Thread Mueller, Doug
@ARSLIST.ORG] On Behalf Of LJ LongWing Sent: Thursday, February 23, 2012 2:33 PM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths (server hang) So to restructure, I don't need to make my 'new' size larger than the current DB size, just larger than the current ar size? -Original Message

Re: Not Matching Lengths (server hang)

2012-02-23 Thread LJ LongWing
Nike -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Thursday, February 23, 2012 3:50 PM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths (server hang) LJ, Correct. We don't pay attention

Re: Not Matching Lengths (server hang)

2012-02-23 Thread LJ LongWing
LOL...Nice -Original Message- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Mueller, Doug Sent: Thursday, February 23, 2012 3:50 PM To: arslist@ARSLIST.ORG Subject: Re: Not Matching Lengths (server hang) LJ, Correct. We don't pay