Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

In the update process the remote db has the log offset reset. I am getting this error "Subscription id 6: consolidated progress 43303783 and remote progress 43300426" which makes sense because the offset was changed. Just wondering the best way to fix this?


asked 09 Mar '12, 11:13

jimboidaho's gravatar image

accept rate: 0%

Please use the procedures to upgrade a remote database that is involved in sync/replication. Please read the following section in the doc: SQL Anywhere 12 - Changes and Upgrading » Upgrading to SQL Anywhere 12 » Upgrading MobiLink » Upgrading SQL Anywhere MobiLink clients

permanent link

answered 09 Mar '12, 11:26

Yufei%20Guo's gravatar image

Yufei Guo
accept rate: 6%

I am upgrading to 11. I have been using the 11 docs but I haven't seen an answer to this one yet.

(09 Mar '12, 11:30) jimboidaho

Sorry, I did not pay much attention to the version. Here is the 11 doc: SQL Anywhere 11 - Changes and Upgrading » Upgrading to SQL Anywhere 11 » Upgrading MobiLink » Upgrading SQL Anywhere MobiLink clients

(09 Mar '12, 11:33) Yufei Guo
Replies hidden

I read the docs again and I can't find anything about how to fix the offset difference between the remote and the consolidated.

(09 Mar '12, 11:38) jimboidaho

It did not tell you how to fix the offset mismatch. However, it does tell you how to upgrade a remote database and then how to zap the log offset after you upgraded the remote database.

(09 Mar '12, 11:45) Yufei Guo

I converted another remote and the offset matched. Not sure what I did the first time. Just in case someone else is reading this, dbunload -ar switch resets the log offset automatically so I could skip that part of the docs. Thanks everyone.

(09 Mar '12, 12:31) jimboidaho
showing 5 of 6 show all flat view
Your answer
toggle preview

Follow this question

By Email:

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



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "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:


question asked: 09 Mar '12, 11:13

question was seen: 2,757 times

last updated: 09 Mar '12, 12:31