When does different type of exceptions occur during Auto-Import in SAP MDM?

[former_member203465]

My query is related to exceptions that occur during Auto Import and are as below:

1. When does each type of exception(Structural, Value & Import exception) occur?

2. What is the difference between Value exception and Import exception?

3. What all categorize wrong or junk value for Value and Import exceptions?

[shanthi_kumar]

Hi Sushan,

Whenever there is a inconsistency in the file that is being imported, Exception occurs and they are being categorized into Structural, Value and Import Exception.

1. a. Structural : When the structure of the file that is being imported is different from the referenced structured in the Import Map, structural Exception occurs. That particular import file will be placed in the Structural Exception folder.

    b.Value : When there is a Value mismatch for the fields mapped there comes Values mismatch. For example if a field is of type Numeric and if the incoming value is 'ABC', then there comes a Value mismatch.

    c. Import: When there is a issue in Import for example connectivity issue in PI, then there comes Import Exception. A lot of times it happens that you will be able to see the files in Import Exception folder and the files are being processed successfully to the receiving system.

2. As explained above Value Exception is because of the Value in a particular field, Import exception is totally different from this.

3. Any value which is of different Data type, exceeding the number of characters allocated for a field, junk value in the XML, value missing for a particular field which is mandatory are examples of Value Exception. There are N number of reasons which will make way for Import exceptions.

Please refer to Console reference guide from Page 266 through 277, which explains clearly about the exceptions. There are also a lot of threads where this is being discussed. Please refer them as well.

Reach us if you have further doubts.

Kind Regards,

Thamizharasi N

[Former Member]

Hi,

I'll try to explain the main operation that can cause each exception type in MDIS:

1. Structural - based on the format of the source a streaming, import server is scanning and transforming the source tables and  records into virtual records.

2. Value - based on the information retrieved from the map the Transformed Source Records are scanned for possible value transformation. This includes field mapping, value mapping and conversion to all records.

3. Import - source transformed/converted records are ready to be handed over to MDS, this includes get matched field converted values, apply input action based on match type of record (skip, create, update), populate import structure, populate Lookup import structure.

Thanks,

Sivan