Adapter keeps polling the same record

I have a problem with my integration. I’m doing one-way integration between two databases. When the integration get triggered by updating the first database, it complete all the transactions without any problems. But the records in the temporary hold tables do not get deleted by webMethods. Sot the adapter polling continues selecting the same records and re triggering the same integration. Anyone has gone through similar problems. Please help.

Samir Issa

In the update notificaton remove any where clause and put the same logic in
your Integration.