Direct sql update not working

We are using DSU in the agent to update release method to Auto Calc Unique. We have observed that OTM sometimes doesn't update the record whereas logs are showing that DSU was executed. This happens sporadically on some orders. I'll appreciate if someone can suggest a fix or work around for this issue.

Here are logs showing sequence of Agent actions (Note that the assign variable picks up existing PREPACK release method suggesting that DSU didn't update the record to Auto Calc Unique).

2014-12-17 12:57:16.582 631108 Debug Agent Performing action DBUpdate: sqlStatement=Update order_release set RELEASE_METHOD_GID ='AUTO_CALC_UNIQUE',MODE_PROFILE_GID='BCI.PARCEL',SHIP_UNIT_ORIGIN='RL' WHERE ORDER_RELEASE_GID = $gid, statementType=Plain SQL Statement, refreshOption=dmlReturning, selectSQLForRefresh=select * from order_release where order_release_gid=$gid, enableLock=true, sqlDescription=Update release method,transport mode and Ship Unit Origin (ORDER FAILED TO PLAN) as BCI (966963292); was DBUpdate: sqlStatement=Update order_release set RELEASE_METHOD_GID ='AUTO_CALC_UNIQUE',MODE_PROFILE_GID='BCI.PARCEL',SHIP_UNIT_ORIGIN='RL' WHERE ORDER_RELEASE_GID = $gid, statementType=Plain SQL Statement, refreshOption=dmlReturning, selectSQLForRefresh=select * from order_release where order_release_gid=$gid, enableLock=true, sqlDescription=Update release method,transport mode and Ship Unit Origin [agentUtility - 9]