Skip to Content
Former Member
Jan 04, 2008 at 10:30 PM

Missing messages with JDBC adapter


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