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

Question

Post reply

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

MAK-1128556

SSCarpal Tunnel

Points: 4594
More actions
February 23, 2010 at 8:53 am

#137428

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

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 1

can someone please let me, Also there is any way to get an email alert if latency exceeds 1min.

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 2

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

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 3

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]

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 4

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!

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 5

MANU-J.

SSC-Dedicated

Points: 31126

February 24, 2010 at 7:46 am

#1124269

Did you gave this a try?

MJ

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 6

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

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 7

MAK-1128556

SSCarpal Tunnel

Points: 4594

February 24, 2010 at 8:24 am

#1124294

Please advise, Thanks

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 8

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

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 9

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

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 10

Try what worked for Deepak, stated on http://social.msdn.microsoft.com/Forums/en-US/sqlreplication/thread/c6e9c5ff-0d72-4af0-be40-a13e5f063eec

MJ

MAK-1128556 SSCarpal Tunnel Points: 4594 More actions · Answer 11

Hi,

Please help me, I can get the email from replication Alerts, but I want to get an email when Latency is more than 10Sec, any suggestion is appreciated