Microsoft Developer Network > Página principal de foros > Team Foundation Server - Setup > TfsWorkItemTracking Process Identities Job fails after upgrade to TFS 2008 SP1
Formular una preguntaFormular una pregunta
 

RespondidaTfsWorkItemTracking Process Identities Job fails after upgrade to TFS 2008 SP1

  • sábado, 23 de agosto de 2008 3:12Marc Miller - AgileThought Medallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuario
     

    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.

Respuestas

  • lunes, 25 de agosto de 2008 6:03Bill.WangMSFT, ModeradorMedallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuario
     Respondida

     

    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.

Todas las respuestas

  • lunes, 25 de agosto de 2008 6:03Bill.WangMSFT, ModeradorMedallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuario
     Respondida

     

    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.

  • lunes, 25 de agosto de 2008 11:54Marc Miller - AgileThought Medallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuarioMedallas del usuario
     

    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.