cancel
Showing results for 
Search instead for 
Did you mean: 

MDIS - Unmapped field values not mapping automatically

Former Member
0 Kudos

We are using MDM 5.5 SP6. The file format is XML schema and using the XSD.

For Default MDIS Handling:

Automap unmapped values: Yes

Unmapped value handling: Add

One of our test environment, MDIS is was NOT picking the files for loading and the port status was showing file is in the ready folder. When restarted all the servers then MDIS picked up this file but there are exceptions and the file is in the exception folder. When we looked this by using the import manager, we noticed some of the field values are not mapped and these fields are flat lookup fields and lookup table has values. Once these field values are mapped, I am able to load this file by using the import Manager.

According to the MDIS configuration, Automap unmapped value = Yes & Unmapped value handling = Add. In this case, lookup table has the values but it is not mapping automatically when using the MDIS.

This environment was working fine until recently but no activity happened the last few months. But nothing changed also.

Any one experience this issue?. What could be the reason?.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

In import map we have set u201CUnmapped Value Addu201D option, which basically add new value in Lookup flat if it does not exists in MDM.

But this works when only one field from your file is mapped to that destination lookup field.

if more than one fileds are mapped then Import Server Just adds the Value in lookup but could not do automapping.

For example:

Your main table has 3 fields Customer Name(text), Global Ultimate County(Lookup Flat), Domestic Ultimate County(Lookup Flat)

here last two fields are pointing to same lookup table County.

Now in Import Manager you do mapping for all there fields.

If file contains data which is already there in County lookup table then Automatic import will work successfully.

But if file has New county code then Import Server will only add new value in Lookup table.... but could not map 2 fields from source file to ur main table fields.

If there is only one Lookup field then Adding & automapping works properly.

Thanks,

Maheshwari

Former Member
0 Kudos

Maheshwari,

Our case, field mapping is very simple and it is Source field A mapped to Target Field A (lookup table) . Just one source field to the corresponding taget field that is all.

Here I am looking for the the reason why simple field to field mapping not working and this was working fine until recently and other environmnets works fine.

Steve.

Former Member
0 Kudos

Hi Steve

Please check if in that environment remote key mapping is enabled for the lookup tables.

For automapping to happen key mapping property should be enabled in MDM.

If not in the map you need to map the values for once and if some new values are coming in the source file(Value exception folders) it has to be manually mapped for first time.

Hope this helps.

Regards

Ravi

Former Member
0 Kudos

Hello ,

I am trying to do automatic import through port in SAP MDM 7.1 SP06 . One of the fields in destination is a hierarchy lookup. For eg: destination field is "region" which is a hierarchy lookup field. The lookup is like Country US then all the regions as child. In my XSD for import I am sending only the leaf node FL, Florida. When I use this map through XML Schema option in import manager and press "Automap" in Value mapping, it maps to the right node in the destination. I want this to automate during Import through Port i.e whenever a new region comes it should get automapped. I have done the folowing configuration setting"

Default MDIS handling- Aotmap unmapped values -- Yes

Value Automap-- Hierarchy-- Leaf nodes only

But inspite of this setting it does not automap.

Please suggest a solution or it is a bug?

Regards

Manoj

former_member189669
Active Participant
0 Kudos

Hi Manoj,

Please update remote keys for all the records in Heirarchy table. Auto import will work.

Regards,

Vinay

Former Member
0 Kudos

Hi Lamp,

Again restart all the auxiliary servers...

Thanks

Yugandhar