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,

I have a script version 4.5 and upgraded my remote database and publication to 4.6.

From the upgrade 4.5 to 4.6 only 1 table has changed. 2 Columns have been added and there now are 22 instead of 20.

Now, sometimes, only sometimes a client cannot synchronize after an upgrade getting the error message 10047.... I can see the correct script version being used in the logging. also the remote is sending 22 parameters but there are only 20 parameters expected (even though the correct updated script version is being used)...

I suspect some sort of caching issue... anyone seen anything like this before?

PS. Where can I find the latest patch of mobilink 12?

Thanks !

asked 29 Sep '16, 10:22

vdcey's gravatar image

vdcey
674293441
accept rate: 33%


If this problem persists across a MobiLink server restart (all ML servers if you have multiple running in parallel) ... Then the most likely cause is that some of your remotes are requesting a ScriptVersion different from their schema version; still.

Another reason for this could be unsynchronized log records from before you changed the remote's schema. This would usually be due to incorrectly upgrading the schema at those remote sites. Depending upon how you did that and whether or not you used START/STOP Synchronization Schema Change statements; and if not you may have not fully synchronized all of the older operations before changing the schema.

Someone might need a more verbose ML server log and a history on how you performed these schema changes to help you out if rebooting all of ML servers does not correct for this and your investigation does not show the reason for this error.

permanent link

answered 29 Sep '16, 11:55

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 32%

converted 30 Sep '16, 05:54

Volker%20Barth's gravatar image

Volker Barth
40.2k361550822

Just tested and you are right, There was no forced synchronization just before upgrading the remote database and this was causing the problems. Answer and I'll accept ... Thanks a bunch !

(30 Sep '16, 05:18) vdcey
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: 29 Sep '16, 10:22

question was seen: 1,161 times

last updated: 30 Sep '16, 05:18