Hello We have a problem with our setup. While syncing we get the error Our setup:
Our issue: This setup works for one database (database A) but doesn't work for another (database B).
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. |
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. 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 '18, 09:25)
MichaelMange...
|
16.0.0.1324 is very old... it's the original GA version of SQL Anywhere 16... many bugs have been fixed since then.
@Breck Carter: We have to use this version because we are using bought software (Amos) and they only support version 16.0.0.1324.
That seems to be a warning fixed with 16.0.0.1932, see the according online read me.
@Volker Barth Your link doesn't seem to work for me.
Here's another attempt:
http://sqlasupport.sap.com/readme/sqla1600.html
Just search for the error message or the build number 1932...
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.
I upgraded to the latest version of Sybase 16 and the issue is still there.