Hi ,
I have a file to JDBC adapter scenario. In the JDBC adapter there are multiple table updates and also executes a stored procedure.
In production I am missing file's and this has happenned on 2 different occassions. The message has come through the file adapter and SXMB_MONI is fine with a success flag. However there is no trace of the file in the SQL database.
This happens when 2 or 3 files come in at the same time. When the file is re-dropped it processes without any issues.
I have tried to re-create this issue in QA with processing 60 files at the same time and was not able to re-create this error.
There is a deadlock error but it resolves without any issue.
Any help is greatly appreciated.
Joe Vellaiparambil