Delete Warnings for UAIV0 driver, Stop logging of warnings fo UAIV0

Modified on 2022/11/10 09:15 by Pavol Vaca Categorized as Equipment Drivers, How to, QCX RoboLab V8, QCX V8

==Introduction==
PanAnalytical equipment can generate big number of unique warnings which leads to massive table of warnings. Consequences are failed exports and problems to load warnings in Performance Viewer. We need to delete these warnings and stop driver from logging them.


==Deletion of warnings==
This is done by running a SQL script which finds all UAIV0 equipment and deletes all warnings for these equipment.


Script is attached to this page (on the top right side).

[image:{UP(Delete-Warnings-for-UAIV0-driver)}00_where.png|medium|left]













Rename file to .sql.


[image:{UP(Delete-Warnings-for-UAIV0-driver)}01_rename.png|medium|left]
















Open in SQL Server Management Studio


[image:{UP(Delete-Warnings-for-UAIV0-driver)}02_open.png|medium|left]


















Execute.


[image:{UP(Delete-Warnings-for-UAIV0-driver)}03_execute.png|medium|left]


















Check if something was deleted.


[image:{UP(Delete-Warnings-for-UAIV0-driver)}04_results.png|medium|left]




















==Equipment configuration==
Turn off logging of warnings for UAIV0.


Set Message mask to 4.


System > QCX Equipment tool > Specific > Edit

Stop/Start the driver!


[image:{UP(Delete-Warnings-for-UAIV0-driver)}05_MessageMask.png|medium|left]

Meta Keywords:
Meta Description:
Change Comment:

FLSmidth QCX wiki

Delete Warnings for UAIV0 driver, Stop logging of warnings fo UAIV0