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

 

Answer 1

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.

Answer 2

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

 

 

 

 

Answer 3

 

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