Activity overview
Latest activity by JonBoy
Cannot sync table - violation of primary key constraint
I'm having problems sync'ing a table. When attempting to do a synch, data compare displays "Violation of primary key constraint. Cannot insert duplicate key into object tableblahblah.
In the projec...
Our boxes are not exactly the same. Mine is a Dell OptiPlex 745. The PC has a Radeon X1550 video card. When a data compare is running, I'm not having any refresh or drawing issues - so I'm not sure how that would cause Data Compare to bomb out? / comments
Our boxes are not exactly the same. Mine is a Dell OptiPlex 745. The PC has a Radeon X1550 video card. When a data compare is running, I'm not having any refresh or drawing issues - so I'm not sure...
Do you still have this as an open issue? / comments
Do you still have this as an open issue?
No love on this issue? :shock: / comments
No love on this issue? :shock:
I've been doing data syncs on various tables where the different row counts are > 1 million rows.
For testing purposes, I did a couple smaller tables where the estimated remaining time is < 1 minute and the issue still occurs by moving the status window.
Log doesn't log anything with the sync is halted (in verbose mode). 08:35:59.301|Info |SQL Compare Engine |1 |Start SaveToDisk: C:\Documents and Settings\JC\Local Settings\Temp\Red Gate\SC_Clone_67c5802f-1eba-4f12-b847-7daf9b16500d.tmp
08:35:59.332|Info |SQL Compare Engine |1 |Finish SaveToDisk: C:\Documents and Settings\JC\Local Settings\Temp\Red Gate\SC_Clone_67c5802f-1eba-4f12-b847-7daf9b16500d.tmp
08:35:59.379|Info |SQL Compare Engine |1 |Start SaveToDisk: C:\Documents and Settings\JC\Local Settings\Temp\Red Gate\SC_Clone_c1fbf058-56a7-47c7-809d-67eff7ea0d90.tmp
08:35:59.410|Info |SQL Compare Engine |1 |Finish SaveToDisk: C:\Documents and Settings\JC\Local Settings\Temp\Red Gate\SC_Clone_c1fbf058-56a7-47c7-809d-67eff7ea0d90.tmp
/ comments
I've been doing data syncs on various tables where the different row counts are > 1 million rows.
For testing purposes, I did a couple smaller tables where the estimated remaining time is < 1 minut...
I first noticed this bug on version 8.1.0.4. Downloaded and updated to 9.0.0.117 yesterday. Enabled verbose logging. Did a couple tests and examined the log afterwards, but nothing was written to it of note. I'll do a couple more tests in the morning. The issue will also occur if a large data sync is occuring, I'm working on another app and put focus back on redgate to see what the status is; it will 50% of the time stop this way (vs dragging the window which stops 100% of the time).
Had another co-worker test this issue on his box (WinXP x86, DataCompare version 8.1.0.4). Same thing. As soon as the data sync occurs, he dragged the window and the sync stopped with the error reported above.
All of our dev systems are running dual monitors. Have no idea if that's what's causing this issue, just throwing it out there.
Sucks when it stops with a large data sync since it has to be restarted. / comments
I first noticed this bug on version 8.1.0.4. Downloaded and updated to 9.0.0.117 yesterday. Enabled verbose logging. Did a couple tests and examined the log afterwards, but nothing was written to ...
Using WinXP x64. Everything is updated. I can verify consistently if you want to do a remote session. / comments
Using WinXP x64. Everything is updated. I can verify consistently if you want to do a remote session.
Data Compare will halt while synchronizing data
Data Compare stops while synchronizing data. Easily reproducible 100% of the time.
Start a data compare between 2 databases with tables that have differences. Wait for Data Compare to generate the ...