SQL Anywhere Mobile - Protocol version mismatch

Author

Protocol version mismatch

Karl Kemp

2006-02-25, 9:50 am

Hi,

I'm trying to set up a sync using .NET scripts. All I have at this point is
an authenticate_user script that does nothing but set the authstatus to
1000. I have no articles in my publication on the remote database and no
download scripts defined on the consolidated side.

When I attempt to sync, sync fails with the error "Protocol version
mismatch" I'm running both dbmlsync and dbmlsrv9 on my local machine
interactively. They are both 9.0.2.3249.

My command to start dbmlsrv9 is
dbmlsrv9 -c " dsn=CheckboxConsolid
ated;uid=sa;pwd=****
" -dl -o
C:\Prezza\CheckboxSy
ncServer\MLLog.txt -v+ -sl
dnet(- MLAutoLoadPath=C:\Pr
ezza\CheckboxSyncSer
ver\Checkbox. Synchronization\bin\
Debug)
-zp

My command to start dbmlsync is: dbmlsync -c
" dbf=C:\Prezza\Checkb
oxMobile\Checkb
oxMobile\Database\Ch
eckboxMobile.db;uid=dba;pwd=****" -v+

The output from dbmlsync is as follows:

I. 02/24 16:33:01. Synchronization Started
I. 02/24 16:33:01. 1: -c
I. 02/24 16:33:01. 2:
********************
********************
********************
********************
******
I. 02/24 16:33:01. 3: -v+
I. 02/24 16:33:01. Adaptive Server Anywhere MobiLink Synchronization Version
9.0.2.3249
I. 02/24 16:33:01.
I. 02/24 16:33:01. Copyright © 1989-2004 Sybase, Inc.
Portions Copyright © 2002-2004, iAnywhere Solutions, Inc.
I. 02/24 16:33:01. All rights reserved. All unpublished rights reserved.
I. 02/24 16:33:01.
I. 02/24 16:33:01. This software contains confidential and trade secret
information of
I. 02/24 16:33:01. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 02/24 16:33:01. by the U.S. Government is subject to restrictions set
forth in a license
I. 02/24 16:33:01. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 02/24 16:33:01. other written agreement specifying the Government's
rights to use the
I. 02/24 16:33:01. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 02/24 16:33:01.
I. 02/24 16:33:01. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
94568, USA
I. 02/24 16:33:01.
I. 02/24 16:33:01. Connecting to remote database
I. 02/24 16:33:01. Loading synchronization information
I. 02/24 16:33:01. Options in database for subscription to
'CheckboxMobileFullS
ync' for '2CK5170916:peter':
I. 02/24 16:33:01. sv=CheckboxMobile1.0;
I. 02/24 16:33:01. Options in database for subscription to
'CheckboxMobileFullS
ync' for '2CK5170916:peter':
I. 02/24 16:33:01. sv=CheckboxMobile1.0;
I. 02/24 16:33:01. Options in database for subscription to
'CheckboxMobileFullS
ync' for '2CK5170916:peter':
I. 02/24 16:33:01. sv=CheckboxMobile1.0;
I. 02/24 16:33:01. Begin synchronizing 'CheckboxMobileFullS
ync' for MobiLink
user '2CK5170916:peter'
I. 02/24 16:33:01. Options for this synchronization:
I. 02/24 16:33:01. SV='CheckboxMobile1.0',CTP='TCPIP'
I. 02/24 16:33:01. Log scan starting at offset 0001867450
I. 02/24 16:33:01. Processing transaction logs from directory
" C:\Prezza\CheckboxMo
bile\CheckboxMobile\
Database\"
I. 02/24 16:33:01. Processing transactions from active transaction log
I. 02/24 16:33:01. Hovering at end of active log
I. 02/24 16:33:01. Connecting to MobiLink server at '' using 'dbmlsock9.dll'
I. 02/24 16:33:01. Uploading header
I. 02/24 16:33:01. Stream version: 544
I. 02/24 16:33:01. Processor is little-endian
I. 02/24 16:33:01. Character set: cp1252
I. 02/24 16:33:01. MobiLink user name: 2CK5170916:peter
I. 02/24 16:33:01. Script version: CheckboxMobile1.0
I. 02/24 16:33:01. Synchronization ID: -602579199
I. 02/24 16:33:01. Publication 'CheckboxMobileFullS
ync' - Synchronizing -
Log offset 0001867450 - Last download time 1900-01-01 00:00:00.0.
I. 02/24 16:33:01. Begin upload
I. 02/24 16:33:01. Uploading publication definition(s)
I. 02/24 16:33:01. Table Upload Order: ???
I. 02/24 16:33:01. Uploading table operations
I. 02/24 16:33:01. Log scan ended at offset 0001868593
I. 02/24 16:33:01. Waiting for MobiLink to apply upload
E. 02/24 16:33:02. SQLCODE from MobiLink server is: -10004
E. 02/24 16:33:02. Message: Protocol version mismatch. Table Name: NULL
I. 02/24 16:33:02. The user authentication value is 1000.
E. 02/24 16:33:02. Download aborted
I. 02/24 16:33:02. Disconnecting from MobiLink server
I. 02/24 16:33:02. Complete log scan required.
I. 02/24 16:33:02. Synchronization completed
I. 02/24 16:33:02. Options in database for subscription to
'CheckboxMobileFullS
ync' for '2CK5170916:peter':
I. 02/24 16:33:02. sv=CheckboxMobile1.0;
I. 02/24 16:33:02. Disconnecting from remote database

The output from dbmlsrv9 is as follows:

I. 02/24 16:32:56. Adaptive Server Anywhere MobiLink Version 9.0.2.3249
I. 02/24 16:32:56.
I. 02/24 16:32:56. Copyright © 1989-2004 Sybase, Inc.
Portions Copyright © 2002-2004, iAnywhere Solutions, Inc.
I. 02/24 16:32:56. All rights reserved. All unpublished rights reserved.
I. 02/24 16:32:56.
I. 02/24 16:32:56. This software contains confidential and trade secret
information of
I. 02/24 16:32:56. iAnywhere Solutions, Inc.
Use, duplication or disclosure of the software and
documentation
I. 02/24 16:32:56. by the U.S. Government is subject to restrictions set
forth in a license
I. 02/24 16:32:56. agreement between the Government and iAnywhere Solutions,
Inc. or
I. 02/24 16:32:56. other written agreement specifying the Government's
rights to use the
I. 02/24 16:32:56. software and any applicable FAR provisions, for example,
FAR 52.227-19.
I. 02/24 16:32:56.
I. 02/24 16:32:56. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
94568, USA
I. 02/24 16:32:56.
I. 02/24 16:32:56. Networked Seat (per-seat) model. Access to the server is
limited to 1 seat(s).
This server is licensed to:
I. 02/24 16:32:56. Developer Edition
I. 02/24 16:32:56. Restricted Use
I. 02/24 16:32:56. <Main>: MobiLink server started
I. 02/24 16:32:56. <Main>: Option 1: -c
I. 02/24 16:32:56. <Main>: Option 2:
dsn=CheckboxConsolid
ated;uid=sa;pwd=****
****
I. 02/24 16:32:56. <Main>: Option 3: -v+
I. 02/24 16:32:56. <Main>: Option 4: -sl
I. 02/24 16:32:56. <Main>: Option 5:
dnet(- MLAutoLoadPath=C:\Pr
ezza\CheckboxSyncSer
ver\Checkbox. Synchronization\bin\
Debug
I. 02/24 16:32:56. <Main>: Option 6: -zp
I. 02/24 16:32:56. <Main>: Verbose logging: show row values
I. 02/24 16:32:56. <Main>: Verbose logging: show script names when invoked
I. 02/24 16:32:56. <Main>: Verbose logging: show script contents when
invoked
I. 02/24 16:32:56. <Main>: Verbose logging: show schema for each table
I. 02/24 16:32:56. <Main>: Verbose logging: show an error when the first
read of a synchronization fails
I. 02/24 16:32:56. <Main>: Verbose logging: show translated SQL for prepared
statements
I. 02/24 16:32:56. <Main>: Verbose logging: show rowcount values
I. 02/24 16:32:56. <Main>: Individual database connections will be closed
after synchronization errors.
I. 02/24 16:32:56. <Main>: BLOB cache size: 524288
I. 02/24 16:32:56. <Main>: Maximum number of BLOB bytes to compare:
4294967295
I. 02/24 16:32:56. <Main>: Maximum number of database connections: 6
I. 02/24 16:32:56. <Main>: Maximum number of deadlock retries: 10
I. 02/24 16:32:56. <Main>: Timeout for inactive database connections: 60
minutes
I. 02/24 16:32:56. <Main>: Maximum delay between retries after deadlock: 30
seconds
I. 02/24 16:32:56. <Main>: Rowset size: 10
I. 02/24 16:32:56. <Main>: Upload cache size: 524288 bytes
I. 02/24 16:32:56. <Main>: Download cache memory size: 1048576 bytes
I. 02/24 16:32:56. <Main>: Download cache directory size: 10485760 bytes
I. 02/24 16:32:56. <Main>: Number of worker threads: 5
I. 02/24 16:32:56. <Main>: Maximum number of threads uploading concurrently:
5
I. 02/24 16:32:56. <Main>: Unknown users will be rejected (when there is no
authenticate_user script).
I. 02/24 16:32:56. <Main>: Example scripts will not be automatically
generated for unknown versions.
I. 02/24 16:32:56. <Main>: Local file for remote synchronization logs:
'dbmlsrv.mle'
I. 02/24 16:32:56. <Main>: Stream specifier 1: TCPIP
W. 02/24 16:32:56. <Main>: Warning: [10050] ODBC: [Microsoft][ODBC SQL
Server Driver][SQL Server]Changed database context to 'CheckboxSync'. (ODBC
State = 01000, Native error code = 5701)
W. 02/24 16:32:56. <Main>: Warning: [10050] ODBC: [Microsoft][ODBC SQL
Server Driver][SQL Server]Changed language setting to us_english. (ODBC
State = 01000, Native error code = 5703)
I. 02/24 16:32:56. <Main>: ODBC DBMS Name: Microsoft SQL Server
I. 02/24 16:32:56. <Main>: ODBC DBMS Version: 08.00.0760
I. 02/24 16:32:56. <Main>: ODBC DBMS Driver Version: 03.85.1117
I. 02/24 16:32:56. <Main>: ODBC Version supported by the driver: 3.52
I. 02/24 16:32:56. <Main>: Collation sequence of the consolidated database
is 'ISO 8859-1'
I. 02/24 16:32:56. <Main>: ODBC isolation set to: Read Committed
I. 02/24 16:32:56. <Main>: Connected
I. 02/24 16:32:56. <Main>: Loaded Assembly "iAnywhere.MobiLink.Script,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=a53f0
c6f719e2641" from
"file:///C:/Program Files/Sybase/SQL Anywhere
9/win32/iAnywhere.MobiLink.Script.dll" into Domain
" DefaultMobiLinkDNetS
criptingDomain".
I. 02/24 16:32:56. <Main>: Loaded Assembly "iAnywhere.MobiLink,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" from
"file:///C:/Program Files/Sybase/SQL Anywhere
9/win32/iAnywhere.MobiLink.dll" into Domain
" DefaultMobiLinkDNetS
criptingDomain".
I. 02/24 16:32:56. <Main>: Loaded Assembly "Checkbox.Common,
Version=1.0.2237.24509, Culture=neutral, PublicKeyToken=null" from
"file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Checkbox.Common.DLL"
into Domain " DefaultMobiLinkDNetS
criptingDomain".
I. 02/24 16:32:56. <Main>: Loaded Assembly "Checkbox,
Version=1.0.2246.22859, Culture=neutral, PublicKeyToken=null" from
"file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Checkbox.DLL"
into Domain " DefaultMobiLinkDNetS
criptingDomain".
I. 02/24 16:32:56. <Main>: Loaded Assembly "Checkbox.Synchronization,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" from
"file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Checkbox.Synchronization.DLL"
into Domain " DefaultMobiLinkDNetS
criptingDomain".
I. 02/24 16:32:56. <Main>: Loaded Assembly "iAnywhere.MobiLink.Script,
Version=1.0.0.0, Culture=neutral, PublicKeyToken=a53f0
c6f719e2641" from
"file:///C:/Program Files/Sybase/SQL Anywhere
9/win32/iAnywhere.MobiLink.Script.dll" into Domain
" DefaultMobiLinkDNetS
criptingDomain".
I. 02/24 16:32:56. <Main>: Loaded Assembly "Prezza.Framework.Common,
Version=1.0.2237.24507, Culture=neutral, PublicKeyToken=null" from
"file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Prezza.Framework.Common.DLL"
into Domain " DefaultMobiLinkDNetS
criptingDomain".
I. 02/24 16:32:56. <Main>: Loaded Assembly "Prezza.Framework,
Version=1.0.2237.24508, Culture=neutral, PublicKeyToken=null" from
"file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Prezza.Framework.DLL"
into Domain " DefaultMobiLinkDNetS
criptingDomain".
I. 02/24 16:32:56. <Main>: Loaded Assembly "Prezza.Licensing.LicenseEngine,
Version=2.1.5000.0, Culture=neutral, PublicKeyToken=null" from
"file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Prezza.Licensing.LicenseEngine.DLL"
into Domain " DefaultMobiLinkDNetS
criptingDomain".
I. 02/24 16:32:56. <Main>: Translated SQL:
SELECT COUNT(*) FROM ml_scripts_modified
I. 02/24 16:32:56. <thread 1.1>: Ready to handle requests
I. 02/24 16:32:56. <thread 1.2>: Ready to handle requests
I. 02/24 16:32:56. <thread 1.3>: Ready to handle requests
I. 02/24 16:32:56. <thread 1.4>: Ready to handle requests
I. 02/24 16:32:56. <thread 1.5>: Ready to handle requests
I. 02/24 16:33:01. <thread 1.5>: Working on a request
I. 02/24 16:33:01. <thread 1.5>: Translated SQL:
SELECT last_modified FROM ml_scripts_modified
I. 02/24 16:33:01. <thread 1.5>: ml_scripts_modified last modified at:
2006-02-24 16:32:33.270
I. 02/24 16:33:01. <thread 1.5>: Translated SQL:
SELECT version_id FROM ml_script_version WHERE name = ?
I. 02/24 16:33:01. <thread 1.5>: ASA synchronization request from:
2CK5170916:peter (version: CheckboxMobile1.0)
W. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: Warning: [10050] ODBC:
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to
'CheckboxSync'. (ODBC State = 01000, Native error code = 5701)
W. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: Warning: [10050] ODBC:
[Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to
us_english. (ODBC State = 01000, Native error code = 5703)
I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: ODBC isolation set to: Read
Committed
I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
SELECT t1.event, t2.script_language, t2.script FROM
ml_connection_script
t1, ml_script t2 WHERE t1.version_id = ? AND
t1.script_id = t2.script_id
I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: begin_connection <connection>
(no script)
I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: COMMIT Transaction:
begin_connection
I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: The authenticate_user script
returned 1000
I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE name = ?
I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: User name '2CK5170916:peter'
not found in the ml_user table, inserting a new entry
I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
SELECT hashed_password FROM ml_user WHERE name = ?
I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
SELECT MAX( user_id ) + 1 FROM ml_user
I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
INSERT INTO ml_user
(user_id,name,commit
_state,hashed_passwo
rd) VALUES(?,?,?,?)
I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
SELECT user_id FROM ml_user WHERE name = ?
I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: COMMIT Transaction:
authenticate_user
W. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Warning: [10017] The
consolidated and remote databases have different timestamp precisions.
Consolidated database timestamps are precise to 2 digit(s) in the fractional
second while the remote database timestamps are precise to 6 digit(s)
W. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Warning: [10018] The timestamp
precision mismatch may be resolved by setting the
DEFAULT_TIMESTAMP_IN
CREMENT option on the remote database to 10000 and
TRUNCATE_TIMESTAMP_V
ALUES to 'On'
I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Publication #1:
CheckboxMobileFullSy
nc, subscription id: 4, last download time: 1900-01-01
00:00:00.000000
E. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Error: [-10004] Protocol
version mismatch
I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Synchronization failed

I'd really appreciate any help you could give me!

Karl Kemp
kkemp at prezzatech dot com

Nick Elson

2006-02-28, 8:34 pm

If this is 'regressive' behaviour that was introduced in
ebf 3249, [i.e.Did this used to work before this ebf?]
please open up a case a submit a repro. Even if you
do not have a support plan, please consider submitting
bug case for this.

[for bug submissions see: "Reporting Bugs" at:
http://www.ianywhere.com/support/co...ct_support.html ]

About the only thing I see odd about your cmdlines is the -zp switch
I didn't know that MSSQL has greater than microsecond precision;
in fact the warning Warning: [10017] is tell me the opposite is true
[like ASE, MSSQL is only accurate to 1/300ths of a second].

The fact this is happening only on the download phase is even
odder.

One thing you should check out is if you have a mixture of versions
installed. Are all the DLLs (in the %asany9%\win32 directory) the
same version as the .EXEs?

"Karl Kemp" <kkemp@prezzatech.com> wrote in message
news:43ff7d86@forums
-2-dub...
> Hi,
>
> I'm trying to set up a sync using .NET scripts. All I have at this point
> is an authenticate_user script that does nothing but set the authstatus to
> 1000. I have no articles in my publication on the remote database and no
> download scripts defined on the consolidated side.
>
> When I attempt to sync, sync fails with the error "Protocol version
> mismatch" I'm running both dbmlsync and dbmlsrv9 on my local machine
> interactively. They are both 9.0.2.3249.
>
> My command to start dbmlsrv9 is
> dbmlsrv9 -c " dsn=CheckboxConsolid
ated;uid=sa;pwd=****
" -dl -o
> C:\Prezza\CheckboxSy
ncServer\MLLog.txt -v+ -sl
> dnet(- MLAutoLoadPath=C:\Pr
ezza\CheckboxSyncSer
ver\Checkbox. Synchronization\bin\
Debug)
> -zp
>
> My command to start dbmlsync is: dbmlsync -c
> " dbf=C:\Prezza\Checkb
oxMobile\Checkb
> oxMobile\Database\Ch
eckboxMobile.db;uid=dba;pwd=****" -v+
>
> The output from dbmlsync is as follows:
>
> I. 02/24 16:33:01. Synchronization Started
> I. 02/24 16:33:01. 1: -c
> I. 02/24 16:33:01. 2:
> ********************
********************
********************
********************
******
> I. 02/24 16:33:01. 3: -v+
> I. 02/24 16:33:01. Adaptive Server Anywhere MobiLink Synchronization
> Version 9.0.2.3249
> I. 02/24 16:33:01.
> I. 02/24 16:33:01. Copyright © 1989-2004 Sybase, Inc.
> Portions Copyright © 2002-2004, iAnywhere Solutions,
> Inc.
> I. 02/24 16:33:01. All rights reserved. All unpublished rights reserved.
> I. 02/24 16:33:01.
> I. 02/24 16:33:01. This software contains confidential and trade secret
> information of
> I. 02/24 16:33:01. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the software and
> documentation
> I. 02/24 16:33:01. by the U.S. Government is subject to restrictions set
> forth in a license
> I. 02/24 16:33:01. agreement between the Government and iAnywhere
> Solutions, Inc. or
> I. 02/24 16:33:01. other written agreement specifying the Government's
> rights to use the
> I. 02/24 16:33:01. software and any applicable FAR provisions, for
> example, FAR 52.227-19.
> I. 02/24 16:33:01.
> I. 02/24 16:33:01. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
> 94568, USA
> I. 02/24 16:33:01.
> I. 02/24 16:33:01. Connecting to remote database
> I. 02/24 16:33:01. Loading synchronization information
> I. 02/24 16:33:01. Options in database for subscription to
> 'CheckboxMobileFullS
ync' for '2CK5170916:peter':
> I. 02/24 16:33:01. sv=CheckboxMobile1.0;
> I. 02/24 16:33:01. Options in database for subscription to
> 'CheckboxMobileFullS
ync' for '2CK5170916:peter':
> I. 02/24 16:33:01. sv=CheckboxMobile1.0;
> I. 02/24 16:33:01. Options in database for subscription to
> 'CheckboxMobileFullS
ync' for '2CK5170916:peter':
> I. 02/24 16:33:01. sv=CheckboxMobile1.0;
> I. 02/24 16:33:01. Begin synchronizing 'CheckboxMobileFullS
ync' for
> MobiLink user '2CK5170916:peter'
> I. 02/24 16:33:01. Options for this synchronization:
> I. 02/24 16:33:01. SV='CheckboxMobile1.0',CTP='TCPIP'
> I. 02/24 16:33:01. Log scan starting at offset 0001867450
> I. 02/24 16:33:01. Processing transaction logs from directory
> " C:\Prezza\CheckboxMo
bile\CheckboxMobile\
Database\"
> I. 02/24 16:33:01. Processing transactions from active transaction log
> I. 02/24 16:33:01. Hovering at end of active log
> I. 02/24 16:33:01. Connecting to MobiLink server at '' using
> 'dbmlsock9.dll'
> I. 02/24 16:33:01. Uploading header
> I. 02/24 16:33:01. Stream version: 544
> I. 02/24 16:33:01. Processor is little-endian
> I. 02/24 16:33:01. Character set: cp1252
> I. 02/24 16:33:01. MobiLink user name: 2CK5170916:peter
> I. 02/24 16:33:01. Script version: CheckboxMobile1.0
> I. 02/24 16:33:01. Synchronization ID: -602579199
> I. 02/24 16:33:01. Publication 'CheckboxMobileFullS
ync' - Synchronizing -
> Log offset 0001867450 - Last download time 1900-01-01 00:00:00.0.
> I. 02/24 16:33:01. Begin upload
> I. 02/24 16:33:01. Uploading publication definition(s)
> I. 02/24 16:33:01. Table Upload Order: ???
> I. 02/24 16:33:01. Uploading table operations
> I. 02/24 16:33:01. Log scan ended at offset 0001868593
> I. 02/24 16:33:01. Waiting for MobiLink to apply upload
> E. 02/24 16:33:02. SQLCODE from MobiLink server is: -10004
> E. 02/24 16:33:02. Message: Protocol version mismatch. Table Name: NULL
> I. 02/24 16:33:02. The user authentication value is 1000.
> E. 02/24 16:33:02. Download aborted
> I. 02/24 16:33:02. Disconnecting from MobiLink server
> I. 02/24 16:33:02. Complete log scan required.
> I. 02/24 16:33:02. Synchronization completed
> I. 02/24 16:33:02. Options in database for subscription to
> 'CheckboxMobileFullS
ync' for '2CK5170916:peter':
> I. 02/24 16:33:02. sv=CheckboxMobile1.0;
> I. 02/24 16:33:02. Disconnecting from remote database
>
>
> The output from dbmlsrv9 is as follows:
>
> I. 02/24 16:32:56. Adaptive Server Anywhere MobiLink Version 9.0.2.3249
> I. 02/24 16:32:56.
> I. 02/24 16:32:56. Copyright © 1989-2004 Sybase, Inc.
> Portions Copyright © 2002-2004, iAnywhere Solutions,
> Inc.
> I. 02/24 16:32:56. All rights reserved. All unpublished rights reserved.
> I. 02/24 16:32:56.
> I. 02/24 16:32:56. This software contains confidential and trade secret
> information of
> I. 02/24 16:32:56. iAnywhere Solutions, Inc.
> Use, duplication or disclosure of the software and
> documentation
> I. 02/24 16:32:56. by the U.S. Government is subject to restrictions set
> forth in a license
> I. 02/24 16:32:56. agreement between the Government and iAnywhere
> Solutions, Inc. or
> I. 02/24 16:32:56. other written agreement specifying the Government's
> rights to use the
> I. 02/24 16:32:56. software and any applicable FAR provisions, for
> example, FAR 52.227-19.
> I. 02/24 16:32:56.
> I. 02/24 16:32:56. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
> 94568, USA
> I. 02/24 16:32:56.
> I. 02/24 16:32:56. Networked Seat (per-seat) model. Access to the server
> is limited to 1 seat(s).
> This server is licensed to:
> I. 02/24 16:32:56. Developer Edition
> I. 02/24 16:32:56. Restricted Use
> I. 02/24 16:32:56. <Main>: MobiLink server started
> I. 02/24 16:32:56. <Main>: Option 1: -c
> I. 02/24 16:32:56. <Main>: Option 2:
> dsn=CheckboxConsolid
ated;uid=sa;pwd=****
****
> I. 02/24 16:32:56. <Main>: Option 3: -v+
> I. 02/24 16:32:56. <Main>: Option 4: -sl
> I. 02/24 16:32:56. <Main>: Option 5:
> dnet(- MLAutoLoadPath=C:\Pr
ezza\CheckboxSyncSer
ver\Checkbox. Synchronization\bin\
Debug
> I. 02/24 16:32:56. <Main>: Option 6: -zp
> I. 02/24 16:32:56. <Main>: Verbose logging: show row values
> I. 02/24 16:32:56. <Main>: Verbose logging: show script names when invoked
> I. 02/24 16:32:56. <Main>: Verbose logging: show script contents when
> invoked
> I. 02/24 16:32:56. <Main>: Verbose logging: show schema for each table
> I. 02/24 16:32:56. <Main>: Verbose logging: show an error when the first
> read of a synchronization fails
> I. 02/24 16:32:56. <Main>: Verbose logging: show translated SQL for
> prepared statements
> I. 02/24 16:32:56. <Main>: Verbose logging: show rowcount values
> I. 02/24 16:32:56. <Main>: Individual database connections will be closed
> after synchronization errors.
> I. 02/24 16:32:56. <Main>: BLOB cache size: 524288
> I. 02/24 16:32:56. <Main>: Maximum number of BLOB bytes to compare:
> 4294967295
> I. 02/24 16:32:56. <Main>: Maximum number of database connections: 6
> I. 02/24 16:32:56. <Main>: Maximum number of deadlock retries: 10
> I. 02/24 16:32:56. <Main>: Timeout for inactive database connections: 60
> minutes
> I. 02/24 16:32:56. <Main>: Maximum delay between retries after deadlock:
> 30 seconds
> I. 02/24 16:32:56. <Main>: Rowset size: 10
> I. 02/24 16:32:56. <Main>: Upload cache size: 524288 bytes
> I. 02/24 16:32:56. <Main>: Download cache memory size: 1048576 bytes
> I. 02/24 16:32:56. <Main>: Download cache directory size: 10485760 bytes
> I. 02/24 16:32:56. <Main>: Number of worker threads: 5
> I. 02/24 16:32:56. <Main>: Maximum number of threads uploading
> concurrently: 5
> I. 02/24 16:32:56. <Main>: Unknown users will be rejected (when there is
> no authenticate_user script).
> I. 02/24 16:32:56. <Main>: Example scripts will not be automatically
> generated for unknown versions.
> I. 02/24 16:32:56. <Main>: Local file for remote synchronization logs:
> 'dbmlsrv.mle'
> I. 02/24 16:32:56. <Main>: Stream specifier 1: TCPIP
> W. 02/24 16:32:56. <Main>: Warning: [10050] ODBC: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Changed database context to 'CheckboxSync'.
> (ODBC State = 01000, Native error code = 5701)
> W. 02/24 16:32:56. <Main>: Warning: [10050] ODBC: [Microsoft][ODBC SQL
> Server Driver][SQL Server]Changed language setting to us_english. (ODBC
> State = 01000, Native error code = 5703)
> I. 02/24 16:32:56. <Main>: ODBC DBMS Name: Microsoft SQL Server
> I. 02/24 16:32:56. <Main>: ODBC DBMS Version: 08.00.0760
> I. 02/24 16:32:56. <Main>: ODBC DBMS Driver Version: 03.85.1117
> I. 02/24 16:32:56. <Main>: ODBC Version supported by the driver: 3.52
> I. 02/24 16:32:56. <Main>: Collation sequence of the consolidated database
> is 'ISO 8859-1'
> I. 02/24 16:32:56. <Main>: ODBC isolation set to: Read Committed
> I. 02/24 16:32:56. <Main>: Connected
> I. 02/24 16:32:56. <Main>: Loaded Assembly "iAnywhere.MobiLink.Script,
> Version=1.0.0.0, Culture=neutral, PublicKeyToken=a53f0
c6f719e2641" from
> "file:///C:/Program Files/Sybase/SQL Anywhere
> 9/win32/iAnywhere.MobiLink.Script.dll" into Domain
> " DefaultMobiLinkDNetS
criptingDomain".
> I. 02/24 16:32:56. <Main>: Loaded Assembly "iAnywhere.MobiLink,
> Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" from
> "file:///C:/Program Files/Sybase/SQL Anywhere
> 9/win32/iAnywhere.MobiLink.dll" into Domain
> " DefaultMobiLinkDNetS
criptingDomain".
> I. 02/24 16:32:56. <Main>: Loaded Assembly "Checkbox.Common,
> Version=1.0.2237.24509, Culture=neutral, PublicKeyToken=null" from
> "file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Checkbox.Common.DLL"
> into Domain " DefaultMobiLinkDNetS
criptingDomain".
> I. 02/24 16:32:56. <Main>: Loaded Assembly "Checkbox,
> Version=1.0.2246.22859, Culture=neutral, PublicKeyToken=null" from
> "file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Checkbox.DLL"
> into Domain " DefaultMobiLinkDNetS
criptingDomain".
> I. 02/24 16:32:56. <Main>: Loaded Assembly "Checkbox.Synchronization,
> Version=1.0.0.0, Culture=neutral, PublicKeyToken=null" from
> "file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Checkbox.Synchronization.DLL"
> into Domain " DefaultMobiLinkDNetS
criptingDomain".
> I. 02/24 16:32:56. <Main>: Loaded Assembly "iAnywhere.MobiLink.Script,
> Version=1.0.0.0, Culture=neutral, PublicKeyToken=a53f0
c6f719e2641" from
> "file:///C:/Program Files/Sybase/SQL Anywhere
> 9/win32/iAnywhere.MobiLink.Script.dll" into Domain
> " DefaultMobiLinkDNetS
criptingDomain".
> I. 02/24 16:32:56. <Main>: Loaded Assembly "Prezza.Framework.Common,
> Version=1.0.2237.24507, Culture=neutral, PublicKeyToken=null" from
> "file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Prezza.Framework.Common.DLL"
> into Domain " DefaultMobiLinkDNetS
criptingDomain".
> I. 02/24 16:32:56. <Main>: Loaded Assembly "Prezza.Framework,
> Version=1.0.2237.24508, Culture=neutral, PublicKeyToken=null" from
> "file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Prezza.Framework.DLL"
> into Domain " DefaultMobiLinkDNetS
criptingDomain".
> I. 02/24 16:32:56. <Main>: Loaded Assembly
> "Prezza.Licensing.LicenseEngine, Version=2.1.5000.0, Culture=neutral,
> PublicKeyToken=null" from
> "file:///C:/Prezza/CheckboxSyncServer/Checkbox.Synchronization/bin/Debug/Prezza.Licensing.LicenseEngine.DLL"
> into Domain " DefaultMobiLinkDNetS
criptingDomain".
> I. 02/24 16:32:56. <Main>: Translated SQL:
> SELECT COUNT(*) FROM ml_scripts_modified
> I. 02/24 16:32:56. <thread 1.1>: Ready to handle requests
> I. 02/24 16:32:56. <thread 1.2>: Ready to handle requests
> I. 02/24 16:32:56. <thread 1.3>: Ready to handle requests
> I. 02/24 16:32:56. <thread 1.4>: Ready to handle requests
> I. 02/24 16:32:56. <thread 1.5>: Ready to handle requests
> I. 02/24 16:33:01. <thread 1.5>: Working on a request
> I. 02/24 16:33:01. <thread 1.5>: Translated SQL:
> SELECT last_modified FROM ml_scripts_modified
> I. 02/24 16:33:01. <thread 1.5>: ml_scripts_modified last modified at:
> 2006-02-24 16:32:33.270
> I. 02/24 16:33:01. <thread 1.5>: Translated SQL:
> SELECT version_id FROM ml_script_version WHERE name = ?
> I. 02/24 16:33:01. <thread 1.5>: ASA synchronization request from:
> 2CK5170916:peter (version: CheckboxMobile1.0)
> W. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: Warning: [10050] ODBC:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to
> 'CheckboxSync'. (ODBC State = 01000, Native error code = 5701)
> W. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: Warning: [10050] ODBC:
> [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to
> us_english. (ODBC State = 01000, Native error code = 5703)
> I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: ODBC isolation set to: Read
> Committed
> I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
> SELECT t1.event, t2.script_language, t2.script FROM
> ml_connection_script
t1, ml_script t2 WHERE t1.version_id = ? AND
> t1.script_id = t2.script_id
> I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: begin_connection <connection>
> (no script)
> I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: COMMIT Transaction:
> begin_connection
> I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: The authenticate_user script
> returned 1000
> I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
> SELECT hashed_password FROM ml_user WHERE name = ?
> I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: User name '2CK5170916:peter'
> not found in the ml_user table, inserting a new entry
> I. 02/24 16:33:01. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
> SELECT hashed_password FROM ml_user WHERE name = ?
> I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
> SELECT MAX( user_id ) + 1 FROM ml_user
> I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
> INSERT INTO ml_user
> (user_id,name,commit
_state,hashed_passwo
rd) VALUES(?,?,?,?)
> I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Translated SQL:
> SELECT user_id FROM ml_user WHERE name = ?
> I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: COMMIT Transaction:
> authenticate_user
> W. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Warning: [10017] The
> consolidated and remote databases have different timestamp precisions.
> Consolidated database timestamps are precise to 2 digit(s) in the
> fractional second while the remote database timestamps are precise to 6
> digit(s)
> W. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Warning: [10018] The
> timestamp precision mismatch may be resolved by setting the
> DEFAULT_TIMESTAMP_IN
CREMENT option on the remote database to 10000 and
> TRUNCATE_TIMESTAMP_V
ALUES to 'On'
> I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Publication #1:
> CheckboxMobileFullSy
nc, subscription id: 4, last download time: 1900-01-01
> 00:00:00.000000
> E. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Error: [-10004] Protocol
> version mismatch
> I. 02/24 16:33:02. <1.5> & #91;2CK5170916:peter
]: Synchronization failed
>
>
> I'd really appreciate any help you could give me!
>
> Karl Kemp
> kkemp at prezzatech dot com
>

Sponsored Links