# Trasaction Group writing success when Stored Procedure Fails

**URL:** <https://forum.inductiveautomation.com/t/trasaction-group-writing-success-when-stored-procedure-fails/25983>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [June 20, 2019, 2:56pm UTC](https://forum.inductiveautomation.com/t/trasaction-group-writing-success-when-stored-procedure-fails/25983 "2019-06-20T14:56:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [June 20, 2019, 2:56pm UTC](https://forum.inductiveautomation.com/t/trasaction-group-writing-success-when-stored-procedure-fails/25983/1 "2019-06-20T14:56:05Z")

</div>

Currently on 8.0.2.

I have several stored procedure transactions, that even though the transaction fails, and the events log shows that it returned an error, the transaction writes the the ‘handshake on success’ tag and not the failure tag. I am fairly certain that this didn’t function this way in 7.9, but its been a while since I’ve used this feature.

Is this expected behavior?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [June 20, 2019, 3:33pm UTC](https://forum.inductiveautomation.com/t/trasaction-group-writing-success-when-stored-procedure-fails/25983/2 "2019-06-20T15:33:01Z")

</div>

Is the group set to ‘Bypass Store and Forward’? This is a common problem with the handshake tags - the transaction group considers it a “successful” write as soon as it passes it to the store and forward system, because S+F has to happen completely asynchronously from the actual group execution. To guarantee the handshakes being accurate, you need to bypass store and forward in the advanced options for the group.

---

<div class="post-metadata">

**Author:** ![grietveld](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/grietveld/32/6984_2.png) [@grietveld](https://forum.inductiveautomation.com/u/grietveld)\
**Post date:** [June 20, 2019, 4:03pm UTC](https://forum.inductiveautomation.com/t/trasaction-group-writing-success-when-stored-procedure-fails/25983/3 "2019-06-20T16:03:31Z")

</div>

Ah, that is the difference between the two projects.

I think I may make some modifications to my stored procedures for the final project to return the value then instead of the ignition handshake, but I can at least get the correct response in the meanwhile.

Thanks!