on 07-03-2018 8:36 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.