The forum is currently being migrated to a new host. While the migration happens, the old server is still available. Once the new machine is ready, I will copy the database to the new machine. Feel free to ask and answer questions in the meantime.

Hi,

What is the reason why we are encountering the following error on remote

E. 2012-08-31 18:09:22. Invalid articles on table 719 at offset 0071898135
E. 2012-08-31 18:09:22. Log operation at offset 0071898135 has bad data at offset 0071898139

After this , remote unable to sync.

how can we fix this error in order to resume the sync.

Regards, vhm

asked 31 Aug '12, 06:16

vhm's gravatar image

vhm
210131320
accept rate: 0%

edited 31 Aug '12, 08:03

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.0k340108


This error is a symptom of a corrupt transaction log. We can get you to synchronize again, but we might need to skip uploading the data between offset 71898135 and the current log offset.

1) Can you run dbtran against the transaction log that contains offset 71898135, possibly using the -ir switch to scan up to the bad offset and then a second run of dbtran to translate operations after the bad offset? If you can see the operations in the log after the bad offset, you will need to manually add these operations to the consolidated database (if you want). If you can't run dbtran at all, and the operations in the transaction log after offset 71898135 are critical, you will need to contact technical support to see if your corrupted transaction log can be repaired.

2) Rename and restart the active transaction log

3) Drop and re-add the synchronization subscriptions in your remote database. You can dbunload -n on the remote database to generate a reload.sql file if you're not sure what the exact CREATE SYNCHRONIZATION SUBSCRIPTION command is.

4) The next time you run dbmlsync it will start scanning at whatever the current log offset was when you dropped and recreated the synchronization subscriptions, which will be past offset 71898135.

permanent link

answered 31 Aug '12, 08:37

Reg%20Domaratzki's gravatar image

Reg Domaratzki
7.0k340108
accept rate: 38%

edited 31 Aug '12, 08:39

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×361

question asked: 31 Aug '12, 06:16

question was seen: 1,438 times

last updated: 31 Aug '12, 08:39