[gelöst] unerwartete Ergebnisse bei DBrep diffvalue

[Nighthawk]

Hallo,

ich versuch gerade eine Übersicht über die Monats und Jahresverbräuche aufzubauen.
Dazu wollte ich mir die Monats, bzw. Jahresverbräuche mit DBrep berechnen lassen, leider bekomme ich dabei aber nicht das Ergebnis was ich erwarte.

Hier ein Beispiel:

Folgendes ist in der Datenbank:s

Code Auswählen Erweitern

+---------------------+--------------+------+----------------------------------+-------------------+---------------+------+
| TIMESTAMP           | DEVICE       | TYPE | EVENT                            | READING           | VALUE         | UNIT |
+---------------------+--------------+------+----------------------------------+-------------------+---------------+------+
| 2017-11-30 00:00:12 | Stromzaehler | OBIS | total_consumption: 22047.5792124 | total_consumption | 22047.5792124 |      |
.
.
.
.
| 2017-11-30 23:59:59 | Stromzaehler | OBIS | total_consumption: 22059.6079391 | total_consumption | 22059.6079391 |      |


Hier noch das DBrep Device:

Code Auswählen Erweitern

Internals:
   DATABASE   fhem_long
   DEF        logdb_long
   FUUID      5cb5702d-f33f-357a-dac7-0da64b8c7661b076
   FVERSION   93_DbRep.pm:v8.50.4-s26650/2022-11-04
   LASTCMD    diffValue display
   MODEL      Client
   NAME       Dbrep_long
   NOTIFYDEV  global,Dbrep_long
   NR         195
   NTFY_ORDER 50-Dbrep_long
   ROLE       Client
   STATE      done
   TYPE       DbRep
   UTF8       1
   eventCount 8
   HELPER:
     DBLOGDEVICE logdb_long
     GRANTS     USAGE,INSERT,UPDATE,DELETE,SELECT
     IDRETRIES  2
     MINTS      2016-12-26 23:33:00
     PACKAGE    main
     VERSION    8.50.4
     CV:
       aggregation day
       aggsec     86400
       destr      2022-11-30
       dsstr      2022-11-01
       epoch_seconds_end 1669849199
       mestr      11
       msstr      11
       testr      23:59:59
       tsstr      00:00:00
       wdadd     
       yestr      2022
       ysstr      2022
     DBREPCOL:
       COLSET     1
       DEVICE     64
       EVENT      512
       READING    64
       TYPE       64
       UNIT       32
       VALUE      128
   OLDREADINGS:
   READINGS:
     2022-12-01 12:17:33   2022-11-01_23-59-58__Stromzaehler__total_consumption__DIFF__2022-11-01 0.0000
     2022-12-01 12:17:33   2022-11-02_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-02 0.0007
     2022-12-01 12:17:33   2022-11-03_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-03 0.0006
     2022-12-01 12:17:33   2022-11-04_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-04 0.0006
     2022-12-01 12:17:33   2022-11-05_23-59-58__Stromzaehler__total_consumption__DIFF__2022-11-05 0.0007
     2022-12-01 12:17:33   2022-11-06_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-06 0.0008
     2022-12-01 12:17:33   2022-11-07_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-07 0.0006
     2022-12-01 12:17:33   2022-11-08_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-08 0.0005
     2022-12-01 12:17:33   2022-11-09_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-09 0.0007
     2022-12-01 12:17:33   2022-11-10_23-59-58__Stromzaehler__total_consumption__DIFF__2022-11-10 0.0005
     2022-12-01 12:17:33   2022-11-11_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-11 0.0005
     2022-12-01 12:17:33   2022-11-12_23-59-55__Stromzaehler__total_consumption__DIFF__2022-11-12 0.0004
     2022-12-01 12:17:33   2022-11-13_23-59-58__Stromzaehler__total_consumption__DIFF__2022-11-13 0.0007
     2022-12-01 12:17:33   2022-11-14_23-59-40__Stromzaehler__total_consumption__DIFF__2022-11-14 0.0006
     2022-12-01 12:17:33   2022-11-15_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-15 0.0014
     2022-12-01 12:17:33   2022-11-16_23-59-57__Stromzaehler__total_consumption__DIFF__2022-11-16 0.0005
     2022-12-01 12:17:33   2022-11-17_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-17 0.0007
     2022-12-01 12:17:33   2022-11-18_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-18 0.0006
     2022-12-01 12:17:33   2022-11-19_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-19 0.0005
     2022-12-01 12:17:33   2022-11-20_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-20 0.0006
     2022-12-01 12:17:33   2022-11-21_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-21 0.0007
     2022-12-01 12:17:33   2022-11-22_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-22 0.0006
     2022-12-01 12:17:33   2022-11-23_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-23 0.0007
     2022-12-01 12:17:33   2022-11-24_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-24 0.0006
     2022-12-01 12:17:33   2022-11-25_23-59-59__Stromzaehler__total_consumption__DIFF__2022-11-25 0.0006
     2022-12-01 12:17:33   2022-11-26_23-59-55__Stromzaehler__total_consumption__DIFF__2022-11-26 0.0005
     2022-12-01 12:17:33   2022-11-27_23-59-56__Stromzaehler__total_consumption__DIFF__2022-11-27 0.0006
     2022-12-01 12:17:33   2022-11-28_23-59-57__Stromzaehler__total_consumption__DIFF__2022-11-28 0.0007
     2022-12-01 12:17:33   2022-11-29_23-59-58__Stromzaehler__total_consumption__DIFF__2022-11-29 0.0005
     2022-12-01 12:17:33   2022-11-30_23-59-55__Stromzaehler__total_consumption__DIFF__2022-11-30 0.0005
     2022-12-01 12:17:33   background_processing_time 11.7581
     2022-12-01 12:17:33   sql_processing_time 6.7730
     2022-12-01 12:17:33   state           done
   hmccu:
