3.5 Upgrade - Column 'nonactive' does not belong to table...

[rmeleiro]

Good afternoon
After upgrading from 3.2 to 3.5 and running the upgrade procedures, the default page of Lansweeper presents this error:

Column 'nonactive' does not belong to table theTable.

The service is up and running, with a status being written to errlog.txt

Could this be a upgrade problem or something else altogether?

Regards

Rui Meleiro

[rmeleiro]

Upgraded from 3.2, skiped the beta version (never install betas on production environments).
Regards

Rui Meleiro

[rmeleiro]

Ok, fixed. In fact the TsysConfig table had the activescanning column as null. Changed it to 1 (true). Restarted the service. Worked like a charm.
Now, I hadn't referred it earlier, as I though it had nothing to do: when upgrading, the license key disappeared, downgrading the product to freeware. Reentered the license, changed back to Premium; side effect - the latter.

Regards

Rui Meleiro

[Hemoco]

rmeleiro wrote:
when upgrading, the license key disappeared

Did you upgrade from the beta version or from 3.2?

[Hemoco]

See this thread :
http://www.lansweeper.com/forum/yaf_postsm5762_Fix-Operator--is-not-defined-for-type-DBNull-and-type-Boolean.aspx#5762

[esullivan]

As per your suggestion in another thread, I read through here. I reran the script and get

There is already an object named 'TsysConfig' in the database

[Jrobinson]

esullivan wrote:
As per your suggestion in another thread, I read through here. I reran the script and get

There is already an object named 'TsysConfig' in the database

I am getting the same message. Tried to rerun the SQL upgrade also.

This is what I got running it in the management console. It seems to be OK now

Msg 2714, Level 16, State 6, Line 1
There is already an object named 'TsysConfig' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'TsysMemorytypes' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'TsysSerials' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'Tsysservicestatus' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tblCompCustom' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tblPhysicalMemory' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tblPhysicalMemoryArray' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tblstate' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tsysActiveScanDomains' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tsysActiveScanOU' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tsysDomainPasswords' in the database.
Msg 2714, Level 16, State 6, Line 2
There is already an object named 'tblSerialnumber' in the database.
Msg 1779, Level 16, State 0, Line 2
Table 'tblSerialnumber' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_tblSerialnumber_tblComputers' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'TsysConfig' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'TsysMemorytypes' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'TsysSerials' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'Tsysservicestatus' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tblCompCustom' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tblPhysicalMemory' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tblPhysicalMemoryArray' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tblstate' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tsysActiveScanDomains' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tsysActiveScanOU' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1779, Level 16, State 0, Line 2
Table 'tsysDomainPasswords' already has a primary key defined on it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 1781, Level 16, State 1, Line 2
Column already has a DEFAULT bound to it.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_tblPhysicalMemory_tblComputers' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2714, Level 16, State 4, Line 2
There is already an object named 'FK_tblPhysicalMemoryArray_tblComputers' in the database.
Msg 1750, Level 16, State 0, Line 2
Could not create constraint. See previous errors.
Msg 2705, Level 16, State 4, Line 2
Column names in each table must be unique. Column name 'LastknownIP' in table 'tblcomputers' is specified more than once.
Msg 2705, Level 16, State 4, Line 2
Column names in each table must be unique. Column name 'Installdate' in table 'tblsoftware' is specified more than once.
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.

(0 row(s) affected)
Msg 2627, Level 14, State 1, Line 11
Violation of PRIMARY KEY constraint 'PK_TsysWaittime'. Cannot insert duplicate key in object 'dbo.TsysWaittime'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_TsysWaittime'. Cannot insert duplicate key in object 'dbo.TsysWaittime'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 2
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_tsysSerials'. Cannot insert duplicate key in object 'dbo.TsysSerials'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 2
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK__TsysRamtypes__08961D2F'. Cannot insert duplicate key in object 'dbo.TsysMemorytypes'.
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 4
Violation of PRIMARY KEY constraint 'PK_TblsysConfig'. Cannot insert duplicate key in object 'dbo.TsysConfig'.
The statement has been terminated.

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)

(1 row(s) affected)
Msg 2627, Level 14, State 1, Line 4
Violation of PRIMARY KEY constraint 'PK_tblsysassetlinks'. Cannot insert duplicate key in object 'dbo.tsysassetlinks'.
The statement has been terminated.

(1 row(s) affected)

[Hemoco]

Could you attach the output of your table tsysconfig please.

[rmeleiro]

Please find the attached output.

[Hemoco]

Could you attach the output of the script ran by sql management studio please