MDM Import map Error

[former_member445255]

Hi Experts,

I have a requirement where I have to update the MDM import map to accomodate additional fields as some new fields have to be imported in MDM in future.

I have created these fields in MDM; PI has completed the required mappings for these additional fields. I have updated the new XML schema in Admin tables-XML schemas, and updated ports table.

Now when I am trying to open the import map using the new XML file  I am getting the error “unable to retrieve unique value for fields XXX’.

I am getting this error with the old XML files also .

Please suggest what can be done to avoid this error and update the import map(by mapping the new fields) to enable automatic import

Thanks in Advance!

[Former Member]

Seems like its a unique constraint violation. Please refer the below link which addresses your error.

http://scn.sap.com/message/7828610

regards,

Prasad

[Former Member]

Div,

As error relates to unique value problem, it might be the authorization issue or the file problem (Data or Format).

Authorization Issue: Check, if you have assigned to a correct role or you should not be assigned to multiple roles with opposite accesses .
Data Issue: Check the values of your file or check the format.

Still, could you let me know the following things?

1. Did you modify the XML schema or you get the modified one from PI team?
2. What is happening after you closing that error message? Are you getting some fields mapped or no single field is mapped after that error, as you are opening your existing map?
3. What are the type of your fields, which you created in MDM?

Thx/ -Tarun

[former_member445255]

Please find my answers below-

1.       Schema was provided by PI team.

2.       After closing the error, when I clicked on those fields(showing error) present In map fields/values Tab of the import manager, I am  getting the same error message i.e. “unable to retrieve unique value for field XX”

3.       Additional fields that I created in MDM are of type Text and Lookup[flat].Also no value is coming under Value Mapping Tab for these fields.Ideally for Null fields we can see "NULL" in Value Mapping tab of import manager.

I have checked the authorization and its correct,Also I am getting this error for fields with Type Lookup fields only. And now when I am trying to import the old XML’s using the old schema , I have started to face the same problem with them also.

Please suggest what can be done to avoid this and update the new mappings, as problem is coming only when I try to open the maps.

[Former Member]

Hi Div,

As per my knowledge, please check for how many fields u have defined as unique in your xml schema, If one or more fields are defined as unique, then in the input file those values also should be unique.

If that doesn't work, please check the authorizations for the user, it might be because of too many access granted for that user.

regards

vinoth