index > Team Foundation Server - Administration > Date overflow rebuilding TfsWarehouse cube when moving servers

Date overflow rebuilding TfsWarehouse cube when moving servers

I am moving my TFS databases from one server to another on the same domain, using the How to: Restore Team Foundation Server Data to a Different Server http://msdn2.microsoft.com/en-us/library/ms252516.aspx

I have run SetupWarehouse.exe successfully, but when I try to process TfsWarehouse cube, I get the following error:

Processing Dimension 'Date' failed.
Processing Dimension Attribute 'Date' failed

SQL Queries: 1

SELECT
DISTINCT
[Date].[__ID] AS [Date__ID0_0],[Date].[Date] AS [DateDate0_1],[Date].[UTCDateTime] AS [DateUTCDateTime0_2],[Date].[YearString] AS [DateYearString0_3],[Date].[Month] AS [DateMonth0_4],[Date].[MonthString] AS [DateMonthString0_5],[Date].[Month of Year] AS [DateMonth_x0020_of_x0020_Year0_6],[Date].[Week] AS [DateWeek0_7],[Date].[WeekString] AS [DateWeekString0_8],[Date].[Week of Year] AS [DateWeek_x0020_of_x0020_Year0_9],[Date].[Day of Year] AS [DateDay_x0020_of_x0020_Year0_10],[Date].[Day of Month] AS [DateDay_x0020_of_x0020_Month0_11],[Date].[Day of Week] AS [DateDay_x0020_of_x0020_Week0_12]
FROM [dbo].[Date] AS [Date]

Error messages:

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 'TfsWarehouse' database was being processed.

Can anyone shed light on what's going on?

Craig Lebowitz

Can you check the system date on the "from" and "to" servers to see if they're wildly off? Are both in the same time zone?

This clearly shouldn't have happened, but that'll at least narrow down the scope of what went wrong.

Team Foundation Server - http://blogs.msdn.com/jmanning/

James Manning - MSFT

The schema for the data tier has changed and the primary key of the TfsWarehouse.date table was an integer instead of the date used now.

I was able to resolve the problem with the help of Brad Peterson at TFS support. He led me through the use of a tool that converts old versions of the TFSWarehouse database to the latest schema. The processing worked after that.

Craig Lebowitz

reply 3