Hi ,
I looked at the sql statements belows and see that it is trying to insert value
in B table like
INSERT INTO B369(C1) VALUES (N'HD0000000000001')
What does the value (N'HD0000000000001') mean? I feel the character N is
violating the unique index on C1 field.
Should'nt it be just ('HD0000000000001') ?
OR if it is correct, can you let me know what 'N' means in the above statement?
Hope it helps..
Thanks,
Mohan
----- Original Message ----
From: Siti Hawa Bee SHAIK FARID <[EMAIL PROTECTED]>
To: arslist@ARSLIST.ORG
Sent: Saturday, March 31, 2007 9:56:33 AM
Subject: Re: SOS- URGENT HELP entry violate a unique index
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"
____________________________________________________________________________________
No need to miss a message. Get email on-the-go
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
