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 |
|
panthagani
Yak Posting Veteran
58 Posts |
 Posted - 2007-06-17 : 20:01:39
|
| I added a new subscriber to my existing environment. That makes it one publisher plus 4 subscribers. There were some initial replication errors since this DB was already used in the same environment, but in a different installation. So, I didn't need to reinitialize and run the snapshot. I just created the subscription from the Push subscription wizard after selecting the option to NOT to initialize with a snapshot. After replication to this subscriber has become stable, I see a blue arrow on the replication monitor - I understand that this means that one of the distribution agents (I don't have queue and merge agents) is 'retrying'. From the time replication errors (normal red cross) stopped, all distribution agents run normally with the 'green triangle'. Still the replication monitor keeps showing the 'blue arrow' on the Distribution agents folder. Refreshed and reopened the Enterprise manager - to rule out refresh issues but still the same. Is something wrong with the distribution agent for the new subscriber? Repl agent history looks clean, though. Or, is it some general network connectivity issue with subscriber?PS: This is transactional replication.Any help with this is appreciated. Thank you. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-17 : 20:23:50
|
| You may need to create replication related sps on new subscriber manually. |
 |
|
|
panthagani
Yak Posting Veteran
58 Posts |
Posted - 2007-06-17 : 22:46:59
|
| If you are referring to sp_MSIns, Del and Upd sprocs... I got the entire script by sp_scriptpublicationcustomprocs 'Publisher DB' and ran the same on the subscriber. Later I got some errors for some specific ones and I complied the specific scripts by generating the corresponding ones from the publisher using : sp_scriptinsproc, del and upd procs with the respective article ids. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-17 : 22:50:48
|
| Any details in distribution agent? |
|
|
|
panthagani
Yak Posting Veteran
58 Posts |
Posted - 2007-06-17 : 23:07:23
|
| No errors in the distribution agent history or 'session details' that may point to 'retries'. However, I'm using a custom agent profile to skip 20598 and 20585 errors. Am I doing something I should'nt? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-06-18 : 16:15:21
|
| Tried with default agent profile? |
|
|
|
|
|
|
Distrubution agent shows 'retry' for a long time