Timeout when deleting categories with a lot of items

For general questions and discussions specific to the AbleCommerce 7.0 Asp.Net product.
Post Reply
bigbangtech
Commander (CMDR)
Commander (CMDR)
Posts: 182
Joined: Mon Oct 10, 2005 6:27 pm

Timeout when deleting categories with a lot of items

Post by bigbangtech » Mon Apr 20, 2009 1:32 pm

In 7.02, when we try to delete a category with dozens of subcategories and 100's of items , it times out, and we get a popup stating:

Sys.WebForms.PageRequestManagerTimeoutException: The server request time out

Is this SQL timing out, or something in the Admin code? What can we change to increase the timeout to say 5-10 minutes?
Last edited by bigbangtech on Mon Jul 13, 2009 10:29 am, edited 1 time in total.
AC7.3

Need A Bulb? - Light bulbs for the building maintenance and construction industries

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Timeout when deleting categories with a lot of items

Post by mazhar » Tue Apr 21, 2009 8:57 am

That could be due to ASPX page request time out. If process takes too long and don't return response to page in desired time it can time out but your categories will be deleted from database. I think its something configurable via IIS for application.

User avatar
mfreeze
Commodore (COMO)
Commodore (COMO)
Posts: 421
Joined: Mon Jan 24, 2005 2:07 pm
Location: Washington, NJ
Contact:

Re: Timeout when deleting categories with a lot of items

Post by mfreeze » Mon Jul 06, 2009 8:34 am

I am getting this both deleting large categories and on abandoned baskets report. I googled the message and found that this is a script postback timeout error.

The method to fix it is
To solve this problem we can increase the timeout. You can change the timeout time by adding a new property to the script manager control. This property is called AsyncPostBackTimeOut and it can help us to define the number of seconds before the request will throw a request timeout exception*.

For example if you want that the timeout will take maximum 10 minutes your code should be look like this:

<asp:ScriptManager ID="ScriptManager1" runat="server"

AsyncPostBackTimeOut="600" >

</asp:ScriptManager>

The default value of the AsyncPostBackTimeOut property is 90 seconds
The problem is that I haven't found where to put the code in Able Commerce. Does anybody know where this would need to be inserted?
Mary E Freeze

Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development

http://www.ffgraphics.com

User avatar
mazhar
Master Yoda
Master Yoda
Posts: 5084
Joined: Wed Jul 09, 2008 8:21 am
Contact:

Re: Timeout when deleting categories with a lot of items

Post by mazhar » Mon Jul 06, 2009 9:10 am

I think you need to adjust it in master pages under layout directory.

User avatar
mfreeze
Commodore (COMO)
Commodore (COMO)
Posts: 421
Joined: Mon Jan 24, 2005 2:07 pm
Location: Washington, NJ
Contact:

Re: Timeout when deleting categories with a lot of items

Post by mfreeze » Mon Jul 06, 2009 2:01 pm

Thanks, that worked. It had to go into admin.master in the admin folder.
Mary E Freeze

Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development

http://www.ffgraphics.com

User avatar
Logan Rhodehamel
Developer
Developer
Posts: 4116
Joined: Wed Dec 10, 2003 5:26 pm

Re: Timeout when deleting categories with a lot of items

Post by Logan Rhodehamel » Tue Jul 07, 2009 9:30 am

Posted as bug 8186 to increase our default timeout to 600 out of the box.
Cheers,
Logan
Image.com

If I do not respond to an unsolicited private message, it's not because I'm ignoring you. It's because the answer to your question is valuable to others. Try the new topic button.

User avatar
triplw
Commander (CMDR)
Commander (CMDR)
Posts: 144
Joined: Sat Jan 12, 2008 5:34 pm
Contact:

Re: Timeout when deleting categories with a lot of items

Post by triplw » Fri Jul 31, 2009 2:36 pm

Mary,
Could you tell me exactly where in the ~/Admin/admin.master file you should put this code. I put it in the body and got an error.

Thanks

User avatar
mfreeze
Commodore (COMO)
Commodore (COMO)
Posts: 421
Joined: Mon Jan 24, 2005 2:07 pm
Location: Washington, NJ
Contact:

Re: Timeout when deleting categories with a lot of items

Post by mfreeze » Mon Aug 03, 2009 7:38 am

Find this line: (around line 45) and change the AsyncPostBackTimeout parameter to the number you desire. I made it a ridiculous number due to the size of some of my clients order tables but you should choose a number that works for you.
<ajax:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="true" AsyncPostBackTimeout="100000" />
Mary E Freeze

Freeze Frame Graphics
Web Hosting and Design, ASP and CFMX Development

http://www.ffgraphics.com

Post Reply