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' 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 ARSlist:"Where the Answers Are"