In the log, i am seeing a logger entry: SQL Bridge.project name.TransactionGroupFolder_TransactionGroupName
the logger entry has the message: Error during group exectution
if I get into the transaction group, it has the following message if I double click on the event in the error tab, but the details tab is greyed out: Error during group execution. com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near ‘’. Incorrect syntax near ‘’.
This transaction group is a core function in our system and works 99.99999999 percent of the time. It is transfering recipe data into a PLC. We use a popup on the screen when the group is triggered and it disappears when the group successfully completes. That is nice because the techs can identify when it ocurrs and notify us. Unfortunately, we are unable to identify any consistency or pattern associated with the ocurrance.
does anyone have any input, experience, or can get me going in the right direction to figure out what intermittently causes this?