Attributes:
   DbLogExclude .*
   aggregation day
   allowDeletion 1
   devStateIcon connected:10px-kreis-gelb .*disconnect:10px-kreis-rot .*done:10px-kreis-gruen
   device     Stromzaehler
   group      Datenbank
   reading    total_consumption
   room       90_Datenbank
   showproctime 1
   sortby     27
   timestamp_begin previous_month_begin
   timestamp_end previous_month_end


Wie man hier erkennt, bekomme ich bei Diffvalue als Ergebnis für den 30.11.22 den Wert 0.0005, erwartet hätte ich den Wert 12,0287267.
Was mache ich falsch, oder verstehe ich die Funktion von Diffvalue falsch?

[DS_Starter]

Folgendes ist in der Datenbank:

2017-11-30 ...


2017 ??

[Nighthawk]

Hallo Heiko,

ja, meine DB ist mittlerweile recht groß
Das Datum spielt bei dem Problem aber keine Rolle, das Ergeblis ist immer unerklärlich.

hier noch ein Beispiel:

Code Auswählen Erweitern


select value from history where device = "Stromzaehler" and reading = "total_consumption"  and  timestamp like "2022-11-30%" ORDER BY timestamp  DESC Limit 1;
+----------------+
| value          |
+----------------+
| 12612.88269031 |
+----------------+


select value from history where device = "Stromzaehler" and reading = "total_consumption"  and  timestamp like "2022-11-30%" ORDER BY timestamp  ASC Limit 1;
+----------------+
| value          |
+----------------+
| 12597.68599355 |
+----------------+


select (select value from history where device = "Stromzaehler" and reading = "total_consumption"  and  timestamp like "2022-11-30%" ORDER BY timestamp  DESC Limit 1) - (select value from history where device = "Stromzaehler" and reading = "total_consumption"  and  timestamp like "2022-11-30%" ORDER BY timestamp  ASC Limit 1) AS Differenz;
+--------------------+
| Differenz          |
+--------------------+
| 15.196696760000123 |
+--------------------+



Und so sieht das diffvalue Ergebnis aus:

Code Auswählen Erweitern

     
.
.
2022-12-05 12:56:24   2022-11-30_23-59-55__Stromzaehler__total_consumption__DIFF__2022-11-30 0.0005

