NetXMS Forum

Thank you very much, it helped.

Pavel

I'm install (upgrade) WebUI 1.2.8 on windows and i can't start service NetXMS WebUI now.

In the log is:
The NetXMS WebUI service terminated with service-specific error 0 (0x0)

Thanks Pavel

It is helpfull,
thank you very much.

Pavel

Thanks.
I can't create backup database

C:\NetXMS\bin>nxdbmgr.exe export backup_db
NetXMS Database Manager Version 1.2.8

ERROR: Schema version mismatch between dbschema_sqlite.sql and your database. Pl
ease check that NetXMS server installed correctly.
Database export failed.

C:\NetXMS\bin>

Hello,
is it possible migration database from SQLite to PostgresSQL?
I have about 700 nods and I can not configure the database again.

Thanks for the answer
Pavel

Thank you very much, it helped.

Are there any risks if they missed a database upgrade from 279 to 280

Pavel

C:\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 1.2.8

Upgrading database...
Upgrading from version 279 to 280
SQL query failed (near "DROP": syntax error):
ALTER TABLE dc_tables DROP COLUMN instance_column
Rolling back last stage due to upgrade errors...
Database upgrade failed

C:\NetXMS\bin>nxdbmgr.exe -X upgrade
NetXMS Database Manager Version 1.2.8

Upgrading database...
Upgrading from version 279 to 280
SQL query failed (near "DROP": syntax error):
ALTER TABLE dc_tables DROP COLUMN instance_column
Upgrading from version 280 to 281
Upgrading from version 281 to 282
Upgrading from version 282 to 283
Upgrading from version 283 to 284
Upgrading from version 284 to 285
Database upgrade succeeded

C:\NetXMS\bin>nxdbmgr.exe check
NetXMS Database Manager Version 1.2.8

Checking database (excluding collected data):
* Checking zone objects...                                            [PASSED]
* Checking node objects...                                            [PASSED]
* Checking interface objects...                                      [PASSED]
* Checking network service objects...                            [PASSED]
* Checking cluster objects...                                        [PASSED]
* Checking template to node mapping...                        [PASSED]
* Checking object properties...                                      [PASSED]
* Checking event processing policy...                            [PASSED]
Database doesn't contain any errors
Database check completed

C:\NetXMS\bin>

Hi, a have problem after upgrade from 1.2.7 to 1.2.8 (Win x86 Server)

C:\Program Files\NetXMS\bin>nxdbmgr.exe check
NetXMS Database Manager Version 1.2.7

Checking database (excluding collected data):
* Checking zone objects...                                            [PASSED]
* Checking node objects...                                            [PASSED]
* Checking interface objects...                                      [PASSED]
* Checking network service objects...                                [PASSED]
* Checking cluster objects...                                        [PASSED]
* Checking template to node mapping...                                [PASSED]
* Checking object properties...                                      [PASSED]
* Checking event processing policy...                                [PASSED]
Database doesn't contain any errors
Database check completed

C:\Program Files\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 1.2.8

Upgrading database...
Upgrading from version 279 to 280
SQL query failed (near "DROP": syntax error):
ALTER TABLE dc_tables DROP COLUMN instance_column
Rolling back last stage due to upgrade errors...
Database upgrade failed

C:\Program Files\NetXMS\bin>