Skip to Content
avatar image
Former Member

MDM Import map Error

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Dec 06, 2012 at 01:57 PM


    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.



  • avatar image
    Former Member
    Dec 06, 2012 at 02:07 PM

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



    Add comment
    10|10000 characters needed characters exceeded