SQL Anywhere Mobile - Sync occuring twice

Author

Sync occuring twice - Urgent

chandhu

2005-04-15, 9:24 am

Hi,

We are using Sybase 8.0.2.4511 and Mobilink Synchronization. Using pocket pc
with sybase 8.0.2.4505 we are synching to main server.
Our problem is, while trying to upload bunch of data, synchronization is
automatically occuring twice.

It is starting the synchronization and says completed. Then automatically
again starts and completes the synchronization.

We are calling the dbmlsync as following:

lngRetVal = CeCreateProcess("\Program Files\Sybase\ASA\dbm
lsync.exe", "-c
"" uid=xx;pwd=xxxx;dbf=
\Program Files\Test\Test.db"" -pd dbsock8.dll -k -ot
""\Program files\Test\dbmlsync.txt"" -vcnosu -x -e ""sa=ON"" -e
""sv=version1"" -n version1", 0, 0, 0, 0, 0, 0, 0, 0)

Thanks.

Chandhu.

Greg Fenton

2005-04-15, 8:24 pm

chandhu wrote:
>
> It is starting the synchronization and says completed. Then automatically
> again starts and completes the synchronization.
>

Take a look at the log file \Program files\Test\dbmlsync.txt on the
remote to see if there are any messages as to why it is restarting.

The main cause of this is that your application modifies a row *after*
the upload of the current synchronization session begins and an update
for that row is *downloaded*. Dbmlsync recognizes that you might be
about to lose the remote's change (the one that occured after synch
started), so it aborts the download and performs a new upload (it likely
will only upload a few rows...possibly just the one offending row,
because the previous upload was successful).

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Chandhu

2005-04-18, 9:24 am

Hi,

Thanks for the reply.

> Take a look at the log file \Program files\Test\dbmlsync.txt on the
> remote to see if there are any messages as to why it is restarting.

Log file is showing the Sync is starting twice but it is not giving any
Error message.

> The main cause of this is that your application modifies a row *after*
> the upload of the current synchronization session begins and an update
> for that row is *downloaded*. Dbmlsync recognizes that you might be
> about to lose the remote's change (the one that occured after synch
> started), so it aborts the download and performs a new upload (it likely
> will only upload a few rows...possibly just the one offending row,
> because the previous upload was successful).
>

Can we trace out where this "modifies a row *after* the upload of the
current synchronization session begins ". I ran the dbmlsrv8 with -vcnrs
option. It is also showing the message without error/warning.

Thanks.

Chandhu.

Greg Fenton

2005-04-19, 8:24 pm

Chandhu wrote:
>
> Can we trace out where this "modifies a row *after* the upload of the
> current synchronization session begins ". I ran the dbmlsrv8 with -vcnrs
> option. It is also showing the message without error/warning.
>

Try changing your "-vcnosu" option to "-v+". I cannot guarantee this
will do it, but it gives you full verbosity and might show the problem.

BTW: this is just my guess as to why the double-pump synchronization is
happening. It could be something else, but I can't think of what that
would be offhand.

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links