CODEWITHSUNDEEP
c#asp.net.net
Tim
Tim

Reputation: 1249

ReadResponse() failed: When uploading large amounts of data

I came across an issue today when adding an upload data modification to a ASP.NET 3.5 C# Web App. The user needs to upload a spreadsheet with a .xls extension containing large amounts of data. That spreadsheet will be converted to a datatable and then inserted into SQL Via a SqlBulkInsert method. The problem I am having is the sheet I am currently working with has 16 columns and can only contain 24889 rows before I receive this message from the server via Fiddler, 'ReadResponse() failed: The server did not return a response for this request.' I've searched and not found much info on this related to my issue. Any help would be appreciated.

Upvotes: 1

Views: 379

Answers (3)

Dinesh
Dinesh

Reputation: 3770

By default you can upload a file upto 4MB.

The size of your excel must be excedding the limit.

What you can do is set the setting in Web Configuration file

What this will do is increase the request size that server can respond to.

Upvotes: 1

Alexei Levenkov
Alexei Levenkov

Reputation: 100555

You need to look into server logs to figure out what cases it (or simply debug the server portion if you can). You also should see if it cased by simply size of the file or data in the file (if you do any processing).

Possible reasons:

  • you code gets the data, but fails in some way likely tearing down whole process
  • ASP.Net blocks request due to size (see Pankaj Garg answer).
  • your code is just too slow

Upvotes: 0

Pankaj
Pankaj

Reputation: 10115

Try giving some values for maxRequestLength like below

<system.web>
    <!-- ... -->

    <httpRuntime maxRequestLength="204800"/>

    <!-- ... -->
</system.web>

Upvotes: 2

Related Questions