To simulate the other, try setting your next id for any object to an already existing ID, and then try creating that object.. That's what happened at a customer site, I only have a guess as to how it MAY have happened, but no confirmation... If you do simulate it do not forget to set the Id back to what it should be..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Rick Cook Sent: Wednesday, February 20, 2008 6:26 PM To: [email protected] Subject: Re: Interview questions ** 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: [email protected] 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: [email protected] 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. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.20.9/1290 - Release Date: 2/20/2008 8:45 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
