This Error Message Article explains the BACKTRACK error message “Abnormal program termination…This SqlTransaction has completed; it is no longer usable.” and details how to fix the underlying problem that caused it to appear.
This error occurred as result of improper configuration of trigger in the TRANS table in a SQL database. It resulted in the execution of an update statement before the record is created.
The trigger is used to update the RELATION table when a record is inserted into TRANS table. When an item is added, the system creates a RELATION record, TRANS record and ITEM record in this order. The trigger fired off the update routine when the record in ITEM has not yet been created. This results in invalid value for the code to locate a record in RELATION table.
We fixed this problem by restricting the trigger to only execute if the transaction is ‘CHECK IN’ and ITEM_NO is not null.
Error Found On: BACKTRACK 2012
KBA-01053-L6C7Q9 – BACKTRACK With ebiTrack Throws SQL Error During Certain Transactions