TFS2010 - TFSWarehouse analysis database missing in Analysis Server

Question

I have [TFS-A] is running now. I backup [TFS-A] databases and restored it into new [TFS_AppTier-B] and [TFS_DataTier-B].

Everything works just perfect in [TFS_AppTier-B] and [TFS_DataTier-B] except the TFS Reporting for TfsReportDS and TfsOlapReportDS. Because these datasource point to "Data source=[TFS_DataTier-B];initial catalog=TfsWarehouse".

The old MSF_Agile_4.0 Team Project which created before TFS2010 (created at TFS2005 or TFS2008) has reporting working fine.
The old MSF_Agile_4.0 Team Project which created after TFS2010 has reporting error message.

I use SSMS to connect to the 2 Analysis Servers [TFS-A] and [TFS_DataTier-B] and I found something is wrong... The TfsWarehouse database is missing at [TFS_DataTier-B] Analysis Server... Well, this is funny. I already follow all the steps for Rebuilding Warehouse which taught from MSDN...

[TFS-A]

[TFS_DataTier-B]

Any idea why?

Answer 1

TFSWarehouse is not a Analysis Server database, but a relational database.

---

Please remember to mark the replies as answers if they help.

Answer 2

There is a TfsWarehouse Analysis Database if the TFS2010 last upgraded from TFS2008 and TFS2005.

Answer 3

The TfsOlapReportDS should connect to the Tfs_Analysis cube and the TfsReportDS should connect to the TfsWarehouse database in your relation store.

---

Please remember to mark the replies as answers if they help.

Answer 4

I tried that too.

The rdl reporting error message from the old TfsOlapReportDS and TfsReportDS:
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for dataset 'IterationParam'. (rsErrorExecutingCommand)
Either the user, <domain>\<tfsreports> does not have access to the TFSWarehouse database, or the database does not exist.

When I do comparison, the dimensions are different set.

There is no 'Iteration' dimensions in the newly installed Tfs_Analysis.

Answer 5

Are you sure that the service account can read the TfsWarehouse database?

Did you check whether the database exists in the Database Engine?

---

Please remember to mark the replies as answers if they help.

Answer 6

TfsWarehouse exists in the SQL Database. I did the comparison from the both SQL instance and only find out one different is the newly installed clean TFS2010 has running without TfsWarehouse analysis database.

The old TfsOlapReportDS could not locate the TfsWarehouse analysis database.

Answer 7

Change the connection string for TfsOlapReportDS to use Tfs_Analysis instead.

---

Please remember to mark the replies as answers if they help.

Answer 8

Like I said, it doesn't have [Iteration] dimension.

    An error has occurred during report processing. (rsProcessingAborted)
        Query execution failed for dataset 'IterationParam'. (rsErrorExecutingCommand)
            The dimension '[Iteration]' was not found in the cube when the string, [Iteration].[Parent_ID].[TfsReports], was parsed.

Even I check to the orginal [TFS-A] Tfs_Analysis analysis database's dimension, there is no [Iteration] dimension included too...

Answer 9

Can I try to backup and restore TfsWarehouse Analysis Database from [TFS_A] to [TFS_DataTier_B] and then modify the Data Source?

Answer 10

I did run into an old blog post of me: http://www.ewaldhofman.nl/post/2010/04/27/TFS-2010-did-not-update-the-Warehouse-and-Cube.aspx

Maybe it is the case for you too?

---

Please remember to mark the replies as answers if they help.

Answer 11

I don't think that will work. Very obvious, [Iteration] dimension is missing.

[TFS_AppTier-B] and [TFS_DataTier-B] are totally new server and they don't have data that last configured from TFS2005 and TFS2008.

I ran across WSS 3.0 problems with VSTS_MSF_Agile and VSTS_MSF_CMMI issue, but it managed to solve by getting the STP files from TFS2008 installation disc. See, it is not included in the single server to dual servers migration MSDN tutorial. And some other WSS stuffs which I forget as well.

This Reporting Service is the final thing that I want to make sure so everything will work just in perfect :)

Answer 12

I guess I will go hard way [TFSWarehouse analysis database] restoration and customization. That's the only option left as I can do.

Answer 13

Restoring the TfsWarehouse analysis database from [TFS-A] into [TFS_DataTier-B] and just change the TfsWarehousedatasource to the new instance SOLVED THIS PROBLEM. VSTS_MSF for 4.0 and 4.2 reports still need TfsWarehouse analysis database to run the reports.

This should be document in MSDN. The TFS2010 which migrated from TFS2008/TFS2005 will still need TFSWarehouse analysis database to be restored to the newer machine.

Answer 14

Hi lannyboy,

Thank you for your question.

I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

Thank you for your understanding and support.

Best regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us