TFS reporting service down. Need help.
Dear all:
My team has a TFS server, and after the password of tfs reporting service account was changed, the report service did not work. When I view a report, for example, “bug rate”, it says“Query execution failed for data set 'dsLastProcessedTime”.I tried to follow the guide to change password inhttp://server/reports/TfsOlapReportDS andhttp://server/reports/TfsReportDS. But the same error. So I rebuilt the warehouse use SetupWarehouse.exe, then inhttp://localhost:8080/warehouse/v1.0/warehousecontroller.asmx, click run->invoke, wait until the status became idle. Then process the TfsWarehouse database in analysis service. No error occurs. But When I view report, the error is still“Query execution failed for data set 'dsLastProcessedTime”.In relational database TfsWarehouse, table _WarehouseConfig, there is no item where ID equals to “LastProcessedTime”. Anything wrong? Thanks.
All the best
-Sen
