Update SQL query working in transaction but not in database

[raj44]

Hi Everyone,

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:-

UPDATE   TABLE  

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

Thanks

Rajeev

[raj44]

Hi Swaroop,

Issue resolved, it was data format issue.

Regards

[swaroop_anasane]

That's what I presumed.

Regards,

Swaroop

[swaroop_anasane]

Hi Rajeev,

How are you assigning the parameters?

Also, have you set Auto-Type Parameters to true in the query?

Regards,

Swaroop

[raj44]

Hi Swaroop,

I am assigning the parameters via transaction parameters using transaction action block.

Regards

Rajeev

[swaroop_anasane]

Hi Rajeev,

What's transaction parameters? Do you mean assign link tab here?

Share a screenshot to understand your case in a better way.

Regards,

Swaroop