index > Team Foundation Server - Reporting > Unable to access any of the reports.

Unable to access any of the reports.


I'm trying to get the reports in Team System up and running. When I bring up the reports I get the following error:

  • An error has occurred during report processing. (rsProcessingAborted)
    • Query execution failed for data set 'dsIterationParam'. (rsErrorExecutingCommand)
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors

I've conntected to http://localhost:8080/warehouse/v1.0/warehousecontroller.asmx and done a GetWarehouseStatus, but all I get is 'Idle'. So I checked the application event log and found the following error. The system has been up and running for a while, but we never implemented reports. Any help would be appreciated.

TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.

Technical Information (for the administrative staff):

Date (UTC): 8/2/2006 2:53:19 PM

Machine: DT-TEAMSYSTEM

Application Domain: /LM/W3SVC/3/Root/Warehouse-5-127990038543850000

Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727

Process Details:

Process Name: w3wp

Process Id: 476

Thread Id: 1388

Account name: SAFETRAC\amorales

Detailed Message: TF30065: An unhandled exception occurred.

Web Request Details

Url: http://dt-teamsystem:8080/Warehouse/warehousecontroller.asmx [method: GET]

User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)

Headers: Connection=Keep-Alive&Accept=*%2f*&Accept-Encoding=gzip%2c+deflate&Accept-Language=en-us&Authorization=NTLM+TlRMTVNTUAADAAAAGAAYAIIAAAAYABgAmgAAABAAEABIAAAAEAAQAFgAAAAaABoAaAAAAAAAAACyAAAABYKIogUCzg4AAAAPcwBhAGYAZQB0AHIAYQBjAGEAbQBvAHIAYQBsAGUAcwBEAFQALQBUAEUAQQBNAFMAWQBTAFQARQBNABcAB2JY9KCKAAAAAAAAAAAAAAAAAAAAABUSK80CzaNwkKspmhluCdl4OlmVWMQrTw%3d%3d&Host=dt-teamsystem%3a8080&User-Agent=Mozilla%2f4.0+(compatible%3b+MSIE+6.0%3b+Windows+NT+5.2%3b+SV1%3b+.NET+CLR+1.1.4322%3b+.NET+CLR+2.0.50727)&UA-CPU=x86

Path: /Warehouse/warehousecontroller.asmx

Local Request: True

Host Address: 10.20.3.38

User: SAFETRAC\amorales [authentication type: NTLM]

Exception Message: The file '/Warehouse/warehousecontroller.asmx' does not exist. (type HttpException)

Exception Stack Trace: at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath)

at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)

at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile)

at System.Web.Compilation.BuildManager.GetVPathBuildResult(HttpContext context, VirtualPath virtualPath)

at System.Web.UI.WebServiceParser.GetCompiledType(String inputFile, HttpContext context)

at System.Web.Services.Protocols.WebServiceHandlerFactory.GetHandler(HttpContext context, String verb, String url, String filePath)

at System.Web.HttpApplication.MapHttpHandler(HttpContext context, String requestType, VirtualPath path, String pathTranslated, Boolean useAppConfig)

at System.Web.HttpApplication.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()

at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)




QA
AaronJ

Hi Aaron,

Please navigate to http://localhost:8080/warehouse/v1.0/warehousecontroller.asmx

and click "Run"

Then go back and choose "GetWarehouseStatus" -- does it still say Idle?

After you do that, please check the event log again and see if there are any issues.

Let's see if we can figure out what's going on here.

thanks,

mauli

Mauli Shah - MSFT

I actually did see 'ProcessingOlap' come up. Here's the error I found in the application event log.

TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff.

Technical Information (for the administrative staff):

Date (UTC): 8/2/2006 5:49:14 PM

Machine: DT-TEAMSYSTEM

Application Domain: /LM/W3SVC/3/Root/Warehouse-4-127990133325354900

Assembly: Microsoft.TeamFoundation.Warehouse, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a; v2.0.50727

