View History Errors

We are getting errors on some files when we try to View History.

Event Type: Error
Event Source: TFS Version Control
Event Category: None
Event ID: 3000
Date: 10/5/2006
Time: 2:27:19 PM
User: N/A
Computer: TFS1
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): 10/5/2006 9:27:19 PM
Machine: TFS1
Application Domain: /LM/W3SVC/3/Root/VersionControl-2-128045557970820364
Assembly: Microsoft.TeamFoundation.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 5716
Thread Id: 5632
Account name: RCM\kfleming

Detailed Message: TF14105: An exception occurred in the Team Foundation Source Control System.
Web Request Details
Url:http://tfs1:8080/VersionControl/v1.0/repository.asmx [method: POST]
User Agent: Team Foundation (devenv.exe, 8.0.50727.147)
Headers: Content-Length=862&Content-Type=application%2fsoap%2bxml%3b+charset%3dutf-8&Accept-Encoding=gzip&Accept-Language=en-US&Expect=100-continue&Host=tfs1%3a8080&User-Agent=Team+Foundation+(devenv.exe%2c+8.0.50727.147)&X-TFS-Version=1.0.0.0&X-VersionControl-Instance=e6072838-acb4-42fd-a853-b2551e64b126
Path: /VersionControl/v1.0/repository.asmx
Local Request: False
Host Address: 192.168.0.50
User: RCM\kfleming [authentication type: NTLM]

Exception Message: Object reference not set to an instance of an object. (type NullReferenceException)

Exception Stack Trace: at Microsoft.TeamFoundation.VersionControl.Server.Changeset.lookupDisplayNames()
at Microsoft.TeamFoundation.VersionControl.Server.Item.QueryItemHistory(IPrincipal userPrincipal, String user, ItemSpec itemSpec, Workspace localWorkspace, VersionSpec versionItem, VersionSpec versionFrom, VersionSpec versionTo, Int32 maxCount, Boolean includeFiles, Boolean generateDownloadUrls, Boolean slotMode)
at Microsoft.TeamFoundation.VersionControl.Server.Repository.QueryHistory(String workspaceName, String workspaceOwner, ItemSpec itemSpec, VersionSpec versionItem, String user, VersionSpec versionFrom, VersionSpec versionTo, Int32 maxCount, Boolean includeFiles, Boolean generateDownloadUrls, Boolean slotMode)

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

[2834 byte] By [KenFleming] at [2007-12-25]
# 1
I can't find any known issues with a similar stack. Please call Customer Support so this can be escalated to the development team and we can figure out what's happening.
RichardBergMSFT at 2007-9-3 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Version Control...
# 2

I would love to, but my boss has said either get it working or we move to SourceSafe.

I was the one that talked management into using TeamFoundation and little support from management (new/different=bad).

The only problem we have run into that I have not been able to work around is the View History. It works on everything but

a few files. I suspect that it has something to do with moving from the workgroup version, but not sure. The reason I think

this is that all effected files are older files. Everything added since the "upgrade" have worked fine.

KenFleming at 2007-9-3 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Version Control...
# 3

Show him this: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=570187&SiteID=1 :) Seriously, having switched my own responsibilities from TFS to VSS recently, you do not want to go down that path.

As far as your crash, try installing SP1 in case it's a known issue after all. I'll point some TFS folks at this thread to see if the stack trace rings any bells.

RichardBergMSFT at 2007-9-3 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Version Control...
# 4

From the sounds of it - it looks like you are missing rows from the identity table - did anyone manually delete any rows from this table? Run this query and check if it returns any rows

select * from tbl_Changeset a

where not exists (

select * from tbl_Identity b

where b.IdentityId = a.OwnerId

Hope it helps

ChandruR-MSFT at 2007-9-3 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Version Control...
# 5

If you do find deleted identities, run the following SQL script in a query window on VC database to fix the problem. The values XX and YY below are the deleted identity ids.

BEGIN TRAN
DECLARE @deletedUniqueUserId INT
DECLARE @authKey1 VARBINARY(85)
DECLARE @authKey2 VARBINARY(85)
DECLARE @base VARBINARY(85)

SET @base = 0xFFEEEEEE
SET @authKey1 = @base + CAST (NEWID() AS VARBINARY(85))
SET @authKey2 = @base + CAST (NEWID() AS VARBINARY(85))

SELECT @deletedUniqueUserId = CounterValue
FROM tbl_Counter WITH (UPDLOCK)
WHERE CounterName = 'UniqueUserId'

SET IDENTITY_INSERT dbo.tbl_Identity ON

INSERT INTO dbo.tbl_Identity(IdentityId, AuthenticationKey, AuthenticationType, DisplayName, IsGroupIdentity, UniqueUserId, CreationDate)
VALUES (XX, @authKey1, 1, 'LCC\Unknown', 0, @deletedUniqueUserId, GETUTCDATE())

INSERT INTO dbo.tbl_Identity(IdentityId, AuthenticationKey, AuthenticationType, DisplayName, IsGroupIdentity, UniqueUserId, CreationDate)
VALUES (YY, @authKey2, 1, 'LCC\Unknown', 0, @deletedUniqueUserId+1, GETUTCDATE())

UPDATE tbl_Counter
SET CounterValue = CounterValue + 2
WHERE CounterName = 'UniqueUserId'

SET IDENTITY_INSERT dbo.tbl_Identity OFF
COMMIT TRAN

VasuSankaran at 2007-9-3 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Version Control...

Visual Studio Team System

Site Classified