1. Home
  2. Inventory and Item Tracking Software
  3. BACKTRACK
  4. BACKTRACK Error Messages
  5. “Abnormal program termination…This SqlTransaction has completed; it is no longer usable.” – BACKTRACK Error Message

“Abnormal program termination…This SqlTransaction has completed; it is no longer usable.” – BACKTRACK Error Message

Summary

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.

Explanation

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.

Solution

We fixed this problem by restricting the trigger to only execute if the transaction is ‘CHECK IN’ and ITEM_NO is not null.

Additional Comments

Error Found On:  BACKTRACK 2012
Related Articles:
KBA-01053-L6C7Q9 – BACKTRACK With ebiTrack Throws SQL Error During Certain Transactions

Updated on July 19, 2017

Was this article helpful?

Need Support?
Can’t find the answer you’re looking for? Don’t worry we’re here to help!
Contact Support