4/19/2024 7:45 AM | |
Joined: 8/3/2022 Last visit: 4/10/2025 Posts: 5 Rating:
|
Hi alanTI, Thank you for your answer
It is clear that the connection interruptions causes all these duplicated alarms. Furthermore, i have storage problems due to the amount of repeated data that are being logged and the dump files (over 2GB) generated by the constant warnings and error messages. ¿Does anyone have any way to avoid alarms with bad quality from being logged? ------------------------------------------------------------------------------------------ |
Last edited by: Jen_Moderator at: 04/19/2024 08:33:24New subject after splitting |
|
4/22/2024 5:12 PM | |
Joined: 7/5/2021 Last visit: 4/16/2025 Posts: 171 Rating:
|
hello aem_a12, i botched together something that looks like a solution, at least on RT. Since there are no system functions that allow to edit sqllite files from wincc unified, and it is not possible to add libraries to js I went outside the scada environment. I have expertly crafted asked chatGPT to make a python script that given a folder looks trough the .db3 files present in the folder and removes any entries from the tables LoggedAlarm where change reason is equal to 16. I have chosen python since it is the only language where i know how to pack everything in a .exe without external dependencies. here is the python code:
then i compiled it in a .exe, that i will now try to add to attachments, it is a split .zip, if you put all 3 file in a folder you should be able to open it. finally i call this application with the path to folder as argument from wincc, example as tested from a button:
I have tried it and it works, seemingly without messing anything up in the databases. It goes without saying that I'am not responsible for any damages to any production environment. It has been done on my part as more of an experiment integrating external scripts in wincc unified. In our future systems i will most likely use a plc on LAN with the scada and push all the alarms to this PLC using S7 put. This script will allow me to clean up the logs as needed on already commissioned systems. @stefan_arcularius afaik it is the same behavior an any wincc unified, rt and ucp. Attachmentrmv_changeReason_16.zip (239 Downloads) |
Last edited by: alanTI at: 04/22/2024 17:16:14 |
|
4/22/2024 5:15 PM | |
Joined: 7/5/2021 Last visit: 4/16/2025 Posts: 171 Rating:
|
attachment 2/3 delete .txt from extension
Attachmentrmv_changeReason_16.z02.txt (261 Downloads) |
4/22/2024 5:16 PM | |
Joined: 7/5/2021 Last visit: 4/16/2025 Posts: 171 Rating:
|
attachment 3/3 delete .txt from extension
Attachmentrmv_changeReason_16.z01.txt (274 Downloads) |
4/23/2024 11:28 AM | |
Joined: 1/21/2013 Last visit: 4/19/2025 Posts: 3765 Rating:
|
Hi aem_a12,
Regarding the GfxRTS crashes, you should create a new support request to get them analyzed more thoroughly. Regarding the multiple logged alarms, I cannot give you any advice yet. I would have to test this for myself first, but at the moment I am testing tag logging, not alarm logging. Kind regards |
4/29/2024 7:23 AM | |
Joined: 8/3/2022 Last visit: 4/10/2025 Posts: 5 Rating:
|
Hi Stefan, Yes, they are analyzing it. I hope we can finally find a solution. Thank you very much for your help. |
Follow us on