September 10, 2004 at 6:50 pm
(2 SQL Servers 2K with sp3a) Has anybody seen the following situation?
I have a table setup for Transactional Replication. It has 11 columns. However, sometimes after a while, data from Column 5 in the Table on the Publisher ends up in Column 4 on the Subscriber. And Column 5 on the subscriber is "". Columns 1-3 and 6-11 are correct on both servers. This doesn't happen for all records...I start the initial snapshot and everything runs for hours/days...and then it starts happening. I have seen this twice now on the same set of 2 servers in the last week. I have this same table replicated between 2 other servers and I have never seen this problem.
Anyone have any ideas?
Mike
September 10, 2004 at 11:11 pm
I don't know what the problem is but my next step would be to run a trace.
Good luck.
Everett Wilson
ewilson10@yahoo.com
September 13, 2004 at 11:20 am
I thought of that as well. I ran a trace on the Source server (Publisher) and the Destination server (Subscriber). The trace on the Subscriber shows the sp_MINS_XXX calls being made with the data in the wrong columns. The trace on the Publisher shows the initiating INSERT statement and everything is correct and ends up in the Publisher table correct as well. Not sure if you can see the actual Replication DDS statements on the Publisher.
Any other suggestions?
Mike
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply