"Timeout expired" error when upgrading
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=19636
Printed Date: 09 April 2026 at 1:15am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: "Timeout expired" error when upgrading
Posted By: fx5500
Subject: "Timeout expired" error when upgrading
Date 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?
|
Replies:
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: CinemaemCena
Date 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! |
Posted By: CinemaemCena
Date 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... |
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: CinemaemCena
Date 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.
|
Posted By: WebWiz-Bruce
Date 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. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: CinemaemCena
Date Posted: 18 September 2006 at 11:51am
| How do I do that? |
Posted By: WebWiz-Bruce
Date Posted: 18 September 2006 at 12:18pm
|
I can't remember offhand as I don't have Enterprise Manager but if you look through the settings, usually under something like properties for the database, you should find a way to increase the timeout for the database. Also check that the SQL Server you are using to update the database has permissions to create and alter tables, moving this user to DBO group in SQL Server should do this. (DBO stands for Database Owner) ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: CinemaemCena
Date Posted: 18 September 2006 at 12:39pm
|
Well, borg, I'm stuck. When I checked the timeout value was set to "Wait indefinetely". The dabase HAS permissions to create and alter tables.
But the upgrading process takes about 100 seconds and, when the final screen appears, everything is right BUT the stage 2, where the Time Out message regarding tblThreads appears.
I guess that's it for me, huh? :(
|
Posted By: WebWiz-Bruce
Date Posted: 18 September 2006 at 1:26pm
|
The only thing you can do then, as it is only the the tblThread table that there is a problem, is have a look in the version history file and manually add the new fields to the table. Luckily the only changes were to add towo new fields which I have listed below:- Changes to tblThread New fields:- 1. Hide - data type = true/false - default value = false 2. File_uploads - data type = text 255 characters For the first one in SQL server it needs to be set to binary and have the default value of 0 as SQL Sever doesn't have a true/false datatype. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: CinemaemCena
Date Posted: 18 September 2006 at 6:49pm
|
Borg, do you recommend I do this before or after running the upgrade?
And what if there's some other table that should've been created but wasn't because of the tblThread time out? I mean... after doing the tblThread, the program would upgrade other tables, wouldn'it?
|
Posted By: WebWiz-Bruce
Date Posted: 19 September 2006 at 10:55am
|
Do this after the upgrade. As the only error message is a timeout on that particular table the other tables should have been created and updated successfully. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: CinemaemCena
Date Posted: 21 September 2006 at 2:18am
|
Ok, I did everything like you said. But now, when I click on any topic of the forum, I get the message: Microsoft VBScript runtime error '800a005e'Invalid use of Null: 'CBool' /forum/forum_posts.asp, line 779
|
Posted By: WebWiz-Bruce
Date Posted: 21 September 2006 at 7:40am
|
It maybe then that the other new fields are also not created. You may need to go through the version history file and create all fields manually if you can not findout why your database is timing out when alterations are applied to the tables. I still think it would be a permissions issue and that the user you are logging into the SQL Server with doesn't have sufficient permissions to alter tables. Try logging in with the 'sa' account for doing the database upgrade. Also a SQL Server site may be able to give you better advice on dealing with issues with SQL Server as it can be quite a complex database system. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: jeffdaro
Date Posted: 21 September 2006 at 1:45pm
|
Just to add to the mix...our install went fine, but timeouts seem to be a daily issue with our forums. I've been blaming it on my ISP. Just my 2 cents... |
Posted By: CinemaemCena
Date Posted: 22 September 2006 at 2:38am
|
This is really frustrating. I went to the Version History file and I compared everything to what I had on my SQL server AFTER the upgrade. There were some discrepancies in some tables, but most of them were correctly created during the ugprade (I noticed some oddities, like data type "text" were constantly substituted by nvchar). So that invalidates the theory that my "user" isn't allowed to do modifications. I also noticed that even in the tables that had new fields added, NO fields were deleted - so I deleted the fields according to the Version History.
After altering everything according to the Version History, I STILL got the Cbool (line 779) error.
Then I went to this thread ( http://forums.webwiz.net/forum_posts.asp?TID=20931&KW=line+779 - http://forums.webwiz.net/forum_posts.asp?TID=20931&KW=line+779 ) and I tried entering the "bit" datatype instead of the "bin" datatype that you suggested (default value still (0)).
Guess what? It still didn't work.
So I officially give up on having the 8.04 version. I'll stay with 7.97, because I honestly can't think of anything else I could do.
Can you? Anyone? :(
|
Posted By: CinemaemCena
Date Posted: 22 September 2006 at 3:36am
|
Ok, I went into the Version History txt file and then compared it to what I had on my database after the upgrade. Maybe if I describe everything in details you'll be able to figure out what's going on.
The differences I found:
tblForum
1) none of the fields that should've been deleted were in fact deleted. And the field Read appeared in my database as [Read]; 2) VH (Version History) said: "Sub_ID - data type = interger - default value = 0". But my DB had datatype as "smallint" (lenght=2. Is that right?)
3) VH said: "Last_post_author_ID - data type = interger". Again, my DB had datatype as "smallint".
4) VH said: "Last_post_date - data type = date/time - default value = now()/GetDate()". My DB had default value as "(getdate())"
5) The field Display was NOT created.
tblTopic
1) The fields Start_date and Last_entry_date were NOT deleted. 2) The fields "Start_Thread_ID", "Last_Thread_ID" and "No_of_replies" had their datatypes in VH as "interger". In my DB, however, it was set to "int". Why "int" and not "smallint" like what happened in the "tblForum"?'
3) The field "Icon", in VH, said datatype as "text". In my DB, it was set to "nvarchar".
4) The field "Hide", in VH, said datatype as "true/false" (def. val. as false). In my DB it said "bit" and def. value as (0).
5) The field "Event-Date", in VH, said datatype as "date". In my DB it's "datetime", but I guess it's correct.
tblThread
1) None of the new fields were created. And there's no "true/false" datatype. you said before I should use "bin". In the thread I linked to in my last post, the user said he used "bit". Which one is the correct? (I guess the default value is (0). tblPermission 1) In VH, it says "Display_posts" datatype true/false. In my DB it says "bit". In VH, it doesn't say which should be the default value, but the upgrade file sets it to (0) (false, isn't it?). 2) In VH, the new field "Calendar_event" is set to datatype "boolean". In my DB, it says "bit" (default value = (0)). tblAuthor
1) In VH, "No_of_PM" has datatype as "interger". In my DB, as "int". I still don't know why interger was substituted with "smallint" in the tblForum. And so on... (yes, I got tired). The pattern is the same in the rest: "interger" for "int", "boolean" for "int", etc, etc, etc.
|
Posted By: CinemaemCena
Date Posted: 22 September 2006 at 4:31am
|
I DID IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
I restarted the whole proccess. Same timeout error while updating tblThread (I still don't know why). After the upgrade was done, I checked every table. Everything was ok (except for the field the weren't deleted. Can I let them on the database or do I have to delete them?).
Then I went to the tblThread and I created the new fields.
You gave me the wrong info, Borg!
 It's not "binary", it's "bit". And then there's the catch. It AUTOMATICALLY selects ALLOW NULL. It's necessary to uncheck it. And it has to be done the first time, before you save the new table. If you save it with the NULL option, you can't change it afterwards. I Mean... you CAN, but the forum still won't work.Anyway... I DID IT!!!! :)
Well... with your help and the help of the user who posted the thread I linked in a post above.
THANK YOU!
|