WorkItemTracking error : The INSERT statement conflicted with the CHECK constraint

Hot Topic

resizing of vector drawings
Problem with TabControl & DataGridView
FxCop and private methods
Replacing an existing project in TFS source control with a newer one!!
Protected nested types, should CA1034 (NestedTypesShouldNotBeVisible) apply?
Header Images
How do you find what process template is in use?
Can I change TFS application pool TFSWSS
Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED))
Debugging running very slow

VS Team System

TFSBuild & sourceControl Deposit
MSDN Library May 2006 Edition integration
What is "citizinship mindset" ?
Can TFSBuild run different targets the way MSBuild can
Import new schema objects into existing project
Installing on 3 servers
Performance counter error
How to add TFS programatically
VC++2005 EE & Books
Clipboard Help

WorkItemTracking error : The INSERT statement conflicted with the CHECK constraint

Hi

I have a problem that I can't find a solution to, I've tried searching the forum and the only thread I could find was regarding beta2 and the anwser was to upgrade.

What could generete this problem and is there a fix for it

Error:

TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.

Technical Information (for the administrative staff):

Date (UTC): 2006-10-04 20:12:51

Machine: VS00

Application Domain: /LM/W3SVC/3/Root/WorkItemTracking-5-128044663618957318

Assembly: Microsoft.TeamFoundation.WorkItemTracking.Server.DataServices, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727

Process Details:

Process Name: w3wp

Process Id: 2468

Thread Id: 3064

Account name: VS00\TFS_User_50

Detailed Message: The INSERT statement conflicted with the CHECK constraint "CK_Rules_NoUserRulesGlobal". The conflict occurred in database "TfsWorkItemTracking", table "dbo.Rules", column 'System.AreaId'.

Exception Message: The INSERT statement conflicted with the CHECK constraint "CK_Rules_NoUserRulesGlobal". The conflict occurred in database "TfsWorkItemTracking", table "dbo.Rules", column 'System.AreaId'. (type SqlException)

SQL Exception Class: 16

SQL Exception Number: 547

SQL Exception Procedure: LookupRule

SQL Exception Line Number: 315

SQL Exception Server: VS00

SQL Exception State: 0

SQL Error(s):

Exception Data Dictionary:

HelpLink.ProdName = Microsoft SQL Server

HelpLink.ProdVer = 09.00.2047

HelpLink.EvtSrc = MSSQLServer

HelpLink.EvtID = 547

HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink

HelpLink.LinkId = 20476

 

Exception Stack Trace: at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.HandleDalError(Exception e)

at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlAccess.ExecuteBatchPayloadImpl(IRequestContext context, String sqlBatch, List`1 parameterList, Boolean& errorOnBulkUpdate, String connectionString)

at Microsoft.TeamFoundation.WorkItemTracking.Server.SqlBatchBuilder.ExecuteBatchInternal(IRequestContext context, Boolean passInConnectionInfo, String server, String database)

at Microsoft.TeamFoundation.WorkItemTracking.Server.DataAccessLayerImpl.UpdateImpl(String serverName, String databaseName, String attachmentServer, String attachmentDatabase, XmlElement updateElement, MetadataTable[] tablesRequested, Int64[] rowVersions, Payload metadataPayload, Boolean bisNotification, String& dbStamp, Boolean bulkUpdate, Boolean& bulkUpdateSuccess, String userSid)

at Microsoft.TeamFoundation.WorkItemTracking.Server.DataAccessLayerImpl.Update(String serverName, String databaseName, String attachmentServer, String attachmentDatabase, XmlElement updateElement, MetadataTable[] tablesRequested, Int64[] rowVersions, Payload metadataPayload, Boolean bisNotification, String& dbStamp, String userSid)

at Microsoft.TeamFoundation.WorkItemTracking.Server.ProcessSecurityEventMessage.ExecuteBatch(String updateXml)

at Microsoft.TeamFoundation.WorkItemTracking.Server.ProcessSecurityEventMessage.Process()

at Microsoft.TeamFoundation.WorkItemTracking.Server.SecurityEventMessage.Process()

at Microsoft.TeamFoundation.WorkItemTracking.Server.EventMessageHandler.ProcessSecurity(Int32 seqId)

at Microsoft.TeamFoundation.WorkItemTracking.Server.EventMessageHandler.ProcessSecurityEvent()

 

 

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Answer this question

WorkItemTracking error : The INSERT statement conflicted with the CHECK constraint

  • Gafrage

    This post is a fork of this post, correct

    http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=785669&SiteID=1

    If so, I will follow-up on that thread.

  • Ashish Vyas

    How often is it getting logged

    Is this just being logged as a warning



  • Gage

    The error apperas a couple of times, more exactly every reboot and when a user that tries to view or add WorkItems, this is regardless if the user is an administrator or a contributor. The only difference is when you are an admin you can still view and add workitems but the error appears in the AT errorlog, but as a contributor you don't see the workitems.
  • WorkItemTracking error : The INSERT statement conflicted with the CHECK constraint
Answer this question