I have an app which throws consistent SQL errors, which are just the way the system works (not my system) and they create alot of noise. I want to exclude these errors so they don’t create problems, alerts or show in multi dimensional analysis. The error is Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1. It happens on the database services e.g. So I went in to the setting for those services and expanded failure detection, General parameters, switched Override global failure detection settings on and added a message to the Ignored exception:
Any exception where message contains “Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements”.
I am still seeing the errors in the MDA, is this meant to happen?
Does anyone know what the settings actually do - is it just do do with problem creation and alerting?