Primary Key Errors when adding files to repository

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

Moderator: SourceGear

Post Reply
aogbue
Posts: 9
Joined: Thu Aug 18, 2005 6:00 am
Location: Toronto, ON

Primary Key Errors when adding files to repository

Post by aogbue » Sun Apr 22, 2007 7:32 am

Hello.

I've just upgraded from Vault 3.1.9 to 3.5.0 and then to 3.5.2 and created a new repository, however, I'm unable to add any files or folders to the repository from either the server, or client computer.

Whenever I attempt to add a new file, the GUI client displays an alert, "Could not save the tree," with the following messages:

[22/04/2007 9:06:20 AM] Preparing data to begin transaction
[22/04/2007 9:06:20 AM] Beginning transaction
[22/04/2007 9:06:20 AM] Add $/Default.aspx
[22/04/2007 9:06:21 AM] Ending the transaction
[22/04/2007 9:06:21 AM] An error occurred while trying to end a transaction.
[22/04/2007 9:06:21 AM] Transaction failed
[22/04/2007 9:06:21 AM] Transaction failed

It also shows

I've checked the logs named 070422sgvault.log and sgvault.log, however, both are empty. I've also looked at yesterday's log, which lists a primary key constraint violation as the culprit.

Is there a way to fix this?

Thanks.

Adaora

