Posted: Tue Dec 08, 2009 1:06 am Post subject: SAPRequest Node : Scenario when the SAP connection is down
Centurion
Joined: 18 Nov 2009 Posts: 118
Hello Everyone,
We have developed a flow which has FileInput node -> Compute node -> SAPRequest node. I have a fileoutput node attached to catch terminal so that if the SAP link goes down the FULL file will be in the location mentioned in FileOutput node.
A file might have multiple records and each record will generate an IDOC. We parse the full file initially in the FileInput node and send it to Compute node. In the compute node each record is read and an IDOC is generated out of it.
My question is what if the file has 10 records and till 5 recods, the SAP connection is fine. While processing the 6th record the broker-SAP connection goes down. How should I take care of such a scenario ??
As of now what I have thought is check in SAP till where the records are read and IDOC generated and the delete those many records from the file and reprocess the remaining file whose IDOC have not been generated. But this is a cumbersome/time consuming process.
My question with the SAP end would be is this a timing issue ie could the delivery of the IDOCs be set on a timed basis rather than en bloc. Would the number of entries in SAP decrease after 30 seconds etc.
Not being conversant with the latest versions and peculiarities of SAP is there a limit within SAP to stop overloads? _________________ Who is General Failure and why is he reading my hard drive?
Artificial Intelligence stands no chance against Natural Stupidity.
Joined: 12 Sep 2006 Posts: 2493 Location: Boston, US
Transaction can be enabled on both the ends on SAP sides as well as on MB side.
it wont be an issue, if you design it properly, it will roll back and keep your data safe.
SAP Request got Failure node and out terminal
where in the out terminal you can catch the SAP Transaction ID.
Failure node you can think of doing the error handling. _________________ Regards
Gayathri
-----------------------------------------------
Do Something Before you Die
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum