Dienstag, 13. Februar 2007

Der Team System-Cube ist nicht vorhanden oder wurde nicht verarbeitet

Unser TFS-Sever hat statt den Reports nur folgendes angezeigt:
  • Fehler bei der Berichtsverarbeitung. (rsProcessingAborted)
    • Fehler beim Ausführen der Abfrage für das PlatformParam-Dataset. (rsErrorExecutingCommand)
      • Der Team System-Cube ist nicht vorhanden oder wurde nicht verarbeitet.
Also Google fragen...
Auf Englisch heisst die Fehlermeldung wohl:
The Team System cube either does not exist or has not been processed
Und dazu findet man in diesem Blog-Eintrag einen Verweis auf diese Anleitung:

This might be due to a known Analysis Services issue that can be fixed by applying the SQL Server 2005 KB914595 HotFix from http://msdn.microsoft.com/vstudio/teamsystem/downloads/

If this does not work, I would recommend deleting the cube and recreating the warehouse by following the following steps:

Step 1:
Stop the SQL Server Analysis Services – Use Management Studio - Connect to Analysis Services - Right click on the Analysis Server and select Stop.
Make a copy of the Analysis Server “data” folder for backup. Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data
Delete the Data Folder
Restart Analysis Services.

Step 2
Run the setupWarehouse command from the application tier:
C:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Tools\Setupwarehouse.exe -rebuild -mturl :8080" href="http://%3capp_tier%3e:8080/">http://:8080 -c warehouseschema.xml -s -d TfsWarehouse -a \ -ra \

is the name of the app tier server.
is the name of the data tier server
\ is the account used for TFS Services (set in your domain)
\

Wait for this process to complete.

Step 3:
From the application tier server
Open http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx.
Click Run and then click Invoke.
Open http://localhost:8080/Warehouse/v1.0/warehousecontroller.asmx.
Click GetWarehouseStatus, and then click Invoke.
Wait for the service to idle. The service should return Running Adapters, ProcessingOlap, and then idle. The four possible return states are:
Idle: The warehouse is not processing.
RunningAdapters: The adapters are applying schema changes or pulling data into the warehouse.
ProcessingOlap: The warehouse is processing schema changes or data changes in the OLAP cube.
Blocked: The warehouse is blocked.

Step 4:
Process the TFSwarehouse in Analysis Service using Management Studio.


( Warehouse Cube Won't Process - B3Refresh Upgraded OK )

Keine Kommentare: