ASP.NET

Re: page cannot be displayed occurred in asp.net 2.0 when executing a oracle sp for a long time

21-Sep-09 2:38

I am executing a oracle stored procedure from the asp.net2.0 application and its takes long time to complete the execution.At that time the page is timing out if the execution takes more than 1 hour..

The Error "Page cannot be displayed". no error code is displayed.There is no entry in event log viewer also.

when i debug the application it doesnt break when the Error occured and in the backend sp is completing the execution but doesnt return any value to the page.

I have set session Timeout = 300 and httpRuntime tag executionTimeout="18000" maxRequestLength="1048576" in web.config.

I am using oracle.dataaccess.client for oracle connection.

Please help me to retain the page when the stored procedure execution takes more than 1 hour to complete.

prasannavenkatesh

Abhijit Jana21-Sep-09 3:33

Re: page cannot be displayed occurred in asp.net 2.0 when executing a oracle sp for a long time

21-Sep-09 3:33

prasannavenkatesh wrote:
At that time the page is timing out if the execution takes more than 1 hour..

Please put breakpoint in your code and check where its take time. If Code is working fine, check how much time take to established the connection. Then try to check the SP execution time.

prasannavenkatesh wrote:
when the stored procedure execution takes more than 1 hour to complete

Is this any back end job ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

prasannavenkatesh21-Sep-09 15:37

Re: page cannot be displayed occurred in asp.net 2.0 when executing a oracle sp for a long time

21-Sep-09 15:37

I have placed a break point and checked. There is no problem with connection.
we are handling with huge data with more than 25000 records. The functionality is the records are moved from temp table to other tables and the records are deleted in the temp table.

If it is very less data and which will complte the execution within 1 hour then it is working fine.

I have increased commandtimeout also into 18000 secs after connection established.

The guy who is handling oracle sp is unable to reduce the execution time currently.

So i am trying to fix the issue from the application.

Please help me to solve this issue.

prasannavenkatesh

Not Active21-Sep-09 3:44

Not Active

21-Sep-09 3:44

Is the code all in the code-behind for the page? If not, test each piece (i.e. Unit Test) to verify each piece is functioning properly. That will help you to identify a problematic component and give performance data.

prasannavenkatesh wrote:
Please help me to retain the page when the stored procedure execution takes more than 1 hour to complete.

It is a really bad design and architecture to keep a page open this long.

only two letters away from being an asset

cookie is not working when session expired in IIS 6.0 in Win 2003 sever

prasannavenkatesh21-Sep-09 2:06

Re: cookie is not working when session expired in IIS 6.0 in Win 2003 sever

21-Sep-09 2:06

I have login page and a main page in the asp.net 2.0 application.In web.config, session Timeout value is set as 5 mins.

My requirements are as below
1.If the main page is idle for 5 mins, the session will expire and the same page will be retained. If the user tries to do some action then it has to redirect to loginpage.
bebuggiung steps
1.comes to session end event in global.asax and the retain the main
page
2.comes to session start event in global.asax after the user tries to
do some action.
3.check the condition and redirects to login page

2.If the session ends at the time of some action is going in the main page(eg executing a stored procedure for a long time ) then the session has to continue upto the action gets finished.Once it is completed session timeout value has to reset as original value (5 mins)

bebuggiung steps
1. Comes to session end event and assigns the session timeout value
to retain the running process in the main page.

I have used the following code to do the above requirements.It is working fine in IIS V5.1 (win xp) and not working in IIs 6.0 in win 2003 server

Web.config
sessionState timeout="5" mode ="InProc" cookieless ="false"

Global.asax
void Application_Start(object sender, EventArgs e)
{
// Code that runs on application startup
Application["Button"] = "Started";
}
void Session_Start(object sender, EventArgs e)
{
// Code that runs when a new session is started
HttpContext context = HttpContext.Current;
HttpCookieCollection cookies = context.Request.Cookies;
if (cookies["starttime"] == null)
{
HttpCookie cookie = new HttpCookie("starttime", DateTime.Now.ToString());
cookie.Path = "/";
context.Response.Cookies.Add(cookie);
cookie.HttpOnly = true;
Application["Button"] = "Started";
}
else
{
if (Application["Button"] == "NotClicked" || Application["Button"] == "Error")
{
context.Response.Redirect("~/Logon.aspx");
}
}
}
void Session_End(object sender, EventArgs e)
{
if (Application["Button"] == "Clicked")
{
Session.Timeout = 60;
}
else
{
Application["Button"] = "NotClicked";
}
}
}
Main Page Load
Application["Button"] = "NotClicked";

