SQL Anywhere Mobile - Mobilink server Protocol error

Author

Mobilink server Protocol error

Alex Naumenko

2005-11-17, 8:25 pm

Hi,

I have remote and consolidated databases, both ASA 9.0.2.3207, both with
identical structure.

On remote database I am adding record into MAILBOX table (and into 2
referenced tables), when synchronization starts I get the following error on
the consolidated server side and Mobilink shuts down.

I. 11/17 17:47:35. <1.5> [ml_remote_mvs]: begin_upload_rows MAILBOX (no
script)
E. 11/17 17:47:35. <1.5> [ml_remote_mvs]: Error: [-10001] Protocol error

Could you advise what it can be, or where to look, or what I need to post to
track down this problem?

My last command line settings for mobilink server are

-c dsn=UC20_SQLANY -x tcpip -za -zu+ -o d:\uc\logs\dbcom\ml_
server.log -v+

and for remote client

-c dsn=UC20_SQLANY -n pub_remote_2way -n pub_remote_upload

Thank you,
Alex.

Reg Domaratzki $iAnywhere Solutions$

2005-11-18, 1:24 pm

Do you get the protocol error every time you synch this remote? If you do,
I'd love to see the remote database and all associated transaction log files
needed to generate the upload stream. If you could package up the following
information and send it to me (direct e-mail is OK), that would be great :

1) The remote database and all old transaction log needed to synchronize the
remote
2) The exact command line used to start dbmlsync (userid/passwords needed!)
3) The exact command line used to start mobilink (userid/passwords not
needed)
4) The userid and password for a user with DBA authority on the remote
database
5) The version number of the remote database engine, dbmlsync executable,
consolidated database engine and MobiLink server

A protocol error is often an indication of a bug in our code, and the above
information should be enough for me to reproduce the problem here on my
machine.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"

"Alex Naumenko" <alexn@esna.com> wrote in message
news:437d1195$1@foru
ms-1-dub...
> Hi,
>
> I have remote and consolidated databases, both ASA 9.0.2.3207, both with
> identical structure.
>
> On remote database I am adding record into MAILBOX table (and into 2
> referenced tables), when synchronization starts I get the following error
on
> the consolidated server side and Mobilink shuts down.
>
> I. 11/17 17:47:35. <1.5> [ml_remote_mvs]: begin_upload_rows MAILBOX (no
> script)
> E. 11/17 17:47:35. <1.5> [ml_remote_mvs]: Error: [-10001] Protocol error
>
> Could you advise what it can be, or where to look, or what I need to post
to
> track down this problem?
>
> My last command line settings for mobilink server are
>
> -c dsn=UC20_SQLANY -x tcpip -za -zu+ -o d:\uc\logs\dbcom\ml_
server.log -v+
>
> and for remote client
>
> -c dsn=UC20_SQLANY -n pub_remote_2way -n pub_remote_upload
>
>
> Thank you,
> Alex.
>
>

Reg Domaratzki

2005-11-18, 8:24 pm

The row you are deleting from the MAILBOX table ( pkey = 214748361 ) has a
character column that contains an embedded NULL in it. NULLS are used to
mark the end of a character string in the MobiLink stream, so when you embed
a NULL character in a char or varchar column, it will corrupt the upload
stream, resulting in protocol errors and possibly a MobiLink crash. If you
need to embed NULL characters into a character string, you'll need to chage
the data type of the column to binary.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Certified SQL Anywhere Associate
Please reply only to the newsgroup

ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL and click "GO"

"Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
wrote in message news:437e1128$1@foru
ms-2-dub...
> Do you get the protocol error every time you synch this remote? If you
do,
> I'd love to see the remote database and all associated transaction log
files

> needed to generate the upload stream. If you could package up the
following
> information and send it to me (direct e-mail is OK), that would be great :
>
> 1) The remote database and all old transaction log needed to synchronize
the
> remote
> 2) The exact command line used to start dbmlsync (userid/passwords
needed!)
> 3) The exact command line used to start mobilink (userid/passwords not
> needed)
> 4) The userid and password for a user with DBA authority on the remote
> database
> 5) The version number of the remote database engine, dbmlsync executable,
> consolidated database engine and MobiLink server
>
> A protocol error is often an indication of a bug in our code, and the
above

