Timeout Expired
Printed From: ProductCart E-Commerce Solutions
Category: ProductCart
Forum Name: Using ProductCart
Forum Description: Running your store with ProductCart
URL: https://forum.productcart.com/forum_posts.asp?TID=4036
Printed Date: 01-November-2024 at 1:30am
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com
Topic: Timeout Expired
Posted By: Orion
Subject: Timeout Expired
Date Posted: 29-September-2010 at 8:28pm
I am running Product Cart 4.1 SP1. I seem to have a lot of errors on a daily basis, as follows:
Source: Microsoft OLE DB Provider for SQL Server
Description: Timeout expired
In the Knowledge Base there appears to be a fix for this by changing the storeconstants.asp file. However, my storecontstants file doesn't look anything like the one shown in the fix. Just wondering if this is an old fix and if is there a new one I should be trying or any other suggestions for running without these errors.
Thanks
|
Replies:
Posted By: Guests
Date Posted: 30-September-2010 at 8:12pm
This is curious.
Have you actually experienced one of these timeouts? Was it while doing something intensive in your control panel?
If something's timing out on your front end, it would be better to address the issue than to band aide by extending the script timeout.
|
Posted By: Orion
Date Posted: 30-September-2010 at 8:29pm
I found all these timeouts in my error log. About 20 or more per day and the url on all is viewPrd.asp.
Thanks for helping
|
Posted By: Guests
Date Posted: 30-September-2010 at 10:59pm
Ok, that's a really bad sign.
What about viewcategories.asp?
Anyways, it's timing out when your customers are viewing pages, and this is really bad.
Who is your host?
Can you provide your domain name so that we have have a look?
Are you using custom search fields?
|
Posted By: Orion
Date Posted: 01-October-2010 at 6:07am
Host is crystaltech
Not finding anything on viewcategories
No custom search fields.
caninedesigns.com
So is this a hosting issue and not a product cart issue? Maybe I need to move. Error free at WMS?
|
Posted By: Guests
Date Posted: 01-October-2010 at 1:37pm
Oh, Hi Sally.
I don't mean to suggest that it is a hosting issue, but it's a possibility(for instance, the dreaded GoDaddy hosting). Crytaltech is a reputable host, though.
I popped into your control panel to look at the errors; indeed, a ton of these timeout errors on product pages. Something is definitely not right.
I clicked around on your site hitting product pages from various places, and while it could maybe be a little snappier, I didn't see anything suggestive, and didn't get anything close to a timeout error (though there is something wrong with your viewcategories page).
It doesn't look like an issue with the application itself, but I recall that you had an issue with the product page when upgrading to 4.11, so let me know if it's ok if I swap out your product page files with out of box 4.11 files just to rule out anything there (but I doubt that's it).
Find out from Crytaltech if your hosting account is in a dedicated application pool. Given that I don't see any evidence that the issue is with the application, that makes the hosting environment suspect.
|
Posted By: katharina
Date Posted: 01-October-2010 at 1:51pm
We had that issue with our past host, and it is not a good thing when customers experience it. They put us one a semi dedicated server and we still had some issues. They extended the server time and it worked better. Eventually it got worse again. I guess their were putting to many customers onto that server. We are now with joltdigital.com. They are specialized with product cart and know their stuff. The switch was the best thing ever, they even transfered all the files from the old site to the new one free of charge. Before we even had time out issues running sales reports. It's all gone now and the site runs fast and smoothly. I'm sure there are other good hosts, but I'm talking out of our experience.
-------------
Katharina
*******************
www.GermanPlaza.com
*******************
|
Posted By: Orion
Date Posted: 01-October-2010 at 2:00pm
Thanks so much for the wonderful help Sean. You are super! Yes, please go ahead and swap out those files. It could be that. I am not on a dedicated pool but I can be. It got complicated so I'll be in touch.
Your input was most helpful too katharina. Greatly appreciated and good to know that I'm not the only one experiencing this.
|
Posted By: Guests
Date Posted: 01-October-2010 at 2:35pm
Hi Sally,
Well, if your sites not running in a dedi application pool, that's the first thing you should change, as that means the performance of other sites in the general application pool can affect the performance of your site even if there's nothing amiss with your application itself.
I'll swap out the files, but I'm 98% sure now that the issue is with your hosting environment.
|
Posted By: Orion
Date Posted: 01-October-2010 at 2:57pm
Hi Sean,
I'm trying to change to a dedicated pool. But I need to change the database from 2005 to 2008. Anyway I need your expert help but your phone is doing the same as my database - and I can't reach you.
Don't worry about swapping out those files.
Thanks
|
Posted By: Guests
Date Posted: 01-October-2010 at 3:01pm
I don't see how putting your site in a dedi app pool has anything to do with what platform your db is running on.
Sorry about the phone: busy phone day this morning. I'm calling you now.
|
Posted By: katharina
Date Posted: 01-October-2010 at 3:11pm
You have to be careful when converting from 2005 to 2008. My last host did that and did not warn us about it. They screwed up the database completely and it took hours to rebuild it. We were out of business for solid 3 days! There is only one person you can call for the repair, because EI would not even touch it since they are not database specialist. Mark Shipp is the only one competent enough to do it, since his specialty is databases and PC. It took him hours to repair it, plus you have to be careful when upgrading to newer version of PC once you run 2008, because the script may not work right when fields have to be added to the database. Here is the info just in case you need it.
Mark D.
Shipp
Cognecy Solutions,
LLC
5100 Eldorado
Pkwy. Ste.102 -
PMB716
McKinney, TX
75070
Tel: 214-206-8910
E-mail: mailto:mark@cognecy.com - - www.cognecy.com
www.yBasket.com -
-------------
Katharina
*******************
www.GermanPlaza.com
*******************
|
Posted By: Guests
Date Posted: 01-October-2010 at 3:35pm
|
Thanks, Katharine. Yeah, I just spoke with Sally and enlightened here about all of this. She's getting back to Crytaltech. There's just no reason she should have to change database platforms in order to have her site run in a dedi app pool.
|
Posted By: Greg Dinger
Date Posted: 01-October-2010 at 3:50pm
|
Katherina,
Just to be clear, I (and presumably others such as Sean, etc. - but I can speak with certainty about myself) migrate databases from SQL 2005 to SQL 2008 all the time. The transition from one to the other is really nothing magical or difficult.
For example, I operate out of a pair of data centers. SQL2k5 in the old one, 2k8 in the new one. Every time I migrate a site from the old network to the new one, I migrate the database. Not rocket science...
And FWIW, Mark and I collaborated in the development of a special script that upgrades the data types during such conversions so that the columns in the upgraded databases comply with current standards.
It's really not that big a deal, it's just that the idiots who hosed your site were clueless and irresponsible.
So while I entirely stand by the assertion that Mark is very good at what he does, and I hire him for every complex database handling requirement that comes my way, for something as lame as upgrading a SQL DB from 2k5 to 2k8, Mark is not the only talent around here who can pull that off.
Thanks.
-------------
GreyBeard Design Group
Certified ProductCart Developer
Web Design/Development/Hosting
http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |
|
Posted By: Guests
Date Posted: 02-October-2010 at 2:05am
Ok, yeah, Greg's point is true, but Mark is rather the Database Admin guru in this community and is well work the accolades in that niche, Katherina.
He knows his stuff well, and it's worth mentioning him and/or pinging him on database issues even though other experienced folks in this community are also knowledgeable.
I think maybe that the important point here is that not all hosting companies are so knowledgeable. Not even quite sure if Jolt is, and they are pretty much THE hosting company that is really dialed into ProductCart hosting. We Certified ProductCart Developers tend to have a lot more insight into all of this, and several of us also offer hosting solutions (though our boutique hosting may not be the right fit for everyone; I'll be the fist to admit that).
Hosting is not quite the commodity that I think most folks think it is. Knowing well the applications one hosts is crucial, and frankly your boutique hosts are going to be a lot more focussed on that and more concerned with your specific business than any hosting company, including Jolt (who is an excellent PC oriented hosting company IHMO).
If you just have an out of the box type ProductCart store, Jolt is my recommendation. If you have any special requirements, then you should hit up the Certified ProductCart Developers up that provide hosting such as GBDG: http://www.greybearddesign.com/, WMS: http://www.wmsmerchantservices.com/ or Cognecy: http://cognecy.com/
|
Posted By: Orion
Date Posted: 02-October-2010 at 2:55pm
I'm almost there after 2 attempted plan changes and numerous calls to tech support, it would seem that my best option would be upgrading to a newer, twice the speed, server which runs ASP.NET 3.5
Anyway they suggested I post over here before making that change to make sure that Product Cart will have no issues with ASP.NET 3.5. So if someone could let me know that all will be good on 3.5, I'd appreciate it.
Thanks to all for help on this and especially to Sean for his endless patience!
|
Posted By: ProductCart
Date Posted: 02-October-2010 at 2:59pm
Yes - ProductCart will run just fine on a server running v3.5 of the .NET framework.
-------------
The ProductCart Team
Home of ProductCart http://www.productcart.com" rel="nofollow - shopping cart software
|
Posted By: Greg Dinger
Date Posted: 02-October-2010 at 3:03pm
|
Yeah, but what does that have to do with how a .ASP site will run?
I just don't understand the guidance these people are giving you. First there is the question of migrating to SQL2k8 in order to get to a dedicated application pool, and now they are talking what version of .NET a box is running in order to get you to a faster server.
Are they proposing to increase your hosting fee in this process?
-------------
GreyBeard Design Group
Certified ProductCart Developer
Web Design/Development/Hosting
http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |
|
Posted By: Orion
Date Posted: 02-October-2010 at 3:14pm
Thanks at least I know I can make that move safely.
No, monthly charges will remain the same. Apparently the only plan they have, at same cost, with dedicated application pool would require moving to SQL 20008. I decided against that.
Another tech support person told me another plan had dedicated app pool. However, when I changed to that, I got an e-mail back saying it didn't have dedicated app pool.
Had a long talk to someone this morning who suggested a semi-dedicated which would have been a mammoth jump in price but is now suggesting the ASP.NET 3.5 server because he thinks that because it is much faster and newer I may not get the timeouts I'm experiencing on the antique server I'm on at the moment.
Since I haven't the foggiest, I am just going with their advice and thought it couldn't hurt to try.
|
Posted By: Greg Dinger
Date Posted: 02-October-2010 at 3:48pm
|
I have little patience for this sort of inept handling of this stuff. Getting more than one story from various individuals and having to jump through hoops like this is silly.
If this next step does not work out, and since it sounds like you already have a relationship with Sean, it might make sense for you to jump ship from that host and move to Sean or any of the others among us who know PC. I just would not put up with it.
-------------
GreyBeard Design Group
Certified ProductCart Developer
Web Design/Development/Hosting
http://tinyurl.com/5c8t4t" rel="nofollow - Add-Ons & Custom Code |
|
Posted By: Guests
Date Posted: 02-October-2010 at 4:00pm
I have to admit, I am baffled by CrystalTech's responses here too.
What is such a big deal with assigning a dedi application pool? Any server set up to run any version of ASP.NET should be default be putting sites in dedi application pools as .NET sites pretty much require that (they need to run as their own applications). And what the database platform has to do with being in a dedi application pool is completely beyond me.
If their control panel doesn't automatically do this (which it should) all they have to do is go into IIS create a new application pool, then open your site properties and assign your site to that application pool. Boom done. Would take about as much time and less effort than it took me to type this paragraph.
Sally, let's start planning a migration for you next week. Meanwhile this really should be such a simple thing for them to do in the interim. I'm baffled.
|
Posted By: Orion
Date Posted: 02-October-2010 at 4:05pm
Greg,
Thank you for that very sound piece of advice. I definitely agree and have discussed with Sean. Will probably relocate over there in the next few months and am looking forward to it. I know he'll make sure all will be working fine.
|
Posted By: Orion
Date Posted: 02-October-2010 at 7:17pm
Sean,
I missed your last post. Must have crossed with mine.
Next week works for me. Sounds good.
|
|