cannot extract value from json by path "$..['SYSAUX'].used_from_max_pct.first()"

[gima]

Hello,

I got this error on this discovery item - Tablespace Discovery.

Failed: cannot extract value from json by path "$..['SYSAUX'].used_from_max_pct.first()": no data matches the specified path

I'm using Zabbix 6.0 with zabbix agent 2 on Oracle DB with version >= 12.2; all the others item and triggers are working good, only this one is failing.

Any suggestion on how to fix it? What I'm doing wrong?

[cyber]

Seems it is looking for
"$..['SYSAUX'].used_from_max_pct.first()"
but your data contains "used_pct_max"
If you fix this, does it work better?

[gima]

I want to provide you more information.

Here you can see the lonely unsupported item



I've tested the Item Oracle TBS 'SYSAUX': Get tablespaces stats and the result is good

[
{
"SYSAUX":{
"contents":"PERMANENT",
"file_bytes":1635778560,
"max_bytes":34359721984,
"free_bytes":112263168,
"used_bytes":1523515392,
"used_pct_max":4.76,
"used_file_pct":93.14,
"status":1
}
}
]

but I still get the error

Preprocessing failed for: [{"SYSAUX":{"contents":"PERMANENT","file_bytes": 163 5778560,"max_bytes":34359721984,"free_bytes":1...
1. Failed: cannot extract value from json by path "$..['SYSAUX'].used_from_max_pct.first()": no data matches the specified path

[cyber]

Seems it is looking for
"$..['SYSAUX'].used_from_max_pct.first()"
but your data contains "used_pct_max"
If you fix this, does it work better?

[gima]

Hello cyber,

thank you very much for the correct answer.

I've corrected the parameter in this way $..['{#TABLESPACE}'].used_pct_max.first() into the Item Prototype -> Preprocessing of the Tablespace Discovery

After I've unlinked and relinked the Template to the host and now all the metrics are good.

I've a lot of hosts with this Template ... how can I update the correct Preprocessing or the Tablespace Discovery to all those hosts massively?

[cyber]

If you change it in template, it should be corrected everywhere with next run of discovery. Either new item appears or old one is updated... you could probably select also those items from all involved hosts on a config page (find it from one host, then remove host from selector, just leave item name/key) and remove all of them, then you can be sure, that new one will be created...

[gima]

Thank you cyber, now is all the items are fine.