JSON Return value not found

Hi there,

I tried to reproduce this issue on our end, unfortunately, we get the correct value without any issue. I just created a ".json", pasted your second code (correctly formatted json) and created the sensor. The sensor then gets the value "8105315" correctly.

Please activate the "Write sensor result to disk (Filename: "Result of Sensor [ID].txt")"-Option and post the results, they most likely help us further.

Best regards.

Hi, sorry for the late reply.

The "Result of sensor" file gives me this

[Probe]
12/18/2017 4:15:33 PM
Microsoft Windows Server 2012 R2 Standard 6.2.9200.0 en-US
[Sensor]
XMLValue 16.1.2
Run by PRTG probe.
[Parameters]
-u=http://amsapp124.pvhcorp.com:4985/_expvar -n=cb/ops/GetsRaw/count -t=60 -ssl3 -debug=D:\ProgramData\Paessler\PRTG Network Monitor\Logs (Sensors)\Result of Sensor 15900.txt 
[Trace]
Sending request
Reply received
[Error]
Node cb/ops/GetsRaw/count not found in xml result.
Exitcode custom_error}}}

And the .Data file provides me with this

{{{
Data['blockedsens'].asString := '';
Data['canlinux'].asString := '0';
Data['channelinfos'].asString := '{"0":{"Unit":"oukCustom","CustomUnit":"#","ValueLookupName":"","LimitMode":"0","LimitMinError":"","LimitMinWarning":"","LimitMaxError":"","LimitMaxWarning":""},"1":{"Unit":"oukTimeResponse","CustomUnit":"","ValueLookupName":"","LimitMode":"0","LimitMinError":"","LimitMinWarning":"","LimitMaxError":"","LimitMaxWarning":""}}';
Data['channelnames'].asString := 'Value'#$D#$A + 
'0'#$D#$A + 
'Execution Time'#$D#$A + 
'1'#$D#$A + 
'';
Data['environment'].asString := '';
Data['exefile'].asString := 'XMLValue.exe';
Data['exeparams'].asString := '-u="http://myServerName.pvhcorp.com:4985/_expvar" -n="cb/ops/GetsRaw/count" -t="60" -ssl3';
Data['fastcount'].asString := '0';
Data['host'].asString := 'myServerName.PVHCORP.COM';
Data['hostv6'].asString := '';
Data['inerror'].asString := '1';
Data['interfacenumber'].asString := '';
Data['inum'].asString := '';
Data['ipversion'].asString := '0';
Data['isexesensor'].asString := '1';
Data['lastmsg'].asString := 'Node cb/ops/GetsRaw/count not found in xml result. ';
Data['lastuptime'].asString := '0';
Data['linuxlogindomain'].asString := '';
Data['linuxloginpassword'].asString := '***';
Data['monitorchange'].asString := '0';
Data['mutexname'].asString := 'ptfxmlrestvalueID15900';
Data['notonpod'].asString := '0';
Data['ptfwriteresult'].asString := '1';
Data['reboot'].asString := '43086.6328852199';
Data['reqmsginterval'].asString := '60';
Data['requiredotnetversion'].asString := '40';
Data['sensorid'].asString := '15900';
Data['simulate'].asString := '0';
Data['timeout'].asString := '60';
Data['tlsexplicit_default'].asString := '';
Data['tlsexplicit_ftp'].asString := '';
Data['tlsexplicit_imap'].asString := '';
Data['tlsexplicit_pop3'].asString := '';
Data['tlsexplicit_port'].asString := '';
Data['tlsexplicit_smtp'].asString := '';
Data['uptimecount'].asString := '0';
Data['usednstime'].asString := '0';
Data['usewindowsauthentication'].asString := '';
Data['valuetype'].asString := '1';
Data['windowslogindomain'].asString := 'MyDomainName';
Data['windowsloginpassword'].asString := '***';
Data['windowsloginusername'].asString := 'myServiceAccount';
Data['writeresult'].asString := '0';

I also pasted some of the JSON code, not all of it so it is missing the end brackets.

{  
   "cb":{  
      "ops":{  
         "GetsRaw":{  
            "count":8971227,
            "sum":144555679535000,
            "min":0,
            "max":18932848100,
            "mean":1.611325625078933e+07,
            "p25":16001800,

Further down in the same JSON file I can retrieve numbers. Different sections.

Hi there,

With your provided JSON-Code, I am able to get the data from the node "cb/ops/GetsRaw/count". Could you try to open the URL "http://myServerName.pvhcorp.com:4985/_expvar" in a browser on the Core Server to see what data is displayed there?

Best regards.

Sorry, got side tracked with other issues for a while.

Going back to this. ;-)

The URL opens the JSON document for me. And I can copy and paste the code into a JSON Beautifier to make it more readable.

The only config I have in the sensor at the moment is the URL: http://amsapp124:4985/_expvar XML Node (and optional property): cb/ops/GetsRaw/count

The log files still tells me the below. I don't get it.

[Probe] 1/19/2018 5:01:23 PM Microsoft Windows Server 2012 R2 Standard 6.2.9200.0 en-US [Sensor] XMLValue 17.1.1 Run by PRTG probe. [Parameters] -u=http://amsapp124:4985/_expvar -n=cb/ops/GetsRaw/count -t=60 -rn -debug=D:\ProgramData\Paessler\PRTG Network Monitor\Logs (Sensors)\Result of Sensor 17826.txt [Trace] Sending request Reply received [Error] Node cb/ops/GetsRaw/count not found in xml result. Exitcode custom_error

Hi there,

As described, when I use the JSON code you provided, I can successfully add the sensor. Please post the exact data that is offered when PRTG connects to "http://amsapp124:4985/_expvar". When we have the source data, which PRTG requests, then we are most likely able to reproduce the issue.

Best regards.

This is a copy and paste of the data that ia returned to me.

<Deleted as it is too long>

Hi there,

Is this the entire returned JSON? I ask, because it doesn't end properly and breaks just in the middle:

...
		507,
		474,
		543,
		545,
		569

So there are no ending brackets/braces.

Best regards.

I can copy and paste the contents of the page locally. All the information is there. I am wondering if the page is either too long for the forum and / or even too long for the sensor?

I can email the contents of the page if you have an email address for me?

Hey,

Kindly forward the complete result as a zip file to [email protected] by referring to this Knowledge Base post. Thanks!

Best regards, Felix

Hi,

The email with the ZIP file has been sent this morning.