Webservice not returning results when dealing with large data

I have an interesting situation.

I have a webservice function that I pass a DataSet, do some inserts, then return the results as a dataset. This works fine 99% of the time.

However, when I send a large dataset to this function strange things happen. On my 'client' end nothing happens - I have a Console.WriteLine right after the webservice call and it NEVER executes (nor does it error out).

ex:
webserviceRef.sendData(someDataSet);
Console.WriteLine("Done!"); <- never executes

Now back on the server (webservice) end, the function executes perfectly. I can tell because right before the 'return' statement I write out a text file that says "Done!"...

Any ideas on why the DataSet is not being returned to the client I have tried increasing timeouts on the client, webservice, and IIS end. I cannot think of anything else to try, or any other way of debugging.

Thanks!

Answer this question

Webservice not returning results when dealing with large data

Blair Stark
I am sure that it is not throwing an exception. I have the webservice write out a text file right before calling the 'return' statement, and it does this everytime.

The dataset has 3 tables, 1st table has ~63,000 rows, 2nd table has ~2000 rows, and the 3rd table has 0 rows.

Thanks
dc2000
It would be useful to do a network trace using a tool like Microsoft Network Monitor to see what is happening on the wire. With a network trace you could see if the client ever received a response from the server and how much of the response the client consumes.

Daniel Roth
swimming
Hi,

Are you sure that it is executing correctly on the server Have u added a try-catch block and checked if any exception is being generated

When you say large Data, how big is it How many DataTables and Rows

Regards,
Vikram
Webservice not returning results when dealing with large data

Answer this question