Hi,
I was wondering when we import the data into data entity, the data entity is actually the view in SQL, so if the system pops up an error "The record already exists", it must be the the issue from the actual tables?
Thanks,
Hi Yuji,
Or you will have a duplication of records in your input file. Please double check and ensure the records are unique.
One additional remark here. Assuming the data is inserted correctly in the staging table or if you are using Odata, it shouldn't give you just this error as it will try to find an existing record to update it based on the entity key.
If you have this error, then probably, another custom index which is set to not allow duplicates is causing the issue. Or there is some additional x++ coding which it trying to insert related records without taking into account that there already might be a reference record present.
If you get this error during import, it means your entity is not implemented correctly. Normally the entity will not try to insert duplicate record, instead it would find the existing record and update it. So please check if your entity key fields correspond to an unique index in the target table. Most likely they do not and that's not correct. Your entity key fields should always correspond to a unique index in the target table.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,188
André Arnaud de Cal... 868 Super User 2025 Season 2
Sohaib Cheema 593 User Group Leader
