Blank file into MDM Tuple

[Former Member]

We have a valid scenario where we push blank files to a MDM port which handles a Tuple load. MDIS righlty raises structural exception because it is looking for a matching parent customer number in MDM. Is there way we can avoid this structural exception by doing a map configuration or some validation workflow check.

I believe even validation workflow step will be triggered only after structural check is done by MDIS. so validation workflow may not work.

Let me know your inputs.

[Former Member · Accepted solution]

Hi Subin,

Please check the xsd to confirm if customer no is mandatory.

I think this is causing the Structural exception.

If you want the scenario to work without then place a DUMMY value in customerid from source system or PI.Map this DUMMY value to NULL in MDM and do a save update.

This way customerid will be NULL.

Thanks,

Ravi

[Former Member]

Hi Subin,

I am with Ravi to suggest you to use Dummy Customer ID and then map it to NULL so that file does not fail in structural exception when MDIS scans for a file in the port.

Please let us know if you need any other help from us.

Thanks and Regards,

Ankush

[Former Member]

It was due to some corruption in the map. I have recreated the map and it worked.

Thanks.

[former_member733388]

Hi Subin,

Turn off automatic port blocking, set the port's Block on Structural Exceptions property = " No"

in the Port Detail pane on the MDM Console

Note:  

            Turning off automatic port blocking is strongly discouraged

because the underlying cause of the structural exception may impact

all import files processed from the port, in which case the exception will

have to be fixed on multiple import files instead of just one.

Regards,

Raja Babu.