Mobilink last download time (12.0.1.3797)

[eric_verhorstert]

To get the last time the user downloads data from the consolidated I looked in table ml_subscription.

I thought the column "last_download_time" would give me the time I would also see in the Mobilink console.

In the Mobilink console I see:

I. 2014-03-04 15:09:00. <2813> Request from "Dbmlsync 12.0.1.3797" for: remote ID: d6d30c51-4817-413a-af96-69c346c4a7fe, user name: 199999, version: victor1

I. 2014-03-04 15:14:34. <2813> Synchronization complete

In ml_subscription I see:

909,2,90,0,download,1900-01-01 00:00:00.000,2014-02-19 10:10:57.734,90,199999,(NULL)

I checked in ml_database and noticed that remote_id remote ID: d6d30c51-4817-413a-af96-69c346c4a7fe is rid 909.

Should I look at a other place to get the latest download time?

Thanks

Eric

[jeff_albion · Accepted solution]

Hi Eric,

The 'last_download_time' is the time that the remote last uploaded during its synchronization, not the current 'last download' time that the remote is storing.

Here's what you should see in the console log, with enough log verbosity - this is for a remote that has never synchronized:

I. 2014-03-04 12:37:46. <1> Request from "Dbmlsync 16.0.1726" for: remote ID: fe79c3d1-5a1a-494f-8475-646f3cbffb8a, user name: rem1, version: v1
...
I. 2014-03-04 12:37:46. <1> Publication #1: p1, subscription id: 2, last download time: 1900-01-01 00:00:00.000000
...
I. 2014-03-04 12:37:46. <1> Sending the download to the remote database
...
I. 2014-03-04 12:37:46. <1> Synchronization complete

When you issue: select * from ml_subscription

rid,subscription_id,user_id,progress,publication_name,last_upload_time,last_download_time
1,'2',1,5881,'p1','2014-03-04 12:37:46.284','1900-01-01 00:00:00.000'

The 'last_upload_time' will be the closest value to the current 'last_download' value for the remote, but only the remote will know the true value.

Should I look at a other place to get the latest download time?

Yes, by default, the remote database in the SYS.SYSSYNC system view. Only the remote can "confirm" the current download time - if the download was interrupted during the send phase, the 'current' download timestamp at the remote is thrown away and the older timestamp value is reused once again. You only know that the value is 'good' once the remote has committed the last download stream and comes in to the MobiLink synchronization server to confirm the last download value with another upload synchronization attempt.

If you wish to see this information at the MobiLink server instead, you will need to enable Download Acknowledgements to receive the information about the download success (last download time) sooner at the MobiLink server than the next synchronization attempt by the remote. With Download Acknowledgements enabled (e.g. dbmlsync -e "sa=on") , I instead see the following information at the consolidated after the new remote comes into synchronize only once and successfully downloads the download stream:

rid,subscription_id,user_id,progress,publication_name,last_upload_time,last_download_time
1,'2',1,5881,'p1','2014-03-04 12:54:24.260','2014-03-04 12:54:24.263'

Regards,

Jeff Albion

SAP Active Global Support