.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

ReportViewer Control large dataset timeout

Posted By:      Posted Date: October 21, 2010    Points: 0   Category :Sql Server
 

Reporting Services 2008 R2

I have a rather large report that returns around 40,000 records. (I've tried telling the business that this is not a useable report and no one is listening.)

When I execute the report through a webservice and stream it to an excel file the response time is fine.  Trying to load the report using the report viewer control it just hangs.

When I run the report through SSRS own Report Manager, I get the following error

  • An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)
    • Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

 

 

This is on my own local dev machine at the minute and I've only just gotten the correct dataset it will be run against.

The stored proc runs in a couple of seconds.

Does anybody have any suggestions in what I can do?

Any help would be appreciated.

 

 

-----  Code

<rsweb:ReportViewer ID="WebRep


View Complete Post


More Related Resource Links

Persist large dataset across ASP.NET pages. No database

  

Can anyone give me suggestions on how to implement the following requirement?

1. A online wizard (step-by step operation) processes user requests across several ASP.NET pages.  The session data is stored in memory until the user submits the request.  Once the request is submitted, a XML file is created and the data are passed to XML.

# Case Study: The parent page has a "select" button.  Click "select" will pop up a child page.  The users can select 1000+ items from a datagrid in the child page.  Once the user clicks "confirm", the selected items in the child page will be populated to the selected item gridveiw in the parent page.  The user can keep selecting more in the child page and the selected items will be appended to the gridview in the parent page.

Questions:

- What's the best way to extract strings from a text file and convert to a dataset in memory and then present it in a datagrid in UI?

- What's the best way to persist and manipulate a large dataset across pages?  Session? or ViewState? Can it be accomplished by LINQ?

The app doesn't interact with a DB.  Once the request is submitted, it will convert the in memory data to a XML file.  What technology can be used to accomplished this?&nb

