NetXMS Support Forum

English Support => General Support => Topic started by: rauchi on January 14, 2019, 09:57:22 AM

Title: Update from 2.2.10 to 2.2.11 - "nxdbmgr check" fails
Post by: rauchi on January 14, 2019, 09:57:22 AM
Hello @all

Before and after running the update from 2.2.10 to 2.2.11 on my Windows Server I usually run a "nxdbmgr check" to verify if the DB is in a good shape.

After Updating to version 2.2.11 I get the following output:

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

nxdbmgr check
NetXMS Database Manager Version 2.2.11 Build 9516 (2.2.11) (UNICODE)

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]
* Template to node mapping                                          [PASSED]
* Object properties                                                      [PASSED]
* Container membership                                                [PASSED]
* Event processing policy                                              [PASSED]
* Network map links                                                     [   0SQL
query failed (Query was empty):
SELECT network_map_links.map_id,network_map_links.element1,network_map_links.ele
ment2 FROM network_map_links LEFT OUTER JOIN network_map_elements ON    network_
map_links.map_id = network_map_elements.map_id AND    network_map_links.element1
= network_map_elements.element_id WHERE network_map_elements.element_id IS NULL

SQL query failed (Query was empty):
SELECT network_map_links.map_id,network_map_links.element1,network_map_links.ele
ment2 FROM network_map_links LEFT OUTER JOIN network_map_elements ON    network_
map_links.map_id = network_map_elements.map_id AND    network_map_links.element2
= network_map_elements.element_id WHERE network_map_elements.element_id IS NULL

[PASSED]
* Data tables                                                          [PASSED]
* Raw DCI values table                                             [PASSED]
* DCI thresholds                                                      [PASSED]
* Table DCI thresholds                                              [PASSED]
Database doesn't contain any errors
Database check completed

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

Any Idea? Some help is greatly appreciated.

regards
Marco

Title: Re: Update from 2.2.10 to 2.2.11 - "nxdbmgr check" fails
Post by: Alex Kirhenshtein on January 14, 2019, 03:14:52 PM
Hello.

That's known issue (it's windows specific). As a workaround, please download and replace libnetxms.dll from this topic https://www.netxms.org/forum/installation/update-from-2-2-10-to-2-2-11-log-flooding/.
New release will be available shortly as well.
Title: Re: Update from 2.2.10 to 2.2.11 - "nxdbmgr check" fails
Post by: rauchi on January 14, 2019, 05:33:30 PM
Hello Alex

Thank you for your fast response and your help.

I just replaced the "libnetxms.dll" on the NetXMS Server with the one provided in the referenced link.

After the replacement I tried first to run "nxdbmgr check" again. With the replaced .dll I get now this error:

"The procedure entry point nx_memdup could not be located in the dynamic link library C:\NetXMS\bin\libnxdb.dll."

I have added the error as attachment (Libnxdb-dll-error.jpg) for reverence.

After switching back to the previous "libnetxms.dll" I can also start the "NetXMS Core" Service again.

Please let me know if you need some more information.

best regards
Marco
Title: Re: Update from 2.2.10 to 2.2.11 - "nxdbmgr check" fails
Post by: Victor Kirhenshtein on January 16, 2019, 05:45:29 PM
Hi,

there are some incompatibilities in dlls. We will publish release 2.2.12 with a fix tomorrow.

Best regards,
Victor
Title: Re: Update from 2.2.10 to 2.2.11 - "nxdbmgr check" fails
Post by: rauchi on January 16, 2019, 05:49:16 PM
Hi,

Great news. Thank you very much for your support.

best regards
Marco
Title: Re: Update from 2.2.10 to 2.2.11 - "nxdbmgr check" fails
Post by: rauchi on January 17, 2019, 01:32:24 PM
Hi,

Problems are gone with the new release 2.2.12.

Thank you  :D

best regards
Marco