NetXMS Support Forum

Hello @all,

after Upgrade from 2.2.10 to 2.2.11 (Win7 64bit, MySQL 5.7.24) NetXMS Dashboard and Performance Tabs shows randomly "Cannot get Value for DCI XXX (Database Failure)"

If i take a look in de NetXMS Server Log, there are many many lines as the following:


^{2019.01.09 17:45:35.739 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1561 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.09 17:45:36.633 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1524 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.09 17:45:36.645 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_2405 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.09 17:45:37.419 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1561 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.09 17:45:37.462 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_2405 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty
2019.01.09 17:45:38.134 *E* SQL query failed (Query = "SELECT idata_timestamp,idata_value FROM idata_1561 WHERE item_id=? AND idata_timestamp>=? AND idata_timestamp<=? ORDER BY idata_timestamp DESC LIMIT 200000"): Query was empty}


I have run "nxdbmgr check" bevor and after update, but there are no errors...

Should i go back to 2.2.10. ??  Any help is welcome...


Greets
Marco

Hello @all,

i would like to update from 2.2.7 to 2.2.8. The database upgrade doesn't work. It throws the following error:


Upgrading database...
Upgrading from version 22.35 to 22.36
SQL query failed (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'row_number=0 WHERE row_number IS NULL' at line 1):
UPDATE dct_threshold_instances SET row_number=0 WHERE row_number IS NULL
Rolling back last stage due to upgrade errors...
Database upgrade failed



NetXMS is running on Windows 7 (64bit) and MySQL 8.0.12 (64-bit).

Any help will be welcome... Thanx.

Greetings
Marco

Hello Victor,

thanks for fixing the vmware tools thing... :-)

Greetings
Marco

By the way:

with activated Vmware Tools service nextxms can't read the windows performance counters (if i poll netxms configuration from via netxms server):

[21.06.2018 09:50:32]    Reading list of available Windows Performance Counters...
[21.06.2018 09:50:36]    unable to get Windows Performance Counters list


If i stop the the vmware service, netxms CAN poll the windows performance counters:

[21.06.2018 09:51:13]    Reading list of available Windows Performance Counters...
[21.06.2018 09:51:18]    159 counters read


After starting Vmware Tools service netxms can further polling windows performance counters.

Maybe that help you further...


Greetings
Marco

Hello Victor,

think i found something. System must be a VMWare Windows VM (Server 2008R1/2016), VMWare tools installed. Steps to reproduce:

- NetXMS Agent is running and still the nxagentd.exe handle from svchost.exe exist
- Stopping VMWare Tools Service (Service "VMTools", V10.1.15)
- Waiting for couple of minutes (1-3)
- nxagentd.exe handle from svchost.exe is gone away

Now, i can update des NetXMS Agent via NetXMS Server or agent installer exe

I can this reproduce on all our Windows VM's (Server 2008R2/2016 64bit).