(Microsoft.Reporting.WebForms.ReportViewer) is not compatible with the type of control (Microsoft.Re

  

 I am trying to use ReportViewer 9 in Visual Studio 8 but I get this error when I try to run the page:

The base class includes the field 'ReportViewer1', but its type (Microsoft.Reporting.WebForms.ReportViewer) is not compatible with the type of control (Microsoft.Reporting.WebForms.ReportViewer).

Please help if you can!

Thanks


what is large and smal dataset

  
what is a large and small dataset /.. how can we say that it is large or small data set. can u xplain me clearly. and also send me some dat sets..my mail id is kalyan9029@gmail.com... thanking u .. kalyan

Does the ReportViewer control print button work inside of a modal MSIE window?

  
I am getting the following two error messages when using the new ReportViewer v10 control after pressing the toolbar print button. I am only seeing this error inside of a modal popup window in MSIE. The print button in a normal popup window doesn't have this error. An error occurred trying to get the current window Error: Could not complete the operation due to error 8007f305. If anyone knows of a quick fix, please let me know. Thank you. VS2010, MSIE 8, SQL Server 2008.

A reportviewer control bug to display unicode?

  
  1 Hello everyone, I am using VSTS 2008 + C# + .Net 3.5 + ASP.Net + IIS 7.0 with reportviewer control. The report created by reportviewer control is very simple, just a single line of Chinese characters (I wrote the line of characters statically in a textbox control, no addtional dynamically generating or fetching from database). I upload the error PDF file exported by the report viewer and screen snapshot here, and my most confusion is why the exported PDF file is just 2k bytes size? Is this issue caused by font not embedded in PDF file? Actually I did not find how to embed font in PDF file. Appreciate if anyone could give me some good ideas. This is the error PDF displayed screen snapshot, http://www.4shared.com/photo/gs_KvxSW/characterissue.html This is the error PDF itself, http://www.4shared.com/document/4Fs5rCH_/characterissue.html thanks in advance, George

Timeout when calling SqlDataAdapter.Fill(DataSet)

  
This issue has stumped me for a while.  Hopefully someone here can give me some insight. When my site runs the following code it works just fine 99% of the time. Dim sda As New Data.SqlClient.SqlDataAdapter(cmd) Dim ds As New Data.DataSet Try sda.Fill(ds) Catch ex As Exception ... The command is calling a SQL Server 2005 stored procedure that takes 20 parameters and returns 6 tables of about 5-50 rows each. The paramters are all NVARCHAR, INT, or BIT data types.  Only one of the parameters is Input/Output. There is a total of about 100 rows returned. Normally this takes a fraction of a second, but for some queries, it times out after 30 seconds. When I run the exact same query in the Management Studio query window it takes 1 second. Any idea what I can do to get the same performance from .Net as I am getting from Management Studio?

problem in Transferring a large dataset to remote machine by using the NetTcpBinding

  
i am developing an WCF application, in which i have to transfer a large dataset to the remote machine!! for that im using nettcpbinding in WCF but i got this exception ' The socket connection was aborted. This could be caused by an error processing your message or a receive timeout being exceeded by the remote host, or an underlying network resource issue. Local socket timeout was '10:29:59.4140000'. at my sender side.   Sender/Client side code   // Object for sending to remote client using (_dpParameters = new DPParameters()) { _dpParameters.SequenceFieldName = "Sequence"; _dpParameters.Size = 10; _dpParameters.SubjectsForFiles = "S,Y,T"; _dpParameters.SubjectNames.Equals(SubjectNames); _dpParameters.FilePath = " E:\\Source\\Phospho.xml"; // this dataset can be in GBs but for testing me using jst 6.78mb DataSet ds = new DataSet(); ds.ReadXml(_dpParameters.FilePath); _dpParameters.Usd = ds.Tables[0]; } /// This is the binding settings NetTcpBinding tcpBinding = new NetTcpBinding(); tcpBinding.ReceiveTimeout = new TimeSpan(10, 30, 00); tcpBinding.SendTimeout = new TimeSpan(10, 30, 00); tcpBinding.MaxBufferSize.Equals(67108864); tcpBinding.MaxBufferPoolSize.Equals(67108864); tcpBinding.MaxReceivedMessageSize.E

Problems with People-picker control in a large organisation.

  
We are experiencing very slow people searches, when trying to pick a user from a SP group containing 500 names. Some people this week have experienced errors after about 10 minutes of waiting. Background: I have a form where the users need to pick an Authoriser. The List of Authorisers is held in a Custom Sharepoint Group. Site column was then built to select people from that SP Group. The good news is the Lookup address book dialog shows the group members OK Unfortunately if the users do a search in this dialog, or from the main form, the server now takes (on average)  around 3 minutes 51s to find the user (from about 500 names), and sometimes fails completely - either with an error, or just returns control to the form with no result. Has Microsoft changed the algorythm for this search to search the entire AD? (I am working in a huge organisation with domains round the world, some are NT4). On a previous project (last year) a similar search only look 2 s! Any suggestions? Any recent Server packs that might impact this (possitively or negatively?) Thanks Ruth, UK

Timeout issue with large data

  

Getting timeout error while retriving large chunk od data. it workd fine for smaller chunks.

We tried to increase the following but didnt help.. Any suggestions are appreciated.

maxReceivedMessageSize,

maxBufferPoolSize

maxBufferSize

" at System.Net.HttpWebRequest.GetResponse()\r\n at System.ServiceModel.Channels.HttpChannelFactory.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout)"

Thanks


Sending Large Dataset to Webservice

  

Dear all,

I have one problem is that when i send large dataset containing byte array.. then webservice not respond well..

it shows error like underlying connection was closed...

I mark that when dataset size goes some large then only problem occurs otherwise it works well..

Please give me solution of how to send large dataset over web service...

 

Thanks.. 


Handling Errors displayed in the ReportViewer control

  

Hi, this kind of a two part question.  Is there any way to handle an error that is displayed inside a report, such as an error returned from a stored procedure?  I have a page with the ReportViewer control on it, but I don't really have any control over the rdl's or the sprocs, so it's possible that something will go wrong.  Currently I'm just getting the following error:

  • An error has occurred during report processing.
    • Query execution failed for dataset 'XXXX'.
      • For more information about this error navigate to the report server on the local server machine, or enable remote errors

If at all possible I would like to handle this error myself and show a message that's consistent with the rest of the site.  I've attempted to handle the ReportError event, but this seems to only fire when there's an issue with the viewer itself, not what it's showing.


Large Dataset Downloaded Before Rendering Report's First Page

  

Greetings,

I'm hoping to understand the behavior of SSRS a bit better in the following scenario (SSRS 2008).  A single matrix (tablix) exists on the report.  No other objects are on the report.  That matrix is populated with 1.1 million rows of data totaling about 200MB.  Why does SSRS download the entire dataset prior to rendering the report's first page or am I missing something here?

When previewing the report, the local .data file bloats to 200MB indicating all dataset rows are being returned.  The matrix does not contain any sorting, all cell "can grow" and "can shrink" properties are set to false, no expressions are used anywhere, and even the table's column data types from which the data is being pulled are appropriate.  In other words, I believe I've reduced storage and CPU needs while eliminating elements that add overhead when rendering a report.

The specific scenario here is a researcher previewing the first few pages of data then choosing to download the entire dataset.  MS documentation I've read refers to "soft page breaks" when rendering as HTML and left me with the impression that perhaps SSRS needs to know the entire height of the dataset before it'll slice the report into pages.  It's odd to me though that it needs to download 1.1 millions rows of data befor

Timeout while sending large amount of data with WCF client

  

Hi,

I've call to Java WebSeal Web "enveloped" by WCF Client. Sending large XML (about 60k) as a parameter cause an error and received one of these messages:

 System.ServiceModel.CommunicationException: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.

OR

System.TimeoutException: The request channel timed out while waiting for a reply after 00:01:00. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout.

Interaction with same webseal service configured as asmx service doesn't cause any errors.

my client app.config looks like this:

<bindings>
      <basicHttpBinding>
        <binding name="WinflowSoap" closeTimeout="00:01:00" openTimeout="00:01:00"
         receiveTimeout="00:10:00" sendTimeout="00:01:00" allowCookies="false"
         bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard"
   

Timeout while sending large amount of data with WCF client

  

Hi,

I've call to Java WebSeal Web "enveloped" by WCF Client. Sending large XML (about 60k) as a parameter cause an error and received one of these messages:

 System.ServiceModel.CommunicationException: The underlying connection was closed: A connection that was expected to be kept alive was closed by the server.

OR

System.TimeoutException: The request channel timed out while waiting for a reply after 00:01:00. Increase the timeout value passed to the call to Request or increase the SendTimeout value on the Binding. The time allotted to this operation may have been a portion of a longer timeout.

Interaction with same webseal service configured as asmx service doesn't cause any errors.

my client app.config looks like this:

<bindings>
      <basicHttpBinding>
        <binding name="WinflowSoap" closeTimeout="00:01:00" openTimeout="00:01:00"
         receiveTimeout="00:10:00" sendTimeout="00:01:00" allowCookies="false"
         bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard"
   

Timeout on dataadapter.Fill on strongly typed dataset

  

Hi friends,

               Error message shown "timeout expired.the timeout period elapsed prior to completion of the operation or the server is not responding "

                on filling the strongly typed dataset(ie. dataadapter.Fill(dataset.tablename)).  plz help me

regards

Lince   

 


Help printing .rdl reports using the asp ReportViewer control from a web page to the users client pr

  

I have developed a set of ssrs .rdl reports and am trying to display them from the reportviewer control embeded in my asp web page. The problem is that when I select the print icon on the reportviewer control I am prompted to install ms sql server. I need help here. What is the best way to print .rdl reports from the web page's embeded reportviewer control to the client's local network printer.

Thanks,

 

Steve

 


Can we assign ADo.NET Dataset to reportviewer

  

Hi,

Is there any possiblity of datasource obtained from front end ADO.NET like DataSet /DataTable to Reportviewer to view report. Something like pushing data to report.

My second question, Can we make call to  webservice on click on "View Report" button, after selecting parameters in report

 

-Mahender


Mahender
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend