# Is there detail available for why a stored procedure Transaction Group failed?

**URL:** <https://forum.inductiveautomation.com/t/is-there-detail-available-for-why-a-stored-procedure-transaction-group-failed/100095>\
**Category:** Ignition\
**Created:** [December 20, 2024, 1:10pm UTC](https://forum.inductiveautomation.com/t/is-there-detail-available-for-why-a-stored-procedure-transaction-group-failed/100095 "2024-12-20T13:10:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert\_Reed](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@Robert\_Reed](https://forum.inductiveautomation.com/u/Robert_Reed)\
**Post date:** [December 20, 2024, 1:10pm UTC](https://forum.inductiveautomation.com/t/is-there-detail-available-for-why-a-stored-procedure-transaction-group-failed/100095/1 "2024-12-20T13:10:06Z")

</div>

I am calling a Stored procedure via a transaction group and getting a handshake failure. Is there a way to see the error data resulting from the sql call?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 20, 2024, 1:36pm UTC](https://forum.inductiveautomation.com/t/is-there-detail-available-for-why-a-stored-procedure-transaction-group-failed/100095/2 "2024-12-20T13:36:46Z")

</div>

No, but a summary shows in the designer IIRC. You can also log from the database side.

---

<div class="post-metadata">

**Author:** ![Robert\_Reed](https://avatars.discourse-cdn.com/v4/letter/r/43a26b/32.png) [@Robert\_Reed](https://forum.inductiveautomation.com/u/Robert_Reed)\
**Post date:** [December 20, 2024, 1:53pm UTC](https://forum.inductiveautomation.com/t/is-there-detail-available-for-why-a-stored-procedure-transaction-group-failed/100095/3 "2024-12-20T13:53:03Z")

</div>

What is/How do I use the IIRC?  
Thanks

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 20, 2024, 1:56pm UTC](https://forum.inductiveautomation.com/t/is-there-detail-available-for-why-a-stored-procedure-transaction-group-failed/100095/4 "2024-12-20T13:56:07Z")

</div>

IIRC =\> "If I Recall Correctly"