Search

Issue with 2 way in replication by Alexandre Tavares

Closed
as Not Reproducible Help for as Not Reproducible

0
1
Sign in
 to vote
Type: Bug
ID: 377555
Opened: 10/24/2008 6:13:25 AM
Access Restriction: Public
1
Workaround(s)
1
User(s) can reproduce this bug
Replication insn´t working fine.

Dear Alexandre,

Thank you for the update.

I understand how urgent the case. We are still communicating with our
development team and didn't get a clear alternative method to make
replication that you want to designed. Please rest assured we will try our
best to help you to work on the case.

Besides the above info, if you have any feedback or wishes on SQL Server, I
encourage you submit via the link below and our product team would like to
hear your voice:

http://connect.microsoft.com/SqlServer/Feedback

Thank you for your patience!

Best Regards,

Robbie Meng
Microsoft Online Partner Support
Details (expand)
Product Language
English

Version

SQL Server 2005 SP2 - Standard Edition

Category

Replication

Operating System

Win2003 Enterprise Server (SP2)
Operating System Language
English
Steps to Reproduce
I am using transactional replication.

Notes:


1- The TABLE_SALES and TABLE_SALES_TEMP have the same structure and fields in all servers (MATRIZ, FILIAL01 and FILIA02;

2- The user application only insert values in TABLE_SALES in FILIAL02 server;

3-In server MATRIZ, the table TABLE_SALES have a trigger that insert the same row in table TABLE_SALES_TEMP from TABLE_SALES that was inserted;

My Issue:
1 - When the user application insert a row in table TABLE_SALES in FILIAL02 server, this row is replicated to table TABLE_SALES in MATRIZ server;

2 – The trigger in table TABLE_SALES in MATRIZ SERVER, insert a row in table TABLE_SALES_TEMP in MATRIZ server ;

3 – The replication for my table TABLE_SALES_TEMP in MATRIZ server repplicated this row to FILIAL01 server , but no replicated to my table TABLE_SALES_TEMP in FILIAL02 server.
Actual Results
Not replicate value from table TABLE_SALES_TEMP in MATRIZ server to TABLE_SALES_TEMP table in FILIAL02 server, but replicate to my table TABLE_SALES_TEMP in FILIAL01 server.
Expected Results
I want that replication replicate to my two servers FILIAL01 and FILIAL02.

If you need, i have a pdf visio with this environment.

Platform

32
File Attachments
File Name Submitted By Submitted On File Size  
Replication Diagram.pdf (restricted) Alexandre Tavares 10/24/2008 -
Sign in to post a comment.
Posted by Microsoft on 1/4/2012 at 5:49 PM
Hi Alexandre ,

I am cleaning up very old issues which have been inactive for many years.
Please reopen a new one if the issue is still relevant to you and share updated information. I'm following up on new entries on a regular basis.

Thanks for taking the time to share your feedback, this is really important to us.


Best regards
Jean-Yves Devant
Program Manager (Replication/CDC/CT)
SQL Server Engine Team
Posted by Microsoft on 1/12/2009 at 4:27 PM
Dear Alexandre,
Thanks for reporting this issue thru the Microsoft connect program. I need some additional information for me to better diagnose what might be a problem in your particular environment. First, let me make sure I have the scenario defined correctly.
•    Tran replication setup between FILIAL02 -> MATRIZ for table TABLE_SALES
•    Trigger at MATRIZ on TABLE_SALES inserts changes into TABLE_SALES_TEMP
•    Tran replication setup between MATRIZ -> FILIAL01 and MATRIZ - > FILIAL02 for TABLE_SALES_TEMP

Problem: not seeing changes in TABLE_SALES_TEMP on FILIAL02

Based on what you have told me so far replication is working fine to TABLE_SALES_TEMP on FILIAL01 so we know the changes are being harvested from the log on MATRIZ and placed in the distribution database. We also know the distribution of changes is happening for FILIAL01 which means the distribution agent is running for this subscription. We need to focus on the distribution agent for FILIAL02 subscription. First thing is to verify the distribution agent is being started (verify in distribution history table at the distributor). If it is running/started, see if there are any errors in the distribution history for this subscription. You can do this by running the distrib.exe from the command line or look at the distribution history for this subscription (if you run from command line turn -historyverboselevel 2). If you’re not finding anything from this exercise, try reinit’ing the FILIAL02 subscription and watch it proceed thru the various stages (remember to rerun the snapshot agent if immediate sync is not turned on) to see any of the initialization steps are failing. Once you gather this information please post back your findings in hopes of finding a resolution to your issue.

Thanks.
-mike
Sign in to post a workaround.
Posted by agentritter on 6/2/2010 at 2:59 PM
SQL Server 2008 has a different definition of loopback detection. In SS2000, the same table would need to be replicated bidirectionally in order to be protected from a replicated loopback. In SS2008, the result of a replicated transaction cannot replicate back to the originating publisher no matter what tables are affected by the result.

To get around this problem I have to explicitly set @loopback_detection = 'false' in the call to sp_addsubscription. Keep in mind that @loopback_detection = 'true' is the default argument in SS2008.

© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement