- 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.
- Fehler beim Ausführen der Abfrage für das PlatformParam-Dataset. (rsErrorExecutingCommand)
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.
Keine Kommentare:
Kommentar veröffentlichen