A long long long time ago a client of mine once had this issue.. I had gone under the covers, and realized that it the ARS was trying to create this object with the same ID that already existed (I think it was for AL's) but the ID in the container table was not updated. We never were able to find out how that may have happened but we attributed it to possible database timeouts as they were experiencing a few of those during that time..
On another occassion a lister here had experienced the same thing and I was able to help him/her restore their system.. The thing about such errors is usually it doesn't give you details as to which table or container this error is resulting from, and one way to find out is an SQL log during the operation. I'm not sure there could be another method to find this out as this is a DB problem.. Joe ----- Original Message ---- From: William Rentfrow <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, February 20, 2008 4:33:55 PM Subject: Re: Interview questions ** 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 ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
