Error handling : File( sender and receiver)

[Former Member]

Hi Experts,

This is regarding some information i require in the Error Handling mechanisms we can use while picking up the file through File Sender Adapter and while placing the same on the receiver adapter :

Scenarios like :

a) Validations we can put , on the file , should that be done in SAP XI or after placing in SAP ERP.

b) If the file is of a different format and isnt picked up how can that be handled ? ]

c) if the File contains wrong data , should the alert be generated in SAP or SAP XI ?

d) If the file does not arrive in the folder itself what is the error handling meachanism ?

e) diff

thanks

Dev

[former_member200962 · Accepted solution]

a) Validations we can put , on the file , should that be done in SAP XI or after placing in SAP ERP

Do validations on File mean perform a check on the file for its contents, format, structure? If yes, then these are performed in XI/ PI

b) If the file is of a different format and isnt picked up how can that be handled ? 

The file channel will throw an error if it is not able to find the file (specified in sender channel) during its poll interval.

c) if the File contains wrong data , should the alert be generated in SAP or SAP XI ?

If SAP is the target system, then better the check and alert be done in SAP XI/ PI, as far as possible we should avoid sending wrong data to the target.

d) If the file does not arrive in the folder itself what is the error handling meachanism ?

Which folder are you talking about? If it is source folder then the error will be thrown as mentioned in point b.

If it is target folder, then the error (if any) will be captured either in IE or AE of SAP XI/ PI and can be intimated using alerts.

Regards,

Abhishek.

[Former Member · Accepted solution]

Thanks for your response Abhishek

I have the following two questions :

a) Validations for checking file for its contents .. how is that done ?? lets say if the field in the source file is coming or not .. or if the file that is about to be picked up does not contain the same date as they previous file etc ....how can this be achieved ??

b) if the file contains wrong data then we shud avoid sending wrong data to be sent ot the target system (yes it is SAP in mycase)

Can we restrict this in the source folder that the file contains wrong data and it shoudlnt be picked ?? how can we achieve this ?

thanks

Dev

[former_member200962 · Accepted solution]

lets say if the field in the source file is coming or not

If on SAP PI7.1 then you can use the option of XML validation by Adapter/ Integration Engine.....or in general can make use of the Condition in Receiver Determination.....in both the cases the file will be picked up from the source folder

Can we restrict this in the source folder that the file contains wrong data and it shoudlnt be picked ??

needs to be done using an adapter module.

Regards,

Abhishek.

[Former Member · Accepted solution]

a) Validations for checking file for its contents .. how is that done ?? lets say if the field in the source file is coming or not .. or if the file that is about to be picked up does not contain the same date as they previous file etc ....how can this be achieved ??

b) if the file contains wrong data then we shud avoid sending wrong data to be sent ot the target system (yes it is SAP in mycase) Can we restrict this in the source folder that the file contains wrong data and it shoudlnt be picked ?? how can we achieve this ? 

You can do it using feature XML Validation at adapter level. But make sure your XSD s defined properly.

For example : If you need just Y & N in a field , then your XSD should have a enumartion with these values for teh particular field.

Regards

Soumen...