index > Team Foundation Server - Administration > Team System Warehouse Problems

Team System Warehouse Problems


Hello,

About five days ago I started seeing a bunch of errors in the Windows Application Event Log. I've been searching for solutions for the past few days with no luck so now I'm posting here.

Here's the errors I'm getting in order:

==============================================================

Event Type: Error
Event Source: MSSQLServerOLAPService
Event Category: (289)
Event ID: 19
Date: 9/20/2006
Time: 9:56:27 AM
User: N/A
Computer: TEAMSERVER
Description:
Errors in the metadata manager. An error occurred when loading the Changeset dimension, from the file, '\\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\TFSWarehouse.0.db\Changeset.200.dim.xml'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

==============================================================

Event Type: Error
Event Source: MSSQLServerOLAPService
Event Category: (289)
Event ID: 19
Date: 9/20/2006
Time: 9:56:27 AM
User: N/A
Computer: TEAMSERVER
Description:
Errors in the metadata manager. An error occurred when loading the Team System cube, from the file, '\\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\TFSWarehouse.0.db\Team System.493.cub.xml'.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

==============================================================

Event Type: Error
Event Source: TFS Warehouse
Event Category: None
Event ID: 3000
Date: 9/20/2006
Time: 9:56:27 AM
User: N/A
Computer: TEAMSERVER
Description:
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): 9/20/2006 4:56:27 PM
Machine: TEAMSERVER
Application Domain: /LM/W3SVC/3/Root/Warehouse-3-128032449845468750
Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727
Process Details:
Process Name: w3wp
Process Id: 2284
Thread Id: 2380
Account name: INDY\TFSService

Detailed Message: Failed to load adapter Microsoft.TeamFoundation.Warehouse.CommonStructureAdapter. Exception Info: \n Microsoft.AnalysisServices.OperationException: File system error: The following file is corrupted: Physical file: \\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\TFSWarehouse.0.db\Changeset.0.dim\200.Changeset.Changeset.lstore. Logical file .
Errors in the metadata manager. An error occurred when loading the Changeset dimension, from the file, '\\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\TFSWarehouse.0.db\Changeset.200.dim.xml'.
Errors in the metadata manager. An error occurred when loading the Team System cube, from the file, '\\?\D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\TFSWarehouse.0.db\Team System.493.cub.xml'.

at Microsoft.AnalysisServices.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError)
at Microsoft.AnalysisServices.AnalysisServicesClient.Discover(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.Refresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.Server.SendRefresh(IMajorObject obj, ObjectExpansion expansion)
at Microsoft.AnalysisServices.MajorObject.Refresh()
at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)
at Microsoft.AnalysisServices.Server.Connect(String connectionString)
at Microsoft.TeamFoundation.Warehouse.OlapCreator.GetServerEdition()
at Microsoft.TeamFoundation.Warehouse.OlapCreator.CommonInit()
at Microsoft.TeamFoundation.Warehouse.OlapCreator..ctor(String serverName, String databaseName)
at Microsoft.TeamFoundation.Warehouse.AdapterWrapper..ctor(Type type, AdapterScheduler scheduler, String connectionString, String accessAccount, String dataReaderAccount, String analysisDbServer, String analysisDbName)
at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.Initialize()

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

==============================================================

This group of these 3 errors repeats for a total of 5 sets of these 3 errors which all happens over the course of about 2 seconds time. Then I'll see this pattern repeat every couple of hours.

I will paste the files that are referred to here in additonal posts.




Matt
mthomasq3

Changeset.200.dim.xml:
==============================================================
- <Load xmlns="http://schemas.microsoft.com/analysisservices/2003/engine" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
- <ParentObject>
<DatabaseID>TFSWarehouse</DatabaseID>
</ParentObject>
- <ObjectDefinition>
- <Dimension>
<Name>Changeset</Name>
<ID>Changeset</ID>
<CreatedTimestamp>2006-09-01T01:25:57</CreatedTimestamp>
<LastSchemaUpdate>2006-09-01T01:59:34</LastSchemaUpdate>
<ObjectVersion>200</ObjectVersion>
<ObjectID>E79D5056-14E8-455F-9A17-831855ADD993</ObjectID>
<Ordinal>31</Ordinal>
<PersistLocation>0</PersistLocation>
<System>false</System>
<DataFileList>200.(All).ahstore;200.(All).asstore;200.(All).astore;200.(All).bsstore;200.(All).bstore;200.(All).fact.data;200.(All).fact.data.hdr;200.(All).hstore;200.(All).khstore;200.(All).ksstore;200.(All).kstore;200.Changeset ID.(All).dstore;200.Changeset ID.(All).lstore;200.Changeset ID.(All).ostore;200.Changeset ID.(All).sstore;200.Changeset ID.ahstore;200.Changeset ID.asstore;200.Changeset ID.astore;200.Changeset ID.bsstore;200.Changeset ID.bstore;200.Changeset ID.Changeset ID.dstore;200.Changeset ID.Changeset ID.fact.map;200.Changeset ID.Changeset ID.fact.map.hdr;200.Changeset ID.Changeset ID.lstore;200.Changeset ID.Changeset ID.ostore;200.Changeset ID.Changeset ID.sstore;200.Changeset ID.Changeset.dstore;200.Changeset ID.fact.data;200.Changeset ID.fact.data.hdr;200.Changeset ID.hstore;200.Changeset ID.khstore;200.Changeset ID.ksstore;200.Changeset ID.kstore;200.Changeset.(All).dstore;200.Changeset.(All).lstore;200.Changeset.(All).ostore;200.Changeset.(All).sstore;200.Changeset.ahstore;200.Changeset.asstore;200.Changeset.astore;200.Changeset.bsstore;200.Changeset.bstore;200.Changeset.Changeset ID.fact.map;200.Changeset.Changeset ID.fact.map.hdr;200.Changeset.Changeset.dstore;200.Changeset.Changeset.fact.map;200.Changeset.Changeset.fact.map.hdr;200.Changeset.Changeset.lstore;200.Changeset.Changeset.ostore;200.Changeset.Changeset.sstore;200.Changeset.fact.data;200.Changeset.fact.data.hdr;200.Changeset.hstore;200.Changeset.khstore;200.Changeset.ksstore;200.Changeset.kstore</DataFileList>
<Description />
- <Annotations xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
- <Annotation>
<Name>Owner</Name>
<Value>Microsoft.VSTS</Value>
</Annotation>
</Annotations>
<LastProcessed>2006-09-16T04:02:41</LastProcessed>
- <Source xsi:type="DataSourceViewBinding">
<DataSourceViewID>TFSWarehouseDataSourceView</DataSourceViewID>
</Source>
<MiningModelID />
<Type>Regular</Type>
<UnknownMember>Visible</UnknownMember>
<MdxMissingMemberMode>Default</MdxMissingMemberMode>
<StorageMode>Molap</StorageMode>
<CurrentStorageMode>Molap</CurrentStorageMode>
<ProcessingPriority>0</ProcessingPriority>
<WriteEnabled>false</WriteEnabled>
<DependsOnDimensionID />
<Language>1033</Language>
<Collation>Latin1_General_CI_AS</Collation>
<UnknownMemberName>Unknown</UnknownMemberName>
<ProcessingMode>Regular</ProcessingMode>
<OrderByKey>false</OrderByKey>
<AttributeAllMemberName />
- <ProactiveCaching>
<SilenceInterval>-PT1S</SilenceInterval>
<Latency>-PT1S</Latency>
<SilenceOverrideInterval>-PT1S</SilenceOverrideInterval>
<ForceRebuildInterval>-PT1S</ForceRebuildInterval>
<Enabled>false</Enabled>
<AggregationStorage>Regular</AggregationStorage>
<OnlineMode>Immediate</OnlineMode>
- <Source xsi:type="ProactiveCachingInheritedBinding">
<NotificationTechnique>Client</NotificationTechnique>
</Source>
</ProactiveCaching>
- <UnknownMemberTranslations>
- <UnknownMemberTranslation>
<Language>1033</Language>
<Caption>Unknown</Caption>
<Description />
<DisplayFolder />
</UnknownMemberTranslation>
</UnknownMemberTranslations>
<AttributeAllMemberTranslations />
- <Translations>
- <Translation>
<Language>1033</Language>
<Caption>Changeset</Caption>
<Description />
<DisplayFolder />
</Translation>
</Translations>
- <Attributes>
- <Attribute>
<Name>Changeset</Name>
<ID>Changeset</ID>
<Description />
<Type>Regular</Type>
<Usage>Key</Usage>
<EstimatedCount>0</EstimatedCount>
<DiscretizationMethod>None</DiscretizationMethod>
<DiscretizationBucketCount>0</DiscretizationBucketCount>
<OrderBy>AttributeKey</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
<DefaultMember />
<OrderByAttributeID>Changeset ID</OrderByAttributeID>
<NamingTemplate />
<MembersWithData>NonLeafDataVisible</MembersWithData>
<MembersWithDataCaption />
<MemberNamesUnique>false</MemberNamesUnique>
<KeyUniquenessGuarantee>false</KeyUniquenessGuarantee>
<IsAggregatable>true</IsAggregatable>
<AttributeHierarchyEnabled>true</AttributeHierarchyEnabled>
<AttributeHierarchyVisible>true</AttributeHierarchyVisible>
<AttributeHierarchyOrdered>true</AttributeHierarchyOrdered>
<AttributeHierarchyOptimizedState>FullyOptimized</AttributeHierarchyOptimizedState>
<AttributeHierarchyDisplayFolder />
<GroupingBehavior>EncourageGrouping</GroupingBehavior>
- <KeyColumns>
- <KeyColumn>
<DataType>Integer</DataType>
<DataSize>0</DataSize>
<NullProcessing>UnknownMember</NullProcessing>
<Collation />
<Format />
- <Source xsi:type="ColumnBinding">
<TableID>Changeset</TableID>
<ColumnID>__ID</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
- <NameColumn>
<DataType>WChar</DataType>
<DataSize>0</DataSize>
<NullProcessing>Automatic</NullProcessing>
<Collation />
<Format />
- <Source xsi:type="ColumnBinding">
<TableID>Changeset</TableID>
<ColumnID>Changeset</ColumnID>
</Source>
</NameColumn>
- <Translations>
- <Translation>
<Language>1033</Language>
<Caption>Changeset</Caption>
<Description />
<DisplayFolder />
<MembersWithDataCaption />
</Translation>
</Translations>
<NamingTemplateTranslations />
- <AttributeRelationships>
- <AttributeRelationship>
<AttributeID>Changeset ID</AttributeID>
<Name>Changeset ID</Name>
<RelationshipType>Flexible</RelationshipType>
<Cardinality>Many</Cardinality>
<Optionality>Mandatory</Optionality>
<OverrideBehavior>Strong</OverrideBehavior>
- <Translations>
- <Translation>
<Language>1033</Language>
<Caption>Changeset ID</Caption>
<Description />
<DisplayFolder />
</Translation>
</Translations>
</AttributeRelationship>
</AttributeRelationships>
</Attribute>
- <Attribute>
<Name>Changeset ID</Name>
<ID>Changeset ID</ID>
<Description />
- <Annotations xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
- <Annotation>
<Name>Owner</Name>
<Value>Microsoft.VSTS</Value>
</Annotation>
</Annotations>
<Type>Regular</Type>
<Usage>Regular</Usage>
<EstimatedCount>0</EstimatedCount>
<DiscretizationMethod>None</DiscretizationMethod>
<DiscretizationBucketCount>0</DiscretizationBucketCount>
<OrderBy>Key</OrderBy>
<InstanceSelection>DropDown</InstanceSelection>
<DefaultMember />
<OrderByAttributeID />
<NamingTemplate />
<MembersWithData>NonLeafDataVisible</MembersWithData>
<MembersWithDataCaption />
<MemberNamesUnique>false</MemberNamesUnique>
<KeyUniquenessGuarantee>false</KeyUniquenessGuarantee>
<IsAggregatable>true</IsAggregatable>
<AttributeHierarchyEnabled>true</AttributeHierarchyEnabled>
<AttributeHierarchyVisible>true</AttributeHierarchyVisible>
<AttributeHierarchyOrdered>true</AttributeHierarchyOrdered>
<AttributeHierarchyOptimizedState>FullyOptimized</AttributeHierarchyOptimizedState>
<AttributeHierarchyDisplayFolder />
<GroupingBehavior>EncourageGrouping</GroupingBehavior>
- <KeyColumns>
- <KeyColumn>
<DataType>Integer</DataType>
<DataSize>0</DataSize>
<NullProcessing>UnknownMember</NullProcessing>
<Collation />
<Format />
- <Source xsi:type="ColumnBinding">
<TableID>Changeset</TableID>
<ColumnID>Changeset_x0020_ID</ColumnID>
</Source>
</KeyColumn>
</KeyColumns>
- <NameColumn>
<DataType>WChar</DataType>
<DataSize>0</DataSize>
<NullProcessing>Automatic</NullProcessing>
<Collation />
<Format />
- <Source xsi:type="ColumnBinding">
<TableID>Changeset</TableID>
<ColumnID>Changeset_x0020_ID</ColumnID>
</Source>
</NameColumn>
- <Translations>
- <Translation>
<Language>1033</Language>
<Caption>Changeset ID</Caption>
<Description />
<DisplayFolder />
<MembersWithDataCaption />
</Translation>
</Translations>
<NamingTemplateTranslations />
<AttributeRelationships />
</Attribute>
</Attributes>
<Hierarchies />
<StructureVersion>0</StructureVersion>
<DataIDVersion>177</DataIDVersion>
<IncDataIDVersion>177</IncDataIDVersion>
<CacheVersion>199</CacheVersion>
<DataVersion>200</DataVersion>
<LastBindingChange>1601-01-01T00:00:00</LastBindingChange>
<PermissionFileList />
</Dimension>
</ObjectDefinition>
</Load>

200.Changeset.Changeset.lstore:
==============================================================
This file is 415 bytes of what looks like whitespace.




Matt
mthomasq3

Was having problems posting Team System.493.cub.xml so I've pasted it here:

http://paste.tyneo.net/ngxb93-35

Thanks in advance for any help on these issues.

Matt




Matt
mthomasq3

Following the steps specified here did the trick:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=317697&SiteID=1

Well, that and running the "Scrum for Team System" Warehouse Manager to rebuild the Warehouse database afterward.




Matt
mthomasq3
reply 4

You can use google to search for other answers

 

More Articles

Error creating team project with RTM
Team System Warehouse Problems
Symbolic name does not apply everywhere
New Project Creation Problems
RESTORING TFS FROM A BOX ON ONE DOMAIN TO ANOTHER BOX ON ANOTHER ...
Config Microsoft Biztalk Problem
Contributors can edit TFS Project Group Membership?
Cube not updating
TFS Stopped working
Check if the App Pool account is a member of ServiceAccounts grou...
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

Unable to connect TFS Server due to WSS …
Does TFS send alerts/notifications? if s…
Unable to access Team Foundation Server …
Restore TFS to a different server
Problems with libraries being displayed …
Error while installing Team Foundation S…
Move TFS projects
Cannot connet to VMWare TFS from a other…
TF53010: An unexpected condition has occ…
Team Foundation Server Reporting account
How to update the name of a team project
New to TeamSystem & need to share a …
no notifications...
Changes in behavior of the DomainProject…
Trouble Accessing Team Foundation Server…

Hot Articles

Team Explorer : Need log to investigate …
Adding web part on Home page Team founda…
Can TFS build .Net 1.1? products
TF30177: Team Project Creation Failed (t…
SOAP Exception while connecting to TFS p…
TFS and CALs
Strange Error - TF53005 Unable to retrie…
PRoject ALert not working in Team founda…
permissions to users in VSTS
Security behaving strange when adding us…
Can't add project Web Parts to home page
proxy bypassed?????
TF53008: The authentication type Negotia…
Does the Source Control system have any …
Team Foundation Workgroup and Sharepoint

Recommend Articles

error when creating a new project in TFS
Team System - Renaming a team project
System Restore Space
Project Alert Administration
Unable to connect to TFS from client mac…
Rename my projects
Deleted Team Foundation Licensed Users
TF50612 Couldn't Remove Permissions for …
How to reverse a check-out (force check-…
Required permission for Reporting Servic…
Symbolic name does not apply everywhere
TF30170 Error, When i create a new Team …
MOM Management Packs
Error unable to connect to the remote se…
Project ALert is not working in team fou…