We have an application that pulls back fairly large datatables and stores them in session (I know this is bad, i didnt design it this way). We are using the Session State Server and I have verfied that its working (the site relies heavily on session and I can work with it just fine). However, when we return a large datatable (~12MB), we get the error
Unable to make the session state request to the session state server. Please ensure that the ASP.NET State service is started and that the client and server ports are the same.
So the question is, are there memory limits for each session instantiated for the Session State Server? It would seem to me that the size for a single session could be as large as the memory dedicated the Session State service. The only other reason that I could think of was that the dataset is so large that the communication between the state service times out before the data is communicated across the channel. Any help on this would be greatly appreciated. Thanks in advance!
Phaedrus - I tried setting the stateNetworkTimeout and it threw the same exception. I also tried it with a different (but also large) datatable and it caused the same problem. It appears that there is a limit to how much data you can store in a single session instance. Ive noticed that if I have less than a 1000 records it works but once I go over that it throws this exception. Not sure what to do from here.