java.sql.BatchUpdateException: (conn=XXXXXX) Duplicate entry 'sys_app_application-title-XXXXXXXX-NU' for key 'name_2'
Inorder to change the Application menu in the navigation panel:
Faced this error:
java.sql.BatchUpdateException: (conn=XXXXX) Duplicate entry 'sys_app_application-title-XXXXXX' for key 'name_2'and Title is not changing but captured "Translated Name / Field" in the Updateset.
Some Explanation: whenever u attempt to change the title , the error messages count increases. This is because based on the attempts of change, records will enter into 'sys_translated' table.
To fix this, Steps to do:
1)Open sys_user list (List of users table)
2)From the list layout,get the Language field on to the LIst.
3)Change the Language value from "NUL/empty/None" to english.
4)Now delete the records which you have created from 'sys_translated' table list
5)Logout from the instance
6)Login to the instance again
7)Now try to change the title of the Application menu
8)Hope it works!Same fix applies to any field that throws this type of error like updating question in variable.,etcThankYou.
Sai Revanth
https://www.servicenow.com/community/now-platform-articles/java-sql-batchupdateexception-conn-xxxxxx-duplicate-entry-sys/ta-p/2324609
