cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Highlighted

Errors in SQL Server Error Log Alerts (for recent versions of SQL?)

I created a SQL Server Error Log Alert to find the word 'Fail' in the error logs.  Mostly this alerts me to backup failures and login failures.  Works well for my SQL 2005 thru 2008 R2 servers.  For most or all of our SQL 2012 and SQL 2014 servers this alert is Broken, we get the following error - Error executing extended stored procedure: Invalid Parameter Type.  We use DPA version 9.0.147.  How do I make this work for my more modern SQL versions?

Labels (1)
Tags (2)
0 Kudos
2 Replies
Highlighted
Level 14

Re: Errors in SQL Server Error Log Alerts (for recent versions of SQL?)

This was a known bug in 9.0.X of DPA.  There was a change in the parameter type for that sproc that wasn't caught. Any possibility to upgrade to 9.1 where this alert was fixed?  Sorry for any inconvenience!

Highlighted

Re: Errors in SQL Server Error Log Alerts (for recent versions of SQL?)

Thanks for letting me know.  We will be upgrading at some point and this gives added motivation.

0 Kudos