> information should be enough for me to reproduce the problem here on my
> machine.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Sybase Certified Professional - Sybase ASA Developer Version 8
> Please reply only to the newsgroup
>
> iAnywhere Developer Community : http://www.ianywhere.com/developer
> iAnywhere Documentation :
http://www.ianywhere.com/developer/product_manuals
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set filter to "Display ALL platforms IN ALL MONTHS"
>
>
> "Alex Naumenko" <alexn@esna.com> wrote in message
> news:437d1195$1@foru
ms-1-dub...
error[color=darkred]

> on
post[color=darkred]
> to
d:\uc\logs\dbcom\ml_
server.log -v+[color=darkred]
>
>

Greg Fenton

2005-11-18, 8:24 pm

Reg Domaratzki wrote:
> NULLS are used to
> mark the end of a character string in the MobiLink stream, so when you embed
> a NULL character in a char or varchar column, it will corrupt the upload
> stream, resulting in protocol errors and possibly a MobiLink crash.
>

Note (for future newsgroup searchers) that I believe the issue of
embedded NULs (\0) in character fields has been addressed in the
upcoming Jasper (ML 10.0) release.

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

Alex Naumenko

2005-11-22, 8:24 pm

Thanks, Reg

I guess it is because I have several fields in this table encrypted (in
BEFORE Trigger with ENCRYPT function), but these fields are of type varchar
now.
So, you think it will work if I will change it to binary? Should I decrypt
the data before sending upload stream, or I should just skip trigger on
consolidated database to not encrypt data twice?

Thank you,
Alex.

"Reg Domaratzki" <nospam.please@sympatico.ca> wrote in message
news:437e5066$1@foru
ms-1-dub...
> The row you are deleting from the MAILBOX table ( pkey = 214748361 ) has a
> character column that contains an embedded NULL in it. NULLS are used to
> mark the end of a character string in the MobiLink stream, so when you
> embed
> a NULL character in a char or varchar column, it will corrupt the upload
> stream, resulting in protocol errors and possibly a MobiLink crash. If
> you
> need to embed NULL characters into a character string, you'll need to
> chage
> the data type of the column to binary.
>
> --
> Reg Domaratzki, Sybase iAnywhere Solutions
> Certified SQL Anywhere Associate
> Please reply only to the newsgroup
>
> ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
> -> Choose SQL Anywhere Studio
> -> Set "Platform Preview" and "Time Frame" to ALL and click "GO"
>
>
> "Reg Domaratzki (iAnywhere Solutions)" <FirstName.LastName@ianywhere.com>
> wrote in message news:437e1128$1@foru
ms-2-dub...
> do,
> files
> following
> the
> needed!)
> above
> http://www.ianywhere.com/developer/product_manuals
> error
> post
> d:\uc\logs\dbcom\ml_
server.log -v+
>
>

Reg Domaratzki

2005-11-22, 8:24 pm

I would suggest that you store encrypted information in a binary column on
the remote (and consolidated). That way, there is never an un-encrypted
veriosn of your data stored on disk or placed in the upload stream.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Certified SQL Anywhere Associate
Please reply only to the newsgroup

ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL and click "GO"

"Alex Naumenko" <alexn@esna.com> wrote in message
news:43837e0e$1@foru
ms-1-dub...
> Thanks, Reg
>
> I guess it is because I have several fields in this table encrypted (in
> BEFORE Trigger with ENCRYPT function), but these fields are of type
varchar
> now.
> So, you think it will work if I will change it to binary? Should I decrypt
> the data before sending upload stream, or I should just skip trigger on
> consolidated database to not encrypt data twice?
>
> Thank you,
> Alex.
>
>
> "Reg Domaratzki" <nospam.please@sympatico.ca> wrote in message
> news:437e5066$1@foru
ms-1-dub...
a[color=darkred]
to[color=darkred]
<FirstName.LastName@ianywhere.com>[color=darkred]
you[color=darkred]
great[color=darkred]

synchronize[color=da
rkred]
executable,[color=da
rkred]
(no[color=darkred]
>
>

Sponsored Links