ich habe bei der Trend Darstellung unter v 1.2 fest gestellt, dass ich keine Diagramme von Luftfeuchtewerten darstellen kann.
Temperaturen funktionieren.
Es sind nur sehr wenige Datenpunkte in der DB, da nur 2 Heizungen und 4 Fenster gelogt werden.
Meine Frage ist nun, ob der Fehler in Historian 1.2 liegt, oder die DB zerschossen ist.
Probeweise habe ich mal den Befehl -recalc ausführen lassen. Der erzeugt exeptions, sobald die Luftfeuchtewerte dran sind.
out of range und 86400 sieht mir eher nach einem systematischen Fehler aus.
Hat jemand eine Idee, wie ich da weiter komme?
Code: Alles auswählen
PS D:\CCU_Historian> java -jar .\ccu-historian.jar -recalc
2018-03-09 10:47:23|INFO |CCU-Historian V1.2.0
2018-03-09 10:47:23|INFO |(C)MDZ (info@ccu-historian.de)
2018-03-09 10:47:23|INFO |Starting base services
2018-03-09 10:47:23|INFO |Connecting to database
2018-03-09 10:47:24|INFO |Starting database web server
2018-03-09 10:47:24|INFO |Starting recalculation of compressed data points
2018-03-09 10:47:24|INFO |Recalculating compressed data point BidCos-RF.VT1-1.ERROR
2018-03-09 10:47:24|INFO |0 entries from 2 dropped (0.0 %); 0.031 seconds
2018-03-09 10:47:24|INFO |Recalculating compressed data point BidCos-RF.VT1-1.VALVE_STATE
2018-03-09 10:47:25|INFO |0 entries from 4362 dropped (0.0 %); 0.64 seconds
2018-03-09 10:47:25|INFO |Recalculating compressed data point BidCos-RF.VT2-1.ERROR
2018-03-09 10:47:25|INFO |0 entries from 2 dropped (0.0 %); 0 seconds
2018-03-09 10:47:25|INFO |Recalculating compressed data point BidCos-RF.VT2-1.VALVE_STATE
2018-03-09 10:47:25|INFO |0 entries from 4085 dropped (0.0 %); 0.312 seconds
2018-03-09 10:47:25|INFO |Recalculating compressed data point BidCos-RF.VT3-1.ERROR
2018-03-09 10:47:25|INFO |0 entries from 2 dropped (0.0 %); 0 seconds
2018-03-09 10:47:25|INFO |Recalculating compressed data point BidCos-RF.VT3-1.VALVE_STATE
2018-03-09 10:47:26|INFO |0 entries from 10258 dropped (0.0 %); 0.889 seconds
2018-03-09 10:47:26|INFO |Recalculating compressed data point BidCos-RF.WT1_Klima.HUMIDITY
2018-03-09 10:47:27|WARNING|Failed to execute: SELECT TS, VALUE, STATE FROM D_BIDCOS_RF_JEQ0235821_1_HUMIDITY WHERE TS>=? AND TS<? ORDER BY TS because: Allgemeiner Fehler: "java.lang.IllegalArgumentException: timeNanos out of range 86400162000000"
General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400
162000000"; SQL statement:
SELECT TS, VALUE, STATE FROM D_BIDCOS_RF_JEQ0235821_1_HUMIDITY WHERE TS>=? AND TS<? ORDER BY TS [50000-196]
2018-03-09 10:47:27|SEVERE |Exception: Retrieving of time series failed: Allgemeiner Fehler: "java.lang.IllegalArgumentException: timeNanos out of range 86400162000000"
General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400162000000"; SQL statement:
SELECT TS, VALUE, STATE FROM D_BIDCOS_RF_JEQ0235821_1_HUMIDITY WHERE TS>=? AND TS<? ORDER BY TS [50000-196]
2018-03-09 10:47:27|SEVERE |Detail: java.util.NoSuchElementException: Retrieving
of time series failed: Allgemeiner Fehler: "java.lang.IllegalArgumentException:
timeNanos out of range 86400162000000"
General error: "java.lang.IllegalArgumentException: timeNanos out of range 86400162000000"; SQL statement:
SELECT TS, VALUE, STATE FROM D_BIDCOS_RF_JEQ0235821_1_HUMIDITY WHERE TS>=? AND TS<? ORDER BY TS [50000-196]
at mdz.hc.TimeSeriesBulkIterator.nextChunk(TimeSeriesBulkIterator.java:57)
at mdz.hc.TimeSeriesBulkIterator.currentOrNextIterator(TimeSeriesBulkIterator.java:65)
at mdz.hc.TimeSeriesBulkIterator.hasNext(TimeSeriesBulkIterator.java:71)
at mdz.eventprocessing.IteratorProducerAdapter.request(IteratorProducerAdapter.java:35)
at mdz.eventprocessing.ConsumerIteratorAdapter.hasNext(ConsumerIteratorAdapter.java:47)
at mdz.ccuhistorian.Database.replaceTimeSeries(Database.groovy:381)
at mdz.ccuhistorian.ExtendedStorage.replaceTimeSeries(ExtendedStorage.groovy:133)
at mdz.ccuhistorian.MaintenanceSystem$_recalculate_closure3.doCall(MaintenanceSystem.groovy:107)
at mdz.ccuhistorian.MaintenanceSystem.recalculate(MaintenanceSystem.groovy:79)
at mdz.ccuhistorian.MaintenanceSystem$_closure1$_closure5.doCall(MaintenanceSystem.groovy:51)
at mdz.ccuhistorian.MaintenanceSystem$_closure1$_closure5.call(MaintenanceSystem.groovy)
at mdz.Exceptions.lambda$0(Exceptions.java:84)
at mdz.Exceptions.catchToLog(Exceptions.java:74)
at mdz.Exceptions.catchToLog(Exceptions.java:84)
at mdz.ccuhistorian.MaintenanceSystem$_closure1.doCall(MaintenanceSystem.groovy:51)
at mdz.ccuhistorian.MaintenanceSystem$_closure1.call(MaintenanceSystem.groovy)
PS D:\CCU_Historian>