Errors during upgrade procedure

[mircea]

Hello,

My company purchased enterprise license for Lansweeper and we have it installed on a server, the database is on a separate SQL server.
I followed the instructions to upgrade the Lansweeper from here
http://www.lansweeper.com/forum/yaf_postst3412_Manual-database-upgrade.aspx
, but after running the SQL script I received many errors.

Please help.


Here is the output log after running the SQL script for database upgrade:

Msg 207, Level 16, State 1, Line 27
Invalid column name 'activescanning'.
Msg 207, Level 16, State 1, Line 27
Invalid column name 'Listenport'.
Msg 207, Level 16, State 1, Line 27
Invalid column name 'ConcurrentThreads'.
Msg 3728, Level 16, State 1, Line 2
'PK_tblApprovedSoftware1' is not a constraint.
Msg 3727, Level 16, State 0, Line 2
Could not drop constraint. See previous errors.
Msg 4924, Level 16, State 1, Line 1
ALTER TABLE ALTER COLUMN failed because column 'softwareVersion' does not exist in table 'tblLicenses'.
Msg 4924, Level 16, State 1, Line 2
ALTER TABLE ALTER COLUMN failed because column 'Caption' does not exist in table 'tblPortConnector'.
Msg 4924, Level 16, State 1, Line 2
ALTER TABLE ALTER COLUMN failed because column 'Description' does not exist in table 'tblServices'.
Msg 3701, Level 11, State 7, Line 2
Cannot drop the index 'tblSoftware.IX_tblSoftware', because it does not exist or you do not have permission.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tsysASServers' in the database.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'activescanning'.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'Listenport'.
Msg 207, Level 16, State 1, Line 3
Invalid column name 'ConcurrentThreads'.
Msg 1785, Level 16, State 0, Line 4
Introducing FOREIGN KEY constraint 'FK_tblPhysicalMemory_tblComputers' on table 'tblPhysicalMemory' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Msg 1750, Level 16, State 0, Line 4
Could not create constraint. See previous errors.
Msg 1785, Level 16, State 0, Line 4
Introducing FOREIGN KEY constraint 'FK_tblPhysicalMemoryArray_tblComputers' on table 'tblPhysicalMemoryArray' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
Msg 1750, Level 16, State 0, Line 4
Could not create constraint. See previous errors.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tsysAdsischedule._WA_Sys_00000002_00200768', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tsysAdsischedule._WA_Sys_00000006_00200768', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblComputerSystemProduct._WA_Sys_00000002_00DF2177', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblComputerSystemProduct._WA_Sys_00000006_00DF2177', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblComputerSystemProduct._WA_Sys_00000003_00DF2177', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblComputerSystemProduct._WA_Sys_00000004_00DF2177', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tsysDomainPasswords._WA_Sys_00000002_023D5A04', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tsysDomainPasswords._WA_Sys_00000003_023D5A04', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblSoftware._WA_Sys_00000004_02925FBF', because it does not exist or you do not have permission.00000C_084B3915', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDesktop._WA_Sys_0000000D_084B3915', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDesktop._WA_Sys_0000000E_084B3915', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDesktop._WA_Sys_0000000F_084B3915', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDesktop._WA_Sys_00000014_084B3915', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDesktop._WA_Sys_00000015_084B3915', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblCDROMDrive._WA_Sys_00000002_0C50D423', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblCDROMDrive._WA_Sys_00000005_0C50D423', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblVideoController._WA_Sys_00000012_0E04126B', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblVideoController._WA_Sys_00000017_0E04126B', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tsysASServers._WA_Sys_00000005_0EA330E9', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tsysASServers._WA_Sys_0000000A_0EA330E9', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tsysASServers._WA_Sys_00000010_0EA330E9', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDiskdrives._WA_Sys_0000000A_1209AD79', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDiskdrives._WA_Sys_0000000B_1209AD79', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDiskdrives._WA_Sys_0000000C_1209AD79', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tsysEventAlerts._WA_Sys_00000003_123EB7A3', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tsysEventAlerts._WA_Sys_00000004_123EB7A3', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblPrinters._WA_Sys_00000002_1293BD5E', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblIEBHO._WA_Sys_00000002_13BCEBC1', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblIEBHO._WA_Sys_00000003_13BCEBC1', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOSRecoveryConfiguration._WA_Sys_00000002_15702A09', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOperatingsystem._WA_Sys_00000010_1699586C', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOperatingsystem._WA_Sys_00000012_1699586C', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOperatingsystem._WA_Sys_0000002A_1699586C', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOperatingsystem._WA_Sys_0000002B_1699586C', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOperatingsystem._WA_Sys_0000002C_1699586C', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOperatingsystem._WA_Sys_0000002D_1699586C', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblPROCESSOR._WA_Sys_00000010_17C286CF', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblPROCESSOR._WA_Sys_0000000F_17C286CF', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblPROCESSOR._WA_Sys_00000003_17C286CF', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblPROCESSOR._WA_Sys_00000007_17C286CF', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblPROCESSOR._WA_Sys_0000001C_17C286CF', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblPROCESSOR._WA_Sys_0000001D_17C286CF', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblUsersInGroup._WA_Sys_00000002_1B29035F', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblUsersInGroup._WA_Sys_00000004_1B29035F', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblUsersInGroup._WA_Sys_00000005_1B29035F', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblUsersInGroup._WA_Sys_00000006_1B29035F', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblUsersInGroup._WA_Sys_00000007_1B29035F', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblUsersInGroup._WA_Sys_00000008_1B29035F', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBattery._WA_Sys_00000002_1D7B6025', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBattery._WA_Sys_00000003_1D7B6025', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBattery._WA_Sys_00000004_1D7B6025', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBattery._WA_Sys_00000005_1D7B6025', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBattery._WA_Sys_0000000B_1D7B6025', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBattery._WA_Sys_0000000C_1D7B6025', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBattery._WA_Sys_0000000D_1D7B6025', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tsysMailgroups._WA_Sys_00000002_1DB06A4F', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBIOS._WA_Sys_00000002_1EF99443', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBIOS._WA_Sys_00000006_1EF99443', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBIOS._WA_Sys_00000007_1EF99443', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBIOS._WA_Sys_00000009_1EF99443', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBIOS._WA_Sys_0000000D_1EF99443', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblBIOS._WA_Sys_0000000E_1EF99443', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOnBoardDevice._WA_Sys_00000002_1F2E9E6D', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOnBoardDevice._WA_Sys_00000003_1F2E9E6D', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOnBoardDevice._WA_Sys_00000004_1F2E9E6D', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOnBoardDevice._WA_Sys_00000005_1F2E9E6D', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOnBoardDevice._WA_Sys_00000006_1F2E9E6D', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblOnBoardDevice._WA_Sys_00000007_1F2E9E6D', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDesktopMonitor._WA_Sys_00000002_2057CCD0', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDesktopMonitor._WA_Sys_0000000B_2057CCD0', because it does not exist or you do not have permission.
Msg 3701, Level 11, State 7, Line 1
Cannot drop the index 'tblDesktopMonitor._WA_Sys_0000000C_2057CCD0', because it does not exist or you do not have permission.
Msg 3723, Level 16, State 5, Line 1
An explicit DROP INDEX is not allowed on index 'TsysWaittime.IX_TsysWaittime'. It is being used for UNIQUE KEY constraint enforcement.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'AdcomputerID' in table 'tbladcomputers' is specified more than once.
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_tblADComputers_tblComputers' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 3728, Level 16, State 1, Line 1
'PK__tblCompCustom__57BDDBAA' is not a constraint.
Msg 3727, Level 16, State 0, Line 1
Could not drop constraint. See previous errors.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'CustID' in table 'tblcompcustom' is specified more than once.
Msg 1779, Level 16, State 0, Line 1
Table 'tblcompcustom' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 1
There is already an object named 'FK_tblCompCustom_tblComputers' in the database.
Msg 1750, Level 16, State 0, Line 1
Could not create constraint. See previous errors.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'ComputerUnique' in table 'tblcomputers' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'Computer' in table 'tblcomputers' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'SiteID' in table 'tblcomputers' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'Scanserver' in table 'tblcomputers' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'ReplID' in table 'tblcomputers' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'ReplSite' in table 'tblcomputers' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'OScode' in table 'tblcomputers' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'SP' in table 'tblcomputers' is specified more than once.
Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'Description' in table 'tblcomputers' is specified more than once.
Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'Computername'.
Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'Computername'.
Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'Computername'.
Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'Computername'.
Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'Computername'.
.............................................
Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'Computername'.
Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'Computername'.
Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'Computername'.
Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'Computername'.
Msg 8102, Level 16, State 1, Line 1
Cannot update identity column 'Computername'.
The query has exceeded the maximum number of error messages. Only the first 1000 messages will be displayed.
The statement has been terminated.
The statement has been terminated.

The statement has been terminated.
The statement has been terminated.
..................................
The statement has been terminated.
The statement has been terminated.

The statement has been terminated.
The statement has been terminated.
The statement has been terminated.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
............................................................................................
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.

[Hemoco]

Why did you run this script and not the normal installer?
The database schema was already on 4.x before you ran the script.