cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Synchronization problems with Mobilink v16

Go to solution
Former Member

on ‎05-29-2014 2:12 PM

0 Kudos

Hi all,

I'm having problems while synchronizing an ultralite database (migrated from v.11 to v.16) in a windows mobile application. The server has this config (log startup):



I. 2014-05-29 10:17:36. SQL Anywhere MobiLink Server Version 16.0.0.1824


I. 2014-05-29 10:17:36. 


I. 2014-05-29 10:17:36. Copyright ø 2014 SAP AG or an SAP affiliate company.


I. 2014-05-29 10:17:36. All rights reserved.


I. 2014-05-29 10:17:36. Use of this software is governed by the Sybase License Agreement.


I. 2014-05-29 10:17:36. Refer to http://www.sybase.com/softwarelicenses.


I. 2014-05-29 10:17:36. 


I. 2014-05-29 10:17:36. This server is licensed to:


I. 2014-05-29 10:17:36.     Developer Edition


I. 2014-05-29 10:17:36.     Restricted Use


I. 2014-05-29 10:17:36. Running Windows 7 Build 7601 Service Pack 1 on X86_64


I. 2014-05-29 10:17:36. Server built for X86_64 processor architecture


I. 2014-05-29 10:17:36. <Main> Option 1: -c


I. 2014-05-29 10:17:36. <Main> Option 2: dsn=BDConsolidada16;uid=CARMCTUser;pwd=********


I. 2014-05-29 10:17:36. <Main> Option 3: -zs


I. 2014-05-29 10:17:36. <Main> Option 4: devNaim


I. 2014-05-29 10:17:36. <Main> Option 5: -dl


I. 2014-05-29 10:17:36. <Main> Option 6: -x


I. 2014-05-29 10:17:36. <Main> Option 7: http(host=10.7.27.114;port=2009)


I. 2014-05-29 10:17:36. <Main> Option 8: -o


I. 2014-05-29 10:17:36. <Main> Option 9: D:\Desarrollo\BDMobiLinkConsolidada\Mobilink.log


I. 2014-05-29 10:17:36. <Main> Option 10: -v+


I. 2014-05-29 10:17:36. <Main> Option 11: -sl


