Unable to insert data getting ENTITY_ALREADY_EXISTS

[former_member1412]

1. I am trying to bulk insert records using the following query:

DAO.INSERT.into(entity).entries(toInsert)

2. But I end up with the following error:

{"code":400,"message":"ENTITY_ALREADY_EXISTS","numericSeverity":4}

even though there are no duplicates in the table

[johnmurray]

Hi anupamalok07 did you ever discover the cause of this problem? I have started experiencing it today with my applications and I'm not sure why yet

Thanks

John

[shiromani_soni1]

If you are trying to do some validations using srv.before event and creating records/data using the same event, then you would be facing this issue.

Please make sure if there are any validations before record insertion, use srv.before and for Insert query use srv.on event, that should solve your problem.

Shiromani Soni

[former_member1412]

Hi Tim,

Thank you for the help. This hint helped me understand the root cause.

The issue was that the array which I was sent to be uploaded had a duplicate record within in. I was not aware of that and was checking on all other places as it sent ENTITY_ALREADY_EXISTS error which put me off track.