Hey Folks,

I recently installed Team Foundation Server with the Option Dual-Server Installation and everything seems to work, BUT....

When I create a new Team Project, I get alway the same Error when something needs Reporting Services

-> rsProcessingAborted and rsErrorExecutingCommand when he wants to access the IterationParam-Dataset. It Tells me, that the System-Cube is not available or  could not be processed.

The Reporting Services are Up and running.

In my Example I created a  'MSF for Agile Software Development - v4.0' Project

I also tried to solve this in the ControllerService Interface

http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx

I can run the WareHouseStatus from the ControllerService and it is RunningAdapetrs, but some time later it is idle again. The Reinitialize Method there, seems not to work, I get an HTTP 500 error.

Thx and greez

      Karsten

Hi,

Do you see any errors in the event log of your application tier?

Thanks,
Othmane

Hi,

I just solved the Problem.

The main Problem was the System_Cube from the Analysis Service. I had to delete it from the Analysis Database and manually recreate it.

I found a Solution under the Warehouse Troiubleshooting Guide http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=154526&SiteID=1

<------------------------------------------------------->

Resolution: Rebuild the OLAP schema and cube

1) Back up all data

2) Delete the TFSWarehouse database in *Analysis Services* (I don't believe this is absolutely necessary but doesn't hurt if you back it up).
3) From a command prompt on the TFS Application Tier machine, use the following command (substituting the correct values for your installation in place of the following values: ServerName, Domain\TFSService, Domain\TFSReports):

%ProgramFiles%\Microsoft Visual Studio 2005 Team Foundation Server\Tools\setupwarehouse.exe -o -s ServerName -d TfsWarehouse -c Warehouseschema.xml -a Domain\TFSService -ra Domain\TFSReports

Note: -o is the important param here which causes the OLAP cube to get rebuilt.

<------------------------------------------------------->

After that, I rerun the Warehouse Service under http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx and that was it !

greez Karsten