dbWarden HealthReport won't run on SQL 2012 standard
-
Hi everybody,
i am usins dbWarden on 8 sql-servers. Everything runs fine, only my SQL 2012 standard won't execute the heath report.
Error from job-history:
Null value is elimitnated by an aggregate or other SET ......
If i try to execute the SP direct, i get the following error:
Warning: Null value is eliminated by an aggregate or other SET operation.
Msg 213, Level 16, State 7, Procedure sp_replmonitorhelppublication, Line 320
Column name or number of supplied values does not match table definition.
Has anybody an idea? I get emails when there are blockings etc.., only the healthreport won't run.
SQL 2012 Standard SP1 64bit
Windows Cluster 2008
It is our distribution-cluster, nothing else.
thanks
regards,
Andreas
-
Seems to be an issue with the stored procedure.
Take a look inside to see what's going on.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Look here first;
http://technet.microsoft.com/en-us/library/ms186304.aspx
something is going on with your replication SP.
MCSE SQL Server 2012\2014\2016
-
Hi,
on the distribution-server i am able to run the sp "sp_replmonitorhelppublication" without error.
-
hi,
on the page from soureforce.net there is no button to create an ticket, or to submit an bug.
Had andybody an idea, or an link, to get in contact with the developer of dbwarden?
-
They have a discussion thread here:
http://www.sqlservercentral.com/Forums/Topic1441532-3362-17.aspx
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply