Page 1 of 1
Error in page tracking log maintenance
Posted: Mon Feb 09, 2009 6:21 pm
by 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?
Re: Error in page tracking log maintenance
Posted: Wed Feb 11, 2009 1:06 pm
by 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,
Re: Error in page tracking log maintenance
Posted: Wed Feb 11, 2009 3:49 pm
by Logan Rhodehamel
WylieE wrote: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.
Re: Error in page tracking log maintenance
Posted: Wed May 20, 2009 3:54 am
by 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
Re: Error in page tracking log maintenance
Posted: Mon Aug 10, 2009 2:08 pm
by WylieE
Logan_AbleCommerce wrote:WylieE wrote: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.
Re: Error in page tracking log maintenance
Posted: Fri Jan 29, 2010 3:20 pm
by 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.