Hi all,

Just updating from 6.0.1 to 6.0.2, get the error below?

Any ideas please

C:\NetXMS\bin>nxdbmgr.exe check
NetXMS Database Manager Version 6.0.2 Build 6.0-504-g549db2d3a0

Checking database (excluding collected data):
Your database has format version 60.33, this tool is compiled for version 60.34.
Use "upgrade" command to upgrade your database first.
Database check aborted

C:\NetXMS\bin>nxdbmgr.exe upgrade
NetXMS Database Manager Version 6.0.2 Build 6.0-504-g549db2d3a0

Upgrading database...
Upgrading from version 60.33 to 60.34
Rolling back last stage due to upgrade errors...
Database upgrade failed

Bit more info

C:\NetXMS\bin>nxdbmgr -t upgrade
NetXMS Database Manager Version 6.0.2 Build 6.0-504-g549db2d3a0

Upgrading database...
Upgrading from version 60.33 to 60.34
Rolling back last stage due to upgrade errors...
Database upgrade failed
>>> SELECT var_value FROM metadata WHERE var_name='PendingOnlineUpgrades'

C:\NetXMS\bin>

Anyone have any ideas please?

I also do not have a 'PendingOnlineUpgrades' in my metadata table, see below.

This issue was fixed, fix will be available in next patch release.

If you do not want to wait for it, you can run these queries to the database:

ALTER TABLE userdb_custom_attributes ALTER COLUMN attr_value varchar(max) NULL;
UPDATE metadata SET var_value='34' WHERE var_name='SchemaVersionMinor';

and nxdbmgr upgrade again after that

Great, thanks for the reply and for fixing  it.

I get this after running the sql

C:\NetXMS\bin>nxdbmgr upgrade
NetXMS Database Manager Version 6.0.2 Build 6.0-504-g549db2d3a0

Upgrading database...
Core database schema is up to date
Database upgrade succeeded

When do you expect the next patch release to be available for this fix?

Just published 6.0.3 - it should have the fix.