November 17, 2006 at 12:31 pm
I am having problems pushing a new subscription to a server. The snapshot agent runs fine, but the distribution agent is failing with 'Error executing a batch of commands. Retrying individual commands.' and then with 'The row was not found at the Subscriber when applying the replicated command.' The publication has to drop and recreate the table at the subscriber, and I can see by the creation date of the table it is being recreated. The individual command that is failing is an update command, and I can understand why it's failing because there are no rows at the subscriber, but why is it doing an update command??? Please help.
TIA
Michelle
November 17, 2006 at 12:33 pm
I have a correction to make, the table has not been recreated at the subscriber.
November 17, 2006 at 3:25 pm
I think I have resolved the issue. I changed the distribution agent profile to have a lower batch size and a longer query timeout setting and the subscription is starting to push through now.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply