sql server 2012 reporting service error cnnection closed whene export to excel


hello,

i have simple report created report builder. when run report form http://xxxx/reports work ok.

when export report excel if number of row returned the query < 11251 work, if > 11251 error generated:

[ioexception: impossibile leggere dati dalla connessione del trasporto: connessione chiusa..]     system.net.connectstream.read(byte[] buffer, int32 offset, int32 size) +1321     microsoft.reporting.webforms.soapreportexecutionservice.serverurlrequest(abortstate abortstate, string url, stream outputstream, string& mimetype, string& filenameextension) +649    [reportserverexception: impossibile leggere dati dalla connessione del trasporto: connessione chiusa..]     microsoft.reporting.webforms.soapreportexecutionservice.serverurlrequest(abortstate abortstate, string url, stream outputstream, string& mimetype, string& filenameextension) +1002     microsoft.reporting.webforms.soapreportexecutionservice.render(abortstate abortstate, string reportpath, string executionid, string historyid, string format, xmlnodelist deviceinfo, namevaluecollection urlaccessparameters, stream reportstream, string& mimetype, string& filenameextension) +1121     microsoft.reporting.webforms.serverreport.internalrender(boolean isabortable, string format, string deviceinfo, namevaluecollection urlaccessparameters, stream reportstream, string& mimetype, string& filenameextension) +425     microsoft.reporting.webforms.servermodesession.renderreport(string format, boolean allowinternalrenderers, string deviceinfo, namevaluecollection additionalparams, boolean cachesecondarystreamsforhtml, string& mimetype, string& fileextension) +209     microsoft.reporting.webforms.exportoperation.performoperation(namevaluecollection urlquery, httpresponse response) +219     microsoft.reporting.webforms.httphandler.processrequest(httpcontext context) +221     system.web.callhandlerexecutionstep.system.web.httpapplication.iexecutionstep.execute() +586     system.web.httpapplication.executestep(iexecutionstep step, boolean& completedsynchronously) +177

hello roberto,

thank post question on technet forum.

from error message, seems issue occurs when export report excel in reportviewer on web site. error message connection closed.

i want check whether report spends long time export excel file , generates issue. if so, consider connection closed because of service timeout. can enlarge <runtime> of reporting service. please go reportserver , reportmanager folder under c:\program files\microsoft sql server\msrs11.mssqlserver\reporting services\ , following steps.

  1. open web.config file , find line <httpruntime executiontimeout="9000" />.
  2. modify executiontimeout 9000 larger number, such 900000.
  3. save changes , restart reporting service see whether issue solved.

if have further question issue, please post freely.

regards,

edward

edward zhu

technet community support



SQL Server  >  SQL Server Reporting Services, Power View



Comments

Post a Comment

Popular posts from this blog

SQL Server PSProvider SQL Server Authentication

greetings: i'm trying use sql psprovider powershell.  can make work management studio by right-clicking next database object.  however, unnable external powershell session. note: i have tried using suggested method msdn ( initializesqlprovider.ps1 , function sqldrive ) i following error: new-psdrive : sql server powershell provider error: not connect 'emtyb06\default+bca_empresarial'. [object ref erence not set instance of object.] @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -credential $cred -scope 1 new-psdrive : sql server powershell provider error: path sqlserver:\sql\emtyb06\default+bca_empresarial not exist.  please specify valid path. @ line:1 char:12 + new-psdrive  <<<< "sqlauth" -psprovider sqlserver -root "sqlserver:\sql\emtyb06\default+bca_empresarial" -cred...
Read more

BIT Version

  hi,     knows how find out ther bit version in sql  , windows os (32 or 64)   regards, s.balavenkatesh   microsoft sql server 2005 - 9.00.1399.06 (intel x86) oct 14 2005 00:33:37 copyright (c) 1988-2005 microsoft corporation standard edition on windows nt 5.2 (build 3790: service pack 2)     intel x86)   -- says sql server 32 bit   madhu SQL Server  >  SQL Server Tools
Read more

How to calculate the delta size while diffing the files in TeamFoundationServer ?

currently, need calculate delta size while diffing files in teamfoundationserver, don't know wheter there are existed tfs api in msdn. far did not find it. familiar it? or deliver suggestions? thanks in advance !! thanks materials !! here solution below: private int calsinglefiledelta(string strbase, string strshelve) { int nfiledelta = 0; arraylist alorgstart = new arraylist(); arraylist aldesstart = new arraylist(); arraylist alunchangedlen = new arraylist(); diffsegment diffseg = difference.difffiles(strbase, encoding.ascii.codepage, strshelve, encoding.ascii.codepage, new diffoptions()); if (diffseg != null) { alorgstart.add(diffseg.originalstart); aldesstart.add(diffseg.modifiedstart); alunchangedlen.add(diffseg.modifiedlength); while (diffseg.next != null) { diffseg = diffseg.next; alorgstart.add(diffseg.originalstart); ...
Read more