JDBC sender issue

Hi Experts,

I am working on JDBC to File interface..where we fetch the records from ORACLE database.

we have written a select query which will fetch the records from actual table and also updates the Tracing table(TR_LOG) confirming that the record has been picked by PI with the date and timestamp.

But sometime, it so happen that TR_LOG table shows that PI has picked the message with date/time..but nothing has reached PI...it happens randomly.

we restarted the channel...sometime it works and sometime it doesn't..we dont know where the message has gone if it got picked...there is no trace in CC or in MONI as it hasn't reached PI..

can someone help me in resolving the issue.

thanks