‎2011 Jan 14 2:24 PM
Hi,
I have external Oracle database and records in it that should be readed by SAP, afterwards SAP should update the SAP database and to update records as processed into external database. How should be done if the connection between both systems is broken or what will happen if one of them is down ? I need working solution which will exclude duplicating or missing records.
Pls advice !
Thanks in advance !
Stefan
‎2011 Jan 14 3:33 PM
Well, presumably, if you have a job scheduled at certain intervals, and there's no connection, then the job terminates without doing anything and there's no issue? If the SAP system is down, the job doesn't run and picks itself back up on the next run. Are you using a direct connection or a connection to an application via RFC function or web service? The DB Assistant has an alert monitor which will handle checking the connection and notification. You can also check the connection manually by pinging the DB server or using one of the DBCON functions as well before executing your core application code.
‎2011 Jan 14 3:33 PM
Well, presumably, if you have a job scheduled at certain intervals, and there's no connection, then the job terminates without doing anything and there's no issue? If the SAP system is down, the job doesn't run and picks itself back up on the next run. Are you using a direct connection or a connection to an application via RFC function or web service? The DB Assistant has an alert monitor which will handle checking the connection and notification. You can also check the connection manually by pinging the DB server or using one of the DBCON functions as well before executing your core application code.