Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
NeilL
Engaged Sweeper
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.

1 REPLY 1
Hemoco
Lansweeper Alumni
Please contact support@lansweeper.com and provide us with:
- Any install logs present in Program Files (x86)\Lansweeper\Install on your Lansweeper server.
- A copy of your complete Errorlog.txt file.

Archive

This board contains archived posts from the retired Lansweeper Forum and Insiders Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now