Question

10
Replies
1550
Views
Aniket Kedari (Aniket)
Vodafone GmBH

Vodafone GmBH
IN
Aniket Member since 2013 24 posts
Vodafone GmBH
Posted: August 10, 2015
Last activity: August 28, 2015
Posted: 10 Aug 2015 14:04 EDT
Last activity: 28 Aug 2015 11:21 EDT
Closed
Solved

key mismatch

Our application has a class XXX-Int-DWH-Assigned_Product which is mapped to a table Assgined_Product in db. This table was existing for few months. To update the entries in this table we recently added a primary key constraint in the database table also defined same property as the key in class definition. It works fine in DEV environment but not in test environment.

I can see the db table definition has a primary key in db and class also has keys, but while doing 'Test Connectivity' I get an error like below. I suspected a miss in grants or synonm but I dont see any differences in it

There is a key mismatch: the keys defined for class BGC-Int-DWH-AssignedProduct do not match the primary key columns for external data table Assigned_Product in database PegaRULES; the class keys are [Product_Sr_Number], but the table's primary keys are [].

Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.