NetXMS Support Forum

We upgraded from NetXMS 3.8.314 to 3.8.366 (Under Windows 2019 Server using Microsoft SQL 2019) and the database upgrade is failing. nxdbmgr error below. Anyone have any ideas on how to proceed? Thanks


E:\NetXMS\bin\nxdbmgr.exe -t upgrade
NetXMS Database Manager Version 3.8.366 Build 3.8-366-gd7bdc676e2 (UNICODE)

Upgrading database...
Upgrading from version 38.16 to 38.17
>>> ALTER TABLE alarms ADD rule_description varchar(255)
>>> UPDATE alarms SET rule_description=(SELECT REPLACE(REPLACE(REPLACE(REPLACE(comments, ?, ' '), ?, ' '), ?, ' '), '  ', ' ') FROM event_policy WHERE event_policy.rule_guid=alarms.rule_guid)
SQL query failed ([Microsoft][SQL Server Native Client 11.0][SQL Server]Argument data type text is invalid for argument 1 of replace function.):
UPDATE alarms SET rule_description=(SELECT REPLACE(REPLACE(REPLACE(REPLACE(comments, ?, ' '), ?, ' '), ?, ' '), '  ', ' ') FROM event_policy WHERE event_policy.rule_guid=alarms.rule_guid)
Rolling back last stage due to upgrade errors...
Database upgrade failed
>>> SELECT var_value FROM metadata WHERE var_name='PendingOnlineUpgrades'