I create new Subscriber and getting error The row was not found at the Subscriber when applying the replicated command.

Question

Post reply

I create new Subscriber and getting error The row was not found at the Subscriber when applying the replicated command.

MAK-1128556

SSCarpal Tunnel

Points: 4594
More actions
August 20, 2009 at 8:29 am

#133926

One of my Subscriber is running fine, but when I create new Subscriber I am getting following error
The row was not found at the Subscriber when applying the replicated command.

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

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

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 1

Did you apply a snapshop to initialize the new subscriber?

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

No, do I have to initialize that, I restore the last night data and just create a subscriber with out initialize.

Steve Jones - SSC Editor SSC Guru Points: 736212 More actions · Answer 3

You might need to if the tables in the article might have changed.

When you set up the subscriber, it ought to ask to initialize the subscriber.

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

hi I recreate the subscriber with initianilaze, now I am getting following error

The initial snapshot for publication 'OLTP_PUB_ALL_Tables' is not yet available.

also when I check the properties of Subscriber I can see Subscriber Status is "Pending"

alen teplitsky SSC-Dedicated Points: 30014 More actions · Answer 5

on the subscription reinitialize it. then start it manually to make sure you get the message that the snapshot is not available.

run the snapshot

run the log reader

start the subscription and it should start copying the snapshot and then any transactions that happened during the snapshot copy

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

MAK-1128556

SSCarpal Tunnel

Points: 4594

August 20, 2009 at 9:43 am

#1042221

How to run the log reader

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

Hi I am getting following error, when I pick up the option initinalize

The initial snapshot for publication 'OLTP_PUB_ALL_Tables' is not yet available.

ps. One Orange Chip Points: 29422 More actions · Answer 8

MAK (8/20/2009)
How to run the log reader

If you're using pull subscription, the log reader job would be created on the subscriber, if you've setup push subscription, the job will be created on the distributor.

expand sql server agent>expand jobs> the job names with two numbers seperated by a hyphen would be your log reader agent job.

Pradeep Singh