# SourceGear Vault Server
----2007-04-21 08:10:04 sgvaultsystem--()--
System Started
Version 3.1.9.3798
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain =
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL = http://ADAORA/VaultService
Identity = ADAORA\ASPNET
----2007-04-21 08:10:20 admin--sds-qckads.com(127.0.0.1)--SSL Disabled Login
----2007-04-21 08:12:35 admin--sds-qckads.com(127.0.0.1)--SSL Disabled Login
----2007-04-21 08:13:49 admin--sds-qckads.com(127.0.0.1)--SSL Disabled Logout
----2007-04-21 08:13:54 admin--sds-qckads.com(127.0.0.1)--SSL Disabled Logout
----2007-04-21 08:39:40 sgvaultsystem--()--
System Started
Version 3.5.2.5087
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 102400
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain =
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL =
Identity = ADAORA\ASPNET
----2007-04-21 08:39:48 admin--sds-qckads.com(127.0.0.1)--SSL Disabled Login
----2007-04-21 08:40:14 admin--sds-qckads.com(127.0.0.1)--SSL Disabled Logout
----2007-04-21 08:40:59 admin--sds-qckads.com(127.0.0.1)--SSL Disabled Login
----2007-04-21 08:42:01 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled Login
----2007-04-21 08:42:28 admin--sds-qckads.com(127.0.0.1)--SSL Disabled Logout
----2007-04-21 09:35:49 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled Login
----2007-04-21 09:36:15 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'pk_tbltreerevisionfolders'. Cannot insert duplicate key in object 'dbo.tbltreerevisionfolders'.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml) 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml)
----2007-04-21 09:36:15 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled Could not save folder skeleton: Error in the application.
----2007-04-21 09:36:15 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (b5c815c4-88f9-4710-b726-d4908d0a92ad) EndTx (Revision - 0) returned: FailSaveSourceTree
----2007-04-21 09:36:15 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (b5c815c4-88f9-4710-b726-d4908d0a92ad) AddFile: $/~sakf5ae940101c78419.webproj returned: FailSaveSourceTree
----2007-04-21 09:37:18 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'pk_tbltreerevisionfolders'. Cannot insert duplicate key in object 'dbo.tbltreerevisionfolders'.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml) 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml)
----2007-04-21 09:37:18 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled Could not save folder skeleton: Error in the application.
----2007-04-21 09:37:19 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (d128520a-0512-4fb0-a261-5665326b90a6) EndTx (Revision - 0) returned: FailSaveSourceTree
----2007-04-21 09:37:19 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (d128520a-0512-4fb0-a261-5665326b90a6) AddFile: $/site.master.cs returned: FailSaveSourceTree
----2007-04-21 09:37:19 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (d128520a-0512-4fb0-a261-5665326b90a6) AddFile: $/site.master returned: FailSaveSourceTree
----2007-04-21 09:37:19 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (d128520a-0512-4fb0-a261-5665326b90a6) AddFile: $/Default.aspx.cs returned: FailSaveSourceTree
----2007-04-21 09:37:19 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (d128520a-0512-4fb0-a261-5665326b90a6) AddFile: $/Default.aspx returned: FailSaveSourceTree
----2007-04-21 09:39:00 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'pk_tbltreerevisionfolders'. Cannot insert duplicate key in object 'dbo.tbltreerevisionfolders'.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml) 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml)
----2007-04-21 09:39:00 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled Could not save folder skeleton: Error in the application.
----2007-04-21 09:39:00 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (11bb1b86-23ed-4c7c-a175-58c68fc72fbf) EndTx (Revision - 0) returned: FailSaveSourceTree
----2007-04-21 09:39:00 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (11bb1b86-23ed-4c7c-a175-58c68fc72fbf) AddFile: $/~sak5aeac00101c7841a.tmp returned: FailSaveSourceTree
----2007-04-21 09:40:01 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'pk_tbltreerevisionfolders'. Cannot insert duplicate key in object 'dbo.tbltreerevisionfolders'.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml) 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml)
----2007-04-21 09:40:01 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled Could not save folder skeleton: Error in the application.
----2007-04-21 09:40:01 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (4931b50e-5c28-418e-9160-ed9950524839) EndTx (Revision - 0) returned: FailSaveSourceTree
----2007-04-21 09:40:01 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (4931b50e-5c28-418e-9160-ed9950524839) AddFile: $/site.master.cs returned: FailSaveSourceTree
----2007-04-21 09:40:01 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (4931b50e-5c28-418e-9160-ed9950524839) AddFile: $/site.master returned: FailSaveSourceTree
----2007-04-21 09:40:01 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (4931b50e-5c28-418e-9160-ed9950524839) AddFile: $/Default.aspx.cs returned: FailSaveSourceTree
----2007-04-21 09:40:01 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (4931b50e-5c28-418e-9160-ed9950524839) AddFile: $/Default.aspx returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'pk_tbltreerevisionfolders'. Cannot insert duplicate key in object 'dbo.tbltreerevisionfolders'.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml) 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml)
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled Could not save folder skeleton: Error in the application.
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) EndTx (Revision - 0) returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFolder: $/mcts70-528 returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFolder: $/mcts70-528/App_Data returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/Default.aspx returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/Default.aspx.cs returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFolder: $/mcts70-528/images returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFolder: $/mcts70-528/images/gifs returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/images/gifs/banner_bg.gif returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/images/gifs/leftnav_bg.gif returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/images/gifs/logo.gif returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/images/gifs/topnav_bg.gif returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFolder: $/mcts70-528/images/working returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/images/working/template.psd returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFolder: $/mcts70-528/includes returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFolder: $/mcts70-528/includes/css returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/includes/css/style.css returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFolder: $/mcts70-528/labs returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFolder: $/mcts70-528/labs/ch1 returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/labs/ch1/Default.aspx returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/labs/ch1/Default.aspx.cs returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFolder: $/mcts70-528/labs/ch2 returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/labs/ch2/Default.aspx returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/labs/ch2/Default.aspx.cs returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/site.master returned: FailSaveSourceTree
----2007-04-21 09:40:53 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled (34cb17c7-baf5-4430-9731-d60ab9f87748) AddFile: $/mcts70-528/site.master.cs returned: FailSaveSourceTree
----2007-04-21 09:43:46 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled Logout
----2007-04-21 09:43:47 ngozi--ADAORA-PJAIVVPJ(192.168.62.51)--SSL Disabled Logout
Top
Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:
Contact Beth

Post by Beth » Mon Apr 23, 2007 10:32 am

I believe we are going to need to dig further here offline. Could you send an email to support at sourcegear.com (Attn: Beth) and include a link to this forum post so I know which one you are?
Top
dovetail
Posts: 6
Joined: Fri May 11, 2007 9:44 am

