TFS Deleted Work Item field showing up when Processing Analsysis database error.

Question

I had created a Work Item field and had deleted it but still the Field is somehow getting into the Analysis Database when I attempt to Process the Cube using the WarehouseControlWebService. The deleted field is causing the Cube to error out. Here is the error from event Viewer. I do not see this field defined anywhere in TFS fields, nor in the TFSWarehouse. As you can see the reason I needed to delete it because it was misspelled. The field is not listed in TFSWarehouse._WitFields, nor in the ProjectCollection Database Fields table. I cannot find this field defined anywhere but still it is showing up as an error when I try to process the Cube. I have totally deleted the TFSWarehouse, Rebuilt it, processed it, Deleted the TFSAnalysis database, Rebuilt it, and processing it via the web service. I am using TFS Admin Console for the Rebuilding.

Detailed Message: Failed to create or update dimension attribute for the Microsoft_VSTS_Build_BuildFoundIn warehouse field in dimension Work Item.

Exception Message: Object reference not set to an instance of an object. (type NullReferenceException)

Answer 1

Answered here, http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/951001c7-1528-4b62-8dc5-7e5728f792dd

---

Please remember to mark the replies as answers if they help.

Blog: http://geekswithblogs.net/TarunArora  Subscribe in a reader

Answer 2

And if you decide to go down the root of rebuilding the cube, then follow the instructions here, http://blog.accentient.com/2010/04/08/ManuallyProcessingTheTeamFoundationServer2010DataWarehouseAndAnalysisServicesDatabase.aspx 

---

Please remember to mark the replies as answers if they help.

Blog: http://geekswithblogs.net/TarunArora  Subscribe in a reader

Answer 3

Thanks for the links, I have deleted, rebuilt and ran the web services to process the warehouse and Cube more than several times already. I have done that and I still get an error. Thanks for your help.

Error message from the GetProcessingStatus service.

<Job JobProcessingStatus="Idle" Name="Full Analysis Database Sync"><lastrun EndTimeUtc="2012-05-22T20:51:45.08Z" ExecutionStartTimeUtc="2012-05-22T20:51:42.177Z" QueueTimeUtc="2012-05-22T20:51:41.287Z" Result="Failed"><LastRun Result="Failed" EndTimeUtc="2012-05-22T20:51:45.08Z" ExecutionStartTimeUtc="2012-05-22T20:51:42.177Z" QueueTimeUtc="2012-05-22T20:51:41.287Z"><resultmessage><ResultMessage>[Full Analysis Database Sync]:  ---> AnalysisDatabaseProcessingType=Full, needCubeSchemaUpdate=True. ---> Microsoft.TeamFoundation.Server.WarehouseException: TF221122: An error occurred running job Full Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION. ---> Microsoft.TeamFoundation.Server.WarehouseException: Failed to Process Analysis Database 'TFS_Analysis'. ---> System.NullReferenceException: Object reference not set to an instance of an object.   at Microsoft.TeamFoundation.Warehouse.OlapCreator.AddOrUpdateDimensionAttribute(WarehouseConfig warehouseConfig, DataTable dataSource, Dimension dimension, Field field, Boolean createRelationshipToKey)   at Microsoft.TeamFoundation.Warehouse.OlapCreator.CreateOrUpdateDimensions(WarehouseConfig warehouseConfig, Database database, Cube cube, Boolean recreateAllTfsEntities, IEnumerable`1 dimensionNames)   at Microsoft.TeamFoundation.Warehouse.OlapCreator.CreateOrUpdateCubes(WarehouseConfig warehouseConfig, Database database, DataSourceView dsv, IEnumerable`1 dimensionNames, IEnumerable`1 factNames, Boolean recreateAllTfsEntities)   at Microsoft.TeamFoundation.Warehouse.OlapCreator.CreateOrUpdateOlapSchema(WarehouseConfig warehouseConfig, Database database, DataSourceView dataSourceView)   at Microsoft.TeamFoundation.Warehouse.OlapCreator.UpdateOlapSchema(Server server, IEnumerable`1 readerAccountNames, WarehouseConfig warehouseConfig)   at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.UpdateOlapSchema()   at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType processingType, WarehouseChanges warehouseChanges, Boolean lastProcessingFailed, Boolean cubeSchemaUpdateNeeded)   --- End of inner exception stack trace ---   at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType processingType, WarehouseChanges warehouseChanges, Boolean lastProcessingFailed, Boolean cubeSchemaUpdateNeeded)   at Microsoft.TeamFoundation.Warehouse.AnalysisDatabaseSyncJobExtension.RunInternal(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String& resultMessage)   at Microsoft.TeamFoundation.Warehouse.WarehouseJobExtension.Run(TeamFoundationRequestContext requestContext, TeamFoundationJobDefinition jobDefinition, DateTime queueTime, String& resultMessage)   --- End of inner exception stack trace ---</ResultMessage></resultmessage></LastRun></lastrun><nextrun JobState="QueuedScheduled" QueueTimeUtc="2012-05-23T07:00:00Z"><NextRun QueueTimeUtc="2012-05-23T07:00:00Z" JobState="QueuedScheduled"/></nextrun>