[DS_Starter]

Kann ich so bei mir nicht nachvollziehen.
Ich habe viele Diff's laufen und die passen.
Da hilft vermutlich nur wenn du mal verbose 4 oder 5 im Device anschaltest und wir die Statements und deren Ergebnisse anschauen.
Meine DB ist auch schon mit Energiedaten seit 2014 gefüllt und 6GB groß.

[Nighthawk]

Hallo Heiko,

hier ein Log mit Verbose 5 von einem anderen Device, das Problem ist das gleiche:

Code Auswählen Erweitern


2022.12.05 14:56:07 4: DbRep Report - -------- New selection ---------
2022.12.05 14:56:07 4: DbRep Report - Command: diffValue display
2022.12.05 14:56:07 4: DbRep Report - FullDay option: 0
2022.12.05 14:56:07 5: DbRep Report - Timestamp begin epocheseconds: 1667257200
2022.12.05 14:56:07 4: DbRep Report - Timestamp begin human readable: 2022-11-01 00:00:00
2022.12.05 14:56:07 5: DbRep Report - Timestamp end epocheseconds: 1669849199
2022.12.05 14:56:07 4: DbRep Report - Timestamp end human readable: 2022-11-30 23:59:59
2022.12.05 14:56:07 5: DbRep Report - Daylight savings changed: 0 (from "Wed Nov 30 00:00:00 2022" to "Thu Dec  1 00:00:00 2022")
2022.12.05 14:56:07 5: DbRep Report - runtime_string: 2022-11-30, runtime_string_first: 2022-11-30, runtime_string_next: 2022-11-30 23:59:59
2022.12.05 14:56:07 4: DbRep Report - Aggregation: day
2022.12.05 14:56:07 5: DbRep Report - BlockingCall with PID "102511" started
2022.12.05 14:56:07 4: DbRep Report - Database connect - user: fhemDB, UTF-8 option set: yes
2022.12.05 14:56:07 5: DbRep Report - IsTimeSet: 1, IsAggrSet: 1
2022.12.05 14:56:07 5: DbRep Report - Timestamp-Array:
2022-11-01#2022-11-01 00:00:00#2022-11-02 2022-11-02#2022-11-02#2022-11-03 2022-11-03#2022-11-03#2022-11-04 2022-11-04#2022-11-04#2022-11-05 2022-11-05#2022-11-05#2022-11-06 2022-11-06#2022-11-06#2022-11-07 2022-11-07#2022-11-07#2022-11-08 2022-11-08#2022-11-08#2022-11-09 2022-11-09#2022-11-09#2022-11-10 2022-11-10#2022-11-10#2022-11-11 2022-11-11#2022-11-11#2022-11-12 2022-11-12#2022-11-12#2022-11-13 2022-11-13#2022-11-13#2022-11-14 2022-11-14#2022-11-14#2022-11-15 2022-11-15#2022-11-15#2022-11-16 2022-11-16#2022-11-16#2022-11-17 2022-11-17#2022-11-17#2022-11-18 2022-11-18#2022-11-18#2022-11-19 2022-11-19#2022-11-19#2022-11-20 2022-11-20#2022-11-20#2022-11-21 2022-11-21#2022-11-21#2022-11-22 2022-11-22#2022-11-22#2022-11-23 2022-11-23#2022-11-23#2022-11-24 2022-11-24#2022-11-24#2022-11-25 2022-11-25#2022-11-25#2022-11-26 2022-11-26#2022-11-26#2022-11-27 2022-11-27#2022-11-27#2022-11-28 2022-11-28#2022-11-28#2022-11-29 2022-11-29#2022-11-29#2022-11-30 2022-11-30#2022-11-30#2022-11-30 23:59:59
2022.12.05 14:56:07 4: DbRep Report - simple do statement: set @V:= 0, @diff:= 0, @diffTotal:= 0, @RB:= 1;
2022.12.05 14:56:07 5: DbRep Report - Devices for operation -
included (1): Gasverbrauch
included with wildcard: 
excluded (0): 
excluded with wildcard:
2022.12.05 14:56:09 5: DbRep Report - Readings for operation -
included (1): countsOverall
included with wildcard: 
excluded (0): 
excluded with wildcard:
2022.12.05 14:56:09 4: DbRep Report - SQL execute: SELECT TIMESTAMP,VALUE, if(VALUE-@V < 0 OR @RB = 1 , @diff:= 0, @diff:= VALUE-@V ) as DIFF, @V:= VALUE as VALUEBEFORE, @RB:= '0' as RBIT  FROM history where ( DEVICE = 'Gasverbrauch' ) AND ( READING = 'countsOverall' ) AND TIMESTAMP >= '2022-11-29' AND TIMESTAMP < '2022-11-30' ORDER BY TIMESTAMP;
2022.12.05 14:56:09 4: DbRep Report - simple do statement: set @V:= 0, @diff:= 0, @diffTotal:= 0, @RB:= 1;
2022.12.05 14:56:09 5: DbRep Report - Devices for operation -
included (1): Gasverbrauch
included with wildcard: 
excluded (0): 
excluded with wildcard:
2022.12.05 14:56:09 5: DbRep Report - Readings for operation -
included (1): countsOverall
included with wildcard: 
excluded (0): 
excluded with wildcard:
2022.12.05 14:56:09 4: DbRep Report - SQL execute: SELECT TIMESTAMP,VALUE, if(VALUE-@V < 0 OR @RB = 1 , @diff:= 0, @diff:= VALUE-@V ) as DIFF, @V:= VALUE as VALUEBEFORE, @RB:= '0' as RBIT  FROM history where ( DEVICE = 'Gasverbrauch' ) AND ( READING = 'countsOverall' ) AND TIMESTAMP >= '2022-11-30' AND TIMESTAMP <= '2022-11-30 23:59:59' ORDER BY TIMESTAMP;
2022.12.05 14:56:09 5: DbRep Report - data of row_array result assigned to fields:
2022.12.05 14:56:10 4: DbRep Report - balance difference of 0 between 2022-11-30 and 2022-11-30
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_00:17:32, VALUE: 151332, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_00:21:31, VALUE: 151333, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_00:45:30, VALUE: 151333, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_00:49:30, VALUE: 151334, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_00:55:29, VALUE: 151334, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:01:29, VALUE: 151334, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:13:28, VALUE: 151334, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:17:28, VALUE: 151335, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:41:27, VALUE: 151335, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:45:26, VALUE: 151336, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_01:57:26, VALUE: 151336, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:03:25, VALUE: 151336, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:09:25, VALUE: 151336, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:13:25, VALUE: 151337, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:37:23, VALUE: 151337, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:41:23, VALUE: 151338, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_02:59:22, VALUE: 151338, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_03:05:22, VALUE: 151338, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_03:08:22, VALUE: 151339, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_03:32:20, VALUE: 151339, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_03:36:20, VALUE: 151340, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_03:59:55, VALUE: 151340, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_04:04:18, VALUE: 151341, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_04:28:17, VALUE: 151341, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_04:32:17, VALUE: 151342, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_04:56:15, VALUE: 151342, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:00:15, VALUE: 151343, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:06:15, VALUE: 151343, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:08:15, VALUE: 151344, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:20:14, VALUE: 151344, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:23:14, VALUE: 151345, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:47:12, VALUE: 151345, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:50:12, VALUE: 151346, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_05:56:12, VALUE: 151346, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:02:11, VALUE: 151346, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:14:11, VALUE: 151346, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:18:11, VALUE: 151347, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:42:09, VALUE: 151347, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:46:09, VALUE: 151348, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_06:58:08, VALUE: 151348, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:04:08, VALUE: 151348, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:10:08, VALUE: 151348, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:13:07, VALUE: 151349, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:37:06, VALUE: 151349, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:41:06, VALUE: 151350, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_07:59:05, VALUE: 151350, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_08:05:04, VALUE: 151350, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_08:09:04, VALUE: 151351, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_08:33:03, VALUE: 151351, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_08:37:03, VALUE: 151352, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_08:55:01, VALUE: 151352, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:01:01, VALUE: 151352, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:05:01, VALUE: 151353, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:11:01, VALUE: 151354, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:15:00, VALUE: 151355, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:38:59, VALUE: 151355, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:41:59, VALUE: 151356, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_09:59:55, VALUE: 151356, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_10:05:57, VALUE: 151356, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_10:09:57, VALUE: 151357, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_10:33:56, VALUE: 151357, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_10:36:55, VALUE: 151358, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_10:59:55, VALUE: 151358, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_11:04:54, VALUE: 151359, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_11:28:52, VALUE: 151359, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_11:32:52, VALUE: 151360, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_11:56:51, VALUE: 151360, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_11:59:51, VALUE: 151361, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_12:05:50, VALUE: 151361, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_12:23:49, VALUE: 151361, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_12:27:49, VALUE: 151362, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_12:51:48, VALUE: 151362, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_12:55:47, VALUE: 151363, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:00:47, VALUE: 151364, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:24:46, VALUE: 151364, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:26:46, VALUE: 151365, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:50:44, VALUE: 151365, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:54:44, VALUE: 151366, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_13:59:55, VALUE: 151366, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:06:43, VALUE: 151366, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:18:43, VALUE: 151366, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:21:42, VALUE: 151367, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:45:41, VALUE: 151367, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:49:41, VALUE: 151368, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_14:55:40, VALUE: 151368, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:01:40, VALUE: 151368, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:13:39, VALUE: 151368, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:17:39, VALUE: 151369, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:41:38, VALUE: 151369, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:45:38, VALUE: 151370, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_15:57:37, VALUE: 151370, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_16:03:36, VALUE: 151370, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_16:21:35, VALUE: 151370, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_16:27:35, VALUE: 151371, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_16:51:34, VALUE: 151371, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_16:55:33, VALUE: 151372, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:01:33, VALUE: 151372, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:19:32, VALUE: 151372, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:23:32, VALUE: 151373, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:47:30, VALUE: 151373, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:50:30, VALUE: 151374, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_17:56:30, VALUE: 151374, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:02:30, VALUE: 151374, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:14:29, VALUE: 151374, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:18:29, VALUE: 151375, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:42:27, VALUE: 151375, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:45:27, VALUE: 151376, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_18:57:26, VALUE: 151376, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:03:26, VALUE: 151376, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:09:26, VALUE: 151376, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:13:26, VALUE: 151377, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:37:24, VALUE: 151377, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:40:24, VALUE: 151378, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_19:58:23, VALUE: 151378, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:04:22, VALUE: 151378, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:08:22, VALUE: 151379, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:13:22, VALUE: 151380, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:18:22, VALUE: 151381, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:22:21, VALUE: 151382, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:28:21, VALUE: 151382, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:30:21, VALUE: 151383, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:54:20, VALUE: 151383, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_20:58:19, VALUE: 151384, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:04:19, VALUE: 151384, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:22:18, VALUE: 151384, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:25:18, VALUE: 151385, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:49:16, VALUE: 151385, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:53:16, VALUE: 151386, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_21:59:16, VALUE: 151386, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:05:15, VALUE: 151386, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:17:15, VALUE: 151386, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:20:15, VALUE: 151387, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:43:13, VALUE: 151387, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:48:13, VALUE: 151388, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_22:59:55, VALUE: 151388, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:06:12, VALUE: 151388, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:12:12, VALUE: 151388, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:15:11, VALUE: 151389, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:39:10, VALUE: 151389, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:43:10, VALUE: 151390, DIFF: 0.0000
2022.12.05 14:56:10 5: DbRep Report - Runtimestring: 2022-11-30, DEVICE: Gasverbrauch, READING: countsOverall, TIMESTAMP: 2022-11-30_23:55:09, VALUE: 151390, DIFF: 0.0000
2022.12.05 14:56:10 4: DbRep Report - print result of diffValue calculation before encoding ...
2022.12.05 14:56:10 4: runtimestring Key: 2022-11-30, value: 2022-11-30|0|2022-11-30_23:55:09
2022.12.05 14:56:10 4: DbRep Report - count of values used for calc:
2022.12.05 14:56:10 4: 2022-11-30 => 142
2022.12.05 14:56:10 5: DbRep Report - BlockingCall PID "102511" finished
2022.12.05 14:56:10 4: DbRep Report - print result of diffValue calculation after decoding ...
2022.12.05 14:56:10 4: DbRep Report - runtimestring Key: 2022-11-30, value: 2022-11-30|0|2022-11-30_23:55:09


