Delete them. According to your logs this is where the violation was occurring and would make sense since you did not remove them.
On 3/31/07, Siti Hawa Bee SHAIK FARID <[EMAIL PROTECTED]> wrote:
** 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:* [email protected] *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]> 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: '[email protected]' > 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" > -- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___
-- Frank Caruso Specific Integration, Inc. Senior Remedy Engineer, ITIL Foundation Certified www.specificintegration.com 703-376-1249 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
