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

[tim_schulze-hartung · Accepted solution]

Hi Mujeeb,

thanks for providing context.

You most probably are using some 'unique' constraint in your DDL (e.g., `@assert.unique` in CDL) and there is an error connected with this – so some data affected by the constraint seems to be present already.

Unfortunately there is a known issue as to the original error message getting lost.

Hope these hints help you.

Regards,
Tim