| Author |
 Topic Search  Topic Options
|
fx5500 
Groupie
Joined: 30 July 2005
Location: Turkey
Status: Offline
Points: 64
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: "Timeout expired" error when upgrading
Posted: 30 April 2006 at 10:09pm |
Hello.
I am using 7.9 with MSSQL version. When I am trying to upgrade to 8.0 with upgrade tool, there are some errors. I am writing all of them..
-----------------------------------------------------------------------------
Database Updated Started
Stage 1: Database Connection..... Complete
Stage 2: Creating New Database Tables and Fields.....
Error Update the Table tblThread
Timeout expired
Complete
Stage 3: Creating Index's on database..... Complete
Stage 4: Entering default values for new fields..... Complete
Stage 5: Populating Database with Default Forum Permissions (this may take some time to complete).....
Permissions are reset to original defaults, you may need to update them once the upgrade is complete.
Complete
Stage 6: Populating Database with Forum Statistics (this may take some time to complete).....Complete
Stage 7: Populating Database with Topic Statistics (this may take some time to complete)..... Complete
Error Discription: Timeout expired
SQL Server database is set up, but with Error!
----------------------------------------------------
There are only one error. What should I do. Should I start again upgrade tool one more time? Or upgrading is over?
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 02 May 2006 at 12:58pm |
|
This seems very odd and the only thing I can think would course this is if the server was underload at the time and rejected the connection as creating the new fields on the tblThread table should take seconds to complete.
I would go back to your original backedup 7.x database and run the upgrade tool again. This time at a time you believe to be quite so that this error doesn't occur again.
|
|
|
|
CinemaemCena
Groupie
Joined: 05 February 2006
Status: Offline
Points: 46
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 September 2006 at 5:20am |
It's also happening to me!
Database Updated Started
Stage 1: Database Connection..... Complete
Stage 2: Creating New Database Tables and Fields.....
Error Update the Table tblThread
Timeout expired
Complete
Stage 3: Creating Index's on database..... Complete
Stage 4: Entering default values for new fields..... Complete
Stage 5: Populating Database with Default Forum Permissions (this may take some time to complete).....
Permissions are reset to original defaults, you may need to update them once the upgrade is complete.
Complete
Stage 6: Populating Database with Forum Statistics (this may take some time to complete).....Complete
Stage 7: Populating Database with Topic Statistics (this may take some time to complete)..... Complete
Error Discription: Timeout expired
SQL Server database is set up, but with Error!
|
|
CinemaemCena
Groupie
Joined: 05 February 2006
Status: Offline
Points: 46
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 September 2006 at 5:21am |
|
And, just to complete the info, I'm pretty sure right now my server is not too loaded...
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 September 2006 at 8:43am |
|
The timeout is occurring at stage 2 which creates the new tables and fields in the database required for version 8.
This stage should only at most take a few seconds to complete, how long is it taking before you see the timeout?
If it is taking sometime then you need to look at your SQL Server and try and workout why it's not updating quickly with te new fields, it could be that other users are using the SQL Server and the tables are locked, thus an update on the tables can not be performed.
Before running the database update tool make sure you have removed the old version 7 from the server, also try stopping and restarting the SQL Server, as this may flush out any connections which have remained open on the database which may course the tables being updated to be locked from any alterations.
|
|
|
|
CinemaemCena
Groupie
Joined: 05 February 2006
Status: Offline
Points: 46
|
Post Options
Thanks(0)
Quote Reply
Posted: 17 September 2006 at 5:40pm |
boRg,
the update screen doesn't show me step by step as described in the txt file. Instead of that, I only see the top of the screen and, in the status bar, I see that the process is going on, but I'm not informed of in which stage the process is right now. Suddenly, everything appears: all the info about all the steps. Everything was completed perfectly, except fot the stage 2.
I tried upgrading the form at 4am last night. I rebooted the server, then I reiniciated IIS, then I deleted all files from 7 version and ONLY THEN I run the upgrade. And... timeout again.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 18 September 2006 at 9:39am |
|
You didn't mention how long the process is taking to complete.
If it is quite quick it could be an issue with your SQL server setup to timeout on connections to quickly.
Try increasing the timeout value of the SQL Server and see if that resolves the issue.
|
|
|
|
CinemaemCena
Groupie
Joined: 05 February 2006
Status: Offline
Points: 46
|
Post Options
Thanks(0)
Quote Reply
Posted: 18 September 2006 at 11:51am |
|
How do I do that?
|
|
