Team Foundation Server 2010 warehouse processing might fails with the following error reported in the Application Logs in Event Viewer:
Log Name: Application
Source: TFS Services
Date: 2/28/2013 2:19:32 PM
Event ID: 3305
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: machinename
Description:
TF53010: The following error has occurred in a Team Foundation component or extension:
Date (UTC): 2/28/2013 10:19:32 PM
Machine: machinename
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: 2204
Thread Id: 6556
Account name: Team Foundation Server service account
Detailed Message: TF221122: An error occurred running job Full Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION.
Exception Message: Failed to Process Analysis Database 'Tfs_Analysis'. (type WarehouseException)
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)
Inner Exception Details:
Exception Message:
Warning: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_DimFile', Column: 'FileExtension', Value: '.Targets'. The attribute is 'File Extension'.Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Errors in the OLAP storage engine: An error occurred while the 'File' attribute of the 'Version Control File' dimension from the 'Tfs_Analysis' database was being processed.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Server: The operation has been cancelled.
Internal error: The operation terminated unsuccessfully.
Errors in the OLAP storage engine: An error occurred while the 'CreationDate__Year' attribute of the 'Test Run' dimension from the 'Tfs_Analysis' database was being processed.
Errors in the back-end database access module. The read operation was cancelled due to an earlier error.
Errors in the OLAP storage engine: An error occurred while the 'File' attribute of the 'Version Control File' dimension from the 'Tfs_Analysis' database was being processed.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimWorkItemOverlay', Name of 'Work Item' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Area12' attribute of the 'Work Item' dimension from the 'Tfs_Analysis' database was being processed.
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimWorkItemOverlay', Name of 'Work Item' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Conchango_TeamSystem_Scrum_TestingImpact' attribute of the 'Work Item' dimension from the 'Tfs_Analysis' database was being processed.
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimWorkItemOverlay', Name of 'Work Item' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Conchango_TeamSystem_Scrum_HistoryDate__Week' attribute of the 'Work Item' dimension from the 'Tfs_Analysis' database was being processed.
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Test Suite', Name of 'Test Suite' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Suite4' attribute of the 'Test Suite' dimension from the 'Tfs_Analysis' database was being processed.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, FactCurrentWorkItem', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, FactWorkItemHistory', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact WorkItem To Tree', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact Linked Current WorkItem', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact WorkItem To Category', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact WorkItem Changeset', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build Project', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build Details', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Code Churn', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact Test Result Overlay', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build Changeset', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build Coverage', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact WorkItem Test Result', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact Linked Current Work Item Test Case', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Run Coverage', has been specified but has not been used. (type WarehouseException)
Exception Stack Trace: at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ExecuteXmla(String finalXmla)
at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType processingType, WarehouseChanges warehouseChanges, Boolean lastProcessingFailed, Boolean cubeSchemaUpdateNeeded)
Log Name: Application
Source: TFS Services
Date: 2/28/2013 2:19:32 PM
Event ID: 3305
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: machinename
Description:
TF53010: The following error has occurred in a Team Foundation component or extension:
Date (UTC): 2/28/2013 10:19:32 PM
Machine: machinename
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: 2204
Thread Id: 6556
Account name: Team Foundation Server service account
Detailed Message: TF221122: An error occurred running job Full Analysis Database Sync for team project collection or Team Foundation server TEAM FOUNDATION.
Exception Message: Failed to Process Analysis Database 'Tfs_Analysis'. (type WarehouseException)
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)
Inner Exception Details:
Exception Message:
Warning: Errors in the OLAP storage engine: The attribute key cannot be found when processing: Table: 'dbo_DimFile', Column: 'FileExtension', Value: '.Targets'. The attribute is 'File Extension'.Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Errors in the OLAP storage engine: An error occurred while the 'File' attribute of the 'Version Control File' dimension from the 'Tfs_Analysis' database was being processed.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
Server: The operation has been cancelled.
Internal error: The operation terminated unsuccessfully.
Errors in the OLAP storage engine: An error occurred while the 'CreationDate__Year' attribute of the 'Test Run' dimension from the 'Tfs_Analysis' database was being processed.
Errors in the back-end database access module. The read operation was cancelled due to an earlier error.
Errors in the OLAP storage engine: An error occurred while the 'File' attribute of the 'Version Control File' dimension from the 'Tfs_Analysis' database was being processed.
Errors in the OLAP storage engine: The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimWorkItemOverlay', Name of 'Work Item' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Area12' attribute of the 'Work Item' dimension from the 'Tfs_Analysis' database was being processed.
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimWorkItemOverlay', Name of 'Work Item' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Conchango_TeamSystem_Scrum_TestingImpact' attribute of the 'Work Item' dimension from the 'Tfs_Analysis' database was being processed.
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'vDimWorkItemOverlay', Name of 'Work Item' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Conchango_TeamSystem_Scrum_HistoryDate__Week' attribute of the 'Work Item' dimension from the 'Tfs_Analysis' database was being processed.
OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.
Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Test Suite', Name of 'Test Suite' was being processed.
Errors in the OLAP storage engine: An error occurred while the 'Suite4' attribute of the 'Test Suite' dimension from the 'Tfs_Analysis' database was being processed.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, FactCurrentWorkItem', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, FactWorkItemHistory', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact WorkItem To Tree', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact Linked Current WorkItem', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact WorkItem To Category', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact WorkItem Changeset', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build Project', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build Details', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Code Churn', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact Test Result Overlay', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build Changeset', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Build Coverage', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact WorkItem Test Result', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, v Fact Linked Current Work Item Test Case', has been specified but has not been used.
Warning: Parser: Out of line object 'Binding', referring to ID(s) 'Tfs_Analysis, Team System, Fact Run Coverage', has been specified but has not been used. (type WarehouseException)
Exception Stack Trace: at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ExecuteXmla(String finalXmla)
at Microsoft.TeamFoundation.Warehouse.TFSOlapProcessComponent.ProcessOlap(AnalysisDatabaseProcessingType processingType, WarehouseChanges warehouseChanges, Boolean lastProcessingFailed, Boolean cubeSchemaUpdateNeeded)