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 8, 2013 12:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:12 AM
Points: 49, Visits: 349
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 8, 2013 1:34 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 13,250, Visits: 11,027
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 8, 2013 11:15 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, September 18, 2014 10:25 AM
Points: 301, Visits: 595
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 9, 2013 12:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:12 AM
Points: 49, Visits: 349
Hi,

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

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


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 941, Visits: 2,935
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 9, 2013 5:34 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:12 AM
Points: 49, Visits: 349
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 9, 2013 6:00 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 5:04 AM
Points: 941, Visits: 2,935
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