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.

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?

Thanks.

asked 09 Mar '12, 11:13

jimboidaho's gravatar image

jimboidaho
111141422
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
401213
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

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: 09 Mar '12, 11:13

question was seen: 2,650 times

last updated: 09 Mar '12, 12:31