Hi All
We are having an Oracle to SAP R/3 interface.
The jdbc sender adapter polls for records from the Orcale database the interface sends each row in the resultset as IDOC to the SAP R/3 via the IDOC adapter.
Our Oracle database in the sender side is having heavy load and quite an exceeding overhead, as it is accessed by numerous other transactions and also due to the number of records. So executing a SELECTquery takes enough time .
We are doing a SELECT query in the jdbc sender adapter as :
' Select * from tablename where processed = "N". ' and in the update column we have an update statement to update all the processd ones like:
' update tablename Set processed = "Y" where processed = "N" '
But right now even if there are certain records that are not picked up , l an update on those IDOCS happen . The most interesting thing is that when we checked for logs in SXMB_MONI or message monitoring for such messages(only the UPDATE) there aren't any .
So the reason which we presume for the UPDATE to take place (not the SELECT) and for it to not get logged is that ; as the database is quite heavy, after several attempts to do a SELECT query the query might have failed (timed out) and then the UPDATE was triggered thus updating unwatned records.
Is there any way to increase the time out of the jdbc sender adapter?
Or does it happen this way, even if the select query gets timed out will an update query get triggered . Or is there a way to say that the UPDATE should get executed only if the SELECT executes properly.
Any sort of suggestion or info is highly appreciated.
Thanks & Regards,
Rahul