Query unable to handle string value

[rfrozza]

The following query from default-metrics.toml is returning error messages when the value is a string.

select resource_name, current_utilization, case when trim(limit_value) like 'unlimited' then '-1' else trim(limit_value) end as limit_value from gv$resource_limit;

time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.162Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.206Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.206Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.206Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.207Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.207Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"
time=2025-06-18T18:11:48.207Z level=ERROR source=metrics.go:75 msg="Unable to convert current value to float (metric=limit_value,metricHelp=Generic counter metric from v$resource_limit view in Oracle (UNLIMITED: -1).,value=<UNLIMITED>)"

Suggestion is to add a "lower" statement:

select resource_name, current_utilization, case when trim(lower(limit_value)) like 'unlimited' then '-1' else trim(limit_value) end as limit_value from gv$resource_limit;

[markxnelson]

Thanks very much for your suggestion, we will take a look asap!

[rfrozza]

Thanks a lot @markxnelson