Group Write Telegram not saved in MySQL

redbear-ger · August 18, 2019, 4:02pm

I’ve made an upgrade to 2.4 this weekend and preferred to do it from scratch (also jumped to KNX2 binding).

Works so far “ok” but I’ve difficulties bringing back my KNX electric meter to work.

It sends Group Telegrams every second and OH sees them…

2019-08-18 17:51:47.937 [TRACE] [g.knx.internal.dpt.KNXCoreTypeMapper] - toType datapoint DPT = 1.001
2019-08-18 17:51:47.985 [TRACE] [nx.internal.client.AbstractKNXClient] - Sending a Group Read Request telegram for 5/0/3
2019-08-18 17:51:51.144 [TRACE] [nx.internal.client.AbstractKNXClient] - Received a Group Write telegram from '1.1.46' to '15/0/12' with value '[64, 71, -33, 58]'
2019-08-18 17:51:51.161 [TRACE] [nx.internal.client.AbstractKNXClient] - Received a Group Write telegram from '1.1.46' to '15/0/13' with value '[63, -88, 49, 38]'
2019-08-18 17:51:51.190 [TRACE] [nx.internal.client.AbstractKNXClient] - Received a Group Write telegram from '1.1.46' to '15/0/14' with value '[64, 3, -58, -90]'
2019-08-18 17:51:52.885 [TRACE] [nx.internal.client.AbstractKNXClient] - Received a Group Write telegram from '1.1.46' to '15/0/8' with value '[68, 101, 0, 0]'
2019-08-18 17:51:52.888 [TRACE] [nx.internal.client.AbstractKNXClient] - Received a Group Write telegram from '1.1.46' to '15/0/9' with value '[67, -10, -128, 0]'
2019-08-18 17:51:52.891 [TRACE] [nx.internal.client.AbstractKNXClient] - Received a Group Write telegram from '1.1.46' to '15/0/10' with value '[66, -44, 0, 0]'
2019-08-18 17:51:52.894 [TRACE] [nx.internal.client.AbstractKNXClient] - Received a Group Write telegram from '1.1.46' to '15/0/11' with value '[67, -98, 0, 0]'

So far so good. But it just dont want to save them in my msql. All other items are in.

my .items

// COU 23   ----------------------------------------------------------------------------------------------------------------------------------------------
Number      Stromzaehler_Wirkenergie_Total          "Wirkenergie Total [%f Wh]"                             { channel="knx:device:GIRA2167:EZD-FW_23:Kanal_23_A" }
Number      Stromzaehler_SpannungL1                 "Spannung L1 [%f A]"                                    { channel="knx:device:GIRA2167:EZD-FW_23:Kanal_23_B" }
Number      Stromzaehler_SpannungL2                 "Spannung L2 [%f A]"                                    { channel="knx:device:GIRA2167:EZD-FW_23:Kanal_23_C" }
Number      Stromzaehler_SpannungL3                 "Spannung L3 [%f A]"                                    { channel="knx:device:GIRA2167:EZD-FW_23:Kanal_23_D" }
Number      Stromzaehler_Wirkleistung_Total         "Wirkleistung Total [%f W]"                             { channel="knx:device:GIRA2167:EZD-FW_23:Kanal_23_E" }
Number      Stromzaehler_WirkleistungL1             "Wirkleistung L1 [%f W]"                                { channel="knx:device:GIRA2167:EZD-FW_23:Kanal_23_F" }
Number      Stromzaehler_WirkleistungL2             "Wirkleistung L2 [%f W]"                                { channel="knx:device:GIRA2167:EZD-FW_23:Kanal_23_G" }
Number      Stromzaehler_WirkleistungL3             "Wirkleistung L3 [%f W]"                                { channel="knx:device:GIRA2167:EZD-FW_23:Kanal_23_H" }

