Subscribers are no longer getting all update applied at the Publisher

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jheaphy - 13 Aug 2008 01:01 GMT

Some of the database updates on the Publisher are not being downloaded
to the Subscriber. However, all the changes at the subscribers are
being uploaded successfully to the Publisher. But, when I do a
complete download to a new local database I get all the data from the
Publisher. We've been running live for about one month. This was
working fine and we have made no configuration changes. I'm wondering
if we have the Publication configured correctly. And if we are might
some scheduled jobs.

Reply to this Message

Hilary Cotter - 16 Aug 2008 16:21 GMT

Is it possible that these errors are showing up in the conflict table?

I also recently opened up a bug which involved timestamp columns which are
not at the end of a table.

Is this possibly your case too?

> Some of the database updates on the Publisher are not being downloaded
> to the Subscriber. However, all the changes at the subscribers are
[quoted text clipped - 4 lines]
> if we have the Publication configured correctly. And if we are might
> some scheduled jobs.

Reply to this Message

jheaphy - 16 Aug 2008 20:50 GMT

> Is it possible that these errors are showing up in the conflict table?
>
[quoted text clipped - 11 lines]
> > if we have the Publication configured correctly. And if we are might
> > some scheduled jobs.

Nope, no conflicts. I wish! I've opened a support ticket with
Microsoft and will post the results.

Reply to this Message

jheaphy - 27 Aug 2008 17:10 GMT

> > Is it possible that these errors are showing up in the conflict table?
>
[quoted text clipped - 18 lines]
> Nope, no conflicts. I wish! I've opened a support ticket with
> Microsoft and will post the results.

The problem was on the IIS server. We had to apply SQL2005 SP2 to
upgrade the Sql Client Tools on the IIS server. Then we had to apply
the latest hot-fix bundle to the IIS server:
Yukon_SP2_CU6/09.00.3228.00

Reply to this Message