Hi
I just upgraded to the latest version of Lansweeper and I noticed that status of scanning stop for a bit then start up, is this normal?
I also saw some error in the errorlog.txt
02/13/2013 13:12:27: Starting update: upgradescript20
02/13/2013 14:08:58: upgradescript20:Error converting data type varchar to numeric.
02/13/2013 14:08:58: upgradescript20:Error converting data type varchar to numeric.
02/13/2013 14:08:59: upgradescript20:Error converting data type varchar to numeric.
02/13/2013 14:08:59: upgradescript20:Error converting data type varchar to numeric.
02/13/2013 14:29:58: upgradescript20:Column names in each table must be unique. Column name 'BuildInAdmin' in table 'dbo.tblUsersHist' is specified more than once.
02/13/2013 14:34:32: upgradescript20:Cannot drop the table 'dbo.Tsysservicestatus', because it does not exist or you do not have permission.
02/13/2013 14:34:41: upgradescript20:Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
02/13/2013 14:34:41: upgradescript20:Violation of PRIMARY KEY constraint 'PK_tsysactions'. Cannot insert duplicate key in object 'dbo.tsysactions'.
The statement has been terminated.
02/13/2013 14:42:44: web30repweb40repAllWorkstationsITD:Invalid column name 'Bias'. Select Top 1000000 upgrade_tblcomputers.Computer, upgrade_tblcomputers.Domain, upgrade_web40osname.OSname, upgrade_web40osname.SP, upgrade_tbloperatingsystem.Description, upgrade_web40osname.Compimage As icon, upgrade_tblcomputersystem.Model, upgrade_tblbios.SerialNumber, upgrade_tblnetwork.IPAddress, upgrade_tbladcomputers.Comment, upgrade_tbladcomputers.OU, upgrade_tblcomputers.Lastseen, upgrade_tblntlogevent.Eventcode, upgrade_tblntlogevent.Eventtype, upgrade_tblntlogevent.Logfile, upgrade_tblntlogevent.Message, upgrade_tblntlogevent.Sourcename, upgrade_tblntlogevent.TimeGenerated, upgrade_tblntlogevent.[User], upgrade_tblntlogevent.Bias From upgrade_tblcomputersystem Inner Join upgrade_tblcomputers On upgrade_tblcomputersystem.Computername = upgrade_tblcomputers.Computername Inner Join upgrade_web40activecomputers On upgrade_tblcomputers.Computername = upgrade_web40activecomputers.Computername Inner Join upgrade_web40osname On upgrade_web40osname.Computername = upgrade_tblcomputers.Computername Inner Join upgrade_tbloperatingsystem On upgrade_tblcomputers.Computername = upgrade_tbloperatingsystem.Computername Inner Join upgrade_tblbios On upgrade_tblcomputers.Computername = upgrade_tblbios.Computername Inner Join upgrade_tblnetwork On upgrade_tblcomputers.Computername = upgrade_tblnetwork.Computername Inner Join upgrade_tbladcomputers On upgrade_tblcomputers.Computername = upgrade_tbladcomputers.Computername Inner Join upgrade_tblntlogevent On upgrade_tblcomputers.Computername = upgrade_tblntlogevent.Computername Where upgrade_tblcomputers.Computer Like 'K5X%' And Not (upgrade_tblnetwork.IPAddress Is Null) And upgrade_tblcomputers.Lastseen > '09/01/2010' And upgrade_tblcomputersystem.Domainrole < '2' And Not (upgrade_tblnetwork.IPAddress Is Null) And Not (upgrade_tblnetwork.IPAddress = '') And Not (upgrade_tblnetwork.IPAddress = '0.0.0.0')
02/13/2013 14:42:47: web30repweb40repAllWorkstationsITD:Invalid column name 'Bias'. Select Top 1000000 upgrade_tblcomputers.Computer, upgrade_tblcomputers.Domain, upgrade_web40osname.OSname, upgrade_web40osname.SP, upgrade_tbloperatingsystem.Description, upgrade_web40osname.Compimage As icon, upgrade_tblcomputersystem.Model, upgrade_tblbios.SerialNumber, upgrade_tblnetwork.IPAddress, upgrade_tbladcomputers.Comment, upgrade_tbladcomputers.OU, upgrade_tblcomputers.Lastseen, upgrade_tblntlogevent.Eventcode, upgrade_tblntlogevent.Eventtype, upgrade_tblntlogevent.Logfile, upgrade_tblntlogevent.Message, upgrade_tblntlogevent.Sourcename, upgrade_tblntlogevent.TimeGenerated, upgrade_tblntlogevent.[User], upgrade_tblntlogevent.Bias From upgrade_tblcomputersystem Inner Join upgrade_tblcomputers On upgrade_tblcomputersystem.Computername = upgrade_tblcomputers.Computername Inner Join upgrade_web40activecomputers On upgrade_tblcomputers.Computername = upgrade_web40activecomputers.Computername Inner Join upgrade_web40osname On upgrade_web40osname.Computername = upgrade_tblcomputers.Computername Inner Join upgrade_tbloperatingsystem On upgrade_tblcomputers.Computername = upgrade_tbloperatingsystem.Computername Inner Join upgrade_tblbios On upgrade_tblcomputers.Computername = upgrade_tblbios.Computername Inner Join upgrade_tblnetwork On upgrade_tblcomputers.Computername = upgrade_tblnetwork.Computername Inner Join upgrade_tbladcomputers On upgrade_tblcomputers.Computername = upgrade_tbladcomputers.Computername Inner Join upgrade_tblntlogevent On upgrade_tblcomputers.Computername = upgrade_tblntlogevent.Computername Where upgrade_tblcomputers.Computer Like 'K5X%' And Not (upgrade_tblnetwork.IPAddress Is Null) And upgrade_tblcomputers.Lastseen > '09/01/2010' And upgrade_tblcomputersystem.Domainrole < '2' And Not (upgrade_tblnetwork.IPAddress Is Null) And Not (upgrade_tblnetwork.IPAddress = '') And Not (upgrade_tblnetwork.IPAddress = '0.0.0.0')
02/13/2013 14:42:48: Starting update: upgradescript21
02/13/2013 14:42:48: Starting update: upgradescript22
02/13/2013 14:42:48: Starting update: upgradescript23
02/13/2013 14:43:41: Starting update: upgradescript24
02/13/2013 14:43:41: Starting update: upgradescript25
02/13/2013 14:43:42: Starting update: upgradescript26
02/13/2013 14:43:42: Starting update: upgradescript27
02/13/2013 14:43:42: Starting update: upgradescript28
02/13/2013 14:43:42: Starting update: upgradescript29
02/13/2013 14:43:42: Starting update: upgradescript30
02/13/2013 14:43:42: upgradescript30:Violation of PRIMARY KEY constraint 'PK_tblstate'. Cannot insert duplicate key in object 'dbo.tblstate'.
The statement has been terminated.
02/13/2013 14:43:43: Starting update: upgradescript31
02/13/2013 14:43:43: Starting update: upgradescript32
02/13/2013 14:43:43: Starting update: upgradescript33
02/13/2013 14:43:43: Starting update: upgradescript34
02/13/2013 14:43:43: Starting update: upgradescript35
02/13/2013 14:43:43: Starting update: upgradescript36
02/13/2013 14:43:43: upgradescript36:Violation of PRIMARY KEY constraint 'PK_tsysAssetTypes'. Cannot insert duplicate key in object 'dbo.tsysAssetTypes'.
The statement has been terminated.