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'

This was addressed in Telegram, let's copy this info here:

execute manually the following statements:
ALTER TABLE alarms ADD rule_description varchar(255);
(may file if alter was already done by nxdbmgr and didn't rolled back - that's ok then

UPDATE metadata SET var_value='17' WHERE var_name='SchemaVersionMinor';

server should start after that

This is excellent.  Worked like a charm!

Thank you!

Filipp --

Thanks for that. Worked great!

I had the same problem, but after executing the satements it did work.

This is now fixed in 3.8.382