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?