I’m working working on a flow which synch data from oracle db and SAP R/3 sys… its a plain intergration , No Monitor here…
How can i handle the exception fired during the end systems are down… I mean when wM is holding data pulling from db if SAP is down … what i can do… In SAP i’m invoking an RFC wic will push data into R/3 sys.
Similarly in vice versa when i need to push into db … what can i do…
Solns:
As i know i can have Retry option … but if it fails in all retries also then?
And how actually configure Retry option in flow service…?
Have the DB operation and SAP RFC call as a single block of operation . When the end systems are down the worst case is half data-synch’d and half left over. Address this issue first .
Use batch insert/select for DB .
In both the cases (to and from DB ) you should be using canonicals and those canonicals can be serialized to your disk in case of any failures and you use a retry service to manually start from the point where it failed .
Retry can be done by using repeat . Exit on success , retry on failure . You many dynamically give the values for retry count and retry interval as per your need .
This has been covered several times in this forum. Do some searching and you will find the answer. It’s also covered in the pub/sub guide that comes with the product.
Retries are configured on the triggers. Just make sure your triggered service throw a ‘Retry for Exception’, and that they are transactional. You can have infinite retries - of course, your remote system would have to come up before the queues filled up.
I’m given to understand that you really need Broker to make this enterprise grade.
Read pub/sub documentation , and look for resource monitoring service . U need to create a resource monitoring service and configure your trigger accordingly.read the documentation so that u can understand clearly.
HTH
sri
