java.sql.BatchUpdateException: Duplicate Entry...

[Jordan Vignoni]

Good evening,

I'm experiencing an issue where I'm unable to update the Question of a variable in a record producer without getting the following message:

The message is consistent for all record producers, but the information between "question-question_text" and "key 'name_2" changes based on the Question I'm attempting to update.   Also, all the text in the Question column shows as blue (as shown below):

Also, this is only impacting my personal account.   I'm able to impersonate another user with access to edit record producers and updates are able to be made with no issues.   I believe this all started when I tested an onSubmit() client script (that updates the user record when the end-user updates the contact information) using my personal account.   This led me to disable the client script, as well as create another way that documents the contact changes into the record producer (rather than to the user record) because the onSubmit() client script seemed to be the cause in my testing with other accounts.   However, my account still will not allow changes to the Question of an existing variable on any record producer.

Any ideas on how to resolve this message from showing when editing the Question of a record producer?

Thanks in advance!

[cloudyrobert]

Thanks for this. My issue was that I had a relatively new account, and the language was apparently set to NULL. I discovered as much when looking at my recent history (sys_update_xml) for anything that could have caused this issue. There were some entries in the sys_translated table that had a language value of NU. Once I modified my language to English (and deleted everything I'd done so far today), the issue resolved.

[ramandeepgarg6]

Thank you so much!
It resolved my issue as well.
I selected my language as English. then I deleted records created by me in sys_translated record.
Then i tried again and was able to change the question text without any error.

[Rajshekhar Pau1]

Thanks a ton Mike. There was an issue in my Language in user profile as well, it was set to NU. While creating the variables for a catalog item, i faced this error. Interestingly, I found a clue from my update set, which was capturing an entry into the Translated text table automatically, which is due to my wrong setting of language in the profile. I changed my language to English, and there it is resolved.

Cheers!! Thanks again.

Regards,

Rajshekhar Paul

[ramandeepgarg6]

Hi jvignoni,

I am facing the same issue. Please tell how you resolved that?

Regards

Ramandeep

[Jordan Alcock]

Just to clarify on the solution offered above - I noticed this happens if the user's Language is set to "NUL" (Not Null/empty) in the user record.  There may be other records in the user account that contribute to this, but that's what I've seen.