469,331 Members | 4,340 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,331 developers. It's quick & easy.

Tables not always replicating

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
Jul 20 '05 #1
0 1054

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Brian E. Seppanen | last post: by
1 post views Thread by missboom | last post: by
1 post views Thread by satish mullapudi | last post: by
7 posts views Thread by shapper | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.