Getting Error: java.sql.BatchUpdateException: Duplicate entry 'e05dd3c82b45e100b641825319da15e4' for key 'PRIMARY'

[m_servicenow]

Hi All,

When i m submitting PC ordering through record producer always i m getting following

Error which is in screenshot...

Find the attached screenshot....

Thanks in advances..

[HarshTimes]

Hi check your request table dictionary which field is set as unique.then cross check that field value which is generating when you are raising a new request.This is due to the record with save value in that field is present

[m_servicenow]

Hi Harsh,

As you suggested i checked sc_request table in dictionary none of the field is "Unique" . Still i am getting Same error only sys_id changes according to request number sys_id..

Second Error is: java.sql.BatchUpdateException: Duplicate entry 'cd616b542b49e100b641825319da1554' for key 'PRIMARY'.

Please let me know if you have any other idea how to remove this error after submitting the request...

Thanks,

Mukesh

[HarshTimes]

The issue is related to the duplicate record entry which is sure.This is also possible that there may be some unique field on database level which are not visible on the table structure. Is this table indexed? I think you need to raise a HI ticket to look into the unique field on this table

[Subhajit1]

Could you please check if you are having Cache Issues on your instance.

Go to App Nav, type in sys_cache_flush.list and then sort by created.

If you see a future Timestamp, you are facing cache issue. Contact HI for that.

We faced this issue in the past and clearing Cache helped us solve the issue.