I am developing a Dotnet application (web application) which being used internally by the company.
I am encountering an intermittent problem which I can't explain.
Basically what is happening is that there will be a random time wherein all the data that the system is retrieving is all wrong. It seems that the data has been corrupted. The only way to resolve it is by doing IIS Reset.
Due to the fact that I cannot disclose the actual code. I will try to explain as much as I could the situation I am having.
To get to know more of the situation error, what I did was to create a dummy website which would randomly retrieve an specific data in the system and this is what I found.
Basically my system is connecting to a SQL Server. What I did was to create 2 line of codes.
first code is
[
string a = "title";
GetParameterValue(a);
]
Second code is
[ GetParameterValue("title"); ]
*NOTE: GetParameterValue has the function like "Select cValue From TableA Where cParameter = @param" wherein @param = "title" (data being passed);
In TableA, we have 2 data and columns.
cParam "language"; cValue "CN"
cParam "title"; cValue "Welcome"
By the right given the 2 code above, it should have the same result. The data retrieved should be "Welcome" since I am retrieving the parameter "title" and the equivalent value is "Welcome".
But in the end, the first code above retrieved correctly (result value: "Welcome"); while the second code above retrieved wrongly (result value: "CN");
I don't understand why it is happening like that. After I do an IIS Reset, the value for both codes will be the same and correct (value "Welcome").
The server I am using is Windows 2008 Server; I am also using SQL Server 2008; ASP.NET 2.0
Has anyone encounter an error like this before? Can I know what may have caused possible corruption of the data?
Is it that the IIS cannot cope with too much user connecting to the website? or the parameters (Query string) has exceeeded and caused the IIS to malfunction? Is there any checks that I need to do to make sure everything is running correctly?
Your code has some bug, all you need to debug it. (Because iis reset "fix" the problem, my firts guess there is some session or cache related bug in your code.)
f_c
0 Points
7 Posts
ASP.NET Data Corruption
Dec 28, 2012 07:28 AM|LINK
Greetings,
I am developing a Dotnet application (web application) which being used internally by the company.
I am encountering an intermittent problem which I can't explain.
Basically what is happening is that there will be a random time wherein all the data that the system is retrieving is all wrong. It seems that the data has been corrupted. The only way to resolve it is by doing IIS Reset.
Due to the fact that I cannot disclose the actual code. I will try to explain as much as I could the situation I am having.
To get to know more of the situation error, what I did was to create a dummy website which would randomly retrieve an specific data in the system and this is what I found.
Basically my system is connecting to a SQL Server. What I did was to create 2 line of codes.
first code is
[
string a = "title";
GetParameterValue(a);
]
Second code is
[ GetParameterValue("title"); ]
*NOTE: GetParameterValue has the function like "Select cValue From TableA Where cParameter = @param" wherein @param = "title" (data being passed);
In TableA, we have 2 data and columns.
cParam "language"; cValue "CN"
cParam "title"; cValue "Welcome"
By the right given the 2 code above, it should have the same result. The data retrieved should be "Welcome" since I am retrieving the parameter "title" and the equivalent value is "Welcome".
But in the end, the first code above retrieved correctly (result value: "Welcome"); while the second code above retrieved wrongly (result value: "CN");
I don't understand why it is happening like that. After I do an IIS Reset, the value for both codes will be the same and correct (value "Welcome").
The server I am using is Windows 2008 Server; I am also using SQL Server 2008; ASP.NET 2.0
Has anyone encounter an error like this before? Can I know what may have caused possible corruption of the data?
Is it that the IIS cannot cope with too much user connecting to the website? or the parameters (Query string) has exceeeded and caused the IIS to malfunction? Is there any checks that I need to do to make sure everything is running correctly?
Please HELP ME! Thank you very much...
FC
stmarti
Contributor
5083 Points
1061 Posts
Re: ASP.NET Data Corruption
Dec 29, 2012 06:39 PM|LINK
Your code has some bug, all you need to debug it. (Because iis reset "fix" the problem, my firts guess there is some session or cache related bug in your code.)
f_c
0 Points
7 Posts
Re: ASP.NET Data Corruption
Jan 02, 2013 02:29 AM|LINK
Hi stmarti,
I checked. I dunno what is causing it. I actually also deployed both Web App & the Database on the same machine.
Will this cause any problem?
Thanks...