CCU-Historian V3.1.0

[Mathias]

Die neue Version ist wie immer auf GitHub zu finden.

Die 39°C-Version mit kleinen Verbesserungen.

Fehlerbehebungen / Verbesserungen

• Nach DB-Migration Fehlermeldung `Tabelle "DATA_POINTS" besteht bereits` (3.1.0)
• H2-HighChart auf V6.4b aktualisieren (3.1.0)
• Leere trenddesigns.groovy aus den Installationspaketen überschreibt eine vorhandene (3.1.0)
• Aufzeichnung der virtuellen Gruppen (3.1.0)
• Geänderte IP-Adresse der CCU wird nicht automatisch in der Konfiguration aktualisiert (3.1.0)
• Bei Datenpunkten mit "Swinging Door" geht der Trend nicht bis zum aktuellen Wert (3.1.0)

Gruß
Mathias

[Micky]

Hallo Mathias,

auch von meiner Seite wieder ein dickes Dankeschön für deine tolle Arbeit. Das Update auf meiner debian11_vm von 2.8 auf 2.9 und dann auf 3.1 incl. Datenbankkonvertierung ist wie gewohnt problemlos durchgelaufen. Sollten wider Erwarten irgendwelche Probleme auftreten, werde ich an dieser Stelle gern berichten.

Grüße M.

[JMeh]

Hallo Mathias,

seit dem Update auf V3.1.0 funktioniert bei mir die Swinging-Door-Kompression nicht mehr (siehe Vergleichsbilder).

Kurvenverlauf vor dem Update

vorher.png (10.59 KiB) 1077 mal betrachtet

Kurvenverlauf nach dem Update

nachher.png (11.27 KiB) 1077 mal betrachtet

In der Konfiguration steht bei den Messwerten aber noch "Sw.Do.K." mit dem Parameterwert.

Den Rechner habe ich bereits neu gestartet, ohne Änderung.

Gruß Jörg

[Mathias]

Werden bei Dir regelmäßig/automatisch Trend-Grafiken zu diesem Datenpunkt angefragt?

Bei der Swinging Door-Kompression werden Werte im Arbeitsspeicher zwischengespeichert. Es kann erst später entschieden werden, ob sie in die Datenbank müssen. Dadurch war die Datenbank für diese Werte nicht aktuell. Der Trend ging nicht bis zur aktuellen Zeit.

Um das zu umgehen, werden nun die zwischengespeicherten Werte vor einer anstehenden Trend-Abfrage in die Datenbank geschrieben, und der Swinging Door-Algorithmus neu gestartet. Dadurch werden zusätzliche Werte in der Datenbank abgelegt.

Deshalb die obige Frage.

[JMeh]

Hallo Mathias,

nein ich erzeuge keine automatischen Grafiken (weiss auch gar nicht, wie das geht ) Ich schaue nur ab und zu mal auf die Webseite mit einem händisch ausgelösten Reload des Browsers.

Den Mechanismus hatte ich schon verstanden, steht ja ausführlich im Change-Log.

Hat sich vielleicht an der Interpretation des Parameter-Wertes (hier im Beispiel 0.3) für den Swinging Door-Algorithmus etwas geändert?

Im Bild kann man sehen, dass es sich stetig um Original-Werte handelt, die minütlich hereinkommen und nicht (mehr) gefiltert werden.

Temperaturwert mit max. Wertedifferenz 0,3 °C

Gruß
Jörg

[Mathias]

Dann schaue ich mir das nochmal an. Ich habe auf der Projektseite einen Eintrag dazu erstellt.

[JMeh]

Hallo noch mal,

ich habe nun ein Downgrade auf die Version 3.0.3 gemacht. Und siehe da, sofort funktioniert die Swinging-Door-Kompression wieder.

Messwerte vor und nach dem Downgrade

Gruß Jörg

[tgw]

Hallo,

ich hatte das schon bei der 3.0.3 gemeldet:
Hier: viewtopic.php?f=38&t=74575#p724387

