Violation of PRIMARY KEY constraint ''PK_tbl_Lock''

Event Type: Error
Event Source: TFS Version Control
Event Category: None
Event ID: 3000
Date: 16/06/2007
Time: 3:38:22 PM
User: N/A
Computer: SERVER
Description:
TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.
Technical Information (for the administrative staff):
Date (UTC): 16/06/2007 5:38:22 AM
Machine: RPTFS01
Application Domain: /LM/W3SVC/3/Root/VersionControl-3-128263771174741081
Assembly: Microsoft.TeamFoundation.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 4788
Thread Id: 196
Account name: DOMAIN\TFSBUILD

Detailed Message: TF14105: An exception occurred in the Team Foundation Source Control System.
Web Request Details
Url:http://SERVER:8080/VersionControl/v1.0/repository.asmx [method: POST]
User Agent: Team Foundation (TfsIntegrator.exe, 8.0.50727.762)
Headers: Content-Length=665&Content-Type=application%2fsoap%2bxml%3b+charset%3dutf-8&Accept-Encoding=gzip&Accept-Language=en-AU&Expect=100-continue&Host=rptfs01%3a8080&User-Agent=Team+Foundation+(TfsIntegrator.exe%2c+8.0.50727.762)&X-TFS-Version=1.0.0.0&X-VersionControl-Instance=e3b211c6-3045-4c31-8e2b-0759e338ef4e
Path: /VersionControl/v1.0/repository.asmx
Local Request: True
Host Address: address
User: DOMAIN\TFSBUILD [authentication type: NTLM]

Exception Message: Violation of PRIMARY KEY constraint 'PK_tbl_Lock'. Cannot insert duplicate key in object 'dbo.tbl_Lock'.
(null): Database Update Failure - Error 2627 executing INSERT statement for tbl_Lock
RPTFS01.TfsVersionControl..prc_PendEdit: Database Update Failure - Error 500004 executing EXEC statement for prc_iiLockItem
The statement has been terminated. (type SqlException)
SQL Exception Class: 14
SQL Exception Number: 2627
SQL Exception Procedure: prc_iiLockItem
SQL Exception Line Number: 44
SQL Exception Server: SERVER
SQL Exception State: 1
SQL Error(s):
SQL Error[1]: System.Data.SqlClient.SqlError: (null): Database Update Failure - Error 2627 executing INSERT statement for tbl_Lock
Class: 16
Number: 500004
Server: SERVER
Source: .Net SqlClient Data Provider
State: 1
Procedure: prc_iiLockItem
Line Number: 57
SQL Error[2]: System.Data.SqlClient.SqlError: SERVER.TfsVersionControl..prc_PendEdit: Database Update Failure - Error 500004 executing EXEC statement for prc_iiLockItem
Class: 16
Number: 500004
Server: SERVER
Source: .Net SqlClient Data Provider
State: 1
Procedure: prc_PendEdit
Line Number: 315
SQL Error[3]: System.Data.SqlClient.SqlError: The statement has been terminated.
Class: 0
Number: 3621
Server: SERVER
Source: .Net SqlClient Data Provider
State: 0
Procedure: prc_iiLockItem
Line Number: 44

Exception Data Dictionary:
HelpLink.ProdName = Microsoft SQL Server
HelpLink.ProdVer = 09.00.3054
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 2627
HelpLink.BaseHelpUrl =http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476

Exception Stack Trace: 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.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 Microsoft.TeamFoundation.Server.SqlResourceComponent.execute(ExecuteType executeType, CommandBehavior behavior)
at Microsoft.TeamFoundation.VersionControl.Server.VersionControlSqlResourceComponent.execute(ExecuteType executeType, CommandBehavior behavior)
at Microsoft.TeamFoundation.Server.SqlResourceComponent.ExecuteReader()
at Microsoft.TeamFoundation.VersionControl.Server.VersionedItemComponent.PendEdit(Workspace workspace, String targetServerItem, Int32 Encoding, LockLevel lockLevel, IList warnings, Boolean silent)
at Microsoft.TeamFoundation.VersionControl.Server.ChangeRequest.PendChange(ExpandedChange expandedChange, VersionedItemComponent db, Workspace workspace, IPrincipal userPrincipal, Set`1 attempts, ArrayList successes, ArrayList warnings, ArrayList failures, Boolean silent)
at Microsoft.TeamFoundation.VersionControl.Server.ChangeRequest.PendChanges(IPrincipal userPrincipal, Workspace workspace, ChangeRequest[] requests, ArrayList& failures, Boolean silent)
at Microsoft.TeamFoundation.VersionControl.Server.Repository.PendChanges(String workspaceName, String ownerName, ChangeRequest[] changes, Boolean silent, ArrayList& failures)

For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.