maximumSince returns value, averageSince is null

darkspirit510 · July 3, 2022, 4:40pm

Hi all,
I’m struggeling with persistence in rules, but can’t find the reason why it is failing. In short (as in title): calling maximumSince returns a value, but averageSince doesn’t.

openHAB version: 3.3.0 release (offical docker image), using both MapDB and JDBC (MariaDB).

My item:

Number Balkon_Sensor_Wetter_Luftfeuchtigkeit "Luftfeuchtigkeit"  <humidity> (StoreFiveMinutes)                {channel="deconz:humiditysensor:homeserver:BalkonMultisensorLuftfeuchtigkeit:humidity"}

My test rule:

rule "Testing average and maximum"

when
  Time cron "*/30 * * * * ?"
then
  logInfo("myRule", "maximum {}", Balkon_Sensor_Wetter_Luftfeuchtigkeit.maximumSince(now.minusMinutes(10), "jdbc").state)
  logInfo("myRule", "average {}", Balkon_Sensor_Wetter_Luftfeuchtigkeit.averageSince(now.minusMinutes(10), "jdbc"))
end

The output:

18:33:00.037 [INFO ] [org.openhab.core.model.script.myRule ] - maximum 38.59
18:33:00.049 [INFO ] [org.openhab.core.model.script.myRule ] - average null

Any idea what I’m doing wrong?

Edit: According to this thread it may be a logging issue, but calling toString() results in:

18:42:30.816 [ERROR] [.internal.handler.ScriptActionHandler] - Script execution of rule with UID 'Testregel-1' failed: cannot invoke method public java.lang.String org.openhab.core.library.types.DecimalType.toString() on null in Testregel

J-N-K · July 3, 2022, 4:57pm

Are you sure there is a valid value 30 minutes ago? If not, no average can be calculated. A maximum might still be possible.

darkspirit510 · July 3, 2022, 5:02pm

What is the definition of “valid”? In my naive thinking, if there is a max value (and this is the only one), shouldn’t this be the average, too?

Latest values, extracted via phpMyAdmin:

Note: For some reason, database times are -2 hours, but I expect this to be some “internal detail” of the JDBC binding, right?

J-N-K · July 3, 2022, 6:06pm

Can you please try to set the interval to 15 minutes? For me it seems to work fine.

rossko57 · July 3, 2022, 6:13pm

You could check the timestamp of the ‘max since’ result returned, as well. I’m thinking max since might return a value from some earlier time, while no records exist for the designated time period. Just to make sure you see what you expect there.

darkspirit510 · July 3, 2022, 6:13pm

@J-N-K
That way?

[...]
then
  logInfo("myRule", "maximum {}", Balkon_Sensor_Wetter_Luftfeuchtigkeit.maximumSince(now.minusMinutes(15), "jdbc").state)
  logInfo("myRule", "average {}", Balkon_Sensor_Wetter_Luftfeuchtigkeit.averageSince(now.minusMinutes(15), "jdbc"))
end

results in

20:12:30.325 [INFO ] [org.openhab.core.model.script.myRule ] - maximum 39.7
20:12:30.337 [INFO ] [org.openhab.core.model.script.myRule ] - average null

darkspirit510 · July 3, 2022, 6:16pm

@rossko57

logInfo("myRule", "maximum {}", Balkon_Sensor_Wetter_Luftfeuchtigkeit.maximumSince(now.minusMinutes(15), "jdbc").getTimestamp().toString())

results in

20:15:00.658 [INFO ] [org.openhab.core.model.script.myRule ] - maximum 2022-07-03T20:15:00.657312+02:00[Europe/Berlin]

J-N-K · July 3, 2022, 6:21pm

Please use log:set DEBUG org.openhab.persistence.jdbc.internal.JdbcPersistenceService on the karaf console and show what is actually returned. You can use DEFAULT to disable logging later.

It’s interesting that the timestamps in my setup are local time, while they seem to be UTC in your example. I’m using JDBC with mariadb backend.

darkspirit510 · July 3, 2022, 6:23pm

Done

