TF255322 while rebuilding Tfs_Analysis


  • I tried to rebuild my Tfs_Analysis, as it got corrupted ("Errors in the metadata manager. An error occurred when loading the Team System cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\Tfs_Analysis.0.db\Team System.1712.cub.xml'.", etc).

    I followed the instructions mentioned here: (stop analysis services, delete Tfs_Analysis files, start the service, start rebuild from TFS Administration Console - Reporting).

    When I try to start rebuild, an error occurs:
    TF255322: The installation parameters specify the use of an existing database, but the database could not be found. The database name is: Tfs_Analysis. The server hosting the database is <tfs server name>".

    When I log to Analysis Services using MSSMS I see there is indeed no Tfs_Analysis DB there.

    I found many manuals advising to drop Tfs_Analysis (and Tfs_Warehouse) before rebuilding them, so I assumed having Tfs_Analysis DB is not necessary to rebuild (also, rebuild procedure is supposed to drop them anyway), but it looks like they are.

    What can I do now? I don't have Tfs_Analysis backup (what's the point if I can always rebuild it?...).

    Best Regards,

    Agnieszka Puzio

    venerdì 9 marzo 2012 17:32