[DS_Starter]

Ich erkenne das Problem, sehe aber momentan keine Lösung.
Auch wenn es unwahrscheinlich scheint ... vllt. kann deine MySQL Version nicht mit dem Statement (das Variablensetting) umgehen.
Was ist deine DB-Version ?

[Nighthawk]

Hallo Heiko,

die Version war bis eben
mysqld  Ver 10.6.7-MariaDB-2ubuntu1.1 for debian-linux-gnu on x86_64 (Ubuntu 22.04)

jetzt nach dem Update ist es
mysqld  Ver 10.6.11-MariaDB-0ubuntu0.22.04.1 for debian-linux-gnu on x86_64 (Ubuntu 22.04)

das Problem bleibt leider.

[DS_Starter]

Hmm,

meine ist die 10.1.48-MariaDB-0+deb9u2

Nicht das neuere Versionen das Problem haben ... muss mal googeln

[DS_Starter]

Ich habe dir eine Testversion in mein contrib geladen (siehe Fußtext).
Kannst du die mal bei dir probieren ?
Nach dem Download reload bzw. restart nicht vergessen.

[Nighthawk]

Hallo Heiko,

das sieht gut aus, woran lag es nun?

Code Auswählen Erweitern

     
.
.
2022-12-05 17:26:04   2022-11-29_23-59-33__Gasverbrauch__countsOverall__DIFF__2022-11-29 61.0000
2022-12-05 17:26:04   2022-11-30_23-55-09__Gasverbrauch__countsOverall__DIFF__2022-11-30 58.0000

