DBFL_SQL TCP error 99680

PLCnext Engineer
1

Hello,
We are using DBFL_SQL_6 function block library to write and read into MariaDB that’s
running on the PLC linux side. Application have been running for couple months
and sometimes we get TCP error 99680.

Any idea what could be causing the error?

udtDBFL_MYSQL_ACCESS.diTCP_Status: 99680
udtDBFL_MYSQL_ACCESS.diSQL_Status: 1
PLC: AXC F 3152
PLCnext Engineer: 2022.9
DBFL_SQL_library: 6

2

Hello Janne,
the Error Code will be decoded as follows:

image.png
image.png685×307 37.6 KB
99680 - 50000 = 49,680 = 16#C210
This error code comes from the firmware function block TCP_SOCKET_2, please see the Error description below:
?name=image.png
I would like to recommend the following steps:

                                          1. Please update the Library to DBFL_SQL_library: 7
                                          2. If PN-Protocol isn't used, deactivate the PN-Service in WBM
                                          3. If the Error persists, check if the connection is terminated from the TCP client or TCP server with wireshark.

Thanks & BR
Eduard

3

Hi Eduard,
Thank you for the reply and instructions how to decode TCP error codes.
What does the PN-protocol refer to? Is it a Profinet protocol on the whole system or something else? We have motors that use Profinet.

/Janne

4

Hello Janne,
thanks for the info, no it is not necessary to deactivate the PN if you need it. Deactivating services that are not needed saves PLC resources (e.g. CPU load).
In order to analyze this problem, the Wireshark record with the time the error occurred is required. The easiest way is to use the switch with mirroring function or you can start recording on OS (e.g. 10 record file in rollover).
BR Eduard

5

Hello Janne, sorry for the question in between but i am struggeling to get mariadb working on the plc. I was installing the app from the Store but it seems that the given Port is still Closed. How did you manage to make this thing working?

Best regards

6

Hello Janne, sorry for the question in between but i am struggeling to get mariadb working on the plc. I was installing the app from the Store but it seems that the given Port is still Closed. How did you manage to make this thing working?</p>Best regards</p>

Hi,
I used example 3 from the DBFL_SQL library to get started. I am using balena engine on PLC linux side to run the database (https://www.plcnextstore.com/eu/app/1032). I dont recall problems with port being closed. Can you give more info about your setup?

7

Hello Janne,</p>thanks for the info, no it is not necessary to deactivate the PN if you need it. Deactivating services that are not needed saves PLC resources (e.g. CPU load).</p>In order to analyze this problem, the Wireshark record with the time the error occurred is required. The easiest way is to use the switch with mirroring function or you can start recording on OS (e.g. 10 record file in rollover).</p>BR Eduard</p>

Thanks for reply Eduard , we will test this when we get a chance.