Missing Transactions

SQL 2k & Win 2k
I have a server(S1) that has a trans. publication of 4 tables. I have
another server (S2) that has a subscription to the publication on S1. This
works fine.
Now, S2 has a merge publication of the same 4 tables to several remote
locations. I have a filter in the publication on each of the the four tables
that filters on a numeric field (ex. loc = 19). If I reinitialize the
subscription, only the data that meets the filter clause is populated on the
subscriber.
SO here is the problem....When data is inserted into S1, it makes it to S2,
but not to the remote locations.
If I do a validation, on S2, I get the error... Article 'TableName' failed
data validation (rowcount only) this message appears for each table.
If I insert a row manually into one of the tables on S1 & run the
distribution & merge agents manually, the row makes it to the final
destination, well on the one test I did.
TIA,
Larry...
Is there anything logged in your conflict tables? Use the conflict viewer to
tell.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:6EB8F35D-7D55-468D-AEBB-5209D1A406F5@.microsoft.com...
> SQL 2k & Win 2k
> I have a server(S1) that has a trans. publication of 4 tables. I have
> another server (S2) that has a subscription to the publication on S1.
> This
> works fine.
> Now, S2 has a merge publication of the same 4 tables to several remote
> locations. I have a filter in the publication on each of the the four
> tables
> that filters on a numeric field (ex. loc = 19). If I reinitialize the
> subscription, only the data that meets the filter clause is populated on
> the
> subscriber.
> SO here is the problem....When data is inserted into S1, it makes it to
> S2,
> but not to the remote locations.
> If I do a validation, on S2, I get the error... Article 'TableName' failed
> data validation (rowcount only) this message appears for each table.
> If I insert a row manually into one of the tables on S1 & run the
> distribution & merge agents manually, the row makes it to the final
> destination, well on the one test I did.
> TIA,
> Larry...
|||When I 'View Confilcts', there are <no confilict tables>.
Larry...
PS - got my book yesterday...thanks!
"Hilary Cotter" wrote:

> Is there anything logged in your conflict tables? Use the conflict viewer to
> tell.
|||Also, when I look at the 'Merge Agent History', there have been no
transactions replicated today, but I know there has been some data that has
been moved from S1 to S2.
|||I'm drawing a blank on this one. I'd contact PSS on this. Hope you enjoy the
book.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:7231045F-D1B7-4EF3-9FC1-8A6EF303065D@.microsoft.com...
> Also, when I look at the 'Merge Agent History', there have been no
> transactions replicated today, but I know there has been some data that
> has
> been moved from S1 to S2.
>