Physical machines seems not be affected. Here i can upgrade the agent without any problems (i looked at process explorer bevor update: there exist no nxagentd.exe handle from svchost.exe

Hope this helps and perhaps, you can find a workaround/fix for that...

Greetings
Marco

Hello @all,

unfortunately the above described behaviour is still present. I tried to update from Windows Agent 2.2.4 (64bit) to Windows Agent 2.2.6 (64bit) but i have no chance to update the agent. Error is the same as described above. I had to reboot all our 30x servers to install the NetXMS agent.

Has anyone more infos or workaround for this problem, please?

Greetings
Marco

----
Running NetXMS Server 2.2.6 64bit on Windows 7 / Agents are at V2.2.4

I asked because I still had the same problems with the agent update from V2.2.3 to V2.2.4 that I had described here

https://www.netxms.org/forum/installation/install-agent-2-2-1-fails/


Maybe i had same Problem at Agent Update as the user who has opened this Thread:

https://www.netxms.org/forum/installation/upgrading-agents/


Greets
Marco

Hi Victor,

does this option also apply to access to the Windows event log?

Greets
Marco

Maybe it's same behaviour (for Windows systems) as described here:

https://www.netxms.org/forum/installation/install-agent-2-2-1-fails/msg23469/#msg23469


For me i stopped shedule and eventlog services and starter afterwards. After that, i can install NetXMS Agent.

sc stop NetXMSAgentdW32
sc stop Schedule
sc stop eventlog
sc start eventlog
sc start Schedule

After that running the NetXMS installer.


Greets
Marco

We are trying to upgrade agents running at V2.1.2

Hello Victor,

thanx for the fast response. If i can help with more informations or logfiles please let me know...

Greets
Marco

Hello @all,

if i want to install the Agent 2.2.1 (x64) there are several error messages (please see the attachments). after i quit the installer i take a look at the process explorer (please see attachment).

Here i can see an open handle or file access from the svchost.exe at the nxagent.exe (NetXMS service was quit before).  I can't restart the windows eventlog service in cause of the dependency from scheduler. I could only install the agent after a server reboot.

My first idea: We use NetXMS to trigger an alarm from windows event log with the logwatch subagent. Could there be the problem?

At the moment i tried at 4x Servers (Windows Server 2008 R2 64bit) to install NetXMS Agent. Two via NetXMS Package Manager and two via a manual execution of the agent installer. On all system i have the same behaviour.

Is there anything i can do?


Greets
Marco

Hello normalcy,

thanx for the feedback. I try to get some debug logs from client and server. Which debug level should i use?

Greets
Marco

Hello @all,

if i run a configuratoin poll at a node (Windows Server 2008 R2, 64bit, NetXMS Agent 2.1.2) NetXMS can not read the Windows Performance Counters list. The configuration poll shows the follwing info:

[09.11.2017 08:12:12] **** Poll request sent to server ****
[09.11.2017 08:12:12] Poll request accepted
[09.11.2017 08:12:12] Starting configuration poll for node XXXXXXXXX
[09.11.2017 08:12:12] Checking node's capabilities...
[09.11.2017 08:12:12]    Checking NetXMS agent...
[09.11.2017 08:12:12]    NetXMS native agent is active
[09.11.2017 08:12:12]    Reading list of available Windows Performance Counters...
[09.11.2017 08:12:16]    unable to get Windows Performance Counters list
[09.11.2017 08:12:20] Capability check finished
[09.11.2017 08:12:20] Checking interface configuration...
[09.11.2017 08:12:22] Interface configuration check finished
[09.11.2017 08:12:22] Checking node name
[09.11.2017 08:12:22] Node name is OK
[09.11.2017 08:12:23] Reading list of installed software packages
[09.11.2017 08:12:23] Got information about 38 installed software packages
[09.11.2017 08:12:23] Finished configuration poll for node XXXXXXXXX
[09.11.2017 08:12:23] Node configuration was not changed after poll
[09.11.2017 08:12:23] **** Poll completed successfully ****

The DCI's from this node based on "Windows Performance Counters" are all functional and i can (manually) create new DCIs based on "Windows Performance Counters". But if i want to create a DCI based on "Windows Performance Counters" and use the "Select" button (DCI Properties Windows > General > Data Parameter) the following Windows ("Select Performance Counters") is empty.

We have this behaviour at 3/4 of all our Windows nodes. For the rest of our servers, the Windows Performance Counter query works without problems. All Machines are VMWare VM's, Windows Server 2008 R2 64bit, Updates/Patches are up to date.

We use NetXMS V2.1.2 (Server and Agent). We use NetXMS since V1.0.27. Unfortunately, I can't tell exactly from which version or event (NetXMS Version, Windows Update, etc.) the Windows Performance Counters are not working anymore.

Any help would be appreciated.

Greetings
Marco

Hello Eriks,

thanks for the hint. I set the access rights at "infrastrukture services" and it works... :-)

Thanks a lot ...

Greets
Marco