none
Database Errors

    Question

  • Hi

    We're running TFS on two nodes IIS from box 1 and the data server on box 2, both machines are running  Windows 2003 64 bit, with SP1, the database is SQL Server 2005 64bit with SP2.

     

    We have applied TFS SP1 successfully six weeks ago, but get the following errors in the database errorlog intermittently;

     

    2007-06-06 14:59:46.01 spid68      Error: 18054, Severity: 16, State: 1.
     2007-06-06 14:59:46.01 spid68      Error 500119, severity 16, state 1 was raised, but no message with that error number was found in sys.messages. If error is larger than 50000, make sure the user-defined message is added using sp_addmessage.
     

    Is this a SP1 induced bug ? I have given TFSERVICE sysadmin rights on the data server so it's not a privilege issue.

     

    regards

    2k5

     

    Wednesday, June 06, 2007 2:14 PM

Answers

  • It seems like your error messages have been cleared out. Did you recently rebuild your master database? You can reset them by running :

     

    USE TFSVersionControl

    GO

    exec prc_iiInstallMessages

     

     

     

     

    Wednesday, June 06, 2007 7:57 PM

All replies

  • That appears to be an error from Source Control --> "PendingChangeMergeConflictExists".  I'll followup with one of the source control folks to see if they have any insight.
    Wednesday, June 06, 2007 7:25 PM
  • It seems like your error messages have been cleared out. Did you recently rebuild your master database? You can reset them by running :

     

    USE TFSVersionControl

    GO

    exec prc_iiInstallMessages

     

     

     

     

    Wednesday, June 06, 2007 7:57 PM
  •  

    Yes, that has to be 'the fix', we have migrated off our original data server and missed this essential step.

    ( anything else held in master?)

     

    Many thanks,

    2K5
    Thursday, June 07, 2007 7:37 AM