my things

         Thing device EZD-FW_23 "COU 23" @ "KNX" [ address="1.1.46", fetch=false, pingInterval=600, readInterval=0 ]                      			
                {
                        Type    number          :       Kanal_23_A      "Stromzaehler Wirkenergie Total"        [ ga="<13.010:15/0/5" ]
                        Type    number          :       Kanal_23_B      "Spannung L1 [%f A]"                    [ ga="<14.019:15/0/18" ]
                        Type    number          :       Kanal_23_C      "Spannung L2 [%f A]"                    [ ga="<14.019:15/0/19" ]
                        Type    number          :       Kanal_23_D      "Spannung L3 [%f A]"                    [ ga="<14.019:15/0/20" ]
                        Type    number          :       Kanal_23_E      "Wirkleistung Total [%f W]"             [ ga="<14.056:15/0/8" ]
                        Type    number          :       Kanal_23_F      "Wirkleistung L1 [%f W]"                [ ga="<14.056:15/0/9" ]
                        Type    number          :       Kanal_23_G      "Wirkleistung L2 [%f W]"                [ ga="<14.056:15/0/10" ]
                        Type    number          :       Kanal_23_H      "Wirkleistung L3 [%f W]"                [ ga="<14.056:15/0/11" ]
                }

my persist

Strategies {
       everyMinute     : "0 * * * * ?"
       every5Minutes   : "0 */5 * * * ?"
       everyHour       : "0 0 * * * ?"
       everyDay        : "0 0 0 * * ?"
       default = everyChange
}

Items {
* : strategy = everyChange, everyHour, everyDay, restoreOnStartup
}

my mysql.conf

url=jdbc:mysql://127.0.0.1:3306/openhab?serverTimezone=Europe/Berlin
user=***
password=***
reconnectCnt=1
waitTimeout=28800
localtime=true

it worked before… so what did I forget? or is there something wrong with the GA format in my things?

System is an Intel Nuc with lots of performance, ram and hdd.
knx-traffic is around 7-10%
Mode is “Tunnel” (was Router before on my Gira IP Router, but didnt get that properly to work. Now its my Lingg&Janke CompiReg2).

rossko57 · August 18, 2019, 6:50pm

As persistence saves Item states, the important missing info is whether your Item(s) gets updated. Look in events.log

redbear-ger · August 20, 2019, 10:33am

I get “some” of them in my mysql when I remove the DPTs.
Event Log is empty.

         Thing device EZD-FW_23 "COU 23" @ "KNX" [ address="1.1.46", fetch=false, pingInterval=600, readInterval=0 ]                      			
                {
                        Type    number          :       Kanal_23_A      "Stromzaehler Wirkenergie Total"        [ ga="15/0/5" ]
                        Type    number          :       Kanal_23_B      "Spannung L1 [%f A]"                    [ ga="15/0/18" ]
                        Type    number          :       Kanal_23_C      "Spannung L2 [%f A]"                    [ ga="15/0/19" ]
                        Type    number          :       Kanal_23_D      "Spannung L3 [%f A]"                    [ ga="15/0/20" ]
                        Type    number          :       Kanal_23_E      "Wirkleistung Total [%f W]"             [ ga="15/0/8" ]
                        Type    number          :       Kanal_23_F      "Wirkleistung L1 [%f W]"                [ ga="15/0/9" ]
                        Type    number          :       Kanal_23_G      "Wirkleistung L2 [%f W]"                [ ga="15/0/10" ]
                        Type    number          :       Kanal_23_H      "Wirkleistung L3 [%f W]"                [ ga="15/0/11" ]
                }

And I cant display the data in habpanel. (If the sun shines my values are negative).

grafik

Item45:
grafik

So these are in my mysql now. That would be ok, but the data saved is absolutely nonsense. I think its because of the missing DPTs.

rossko57 · August 20, 2019, 11:08am

Okay, so my prompting was aimed it - if your Items don’t get updates, you are wasting effort looking at persistence.

The likely problem area is KNX config, I cannot help with that but suggest you update your post title from “Group Write Telegram not saved in MySQL” to reflect that and draw the right attention.