Posted: 30 Sep 2020 2:55 EDT Last activity: 7 Oct 2020 0:26 EDT
Adding new primary key for existing class key mismatch
Our application has a class XXX-Data-DWH-List_Product which is mapped to a table pr_List_Product in db.
I have added new key[Name] to this class XXX-Data-DWH-List_Product when i do test connectvity i see this error
There is a key mismatch: the keys defined for class XXX-Data-DWH-List_Product do not match the primary key columns for external data table customerdata.pr_pr_List_Product in database CustomerData; the class keys are [ID,Type,Name], but the table's primary keys are [customerdata.type, customerdata.id]
I have tired to update the key as below :
Configure---Data model--Data base table mapping
Select Category : Data-
Class :XXX-Data-DWH-List_Product Data base : Customer Data Edit and select the new keys and save.