Value Exception in Import server

[Former Member]

Hi Experts,

My requirement is i have 100 files in the ready folder while processing first file through import server, it got value exception which i fixed manually through import manager port option and saved map as update. But even after the files which are having records with same values also moving to Value exception. Can you please me help me out to fix it.

Thanks

Narendra

[Former Member · Accepted solution]

Hi Mullapudi Narendra,

Value exception only come when any new value occurs in you lookup table so avoid this in importmanager configuration setting require to set MDIS parameter

in MDIS Add / Map / fail and ignore detail as follows

Add : value at destination side doesn't exist then this value get added to your lookup table as well as update this value at record. add new value at lookup subtable and update record at main table

Map : value will only map which are exist at destination side. update records at main table

Fail : if any new value occurs which is not exist at destination will not allowed to import this record as well as lookup field value.

entire record will get fail and doesnot import lookup subtable and maintable

Ignore : if any new value occurs which is not exist at destination will ignore this value and remaining data will get import except lookup field which contain new value .only value will ingore at lookup subtable and maintable for respective field, other field data of file will import

Thanks,

Jignesh Patel

[Former Member]

thanks problem solved.

Edited by: Mullapudi Narendra on Aug 23, 2010 9:35 AM

[Former Member]

Hi Narendra

Please save the MAP again using SAVE option for MPM with same name of MAP, then try placing files in ready folder

Thanks

[former_member205403]

Hi,

I am not sure if it will work, but Give a try with to this:

1. Stop Import Server

2. Clean exception directories by deleting all files under exception folder.

3. start import server.

Check and revert with result if this works. it worked for me once.

Best Regards,

Shiv