Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imarchenko
Yak Posting Veteran
57 Posts |
 Posted - 2009-10-14 : 15:16:40
|
| Hello! We had maintenance on distribution server (separate from Publisher and Subscriber) and after Server restart I noticed that I constantly being disconnected from Publisher in Replication Monitor. Initially, I am able to connect to Publisher by after clicking around, my connection is being terminated and I had to select 'Click to Distributor' to reconnect.I tried to debug by capturing SQL Trace and noticed following error that I believe is causing a problem:Msg 8115, Level 16, State 2, Procedure sp_replmonitorrefreshagentdata, Line 110Arithmetic overflow error converting expression to data type int.The statement has been terminated.This is an intermittent error. I am able to run following statement successfully in a little while (I stripped out actual names):use [master]exec [distribution].sys.sp_replmonitorhelpsubscription @publisher = N'<ServerName>', @publisher_db = N'<DBName>', @publication = N'<Publication>', @mode = 0, @exclude_anonymous = 0, @refreshpolicy = N'0'I believe that Arithmetic overflow is what's causing a problem. This is SQL Server 2005 environment.Any advice is appreciated,Igor |
|
|
|
|
|
Loosing connection to Publisher in Replication mon