[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