NetXMS Forum

Thanks for help.
Database upgraded succeful.

In cluster_sync_subnets table columns cluster_id and subnet_addr doesnt have primary key. I set this items primary key.

I try run nxdbmgr -t upgrade. Here is output
C:\NetXMS\bin>nxdbmgr -t upgrade
NetXMS Database Manager Version 2.0.8 Build 8078 (2.0.8-RELEASE) (UNICODE)

Upgrading database...
Upgrading from version 345 to 346
>>> SELECT name FROM sysobjects WHERE xtype='PK' AND parent_obj=OBJECT_ID('clust
er_sync_subnets')
>>> ALTER TABLE cluster_sync_subnets DROP CONSTRAINT PK_cluster_sync_subnets
>>> SELECT name FROM sysobjects WHERE xtype='PK' AND parent_obj=OBJECT_ID('addre
ss_lists')
Rolling back last stage due to upgrade errors...
Database upgrade failed

manual query result is in attachment.
 in server i logged as domain administrator . here is my netxms server configuration file
# NetXMS Server configuration file
# Created by NetXMS Server configuration wizard at Thu Jan 05 15:36:26 2017
#

LogFile = C:\NetXMS\New Text Document.txt
DBDriver = mssql.ddr
DBServer = HPDL580
DBName = NetXMSn
DBLogin = *
LogFailedSQLQueries = yes

1. database type MSSQL server, version 9.00.5069.00.
2. C:\NetXMS\bin>nxdbmgr -t upgrade
   NetXMS Database Manager Version 2.0.8 Build 8078 (2.0.8-RELEASE) (UNICODE)

Upgrading database...
Upgrading from version 345 to 346
>>> SELECT name FROM sysobjects WHERE xtype='PK' AND parent_obj=OBJECT_ID('clust
er_sync_subnets')
Rolling back last stage due to upgrade errors...
Database upgrade failed

Hello,
later i have netxms 1.2.17x64 netxms server and today maked upgrade to 2.0.8. On 1.2.17 everything worked.
Atfer upgrade i try to upgrade database and get this error . in logs i see, what driver works fine.

C:\NetXMS\bin>nxdbmgr upgrade
NetXMS Database Manager Version 2.0.8 Build 8078 (2.0.8-RELEASE) (UNICODE)

Upgrading database...
Upgrading from version 345 to 346
Rolling back last stage due to upgrade errors...
Database upgrade failed

How to solve this problem ?

1.2.10-x64 version
It works, now agent detect.
Thanks

Hello,
i have problem with agent. In NETXMS managment console in Capabilities tab write IsAgent -> NO.
i check services. NetXMS agent and NetXMS Core ir started.

Agent config file location
C:\NetXMS\etc\nxagentd.conf

#
# NetXMS agent configuration file
# Created by server installer at Thu Dec 19 11:28:24 2013
#

LogFile = {syslog}
Servers = 127.0.0.1
InstallationServers = MY COMPUTER IP
FileStore = C:\NetXMS\var
RequireAuthentication = no
SubAgent = winperf.nsm
SubAgent = portcheck.nsm