Import Server - Multiple Qualified Table - Map Crash

[Former Member]

Hello,

Requirement: I need to update multiple qualified table using single source file.

Preparation: I have created a map where mapping to multiple qualified table fields maually.

Have created a Inbound Port using the above map.

Problem: Import server throws an exception; while opening the Import Manager using the Port Option and corresponding Exception; Lot of fields were un-mapped. Looks like Import map crashed.

Please feel free to throw some light reg the same!

Thanks

Alexander

[Former Member]

Hi Alexander,

If you are performing multiple qualifier table mapping and importing then you will hav eto create differnt map for each table importing.In that case you will rrquire multiple inbound ports and in each ports deatils you will give the map name pertaining to which qualified lookup table you wish to import.

Actually using automatic importing for lookups is not desirable as the lookups always need to be prepopulated before your main table importing.

The exception taht you are receiving could be due to the reason that the map you are saving is using only one table mapping and so most of the fields are left unmapped.

try not to use automatic importing for Lookup qualifier tables and use manual importing and see if the the exception still comes.

Hope it helps

Kindly reaward points if found useful

Thanks

Simona

[Former Member]

Hi,

After creating the map try to execute it using Import Manager itself. If import is successful then only use the map for Import Server.By this you will get the exact error if exists in the map.

Regards,

Jitesh Talreja

[Former Member]

Check the exception file to see what the error is, and if you can paste it into this message so we can take a look at it. A common mistake is when you have values that are being mapped to a lookup table which require automapping. In the map go to configuration options, and then make sure automapping is set to True. Another thing that happens is when values are being imported that don't exist in a lookup table already. You need to specify whether you want to map them to NULL, another value, or add the new value to the lookup table.