fk_tbltransactiondetails_itemobjverid_tblfsobjectversions

[Hans Olav Nymand]

Hi,


I have this problem in the log of our Vault server:

----18-08-2011 14:02:43 Hans_Olav_Nymand--hon-1306.pdc.xx(10.117.66.102)--SSL Disabled System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_tbltransactiondetails_itemobjverid_tblfsobjectversions". The conflict occurred in database "sgVault", table "dbo.tblfsobjectversions", column 'objverid'.

What does it mean and what can I do to fix the problem ?


Best regards,
Hans Olav Nymand

[Hans Olav Nymand]

Sorry, forgot the version: Client and Server is 5.1.1.19215

/Hans Olav

[Beth]

Do you know what action a user was trying to perform when that error came up?

Can you reproduce the error?

[Hans Olav Nymand]

I can describe what happened.

I moved two folders to another location - same new parent folder for both. When I tried to move a 3rd folder to that same destination it failed.

This generated the following sequence of errors in the log - some are from repeatedly trying the same move before I realized that the problem was permanent. These are just the "highlights" from the log...

----18-08-2011 13:55:29 System.Data.SqlClient.SqlException: Transaction (Process ID 113) was deadlocked on thread | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
----18-08-2011 13:55:38 System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_tbltransactiondetails_itemobjverid_tblfsobjectversions". The conflict occurred in database "sgVault", table "dbo.tblfsobjectversions", column 'objverid'.
The statement has been terminated.
----18-08-2011 13:56:15 System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_tbltransactiondetails_itemobjverid_tblfsobjectversions". The conflict occurred in database "sgVault", table "dbo.tblfsobjectversions", column 'objverid'.
The statement has been terminated.
----18-08-2011 13:56:29 Failed to bubble folder name: $ ID:31065 version: 32702 objverid: 6192665
----18-08-2011 13:56:57 Failed to bubble folder name: $ ID:31065 version: 32702 objverid: 6192665
----18-08-2011 14:02:43 System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "fk_tbltransactiondetails_itemobjverid_tblfsobjectversions". The conflict occurred in database "sgVault", table "dbo.tblfsobjectversions", column 'objverid'.
The statement has been terminated.

I just tried again creating a new folder in the parent directory (rather than moving a folder to that place)

This gives the following error:
----18-08-2011 18:20:47 Failed to bubble folder name: $ ID:31065 version: 32702 objverid: 6192665

In short it seems that both the "Failed to bubble folder name" and "INSERT statement conflicted with the FOREIGN KEY" are reproduceable, but maybe not consistently.

The error "Transaction was deadlocked" I cannot recreate in the log.


Regards,
Hans Olav

[Beth]

It looks like there could be some inconsistent data in one of the caches. Here's what you do:

• 1) Try an iisreset on the Vault server.
  2) An iisreset will disconnect all your users from Vault, so you may need to forewarn them.
  3) Go to Start - Run and type iisreset. Just stopping and starting IIS does not do the same thing as iisreset, so please use the command.

Then try to move an item. Make sure you commit the item as well. Did that work?

If you still can't move an item, then try these next set of steps:

• 1) Close all instances of Vault and Visual Studio.
  2) Rename your Vault client-side cache. Instructions can be found here: http://support.sourcegear.com/viewtopic ... 13&t=11513.
  3) Perform an iisreset on the Vault server in the same manner as you had before.
  4) Now open your Vault GUI client. It will take a minute for it to rebuild its cache. You will need to reset your working folders.

Then try to move an item. Make sure you commit the item as well. Did that work?

[Hans Olav Nymand]

Yes, the first part did the trick. Thank you.

[Beth]

Thank you for the update.