Matching record with key 'FieldName': XXXX for the data source 'TableName' does not exist

(0) Share

Report

Posted on by Ganesh Potnuru

170

Hi there.

Recently I have gone through this error while working on creating a new data entity.

In my Newly Data Entity, I have multiple Data Sources i.e.,2, and I have added the required fields which I want to export or import.

so when I'm Importing a file with a newly added record to this data entity, I'm getting this error this kind of error "Matching record with key 'FieldName': XXXX for the data source 'TableName' does not exist" and import partially succeeded.

This is because of the two data sources that I have added to my newly created entity relation.

SOLUTION: Go to Data Entity in visual studio which you have created and open the second data source and go to its properties. In the properties, if the join Property is inner join change it to outer join, so that even if there are no matching records in the data source it will import your record because inner join won't allow you to add records if there are no matching records in the joined data source.

Thank you.

I have the same question (0)