More Recent problems

[kthompson]

Hello,

I am experiencing a rather strange problem using 3.0.5. We have been running very smoothly with vault up until about 3 weeks ago. One of our developers made some minor changes to 2 files in the same folder and checked in her changes. In the vault client now these files show up with a duplicate. One of the files is marked as More Recent were as the other version of the file is up to date. When you click on one of the files it automatically highlights both of them. As far as I can tell these are the only two files with the problem.

The message window doesnt show us any information unless you try to delete one of the copies, at which point it gives the following error:

[6/10/2005 9:49:18 AM] Server unavailable for transaction end
[6/10/2005 9:49:18 AM] An exception was encountered during the transaction. Exception: Exception of type System.Exception was thrown. at VaultClientOperationsLib.ClientInstance.Commit(ChangeSetItemColl givenItems, Boolean keepCheckedOut, Boolean removeLocalCopy, Boolean bIsImport, DateTime dateImport, Int32 nUserIDImport, Int64& nRevID)
[6/10/2005 9:49:18 AM] Transaction failed
[6/10/2005 9:49:18 AM] Transaction failed


Any help would be greatly appreciated.

Thanks
Keith Thompson

[jclausius]

Keith:

Let's take a look at things from the database end. Can you run the following:

1) SELECT repid, name, currenttxid FROM sgvault.dbo.tblrepositories

2) SELECT x.repid, x.txid FROM sgvault.dbo.tblfulltreerevisionfolders x WHERE EXISTS ( SELECT y.repid FROM sgvault.dbo.tblrepositories y WHERE y.repid = x.repid AND y.currenttxid = x.txid )

Send this by email if you would like to keep the information private.