Identifiy source of 7076 error transaction

[former_member604454]

So after a server crash, on a specific record, I get the error message: "The primary key found in TWOrder:FILENO is currently involved in a transaction by another user. Update cannot be performed." This actually occurs on an insert in another table that has an RI rule to FileNo. sp_mgGetAllLocks does not show a lock on that file.

Is there a way to identify who has this transaction open, or it is actually a lie because of the server crash and can I fix it somehow?

Version 11.1

[michael_loop]

Look in the Advantage Configuration Utility under Configuration Utility > File Locations and nte the Transaction Log Files Path. Check that directory for files with the extension .TPS. Any such files predating the last server restart should be deleted. I would suggest shutting down the service first and then deleting any TPS files that remain.

[former_member604454]

Wish I had seen this in time, but we just had another one of these and this was great. Thank you.