NetXMS Support Forum

Hello NetXMS Team,

the download files for V6.2.1 are missing at your homepage... The download links leads to an 404 error...

Greetings
Marco

Hi Alex,

thanks for the hint. I give it a try...

Greetings
Marco

Hello Alex,

thanks for the description. I tried that today, but running out of storage... :-(

Is there an function in nxdbmgr or any other tool for deleting all DCI Data in tables, so the tables has less amount of data so i can do the migration?

Greetings
Marco

Hello @all,

today i updated our NetXMS server vom Debian 12 to 13. At the first try i upgraded, as part of the Debian Update, the Postgres Cluster from 15 to 17 too. But there are many warnings:

Example:
Fixing hardcoded library paths for stored procedures...
WARNUNG:  Version von Sortierfolge für Datenbank »postgres« stimmt nicht überein
DETAIL:  Die Datenbank wurde mit Sortierfolgenversion 2.36 erzeugt, aber das Betriebssystem hat Version 2.41.
TIP:  Bauen Sie alle Objekte in dieser Datenbank, die die Standardsortierfolge verwenden, neu und führen Sie ALTER DATABASE postgres REFRESH COLLATION VERSION aus, oder bauen Sie PostgreSQL mit der richtigen Bibliotheksversion.
Upgrading database postgres...
WARNUNG:  Version von Sortierfolge für Datenbank »postgres« stimmt nicht überein
DETAIL:  Die Datenbank wurde mit Sortierfolgenversion 2.36 erzeugt, aber das Betriebssystem hat Version 2.41.
TIP:  Bauen Sie alle Objekte in dieser Datenbank, die die Standardsortierfolge verwenden, neu und führen Sie ALTER DATABASE postgres REFRESH COLLATION VERSION aus, oder bauen Sie PostgreSQL mit der richtigen Bibliotheksversion.
Fixing hardcoded library paths for stored procedures...
WARNUNG:  Version von Sortierfolge für Datenbank »netxms« stimmt nicht überein
DETAIL:  Die Datenbank wurde mit Sortierfolgenversion 2.36 erzeugt, aber das Betriebssystem hat Version 2.41.
TIP:  Bauen Sie alle Objekte in dieser Datenbank, die die Standardsortierfolge verwenden, neu und führen Sie ALTER DATABASE netxms REFRESH COLLATION VERSION aus, oder bauen Sie PostgreSQL mit der richtigen Bibliotheksversion.
Upgrading database netxms...
WARNUNG:  Version von Sortierfolge für Datenbank »netxms« stimmt nicht überein
DETAIL:  Die Datenbank wurde mit Sortierfolgenversion 2.36 erzeugt, aber das Betriebssystem hat Version 2.41.
TIP:  Bauen Sie alle Objekte in dieser Datenbank, die die Standardsortierfolge verwenden, neu und führen Sie ALTER DATABASE netxms REFRESH COLLATION VERSION aus, oder bauen Sie PostgreSQL mit der richtigen Bibliotheksversion.

So i decided to rollback the snapshot of the VM and upgrade Debian without the cluster update of Potsgres.

Are there any howto's or links to websites where i can figure out how i make the Postgres Cluster Update from 15 to 17 on the "right" way for NetXMS?

Greetings
Marco

Hello @all,

i have following code in a template:


<config>
<core>
<ExternalMetric>WindowsADUserGroup.Count(*):powershell -NoProfile -NonInteractive -Command "Write-Host ((Get-ADGroupMember -Identity '$1' -Recursive | Where-Object { $_.objectClass -eq 'user' }).count)"</ExternalMetric>
</core>
</config>

If i run the code directly on a server, there are no errors..

If i run the script via NetXMS DC, i getting the error that "_.objectClass" is not found...

Where is my fault? I didn't get a solution for that... Many thanks for any help...

Greetings
Marco

Quote from: Victor Kirhenshtein on March 12, 2026, 12:10:30 PMI just fixed that, we will publish patch release 6.0.5 soon.

Great, thanks Victor... 

Hi Filipp,

i'm using the V6.0.4 NetXMS Client.

Greetings
Marco

Hello @all,

perfomance view (see the attachment, please) seems a little bit buggy if i choose a view >= 2 days. I noticed that since V6.

Anyone else with the issue?


Greetings
Marco

Hi Filipp,

it worked!! :-)

