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
Reporting Services Error
su45937
Hi,
Do you see any errors in the event log of your application tier
Thanks,
Othmane
David Turner
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