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.

I am doing sync from iPad (ULDB file) to Mobilink server. The ml_remote_id I have set in the client side is a integer (e.g : 888), but in the Mobilink log it is being recorded as "a9219090-6ab8-122b-8000-c82a14000858". What could be the reason. Any idea?

asked 19 Mar '12, 12:31

Bose's gravatar image

accept rate: 0%

edited 19 Mar '12, 15:17

Justin%20Willey's gravatar image

Justin Willey

Could you please post the MobiLink server log file (please remove all sensitive data before post it)?

(19 Mar '12, 13:52) Yufei Guo

Just curious - why do you want to use a non-default remote id?

If it is for implementing a download subset, it would be better to use the MobiLink user ID or an authentication parameter.

(19 Mar '12, 17:46) Graham Hurst

I would expect that you are likely setting the database option 'global_database_id' to '888', not 'ml_remote_id' - these are separate concepts/database options.

There is the database property 'global_database_id', which must accept an integer value. This value is used to determine the partitioning for a GLOBAL AUTOINCREMENT value (e.g. which range of values can be used for that particular remote).

The 'ml_remote_id' database option is instead used to uniquely identify a remote database in the MobiLink system - this is automatically set to a GUID value upon first synchronization if it has not been set previously. Notably, the 'ml_remote_id' value can take a string value (e.g. 'HR001'), not just integer values.

permanent link

answered 19 Mar '12, 13:58

Jeff%20Albion's gravatar image

Jeff Albion
accept rate: 25%

Try this:

-- Set the MobiLink remote ID: SET OPTION PUBLIC.ml_remote_id = 'Whatever you need it to be';

permanent link

answered 20 Mar '12, 05:30

Adiel's gravatar image

accept rate: 0%


...but take care of this warning, cited from here:


In most cases, you do not need to set the remote ID or know its value. However, in the event that you do need to change it, the safest time to change the remote ID is before the first synchronization. If you change it later, be sure you have performed a complete, successful synchronization just before changing the remote ID. Otherwise you may lose data and put your database into an inconsistent state.

(20 Mar '12, 06:51) Volker Barth
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: 19 Mar '12, 12:31

question was seen: 3,020 times

last updated: 20 Mar '12, 06:51