Background Update has completed the task ...

:~$ nxdbmgr background-upgrade
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Background upgrade is locked by another process
Are you sure you want to start background upgrade? (Yes/No) yes
Running background upgrade procedure for version 52.24
Background upgrade procedure for version 52.24 completed


...and the update to V6.0.1 worked without any error messages... :-)

Many thanks for the support...

Greetings
Marco

Hi Filipp,

nxdbmgr ist not running

:~$ ps fax | grep nx
    507 ?        Ssl    1:02 /usr/bin/nxagentd -S
  42549 pts/0    S+     0:00              \_ grep nx


...but nxdbmgr shows, that Background Update ist locked...


:~$ nxdbmgr background-upgrade
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Background upgrade is locked by another process
Are you sure you want to start background upgrade? (Yes/No)


Should I run "nxdbmgr background-upgrade" anyway?

Greetings
Marco

Hi Filipp,

thanks for the fast reply. How can i recognize then background prozess?

ps fax shows me only this in combination with netxms:

 
    507 ?        Ssl    0:36 /usr/bin/nxagentd -S
 
    986 ?        Ssl    4:16 /usr/bin/netxmsd -S

603 ?        Ss     0:00 /usr/lib/postgresql/15/bin/postgres -D /var/lib/postgresql/15/main -c config_file=/etc/postgresql/15/main/postgresql.conf
    659 ?        Ss     0:06  \_ postgres: 15/main: checkpointer
    660 ?        Ss     0:00  \_ postgres: 15/main: background writer
    667 ?        Ss     0:01  \_ postgres: 15/main: walwriter
    668 ?        Ss     0:00  \_ postgres: 15/main: autovacuum launcher
    669 ?        Ss     0:00  \_ postgres: 15/main: logical replication launcher
    990 ?        Ss     0:20  \_ postgres: 15/main: netxms netxms 127.0.0.1(46052) idle
    991 ?        Ss     0:20  \_ postgres: 15/main: netxms netxms 127.0.0.1(46062) idle
    992 ?        Ss     0:19  \_ postgres: 15/main: netxms netxms 127.0.0.1(46064) idle
    993 ?        Ss     0:19  \_ postgres: 15/main: netxms netxms 127.0.0.1(46066) idle
    994 ?        Ss     0:17  \_ postgres: 15/main: netxms netxms 127.0.0.1(46078) idle in transaction
  12165 ?        Ss     0:16  \_ postgres: 15/main: netxms netxms 127.0.0.1(33932) idle



Other question: Can i run "nxdbmgr background-upgrade" while running the NetXMS server or must i stop the server?

Greetings
Marco

Hello @all,

want to update NetXMS from V5.2.8 to V6.0.1. After the Update NetXMS cannot upgrade DB:

Upgrading database...
Upgrading from version 52.24 to 53.0
Upgrading from version 53.0 to 53.1
Upgrading from version 53.1 to 53.2
Upgrading from version 53.2 to 53.3
Upgrading from version 53.3 to 53.4
Upgrading from version 53.4 to 53.5
Upgrading from version 53.5 to 53.6
Upgrading from version 53.6 to 53.7
Upgrading from version 53.7 to 53.8
Upgrading from version 53.8 to 53.9
Upgrading from version 53.9 to 53.10
Upgrading from version 53.10 to 53.11
Upgrading from version 53.11 to 60.0
Upgrading from version 60.0 to 60.1
Upgrading from version 60.1 to 60.2
Upgrading from version 60.2 to 60.3
Upgrading from version 60.3 to 60.4
Upgrading from version 60.4 to 60.5
Upgrading from version 60.5 to 60.6
Upgrading from version 60.6 to 60.7
Upgrading from version 60.7 to 60.8
Pending online upgrades must be completed before this step
Rolling back last stage due to upgrade errors...
Database upgrade failed