20:22:30.449 [DEBUG] [.jdbc.internal.JdbcPersistenceService] - JDBC::query: item is Balkon_Sensor_Wetter_Luftfeuchtigkeit
20:22:30.460 [DEBUG] [.jdbc.internal.JdbcPersistenceService] - JDBC: Query for item 'Balkon_Sensor_Wetter_Luftfeuchtigkeit' returned 0 rows in 4 ms
20:22:30.466 [INFO ] [org.openhab.core.model.script.myRule ] - maximum 39.7
20:22:30.468 [DEBUG] [.jdbc.internal.JdbcPersistenceService] - JDBC::query: item is Balkon_Sensor_Wetter_Luftfeuchtigkeit
20:22:30.473 [DEBUG] [.jdbc.internal.JdbcPersistenceService] - JDBC: Query for item 'Balkon_Sensor_Wetter_Luftfeuchtigkeit' returned 0 rows in 2 ms
20:22:30.478 [INFO ] [org.openhab.core.model.script.myRule ] - maximum 2022-07-03T20:22:30.476505+02:00[Europe/Berlin]
20:22:30.480 [DEBUG] [.jdbc.internal.JdbcPersistenceService] - JDBC::query: item is Balkon_Sensor_Wetter_Luftfeuchtigkeit
20:22:30.483 [DEBUG] [.jdbc.internal.JdbcPersistenceService] - JDBC: Query for item 'Balkon_Sensor_Wetter_Luftfeuchtigkeit' returned 0 rows in 1 ms
20:22:30.485 [INFO ] [org.openhab.core.model.script.myRule ] - average null

Wait - 0 rows?

J-N-K · July 3, 2022, 6:27pm

That’s the explanation: there are no values returned. In this case the maximum is the current value. But the average needs at least two values to calculate it. The average calculation is integrating over all values, calculating the sum of (value2 + value1)/2 * (timestamp2-timestamp1) and dividing that by now-firstTimestamp. If you have only the current value, this fails.

I already edited my post above: in my setup the dates are stored in local time, not UTC like in your example. But this seems to be an issue with the JDBC add-on, I can’t comment on that.

darkspirit510 · July 3, 2022, 7:41pm

I changed the timezone of the MariaDB docker container (which was UTC), now it works! Thank you really much!

Still - shouldn’t there be any explanation in the persistence article that if there are no matching values, maximumSince returns current value, while averageSince returns null?

J-N-K · July 3, 2022, 8:14pm

Feel free to suggest an improvement to the documentation: openhab-docs/persistence.md at main · openhab/openhab-docs · GitHub

You can use the pencil at the top to use the web editor.

MyAIKonto · July 6, 2025, 2:27pm

Hi All,

My issue seems similar to the one discussed in this thread.

Here’s what I’m struggling with:
If I use the following code without the + "" (commented out), I get this error:
Script execution of rule with UID 'change-2' failed: 'split' is not a member of 'org.openhab.core.types.State'; line 52, column 41, length 19 in change

logInfo("Change.rules","------- Start -------")
    val maxItem = OpenWeather_Aussentemperatur.maximumSince(now.minusHours(12),"jdbc").state
    val maxItem2 = maxItem //+ ""
    val Number zahl = Float::parseFloat(maxItem2.split(" ").get(0))
    if (zahl >= 21) {
     logInfo("Change.rules","#### Success ########")
   }
logInfo("Change.rules","------- END -------")

If I uncomment the + "", everything works fine

logInfo("Change.rules","------- Start -------")
    val maxItem = OpenWeather_Aussentemperatur.maximumSince(now.minusHours(12),"jdbc").state
    val maxItem2 = maxItem + ""
    val Number zahl = Float::parseFloat(maxItem2.split(" ").get(0))
    if (zahl >= 21) {
     logInfo("Change.rules","#### Success ########")
   }
logInfo("Change.rules","------- END -------")

I’ve enabled debug logging for my JDBC config, here are some additional details below.
Maybe someone can point out what I’m doing wrong?

With + "":

