Subscription does not feed the latest transactions

Asked By steve jenkins 0 points N/A Posted on - 11/03/2011

My subscription does not feed the latest transactions from the publisher. I tried re-initializing it and saw that the snapshot generates for all the articles, the distribution is completed, and the tables are in sync. But then after just a few days, the subscriber would not receive the most recent data. Now, the distribution agent shows no available transactions, and there are no undistributed commands. There are two subscribers, but only one is claiming to have problems. I have checked the SQL server logs and the ms subscriptions, and there are no space issues or inactive subscriptions. What is wrong with the ms subscription?

• Status: Open
• Question Views: 804
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Mahesh Babu 20 points N/A #105058

Subscription does not feed the latest transactions

Hallo Steve Jenkins,

I guess the reason why your ms subscription does not feed the latest transactions from publisher could be possibly be due to some syntax or semantic errors in the SQL statements that you have used to specify the code for subscription.

Make sure that you have set the operations and constraints properly in the code to allow for the feeds to be published. Check to ensure that they are not any truncation errors in the code, and in case you are using the BULK INSERT statement, you have to be aware that it will not work like the EXECUTE AS LOGIN statement will work because they are meant for two different operations.

__
Regards
Mahesh Babu

 

About Mahesh Babu

Questions
1

Answers
473

Best Answers
87

• Vote Up 0 Vote Down

• Posted on - 11/22/2011
• Question Category: MS SQL Server