SQL Anywhere Mobile - Trying synching for the first time... help!

Author

Trying synching for the first time... help!

Mad Vlad

2005-11-15, 9:24 am

Hi all,

It is first time that I'm trying to attempt a synchronisation between two
databases on same machine. We have a 150-Mb large database, call it host.db.
I unload its structure only, and reload it into brand new remote.db. I
create a publication, a mobilink user, and a subscription with remote.db.

I start the mobilink server with

dbmlsrv9 -dl -vcrs -za -zu+ -x tcpip -c "DSN=Host" -o C:\DBs\MLserv.txt

I start the mobilink sync with

dbmlsync -c "DSN=Remote" -v -dl -e "SendColumnNames=ON"

With "SendColumnNames=ON" so that the host database could generate mobilink
scripts. When it comes to try the synchronisation for the first time, it
fails with "Message: ODBC: [Sybase][ODBC Driver][Adaptive Server
Anywhere]Syntax error near 'window' on line 1 (ODBC State = 42000, Native
error code = -131). Table Name: history"

I take it that means that it does not like the column name "window" in
several scripts. So I go through all scripts and put double quotes around
all calls on columns that are called with a WINDOW keyword.

I start the mobilink sync again, this time with no "SendColumnNames" this
time, as scripts are already generated.

The mobilink server window starts flashing like mad, looking like it's
getting ready to send the data for synchronisation (it looks like it is
unloading all the data- that is what its output window shows)

However, it is going on for about half an hour already, although it is 150
megabytes DB I think it should do it in much shorter time - I don't think
that it's working, and it looks like it's stuck in some sort of loop. Did I
do something wrong?

Thanks for any ideas

Mad Vlad

2005-11-15, 9:24 am

-- Update --

I just did it for one table of 30 rows only, and I did not include writing
log to the text file on disk - it worked - got done in 2 seconds!

I will try to sync the whole database again, but this time will not write to
log and will leave it for the whole afternoon... hopefully it will work.

"Mad Vlad" <vlad@NOSPAMpcr.ltd.uk> wrote in message
news:4379e704@forums
-1-dub...
> Hi all,
>
> It is first time that I'm trying to attempt a synchronisation between two
> databases on same machine. We have a 150-Mb large database, call it
> host.db. I unload its structure only, and reload it into brand new
> remote.db. I create a publication, a mobilink user, and a subscription
> with remote.db.
>
> I start the mobilink server with
>
> dbmlsrv9 -dl -vcrs -za -zu+ -x tcpip -c "DSN=Host" -o C:\DBs\MLserv.txt
>
> I start the mobilink sync with
>
> dbmlsync -c "DSN=Remote" -v -dl -e "SendColumnNames=ON"
>
> With "SendColumnNames=ON" so that the host database could generate
> mobilink scripts. When it comes to try the synchronisation for the first
> time, it fails with "Message: ODBC: [Sybase][ODBC Driver][Adaptive Server
> Anywhere]Syntax error near 'window' on line 1 (ODBC State = 42000, Native
> error code = -131). Table Name: history"
>
> I take it that means that it does not like the column name "window" in
> several scripts. So I go through all scripts and put double quotes around
> all calls on columns that are called with a WINDOW keyword.
>
> I start the mobilink sync again, this time with no "SendColumnNames" this
> time, as scripts are already generated.
>
> The mobilink server window starts flashing like mad, looking like it's
> getting ready to send the data for synchronisation (it looks like it is
> unloading all the data- that is what its output window shows)
>
> However, it is going on for about half an hour already, although it is 150
> megabytes DB I think it should do it in much shorter time - I don't think
> that it's working, and it looks like it's stuck in some sort of loop. Did
> I do something wrong?
>
> Thanks for any ideas
>
>

Breck Carter [TeamSybase]

2005-11-15, 9:24 am

On 15 Nov 2005 05:47:48 -0800, "Mad Vlad" <vlad@NOSPAMpcr.ltd.uk>
wrote:

>-vcrs

That option will put an *extreme* level of detail into the diagnostic
log. The offending letter is "r" which should be used only (a) when
syncing a few rows, and/or (b) when trying to debug a problem.

Here are a few suggestive lines from a template .BAT file...

REM -v cfhnprstu logs everything
REM -v cfhnpstu logs everything interesting except row values
REM -v cfnps suggested for production, high volume tests

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

David Fishburn

2005-11-15, 9:24 am

"Mad Vlad" <vlad@NOSPAMpcr.ltd.uk> wrote in news:4379e704@forums
-1-dub
of sybase.public.sqlanywhere.mobilink:

MV> dbmlsrv9 -dl -vcrs -za -zu+ -x tcpip -c "DSN=Host" -o
MV> C:\DBs\MLserv.txt

Avoid the -dl. That forces the GUI to be written to which slows down
ML massively.

If you are going to download 150 mb of data no sense using -vr which
will record all 150 mb of the data in the ML log. That coupled with the
-dl would be responsible for the speed.

--
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