Cannot rename a top-level folder

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
mdford
Posts: 5
Joined: Thu Aug 21, 2014 6:58 am

Cannot rename a top-level folder

Post by mdford » Wed Jun 17, 2015 3:29 pm

I'm getting an exception thrown when trying to rename a top-level folder:

Code: Select all

----6/17/2015 5:12:22 PM     <redacted>--SSL Disabled	(e568e855-2509-4d1d-8be8-a12a9ced6086) EndTx (Revision - 0) returned: FailDBReader 
----6/17/2015 5:12:22 PM     <redacted>--SSL Disabled		(e568e855-2509-4d1d-8be8-a12a9ced6086) Rename: $/ODMS to ODMS10 returned: FailDBReader 
----6/17/2015 5:12:46 PM     <redacted>--SSL Disabled	System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'PK__#664B26C__956BCC4768336F3E'. Cannot insert duplicate key in object 'dbo.@tblfsobjectshares'. The duplicate key value is (18176, 44649, 0xdb2e031bfc654b62b266aaedf34a1df8, 1659).
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at VaultServiceSQL.VaultSqlSCC.GetItemsForPathChange(VaultSqlConn conn, Int32 nRepID, Int64 nObjID, Int64 nOwnerFolderObjID, String strXml, String strXmlShares, VaultCloakedFolder[]& vcf, VaultFolderRightsItem[]& vfri, VaultShareHint[]& vsh)
ClientConnectionId:a6c60725-941a-4ee7-9372-b246b763f030
Error Number:2627,State:2,Class:14    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at VaultServiceSQL.VaultSqlSCC.GetItemsForPathChange(VaultSqlConn conn, Int32 nRepID, Int64 nObjID, Int64 nOwnerFolderObjID, String strXml, String strXmlShares, VaultCloakedFolder[]& vcf, VaultFolderRightsItem[]& vfri, VaultShareHint[]& vsh)
----6/17/2015 5:12:46 PM    <redacted>--SSL Disabled	Rolling Back a transaction   at VaultServiceSQL.VaultSqlConn.RollbackTransaction()
   at VaultServiceAPILib.VaultServiceAPI.EndTx(Int32 nTxUserID, String strTxID, Int32 nTxAction, VaultIntTx vit, VaultDateTime& dtTxBegin, Int64& nNewRevision, VaultResponseItem[]& responses, VaultRepository& repNew)
   at VaultService.VaultService.EndTx(String strTxID, Int32 nTxAction, VaultDateTime& dtTxBegin, Int64& nNewRevision, VaultResponseItem[]& responses)
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   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.PipelineStepManager.ResumeSteps(Exception error)
   at System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
   at System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
   at System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   at System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
 
----6/17/2015 5:12:46 PM    <redacted>--SSL Disabled	(dcf358e5-94b2-4827-9925-d4ce8074bf43) EndTx (Revision - 0) returned: FailDBReader 
----6/17/2015 5:12:46 PM    <redacted>--SSL Disabled		(dcf358e5-94b2-4827-9925-d4ce8074bf43) Rename: $/ODMS to ODMS10 returned: FailDBReader
Top
Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:
Contact Beth

Re: Cannot rename a top-level folder

Post by Beth » Wed Jun 17, 2015 3:34 pm

Which version of Vault are you on?

Is there any sharing in the database? If so, is there sharing between locations both underneath the area you are renaming?

In your Vault GUI client, while logged in to a repository, can you go to Help - Technical Support and copy the information from there in your response?
Beth Kieler
SourceGear Technical Support
Top
mdford
Posts: 5
Joined: Thu Aug 21, 2014 6:58 am

Re: Cannot rename a top-level folder

Post by mdford » Wed Jun 17, 2015 3:36 pm

Requested info:

Code: Select all

Client Information
    Vault Standard Client Version: 8.0.1.299
    .NET Framework Version: 4.0.30319.18444
    Operating System: Microsoft Windows 7 Enterprise 
    Service Pack: 1.0
    OS Version: 6.1.7601
    Total Physical Memory: 19.93 GB
    Time Zone: (UTC-06:00) Central Time (US & Canada)
    
Server Information
     Server Version: 8.0.1.299
    .NET Framework Version: 4.0.30319.34209
    Operating System: Microsoft Windows Server 2008 R2 Enterprise 
    Service Pack: 1.0
    OS Version: 6.1.7601
    Timezone: (UTC-05:00) Eastern Time (US & Canada)
    SQL Version: Microsoft SQL Server 2008 R2 (SP3) - 10.50.6000.34 (X64) 
            
            
            
    
License Information
    1 serial number(s):
        1 of 1: 20 full users, permanent

We have sharing of both folders and files that are 3 and 4 levels below the folder being renamed.
Top
mdford
Posts: 5
Joined: Thu Aug 21, 2014 6:58 am

Re: Cannot rename a top-level folder

Post by mdford » Wed Jun 17, 2015 3:42 pm

The folders that are being shared are within the same main tree, but I did notice that a few of the files that are shared are shared outside of the folder being renamed. Is this the problem?
Top
Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:
Contact Beth

Re: Cannot rename a top-level folder

Post by Beth » Wed Jun 17, 2015 4:13 pm

I ran some tests to make sure there wasn't a bug introduced, and they all succeeded.

I think we'll need to take a closer look. Could you send an email to support at sourcegear.com (attn: Beth) with a link to this forum thread?
Beth Kieler
SourceGear Technical Support
Top
Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:
Contact Beth

Re: Cannot rename a top-level folder

Post by Beth » Thu Jun 18, 2015 10:46 am

I have received you email and respond directly.

HS: 235290
Beth Kieler
SourceGear Technical Support
Top
Post Reply

Return to “Support (Vault)”