Mit der 3.1.0 habe ich jetzt wieder Fehler nach dem Konvertieren:

Code: Alles auswählen

25 15:49:24|INFO   |CCU-Historian V3.1.0
2022-07-25 15:49:24|INFO   |(C)MDZ (info@ccu-historian.de)
2022-07-25 15:49:25|INFO   |Starting base services
2022-07-25 15:49:25|INFO   |Connecting to database
2022-07-25 15:49:27|INFO   |Starting database web server
2022-07-25 15:49:27|INFO   |Auto detected local address (please check): 192.168.x.xx
2022-07-25 15:49:27|INFO   |Setting up device 1
2022-07-25 15:49:27|INFO   |Creating HM script client for http://192.168.x.xxx:8181/tclrega.exe
2022-07-25 15:49:27|INFO   |Setting up plug-in 1
2022-07-25 15:49:27|INFO   |Setting up plug-in 2
2022-07-25 15:49:28|INFO   |Configured following interfaces: BidCos-RF, HmIP-RF, SysVar, CUxD, BidCos-Wired
2022-07-25 15:49:28|INFO   |Starting interfaces
2022-07-25 15:49:28|INFO   |Starting BIN-RPC server on port 2099
2022-07-25 15:49:28|INFO   |Starting XML-RPC server on port 2098
2022-07-25 15:49:28|INFO   |Connecting to 192.168.x.xxx:8701
2022-07-25 15:49:28|INFO   |Starting historian
2022-07-25 15:49:28|INFO   |Starting web server
2022-07-25 15:49:28|INFO   |Web server port: 4663
2022-07-25 15:49:34|SEVERE |Exception: Tabelle "D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE" nicht gefunden
Table "D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE" not found; SQL statement:
INSERT INTO D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE (TS, "VALUE", STATE) VALUES (?, ?, ?) [42102-214]
2022-07-25 15:49:34|SEVERE |Detail: org.h2.jdbc.JdbcSQLSyntaxErrorException: Tabelle "D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE" nicht gefunden
Table "D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE" not found; SQL statement:
INSERT INTO D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE (TS, "VALUE", STATE) VALUES (?, ?, ?) [42102-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:223)
        at org.h2.message.DbException.get(DbException.java:199)
        at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398)
        at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369)
        at org.h2.command.Parser.readTableOrView(Parser.java:8358)
        at org.h2.command.Parser.readTableOrView(Parser.java:8328)
        at org.h2.command.Parser.parseInsert(Parser.java:1632)
        at org.h2.command.Parser.parsePrepared(Parser.java:814)
        at org.h2.command.Parser.parse(Parser.java:689)
        at org.h2.command.Parser.parse(Parser.java:661)
        at org.h2.command.Parser.prepareCommand(Parser.java:569)
        at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
        at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1044)
        at mdz.ccuhistorian.Database.consume(Database.groovy:563)
        at mdz.ccuhistorian.ExtendedStorage.consume(ExtendedStorage.groovy:39)
        at mdz.ccuhistorian.ExtendedStorage.consume(ExtendedStorage.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.FirstArchived.consume(FirstArchived.groovy:35)
        at mdz.ccuhistorian.eventprocessing.FirstArchived.consume(FirstArchived.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.Preprocessor.consume(Preprocessor.groovy:76)
        at mdz.ccuhistorian.eventprocessing.Preprocessor.consume(Preprocessor.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.OverflowHandler.consume(OverflowHandler.groovy:73)
        at mdz.ccuhistorian.eventprocessing.OverflowHandler.consume(OverflowHandler.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.HistoryDisabledFilter.consume(HistoryDisabledFilter.groovy:36)
        at mdz.ccuhistorian.eventprocessing.HistoryDisabledFilter.consume(HistoryDisabledFilter.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
2022-07-25 15:49:34|SEVERE |Exception: Tabelle "D_HMIP_RF_000EDA499C84B3_1_HUMIDITY" nicht gefunden
Table "D_HMIP_RF_000EDA499Cxxxx_1_HUMIDITY" not found; SQL statement:
INSERT INTO D_HMIP_RF_000EDA499Cxxxx_1_HUMIDITY (TS, "VALUE", STATE) VALUES (?, ?, ?) [42102-214]
2022-07-25 15:49:34|SEVERE |Detail: org.h2.jdbc.JdbcSQLSyntaxErrorException: Tabelle "D_HMIP_RF_000EDA499Cxxxx_1_HUMIDITY" nicht gefunden
Table "D_HMIP_RF_000EDA499Cxxxx_1_HUMIDITY" not found; SQL statement:
INSERT INTO D_HMIP_RF_000EDA499Cxxxx_1_HUMIDITY (TS, "VALUE", STATE) VALUES (?, ?, ?) [42102-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:223)
        at org.h2.message.DbException.get(DbException.java:199)
        at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398)
        at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369)
        at org.h2.command.Parser.readTableOrView(Parser.java:8358)
        at org.h2.command.Parser.readTableOrView(Parser.java:8328)
        at org.h2.command.Parser.parseInsert(Parser.java:1632)
        at org.h2.command.Parser.parsePrepared(Parser.java:814)
        at org.h2.command.Parser.parse(Parser.java:689)
        at org.h2.command.Parser.parse(Parser.java:661)
        at org.h2.command.Parser.prepareCommand(Parser.java:569)
        at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
        at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1044)
        at mdz.ccuhistorian.Database.consume(Database.groovy:563)
        at mdz.ccuhistorian.ExtendedStorage.consume(ExtendedStorage.groovy:39)
        at mdz.ccuhistorian.ExtendedStorage.consume(ExtendedStorage.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.FirstArchived.consume(FirstArchived.groovy:35)
        at mdz.ccuhistorian.eventprocessing.FirstArchived.consume(FirstArchived.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.Preprocessor.consume(Preprocessor.groovy:76)
        at mdz.ccuhistorian.eventprocessing.Preprocessor.consume(Preprocessor.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.OverflowHandler.consume(OverflowHandler.groovy:73)
        at mdz.ccuhistorian.eventprocessing.OverflowHandler.consume(OverflowHandler.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.HistoryDisabledFilter.consume(HistoryDisabledFilter.groovy:36)
        at mdz.ccuhistorian.eventprocessing.HistoryDisabledFilter.consume(HistoryDisabledFilter.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
2022-07-25 15:49:34|SEVERE |Exception: Tabelle "D_HMIP_RF_000EDA499Cxxxx_0_CONFIG_PENDING" nicht gefunden
Table "D_HMIP_RF_000EDA499Cxxxx_0_CONFIG_PENDING" not found; SQL statement:
INSERT INTO D_HMIP_RF_000EDA499Cxxxx_0_CONFIG_PENDING (TS, "VALUE", STATE) VALUES (?, ?, ?) [42102-214]
2022-07-25 15:49:34|SEVERE |Detail: org.h2.jdbc.JdbcSQLSyntaxErrorException: Tabelle "D_HMIP_RF_000EDA499Cxxxx_0_CONFIG_PENDING" nicht gefunden
Table "D_HMIP_RF_000EDA499Cxxxx_0_CONFIG_PENDING" not found; SQL statement:
INSERT INTO D_HMIP_RF_000EDA499Cxxxx_0_CONFIG_PENDING (TS, "VALUE", STATE) VALUES (?, ?, ?) [42102-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:223)
        at org.h2.message.DbException.get(DbException.java:199)
        at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398)
        at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369)
        at org.h2.command.Parser.readTableOrView(Parser.java:8358)
        at org.h2.command.Parser.readTableOrView(Parser.java:8328)
        at org.h2.command.Parser.parseInsert(Parser.java:1632)
        at org.h2.command.Parser.parsePrepared(Parser.java:814)
        at org.h2.command.Parser.parse(Parser.java:689)
        at org.h2.command.Parser.parse(Parser.java:661)
        at org.h2.command.Parser.prepareCommand(Parser.java:569)
        at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
        at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1044)
        at mdz.ccuhistorian.Database.consume(Database.groovy:563)
        at mdz.ccuhistorian.ExtendedStorage.consume(ExtendedStorage.groovy:39)
        at mdz.ccuhistorian.ExtendedStorage.consume(ExtendedStorage.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.FirstArchived.consume(FirstArchived.groovy:35)
        at mdz.ccuhistorian.eventprocessing.FirstArchived.consume(FirstArchived.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.Preprocessor.consume(Preprocessor.groovy:76)
        at mdz.ccuhistorian.eventprocessing.Preprocessor.consume(Preprocessor.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.OverflowHandler.consume(OverflowHandler.groovy:73)
        at mdz.ccuhistorian.eventprocessing.OverflowHandler.consume(OverflowHandler.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.HistoryDisabledFilter.consume(HistoryDisabledFilter.groovy:36)
        at mdz.ccuhistorian.eventprocessing.HistoryDisabledFilter.consume(HistoryDisabledFilter.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
2022-07-25 15:49:34|SEVERE |Exception: Tabelle "D_HMIP_RF_000EDA499Cxxxx_0_DUTY_CYCLE" nicht gefunden
Table "D_HMIP_RF_000EDA499Cxxxx_0_DUTY_CYCLE" not found; SQL statement:
INSERT INTO D_HMIP_RF_000EDA499Cxxxx_0_DUTY_CYCLE (TS, "VALUE", STATE) VALUES (?, ?, ?) [42102-214]
2022-07-25 15:49:34|SEVERE |Detail: org.h2.jdbc.JdbcSQLSyntaxErrorException: Tabelle "D_HMIP_RF_000EDA499Cxxxx_0_DUTY_CYCLE" nicht gefunden
Table "D_HMIP_RF_000EDA499Cxxxx_0_DUTY_CYCLE" not found; SQL statement:
INSERT INTO D_HMIP_RF_000EDA499Cxxxx_0_DUTY_CYCLE (TS, "VALUE", STATE) VALUES (?, ?, ?) [42102-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:223)
        at org.h2.message.DbException.get(DbException.java:199)
        at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398)
        at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369)
        at org.h2.command.Parser.readTableOrView(Parser.java:8358)
        at org.h2.command.Parser.readTableOrView(Parser.java:8328)
        at org.h2.command.Parser.parseInsert(Parser.java:1632)
        at org.h2.command.Parser.parsePrepared(Parser.java:814)
        at org.h2.command.Parser.parse(Parser.java:689)
        at org.h2.command.Parser.parse(Parser.java:661)
        at org.h2.command.Parser.prepareCommand(Parser.java:569)
        at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
        at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1044)
        at mdz.ccuhistorian.Database.consume(Database.groovy:563)
        at mdz.ccuhistorian.ExtendedStorage.consume(ExtendedStorage.groovy:39)
        at mdz.ccuhistorian.ExtendedStorage.consume(ExtendedStorage.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.FirstArchived.consume(FirstArchived.groovy:35)
        at mdz.ccuhistorian.eventprocessing.FirstArchived.consume(FirstArchived.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.Preprocessor.consume(Preprocessor.groovy:76)
        at mdz.ccuhistorian.eventprocessing.Preprocessor.consume(Preprocessor.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.OverflowHandler.consume(OverflowHandler.groovy:73)
        at mdz.ccuhistorian.eventprocessing.OverflowHandler.consume(OverflowHandler.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.HistoryDisabledFilter.consume(HistoryDisabledFilter.groovy:36)
        at mdz.ccuhistorian.eventprocessing.HistoryDisabledFilter.consume(HistoryDisabledFilter.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
2022-07-25 15:49:34|SEVERE |Exception: Tabelle "D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE_STATUS" nicht gefunden
Table "D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE_STATUS" not found; SQL statement:
INSERT INTO D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE_STATUS (TS, "VALUE", STATE) VALUES (?, ?, ?) [42102-214]
2022-07-25 15:49:34|SEVERE |Detail: org.h2.jdbc.JdbcSQLSyntaxErrorException: Tabelle "D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE_STATUS" nicht gefunden
Table "D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE_STATUS" not found; SQL statement:
INSERT INTO D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE_STATUS (TS, "VALUE", STATE) VALUES (?, ?, ?) [42102-214]
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
        at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
        at org.h2.message.DbException.get(DbException.java:223)
        at org.h2.message.DbException.get(DbException.java:199)
        at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8398)
        at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8369)
        at org.h2.command.Parser.readTableOrView(Parser.java:8358)
        at org.h2.command.Parser.readTableOrView(Parser.java:8328)
        at org.h2.command.Parser.parseInsert(Parser.java:1632)
        at org.h2.command.Parser.parsePrepared(Parser.java:814)
        at org.h2.command.Parser.parse(Parser.java:689)
        at org.h2.command.Parser.parse(Parser.java:661)
        at org.h2.command.Parser.prepareCommand(Parser.java:569)
        at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
        at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
        at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
        at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92)
        at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:1044)
        at mdz.ccuhistorian.Database.consume(Database.groovy:563)
        at mdz.ccuhistorian.ExtendedStorage.consume(ExtendedStorage.groovy:39)
        at mdz.ccuhistorian.ExtendedStorage.consume(ExtendedStorage.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.FirstArchived.consume(FirstArchived.groovy:35)
        at mdz.ccuhistorian.eventprocessing.FirstArchived.consume(FirstArchived.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.Preprocessor.consume(Preprocessor.groovy:76)
        at mdz.ccuhistorian.eventprocessing.Preprocessor.consume(Preprocessor.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.OverflowHandler.consume(OverflowHandler.groovy:73)
        at mdz.ccuhistorian.eventprocessing.OverflowHandler.consume(OverflowHandler.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.HistoryDisabledFilter.consume(HistoryDisabledFilter.groovy:36)
        at mdz.ccuhistorian.eventprocessing.HistoryDisabledFilter.consume(HistoryDisabledFilter.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy:64)
        at mdz.ccuhistorian.eventprocessing.DataPointStorageUpdater.consume(DataPointStorageUpdater.groovy)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.eventprocessing.Buffer.purge(Buffer.java:74)
        at mdz.eventprocessing.Buffer.consume(Buffer.java:65)
        at mdz.eventprocessing.BasicProducer.lambda$0(BasicProducer.java:36)
        at mdz.Exceptions.catchToLog(Exceptions.java:74)
        at mdz.eventprocessing.BasicProducer.safeProduce(BasicProducer.java:36)
        at mdz.eventprocessing.BasicProducer.produce(BasicProducer.java:42)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)
        at mdz.hc.itf.Manager.sendEvents(Manager.groovy:137)

Das wiederholt sich ewig lange mit unterschiedlichen Adressen und endet schließlich mit einem "Out of Memory"
Auf die neueste Java habe ich upgedatet, hat nichts gebracht.

Ich habe dazu ein Errorlog generiert, wenn es interessant ist, kann ich das zur Verfügung stellen.

[Mathias]

Mit der 3.1.0 habe ich jetzt wieder Fehler nach dem Konvertieren:

Code: Alles auswählen

...
2022-07-25 15:49:34|SEVERE |Exception: Tabelle "D_HMIP_RF_000EDA499Cxxxx_1_ACTUAL_TEMPERATURE" nicht gefunden
...

Kannst Du mir irgendwie Deine über -runscript exportierte Datenbank zur Verfügung stellen?

Falls die Datei zu groß ist, kannst Du mit dem Skript "Alte Zeitreihendaten löschen" eine Kopie Deiner Datenbank vor dem Export verkleinern (z.B. nur 10 Tage an Daten behalten).

[tgw]

Du hast eine PM. Ich kann Dir jede beliebige Größe zur Verfügung stellen.