1104 : FailDBReader On File Checkout

[sross90]

SourceGear Vault Version 5.0.4.18845
SourceGear Valut Client Version 5.0.4 (118845)

SQL Server - Microsoft SQL Server Standard Edition (64-bit)
Running on - Windows 2003, Standard x64 Edition


Problem we can connect and browse the repository but we cannot check out any files. When we do we recieve the error 1104: FailDBReader.

Below is details from the sgvalut.log file. Any help regarding this issue would be much appreciated, thanks.

----8/16/2012 10:50:53 AM X--SSL Disabled SQL transaction 61793871 successfully rolled back.
----8/16/2012 10:50:53 AM X--SSL Disabled CheckOutFiles: Transaction Rolled Back
----8/16/2012 10:50:53 AM X--SSL Disabled CheckOutFiles returned:FailDBReader
----8/16/2012 10:52:30 AM X--SSL Disabled Checking out Files
----8/16/2012 10:52:30 AM X--SSL Disabled ASMX: CheckOutFiles started.
----8/16/2012 10:52:30 AM X--SSL Disabled DB: GetUserRepositoryLastChange started.
----8/16/2012 10:52:30 AM X--SSL Disabled DB: GetUserRepositoryLastChange finished.
----8/16/2012 10:52:30 AM X--SSL Disabled DB: GetLatestRepositoryInfo started.
----8/16/2012 10:52:30 AM X--SSL Disabled DB: GetLatestRepositoryInfo finished.
----8/16/2012 10:52:30 AM X--SSL Disabled TreeManager: cache matches repository revision and folder security hasn't changed. Returning cached tree, revID 126815
----8/16/2012 10:52:30 AM X--SSL Disabled Beginning SQL transaction 8000841
----8/16/2012 10:52:30 AM X--SSL Disabled CheckOutFiles: Transaction Started
----8/16/2012 10:52:30 AM X--SSL Disabled DB: LockCheckoutList started.
----8/16/2012 10:52:30 AM X--SSL Disabled DB: CreateDBLockObject started.
----8/16/2012 10:52:30 AM X--SSL Disabled DB: CreateDBLockObject finished.
----8/16/2012 10:52:30 AM X--SSL Disabled DB: LockCheckoutList finished.
----8/16/2012 10:52:30 AM X--SSL Disabled DB: GetPendingTransactionObjects started.
----8/16/2012 10:52:30 AM X--SSL Disabled System.ArgumentException: Item has already been added. Key in dictionary: '277' Key being added: '277'
at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Specialized.HybridDictionary.Add(Object key, Object value)
at VaultServiceSQL.VaultSqlSCC.GetPendingTransactionObjects(VaultSqlConn conn, Int32 nRepID, Int64 nLastTxID, HybridDictionary& hdObjIDs) at System.Collections.Hashtable.Insert(Object key, Object nvalue, Boolean add)
at System.Collections.Specialized.HybridDictionary.Add(Object key, Object value)
at VaultServiceSQL.VaultSqlSCC.GetPendingTransactionObjects(VaultSqlConn conn, Int32 nRepID, Int64 nLastTxID, HybridDictionary& hdObjIDs)
----8/16/2012 10:52:30 AM X--SSL Disabled DB: GetPendingTransactionObjects finished.
----8/16/2012 10:52:30 AM X--SSL Disabled Rolling Back a transaction at VaultServiceSQL.VaultSqlConn.RollbackTransaction()
at VaultServiceAPILib.VaultServiceAPI.CheckOutFiles(Int32 nRepID, VaultRequestCheckOut[] vrcCheckOuts)
at VaultService.VaultService.CheckOutFiles(Int32 nRepID, VaultRequestCheckOut[]& vrcoCheckouts)
at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
at System.Web.Services.Protocols.WebServiceHandler.Invoke()
at System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
at System.Web.Services.Protocols.SyncSessionlessHandler.ProcessRequest(HttpContext context)
at System.Web.Script.Services.ScriptHandlerFactory.HandlerWrapper.ProcessRequest(HttpContext context)
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
at System.Web.HttpApplication.ApplicationStepManager.ResumeSteps(Exception error)
at System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
at System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
at System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

----8/16/2012 10:52:30 AM X--SSL Disabled SQL transaction 8000841 successfully rolled back.
----8/16/2012 10:52:30 AM X--SSL Disabled CheckOutFiles: Transaction Rolled Back
----8/16/2012 10:52:30 AM X--SSL Disabled CheckOutFiles returned:FailDBReader

[lbauer]

It looks like there may be duplicate items in one of the database tables.

Would you run this query on the sgvault database in SQL Server and let us know the results?

select * from dbo. tblpendingtransactionobjects

Send the results to support at sourcegear.com, Attn: Linda. Please include a link to this forum post. If there are many objects, send the results as an attachment, instead of in the email.