Hi,
Zabbix Server : 6.4.8
Oracle version : 19
Items :
Tablespace discovery: Oracle TBS 'SYSAUX': Get tablespaces stats: Oracle TBS 'SYSAUX': Tablespace usage from MAX, percent
And also TBS SYSTEM, TBS TEMP, TBS UNDOTBS
I have this following error message:
Info error : Preprocessing failed for: [{"SYSAUX":{"contents":"PERMANENT","file_bytes": 527 4337280,"max_bytes":34359721984,"free_bytes":6...
1. Failed: cannot extract value from json by path "$..['SYSAUX'].used_from_max_pct.first()": no data matches the specified path
And the log file contains :
1171125:20231116:132505.188 enabling Zabbix agent checks on host "svx-ora-11e - co11911e": interface became available
1171059:20231116:132544.037 item "svx-ora-11e - co11911e
racle.tbs_used_from_max_pct["USERS"]" became not supported: Preprocessing failed for: [{"USERS":{"contents":"PERMANENT","file_bytes":5242 880,"max_bytes":34359721984,"free_bytes":24248...
1. Failed: cannot extract value from json by path "$..['USERS'].used_from_max_pct.first()": no data matches the specified path
1171060:20231116:132608.075 item "svx-ora-11e - co11911e
racle.tbs_used_from_max_pct["SYSTEM"]" became not supported: Preprocessing failed for: [{"SYSTEM":{"contents":"PERMANENT","file_bytes":100 6632960,"max_bytes":34359721984,"free_bytes":1...
1. Failed: cannot extract value from json by path "$..['SYSTEM'].used_from_max_pct.first()": no data matches the specified path
1171072:20231116:132618.102 item "svx-ora-11e - co11911e
racle.tbs_used_from_max_pct["SYSAUX"]" became not supported: Preprocessing failed for: [{"SYSAUX":{"contents":"PERMANENT","file_bytes":527 4337280,"max_bytes":34359721984,"free_bytes":6...
1. Failed: cannot extract value from json by path "$..['SYSAUX'].used_from_max_pct.first()": no data matches the specified path
1171059:20231116:132626.117 item "svx-ora-11e - co11911e
racle.tbs_used_from_max_pct["UNDOTBS1"]" became not supported: Preprocessing failed for: [{"UNDOTBS1":{"contents":"UNDO","file_bytes":403701 760,"max_bytes":34359721984,"free_bytes":34072...
1. Failed: cannot extract value from json by path "$..['UNDOTBS1'].used_from_max_pct.first()": no data matches the specified path
1171071:20231116:132635.133 item "svx-ora-11e - co11911e
racle.tbs_free_bytes["TEMP"]" became not supported: Value of type "string" is not suitable for value type "Numeric (unsigned)". Value "-528482304"
1171071:20231116:132635.133 item "svx-ora-11e - co11911e
racle.tbs_used_from_max_pct["TEMP"]" became not supported: Preprocessing failed for: [{"TEMP":{"contents":"TEMPORARY","file_bytes":15099 4944,"max_bytes":34359721984,"free_bytes":-528...
1. Failed: cannot extract value from json by path "$..['TEMP'].used_from_max_pct.first()": no data matches the specified path
zz0.bfslhxzce4nzz
I need help to resolve this error.
Regards
Olivier
Zabbix Server : 6.4.8
Oracle version : 19
Items :
Tablespace discovery: Oracle TBS 'SYSAUX': Get tablespaces stats: Oracle TBS 'SYSAUX': Tablespace usage from MAX, percent
And also TBS SYSTEM, TBS TEMP, TBS UNDOTBS
I have this following error message:
Info error : Preprocessing failed for: [{"SYSAUX":{"contents":"PERMANENT","file_bytes": 527 4337280,"max_bytes":34359721984,"free_bytes":6...
1. Failed: cannot extract value from json by path "$..['SYSAUX'].used_from_max_pct.first()": no data matches the specified path
And the log file contains :
1171125:20231116:132505.188 enabling Zabbix agent checks on host "svx-ora-11e - co11911e": interface became available
1171059:20231116:132544.037 item "svx-ora-11e - co11911e
racle.tbs_used_from_max_pct["USERS"]" became not supported: Preprocessing failed for: [{"USERS":{"contents":"PERMANENT","file_bytes":5242 880,"max_bytes":34359721984,"free_bytes":24248...1. Failed: cannot extract value from json by path "$..['USERS'].used_from_max_pct.first()": no data matches the specified path
1171060:20231116:132608.075 item "svx-ora-11e - co11911e
racle.tbs_used_from_max_pct["SYSTEM"]" became not supported: Preprocessing failed for: [{"SYSTEM":{"contents":"PERMANENT","file_bytes":100 6632960,"max_bytes":34359721984,"free_bytes":1...1. Failed: cannot extract value from json by path "$..['SYSTEM'].used_from_max_pct.first()": no data matches the specified path
1171072:20231116:132618.102 item "svx-ora-11e - co11911e
racle.tbs_used_from_max_pct["SYSAUX"]" became not supported: Preprocessing failed for: [{"SYSAUX":{"contents":"PERMANENT","file_bytes":527 4337280,"max_bytes":34359721984,"free_bytes":6...1. Failed: cannot extract value from json by path "$..['SYSAUX'].used_from_max_pct.first()": no data matches the specified path
1171059:20231116:132626.117 item "svx-ora-11e - co11911e
racle.tbs_used_from_max_pct["UNDOTBS1"]" became not supported: Preprocessing failed for: [{"UNDOTBS1":{"contents":"UNDO","file_bytes":403701 760,"max_bytes":34359721984,"free_bytes":34072...1. Failed: cannot extract value from json by path "$..['UNDOTBS1'].used_from_max_pct.first()": no data matches the specified path
1171071:20231116:132635.133 item "svx-ora-11e - co11911e
racle.tbs_free_bytes["TEMP"]" became not supported: Value of type "string" is not suitable for value type "Numeric (unsigned)". Value "-528482304"1171071:20231116:132635.133 item "svx-ora-11e - co11911e
racle.tbs_used_from_max_pct["TEMP"]" became not supported: Preprocessing failed for: [{"TEMP":{"contents":"TEMPORARY","file_bytes":15099 4944,"max_bytes":34359721984,"free_bytes":-528...1. Failed: cannot extract value from json by path "$..['TEMP'].used_from_max_pct.first()": no data matches the specified path
zz0.bfslhxzce4nzz
I need help to resolve this error.
Regards
Olivier