java.sql.BatchUpdateException: (conn=*) Duplicate entry '3c4464a7b701230034d1da2***' for key 'PRIMARY'

srinidhi · ‎08-16-2022

Hi Team,

Unable to import the xml's getting below error. Please refer the screenshot. Please let me know how to resolve this

Thanks.

Aman Kumar S · ‎08-16-2022

Check with the same sys_id on the table, there must be some existing record, which is causing this behavior.

You can use this script as well, to see which record corresponds to this sys_id:

Best Regards
Aman Kumar

srinidhi · ‎08-25-2022

Thanks @Aman Kumar, checked the sys_id and found the duplicate onces.

java.sql.BatchUpdateException: (conn=*****) Duplicate entry '3c4464a7b701230034d1da2*******' for key 'PRIMARY'