I. 2014-05-29 10:17:36. <Main> Option 12: dnet(-clrVersion=v4.0.30319


I. 2014-05-29 10:17:36. <Main> Option 13: -MLAutoLoadPath=D:\Projects\Inator3\PDASYS~1\PDA\SYNCHR~1\SYNCHR~1.0-S\bin\Debug


I. 2014-05-29 10:17:36. <Main> Verbose logging: show upload row values


I. 2014-05-29 10:17:36. <Main> Verbose logging: show download row values


I. 2014-05-29 10:17:36. <Main> Verbose logging: show script names when invoked


I. 2014-05-29 10:17:36. <Main> Verbose logging: show script contents when invoked


I. 2014-05-29 10:17:36. <Main> Verbose logging: show schema for each table


I. 2014-05-29 10:17:36. <Main> Verbose logging: show an error when the first read of a synchronization fails


I. 2014-05-29 10:17:36. <Main> Verbose logging: show translated SQL for prepared statements


I. 2014-05-29 10:17:36. <Main> Verbose logging: show rowcount values


I. 2014-05-29 10:17:36. <Main> Cache size: 52428800 bytes


I. 2014-05-29 10:17:36. <Main> Download cache directory size: 10485760 bytes


I. 2014-05-29 10:17:36. <Main> Local file for remote synchronization logs: 'mlsrv.mle'


I. 2014-05-29 10:17:37. <Main> Starting cache sizes: min of 52428800 bytes; max of 5973578956 bytes; initial size of 52142080 bytes


I. 2014-05-29 10:17:37. <Main> Individual database connections will be closed after synchronization errors


I. 2014-05-29 10:17:37. <Main> Maximum number of BLOB bytes to compare: 4294967295


I. 2014-05-29 10:17:37. <Main> Maximum number of database connections: 5


I. 2014-05-29 10:17:37. <Main> Maximum number of deadlock retries: 10


I. 2014-05-29 10:17:37. <Main> Timeout for inactive database connections: 60 minutes


I. 2014-05-29 10:17:37. <Main> Maximum delay between retries after deadlock: 30 seconds


I. 2014-05-29 10:17:37. <Main> Rowset size: 10


I. 2014-05-29 10:17:37. <Main> Number of database worker threads: 5


I. 2014-05-29 10:17:37. <Main> Unknown users will be rejected (when there is no authenticate_user script)


I. 2014-05-29 10:17:39. <Main> ODBC DBMS Name: SQL Anywhere


I. 2014-05-29 10:17:39. <Main> ODBC DBMS Version: 16.00.0000


I. 2014-05-29 10:17:39. <Main> ODBC DBMS Driver Version: 16.00.1824


I. 2014-05-29 10:17:39. <Main> ODBC Version supported by the driver: 3.52


I. 2014-05-29 10:17:39. <Main> Collation sequence of the consolidated database is 'UTF-8'


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        select db_property( 'Capabilities' )


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        select db_property( 'Capabilities' )


I. 2014-05-29 10:17:39. <Main> ODBC DBMS Type: SQL Anywhere


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        SELECT @@spid


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        SELECT @@spid


I. 2014-05-29 10:17:39. <Main> Shared administrative connection with connection ID 'SPID 1' has been established


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        set temporary option chained = 'ON'


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        set temporary option chained = 'ON'


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        set temporary option st_geometry_asbinary_format = 'WKB( endian=little )'


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        set temporary option st_geometry_asbinary_format = 'WKB( endian=little )'


I. 2014-05-29 10:17:39. <Main> ODBC isolation set to: Read Committed


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        SELECT user_id, name, hashed_password, policy_id, user_dn FROM ml_user WHERE 1=2


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        SELECT user_id, name, hashed_password, policy_id, user_dn FROM ml_user WHERE 1=2


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        SELECT rid, remote_id, script_ldt, sync_key, description FROM ml_database WHERE 1=2


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        SELECT rid, remote_id, script_ldt, sync_key, description FROM ml_database WHERE 1=2


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        SELECT rid, subscription_id, user_id, progress, publication_name, last_upload_time, last_download_time FROM ml_subscription WHERE 1=2


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        SELECT rid, subscription_id, user_id, progress, publication_name, last_upload_time, last_download_time FROM ml_subscription WHERE 1=2


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        SELECT ldsrv_id, ldsrv_name, search_url, access_dn, access_dn_pwd, auth_url, num_retries, timeout, start_tls FROM ml_ldap_server WHERE 1=2


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        SELECT ldsrv_id, ldsrv_name, search_url, access_dn, access_dn_pwd, auth_url, num_retries, timeout, start_tls FROM ml_ldap_server WHERE 1=2


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        SELECT file_name FROM ml_trusted_certificates_file WHERE 1=2


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        SELECT file_name FROM ml_trusted_certificates_file WHERE 1=2


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        SELECT policy_id, policy_name, primary_ldsrv_id, secondary_ldsrv_id, ldap_auto_failback_period, ldap_failover_to_std FROM ml_user_auth_policy WHERE 1=2


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        SELECT policy_id, policy_name, primary_ldsrv_id, secondary_ldsrv_id, ldap_auto_failback_period, ldap_failover_to_std FROM ml_user_auth_policy WHERE 1=2


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        SELECT table_id, name FROM ml_table WHERE 1=2


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        SELECT table_id, name FROM ml_table WHERE 1=2


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        SELECT component_name, property_set_name, property_name, property_value FROM ml_property WHERE 1=2


I. 2014-05-29 10:17:39. <Main> Translated SQL:


                        SELECT component_name, property_set_name, property_name, property_value FROM ml_property WHERE 1=2


I. 2014-05-29 10:17:39. <Main> System event on shared administrative connection:


                        SELECT script_id, script, script_language FROM ml_script WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT script_id, script, script_language FROM ml_script WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT version_id, name, description FROM ml_script_version WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT version_id, name, description FROM ml_script_version WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT version_id, event, script_id FROM ml_connection_script WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT version_id, event, script_id FROM ml_connection_script WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT version_id, table_id, event, script_id FROM ml_table_script WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT version_id, table_id, event, script_id FROM ml_table_script WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT last_modified FROM ml_scripts_modified WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT last_modified FROM ml_scripts_modified WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT version_id, table_id, idx, name, type FROM ml_column WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT version_id, table_id, idx, name, type FROM ml_column WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT server_id, name, connection_info, instance_key, start_time FROM ml_primary_server WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT server_id, name, connection_info, instance_key, start_time FROM ml_primary_server WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT script_id, script_name, flags, affected_pubs, script, description FROM ml_passthrough_script WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT script_id, script_name, flags, affected_pubs, script, description FROM ml_passthrough_script WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT remote_id, run_order, script_id, last_modified FROM ml_passthrough WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT remote_id, run_order, script_id, last_modified FROM ml_passthrough WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT status_id, remote_id, run_order, script_id, script_status, error_code, error_text, remote_run_time FROM ml_passthrough_status WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT status_id, remote_id, run_order, script_id, script_status, error_code, error_text, remote_run_time FROM ml_passthrough_status WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT failed_script_id, error_code, new_script_id, action FROM ml_passthrough_repair WHERE 1=2


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT failed_script_id, error_code, new_script_id, action FROM ml_passthrough_repair WHERE 1=2


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT count(*) FROM ml_scripts_modified


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT count(*) FROM ml_scripts_modified


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT CONNECTION_PROPERTY( 'ALLOW_SNAPSHOT_ISOLATION' )


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT CONNECTION_PROPERTY( 'ALLOW_SNAPSHOT_ISOLATION' )


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT file_name FROM ml_trusted_certificates_file


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT file_name FROM ml_trusted_certificates_file


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT ldsrv_id, ldsrv_name, search_url, access_dn, access_dn_pwd, auth_url, timeout, num_retries, start_tls FROM ml_ldap_server order by 1


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT ldsrv_id, ldsrv_name, search_url, access_dn, access_dn_pwd, auth_url, timeout, num_retries, start_tls FROM ml_ldap_server order by 1


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        SELECT policy_id, policy_name, primary_ldsrv_id, secondary_ldsrv_id, ldap_auto_failback_period, ldap_failover_to_std FROM ml_user_auth_policy order by 1


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        SELECT policy_id, policy_name, primary_ldsrv_id, secondary_ldsrv_id, ldap_auto_failback_period, ldap_failover_to_std FROM ml_user_auth_policy order by 1


I. 2014-05-29 10:17:40. <Main> System event on shared administrative connection:


                        select cast(property_value as char(254)) from ml_property where component_name = 'MLS' AND property_set_name = 'locking_and_blocking_detection' AND property_name = 'blocking_threshold_in_seconds'


I. 2014-05-29 10:17:40. <Main> Translated SQL:


                        select cast(property_value as char(254)) from ml_property where component_name = 'MLS' AND property_set_name = 'locking_and_blocking_detection' AND property_name = 'blocking_threshold_in_seconds'


I. 2014-05-29 10:17:41. <Main> Loaded Assembly "iAnywhere.MobiLink.Script, Version=1.0.0.0, Culture=neutral, PublicKeyToken=a53f0c6f719e2641" from "file:///C:/Program Files/SQL Anywhere 16/Assembly/v2/iAnywhere.MobiLink.Script.DLL" into Domain "DefaultDomain"


I. 2014-05-29 10:17:42. <Main> Loaded Assembly "iAnywhere.MobiLink, Version=16.0.0.1824, Culture=neutral, PublicKeyToken=a53f0c6f719e2641" from "file:///C:/Program Files/SQL Anywhere 16/Assembly/v2/iAnywhere.MobiLink.dll" into Domain "DefaultDomain"


I. 2014-05-29 10:17:42. <Main> Loaded Assembly "iAnywhere.MobiLink.Script, Version=1.0.0.0, Culture=neutral, PublicKeyToken=a53f0c6f719e2641" from "file:///C:/Program Files/SQL Anywhere 16/Assembly/v2/iAnywhere.MobiLink.Script.dll" into Domain "DefaultMobiLinkDNetScriptingDomain"


I. 2014-05-29 10:17:43. <Main> Loaded Assembly "iAnywhere.MobiLink, Version=16.0.0.1824, Culture=neutral, PublicKeyToken=a53f0c6f719e2641" from "file:///C:/Program Files/SQL Anywhere 16/Assembly/v2/iAnywhere.MobiLink.dll" into Domain "DefaultMobiLinkDNetScriptingDomain"


I. 2014-05-29 10:17:43. <Main> Loaded Assembly "SynchroServer, Version=10.3.0.0, Culture=neutral, PublicKeyToken=null" from "file:///D:/Projects/Inator3/PDASystem/PDA/SynchroServer/SynchroServer_10.3.0.0-SQLAnywhere16/bin/Debug/SynchroServer.DLL" into Domain "DefaultMobiLinkDNetScriptingDomain"


I. 2014-05-29 10:17:44. <Main> System event on locking/blocking detector connection:


                        SELECT @@spid


I. 2014-05-29 10:17:44. <Main> MobiLink server started

The server raises some errors:



I. 2014-05-29 11:16:56. <8> Request from "UL 16.0.1824" for: remote ID: 16494c50-e688-11e3-8000-883086e0189e, user name: *******, version: verNewTrip


E. 2014-05-29 11:16:57. <8> [-10060] Memory allocation failed


E. 2014-05-29 11:16:57. <8> [-10001] Protocol error: 400


E. 2014-05-29 11:16:57. <8> [-10410] The client failed to send a complete sequence of commands


I. 2014-05-29 11:16:57. <8> Synchronization failed


I. 2014-05-29 11:16:57. <8> PHASE: sync_request: 318


I. 2014-05-29 11:16:57. <8> PHASE: receive_upload: 433


I. 2014-05-29 11:16:57. <8> PHASE: get_db_worker: 0


I. 2014-05-29 11:16:57. <8> PHASE: connect: 0


I. 2014-05-29 11:16:57. <8> PHASE: authenticate_user: 0


I. 2014-05-29 11:16:57. <8> PHASE: begin_sync: 0


I. 2014-05-29 11:16:57. <8> PHASE: apply_upload: 0


I. 2014-05-29 11:16:57. <8> PHASE: prepare_for_download: 0


I. 2014-05-29 11:16:57. <8> PHASE: fetch_download: 0


I. 2014-05-29 11:16:57. <8> PHASE: end_sync: 0


I. 2014-05-29 11:16:57. <8> PHASE: send_download: 0


I. 2014-05-29 11:16:57. <8> PHASE: wait_for_download_ack: 0


I. 2014-05-29 11:16:57. <8> PHASE: get_db_worker_for_download_ack: 0


I. 2014-05-29 11:16:57. <8> PHASE: connect_for_download_ack: 0


I. 2014-05-29 11:16:57. <8> PHASE: nonblocking_download_ack: 0


E. 2014-05-29 11:16:57. <9> [-10117] Stream Error: Unable to continue unknown HTTP session

Has someone some help?

Thanks in advance.

Show replies
Show replies
Answer

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
‎05-30-2014 8:00 AM
0 Kudos

HI All,

I've found the problem....

I was missing some publications and the publications that were in the Ultralite Database were incomplete, i'm experiencing some problems on migration from v.11 to v.16 (see this post ).

Now, the synchronization works but i'm missing some filtering on some articles...

Best regards!

Show replies
Show replies

Answers (0)

Ask a Question