index > Team Foundation Server - Work Item Tracking > WorkItemTracking error : The INSERT statement conflicted with the...

WorkItemTracking error : The INSERT statement conflicted with the...


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.

Alvedon

How often is it getting logged?

Is this just being logged as a warning?




Sam Heald (MSFT)
Sam Heald
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.
Alvedon
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.

Sam Heald
reply 4

You can use google to search for other answers

 

More Articles

Can users add and view work items from the sharepoint portal for ...
Field-name used in error message
Grouping Query Clauses
<ALLOWEXISTINGVALUE> not valid for System.Reason
How do I specify dependancies (and import to Project)
Work Items Areas and the WOrk Item OM
How to autofill field value from other field value during transit...
Work Item Dependency
Making the query find items without a review
Creating a Custom query programmatically and displaying results i...
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

GCHandle exception when querying TFS fro…
How to add custom fields that works like…
Project->Tasks: bogus start dates?
Can the default value for a PlainText fi…
TF80071 connecting MPP to Team project
Work Item Attachment
Refresh on the TeamFoundationServer obje…
Copied work items do not show up in quer…
Nested WHEN or conditional operators
Work Item object model - problem with ed…
Contains operator for WorkItem HTML fiel…
Publishing errors when updating frozen f…
Re-Pointing Microsoft Project plan at TFS
Renaming column names in Query
Supress the "Team" Menu

Hot Articles

Set permission to some specific group to…
Adding Areas and Iterations via the obje…
Custom work item editor
Query using Contains Operator
limit control type links control to spec…
Customize Query Variables
Label Report of work items and files
Adding a camera or screen shot utility t…
Contains operator for WorkItem HTML fiel…
Work Item Access control based on Work I…
Project field mapping questions
Walkthru question on "To save a doc…
How to Import/Export WorkItems in TFS-RTM
Default TFS event subscriptions & ce…
MS Project stops leveling after getting …

Recommend Articles

Possible bug(?): LinksControl as a requi…
There is a way to make the link control …
How can I know who's link to my WI??
What Is the Difference Between a Task an…
MSProject Undo and Redo disabled
Build a WIQL query on iteration paths
Work Item custom field's value update
Where is the Authoring Work Item Types.d…
TFS VersionControl SQL transaction Log S…
MS Project Integration and Assigned To F…
Integrating with TFS: Use of ExecuteDefa…
Project to TFS sync problem
WorkItemStore null reference
Want just to see (not manage) work items…
WI permission