TFS 2005 to 2008 Upgrade: While upgrading, Error 32000 due to a bad TFSWarehouse cube.

  • Article

Cheers everyone, One of our fellow engineers "Vimal" brings this content,

While upgrading from 2005 to 2008you might encounter an error

Error 32000.The Commandline '"D:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\TfsDb.exe" upgrade /server: <ServerName> /property:"TFS_SERVICE_ACCOUNT=domainname\TFSService;TFS_REPORTING_ACCOUNT=domainname\TFSREPORTS;LCID=1033;VSTF_AS_INSTANCE=<ServerName>;VSTF_AS_DATABASE=TFSWarehouse;VSTF_AS_ACCOUNT=" /showui:131562' returned non-zero value: 100.

Cause: TfsWarehouse cube was corrupt

Resolution:

1) Do not close the upgrade wizard.

2) Take a backup of the TfsWarehouse cube from Analysis Services.

a) To backup the TfsWarehouse cube, Open SQL Server Management Studio and connect to the “Analysis Services” instance.

b) Browse to the TfsWarehouse cube node and right click on the cube

c) Select “backup” and in the backup wizard, browse a location to save the backup file

3) Delete the TfsWarehouse cube

a) To delete the TfsWarehouse cube, while in SQL Server Management Studio connected to the “Aanalysis Services” instance, browse to TfsWarehosue cube

b) Right click the TfsWarehouse cube and select “delete”

Note: as a best practice, verify that the “TFSWarehouse.0.db” folder gets deleted when the TfsWarehouse cube is deleted from Analysis Services. This folder is located in the Data folder of the OLAP binaries (<sys dir>:\Program Files\Microsoft SQL Server\MSSQL.<inst ID>\OLAP\Data\). If not deleted, stop “SQL server Analysis Services” service and manually delete the folder and start the service.

4) Hit retry to complete the upgrade.

Content Developed by: Vimal

Reviewed by: Lucky