ml_remote_id Format

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?

log-file mobilink

asked 19 Mar '12, 12:31

Bose
31●5●5●7
accept rate: 0%

edited 19 Mar '12, 15:17

Justin Willey
7.6k●137●179●249

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

flat view

2 Answers:

active answers oldest answers newest answers popular answers

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 Albion
10.8k●1●71●175
accept rate: 25%

flat view

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
1●3●3●5
accept rate: 0%

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

Caution

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

flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

mobilink ×371
log-file ×48

question asked: 19 Mar '12, 12:31

question was seen: 2,992 times

last updated: 20 Mar '12, 06:51

SAP SQL Anywhere

ml_remote_id Format

Follow this question

Related questions