• anthony.green - Monday, September 25, 2017 5:39 AM

    aminbangash110 - Monday, September 25, 2017 5:33 AM

    why data is not actually synced. Basically replication was stop for example for 24 16:00 but it gives me that error for 25th date and i can see data of only 24 how can data be duplicated if it doesn't exist. This error happens when server is rebooted.

    You've not answered the first question, is this replication (Transaction / Merge / Snapshot) or is this SSIS extracting and loading data?

    If its actual proper replication look at the monitor and the sp_browsereplcmds, it will give you what is failing then you can fix it.

    If its SSIS, open the project, debug the package causing the problems.

    How can data be duplicated?  I don't know your code, your systems or your processes.  You will need to go and debug.  Something is violating the primary key for cdr_main, go find what that is and fix it, then move on to the next error.

    Replication monitor is not set there but we are replicating data via a job from primary server and our job failed with following error as i have provided above. how can i found the duplicate value as it didn't exist for 25. data is already replicated to 24.