index > Team Foundation Server - Setup > Error getting when trying to build a datawarehouse (Team Foundat...

Error getting when trying to build a datawarehouse (Team Foundat...

Hi,

I am trying to move the data from one TFS server to a different one. after restoring the databases ,when i try to build the warehouse database(sql analysys service-

  1. Expand the Databases node to see the list of databases that make up the Team Foundation Server data tier.

  2. Right-click the TFSWarehouse, and then click Process

end of the process i am getting the following error.

Errors in the high-level relational engine. The data source view does not contain a definition for the '__ID' column in the 'Assembly' table or view.

binod m paul

Hi Binod,

What database(s) are you restoring?

1. The relational TfsWarehouse database.

2. The OLAP database in SQL AS

If you look at the Data Source used by the Data Source View of your cube, is it pointing to the right server?



Patrick Ng - Visual Studio Team Foundation Server
Patrick Ng - MSFT

Hi,

I am following the steps http://blogs.msdn.com/vstsue/articles/558116.aspx

I solved the issue of the __ID column by editing the XML file using the sql business intelligence on the dimensions.

But now i cannot process one dimension called 'Date.dim' ,getting the error "Errors in the back-end database access module. OLE DB reported an overflow of the data type for column 0." Errors in the OLAP storage engine: An error occurred while the 'Date' attribute of the 'Date' dimension from the 'Analysis Services Project2' database was being processed.

is there any issue with the collation setting ?

The default settings in the Tfswarehouse db: Latin1_General_CI_AS

and the default setting in the analysys server :Latin1_General

please tell me solution to solve this issue.

<Dimension xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:dwd="http://schemas.microsoft.com/DataWarehouse/Designer/1.0" dwd:design-time-name="c3d41057-571c-4a00-be4e-73a8caf1e1dd" xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<ID>Date</ID>

<Name>Date</Name>

<CreatedTimestamp>2006-08-02T12:16:20Z</CreatedTimestamp>

<LastSchemaUpdate>2006-08-02T12:16:20Z</LastSchemaUpdate>

<Annotations>

<Annotation>

<Name>Owner</Name>

<Value>Microsoft.VSTS</Value>

</Annotation>

<Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramLayout</Name>

<Value>

<dds xmlns="">

<diagram fontclsid="{0BE35203-8F91-11CE-9DE3-00AA004BB851}" mouseiconclsid="{0BE35204-8F91-11CE-9DE3-00AA004BB851}" defaultlayout="MSDDS.Rectilinear" defaultlineroute="MSDDS.Rectilinear" version="7" nextobject="2" scale="100" pagebreakanchorx="0" pagebreakanchory="0" pagebreaksizex="0" pagebreaksizey="0" scrollleft="-523" scrolltop="-4273" gridx="150" gridy="150" marginx="5000" marginy="5000" zoom="100" x="5398" y="13547" backcolor="15334399" defaultpersistence="2" PrintPageNumbersMode="3" PrintMarginTop="0" PrintMarginBottom="635" PrintMarginLeft="0" PrintMarginRight="0" marqueeselectionmode="0" mousepointer="0" snaptogrid="0" autotypeannotation="1" showscrollbars="0" viewpagebreaks="0" donotforceconnectorsbehindshapes="1" backpictureclsid="{00000000-0000-0000-0000-000000000000}">

<font>

<ddsxmlobjectstreamwrapper binary="01000000900144420100065461686f6d61" />

</font>

<mouseicon>

<ddsxmlobjectstreamwrapper binary="6c74000000000000" />

</mouseicon>

</diagram>

<layoutmanager>

<ddsxmlobj />

</layoutmanager>

<ddscontrol controlprogid="DdsShapes.DdsObjectManagedBridge.1" tooltip="Date (dbo.Date)" left="20" top="0" logicalid="1" controlid="1" masterid="0" hint1="0" hint2="0" width="4313" height="5000" noresize="0" nomove="0" nodefaultattachpoints="0" autodrag="1" usedefaultiddshape="1" selectable="1" showselectionhandles="1" allownudging="1" isannotation="0" dontautolayout="0" groupcollapsed="0" tabstop="1" visible="1" snaptogrid="0">

<control>

<ddsxmlobjectstreaminitwrapper binary="00080000d910000088130000" />

</control>

<layoutobject>

<ddsxmlobj>

<property name="LogicalObject" value="Date" vartype="8" />

</ddsxmlobj>

</layoutobject>

<shape groupshapeid="0" groupnode="0" />

</ddscontrol>

</dds>

</Value>

</Annotation>

<Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowFriendlyNames</Name>

<Value>true</Value>

</Annotation>

<Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:ShowRelationshipNames</Name>

<Value>false</Value>

</Annotation>

<Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:UseDiagramDefaultLayout</Name>

<Value>true</Value>

</Annotation>

<Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortLeft</Name>

<Value>-523</Value>

</Annotation>

<Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramViewPortTop</Name>

<Value>-4273</Value>

</Annotation>

<Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingLeft</Name>

<Value>20</Value>

</Annotation>

<Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramBoundingTop</Name>

<Value>0</Value>

</Annotation>

<Annotation>

<Name>http://schemas.microsoft.com/DataWarehouse/Designer/1.0:DiagramZoom</Name>

<Value>100</Value>

</Annotation>

</Annotations>

<LastProcessed>1699-12-31T00:00:00Z</LastProcessed>

<State>Unprocessed</State>

<Source xsi:type="DataSourceViewBinding" dwd:design-time-name="60294d65-98e3-4489-abe0-53d5c9c9cf8f">

<DataSourceViewID>TfsWarehouseDataSourceView</DataSourceViewID>

</Source>

<Type>Time</Type>

<UnknownMember>Visible</UnknownMember>

<CurrentStorageMode>Molap</CurrentStorageMode>

<Language>1033</Language>

<Collation>Latin1_General_CI_AS</Collation>

<UnknownMemberName>Unknown</UnknownMemberName>

<UnknownMemberTranslations>

<UnknownMemberTranslation dwd:design-time-name="4203546d-ab36-4db8-8978-ff3e5f9b9884">

<Language>1033</Language>

<Caption>Unknown</Caption>

</UnknownMemberTranslation>

</UnknownMemberTranslations>

<Translations>

<Translation dwd:design-time-name="1c6f7277-2dd3-40bf-9fcf-4dcb2fb2f19e">

<Language>1033</Language>

<Caption>Date</Caption>

</Translation>

</Translations>

<Attributes>

<Attribute dwd:design-time-name="4b9b5fdd-8e8b-4172-abb9-0ac21d5f702b">

<ID>Date</ID>

<Name>Date</Name>

<Type>Date</Type>

<Usage>Key</Usage>

<KeyColumns>

<KeyColumn dwd:design-time-name="7d39c03b-6139-4944-8cc6-7e006f605b3c">

<NullProcessing>UnknownMember</NullProcessing>

<DataType>Date</DataType>

<Source xsi:type="ColumnBinding" dwd:design-time-name="bf9966e3-9561-474b-b731-b6912bea4675">

<TableID>Date</TableID>

<ColumnID>ID</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

<NameColumn dwd:design-time-name="2c1fa592-f403-4b3c-9b0c-cd96ee310fbb">

<DataType>WChar</DataType>

<Source xsi:type="ColumnBinding" dwd:design-time-name="2139db2c-855f-4a66-9758-a9b8e6c1f306">

<TableID>Date</TableID>

<ColumnID>Date</ColumnID>

</Source>

</NameColumn>

<Translations>

<Translation dwd:design-time-name="d5c4beda-a98f-4476-b51e-901eb6a29332">

<Language>1033</Language>

<Caption>Date</Caption>

</Translation>

</Translations>

<AttributeRelationships>

<AttributeRelationship dwd:design-time-name="5a9da9b7-1076-4086-bf5a-433a943bf2db">

<AttributeID>UTCDateTime</AttributeID>

<Name>UTCDateTime</Name>

<Translations>

<Translation dwd:design-time-name="3c5f10e2-d67c-460e-9fea-1f20989ed99b">

<Language>1033</Language>

<Caption>UTCDateTime</Caption>

</Translation>

</Translations>

</AttributeRelationship>

<AttributeRelationship dwd:design-time-name="f49acf6a-28b2-4b52-a2ee-c5798cc8ec15">

<AttributeID>YearString</AttributeID>

<Name>YearString</Name>

<Translations>

<Translation dwd:design-time-name="fd916e99-369a-4c6d-bfc2-329bb3da64c4">

<Language>1033</Language>

<Caption>YearString</Caption>

</Translation>

</Translations>

</AttributeRelationship>

<AttributeRelationship dwd:design-time-name="e05dfd39-b800-4124-87ef-2ec3cc90403d">

<AttributeID>Month</AttributeID>

<Name>Month</Name>

<Translations>

<Translation dwd:design-time-name="6b83ba66-a17a-4973-b1ce-abe027bf35e5">

<Language>1033</Language>

<Caption>Month</Caption>

</Translation>

</Translations>

</AttributeRelationship>

<AttributeRelationship dwd:design-time-name="4ec414c1-8bd6-4d95-9624-d51a0cdd8349">

<AttributeID>MonthString</AttributeID>

<Name>MonthString</Name>

<Translations>

<Translation dwd:design-time-name="5d5c96b0-0e5a-43a1-b708-539afc666fe4">

<Language>1033</Language>

<Caption>MonthString</Caption>

</Translation>

</Translations>

</AttributeRelationship>

<AttributeRelationship dwd:design-time-name="cbebc54f-6623-4c05-8ea2-aee818aab8f2">

<AttributeID>Month of Year</AttributeID>

<Name>Month of Year</Name>

<Translations>

<Translation dwd:design-time-name="de939d8a-9c17-4d3e-a0fd-b3196d8c3dd3">

<Language>1033</Language>

<Caption>Month of Year</Caption>

</Translation>

</Translations>

</AttributeRelationship>

<AttributeRelationship dwd:design-time-name="2c3aab3d-3e26-4d62-aa5a-ded39aa6607e">

<AttributeID>Week</AttributeID>

<Name>Week</Name>

<Translations>

<Translation dwd:design-time-name="c17f31c1-55e1-4321-b088-8363e87251ed">

<Language>1033</Language>

<Caption>Week</Caption>

</Translation>

</Translations>

</AttributeRelationship>

<AttributeRelationship dwd:design-time-name="5928d1b9-83a3-4342-8ea8-c6e02805649e">

<AttributeID>WeekString</AttributeID>

<Name>WeekString</Name>

<Translations>

<Translation dwd:design-time-name="7efa820f-93ba-4586-9f72-50ba98c9ca62">

<Language>1033</Language>

<Caption>WeekString</Caption>

</Translation>

</Translations>

</AttributeRelationship>

<AttributeRelationship dwd:design-time-name="2a7e921f-7352-4f40-8a4a-987beda5ba6f">

<AttributeID>Week of Year</AttributeID>

<Name>Week of Year</Name>

<Translations>

<Translation dwd:design-time-name="35979ede-54bc-4abd-b70e-3e955b8c3133">

<Language>1033</Language>

<Caption>Week of Year</Caption>

</Translation>

</Translations>

</AttributeRelationship>

<AttributeRelationship dwd:design-time-name="ed7ff6b2-33a6-4e27-a8e9-05941156c42d">

<AttributeID>Day of Year</AttributeID>

<Name>Day of Year</Name>

<Translations>

<Translation dwd:design-time-name="1a282b5a-1e66-41b4-97e7-b79117ee6162">

<Language>1033</Language>

<Caption>Day of Year</Caption>

</Translation>

</Translations>

</AttributeRelationship>

<AttributeRelationship dwd:design-time-name="6fb7bc4c-3292-45d1-b93c-2ad275b57896">

<AttributeID>Day of Month</AttributeID>

<Name>Day of Month</Name>

<Translations>

<Translation dwd:design-time-name="5bf3ff14-4b99-4426-b4a5-f5846d7710e0">

<Language>1033</Language>

<Caption>Day of Month</Caption>

</Translation>

</Translations>

</AttributeRelationship>

<AttributeRelationship dwd:design-time-name="caf7247b-31e3-4f3b-b3d6-dc0404c5b647">

<AttributeID>Day of Week</AttributeID>

<Name>Day of Week</Name>

<Translations>

<Translation dwd:design-time-name="09d8a4d0-d1ce-49c2-837f-2df38f97e4bd">

<Language>1033</Language>

<Caption>Day of Week</Caption>

</Translation>

</Translations>

</AttributeRelationship>

</AttributeRelationships>

<OrderBy>Key</OrderBy>

<InstanceSelection>DropDown</InstanceSelection>

</Attribute>

<Attribute dwd:design-time-name="b4d08391-fd06-44da-9c18-6e3f79314ee0">

<Annotations>

<Annotation>

<Name>Owner</Name>

<Value>Microsoft.VSTS</Value>

</Annotation>

</Annotations>

<ID>UTCDateTime</ID>

<Name>UTCDateTime</Name>

<KeyColumns>

<KeyColumn dwd:design-time-name="d61f0d83-077d-4144-a2ca-45eaea6f74ad">

<NullProcessing>UnknownMember</NullProcessing>

<DataType>Date</DataType>

<Source xsi:type="ColumnBinding" dwd:design-time-name="c3b4f2ca-6fb8-4a3a-b749-195f98145faa">

<TableID>Date</TableID>

<ColumnID>UTCDateTime</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

<NameColumn dwd:design-time-name="fe7bdda9-32f3-4e90-911d-c4a909d3b608">

<DataType>WChar</DataType>

<Source xsi:type="ColumnBinding" dwd:design-time-name="61ca5f19-5d73-4694-9526-dc078192e486">

<TableID>Date</TableID>

<ColumnID>UTCDateTime</ColumnID>

</Source>

</NameColumn>

<Translations>

<Translation dwd:design-time-name="a615bb91-c78f-40f9-ae4d-a06b59c8e687">

<Language>1033</Language>

<Caption>UTCDateTime</Caption>

</Translation>

</Translations>

<OrderBy>Key</OrderBy>

<AttributeHierarchyVisible>false</AttributeHierarchyVisible>

<InstanceSelection>DropDown</InstanceSelection>

</Attribute>

<Attribute dwd:design-time-name="c487f9e5-36e5-40a9-a7b0-a4f38990298c">

<Annotations>

<Annotation>

<Name>Owner</Name>

<Value>Microsoft.VSTS</Value>

</Annotation>

</Annotations>

<ID>Year</ID>

<Name>Year</Name>

<Type>Years</Type>

<KeyColumns>

<KeyColumn dwd:design-time-name="abfa0d6b-963f-4fc8-b6d7-a58dd767d663">

<NullProcessing>UnknownMember</NullProcessing>

<DataType>Date</DataType>

<Source xsi:type="ColumnBinding" dwd:design-time-name="7feb377d-72eb-48fc-9c0b-d34d82fc1859">

<TableID>Date</TableID>

<ColumnID>Year</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

<NameColumn dwd:design-time-name="ce0e0aa0-8b43-4721-8d34-96bcd2d0b625">

<DataType>WChar</DataType>

<Source xsi:type="ColumnBinding" dwd:design-time-name="8554d6e2-432b-46cb-a9c5-25ddd8f07f3e">

<TableID>Date</TableID>

<ColumnID>YearString</ColumnID>

</Source>

</NameColumn>

<Translations>

<Translation dwd:design-time-name="dd34441f-7d66-432f-a139-f6b670f4d739">

<Language>1033</Language>

<Caption>Year</Caption>

</Translation>

</Translations>

<OrderBy>Key</OrderBy>

<AttributeHierarchyVisible>false</AttributeHierarchyVisible>

<InstanceSelection>DropDown</InstanceSelection>

</Attribute>

<Attribute dwd:design-time-name="01287bc9-efb8-491b-81b0-6fe9a9eeeff8">

<Annotations>

<Annotation>

<Name>Owner</Name>

<Value>Microsoft.VSTS</Value>

</Annotation>

</Annotations>

<ID>YearString</ID>

<Name>YearString</Name>

<KeyColumns>

<KeyColumn dwd:design-time-name="2c93ca92-dde5-4e15-8a5d-b0f785d19000">

<NullProcessing>UnknownMember</NullProcessing>

<DataType>WChar</DataType>

<DataSize>30</DataSize>

<Source xsi:type="ColumnBinding" dwd:design-time-name="45ac0566-4cb9-43fd-81c4-dbc86b88b255">

<TableID>Date</TableID>

<ColumnID>YearString</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

<NameColumn dwd:design-time-name="a93e5ce6-ca65-4a90-910b-7c30feb17a99">

<DataType>WChar</DataType>

<Source xsi:type="ColumnBinding" dwd:design-time-name="899ae3fa-039a-4fc9-9d9e-2d7870d734d4">

<TableID>Date</TableID>

<ColumnID>YearString</ColumnID>

</Source>

</NameColumn>

<Translations>

<Translation dwd:design-time-name="9331b1e2-be22-45e6-97b1-79d2023b63f7">

<Language>1033</Language>

<Caption>YearString</Caption>

</Translation>

</Translations>

<OrderBy>Key</OrderBy>

<AttributeHierarchyVisible>false</AttributeHierarchyVisible>

<InstanceSelection>DropDown</InstanceSelection>

</Attribute>

<Attribute dwd:design-time-name="5ac4e86d-ea2e-4ba1-bb92-5ad2e89c4126">

<Annotations>

<Annotation>

<Name>Owner</Name>

<Value>Microsoft.VSTS</Value>

</Annotation>

</Annotations>

<ID>Month</ID>

<Name>Month</Name>

<Type>Months</Type>

<KeyColumns>

<KeyColumn dwd:design-time-name="be104bf3-e4c6-4a0e-bc8c-cc1cf58a2d95">

<NullProcessing>UnknownMember</NullProcessing>

<DataType>Date</DataType>

<Source xsi:type="ColumnBinding" dwd:design-time-name="48e40fd3-0070-4e12-a783-cf114eafdead">

<TableID>Date</TableID>

<ColumnID>Month</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

<NameColumn dwd:design-time-name="137317e8-8521-4308-92ec-6b7f2ada9883">

<DataType>WChar</DataType>

<Source xsi:type="ColumnBinding" dwd:design-time-name="b4ac6efc-c1f4-4c3e-a92d-7a87dd1098fe">

<TableID>Date</TableID>

<ColumnID>MonthString</ColumnID>

</Source>

</NameColumn>

<Translations>

<Translation dwd:design-time-name="cb9cbe2a-5527-46e5-94eb-ebf717fe928e">

<Language>1033</Language>

<Caption>Month</Caption>

</Translation>

</Translations>

<AttributeRelationships>

<AttributeRelationship dwd:design-time-name="fb5ed380-28b9-4922-a9c4-d2270e8f2ecd">

<AttributeID>Year</AttributeID>

<Name>Year</Name>

<Translations>

<Translation dwd:design-time-name="0706cbba-e910-4493-a0c7-1497b4b4f2fe">

<Language>1033</Language>

<Caption>Year</Caption>

</Translation>

</Translations>

</AttributeRelationship>

</AttributeRelationships>

<OrderBy>Key</OrderBy>

<AttributeHierarchyVisible>false</AttributeHierarchyVisible>

<InstanceSelection>DropDown</InstanceSelection>

</Attribute>

<Attribute dwd:design-time-name="4744f85b-e642-405c-ba5c-42805e40e7bd">

<Annotations>

<Annotation>

<Name>Owner</Name>

<Value>Microsoft.VSTS</Value>

</Annotation>

</Annotations>

<ID>MonthString</ID>

<Name>MonthString</Name>

<KeyColumns>

<KeyColumn dwd:design-time-name="7d67a3e5-4262-4357-a25e-2c219c35f5e4">

<NullProcessing>UnknownMember</NullProcessing>

<DataType>WChar</DataType>

<DataSize>30</DataSize>

<Source xsi:type="ColumnBinding" dwd:design-time-name="388f189e-52aa-4ad0-92fa-c3049c8a2999">

<TableID>Date</TableID>

<ColumnID>MonthString</ColumnID>

</Source>

</KeyColumn>

</KeyColumns>

<NameColumn dwd:design-time-name="1a347877-9bdb-4f2a-a6b8-02a4ad67ca2f">

<DataType>WChar</DataType>

<Source xsi:type="ColumnBinding" dwd:design-time-name="3e6134af-d565-4b2d-af12-cceaf6a5b643">

<TableID>Date</TableID>

<ColumnID>MonthString</ColumnID>

</Source>

</NameColumn>

<Translations>

<Translation dwd:design-time-name="1a54f7cd-0f61-4e98-b59d-9b830b67fe7c">

<Language>1033</Language>

<Caption>MonthString</Caption>

</Translation>

</Translations>

<OrderBy>Key</OrderBy>

<AttributeHierarchyVisible>false</AttributeHierarchyVisible>

<InstanceSelection>DropDown</InstanceSelection>

</Attribute>

<Attribute dwd:design-time-name="ddb51e2b-cafa-49c2-9d2c-8fa71d498079">

<Annotations>

<Annotation>

<Name>Owner</Name>

<Value>Microsoft.VSTS</Value>

</Annotation>

</Annotations>

<ID>Month of Year</ID>

<Name>Month of Year</Name>

<Type>MonthOfYear</Type>

<KeyColumns>

<KeyColumn dwd:design-time-name="6554b1b3-c9a2-4cdc-adb6-cdbf6cc8d2f8">

<NullProcessing>UnknownMember</NullProcessing>

<<