Exports are failing
We have a website written in .net, which incorporates a reporting mechanism based on SSRS. The site displays a list of available reports, and on clicking one launches the report from the report server in a new tab/window, but rendered through a .net
page. Recently, the exports have stopped working from the reports. Obviously changes to the system have gone in, but nothing in terms of configuration that we can see as something affecting the export. A list of "facts" are below:
The reports work fine bringing back data as expected. If I run the reports directly from the report server, I can export them without any problems
In IE9, a new tab opens saying "Internet Explorer cannot display the webpage"
In Firefox 3.6 - 5, it prompts you to open or save the file, but subsequently does "nothing"
The SSRS log shows some errors, posted below I started logging HTTP requests, and when exporting from the .net page there were no errors in the log, but it was missing a final GET command when compared to exporting directly from the report server.
We have tried a large number of different things in our dev environment and the problem appears intermittent
None of the http headers have the "no-cache" option which is known to cause an export issue
The website is running on SSL, the report server is not
I think that covers the main points. Anyone who has seen something similar or who can provide some insight would be greatly appreciated! Thanks.
Log File error (small snippit):
rshost!rshost!2600!07/11/2011-10:30:49:: e ERROR: WriteCallback(): failed to write in write callback.
rshost!rshost!2600!07/11/2011-10:30:49:: e ERROR: Failed with win32 error 0x0016, pipeline=0x000000000085DC50.
rshost!rshost!678c!07/11/2011-10:30:49:: e ERROR: HttpPipelineCallback::SendResponse(): failed async writing response.
rshost!rshost!678c!07/11/2011-10:30:49:: e ERROR: Failed with win32 error 0x0016, pipeline=0x000000000085DC50.
httpruntime!ReportManager_0-24!678c!07/11/2011-10:30:49:: e ERROR: Failed in BaseWorkerRequest::SendHttpResponse(bool), exception=System.Runtime.InteropServices.COMException (0x80070016): The device does not recognize the command. (Exception from HRESULT: 0x80070016)
at Microsoft.ReportingServices.HostingInterfaces.IRsHttpPipeline.SendResponse(Void* response, Boolean finalWrite, Boolean closeConn)
at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
library!ReportManager_0-24!678c!07/11/2011-10:30:49:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException: RsWorkerRequest::FlushResponse., Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeInternalException:
An internal or system error occurred in the HTTP Runtime object for application domain ReportManager_MSSQLSERVER_0-24-129547073742107724. ---> System.Runtime.InteropServices.COMException (0x80070016): The device does not recognize the command. (Exception
from HRESULT: 0x80070016)
at ReportingServicesHttpRuntime.BaseWorkerRequest.SendHttpResponse(Boolean finalFlush)
at ReportingServicesHttpRuntime.RsWorkerRequest.FlushResponse(Boolean finalFlush)
--- End of inner exception stack trace ---;
July 12th, 2011 12:23pm
Hi mzz3lh,
Thanks for your question. There is one similar thread had handled by other partners, hope the solutions also work fine for your
issue.
Internet Explorer can’t display Error in Reporting server website:
http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/66ed102d-a491-44c3-ba99-1e362e8daaf1.
Hope it helps you.
If your
issue still exists, please feel free to let me know.
Thanks,
Sharp Wang
Please remember to mark the replies as answers if they help you and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2011 10:15pm