Abandoned baskets report timing out

[WylieE]

Our abandoned baskets report is suddenly timing out on us. I ran it last week and it worked fine. All of our other reports are working fine.

When running the report, we get a request timed out error. In the past, it took some time to run. I'm guessing a table has grown too large or something like that.

Has anyone ever encountered problems with this report? Timeouts?

[Logan Rhodehamel]

This is the second time I've heard this this week. IIRC you can get to your database... Do you want to compare these two queries on your large dataset?

current query (approximate):

Code: Select all

SELECT b.BasketId FROM ac_Baskets b INNER JOIN ac_Users u on b.UserId=u.UserId WHERE u.StoreId = 1 AND u.LastActivityDate >= '8/1/2009' AND u.LastActivityDate < '8/28/2009'

possible improvement:

Code: Select all

SELECT BasketId WHERE ac_Baskets WHERE UserId IN (SELECT UserId FROM ac_Users WHERE StoreId = 1 AND LastActivityDate >= '8/1/2009' AND LastActivityDate < '8/28/2009')

We may also need to add an index on lastactivitydate.

[WylieE]

I compared both queries and the results were near identical. Approximately 2 seconds to return 217,454 rows. I also indexed LastActivityDate. Marginally faster search results.

After adding the index, I tried running the Abandoned carts report and it still errored out with a timeout error.

[Logan Rhodehamel]

After adding the index, I tried running the Abandoned carts report and it still errored out with a timeout error.

I assumed timeout meaning sql timeout. Is this perhaps an ASP.NET timeout? Something about the page processing that it's taking too long to draw the page? Because a 2 second query won't do that.

[WylieE]

Here's the exact error as reported in our event viewer.

Event code: 3001
Event message: The request has been aborted.
Event time: 8/31/2009 9:52:58 AM
Event time (UTC): 8/31/2009 4:52:58 PM
Event ID: c2cd69bdf74f4249884af79a9f6504e3
Event sequence: 965
Event occurrence: 1
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/195289828/Root-1-128962108928276250
Trust level: Full
Application Virtual Path: /
Application Path: C:\Inetpub\wwwroot\warmothable\
Machine name: WARMOTH

Process information:
Process ID: 2560
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: HttpException
Exception message: Request timed out.

Request information:
Request URL: https://www.warmoth.com:443/Admin/Repor ... skets.aspx
Request path: /Admin/Reports/MonthlyAbandonedBaskets.aspx
User host address: 75.149.171.225
User: eric@warmoth.com
Is authenticated: True
Authentication Type: Forms
Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:
Thread ID: 7
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace:

[WylieE]

Update:

We can run the abandoned carts report for September. Once in the report, I can select any month *but* August and have the report run correctly. If I select August in the report, it updates the month display at the top of the report, but returns the previously selected month's totals.

Logan, I'm guessing you have some error checking in place that returns the previous data set if there's an error. I checked the error log and app.log and no errors were reports.

[Logan Rhodehamel]

It's just timing out trying to produce the page - it might not be directly a SQL timeout. You could try upping the timeout with a small edit to MonthlyAbandonedBaskets.aspx.cs:

Code: Select all

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)

turns into

Code: Select all

    protected void Page_Load(object sender, EventArgs e)
    {
        Server.ScriptTimeout = 7200;
        if (!Page.IsPostBack)

[divers-supply]

Anybody figured this out? I just ran my Abandoned baskets report and I'm getting a timing out error before it loads the page in my web browser!

[triplw]

I have this problem with the timeouts too. At the beginning of the month I usually can load the abandoned baskets report but it gets slower as the month goes on then starts timing out. I added a link on the dropdown to DailyAbandonedBaskets.aspx and that way I can view the days one at a time without any problems. But I would like to have the MonthlyAbandonedBasket.aspx page load too.

[mazhar]

Did you tired to increase the timeout period as suggested by Logan in his above post? I think that will also work.

[triplw]

I did what Logan suggested. I just wondered why it would take SO LONG to load the report.

[crockettdunn]

glad to know how to do this. Would anyone be kind enough to tell me where the anonymous user maintenance code lives, so I can increase the timeout there?

[jmestep]

protected void Page_Load(object sender, EventArgs e)
{
Server.ScriptTimeout = 7200;
if (!Page.IsPostBack)

The above code would go into the Admin/Reports/MonthlyAbandonedBaskets.aspx.cs
Is that what you were asking about?