TFS 2008: Error 32000 while upgrading TFS from 2005 to 2008+SP1

While upgrading Team Foundation Server from 2005 to 2008 with Slipstreamed SP1 you might experiance an error:

Error 32000.The Commandline '"Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\TfsDb.exe" upgrade /server:"SERVER" /property:"TFS_SERVICE_ACCOUNT=SERVER\TFSSERVICE;TFS_REPORTING_ACCOUNT=SERVER\TFSREPORTS;LCID=1033;VSTF_AS_INSTANCE=SERVER;VSTF_AS_DATABASE=TFSWarehouse" /showui:196682' returned non-zero value: 100.

Cause

The TFSWarehouse binaries inside the SQL OLAP data folders got corrupt.

Log snippet:

Upgrading the Warehouse Database (TfsWarehouse)
C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe
-upgrade -int TfsIntegration -s SRV-TFS -d TfsWarehouse -c "C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\Warehouseschema.xml" -a "ITMAR\TFSSERVICE" -ra "ITMAR\TFSREPORTS" -asinst "APPTIER" -asdbname "TFSWarehouse" -asacct ""
C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe -upgrade -int TfsIntegration -s APPTIERNAME -d TfsWarehouse -c "C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\Warehouseschema.xml" -a "DOMAIN\TFSSERVICE" -ra "DOMAIN\TFSREPORTS" -asinst "APPTIERNAME" -asdbname "TFSWarehouse" -asacct ""
An unexpected error occurred: Error in the XML analysis in row 1, column 0: A document must contain exactly one root element.
.
Metadata Manager error. Failed to instantiate of a metadata object from the file '\\?\C:\Data\DB\MSSQL.2\OLAP\Data\TFSWarehouse.0.db\Build Flavor.1587.dim.xml'.

Resolution

Once you see the error, don’t cancel the installation. Backup and delete / rename the TFSwarehouse.0.db folder and click the "retry" for the installation. The installation should go fine.

Content by: Raviku

Reviewed by: Lakhmins