Saturday, April 13, 2013

[SQL Server Data Warehousing] Team Foundation Server Issue Work Items not synching to warehouse - TF221122: An error occurred running job Work Item Tracking Warehouse Sync for team project collection or Team


custom field were added to the work item template


[_WitFields]


SK ReferenceNameDisplayName DataType Filedname
139 Acq.TaskSourceSource 162 10083


Values in Field 10083


fld10083
Internal/Tech
NULL
QA
Business Request


This is where the failure is


Exception Message: Conversion failed when converting the nvarchar value 'Business Request' to data type int. Cannot find the object "#workingSet" because it does not exist or you do not have permissions. (type SqlException) SQL Exception Class: 16 SQL Exception Number: 50000 SQL Exception Procedure: prc_Dimension_DimWorkItem_AddUpdate 



.

social.technet.microsoft.com/Forums

No comments:

Post a Comment

Search This Blog