Hi Frank, Sorry i had checked and confirmed that i did NOT delete from B369C300615200. So what should i do next?
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Frank Caruso Sent: Saturday, March 31, 2007 22:39 To: arslist@ARSLIST.ORG Subject: Re: SOS- URGENT HELP entry violate a unique index ** It sounds as though you manually deleted from the tables T369, B369 and H369. However did you also delete from B369C300615200 which is a table? On 3/31/07, Siti Hawa Bee SHAIK FARID <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: It seems there is a problem when it is trying to push the value to B369. The statement terminated there. Any clue why is this happening? How to resolve this issue. I can't even submit any helpdesk cases now. <SQL > <TID: 0000002080> <RPC ID: 0000130794> <Queue: Admin > <Client-RPC: 390620 > <USER: OPSSIT > /* Sat Mar 31 2007 21:30:16.8050 */BEGIN TRANSACTION <SQL > <TID: 0000002080> <RPC ID: 0000130794> <Queue: Admin > <Client-RPC: 390620 > <USER: OPSSIT > /* Sat Mar 31 2007 21:30:16.8050 */UPDATE arschema SET nextId = nextId + 1 WHERE schemaId = 369 <SQL > <TID: 0000002080> <RPC ID: 0000130794> <Queue: Admin > <Client-RPC: 390620 > <USER: OPSSIT > /* Sat Mar 31 2007 21:30:16.8050 */SELECT nextId FROM arschema WHERE schemaId = 369 <SQL > <TID: 0000002080> <RPC ID: 0000130794> <Queue: Admin > <Client-RPC: 390620 > <USER: OPSSIT > /* Sat Mar 31 2007 21:30:16.8050 */UPDATE B369 SET CO300615200=NULL,CC300615200=NULL,C300615200=NULL WHERE C1=N'HD0000000000001' <SQL > <TID: 0000002080> <RPC ID: 0000130794> <Queue: Admin > <Client-RPC: 390620 > <USER: OPSSIT > /* Sat Mar 31 2007 21:30:16.8050 */INSERT INTO B369(C1) VALUES (N'HD0000000000001') <SQL > <TID: 0000002080> <RPC ID: 0000130794> <Queue: Admin > <Client-RPC: 390620 > <USER: OPSSIT > /* Sat Mar 31 2007 21:30:16.8050 */UPDATE B369 SET CO300615200=NULL,CC300615200=NULL,C300615200=NULL WHERE C1=N'HD0000000000001' <SQL > <TID: 0000002080> <RPC ID: 0000130794> <Queue: Admin > <Client-RPC: 390620 > <USER: OPSSIT > /* Sat Mar 31 2007 21:30:16.8050 */INSERT INTO B369C300615200 (entryId) VALUES (N'HD0000000000001') <SQL > <TID: 0000002080> <RPC ID: 0000130794> <Queue: Admin > <Client-RPC: 390620 > <USER: OPSSIT > /* Sat Mar 31 2007 21:30:16.8050 */* WARNING * The statement has been terminated. -----Original Message----- From: Siti Hawa Bee SHAIK FARID Sent: Saturday, March 31, 2007 21:42 To: 'arslist@ARSLIST.ORG <mailto:arslist@ARSLIST.ORG> ' Subject: SOS- URGENT HELP entry violate a unique index 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 <http://www.arslist.org> ARSlist:"Where the Answers Are" -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com <http://www.specificintegration.com> 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"