Updating from TFS 2012 Update 1 to TFS 2012 Update 4 – Problem with Upgrade Warehouse

My team recently needed to update from TFS 2012 Update 1 to TFS 2012 Update 4, but ran into a problem during the upgrade:

Upgrade Error

Looking closer at the log file, it had this information:

XML parsing failed at line 1, column 0: A document must contain exactly one root element.
.
Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, ‘\\?\d:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\Team System.8676.cub.xml’.

[Info @22:20:14.393] Microsoft.AnalysisServices.OperationException: XML parsing failed at line 1, column 0: A document must contain exactly one root element.
.
Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, ‘\\?\d:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\Team System.8676.cub.xml’.

To get around this we:

  1. Restored the TFS_Configuration and TFS_[Collections] databases to their pre-upgrade state
  2. Re-ran the upgrade wizard, but this time unchecked the Reporting portion of the upgrade. This causes the installer to ignore the warehouse and analysis services part of the install
  3. After the install completed, we deleted the tfs_warehouse and tfs_analysis databases
  4. Following instructions from this TFS Setup Support blog post, rebuilt the warehouse and analysis databases

Upgrade complete!

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s