# Lack of useful information in logs on Transaction Group Error **URL:** \ **Category:** Ignition\ **Tags:** ignition81\ **Created:** [March 15, 2023, 5:23pm UTC](https://forum.inductiveautomation.com/t/lack-of-useful-information-in-logs-on-transaction-group-error/71108 "2023-03-15T17:23:26Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Cecil\_Rhoades](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Cecil\_Rhoades](https://forum.inductiveautomation.com/u/Cecil_Rhoades)\ **Post date:** [March 15, 2023, 5:23pm UTC](https://forum.inductiveautomation.com/t/lack-of-useful-information-in-logs-on-transaction-group-error/71108/1 "2023-03-15T17:23:27Z")
I set up a "Transaction Group" with two in and one out parameters, pointing to a simple stored procedure. It works. I then tried to use an existing Oracle Procedure we are currenly using with Rockwells Transaction Manager (RSSQL) with a larger number of in parameters and one out parameter. It fails. The logical place to go for troublshooting is the logs. I find them to be useless, but I thought I would post here, to see what I am missing. I turned on trace level loging for my project, for the PLC, the database and the transaction group. The only thing the log tells me is "Error during group execution." This is useless. There are no hints at all on where to begin to look, i.e. db communications, data type mis-matches, OPC errors, etc.. I would never, ever put something like this into a production environment. FW\_Sta33\_exit\_test 15Mar2023 12:51:31 Error during group execution. FW\_Sta33\_exit\_test 15Mar2023 12:51:31 Executing post-trigger evaluation. FW\_Sta33\_exit\_test 15Mar2023 12:51:31 Trigger is active. FW\_Sta33\_exit\_test 15Mar2023 12:51:31 Trigger evaluated. Value: [true, Good, Wed Mar 15 12:51:30 EDT 2023 (1678899090225)], Active evaluation: true, Return value: true, First exec cancellation: false FW\_Sta33\_exit\_test 15Mar2023 12:51:31 Reading item '[**GROUP**]Exit\_Trigger', group tag=true, abiguous=false FW\_Sta33\_exit\_test 15Mar2023 12:51:31 Trigger latched value: [true, Good, Wed Mar 15 12:51:30 EDT 2023 (1678899090225)] Am I missing something here? ---
**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Post date:** [March 15, 2023, 5:36pm UTC](https://forum.inductiveautomation.com/t/lack-of-useful-information-in-logs-on-transaction-group-error/71108/2 "2023-03-15T17:36:38Z")
I agree 100% You CAN get a more detailed error if you go to the transaction group, go to the Events Tab at the bottom and double click on the error row. But there should be much more detailed logging of the groups. ---
**Author:** ![Cecil\_Rhoades](https://avatars.discourse-cdn.com/v4/letter/c/e79b87/32.png) [@Cecil\_Rhoades](https://forum.inductiveautomation.com/u/Cecil_Rhoades)\ **Post date:** [March 15, 2023, 8:21pm UTC](https://forum.inductiveautomation.com/t/lack-of-useful-information-in-logs-on-transaction-group-error/71108/3 "2023-03-15T20:21:28Z")
Thanks. That is helpful. I can move forward, but I still don't think I will use Transaction Groups in a production environment. I wrote some script to execute transactions against the OPC layer, subscribing to only the trigger tag, and that seems to work well. I can write logging code inside my script. While it is early in the project, I am leaning that direction. Each minute of down time while researching why transactions are not working is very expensive. Therefor good logs are as imperative as good network communications. ---
**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\ **Post date:** [March 15, 2023, 8:25pm UTC](https://forum.inductiveautomation.com/t/lack-of-useful-information-in-logs-on-transaction-group-error/71108/4 "2023-03-15T20:25:23Z")
IMO, transaction groups are intended for those who cannot script (at all, or well), and therefore provides a nice drag and drop interface for those starting out. There are several threads on the forum that highlight the benefits of scripts over TG's. If you can script, then script, you are in total control and it saves buying the module. ---
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [March 15, 2023, 8:41pm UTC](https://forum.inductiveautomation.com/t/lack-of-useful-information-in-logs-on-transaction-group-error/71108/5 "2023-03-15T20:41:48Z")
+1 for no to transaction groups, yes to scripting