TfsWorkItemTracking Process Identities Job fails after upgrade to TFS 2008 SP1

Question

I upgraded my TFS 2008 server with Visual Studio 2008 SP1 followed by TFS 2008 SP1. After upgrade the TfsWorkItemTracking Process Identities job fails every 10 minutes with the following error:

 

Executed as user: NT AUTHORITY\NETWORK SERVICE. Could not find stored procedure 'dbo.GetAccountDisplayMode'. [SQLSTATE 42000] (Error 2812).  The step failed.

 

I searched for this stored procedure and later found that it is a missing scalar function, having located it on another TFS server.

 

Any help would be greatly appreciated. Thanks.

Answer 1

 

Does adding this function manually work? Please run the following sql that I get from the TFS on my box:

 

Code Snippet

USE [TfsWorkItemTracking]

GO

/****** Object:  UserDefinedFunction [dbo].[GetAccountDisplayMode]    Script Date: 08/25/2008 13:58:13 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

 

Create function [dbo].[GetAccountDisplayMode]

()

RETURNS int

as

begin

return 2

 

end

 

 

I'm not sure why this function is missed. I'd like to suggest you running Best Practice Analyzer from the Visual Studio TFS Power Tool to have a health check against TFS.

Answer 2

Thanks for the response.

 

This is in fact the work around that I used successfully on 8/23 after retrying the upgrade (my TFS server is a virtual server). Prior to running the upgrade, I saved that function to file. After the second upgrade attempt produced the same results (missing function), I ran the saved query.

 

I will run the Best Practice Analyzer and post anything suspicious.

 

Thanks again.