Upgrade: 1.9 >>> 2.0.5
My current database version is 1.9.
I've created a test environment on a separate machine running WinXP, IIS 5.1, .NET v1.1 & SQL Server 2000 sp4.
I created a backup of the current database and have restored it into the test environment, ran the upgrade scripts etc and noticed a couple of error messages when a couple of the scripts executed but ignored them initially.
I have been able to access Default.aspx no problem but experiencing problems when trying to login. Symptoms are that ASPNETWP.exe process runs at approx. 50% utilisation for ages, progress bar reaches 100% on the page but nothing loads and it seems the database table "errorlog" is filling up with a very large number of errors.
I've since deleted the database and restarted the upgrade process from scratch taking note of the error messages reported when executing the upgrade scripts (see below).
After running "Upgradev1-9.sql" I get the following:
* MESSAGES
Server: Msg 207, Level 16, State 3, Line 2
Invalid column name 'estimatedeffortdays'.
Server: Msg 207, Level 16, State 1, Line 2
Invalid column name 'estimatedeffortdays'.
Server: Msg 207, Level 16, State 1, Line 3
Invalid column name 'estimatedefforthours'.
Server: Msg 207, Level 16, State 1, Line 3
Invalid column name 'estimatedefforthours'.
****
I presume the below portion of the upgrade script is resulting in the reported messages as above:
"
update issues set estimatedays=cast(estimatedeffortdays as numeric(10,0)) where isnumeric(estimatedeffortdays)=1
update issues set estimatehours=cast(estimatedefforthours as numeric(10,0)) where isnumeric(estimatedefforthours)=1
"
Is "CAST", used in the SQL statement trying to convert the column names as well?
Then after running "UnicodeUpgrade.sql" I get the following:
MESSAGES
Server: Msg 4924, Level 16, State 1, Line 61
ALTER TABLE ALTER COLUMN failed because column 'estimatedeffortdays' does not exist in table 'issues'.
*****
The cause of the message above is obvious since the column, indeed, does not exist.
Are you able to enlighten me CounterSoft, many thanks.
|
Groins_NZ
· 1 |
|
| Tuesday, August 1, 2006, 12:41:32 AM | |
