Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

dbWarden HealthReport won't run on SQL 2012 standard Expand / Collapse
Author
Message
Posted Tuesday, October 08, 2013 12:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 7:07 AM
Points: 48, Visits: 252
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
Post #1502470
Posted Tuesday, October 08, 2013 1:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:39 AM
Points: 12,175, Visits: 9,126
Seems to be an issue with the stored procedure.
Take a look inside to see what's going on.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1502484
Posted Tuesday, October 08, 2013 11:15 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, March 14, 2014 10:32 AM
Points: 215, Visits: 444
Look here first;

http://technet.microsoft.com/en-us/library/ms186304.aspx

something is going on with your replication SP.


MCSA SQL Server 2012
Post #1502727
Posted Wednesday, October 09, 2013 12:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 7:07 AM
Points: 48, Visits: 252
Hi,

on the distribution-server i am able to run the sp "sp_replmonitorhelppublication" without error.

Post #1502924
Posted Wednesday, October 09, 2013 3:59 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 11:49 AM
Points: 739, Visits: 2,470
sp_replmonitorhelppublication returns an extra column in 2012. If you have the latest version of DbWarden then it is most likely a bug. Try submit a ticket with the developers of DbWarden.



The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1502997
Posted Wednesday, October 09, 2013 5:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 7:07 AM
Points: 48, Visits: 252
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?
Post #1503026
Posted Wednesday, October 09, 2013 6:00 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: 2 days ago @ 11:49 AM
Points: 739, Visits: 2,470
They have a discussion thread here:
http://www.sqlservercentral.com/Forums/Topic1441532-3362-17.aspx





The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1503043
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse