Ok, Solved.
Running nxdbmgr check-data-tables fixed the issue.
Up and running again
Thank you for help!
Ronald
Running nxdbmgr check-data-tables fixed the issue.
Up and running again
Thank you for help!
Ronald
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts MenuC:\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 2.0.4 Build 8067 (2.0.4-RELEASE) (UNICODE)
Upgrading database...
Upgrading from version 285 to 286
Upgrading from version 286 to 287
Upgrading from version 287 to 288
Upgrading from version 288 to 289
Upgrading from version 289 to 290
Upgrading from version 290 to 291
Upgrading from version 291 to 292
Upgrading from version 292 to 293
Upgrading from version 293 to 294
SQL query failed (42P01 ERROR: table "tdata_rows_985" does not exist):
DROP TABLE tdata_rows_985
SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
SELECT id FROM clusters
SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
SELECT id FROM mobile_devices
SQL query failed (25P02 ERROR: current transaction is aborted, commands ignored until end of transaction block):
INSERT INTO metadata (var_name,var_value) VALUES ('ValidTDataIndex','1')
Rolling back last stage due to upgrade errors...
Database upgrade failed
[07-Jul-2016 11:53:06.821] Log file opened
[07-Jul-2016 11:53:06.821] [DEBUG] LIB directory set to C:\NetXMS\lib
[07-Jul-2016 11:53:06.977] [ERROR] Unable to load database driver module "pgsql.ddr": Das angegebene Modul wurde nicht gefunden.
LogFile = C:\NetXMS\netxmsd.log
DBDriver = pgsql.ddr
DBServer = elia
DBName = netxms_db
DBLogin = netxms
DBPassword = ****
LogFailedSQLQueries = yes