An error has occurred during report processing. (rsProcessingAborted)


Error:

You receive the following error message when opening a TFS report:
    An error has occurred during report processing. (rsProcessingAborted)
       Query execution failed for dataset 'dsIteration'. (rsErrorExecutingCommand)
           The Team System cube eitehr does not exist or has not been processed.


It means: the cube has not been processed.

Solution:

To access the Warehouse Control Web Service
1. Log on to the application-tier server.
2. Open Internet Explorer, type the following string in the Address bar, and then press ENTER:http://localhost:8080/ VirtualDirectory /TeamFoundation/Administration/v3.0/WarehouseControlService.asmx
The WarehouseControlWebService page opens.
Determine the Processing Status
1. From the WarehouseControlWebService page, click GetProcessingStatus, and then click Invoke.A new browser window will open and indicate the processing status.
      A value of Idle indicates that the synchronization job is currently not running. You should process the data warehouse or the cube only when the processing status for these jobs is Idle. If a different value is returned, repeat this step until Idle is returned for the job that you want to process.
Process the Data Warehouse Manually
1. From the WarehouseControlWebService page, click ProcessWarehouse, and then click Invoke.A new browser window will open. The service returns True when it successfully starts the processing of the warehouse and False if it is not successful. A value of False indicates that the warehouse is currently being processed.
2. To determine when the warehouse has been processed, return to the WarehouseControlWebService page, click GetProcessingStatus, and then click Invoke.
      Warehouse processing is completed when the GetProcessingStatus service returns a value of Idle for all jobs.
Process the Analysis Services Cube Manually
1. From the WarehouseControlWebService page, click ProcessAnalysisDatabase.
 
2. On the ProcessAnalysisDatabase page, in processingType, type either Incremental or Full, and then click Invoke.
      If you specify Incremental, data is processed only if it has been added since the most recent processing. If you specify Full, all data is processed as if the warehouse were being rebuilt. Full processes take longer to perform and should be performed only when required (for example, when a team project or project collection has been removed or deleted).
      A new browser window will open. The service returns True when it successfully starts the processing of the cube and False if it is not successful. A value of False indicates that the cube is currently being processed.
  
3. To determine when the cube has been processed, return to the WarehouseControlWebService page, click GetProcessingStatus, and then click Invoke.
      Cube processing is completed when the GetProcessingStatus service returns a value of Idle for all jobs.
Ebook Download
View all
Learn
View all
F11Research & Development, LLC