NetXMS Support Forum

Unfortunately I hit the same yesterday as Dreamscape. I tried marking the transaction log as unlimited size growth, but then I ran out of disk space (I have over 100GB free). I copied all the lines I saw and filtered out just the SQL commands and ran them manually, and on "UPDATE idata_1088 SET idata_timestamp = idata_timestamp * 1000" I get an error of "Arithmetic overflow error converting expression to data type int."

Ignoring that last error, running the upgrade command again gives me:

PS C:\netxms\bin> .\nxdbmgr.exe upgrade
NetXMS Database Manager Version 6.0.0 Build 6.0-444-gb145606172

INFO: Server module WEBAPI skipped
Upgrading database...
Upgrading from version 60.7 to 60.8
SQL query failed ([Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The object 'PK__idata__410D428BF41FA2F0' is dependent on column 'idata_timestamp'.):
ALTER TABLE idata ALTER COLUMN idata_timestamp bigint
Rolling back last stage due to upgrade errors...
Database upgrade failed

Sorry, just realized I'm on 5.2.6, not 5.2.8.

Had a previous install of 5.2.8 on Windows. Installation of 6.0.0 went smoothly, no issues presented. Upon trying to connect with the new client, found that netxms core service not running. Tried running "nxdbmgr upgrade" but get the following error:

PS C:\NetXMS\bin> .\nxdbmgr upgrade
NetXMS Database Manager Version 6.0.0 Build 6.0-444-gb145606172

Upgrading database...
Upgrading from version 60.7 to 60.8
SQL query failed ([Microsoft][ODBC Driver 17 for SQL Server][SQL Server]The object 'PK__idata__410D428BF41FA2F0' is dependent on column 'idata_timestamp'.):
ALTER TABLE idata ALTER COLUMN idata_timestamp bigint
Rolling back last stage due to upgrade errors...
Database upgrade failed