on 2013 Sep 16 12:50 PM
As a followup question for this problem:
Is there a way to resend the missing/failed rows to the remote database(s)?
I. 2013-09-03 09:03:00. INSERT INTO DBA.CardEntries(CardEntries,ClientCard,CreationDate,Amount, REMOTENAME,Salesperson,EntryProcessed,BatchID) VALUES ('O000CB','J001UW','12:26:15.446918 2013/08/30',169,'SiteTest1','Sil Sch.r',0,NULL) E. 2013-09-03 09:03:00. SQL-Anweisung fehlgeschlagen: (-131) Syntaxfehler bei 'Sil Sch.,0,NULL)' in Zeile 3 E. 2013-09-03 09:03:00. Wird übersprungen: E. 2013-09-03 09:03:00. INSERT INTO DBA.CardEntries(CardEntries,ClientCard,CreationDate,Amount, REMOTENAME,Salesperson,EntryProcessed,BatchID) VALUES ('O000CB','J001UW','12:26:15.446918 2013/08/30',169,'SiteTest1','Sil Sch.r',0,NULL)
A remote reset did not clear up things as I have expected, but instead fails with this error on the remote:
I. 2013-09-16 17:16:00. DELETE FROM DBA.Salesperson I. 2013-09-16 17:16:01. DELETE FROM DBA.StartIDS E. 2013-09-16 17:16:01. SQL-Anweisung fehlgeschlagen: (-20000) RAISERROR ausgef.hrt: Cannot delete parent StartIDS if children still exist in CardEntri E. 2013-09-16 17:16:01. Wird übersprungen: E. 2013-09-16 17:16:01. DELETE FROM DBA.StartIDS I. 2013-09-16 17:16:01. DELETE FROM DBA.GROUPSPERADDRESS I. 2013-09-16 17:16:01. DELETE FROM DBA.GlobVars I. 2013-09-16 17:16:01. DELETE FROM DBA.GD I. 2013-09-16 17:16:01. DELETE FROM DBA.ClientCard I. 2013-09-16 17:17:33. DELETE FROM DBA.AddressGroups I. 2013-09-16 17:17:33. DELETE FROM DBA.ADDRESS I. 2013-09-16 17:17:39. DELETE FROM DBA.CardEntries I. 2013-09-16 17:17:39. SELECT Fullname FROM DBA.Salesperson I. 2013-09-16 17:17:39. 98 Zeilen synchronisiert I. 2013-09-16 17:17:39. SELECT REMOTENAME, STARTVALUE, Stammfiliale FROM DBA.StartIDS E. 2013-09-16 17:17:39. SQL-Anweisung fehlgeschlagen: (-193) Prim.rschl.ssel f.r Tabelle 'StartIDS' ist nicht eindeutig E. 2013-09-16 17:18:34. Empfang von Nachrichten fehlgeschlagen I. 2013-09-16 17:18:34. Ausführung abgeschlossen
In case the missing rows don't have according child records, you might be fine to delete them in the cons and insert them back again.
The delete will be an no-op in the remotes where the insert have been skipped.
If the RI relationship is more difficult, and there are dependent rows that are also missing, it's harder to give advice.
FWIW, you can also try to use PASSTHROUGH ONLY mode to sent statements to remotes outside of the usual replication logic.
I surely have to note that I would always test "data fixes" like these thorougly in a test environment...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
70 | |
10 | |
9 | |
6 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.