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 12»»

Replication Error, The process could not execute 'sp_MSpub_adjust_identity' on 'Servername'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Expand / Collapse
Author
Message
Posted Tuesday, February 23, 2010 8:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290
Hi,

i am running a tran. replication, and today i got following error, abut after 50min lag my replication was ok. do you know whay this happend and how to prevent and get a email if this happend again. i am running 2005 with SP3
Error I got is

Replication Error, The process could not execute 'sp_MSpub_adjust_identity' on 'Servername'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)

Thanks for help
Post #871195
Posted Tuesday, February 23, 2010 12:52 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290
can someone please let me, Also there is any way to get an email alert if latency exceeds 1min.
Post #871409
Posted Tuesday, February 23, 2010 2:56 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 21, 2014 11:07 PM
Points: 1,688, Visits: 8,760
Tracer tokens comes to your rescue. Read about one such procedure mentioned by Chad at http://blogs.mssqltips.com/blogs/chadboyd/archive/2007/10/24/monitoring-replication-latency-automatically-using-tracer-tokens-sp-replchecklatency-allpubs.aspx.

HTH!
MJ
Post #871489
Posted Tuesday, February 23, 2010 3:13 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290
Hi Thanks for reply, I try to get a email alert from these configeration but can't success, can you help me to figure out how to get an email from these

Replication Monitor
configuration Replication Alert
replication warning : Transsactional replication latency [threshold latency]
Post #871500
Posted Tuesday, February 23, 2010 3:42 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 21, 2014 11:07 PM
Points: 1,688, Visits: 8,760
Replication Monitor
configuration Replication Alert
replication warning : Transsactional replication latency [threshold latency]

After this Select-->SQL Server Performance Condition Alert(under Type)--Then-->Select MSSQL$YUKON1:Replication Logreader Under Object
then Select-->Logreader:Delivery Latency(Under Counter)-->Then ur instance and alert if counter value.....


You have mulitude of options under Objects so choose as per need.

HTH!
Post #871522
Posted Wednesday, February 24, 2010 7:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, April 21, 2014 11:07 PM
Points: 1,688, Visits: 8,760
Did you gave this a try?

MJ
Post #871915
Posted Wednesday, February 24, 2010 7:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290
Hi,

Thanks for reply, and checking on me. I try it but didn't get the email.
my counter Threshold is 5 see,
I use Alter if counter is rises above 4,
please advise
Post #871921
Posted Wednesday, February 24, 2010 8:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290
Please advise, Thanks
Post #871944
Posted Wednesday, February 24, 2010 8:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290
I change the Latency to 5 see,
now when ever it is more then 5 see performance status is Poor
and Status is crictical, can you please help me how to get the email notification
Post #871957
Posted Wednesday, February 24, 2010 10:24 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290
now I am getting the email, but I need only email when threshold is 10sec delay.
please let me know how can I get the parameter to set up
Please help
Post #872048
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse