For the Past few days we are seeing some strange issues for one of the process, we are using Database adapter for fetching the records once the records fetched database adapter updates the field in the table with a value and after achieving the Business Logic we are updating the same table and same field(i.e is the used for fetching the records) with some other value.It is updating for some records and not for all. I tried to replicate the issue in other environments but no use
Are you trying to use the same DB adapter to both select and update the same table?
If so, you need to pass all those elements you have choosen in your select operation, to the update operation.
Can you please explain in more detail on what you are trying to do?