Update SQL query working in transaction but not in database
I am encountering a strange issue in MII, the update query action block in a transaction is working; but in the database it is inserting NULL in the columns. The values returned from the update query action block is correct- but for some reason on, on executing the transaction, the updated values are not seen in the database but NULL. I did try deleting the action block and configuring it again- still the same issue persists.
My update query is of the form:-
SET A= '[Param.4]' , B= '[Param.5]', B= '[Param.6]', D= '[Param.7]', E= '[Param.8]', F= '[Param.9]'
WHERE G= '[Param.1]'
and H= '[Param.2]'
and I= '[Param.3]'
and J= '[Param.10]'
and K= '[Param.11]'
Has anyone faced this issue? How can I resolve the issue? Any suggestions/insights are highly appreciated