Main Page Button Click (calling sp in this button)
Application["Button"] = "Clicked";

Please any one help me out to do the same in IIS 6.0. I have tried with worker process idle time also in application pool.

What is the difference in IIS 6.0 with IIS 5.1 using the above code with cookies? Please any one reply me as soon as possible. its very urgent....

Abhijit Jana21-Sep-09 3:30

Re: cookie is not working when session expired in IIS 6.0 in Win 2003 sever

21-Sep-09 3:30

prasannavenkatesh wrote:
Please any one reply me as soon as possible. its very urgent....

This is Bad Dead | X|

prasannavenkatesh wrote:
IIS 6.0. I have tried with worker process idle time also in application pool.

Did you create separate Application pool for that? What are the configuration did u changed in Application Pool ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

prasannavenkatesh21-Sep-09 15:21

Button OnClick event on post back

21-Sep-09 15:21

hi,
I didnt create seperate application pool for that.In the Default Application pool, i have changed the settings and tested the same functionality based on the below link.

http://sanjaykattimani.blogspot.com/2007/02/net-session-timeout-settings-in-iis6-on.html

I have modified the option "ShutDown Worker processes after being idle for" into 5 minutes and restrated the IIS entirely and tested but no solution.

Now,i have reverted to default settings 90 minutes for that option.

Please help me if any other solution for this issue.

prasannavenkatesh

amit sahu2021-Sep-09 0:14

amit sahu20

21-Sep-09 0:14

how could i know,
such a button onclick() event get fired in checking Postback

Re: Button OnClick event on post back

Manas Bhardwaj21-Sep-09 0:27

Manas Bhardwaj

21-Sep-09 0:27

You can use Request.Form["__EVENTTARGET"] to get the control which caused the postack

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Button OnClick event on post back

amit sahu2021-Sep-09 0:36

amit sahu20

21-Sep-09 0:36

thanx for reply yep its works ,yet have to add

UseSubmitBehavior="false"
to the button

gridview

mylogics21-Sep-09 0:10

mylogics

21-Sep-09 0:10

hii...
i have taken buttonfield in one of the columns of a grid view rest of the columns are populated from the database.I want to perform some task on the buttonclick event how can i do this.
plz guide me....
thanks...

Abhijit Jana21-Sep-09 1:05

21-Sep-09 1:05

Use Gridview RowCommand Event and Check the Command name. Below is the Reference link for you.
http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowcommand.aspx[^]

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Seraph_summer21-Sep-09 10:15

Seraph_summer

21-Sep-09 10:15

right, I have used this way!

Abhijit Jana21-Sep-09 10:32

21-Sep-09 10:32

That's cool ! Thumbs Up | :thumbsup:

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Amit Patel198521-Sep-09 1:09

Amit Patel1985

21-Sep-09 1:09

use gridview edit and delete event and Google u will find so many example

Thanks,

Amit Patel

Abhijit Jana21-Sep-09 1:11

21-Sep-09 1:11

Amit, I guess he is not asking about the GridView Edit Button. Poke tongue | ;-P

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

sashidhar21-Sep-09 1:12

sashidhar

21-Sep-09 1:12

The Event U r Searching For is GridView RowCommand event

Use The Below Link It Will Give FullOverview Of Grid View Event

Trick/Tip: Raise a GridView RowCommand event from a child DropDownList control using a Submit button[^]

http://msdn.microsoft.com/en-us/library/system.web.ui.webcontrols.gridview.rowcommand.aspx[^]

If It Helps Click It as Answer

Abhijit Jana21-Sep-09 1:15

21-Sep-09 1:15

You are 7 min late Wink | ;)

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

sashidhar21-Sep-09 1:35

sashidhar

21-Sep-09 1:35

LOL i am Always Ur Follower Dude..!

If It Helps Click It as Answer

Abhijit Jana21-Sep-09 1:58

21-Sep-09 1:58

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

mylogics21-Sep-09 2:29

mylogics

21-Sep-09 2:29

thanks...