The Team System cube either does not exist or has been processed

Question

I've not been able to get any reports working. I get the error message that the cube either does not exist or has not been processed. I've ran the rebuild via 'SetupWarehouse' and then ran the web service to run the build. I ran the 'GetWarehouseStatus' method and see it go through different status until idle was displayed but the error is still the same.

I have not had this working since initially installing so I'm not sure what I've done wrong. I've followed all the steps in the troubleshooting, restarting services etc, but nothing seems to work.

I'm using VS 2008 with SQL 2008 and I have a seperate application and data tier.

Any ideas what I can check.

Regards

Answer 1

Hi Mike,

Can you try to connect to the SQL Analysis server on the TFS box using the SQL Management Studio and manually process the cube? Once you connect, browse to the TFS cube, right-click and Reprocess it. If there are any errors, you may get more details to help you further troubleshoot.

Thanks,
Alin,
PRAKTIK Consulting
TFS Hosting and TFS Consulting Services.

Answer 2

Hi Mike,

Welcome to MSDN forum.

Please following Warehouse Troubleshooting Guide to identify what's wrong when OLAP process.

Please also check if there is error or warning in windows event log from SSAS. Thanks.
 

Hongye Sun [MSFT]
MSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg @ microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 3

Is this issue resolved? Thanks.

Hongye Sun [MSFT]
MSDN Subscriber Support in Forum
If you have any feedback on our support, please contact msdnmg @ microsoft.com

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.