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.
But still no luck.
Any suggestions ?
Novitates
IN
I tried the below solution and it didn't work
- Deleted all the record from the data table
- saved class and Data-Admin-DB-Table (Class Name)
- Revalidate and Save Data-Admin-DB-Table and Rule-obj-Class
- Test Connectivity of XXX-Data-DWH-List_Product still shows key miss match error
how to update the keys in external data table customerdata.pr_pr_List_Product
Does it work if drop the table customerdata.pr_pr_List_Product and re generate the same table with new keys ?
Any suggestion/Approach appreciated
BPM Company
NL
@VikramReddy if you have write-access to DB, you can do it using ALTER statement. Or, in postgresql for example, you can use pgadmin to create a new constraint with the list of columns you want to have as a key
BPM Company
NL
@VikramReddy and if you don't have access to DB then I looks like it's not possible to do it only from Pega (weeeeeell, unless you create a custom SQL connector with ALTER statement. But that's a dirty trick)