NetXMS Support Forum

How do I stop this error from occurring?

I was using the SQLLite Database but now on full MSSQL which wouldn't of thought would suffer from the same issue as its a true client/server database model.


NetXMS Database Manager Version 2.2.3 Build 9505 (2.2.3) (UNICODE)

Checking database (excluding collected data):
Database is locked by server 1.1.1.1 [COMPUTER Windows 8 Build 9200]
Do you wish to force database unlock? (Yes/No)

Opted to start again with fresh database under MSSQL instead of using the SQLLite database.

Ran this command instead to ignore SQL errors on upgrade, its working on 2.2.1 so will see how things go.


C:\NetXMS\bin>nxdbmgr.exe upgrade -t -X
NetXMS Database Manager Version 2.2.1 Build 9502 (2.2.1) (UNICODE)

Upgrading database...
Upgrading from version 21.4 to 21.5
>>> ALTER TABLE nodes ADD rack_orientation integer
>>> ALTER TABLE chassis ADD rack_orientation integer
>>> UPDATE nodes SET rack_orientation=0
>>> UPDATE chassis SET rack_orientation=0
Unable to set not null constraint.
Unable to set not null constraint.
>>> UPDATE metadata SET var_value='5' WHERE var_name='SchemaVersionMinor'
Upgrading from version 21.5 to 22.0
>>> INSERT INTO metadata (var_name,var_value) VALUES ('SchemaVersionLevel.21','5')
>>> UPDATE metadata SET var_value='22' WHERE var_name='SchemaVersionMajor'
>>> UPDATE metadata SET var_value='0' WHERE var_name='SchemaVersionMinor'
Upgrading from version 22.0 to 22.1
>>> SELECT var_value FROM config WHERE var_name='NumberOfDataCollectors'
>>> INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,is_public,data_type,description) VALUES ('DataCollector.ThreadPool.BaseSize','10','10',1,1,'N','I','Base size for data collector thread pool.')
>>> INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,is_public,data_type,description) VALUES ('DataCollector.ThreadPool.MaxSize','250','250',1,1,'N','I','Maximum size for data collector thread pool.')
>>> UPDATE config SET default_value='250' WHERE var_name='DataCollector.ThreadPool.MaxSize'
>>> DELETE FROM config WHERE var_name='NumberOfDataCollectors'
>>> UPDATE metadata SET var_value='1' WHERE var_name='SchemaVersionMinor'
Upgrading from version 22.1 to 22.2
>>> INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,is_public,data_type,description) VALUES ('DBWriter.MaxRecordsPerTransaction','1000','1000',1,1,'N','I','Maximum number of records per one transaction for delayed database writes.')
>>> UPDATE metadata SET var_value='2' WHERE var_name='SchemaVersionMinor'
Upgrading from version 22.2 to 22.3
>>> CREATE TABLE dci_access (   dci_id integer not null,   user_id integer not null,   PRIMARY KEY(dci_id,user_id))
>>> UPDATE metadata SET var_value='3' WHERE var_name='SchemaVersionMinor'
Upgrading from version 22.3 to 22.4
>>> SELECT var_value FROM metadata WHERE var_name='SchemaVersionLevel.21'
>>> UPDATE metadata SET var_value='4' WHERE var_name='SchemaVersionMinor'
Upgrading from version 22.4 to 22.5
>>> ALTER TABLE items ADD instance_retention_time integer
>>> ALTER TABLE dc_tables ADD instance_retention_time integer
>>> UPDATE items SET instance_retention_time=-1
>>> UPDATE dc_tables SET instance_retention_time=-1
>>> INSERT INTO config (var_name,var_value,default_value,is_visible,need_server_restart,is_public,data_type,description) VALUES ('InstanceRetentionTime','0','0',1,1,'Y','I','Default retention time (in days) for missing DCI instances')
Unable to set not null constraint.
Unable to set not null constraint.
>>> UPDATE metadata SET var_value='5' WHERE var_name='SchemaVersionMinor'
Database upgrade succeeded

Hi

I have migrated from x86 to x64 netxms system on v2.1.2 on SQLLite database successfully so had a go at upgrading to v2.2.1 but hitting issue of:

C:\NetXMS\bin>nxdbmgr.exe upgrade -t
NetXMS Database Manager Version 2.2.1 Build 9502 (2.2.1) (UNICODE)

Upgrading database...
Upgrading from version 21.4 to 21.5
>>> ALTER TABLE nodes ADD rack_orientation integer
>>> ALTER TABLE chassis ADD rack_orientation integer
>>> UPDATE nodes SET rack_orientation=0
>>> UPDATE chassis SET rack_orientation=0
Unable to set not null constraint.
Rolling back last stage due to upgrade errors...
Database upgrade failed

Any pointers to fix this?

I might have to bite the bullet reconfigure the system from scratch as my plan was to migrate over to MSSQL database but as I can't get the migrate to work either looking like this might be my only option.

Thanks

Carl

opted to restore from backup.
system back up and running again on v2.1.2

C:\NetXMS\bin>netxmsd -D 9

Using configuration file "C:\NetXMS\etc\netxmsd.conf"
2018.02.12 12:18:46.315 LIB directory set to C:\NetXMS\lib
2018.02.12 12:18:46.324 SQLite version 3.22.0
2018.02.12 12:18:46.325 Database driver "sqlite.ddr" loaded and initialized successfully
2018.02.12 12:18:46.326 [db.conn            ] DBConnect: server=127.0.0.1 db=C:\NetXMS\database\netxms_db login=netxms schema=
2018.02.12 12:18:46.329 [db.conn            ] New DB connection opened: handle=0000016862CD6E00
2018.02.12 12:18:46.330 Successfully connected to database C:\NetXMS\database\[email protected]
2018.02.12 12:18:46.355 [db.query           ] Successful sync query: "SELECT var_value FROM metadata WHERE var_name='SchemaVersion'" [24 ms]
2018.02.12 12:18:46.357 [db.query           ] Successful sync query: "SELECT var_value FROM metadata WHERE var_name='SchemaVersionMajor'" [1 ms]
2018.02.12 12:18:46.358 [db.query           ] Successful sync query: "SELECT var_value FROM metadata WHERE var_name='SchemaVersionMinor'" [0 ms]
2018.02.12 12:18:46.359 Your database has format version 21.4, but server is compiled for version 22.16
2018.02.12 12:18:46.360 [db.conn            ] DB connection 0000016862CD6E00 closed
NetXMS Core initialization failed

in a bit of a mess now, opted to upgrade to the new version: netxms-2.2.3-x64 which bailed out on the /SILENT setup and asked me to rerun the sql connection wizard and then corrupted my conf file with a path to the SQLLite database of
DBName = C:\NetXMS\database\C:\NetXMS\database\netxms_db

I fixed the path back to and tried to start the NetXMS Core service but it won't start.
DBName = C:\NetXMS\database\netxms_db

Tried to do the nxdbmgr upgrade but this results in the error of:
C:\NetXMS\bin>nxdbmgr upgrade
NetXMS Database Manager Version 2.2.3 Build 9505 (2.2.3) (UNICODE)

Upgrading database...
Upgrading from version 21.4 to 21.5
Unable to set not null constraint.
Rolling back last stage due to upgrade errors...
Database upgrade failed

Help!!!

Thanks

Carl

Hi

I am following this guide https://wiki.netxms.org/wiki/How_to_migrate_to_another_database

The SQL Lite database is 11MB and migrating over to MSSQL 2017 instance, started the migration but it got stuck at "Migrating table config" with no progress or error indicating when it will complete.  Here is my output:

C:\NetXMS\bin>nxdbmgr migrate c:\netxms\etc\netxmsd_old.conf
NetXMS Database Manager Version 2.1.2 Build 9015 (2.1.2) (UNICODE)

Source:
        DB Name: C:\NetXMS\database\netxms_db
        DB Server: 127.0.0.1
        DB Login: netxms
Current:
        DB Name: netxmsdb
        DB Server: SERVER\SQLEXPRESS
        DB Login: netxms

Confirm database migration? (Y/N) Y
Database driver sqlite.ddr loaded
Connected to source database


WARNING!!!
This operation will clear all configuration and collected data from destination database before migration.
Are you sure? (Y/N) Y
Database successfully cleared
Migrating table config


Anything I am missing?

Thanks

Carl

Hi

Is it possible to hover over a line chart value and have a tooltip popup with the name of the node name or the label that it refers to in the Legend.

Thanks

Carl