Post by dovetail » Fri May 11, 2007 10:08 am

hi guys,

did you find a resolution to this issue? i've got exactly the same problem.

thanks.
Top
Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:
Contact Beth

Post by Beth » Fri May 11, 2007 3:51 pm

Yes. bit it's a bit involved. Send an email to support at sourcegear.com with the errors.
Top
dovetail
Posts: 6
Joined: Fri May 11, 2007 9:44 am

Post by dovetail » Thu May 17, 2007 3:19 pm

ok, thanks beth.
Top
Beth
Posts: 8550
Joined: Wed Jun 21, 2006 8:24 pm
Location: SourceGear
Contact:
Contact Beth

Post by Beth » Fri May 18, 2007 8:50 am

For any others who come across this thread after upgrading to Vault 3.5.2, look for this error in your Vault Server Log:
Violation of PRIMARY KEY constraint 'pk_tbltreerevisionfolders'. Cannot insert duplicate key in object 'dbo.tbltreerevisionfolders'.
If you have that, run the following check and report the results of the check (just how many rows returned in each one) and the repid involved. You will send that to support at sourcegear.com.

First, to get the repository IDs, run the following in Query Analyzer on your SQL server:

Code: Select all

SELECT repid, name FROM sgvault.dbo.tblrepositories
Then run each of the following individually, replacing '(id)' with one of the repository IDs from the previous query.

Code: Select all

select * from sgvault.dbo.tblcurrenttreerevisionfolders where repid = (id)

Code: Select all

SELECT * FROM sgvault.dbo.tblrepositories r WHERE r.repid = (id)

Code: Select all

select * from sgvault.dbo.tbltreerevisionfolders x inner join sgvault.dbo.tblrepositories r on r.currenttxid = x.txid where r.repid = (id)
Last edited by Beth on Tue Jul 10, 2007 9:40 am, edited 1 time in total.
Top
dovetail
Posts: 6
Joined: Fri May 11, 2007 9:44 am

Post by dovetail » Mon May 21, 2007 5:28 am

just FYI it's not a problem at the moment (don't need a new repository now) so i wont do this unless we need to. thanks though.
Top
jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:
Contact jkp*74

Post by jkp*74 » Wed Jan 09, 2008 1:58 am

I faced the same problem. This is the new repository created after upgrade to Vault 4.0.6

admin--SDD-JOEL(192.0.0.88)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'pk_tbltreerevisionfolders'. Cannot insert duplicate key in object 'tbltreerevisionfolders'.
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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml) 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.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.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at VaultServiceSQL.VaultSqlSCC.SaveCurrentTreeFolders(VaultSqlConn conn, Int32 nRepID, Int64 nTxID, Int64 nLastTxID, Boolean bSaveAsDelta, String strXml)
----1/9/2008 3:33:19 PM admin--SDD-JOEL(192.0.0.88)--SSL Disabled Could not save folder skeleton: Error in the application.
----1/9/2008 3:33:19 PM admin--SDD-JOEL(192.0.0.88)--SSL Disabled (b058ae70-00c1-489e-b7b7-86973043d03b) EndTx (Revision - 0) returned: FailSaveSourceTree
----1/9/2008 3:33:19 PM admin--SDD-JOEL(192.0.0.88)--SSL Disabled (b058ae70-00c1-489e-b7b7-86973043d03b) AddFolder: $/Test Project returned: FailSaveSourceTree

I will post you the screen shot of query result off line. The problematic repid is 20
Joel
Micro Modular System
http://www.mmsis.com
Top
jkp*74
Posts: 147
Joined: Wed Dec 15, 2004 9:42 pm
Contact:
Contact jkp*74

Post by jkp*74 » Wed Jan 09, 2008 3:03 am

Deleted the problematic repository & creat a new one with the same name. The problem disappeared. Create another repository for testing - also no problem.
Joel
Micro Modular System
http://www.mmsis.com
Top
Post Reply

Return to “Support (Vault)”