Error in page tracking log maintenance

[WylieE]

We've suddenly started seeing a rash of these errors. The debug data reads; "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

I've noticed performance lags at the same time. It seems like these maintenance routines are automatic. Can we delay their start to off peak hours or what triggers them?

[WylieE]

Anyone?

We're also starting to see errors reading:

Transaction (Process ID 73) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

The exact process ID can change, but the rest of the error message remains the same.

Is there any way to push maintenance to the evening hours when we have less traffic?

Thanks,

[Logan Rhodehamel]

Is there any way to push maintenance to the evening hours when we have less traffic?

This problem of deadlocked resources is resolved in our upcoming release. The maintenance processes should not be resource intensive, however the way we implemented some of the cleanup tasks was less than desirable in high traffic situations.

To answer your question, almost yes, with a little bit of work.

Step 1: Disable Timed Recurring Maintenance

Edit the App_Data\ablecommerce.config file. There is an attribute for maintenanceInterval, by default set to 360 minutes (6 hours). You can set this to 0 which will disable recurring maintenance from running. (You can also increase the value if you want to reduce the frequency that maintenance runs, but you cannot control exactly when it runs.)

Step 2: Create a Custom Script to Trigger Maintenance

You need a very basic utility script file that makes a call to CommerceBuilder.Utility.MaintenanceWorker.RunMaintenance() method.

Step 3: Use NT Scheduler to Call Maintenance File

You can use a windows task scheduler (like the at scheduler) to request the URL of your utility script to call the maintenance timer. This way you can configure an exact time the maintenance processes will be requested.

[AbleBody]

Hi Logan,
I posted a separate message on this and did not get a response

Anyways, tried your method above. but even after setting maintenanceInterval to "0", looking at the app_log, it appears to be running sporadically.. every 1/2 hr sometimes to every 4 or 5 hrs other times.

Close to this, we see a lot of "The timeout period elapsed prior to completion of the operation or the server is not responding" errors... this is has become a big issue for us, and we are expecting at least 2 to 3 times more in orders in a couple of weeks.

Can you please let me know what the best option is to resolve the timeout issue??

Also prevent maintenance routines from running periodically?

I have created the script and set it to run once in two days to prevent this.. but looks like the "0" setting may not be working.

Their version is below :
PLATFORM: ASP.NET
VERSION: 7.1
BUILD: 10875

Appreciate a response as soon as you guys can.

Thanks.
-sri
sri@awcs.net

[WylieE]

Is there any way to push maintenance to the evening hours when we have less traffic?

This problem of deadlocked resources is resolved in our upcoming release. The maintenance processes should not be resource intensive, however the way we implemented some of the cleanup tasks was less than desirable in high traffic situations.

Logan,

Can you elaborate on this? The process should not be resource intensive, but implementation was less than desirable in high traffic situations??

I've checked our settings and maintenance should be running every 6 hours, but I'm seeing inconsistent maintenance patterns. Acording to the app log, it ran at 8:14, 14:53 and 18:03 yesterday. Today it has run at 7:14, 10:08 and 13:27.

[Carolharry]

What is the script in AbleCommerce that calls MaintenanceWorker.runMaintenance() method on a daily basis. Did anything get installed silently to invoke this method on our server?

Appreciate any help
Thanks,
Carol.