Unable to convert current value to float

[bellaryboy]

Hi,

May be duplicate issue , sorry in case .. please direct me the correct post already in place..

I want to have below metric.. I am not sure why I am getting error..

[[metric]]

context = "SesUsedMem"

metricsdesc = { ToltalMem = "Totalsessionmemory" }

labels = ["value"]

request = "select 'Totalsessionmemory' as ToltalMem, cast(round(SUM(value)/1024/1024/1024) as integer) as value from gV$MYSTAT,gV$STATNAME where name='session uga memory'"

Aug 20 08:33:53 sl73gseldb2d01 systemd[1]: Started Service for oracle telemetry client.

Aug 20 08:33:53 sl73gseldb2d01 oracledb_exporter[58306]: time="2022-08-20T08:33:53Z" level=error msg="Unable to convert current value to float (metric=ToltalMem,metricHelp=Totalsessionmemory,value=<>)" source="main.go:330"

Aug 20 08:33:53 sl73gseldb2d01 oracledb_exporter[58306]: time="2022-08-20T08:33:53Z" level=error msg="Error scraping for SesUsedMem _ map[ToltalMem:Totalsessionmemory] 116.462954ms : No metrics found while parsing" source="main.go:278"

Aug 20 08:33:54 sl73gseldb2d01 oracledb_exporter[58306]: time="2022-08-20T08:33:54Z" level=error msg="Unable to convert current value to float (metric=ToltalMem,metricHelp=Totalsessionmemory,value=<>)" source="main.go:330"

Aug 20 08:33:54 sl73gseldb2d01 oracledb_exporter[58306]: time="2022-08-20T08:33:54Z" level=e

[shaxiaozz]

@bellaryboy You can take a look at the answer to this question https://github.com/iamseth/oracledb_exporter/issues/310, I hope it helps you