Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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.7k343118


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.7k343118
accept rate: 37%

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:

×371

question asked: 31 Aug '12, 06:16

question was seen: 1,729 times

last updated: 31 Aug '12, 08:39