2025-07-06 16:09:08.282 [INFO ] [enhab.core.model.script.Change.rules] - ------- Start -------
2025-07-06 16:09:08.283 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::query: item is OpenWeather_Aussentemperatur
2025-07-06 16:09:08.283 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::getHistItemFilterQuery filter='true' numberDecimalcount='3' table='openweather_aussentemperatur_0001' item='OpenWeather_Aussentemperatur (Type=NumberItem, State=24.59 °C, Label=Außentemperatur, Category=Temperature, Tags=[Temperature, Measurement], Groups=[OpenWeather_Vorhersage, gPersistence, gTemperatur])' itemName='OpenWeather_Aussentemperatur'
2025-07-06 16:09:08.284 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::getHistItemFilterQueryProvider filter = FilterCriteria [itemName=OpenWeather_Aussentemperatur, beginDate=2025-07-06T04:09:08.282753921+02:00[Europe/Berlin], endDate=2025-07-06T16:09:08.283137986+02:00[Europe/Berlin], pageNumber=0, pageSize=2147483647, operator=EQ, ordering=ASCENDING, state=null], numberDecimalcount = 3, table = openweather_aussentemperatur_0001, simpleName = OpenWeather_Aussentemperatur
2025-07-06 16:09:08.285 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::query queryString = SELECT time, value FROM openweather_aussentemperatur_0001 WHERE TIME>='2025-07-06 04:09:08' AND TIME<='2025-07-06 16:09:08' ORDER BY time ASC
2025-07-06 16:09:08.285 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetHistItemFilterQuery sql=SELECT time, value FROM openweather_aussentemperatur_0001 WHERE TIME>='2025-07-06 04:09:08' AND TIME<='2025-07-06 16:09:08' ORDER BY time ASC
2025-07-06 16:09:08.287 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '16.77', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.288 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '16.77', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.289 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '17.11', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.289 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '17.11', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.290 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '17.01', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.290 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '17.01', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.291 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '19.75', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.292 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '19.75', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.292 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '20.81', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.293 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '20.81', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.293 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '23.07', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.294 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '23.07', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.294 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '23.99', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.295 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '23.99', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.295 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.14', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.296 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.14', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.296 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '26.07', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.297 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '26.07', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.297 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.96', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.298 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.96', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.298 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.91', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.299 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.91', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.299 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.34', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.300 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.34', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.300 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '24.59', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.301 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '24.59', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.302 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC: Query for item 'OpenWeather_Aussentemperatur' returned 26 rows in 19 ms
2025-07-06 16:09:08.302 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::query: item is OpenWeather_Aussentemperatur
2025-07-06 16:09:08.303 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::getHistItemFilterQuery filter='true' numberDecimalcount='3' table='openweather_aussentemperatur_0001' item='OpenWeather_Aussentemperatur (Type=NumberItem, State=24.59 °C, Label=Außentemperatur, Category=Temperature, Tags=[Temperature, Measurement], Groups=[OpenWeather_Vorhersage, gPersistence, gTemperatur])' itemName='OpenWeather_Aussentemperatur'
2025-07-06 16:09:08.303 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::getHistItemFilterQueryProvider filter = FilterCriteria [itemName=OpenWeather_Aussentemperatur, beginDate=null, endDate=2025-07-06T04:09:08.282753921+02:00[Europe/Berlin], pageNumber=0, pageSize=1, operator=EQ, ordering=DESCENDING, state=null], numberDecimalcount = 3, table = openweather_aussentemperatur_0001, simpleName = OpenWeather_Aussentemperatur
2025-07-06 16:09:08.304 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::query queryString = SELECT time, value FROM openweather_aussentemperatur_0001 WHERE TIME<='2025-07-06 04:09:08' ORDER BY time DESC LIMIT 0,1
2025-07-06 16:09:08.304 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetHistItemFilterQuery sql=SELECT time, value FROM openweather_aussentemperatur_0001 WHERE TIME<='2025-07-06 04:09:08' ORDER BY time DESC LIMIT 0,1
2025-07-06 16:09:08.306 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '17.65', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:09:08.307 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC: Query for item 'OpenWeather_Aussentemperatur' returned 1 rows in 4 ms
2025-07-06 16:09:08.309 [INFO ] [enhab.core.model.script.Change.rules] - #### Success ########
2025-07-06 16:09:08.309 [INFO ] [enhab.core.model.script.Change.rules] - ------- END -------

With out commented //+ "":

