Me, either. I have seen that error occur when adding a unique index to a field containing data that violates it. Multiple NULL values are the most frequent culprit.
Rick On Wed, Feb 20, 2008 at 2:33 PM, William Rentfrow < [EMAIL PROTECTED]> wrote: > ** Wow - I've been working with Remedy for 8 years or so and I've never > had the second one happen! > > The first one on the other hand...... > > ------------------------------ > *From:* Action Request System discussion list(ARSList) [mailto: > [EMAIL PROTECTED] *On Behalf Of *Joe DeSouza > *Sent:* Wednesday, February 20, 2008 4:31 PM > *To:* arslist@ARSLIST.ORG > *Subject:* Re: Interview questions > > ** > One of the questions I would ask is the error about violation of unique > indexes. What do you do when you get this error. An experienced developer > would know that this error can happen on both the user tool in case the > system tries to create a duplicate record due to a conflict with the nextid > in case it has been reset earlier OR can happen on the admin tool while > creating new objects if there is a conflict with the containers ID that can > happen sometimes due to data corruption for whatever reasons.. > > I'd be more interested in the later part of the answers as if that occurs > its most likely an experienced developer who would know what got to be done > next to get it working.. > > Joe > > > ----- Original Message ---- > From: John Atherly <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Sent: Wednesday, February 20, 2008 7:07:07 AM > Subject: Re: Interview questions > > Why are manhole covers round? If any other shape they could fall in to > the hole that they cover. > > Do I get the job? > > > John Atherly > American Power Conversion > [EMAIL PROTECTED] > 401-789-5735 Ext. 2120 > 1-800-788-2208 Ext. 2120 > > ------------------------------ > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it > now.<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>__Platinum > Sponsor: > www.rmsportal.com ARSlist: "Where the Answers Are" html___ > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"