Abhi's den...

Viewstate error : 12031

2009-10-13T06:41:00Z

Few days ago I was asked to look into an issue. In our application we have created dynamic grids to show data from database. This ASPX page was Ajax enabled. Moreover all the rows of the grid were in edit mode ie. the normal controls like textbox,dropdowns etc were displayed in all the rows. This grid was Paginated. But for the past few days the paging was not working.

I executed the page and found that the page was generating an error 12031 with the following message

Sys.webForms.PageRequestManagerServerErrorException:An unknown error occurred while processing the request on the server .the status code returned from the server was:12031.

On my first round of analysis I found the issue with Viewstate. If the viewstate is large then connection is reset (ERROR_INTERNET_CONNECTION_RESET ). In local machine with less load this problem will not occur but as the load & network latency increases this error will come. Once this error is generated the general events of grid is not triggered. So advised my team to minimize the use of viewstate. It will help in to load the page faster & reduce the network traffic. I can increase the maxRequestlength value to allow more data but ideally i shouldn't increase that.

In the page tested by me a page with grid with 372 rows generated a viewstate of 4.2 mb. you can disable viewstate using EnableViewState="false" for the individual controls and for the entire page also.

With every post back this much of data is transferred back & fro & this will result in low response time.

The developer was saving all the data into viewstate in page load and from that the data was populated to the grid.

Better solution is to retrieve only the required data from database, minimize the use of viewstate, Viewstate can be compressed also. About all these I will update in another post.

Add Web service reference- Components required to enumerate web references not installed

2009-10-13T06:23:00Z

After playing with Web services for so many years this was a tricky error which kept me thinking for few minutes. Today when i tried to add WCF reference to my application it gave the following error, Error --------------------------- Microsoft Visual Studio --------------------------- Failed to update Service Reference 'XXXBusiness.Reference'. Error:The components required to enumerate Web references are not installed on this computer. Please re-install Visual Studio.(0x80004002) What could have...(read more)

WCF 8192 issue

2009-08-06T16:08:00Z

This was a simple issue which baffled few brains in my project. For the past few weeks i was seeing the mails about this. What was the exact problem? Whenever a large xml stream is passed through WCF it generated the following error. Everything was fins at the ASP.net client side. Almost all the known properties of Problem: The maximum string content length quota (8192) has been exceeded while reading XML data. This quota may be increased by changing the MaxStringContentLength property on the XmlDictionaryReaderQuotas...(read more)

SQL Server Management Studio query template

2008-11-23T16:36:00Z

Last day I was working on SQL server and I got this strange error
---------------------------
Microsoft SQL Server Management Studio
---------------------------
Cannot find template file for the new query ('C:\Program Files\Microsoft SQL
Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWorkbenchProjectItems\SQL\SQLFile.sql').
---------------------------
OK

At first I thought my SQl server installation was corrupt. I changed few settings, tried to repair but no use.

Solution:
Actually the solution was very simple. I just created an empty file SQLFile.sql in the designated folder and then it started working. Now this gave me a new idea. I could add my own template and every time I open SSMS I will get this template. Phew

.NET Framework V2.0 Obsolete API List

2008-01-25T03:18:00Z

With the release of .Net framework 3.0 & 3.5 a lot API in .Net 2.0 has become obsolete.

I found two excellent links in MSDN which gives a comphrensive list of all the obsolete API's of .Net 2.0

The Obsoleted Types count is the number of obsoleted types found in the assembly/namespace.
The Obsoleted Members count is the number of obsoleted members not contained in an obsoleted type. If a type is obsolete, it's members are not counted in this value.

Obsolete List: By Assembly

Obsolete List: By Namespace