VSS Import Error: FailDBReader at VaultService.VaultAdminSer

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
wooa
Posts: 5
Joined: Wed Oct 04, 2006 9:10 am

VSS Import Error: FailDBReader at VaultService.VaultAdminSer

Post by wooa » Wed Oct 04, 2006 9:33 am

I was trying to do a VSS import from VSS 6.0C to Vault 3.5 (SQL2K5) and I received the following error:

Code: Select all

VaultServiceAPILib.VaultSoapException: 1104 : FailDBReader
   at VaultService.VaultAdminService.AddRepository(String strRepName, Boolean bSecEnabled)

I then tried to manually add a new Repository via the Vault Admin Tool 3.5.1 and i received the same error.

Has anybody run into this before?
Top
lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Wed Oct 04, 2006 12:55 pm

There may be a problem with the connection to the SQL Server database.

Are there any errors in the Vault log file that correspond to these failed operations? The log is sgvault.log and is in %windir%\temp\sgvault on the Vault Server machine.
Linda Bauer
SourceGear
Technical Support Manager
Top
wooa
Posts: 5
Joined: Wed Oct 04, 2006 9:10 am

Post by wooa » Thu Oct 05, 2006 12:52 pm

There are no problems in the log file. I am able to open the Admin tool and do other operations such as create new roles. Therefore, I do not think there is an issue with the connection string. Its just that I cannot add a new Repository via the Admin tool or the VSS Import tool.
Top
jclausius
Posts: 3706
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:
Contact jclausius

Post by jclausius » Thu Oct 05, 2006 1:14 pm

Are you running the Admin Tool on the Vault server itself?
Jeff Clausius
SourceGear
Top
wooa
Posts: 5
Joined: Wed Oct 04, 2006 9:10 am

Post by wooa » Tue Oct 10, 2006 7:55 am

yes i am running the admin tool on the server
Top
lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Tue Oct 10, 2006 8:15 am

Could you reproduce the error, then post or email a copy of your vault server log? It's sgvault.log in %windir%\temp\sgvault.

You can email it to support@sourcegear.com. Put attn: Linda Bauer in the subject. Be sure to provide a link to this forum post in the email.
Linda Bauer
SourceGear
Technical Support Manager
Top
wooa
Posts: 5
Joined: Wed Oct 04, 2006 9:10 am

Post by wooa » Tue Oct 10, 2006 8:35 am

# SourceGear Vault Server
----10/10/2006 10:35:53 AM admin--florida.iad.lmit.local(166.25.61.157)--SSL Disabled Login
----10/10/2006 10:36:00 AM admin--florida.iad.lmit.local(166.25.61.157)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'pk_tbltransactionfsobjectversions'. Cannot insert duplicate key in object 'dbo.tbltransactionfsobjectversions'.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.AddRepository(VaultSqlConn conn, String strRepName, Int32 nUserID, Boolean bSecEnabled, String strMergeableExtensions, String strFolderExclusions, String strFileExclusions) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.AddRepository(VaultSqlConn conn, String strRepName, Int32 nUserID, Boolean bSecEnabled, String strMergeableExtensions, String strFolderExclusions, String strFileExclusions)
----10/10/2006 10:36:00 AM admin--florida.iad.lmit.local(166.25.61.157)--SSL Disabled System.Data.SqlClient.SqlException: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.ExecuteTransaction(String sqlBatch, String method)
at System.Data.SqlClient.SqlTransaction.Commit()
at VaultServiceSQL.VaultSqlConn.CommitTransaction() at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.ExecuteTransaction(String sqlBatch, String method)
at System.Data.SqlClient.SqlTransaction.Commit()
at VaultServiceSQL.VaultSqlConn.CommitTransaction()
----10/10/2006 10:36:00 AM admin--florida.iad.lmit.local(166.25.61.157)--SSL Disabled System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable.
at System.Data.SqlClient.SqlTransaction.Rollback()
at VaultServiceSQL.VaultSqlConn.RollbackTransaction() at System.Data.SqlClient.SqlTransaction.Rollback()
at VaultServiceSQL.VaultSqlConn.RollbackTransaction()
----10/10/2006 10:36:50 AM admin--florida.iad.lmit.local(166.25.61.157)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'pk_tbltransactionfsobjectversions'. Cannot insert duplicate key in object 'dbo.tbltransactionfsobjectversions'.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.AddRepository(VaultSqlConn conn, String strRepName, Int32 nUserID, Boolean bSecEnabled, String strMergeableExtensions, String strFolderExclusions, String strFileExclusions) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at VaultServiceSQL.VaultSqlSCC.AddRepository(VaultSqlConn conn, String strRepName, Int32 nUserID, Boolean bSecEnabled, String strMergeableExtensions, String strFolderExclusions, String strFileExclusions)
----10/10/2006 10:36:50 AM admin--florida.iad.lmit.local(166.25.61.157)--SSL Disabled System.Data.SqlClient.SqlException: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.ExecuteTransaction(String sqlBatch, String method)
at System.Data.SqlClient.SqlTransaction.Commit()
at VaultServiceSQL.VaultSqlConn.CommitTransaction() at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, TdsParserState state)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior run, SqlCommand cmdHandler, SqlDataReader dataStream)
at System.Data.SqlClient.SqlInternalConnection.ExecuteTransaction(String sqlBatch, String method)
at System.Data.SqlClient.SqlConnection.ExecuteTransaction(String sqlBatch, String method)
at System.Data.SqlClient.SqlTransaction.Commit()
at VaultServiceSQL.VaultSqlConn.CommitTransaction()
----10/10/2006 10:36:50 AM admin--florida.iad.lmit.local(166.25.61.157)--SSL Disabled System.InvalidOperationException: This SqlTransaction has completed; it is no longer usable.
at System.Data.SqlClient.SqlTransaction.Rollback()
at VaultServiceSQL.VaultSqlConn.RollbackTransaction() at System.Data.SqlClient.SqlTransaction.Rollback()
at VaultServiceSQL.VaultSqlConn.RollbackTransaction()
Top
lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Tue Oct 10, 2006 10:55 am

The log file indicates there are inconsistencies in the database.

I'll send you an email with instructions on what we need to do next.
Linda Bauer
SourceGear
Technical Support Manager
Top
wooa
Posts: 5
Joined: Wed Oct 04, 2006 9:10 am

Post by wooa » Fri Oct 13, 2006 6:49 am

ok I will be waiting for your email.
Top
lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Post by lbauer » Fri Oct 13, 2006 12:32 pm

I sent you an email with instructions on Oct. 10. It came from our call tracking system, so it would have been from helpspot at sourcegear.com or support at sourcegear.com.

I'll send it again in a few minutes, so be on the lookout for it.
Linda Bauer
SourceGear
Technical Support Manager
Top
Locked

Return to “Gold Support (Vault) -- Read-only”