Problem with Branching

awiedenhoff · Post by **awiedenhoff** » Wed Oct 24, 2007 1:35 pm

I'm attempting to create a branch of one of our projects from within the vault client and running into an error. I am able to create branches of other projects, so this error appears to be project specific.
I have created branches of this "problem" project in the past, but all would have occurred before our recent upgrade.

Any help is greatly appreciated!!

Thanks,
Alethea

--------------------------------------------------------------------------------
Here are the details:

Vault Version: 4.0.4.15848 (recently upgraded)

Error Message in Vault Client:
[10/24/2007 2:23:05 PM] An error occurred while trying to end a transaction.
[10/24/2007 2:23:05 PM] Transaction failed
[10/24/2007 2:23:05 PM] Item $/Von Hoffmann/Pick & Pack/Source Code - ASP.NET 2.0/PickAndPackSolution caused the transaction to fail: A database error has occured (FailDBReader)
[10/24/2007 2:23:05 PM] Transaction failed

Entry in Log File:
----10/24/2007 2:23:04 PM awiedenhoff--awiedenhoffxp.mir.local(10.10.40.25)--SSL Disabled System.Data.SqlClient.SqlException: The error description is 'Whitespace is not allowed at this location.'.
Could not find prepared statement with handle 0.
sp_xml_removedocument: The value supplied for parameter number 1 is invalid.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
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.BranchFolder(VaultSqlConn conn, String strSessionID, Int32 nRepID, Hashtable htSharedItems, HybridDictionary htTxModifiedItems, Int64 nTxID, Int32 nTxItem, Byte nTxType, VaultDateTime vdTxBegin, String strItemPath, String strNewBranchName, String strXml, BranchingModTime bmt, VaultFolder vfRoot, String strTxComment, Int32& nCopiedSecurityFolderRights, VaultFolder& vfOut) at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
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.BranchFolder(VaultSqlConn conn, String strSessionID, Int32 nRepID, Hashtable htSharedItems, HybridDictionary htTxModifiedItems, Int64 nTxID, Int32 nTxItem, Byte nTxType, VaultDateTime vdTxBegin, String strItemPath, String strNewBranchName, String strXml, BranchingModTime bmt, VaultFolder vfRoot, String strTxComment, Int32& nCopiedSecurityFolderRights, VaultFolder& vfOut)
----10/24/2007 2:23:05 PM awiedenhoff--awiedenhoffxp.mir.local(10.10.40.25)--SSL Disabled (c93c785a-2bb9-475d-9a89-9fccd4201c29) EndTx (Revision - 0) returned: FailDBReader
----10/24/2007 2:23:05 PM awiedenhoff--awiedenhoffxp.mir.local(10.10.40.25)--SSL Disabled (c93c785a-2bb9-475d-9a89-9fccd4201c29) CopyBranch: $/Von Hoffmann/Pick & Pack/Source Code - ASP.NET 2.0/PickAndPackSolution to $/Von Hoffmann/Pick & Pack/Source Code - ASP.NET 2.0/PickAndPackSolution-2007.09.25 returned: FailDBReader

Beth · Post by **Beth** » Wed Oct 24, 2007 3:14 pm

Are any of the paths you are using different than they were when you were branching before?

awiedenhoff · Post by **awiedenhoff** » Wed Oct 24, 2007 3:19 pm

The respository structure above the point I'm trying to branch at has not changed since the first branch was created approximately a year ago.
The structure below that point has changed as the application has evolved/grown.

Is there something I should look for within the project tree that could be causing this problem?

Beth · Post by **Beth** » Wed Oct 24, 2007 3:24 pm

Is there any chance you have leading or trailing spaces in a file or folder name? Or in the structure below that has grown, are there any special characters that weren't present before?