TfsWorkItemTracking Process Identities Job fails after upgrade to TFS 2008 SP1

Sat, 23 Aug 2008 03:12:45 Z

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.

TfsWorkItemTracking Process Identities Job fails after upgrade to TFS 2008 SP1

Mon, 25 Aug 2008 06:03:02 Z

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

Code Snippet

USE [TfsWorkItemTracking]

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

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

Create function [dbo].[GetAccountDisplayMode]

()

RETURNS int

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.

TfsWorkItemTracking Process Identities Job fails after upgrade to TFS 2008 SP1

Mon, 25 Aug 2008 11:54:57 Z

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.