| Author |
 Topic Search  Topic Options
|
txwaterfowler 
Newbie
Joined: 05 September 2011
Location: Texas
Status: Offline
Points: 13
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Issue Upgrading SQL Server Database to v10.x
Posted: 05 September 2011 at 8:19am |
I'm consistently getting the following error or some variation when trying to update SQL2000 database from v9.71 to either v10.02 or v10.03. I confirmed with the host that I have dbo rights on the database. Is there a way to increase the timeout??
---------------------------
Your Database is being updated. Please be patient as this may take a few minutes to complete.
Stage 1: Creating New Database Tables and Fields.....
Error Altering the Table tblThread Timeout expired.Complete
Stage 2: Entering default values for new fields..... Complete
Stage 3: Migrating forum configuration settings to new format..... Complete
Stage 4: Migrate Post Count to new Point System (this may take some time to complete)..... Complete
Timeout expired
SQL Server database is updated, but with Error!
|
 |
txwaterfowler
Newbie
Joined: 05 September 2011
Location: Texas
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 September 2011 at 8:33am |
Another variation after a database restore ...
--------------------------------
Your Database is being updated. Please be patient as this may take a few minutes to complete.
Stage 1: Creating New Database Tables and Fields.....
Error Altering the Table tblTopic Timeout expired.
Error Altering the Table tblThread Timeout expired.Complete
Stage 2: Entering default values for new fields..... Complete
Stage 3: Migrating forum configuration settings to new format..... Complete
Stage 4: Migrate Post Count to new Point System (this may take some time to complete)..... Complete
Timeout expired
SQL Server database is updated, but with Error! |
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 September 2011 at 8:38am |
|
It would appear to be a time out with the database connection. This would be set on the database server and you would need to get your SQL Server DB Admin to increase the timeout for database queries.
|
|
|
|
txwaterfowler
Newbie
Joined: 05 September 2011
Location: Texas
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
Posted: 05 September 2011 at 10:45pm |
Thanks for the quick response.
My host is telling me they will not change the timeout on the shared database server.
Any other option to keep retrying the table updates?
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 06 September 2011 at 8:37am |
|
I presume that either your database has allot of topics and posts or the timeout is set very low on the database.
There are new fields added to the tables tblTopic and tblThread which means that the database table would need to be rebuilt when the fields are added. If the timeout on the database server is set to low to add these new fields then you would get these errors.
If your host can not change the timeout the only options are to do the upgrade on another database server.
|
|
|
|
txwaterfowler
Newbie
Joined: 05 September 2011
Location: Texas
Status: Offline
Points: 13
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 September 2011 at 3:02am |
The host has tried a few things but still unsuccessful thus far ...
I've had this forum on SQL2K since 2004 ... successfully upgraded a several times until now.
Topics - approx 22,000 Posts - approx 265,000
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 September 2011 at 10:59am |
In previous upgrades your database was probably much smaller. Unfortunately the only solution would be to either install everything on your local PC or find another host that can give you more resources. We are a web host so you could host with us if you wished to and we could then also do the upgrade for you. Also as we use SQL Server 2008 R2 it means that you would be able to use the server side paging which is not available in SQL Server 2000. A forum of your size really needs to the server side paging. We can host your whole website and forum under our Web Site Hosting, or just your forum under our Web Wiz Forums Hosting.
|
|
|
|
hummelmose
Newbie
Joined: 05 November 2009
Status: Offline
Points: 18
|
Post Options
Thanks(0)
Quote Reply
Posted: 15 April 2012 at 4:44pm |
Hi.
I'm an administrator on a WebWiz 9.7 forum, who wishes to upgrade. We're running SQL server 2005, and have administrative rights on our database. Allthough script timeout is set to 0 (no timeout) we get the following error:
I've triede 10 times, and gets the same error every time.
http://dl.drop.com/u/65950/15-04-2012%2017-37-12.png - http://dl.drop.com/u/65950/15-04-2012%2017-37-12.png
|
|
