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]

Hello Mujeeb,

please provide more context: Which products and programming language do you use and on which platform?

Regards, Tim

[former_member1412]

Sure, Tim.

Following are the details:

1. The DB here is Hana and I am using CDS queries to update and insert data.

2. I am using Node.js

3. I am doing the development on the BAS and the services are deployed on Cloud Foundry.

To add more details here:

1. I deleted a few entries from Hana's SQL console.

2. We have an auto cron [batch job] which fetches data from C4C and then process them and updated the Hana database/

3. Fetching and proccessing is workig right but the save/update is failing with the above error.