Hello

We have a problem with our setup. While syncing we get the error [-10410] The client failed to send a complete sequence of commands on the server.

Our setup:

  • Sybase 16 Database on Windows
  • Hosted Mobilink with the command: mlsrv16 -c "DSN=amos0056" -o D:\mlserver14.txt -dl -zu+ -x tcpip -vcehpRstu
  • Sybase 16 Database on Windows Mobile 6.5
  • Sync called from the Windows Mobile 6.5 with the command: dbmlsync.exe -qc -x 5M -c "eng=amos_remote;uid=DBA;pwd=<REDACTED>" -u AmosSync -ot "Storage Card\Database\logEx.txt" -e "tor=amosuser,location,orderline,sparetype,unit,sys_member,sys_groups,sys_modules,sys_access,jdntransportcolloline,sparelocation,spareunit,sparelocationtemp,jdnamosmobileauditlog,sparepartlog,jdninventory,installation,department";

Our issue:

This setup works for one database (database A) but doesn't work for another (database B).

  • Database A: Works on Windows Mobile 6.5 device and Windows Mobile 6.1 device, +/- 2GB in size
  • Database B: Doesn't work on Windows Mobile 6.5 device and works on Windows Mobile 6.1 device, +/- 2.2GB in size

The log on the Windows Mobile 6.5 device for database B: It stays stuck on 'Buffering download stream: received xxxxxxxxx bytes' for a while until it just suddenly stops

I. 2018-06-19 13:50:10. SQL Anywhere MobiLink Client Version 16.0.0.1324
I. 2018-06-19 13:50:10. 
I. 2018-06-19 13:50:10. Copyright © 2013 SAP AG or an SAP affiliate company.
I. 2018-06-19 13:50:10. All rights reserved.
I. 2018-06-19 13:50:10. Use of this software is governed by the Sybase License Agreement.
I. 2018-06-19 13:50:10. Refer to http://www.sybase.com/softwarelicenses.
I. 2018-06-19 13:50:11. 
I. 2018-06-19 13:50:11. Running Windows CE 5.2 Build 29344  on ARM
I. 2018-06-19 13:50:11. Executable built for ARM processor architecture
I. 2018-06-19 13:50:11. 
I. 2018-06-19 13:50:12. Begin synchronizing subscription(s) 'AmosSync_amossync'
I. 2018-06-19 13:50:12. Log scan starting at offset 0013599156
I. 2018-06-19 13:50:12. Processing transaction logs from directory "\Storage Card\Database\"
I. 2018-06-19 13:50:12. Processing transactions from active transaction log
I. 2018-06-19 13:50:12. Hovering at end of active log
I. 2018-06-19 13:50:12. Log scan ended at offset 0013599897
I. 2018-06-19 13:50:12. Connecting to MobiLink server at 'host=vm-win7scth01;port=2439' using 'TCPIP'
I. 2018-06-19 13:50:12. Begin upload
I. 2018-06-19 13:50:12. Uploading table operations
I. 2018-06-19 13:50:12. Waiting for MobiLink to apply upload
I. 2018-06-19 13:50:12. Sending schema information to MobiLink server.
I. 2018-06-19 13:50:15. The user authentication value is 1000.
I. 2018-06-19 13:50:15. COMMIT
I. 2018-06-19 13:50:50. Download stream: received 17175174 bytes from MobiLink server.
018-06-19 11:23:23. Uploading table operations
I. 2018-06-19 11:23:23. Waiting for MobiLink to apply upload
I. 2018-06-19 11:23:23. Sending schema information to MobiLink server.
I. 2018-06-19 11:23:23. The user authentication value is 1000.
I. 2018-06-19 11:23:23. COMMIT
I. 2018-06-19 11:23:46. Download stream: received 17175184 bytes from MobiLink server.
 completed
I. 2018-06-19 11:23:08. Shutdown by request

This is the log on the server for database B (only posting most relevent info):

....

I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) begin_download_rows Department (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_cursor Department

                        call "amos"."pdml_dlcurs_department" (?, ?)

I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) Translated SQL:

                        call "amos"."pdml_dlcurs_department" (?, ?)

