Re: Major index problem - RESOLVED - with performance/troubleshoot tips because it's Friday

2008-08-15 Thread William Rentfrow
Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Friday, August 15, 2008 10:38 AM To: arslist@ARSLIST.ORG Subject: Re: Major index problem - RESOLVED - with performance/troubleshoot tips because it's Friday ** William, thanks for sharing thi

Re: Major index problem - RESOLVED - with performance/troubleshoot tips because it's Friday

2008-08-15 Thread Rick Cook
William, thanks for sharing this - it will probably help others at some time. Re: Lesson Three. Could you elaborate on the apps "helping" you by changing the DB CLOB settings? This is disturbing. Rick On Fri, Aug 15, 2008 at 8:28 AM, William Rentfrow < [EMAIL PROTECTED]> wrote: > ** This one

Major index problem - RESOLVED - with performance/troubleshoot tips because it's Friday

2008-08-15 Thread William Rentfrow
This one was a proverbial hum-dinger to fix. It's an interesting problem though so I'll go back through it. Server: ARS 7.1 on Solaris with Incident Management 7.03, SLM 7.1, normal ancillary apps such as AE, EE, MT, etc 4 MT servers on Solaris with Websphere/IBM HTTP server The original probl

Re: Major index problem

2008-08-13 Thread William Rentfrow
om: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Janie Sent: Tuesday, August 12, 2008 3:37 PM To: arslist@ARSLIST.ORG Subject: Re: Major index problem ** The Cleanup for "HPD:CFG Ticket Num Generator" is handled from the 'SYS:Application

Re: Major index problem

2008-08-12 Thread William Rentfrow
T.ORG Subject: Re: Major index problem ** The Cleanup for "HPD:CFG Ticket Num Generator" is handled from the 'SYS:Application Cleanup' form. There is an entry in the form for "HPD:CFG Ticket Num Generator" - most likely the retention period is 1 day, There is a

Re: Major index problem

2008-08-12 Thread Janie
System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Roger Medsker Sent: Tuesday, August 12, 2008 11:51 AM To: arslist@ARSLIST.ORG Subject: Re: Major index problem I believe that the record is created with a value in one of the fields that triggers a filter on the form that per

Re: Major index problem

2008-08-12 Thread Roger Medsker
Rick Cook Sent: Tuesday, August 12, 2008 11:36 AM To: arslist@ARSLIST.ORG Subject: Re: Major index problem ** I think you're right. On Tue, Aug 12, 2008 at 9:30 AM, William Rentfrow <[EMAIL PROTECTED]> wrote: ** Anyone know what escalation? There's no escalation based dir

Re: Major index problem

2008-08-12 Thread Rick Cook
> *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Rick Cook > *Sent:* Tuesday, August 12, 2008 11:24 AM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Major index problem > > ** > William, if memory serves, the

Re: Major index problem

2008-08-12 Thread William Rentfrow
2, 2008 11:24 AM To: arslist@ARSLIST.ORG Subject: Re: Major index problem ** William, if memory serves, the records in that form get flagged for deletion after the Incident is created, and an Escalation deletes them. Rick On Tue, Aug 12, 2008 at 9:18 AM, William Rentfrow <[EMAIL PROT

Re: Major index problem

2008-08-12 Thread Rick Cook
William, if memory serves, the records in that form get flagged for deletion after the Incident is created, and an Escalation deletes them. Rick On Tue, Aug 12, 2008 at 9:18 AM, William Rentfrow < [EMAIL PROTECTED]> wrote: > ** We are having a fairly serious problem in IM 7.03. > > Sometimes - a

Major index problem

2008-08-12 Thread William Rentfrow
We are having a fairly serious problem in IM 7.03. Sometimes - and with no consistency - users will get a "unique index violation" error when creating an incident. After extensive research I've found the following to be true: 1.) The error is valid. 2.) The error happens because the system is