Thanks for your reply, Archana. The problem was resolved after I had deleted those records in these tables as well, B369C300615200, B369C300615300 and B369C300615400.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Vyom Labs - ITSM Support Sent: Monday, April 02, 2007 23:32 To: [email protected] Subject: Re: SOS- URGENT HELP entry violate a unique index Just check out which fields are indexed with the unique flag set, and ensure that you are not trying to add a value that already exists for that field. Example: I have created two character fields with first name and last name, and set unique flag set for last name so that when we saved duplicate data with same last name then it will generate an error message ARERR[382] because last name has a unique flag set. Please do check for the unique index is required for the fields. If possible try to customize with minimum index to the fields. Regards, Archana -- www.vyomlabs.com Consulting | Oursourcing | Training || ITIL | IT Governance |BMC Remedy Siti Hawa Bee SHAIK FARID wrote: > > My Dear Listers, > > I really need your expert advise to resolve this issue. > > When I created a case and saved it, I was hit with this error msg " > ARERR[382] The value for this entry violate a unique index that has been > defined for this form. > > I had done the SQL, filter, DB and active link logging but I dun see that > error msg in the logs and I still do not know where the error msg comes from > and what is it checking on that refrain me from submitted a case. > > I had initially deleted the cases from HPD:Helpdesk and when re-importing > hit the error msg. > Now when I tried to create just a simple new case and submit, I also hit the > same error message. > > Because I need to reimport again, I had deleted helpdesk records from table > T369, B369 and H369. > > I would appreciate if anyone of you out there can come to my rescue. Please > render your help. > > UOB EMAIL DISCLAIMER > Any person receiving this email and any attachment(s) contained, shall treat the information as confidential and not misuse, copy, disclose, distribute or retain the information in any way that amounts to a breach of confidentiality. If you are not the intended recipient, please delete all copies of this email from your computer system. As the integrity of this message cannot be guaranteed, neither UOB nor any entity in the UOB Group shall be responsible for the contents. Any opinion in this email may not necessarily represent the opinion of UOB or any entity in the UOB Group. > > ____________________________________________________________________________ ___ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" > ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" UOB EMAIL DISCLAIMER Any person receiving this email and any attachment(s) contained, shall treat the information as confidential and not misuse, copy, disclose, distribute or retain the information in any way that amounts to a breach of confidentiality. If you are not the intended recipient, please delete all copies of this email from your computer system. As the integrity of this message cannot be guaranteed, neither UOB nor any entity in the UOB Group shall be responsible for the contents. Any opinion in this email may not necessarily represent the opinion of UOB or any entity in the UOB Group. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
