Query:

UPDATE seg_encounter_location_rate SET ward_nr='1', room_nr='15', bed_nr='1', rate='0.0000' WHERE encounter_nr='2009023671' AND loc_enc_nr='411265'

I've got an error:
No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table.

What do you mean by Smart Rollback occurred?
How can I resolve my error?

I don't know what do you mean by "Smart Rollback".

By the way, the error(?) said that No row was found which satisfy the WHERE condition encounter_nr='2009023671' AND loc_enc_nr='411265'.

So, it would be a warning, not an error.

Maybe "Smart Rollback" just means the fact that all changes that the SQL statement would have made are undone in case the SQL statement fails (but not with a warning as is the case here). However, that's not a "rollback" but rather a way to guarantee that each statement is atomically executed.