During Import if one record got failed so all records will not import?

[Former Member]

Hi All,

I want to clear on the following situation:

I have 10 records in a file and due to 2 records some structural reason import got failed.. So do MDIS will import 8 records and create a file with two records in error folder? or it will not import at all and create a file in the error folder?

How does it works? basically I want to know if because of any reason 1-2 records in a 1000 records file got failed do entire file willnot import or only those errored records are not imported?

THanks

Rajeev

[Former Member · Accepted solution]

Hi Rajeev,

have 10 records in a file and due to 2 records some structural reason import got failed.. So do MDIS will import 8 records and create a file with two records in error folder? or it will not import at all and create a file in the error folder?

This totally depends on your business scenario,

1. If you want that if there are expection in even one file also all the records should not be imported than also it is possible

2. If you want that if the exception is there than only the exception records should be sent to the Exception Folder and rest of the records should be imported by MDIS service, this process is also possible.

For implementing the second scenario you just have to set the property in Console -> Admin -> Ports

Block on Structural Exception = No

And if you want that the files should not be imported even if one file has exception then set

Block on Structural Exception = Yes

Hope this would be helpful.

Best Regards,

Parul Malhotra

[Former Member]

HI Rajeev,

Although what Sowseel and Parul pointed out are very correct but there is a scenario when multiple xmls coming from PI get blocked even if one xml has exceptions.

When in ECC data extraction you have block size more than one,PI has these setting http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/30ea2fdf-f047-2a10-d3a2-955a634bd...

then failure of one record can lead to failure of whole package.

Thanks,

Ravi

[former_member207367]

Hi Rajeev,

Import Server will exclude the 2 records which has structural exception and import the rest.....

2 records will be in a file under Structural Exception folder of your port

regards

Sowseel