Adding a value on a specific time (JDBC) fails, sometimes

Setup, Configuration and Use Scripts & Rules
1

I’m using OH 4.3.1 on Ubuntu with a MariaDB sql databse.

In a rule, I read the json respons of an API call to Solcast to get solar power forecasts. In the rule I get the value and the timeslot is referes to. Next I want to store that value with the specific time. I’m using this Blockly part to do just that:

image
image1414×466 58.1 KB

for some reason it writes about 20 values (of in total 96) with the timestamp of the time the rul runs. all other timestamps work fine.

in the database, it looks like this:

image
image1418×1682 386 KB

what am I doing wrong??

thx,

2

What’s “DateTimeKort”? In what you posted, you set the value retrieved from the JSONPATH to a variable named “DateTime”.

3

true, DateTimeKort is another datetime layout I tried.
DateTime is in format: yyyy-mm-ddThh:mm:ss:0.0000000Z
DateTime is in format yyyy-mm-ddThh:mm:ss:00

Both randomly don’t work perfectly. It seems that the first 10-20 values of the Repeat loop get stored with the actual time when the rule runs. But also sometimes it works perfectly. And another rule who basically uses the same concept, never fails.

It feels like a timing thing, perhaps also the json api call respons is big. I did increase the timer of the call and also added 1 5s wait, but all of the above isn’t the solution.

My other rule works with datetime format: yyyy-mm-dd hh:mm:ss
I think I’ll give that a try.

4

I think the datetime block will return now if the value passed to it is null and I think JSONPATH will return null if it doesn’t find anything at the path provided.

So you might need to add some error checking around the JSONPATH to make sure you are getting something back.

That is probably where the “when the rule ran” timestamps come from.

5

Thanks. I’m logging all variables every run and they seem to be fine and look the same (format) between the ones going wrong and going right.

And I will check the json output to be correct (sort of), no harm in doing that