Tables not always replicating

[Patrick Johnson]

Hello,

I'm not sure where to start with this. I have 3 MSSQL servers. Server
A publishes a database to B and C. The publication is set up as
transactional, immediate updating with queued failover. There is a
'push' subscription from A to B and C. MSSQL 2K SP3. Win2K.

This has been working perfectly for several months.

Recently I tried to add a column to one of the tables using
filter-columns dialog on subscription properties. Wouldn't work without
calling sp_repladdcolumn manually with force_reinit_subscription set.
Reinitialized subscriptions. Had to change snapshot settings on several
articles to "delete all" to avoid constraint violations I was getting
with DROP setting.

Reinitialized subscriptions. Generated snapshot. All systems go so far.

Now I have a problem where SOME of the tables do not replicate inserts
SOME of the time ?!? No errors in any log files, no visible signs of
problems, except some inserts do not make it. Other inserts do make
it, and I get constraint violations because of the ones that did not
make it. But sometimes they DO make it. AAARRRRRGGGHHHH.

Much of the updating is being done through a JDBC app using jTDS 0.8
rc1, if that matters. No JDBC errors.

Can anyone suggest a good way to start debugging this beast ???

Thanks,
Patrick

pjohnson_mssql at
technoscope
dot
com