Duplicate entitlement values being created

[PA]

Hello,

I am having an issue of duplicate entitlement value being created for a DB connected app. I inactivated one of the duplicate entitlement values but when I run the job the inactivated entitlement value gets activated while another remains active as well. Same accounts appear in both of the entitlement values.

Where can I configure this to make the duplicate entitlement values remain inactive and also prevent duplicate entitlement values being created? 

[dgandhi]

I believe entitlement id is not mapped in your entitlement import xml and that is the reason duplicate entitlement is getting created.

Can you  map entitlement id if it is not mapped and use update query to rename the duplicate entitlement as one time activity.

[rushikeshvartak]

Select entitlementid,entitlement_value from entitlement_values where entitlementtypekey= 

validate data using below query and inactivate using import sheet

[PA]

Thank you both for your reply. We have the attached table in SQL DB from where we bring the Accounts and entitlements through DB connector for Ent reviews . I can add a column in this table. Would adding a column named entID and adding following help? Can you please suggest the best approach considering the attached table?

<mapfield saviyntproperty="entitlementvalues.entitlementID" sourceproperty="entID" type="character"/>

[dgandhi]

Map this and try

<mapfield saviyntproperty="entitlementvalues.entitlementID" sourceproperty="EntitlementValue" type="character"/>