"XML: The returned XML does not match the expected schema. (code: PE233) -- JSON: The returned JSON does not match the expected structure (invalid JSON). (code:PE231)"

Question

"XML: The returned XML does not match the expected schema. (code: PE233) -- JSON: The returned JSON does not match the expected structure (invalid JSON). (code:PE231)"

tsc-ham opened this issue 3 years ago · 13 comments

Hello Jannos, we came across your scripts while looking for a DataCore / PRTG integration and would love to use them. Unfortunately, we get the following error message back when we include this in PRTG as a sensor:

Do you have any idea what could be wrong here?

Answer 1 · 2021-12-08T18:59:51.000Z

Hey, could you send me the sensor log (full text file would be the best) from prtg and the powershell output if you run it directly in powershell?

Answer 2 · 2021-12-09T17:07:29.000Z

Hi, here the PowerShell output from PRTG-DataCore.ps1:

<prtg><result>
        <channel>Error Count</channel>
        <value>0</value>
        <unit>Count</unit>
        <limitmode>1</limitmode>
        <LimitMaxError>0</LimitMaxError>
        </result>
        <result>
        <channel>Warning Count</channel>
        <value>0</value>
        <unit>Count</unit>
        <limitmode>1</limitmode>
        <LimitMaxWarning>0</LimitMaxWarning>
        </result><text>No Alerts found</text></prtg>

PRTG output is attached

Result of Sensor 12138.Data.txt

Answer 3 · 2021-12-09T17:30:46.000Z

Powershell output looks good, could you also upload the "Result of Sensor xxxxx.txt" from the sensor

Answer 4 · 2021-12-09T17:44:03.000Z

the sensor result is attached to the same comment above

Answer 5 · 2021-12-09T17:49:24.000Z

I can only see the result data file, there should also be one file with just result in the name.

Answer 6 · 2021-12-10T14:20:43.000Z

There was a file created with the name "Result of Sensor 12138.txt" without any content

Answer 7 · 2021-12-10T14:53:44.000Z

Could you please download the latest Version and check again? The should be output in the "Result of Sensor xxx.txt"

Answer 8 · 2021-12-14T13:28:27.000Z

We have tested the new script. When executed manually via PowerShell, it works. When running it via PRTG we get an error message regarding the signature of the script.

I attach the results as a text file.

Result of Sensor 12160.txt
Result of Sensor 12160.Data.txt
manualusage.txt

Answer 9 · 2021-12-14T16:05:02.000Z

We were able to solve the problem with script signing.There are different settings for script execution for 32bit and 64bit Powershell.

Answer 10 · 2021-12-17T15:56:04.000Z

Unfortunately, it doesn't quite work with the query yet. We have created a new sensor and included the script.

With the parameter "DcsStatus" four channels are filled with data. The rest remain empty.

The empty channels show the following error message: "At least one channel uses a lookup that is not available or could not be loaded."

If you want to take another look, here are the logs:

ps_log.txt
Result of Sensor 12567.Data.txt
Result of Sensor 12567.txt

Answer 11 · 2021-12-17T21:05:51.000Z

oh that is my bad, I forgot to add the lookup files to Github.
Please look in the readme again, I added step 6/7 "lookup Files"

Answer 12 · 2021-12-21T17:50:07.000Z

The DataCore connection now works properly. Thanks for the support with the integration of your scripts and in general for the great work you provide for free.

Answer 13 · 2021-12-21T18:30:48.000Z

thanks for the great feedback :)
Any suggestions to improve the sensor are welcome. (or for new Sensors)