Danke und Gruß
Alex

[DS_Starter]

Wie ich vermutete.
Offensichtlich kann die MySQL Version nicht mit der Syntax umgehen.
Ich habe einfach die Routine, die ich z.B. für SQLite verwende, auch für MariaDb/MySQL aktiviert.

Weiß nur noch nicht wie ich jetzt damit umgehe ...

[DS_Starter]

Ich habe die Änderung mit meiner  MariaDB getestet und mich entschieden diese Änderung ins Repo zu übernehmen.
Scheint zu passen.
Habe das Modul nochmal bisschen angepasst.
Kannst du bitte nochmal aus dem contrib laden und bei dir testen ?

[ch.eick]

Moin,
Habt ihr das SQL mal als Statement, dann könnte ich es mir mal anschauen und gegen eine Oracle MySQL testen.

VG Christian

[DS_Starter]

Hi Christian,

Das siehst du weiter oben.
Zuerst werden die Variablen initialisiert:

Code Auswählen Erweitern


2022.12.05 14:56:09 4: DbRep Report - simple do statement: set @V:= 0, @diff:= 0, @diffTotal:= 0, @RB:= 1;


Dann das Statement:

Code Auswählen Erweitern

2022.12.05 14:56:09 4: DbRep Report - SQL execute: SELECT TIMESTAMP,VALUE, if(VALUE-@V < 0 OR @RB = 1 , @diff:= 0, @diff:= VALUE-@V ) as DIFF, @V:= VALUE as VALUEBEFORE, @RB:= '0' as RBIT  FROM history where ( DEVICE = 'Gasverbrauch' ) AND ( READING = 'countsOverall' ) AND TIMESTAMP >= '2022-11-29' AND TIMESTAMP < '2022-11-30' ORDER BY TIMESTAMP;


Das Konstrukt kennst du ja.

[ch.eick]

Ja, das verwende ich auch so bei meinen  Abfragen.