Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Question Unanswered: ASE - ASE Replication (SQLRemote)

    hello,

    could You please help me with such errors?

    out ssremote:
    E. 10/13 11:33:28. Internal error: transaction log corrupted
    E. 10/13 11:33:28. Internal error: transaction log corrupted
    E. 10/13 11:33:28. Internal error: transaction log corrupted

    in ssremote:
    E. 10/11 07:59:56. hq_user: Error 2601: Attempt to insert duplicate key row in object 'Wplata' with unique index 'PK_WPLATA'

    E. 10/11 07:59:56. hq_user: Error 3621: Command has been aborted.

    E. 10/11 07:59:56. hq_user: INSERT INTO Wplata(Odbiorca,RodzajDokumentu,DataWystawienia,Nu mer,Jo,Paczka, Konto,Kwota,DoRozksiegowania,Opis,LpKasa,NumerKasa ,PkNumer,PkData,
    PkOdbiorca,idWplata) VALUES ('0100159','BP','2004-10-07 00:00:00:000','310/B/CITY/256/1/04/623',4,'310/B/CITY/256/04','130-10',121.74,121.74,'8091010015910050012187OWCZARSKA WAC LAWA',NULL,NULL,NULL,NULL,NULL,6132299)

    I have lot of such errors
    But rest of replication works. It is only problem with few tables!! And with not every rows!!!!Some of them are replicated successful!!!

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    You seem to have tried this over and over again resulting in duplicates on the replicate. Your best bet is to select from the replicate for the pk it is complaining about and then delete that record on the replicate and run ssremote again.

    I have no idea why the transaction log is corrupt.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •