cant add a group to repository access (v4.0.1)

MapData · Post by **MapData** » Sun Jun 24, 2007 10:22 pm

We have 4 groups (Plus admin group) in vault.
When I try to add groups to reposity access they all add with the specified rights except one of them. From the web admin after clicking assign it just refreshes the page looking like it does nothing. The following is what appears in the vault log:

----25/06/2007 2:15:15 PM admin--mapdata18.mydomain.com.au(192.168.10.28)--SSL Disabled System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'pk_tbluserrepositories'. Cannot insert duplicate key in object 'dbo.tblrepositoryaccess'.
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.VaultAdminSQL.AddRepositoryAccess(VaultSqlConn conn, Int32 nRepID, Int32 nUserIDorGroupID, Boolean isGroup, VaultRepositoryAccess accessLevel) 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.VaultAdminSQL.AddRepositoryAccess(VaultSqlConn conn, Int32 nRepID, Int32 nUserIDorGroupID, Boolean isGroup, VaultRepositoryAccess accessLevel)
----25/06/2007 2:15:15 PM admin--mapdata18.mydomain.com.au(192.168.10.28)--SSL Disabled System.Exception: An error occurred adding Repository Access: A database error has occured (FailDBInsert)
at VaultWebLib.RepositoryAccessForGroupData.Insert(Int32 gid, VaultRepositoryAccess access) at VaultWebLib.RepositoryAccessForGroupData.Insert(Int32 gid, VaultRepositoryAccess access)

Will just deleting the group and re-adding it solve my primary key problem or will the group be created with the same key (ie. next available primary key)

Beth · Post by **Beth** » Mon Jun 25, 2007 7:47 am

We have a fix for the issue you are having. It will be in Vault 4.0.2, which will be coming out very soon (I think in a week or two).

If there's a time crunch with this, send an email to support at sourcegear.com with a link to this forum thread.

MapData · Post by **MapData** » Tue Jul 17, 2007 10:36 pm

I cant find a mention of a fix for this in the release notes for 4.0.2. Was this issue fixed?

Post by **jeremy_sg** » Wed Jul 18, 2007 7:53 am

Yes, the fix for this was included in 4.0.2.