Background upgrades pending. Please run mnxdbmgr background-upgrade when possible.


So i rolled back the server to the latest snapshot...

After that i tried to upgrade the db with the following commands. Everytime i startet the upgrade, the "nxdbmgr background-upgrade" says the background update is locked by another process...

Also i don't understand, that "nxdbmgr check" says, its the latest db version, but if i run the "nxdbmgr background-upgrade" it want to upgrade the db version 52.24...

Please help, i'm a little bit lost... What have i to do to fix the db problem...

Many thanks
Marco

-------------------------------------

:~$ nxdbmgr check
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Checking database (excluding collected data):
* Zone object properties                                               [PASSED]
* Node object properties                                               [PASSED]
* Node to subnet bindings                                              [PASSED]
* Interface object properties                                          [PASSED]
* Interface bindings                                                   [PASSED]
* Network service object properties                                    [PASSED]
* Network service bindings                                             [PASSED]
* Cluster object properties                                            [PASSED]
* Cluster member nodes                                                 [PASSED]
* Access point object properties                                       [PASSED]
* Template mapping                                                     [PASSED]
* Business services                                                    [PASSED]
* Business service prototypes                                          [PASSED]
* Object properties                                                    [PASSED]
* Container membership                                                 [PASSED]
* Event processing policy                                              [PASSED]
* Network map links                                                    [PASSED]
* Data tables                                                          [PASSED]
* Orphaned data tables                                                 [PASSED]
* DCI configuration                                                    [PASSED]
* Raw DCI values table                                                 [PASSED]
* DCI thresholds                                                       [PASSED]
* Table DCI thresholds                                                 [PASSED]
* Business service checks - service bindings                           [PASSED]
* Business service tickets - service bindings                          [PASSED]
* Business service tickets - check bindings                            [PASSED]
* Business service tickets - hierarchy                                 [PASSED]
* Business service checks - state                                      [PASSED]
* Business service downtime                                            [PASSED]
* Assets                                                               [PASSED]
* Asset to node links                                                  [PASSED]
* Node to asset links                                                  [PASSED]
Database doesn't contain any errors
Database check completed

WARNING: Background upgrades pending. Please run nxdbmgr background-upgrade when possible.

-------------------------------------

:~$ sudo nxdbmgr background-upgrade
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Background upgrade is locked by another process
Are you sure you want to start background upgrade? (Yes/No)

-------------------------------------

:~$ nxdbmgr upgrade
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

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

WARNING: Background upgrades pending. Please run nxdbmgr background-upgrade when possible.

-------------------------------------

:~$ nxdbmgr background-upgrade
NetXMS Database Manager Version 5.2.8 Build 5.2-506-g7d4137c08a

Background upgrade is locked by another process
Are you sure you want to start background upgrade? (Yes/No) yes
Running background upgrade procedure for version 52.24

-------------------------------------


Hello @all,

is it possible to log the user sessions (User, Client name, Client Adress, ...) to the NetXMS event log?

Greetings
Marco

Hi Filipp,

Quote from: Filipp Sudanov on September 05, 2025, 04:43:15 PMCould be that during the execution of the first script it deleted all the duplicates.

I think, the duplicates was created while the update of NetXMS to V5.2.5. But, in cause of my revert to a VM snapshot with NetXMS V5.2.4, there are no duplicates in tables. I run the scripts above against the V5.2.4 Version of the tables (after i restored the snapshot of the VM)...

Greetings
Marco

Hi Alex,

thanks for the new script... Started it an the result is:


psql:showduplicate1.sql:39: HINWEIS:  Total duplicate rows found: 0


So, at earlier post you said i had duplicates, but the script says there are none... Whats the truth? :-)

Greetings
Marco