I had a similar error today on SIMS our MIS system and it appears to be a timeout issue.
The solution for me, was to add a line in a configuration file to set the commandtimeout to 10000, this was a known solution but i had removed it for testing while tweaking some other log on issues.
The odd thing is that it occurs whilst i am in the application running a report to return photos. The report takes only a minute or two to work.ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
However, yesterday i was running huge long reports that took 20 mins to run, and had no issue even without the commandtimeout variable set. Odd.
I can only imagine, that the other large reports had constant data flow, and the photo reports were being run server side and then timing out whilst the data was transferred across the network to me.
Sorry if it's not much help, i'm assuming the two errors are linked.



LinkBack URL
About LinkBacks

Reply With Quote

