Subscription does not feed the latest transactions

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 0 points N/A #105058

Subscription does not feed the latest transactions

qa-featured

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

 

Login/Register to Answer

Related Questions