I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download_rows Department (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) modify_next_last_download_timestamp <connection> (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download AmosUser (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download Location (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download OrderLine (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download SpareType (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download Unit (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download Sys_Member (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download Sys_Groups (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download Sys_modules (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download Sys_Access (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download jdntransportcolloline (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download SpareLocation (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download SpareUnit (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download SpareLocationTemp (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download JdnAmosMobileAuditLog (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download SparePartLog (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download JdnInventory (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download Installation (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download Department (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) end_download <connection> (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics AmosUser (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics Location (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics OrderLine (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics SpareType (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics Unit (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics Sys_Member (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics Sys_Groups (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics Sys_modules (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics Sys_Access (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics jdntransportcolloline (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics SpareLocation (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics SpareUnit (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics SpareLocationTemp (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics JdnAmosMobileAuditLog (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics SparePartLog (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics JdnInventory (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics Installation (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics Department (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) download_statistics <connection> (no script)
I. 2018-06-19 13:51:05. <1> (JDN-1477-9829621547,) Sending the download to the remote database
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) COMMIT Transaction: Download
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_publication <connection> (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization AmosUser (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization Location (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization OrderLine (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization SpareType (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization Unit (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization Sys_Member (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization Sys_Groups (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization Sys_modules (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization Sys_Access (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization jdntransportcolloline (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization SpareLocation (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization SpareUnit (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization SpareLocationTemp (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization JdnAmosMobileAuditLog (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization SparePartLog (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization JdnInventory (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization Installation (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization Department (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) end_synchronization <connection> (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics AmosUser (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics Location (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics OrderLine (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics SpareType (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics Unit (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics Sys_Member (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics Sys_Groups (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics Sys_modules (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics Sys_Access (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics jdntransportcolloline (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics SpareLocation (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics SpareUnit (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics SpareLocationTemp (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics JdnAmosMobileAuditLog (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics SparePartLog (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics JdnInventory (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics Installation (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics Department (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) synchronization_statistics <connection> (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics AmosUser (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics Location (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics OrderLine (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics SpareType (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics Unit (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics Sys_Member (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics Sys_Groups (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics Sys_modules (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics Sys_Access (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics jdntransportcolloline (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics SpareLocation (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics SpareUnit (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics SpareLocationTemp (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics JdnAmosMobileAuditLog (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics SparePartLog (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics JdnInventory (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics Installation (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics Department (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) time_statistics <connection> (no script)
I. 2018-06-19 13:51:06. <1> (JDN-1477-9829621547,) COMMIT Transaction: End synchronization
E. 2018-06-19 13:51:26. <1> (JDN-1477-9829621547,) [-10410] The client failed to send a complete sequence of commands
I. 2018-06-19 13:51:26. <1> (JDN-1477-9829621547,) Synchronization failed

What now?

We have no idea what to do next. We checked a lot of options

We tried adding "adr=timeout=600" option to the Windows Mobile 6.5 sync request, but this did not change a thing.

The only difference we see between the Windows Mobile 6.5 and Windows Mobile 6.1 versions is that the Buffering download stream: received xxxxxxxxx bytes stays for a longer time, and the number of bytes goes up more in the 6.1 version in comparison to the 6.5 version.

Any ideas?

If you need more info, feel free to ask.

Thank you.

asked 19 Jun, 07:52

MichaelMangelschots's gravatar image

MichaelMange...
1201210
accept rate: 0%

edited 19 Jun, 08:39

16.0.0.1324 is very old... it's the original GA version of SQL Anywhere 16... many bugs have been fixed since then.

(19 Jun, 16:13) Breck Carter

@Breck Carter: We have to use this version because we are using bought software (Amos) and they only support version 16.0.0.1324.

(20 Jun, 02:11) MichaelMange...

That seems to be a warning fixed with 16.0.0.1932, see the according online read me.

(20 Jun, 03:09) Volker Barth
Replies hidden

@Volker Barth Your link doesn't seem to work for me.

(20 Jun, 03:36) MichaelMange...

Here's another attempt:

http://sqlasupport.sap.com/readme/sqla1600.html

Just search for the error message or the build number 1932...

(20 Jun, 06:22) Volker Barth
Comment Text Removed

I found the 'bug' that it's supposed to fix, but that's not really the case here I think. Something is actually not working.

(22 Jun, 09:29) MichaelMange...

I upgraded to the latest version of Sybase 16 and the issue is still there.

(05 Jul, 06:25) MichaelMange...
showing 3 of 7 show all flat view

Error -10410 in the server log doesn't really mean anything; it basically means that the client disappeared and we don't know why.

In the dbmlsync log, the "Download stream: received..." indicates that the entire download was received and is presumably being applied to the remote database. You can turn on request logging in the remote database to see what dbmlsync is doing when it gets stuck.

permanent link

answered 20 Jun, 17:37

Bill%20Somers's gravatar image

Bill Somers
1.1k819
accept rate: 37%

Thanks for the suggestion! I enabled -v+ but it still doesn't say anything after that line.

If I check on a database that works, the next line should be 'I. 2018-06-20 14:39:27. Processing download stream ...'. But it doesn't show that either on the failed database.

(22 Jun, 09:25) MichaelMange...
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×310
×107
×21
×10
×2

question asked: 19 Jun, 07:52

question was seen: 135 times

last updated: 05 Jul, 06:25