FailDBFault Error

[Sridhar_TR]

We have Vault 3.0.1. Couple of weeks ago I switched on folder level access control for groups. It started slowing down VSS Import and other normal operations. So, I switched it off.

We started getting an error "$/<file> caused the transaction to fail: You must merge your working copy with the newest version before Check In can succeed." when we try to check in a specific file. When tried to view the history we got the error as

A database error has occured (FailDBFault)

The log file has the following information when trying to check-in followed by a view history.

----4/13/2005 1:59:03 AM Sridhar--SRIDHAR2(10.43.64.109)--SSL Disabled Login
----4/13/2005 1:59:58 AM Sridhar--SRIDHAR2(10.43.64.109)--SSL Disabled BeginTx returned: FailOutofDateObjVerID
----4/13/2005 1:59:58 AM Sridhar--SRIDHAR2(10.43.64.109)--SSL Disabled VaultLib.VaultRequestCheckIn returned: FailOutofDateObjVerID
----4/13/2005 2:00:18 AM Sridhar--SRIDHAR2(10.43.64.109)--SSL Disabled Cannot insert the value NULL into column 'objprops', table 'tempdb.dbo.#tmpresults_________________________________________________________________________________________________________00010000001F'; column does not allow nulls. INSERT fails.
----4/13/2005 2:00:18 AM Sridhar--SRIDHAR2(10.43.64.109)--SSL Disabled BeginHistoryQuery returned: FailDBFault

The same error shows up for all users of the system. So, it didn't seem like a client side problem. Hoping that upgrade to 3.0.6 would fix the problem, I backed up the DB and upgraded to 3.0.6. Still the problem continues.[/quote]

[jclausius]

I responded to your post in the other forum. Let's continue the thread here.

I'm looking for only the server log entries related to the history problem. Can you re-run the history query, and then provide the tail end of the server's log file?

Thanks

[Sridhar_TR]

For Transaction

----4/13/2005 12:00:20 PM Sridhar--SRIDHAR2(10.43.64.127)--SSL Disabled Login
----4/13/2005 12:02:41 PM Sridhar--SRIDHAR2(10.43.64.127)--SSL Disabled BeginTx returned: FailOutofDateObjVerID
----4/13/2005 12:02:41 PM Sridhar--SRIDHAR2(10.43.64.127)--SSL Disabled VaultLib.VaultRequestCheckIn returned: FailOutofDateObjVerID

For History

----4/13/2005 12:04:10 PM Sridhar--SRIDHAR2(10.43.64.127)--SSL Disabled Cannot insert the value NULL into column 'objprops', table 'tempdb.dbo.#tmpresults_________________________________________________________________________________________________________00010000006B'; column does not allow nulls. INSERT fails.
----4/13/2005 12:04:10 PM Sridhar--SRIDHAR2(10.43.64.127)--SSL Disabled BeginHistoryQuery returned: FailDBFault

[jclausius]

Its almost as if the object does not really exist ( just showing up because it is cached somehow ).

If you try to view properties on the file, does that succeed? If you try to delete / undelete the file do those operations succeed? Note you should probably make another backup of the database before attempting the delete / undelete.

[Sridhar_TR]

jclausius,

For properties, I get the following message:

Data is Null. This method or property cannot be called on Null values.

I could delete it. It is going to take my week end to restore as I can't disturb the other users now. For now, I can live with the single version I checked in now. Will try to restore if it is worth it and give more details to you.

Thank you.

[jclausius]

Just for clarification delete / undelete refers to the file which should only take a second or two. However, if there is a problem, and you cannot undelete the file, a database restoration may be necessary.

However, I don't believe the file is actually there, but cached only on the client.

If you shut down all Vault clients, delete any client side caching for the tree (CacheMember_LastStructureGetTime & CacheMember_Repository) from the Vault client cache ( See http://support.sourcegear.com/viewtopic.php?t=6 for more information ), and then restart the Vault client, is the file still in the tree?

[Sridhar_TR]

I could delete, but undelete option was not available. So, I will have to restore from the backup. Since restore and any other activity in resolving this issue is going to affect other users, after the delete operation, I chose to check in the most recent version I had.

The file did exist and had 61 versions before I deleted it after you suggested. It is also not possible that the cache has old data as it happened even after clearing the cache. On a machine that didn't have any file got from Vault, the problem did show up.

For now, I'm fine with the current setup. We will revisit this if the problem shows up for any other file in Vault repository.

[jclausius]

I could delete, but undelete option was not available.

Invoke the properties on the parent folder. In the undelete tab, you should see the file. Is it there? If so, highlight it and then click "Undelete".

Of course, you should rename/remove any "newly" added files with the same name to avoid a name conflict within the folder.

[Sridhar_TR]

The deleted file is not listed in the undelete tab. Also, the file doesn't show up in the Obliterate tab of Vault Admin.

[jclausius]

OK. Let us know if there is anything else you want to pursue down this line.