SQL Anywhere Mobile - how to reset sync from an log offset?

Author

how to reset sync from an log offset?

vsv

2005-08-23, 1:24 pm

Table 'emp' has been altered outside of synchronization at log offset
0009955670.
Upload aborted at offset 0009955641

I altered the table in the synchronization by removing it in the
publication. altered table. added to synchronization.
Is there a way to force download to reset after an log offset say
0009955670.
I know the risk that I might lose all the changes done in the remote prior
to this offset.
But how to do in mobilink?

thanks
vsv

David Fishburn

2005-08-27, 1:23 pm

"vsv" <nospam@nospam.com> wrote in news:430b5a93$1@foru
ms-2-dub of
sybase.public.sqlanywhere.mobilink:

v> Table 'emp' has been altered outside of synchronization at log offset
v> 0009955670.
v> Upload aborted at offset 0009955641
v>
v> I altered the table in the synchronization by removing it in the
v> publication. altered table. added to synchronization.

Is this something you are going to do often?
You need to modify the tables using the sp_hook_dbmlsync_sch
ema_upgrade
to perform these changes. Then you will not have this problem.

v> Is there a way to force download to reset after an log offset say
v> 0009955670.
v> I know the risk that I might lose all the changes done in the remote
v> prior to this offset.

Once this has happened you must drop and recreate the sync subscription.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links