Transaction Data?

Unknown

Transaction Data?

Unknown

Hi All,

Im seeing this tick value for "Use Transaction Data" on one of my query steps. What exactly does this do?

[img]att1[/img]

Unknown

jmcmann49,

[color=rgb(229, 226, 220)][font=Arial, Helvetica, sans-serif]The Use Transaction Data allows you to utilize the Transaction steps (found in Integration > Database > "your connection here"). What these transaction steps do is allow you to link a "Transaction" to the step. Transactions act as a sort of fail safe in the sense that, if the task fails, youll have the task "Rollback" vs just remaining stagnant. [/font][/color]
[color=rgb(229, 226, 220)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(229, 226, 220)][font=Arial, Helvetica, sans-serif][img]https://mail.google.com/mail/u/0?ui=2&ik=9a04c01e97&attid=0.1&permmsgid=msg-a:r7187643604941908308&th=16d4f270c237cd3c&view=fimg&sz=s0-l75-ft&attbid=ANGjdJ9PbBwpjBmpE5Kg_3t6DTRnKfM6xm8BLJZB82rkoK17x2I7zFmGCFD6-pXylwcKpWvAh6HqLt4EhiRpf-tAxNuTjng9sHXLXBvqgdFDgGcIV2OnJk7nv-H1Ba0&disp=emb&realattid=ii_k0s8pg0p1[/img]
[/font][/color]
[color=rgb(229, 226, 220)][font=Arial, Helvetica, sans-serif]
[/font][/color]
The whole process is started by a Start Transaction step which allows you to setup how unresolved transactions are handled, its isolation level (details of the different levels available here on our documentation site: https://documentation.decisions.com/docs/using-transaction-steps), and the Transaction Name.
[color=rgb(229, 226, 220)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(229, 226, 220)][font=Arial, Helvetica, sans-serif]This will output Transaction Data which you will be able to reference when you tick the "Use Transaction Data" box on your database query step. In regards to this stopping table deadlocks, it can be capable if one of these database query steps is the cause of it, youll be able to rollback vs just having the process come to a hard stop. [/font][/color]
[color=rgb(229, 226, 220)][font=Arial, Helvetica, sans-serif]
[/font][/color]
[color=rgb(229, 226, 220)][font=Arial, Helvetica, sans-serif]We do have a more detailed walkthrough of the transaction steps in our documentation site:[/font][/color]
[color=rgb(229, 226, 220)][font=Arial, Helvetica, sans-serif]
[/font][/color]
https://documentation.decisions.com/docs/using-transaction-steps