Error message from EventViewer. This I have seen numerous times also I cannot find this Field that it is choking on.

TF53010: The following error has occurred in a Team Foundation component or extension:

Date (UTC): 5/22/2012 8:51:45 PM

Machine: TFS

Application Domain: TfsJobAgent.exe

Assembly: Microsoft.TeamFoundation.Framework.Server, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727

Service Host:

Process Details:

  Process Name: TFSJobAgent

  Process Id: 1852

  Thread Id: 4596

  Account name: 2BEHURD\TFSService1

Detailed Message: Failed to create or update dimension attribute for the Microsoft_VSTS_Build_BuildFoundIn warehouse field in dimension Work Item.

Exception Message: Object reference not set to an instance of an object. (type NullReferenceException)

Exception Stack Trace:    at Microsoft.TeamFoundation.Warehouse.OlapCreator.AddOrUpdateDimensionAttribute(WarehouseConfig warehouseConfig, DataTable dataSource, Dimension dimension, Field field, Boolean createRelationshipToKey)

<nextrun JobState="QueuedScheduled" QueueTimeUtc="2012-05-23T07:00:00Z"></nextrun>

Answer 4

Hi Tarun,

Thanks for your reply. 

Please view the discussions in AaronBrock’s initial post here, as AaronBrock said, recreated the Tfs_Warehouse and Tfs_Analysis can’t resolve this issue. Do you have other suggestions?

Any suggestions are appreciated.       

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us

Answer 5

Current status, I am no longer getting the error message on the Severity as stated in the other posting. I had resolved that issue by researching and finding that some resolutions were found by adding a new Team project to the TEam PRoject Collection with all the default work item types. So I did add a TEST team project from the CMMI template and that resolved the Severity field showing up as a missing dimension attribute, but I am still getting an error with the Field noted in this posting. I had attempted to add Microsoft_VSTS_Build_BuildFoundIn as a new Field to resolve an error where Microsoft_VSTS_Build_FoundIn field was having an error but as you can see I had a typo, Now currently I still get error missing Microsoft_VSTS_Build_BuildFoundIn  when processing the cube using the WebServices. Thats where I stand right now trying to track down where in the Data Warehouse that field is defined. Thanks all for any suggestions of where to look, I have been looking through each table.

---

Aaron Brockhaus

Answer 6

Hi Aaron, 

Thanks for your reply.

After you cleaned the Cache and restarted the TFS Server, you can try to recreate the Tfs_Analysis database or create another new TFS analysis database again, then click Rebuild to re-build them. Please refer to: http://ravendra.wordpress.com/2010/05/10/team-foundation-server-2010-warehouse-rebuilt/.       

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us

Answer 7

Yes that was the ticket, clearing the TFS cache on the server and recreating the TFS Analysis db and reprocessing. Thanks All!

---

Aaron Brockhaus