2025-07-06 16:10:06.928 [INFO ] [enhab.core.model.script.Change.rules] - ------- Start -------
2025-07-06 16:10:06.929 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::query: item is OpenWeather_Aussentemperatur
2025-07-06 16:10:06.929 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::getHistItemFilterQuery filter='true' numberDecimalcount='3' table='openweather_aussentemperatur_0001' item='OpenWeather_Aussentemperatur (Type=NumberItem, State=24.59 °C, Label=Außentemperatur, Category=Temperature, Tags=[Temperature, Measurement], Groups=[OpenWeather_Vorhersage, gPersistence, gTemperatur])' itemName='OpenWeather_Aussentemperatur'
2025-07-06 16:10:06.930 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::getHistItemFilterQueryProvider filter = FilterCriteria [itemName=OpenWeather_Aussentemperatur, beginDate=2025-07-06T04:10:06.928847536+02:00[Europe/Berlin], endDate=2025-07-06T16:10:06.929184269+02:00[Europe/Berlin], pageNumber=0, pageSize=2147483647, operator=EQ, ordering=ASCENDING, state=null], numberDecimalcount = 3, table = openweather_aussentemperatur_0001, simpleName = OpenWeather_Aussentemperatur
2025-07-06 16:10:06.931 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::query queryString = SELECT time, value FROM openweather_aussentemperatur_0001 WHERE TIME>='2025-07-06 04:10:06' AND TIME<='2025-07-06 16:10:06' ORDER BY time ASC
2025-07-06 16:10:06.931 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetHistItemFilterQuery sql=SELECT time, value FROM openweather_aussentemperatur_0001 WHERE TIME>='2025-07-06 04:10:06' AND TIME<='2025-07-06 16:10:06' ORDER BY time ASC
2025-07-06 16:10:06.934 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '16.77', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.934 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '16.77', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.935 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '17.11', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.936 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '17.11', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.936 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '17.01', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.937 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '17.01', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.938 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '19.75', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.938 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '19.75', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.939 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '20.81', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.939 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '20.81', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.940 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '23.07', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.940 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '23.07', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.941 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '23.99', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.942 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '23.99', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.942 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.14', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.943 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.14', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.943 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '26.07', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.944 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '26.07', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.944 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.96', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.945 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.96', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.945 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.91', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.946 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.91', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.947 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.34', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.947 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '25.34', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.948 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '24.59', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.948 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '24.59', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.949 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC: Query for item 'OpenWeather_Aussentemperatur' returned 26 rows in 20 ms
2025-07-06 16:10:06.949 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC::query: item is OpenWeather_Aussentemperatur
2025-07-06 16:10:06.950 [DEBUG] [persistence.jdbc.internal.JdbcMapper] - JDBC::getHistItemFilterQuery filter='true' numberDecimalcount='3' table='openweather_aussentemperatur_0001' item='OpenWeather_Aussentemperatur (Type=NumberItem, State=24.59 °C, Label=Außentemperatur, Category=Temperature, Tags=[Temperature, Measurement], Groups=[OpenWeather_Vorhersage, gPersistence, gTemperatur])' itemName='OpenWeather_Aussentemperatur'
2025-07-06 16:10:06.950 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::getHistItemFilterQueryProvider filter = FilterCriteria [itemName=OpenWeather_Aussentemperatur, beginDate=null, endDate=2025-07-06T04:10:06.928847536+02:00[Europe/Berlin], pageNumber=0, pageSize=1, operator=EQ, ordering=DESCENDING, state=null], numberDecimalcount = 3, table = openweather_aussentemperatur_0001, simpleName = OpenWeather_Aussentemperatur
2025-07-06 16:10:06.951 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::query queryString = SELECT time, value FROM openweather_aussentemperatur_0001 WHERE TIME<='2025-07-06 04:10:06' ORDER BY time DESC LIMIT 0,1
2025-07-06 16:10:06.952 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::doGetHistItemFilterQuery sql=SELECT time, value FROM openweather_aussentemperatur_0001 WHERE TIME<='2025-07-06 04:10:06' ORDER BY time DESC LIMIT 0,1
2025-07-06 16:10:06.955 [DEBUG] [istence.jdbc.internal.db.JdbcBaseDAO] - JDBC::ItemResultHandler::handleResult getState value = '17.65', unit = '°C', getClass = 'class java.lang.Double', clazz = 'Double'
2025-07-06 16:10:06.955 [DEBUG] [jdbc.internal.JdbcPersistenceService] - JDBC: Query for item 'OpenWeather_Aussentemperatur' returned 1 rows in 5 ms
2025-07-06 16:10:06.958 [ERROR] [.handler.AbstractScriptModuleHandler] - Script execution of rule with UID 'change-2' failed: 'split' is not a member of 'org.openhab.core.types.State'; line 52, column 41, length 19 in change