Process Details:

Process Name: w3wp

Process Id: 2604

Thread Id: 4740

Account name: SAFETRAC\amorales

Detailed Message: Cube processing runtime error: \r\nSystem.Threading.ThreadAbortException: Thread was being aborted.

at System.Net.UnsafeNclNativeMethods.OSSOCK.setsockopt(SafeCloseSocket socketHandle, SocketOptionLevel optionLevel, SocketOptionName optionName, Int32& optionValue, Int32 optionLength)

at System.Net.Sockets.Socket.SetSocketOption(SocketOptionLevel optionLevel, SocketOptionName optionName, Int32 optionValue, Boolean silent)

at System.Net.Sockets.TcpClient.set_NoDelay(Boolean value)

at Microsoft.AnalysisServices.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)

at Microsoft.AnalysisServices.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)

at Microsoft.AnalysisServices.Server.Connect(String connectionString, String sessionId)

at Microsoft.AnalysisServices.Server.Connect(String connectionString)

at Microsoft.TeamFoundation.Warehouse.OlapCreator.ProcessOlap(Boolean schemaUpdated, UpdateStatusStore updateStatus)

at Microsoft.TeamFoundation.Warehouse.AdapterScheduler.RunCubeProcess()




QA
AaronJ

Hi Aaron,

Thanks for the reply. It looks like the thread running the warehouse processing was aborted - this happens from time to time - we're working on mitigating that. You can rerun the processing and it should pick up again. Please try processing the warehouse again, and let me know if there are any issues.

Thanks,
Mauli

Mauli Shah - MSFT

Sorry, I haven't replied back in a while. We're in the middle of a release cycle. We are still getting the same errors I mentioned. Is there somewhere else for me to check any error logs?

  • An error has occurred during report processing. (rsProcessingAborted)
    • Query execution failed for data set 'dsIterationParam'. (rsErrorExecutingCommand)
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors



QA
AaronJ
reply 5

You can use google to search for other answers

 

More Articles

Merged Changesets Report
An attempt has been made to use a data extension 'DLLName' that i...
msmdsrv using 50% cpu for minutes
How do i edit or delete reports?
Code Reviewer Report
Setting for URL in Reporting services
How do i modify the filter on a report
cube versus warehouse
Importance of Work Items - Remaining Work
Reports not accessible through project portal by remote user
Welcome to Bokebb   New Update   Joins the collection  
 

New Articles

Failed to load adapter
how to create entirely new report
Reports List in the Portal
Not all work items are displayed.
Missing TfsReportDS and TfsOlapReportDS
Error executing reports in RTM Trial
Quality Indicators Report
schedulingfinishdate error + how to add …
report stops showing data - warehouse no…
Datawarehouse, how can I do?
Merged Changesets Report
More Warehouse problems
URL for the 50 standard TFS reports
Datagrid row style
Standard team project reports have empty…

Hot Articles

Reporting completed work per person retu…
How to create report on custom defined p…
Error executing reports in RTM Trial
Setting for URL in Reporting services
How "State Change Count" Measu…
Does Business Intelligence Development S…
Adding Data Region to existing items
Shelveset Report
Deploying cube so as to make reports bas…
Reporting on Plain Text Fields in Work I…
DateTimes become Dates in Warehouse/Repo…
Issues with dimension after following wa…
Filter on #current work items
What is the formal definition of Priorit…
Restoring reports for a team project

Recommend Articles

How to force Repository Refresh?
Churn report
Possible Bug in Warehouseadapter
When trying to add a new VS2005 RDL file…
Report for finding Defect/Bug Frequency
Reports using customized Workitems
How to accss Symptom and StepsToReproduc…
NullReferenceException during Code Churn…
Error in Reporting
How to update 2005 report definitions to…
Can not find any Perspective other than …
date current state was set
How is unplanned work report calculated?
More Warehouse problems
Bug Rates Report - Getting very weird re…