on 2016 Feb 05 5:47 PM
I am running Mobilink 16 server and replicating to ultralite databases on windows mobile devices.
On the end synchronization connection event, I call a stored procedure to do some house keeping if the replication is successful. We have recently run into a replication failure, likely due to a degraded network connection, where the replication fails but the s.synchronization_ok indicates the replication was successful. It's causing some problems with the data...
Here's the error line from the log: E. 2016-02-05 16:56:28. <27> [-10410] The client failed to send a complete sequence of commands I. 2016-02-05 16:56:28. <27> Synchronization failed
What should (can) I do about this?
Thank you in advance!
Paula
Edit - v+ log data. I did not include the entries for every table - it is a lot. I see where the procedure is being executed and I see that the end sync event happens before the download is applied/completed on the remote database - is that correct?
I. 2016-02-06 16:26:51. <1> System variable username value: FE_PAULA I. 2016-02-06 16:26:51. <1> end_download_rows REP_TASK_RESPONSE_AUDIT (no script) I. 2016-02-06 16:26:51. <1> The earliest transaction has been running for '0' seconds I. 2016-02-06 16:26:51. <1> modify_next_last_download_timestamp <connection> (no script) I. 2016-02-06 16:26:51. <1> end_download REP_APPOINTMENT_HISTORY (no script) I. 2016-02-06 16:26:51. <1> end_download REP_APPOINTMENT_TIME_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_BLACKOUT_SCHEDULE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_CLASS_TO_CLASS_GROUP_ID (no script) I. 2016-02-06 16:26:51. <1> end_download REP_DEVICE_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_FIELD_WORK_HISTORY (no script) I. 2016-02-06 16:26:51. <1> end_download REP_FUNCTION_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_GPS (no script) I. 2016-02-06 16:26:51. <1> end_download REP_LABOR_CLASSIFICATION_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_MFG_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_OBSERVATION_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_OBSERVATION_HISTORY (no script) I. 2016-02-06 16:26:51. <1> end_download REP_ROUTE_SELECT_METHOD_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_ROUTE_SUMMARY (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SAFETY_MESSAGE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SECURITY_ID_FUNCT_ASSIGN (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SECURITY_ID (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SITE_INFO_NOTES (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SITE_INFO (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SPECIAL_INSTRUCTION_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SPECIAL_INSTRUCTIONS (no script) I. 2016-02-06 16:26:51. <1> end_download REP_TELEPHONE_LOOKUP (no script) I. 2016-02-06 16:26:51. <1> end_download REP_VALIDATION_INFO (no script) I. 2016-02-06 16:26:51. <1> end_download REP_WO_TO_REMOTE_DB (no script) I. 2016-02-06 16:26:51. <1> end_download REP_WORK_COUNT_TABLE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_WORK_ORDER_HEADER (no script) I. 2016-02-06 16:26:51. <1> end_download REP_WORK_ORDER_STATUS_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_WORK_ORDER_STATUS_CONTROL (no script) I. 2016-02-06 16:26:51. <1> end_download REP_WORK_ORDER_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download SHR_REMOTE_DATABASE_ID (no script) I. 2016-02-06 16:26:51. <1> end_download REP_IMAGE_REASON_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_FIELD_WORK_IMAGES (no script) I. 2016-02-06 16:26:51. <1> end_download REP_REPAIR_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_REPAIR_HISTORY (no script) I. 2016-02-06 16:26:51. <1> end_download REP_REGISTER_READ_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_EQUIPMENT_ASSEMBLY_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SUBSTITUTE_ASSEMBLY_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_FW_TWO_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_FW_ONE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SI_ONE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SI_TWO_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SI_THREE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SI_SIX_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SI_SEVEN_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_SI_EIGHT_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_PREMISE_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> end_download REP_EAC_VOLTAGE_LOOKUP (no script) I. 2016-02-06 16:26:51. <1> end_download REP_PRIMARY_INVENTORY (no script) I. 2016-02-06 16:26:51. <1> end_download REP_TASK_RESPONSE_AUDIT (no script) I. 2016-02-06 16:26:51. <1> end_download <connection> (no script) I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_APPOINTMENT_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_APPOINTMENT_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_APPOINTMENT_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_APPOINTMENT_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_APPOINTMENT_TIME_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_APPOINTMENT_TIME_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_APPOINTMENT_TIME_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_APPOINTMENT_TIME_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_BLACKOUT_SCHEDULE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_BLACKOUT_SCHEDULE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_BLACKOUT_SCHEDULE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_BLACKOUT_SCHEDULE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_CLASS_TO_CLASS_GROUP_ID : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_CLASS_TO_CLASS_GROUP_ID : 2 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_CLASS_TO_CLASS_GROUP_ID : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_CLASS_TO_CLASS_GROUP_ID : 2 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_DEVICE_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_DEVICE_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_DEVICE_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_DEVICE_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_FIELD_WORK_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_FIELD_WORK_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_FIELD_WORK_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_FIELD_WORK_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_FUNCTION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_FUNCTION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_FUNCTION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_FUNCTION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_GPS : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_GPS : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_GPS : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_GPS : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_LABOR_CLASSIFICATION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_LABOR_CLASSIFICATION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_LABOR_CLASSIFICATION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_LABOR_CLASSIFICATION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_MFG_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_MFG_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_MFG_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_MFG_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_OBSERVATION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_OBSERVATION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_OBSERVATION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_OBSERVATION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_OBSERVATION_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_OBSERVATION_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_OBSERVATION_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_OBSERVATION_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_ROUTE_SELECT_METHOD_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_ROUTE_SELECT_METHOD_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_ROUTE_SELECT_METHOD_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_ROUTE_SELECT_METHOD_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_ROUTE_SUMMARY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_ROUTE_SUMMARY : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_ROUTE_SUMMARY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_ROUTE_SUMMARY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SAFETY_MESSAGE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SAFETY_MESSAGE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SAFETY_MESSAGE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SAFETY_MESSAGE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SECURITY_ID_FUNCT_ASSIGN : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SECURITY_ID_FUNCT_ASSIGN : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SECURITY_ID_FUNCT_ASSIGN : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SECURITY_ID_FUNCT_ASSIGN : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SECURITY_ID : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SECURITY_ID : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SECURITY_ID : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SECURITY_ID : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SITE_INFO_NOTES : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SITE_INFO_NOTES : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SITE_INFO_NOTES : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SITE_INFO_NOTES : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SITE_INFO : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SITE_INFO : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SITE_INFO : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SITE_INFO : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SPECIAL_INSTRUCTION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SPECIAL_INSTRUCTION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SPECIAL_INSTRUCTION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SPECIAL_INSTRUCTION_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SPECIAL_INSTRUCTIONS : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SPECIAL_INSTRUCTIONS : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SPECIAL_INSTRUCTIONS : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SPECIAL_INSTRUCTIONS : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_TELEPHONE_LOOKUP : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_TELEPHONE_LOOKUP : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_TELEPHONE_LOOKUP : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_TELEPHONE_LOOKUP : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_VALIDATION_INFO : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_VALIDATION_INFO : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_VALIDATION_INFO : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_VALIDATION_INFO : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_WO_TO_REMOTE_DB : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_WO_TO_REMOTE_DB : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_WO_TO_REMOTE_DB : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_WO_TO_REMOTE_DB : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_WORK_COUNT_TABLE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_WORK_COUNT_TABLE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_WORK_COUNT_TABLE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_WORK_COUNT_TABLE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_WORK_ORDER_HEADER : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_WORK_ORDER_HEADER : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_WORK_ORDER_HEADER : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_WORK_ORDER_HEADER : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_WORK_ORDER_STATUS_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_WORK_ORDER_STATUS_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_WORK_ORDER_STATUS_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_WORK_ORDER_STATUS_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_WORK_ORDER_STATUS_CONTROL : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_WORK_ORDER_STATUS_CONTROL : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_WORK_ORDER_STATUS_CONTROL : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_WORK_ORDER_STATUS_CONTROL : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_WORK_ORDER_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_WORK_ORDER_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_WORK_ORDER_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_WORK_ORDER_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_INV_TO_REMOTE_DB : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_INV_TO_REMOTE_DB : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_INV_TO_REMOTE_DB : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_INV_TO_REMOTE_DB : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table SHR_REMOTE_DATABASE_ID : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table SHR_REMOTE_DATABASE_ID : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table SHR_REMOTE_DATABASE_ID : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table SHR_REMOTE_DATABASE_ID : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_IMAGE_REASON_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_IMAGE_REASON_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_IMAGE_REASON_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_IMAGE_REASON_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_FIELD_WORK_IMAGES : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_FIELD_WORK_IMAGES : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_FIELD_WORK_IMAGES : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_FIELD_WORK_IMAGES : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_REPAIR_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_REPAIR_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_REPAIR_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_REPAIR_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_REPAIR_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_REPAIR_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_REPAIR_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_REPAIR_HISTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_REGISTER_READ_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_REGISTER_READ_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_REGISTER_READ_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_REGISTER_READ_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_EQUIPMENT_ASSEMBLY_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_EQUIPMENT_ASSEMBLY_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_EQUIPMENT_ASSEMBLY_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_EQUIPMENT_ASSEMBLY_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SUBSTITUTE_ASSEMBLY_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SUBSTITUTE_ASSEMBLY_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SUBSTITUTE_ASSEMBLY_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SUBSTITUTE_ASSEMBLY_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_FW_TWO_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_FW_TWO_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_FW_TWO_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_FW_TWO_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_FW_ONE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_FW_ONE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_FW_ONE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_FW_ONE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SI_ONE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SI_ONE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SI_ONE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SI_ONE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SI_TWO_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SI_TWO_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SI_TWO_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SI_TWO_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SI_THREE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SI_THREE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SI_THREE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SI_THREE_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SI_SIX_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SI_SIX_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SI_SIX_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SI_SIX_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SI_SEVEN_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SI_SEVEN_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SI_SEVEN_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SI_SEVEN_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_SI_EIGHT_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_SI_EIGHT_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_SI_EIGHT_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_SI_EIGHT_USER_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_PREMISE_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_PREMISE_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_PREMISE_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_PREMISE_TYPE_CODE : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_EAC_VOLTAGE_LOOKUP : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_EAC_VOLTAGE_LOOKUP : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_EAC_VOLTAGE_LOOKUP : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_EAC_VOLTAGE_LOOKUP : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_PRIMARY_INVENTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_PRIMARY_INVENTORY : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_PRIMARY_INVENTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_PRIMARY_INVENTORY : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for delete from table REP_TASK_RESPONSE_AUDIT : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded for insert/update from table REP_TASK_RESPONSE_AUDIT : 0 I. 2016-02-06 16:26:51. <1> # rows filtered for download from table REP_TASK_RESPONSE_AUDIT : 0 I. 2016-02-06 16:26:51. <1> # rows downloaded to remote from table REP_TASK_RESPONSE_AUDIT : 0 I. 2016-02-06 16:26:51. <1> download_statistics REP_APPOINTMENT_HISTORY (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_APPOINTMENT_TIME_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_BLACKOUT_SCHEDULE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_CLASS_TO_CLASS_GROUP_ID (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_DEVICE_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_FIELD_WORK_HISTORY (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_FUNCTION_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_GPS (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_LABOR_CLASSIFICATION_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_MFG_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_OBSERVATION_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_OBSERVATION_HISTORY (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_ROUTE_SELECT_METHOD_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_ROUTE_SUMMARY (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SAFETY_MESSAGE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SECURITY_ID_FUNCT_ASSIGN (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SECURITY_ID (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SITE_INFO_NOTES (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SITE_INFO (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SPECIAL_INSTRUCTION_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SPECIAL_INSTRUCTIONS (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_TELEPHONE_LOOKUP (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_VALIDATION_INFO (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_WO_TO_REMOTE_DB (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_WORK_COUNT_TABLE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_WORK_ORDER_HEADER (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_WORK_ORDER_STATUS_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_WORK_ORDER_STATUS_CONTROL (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_WORK_ORDER_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_INV_TO_REMOTE_DB (no script) I. 2016-02-06 16:26:51. <1> download_statistics SHR_REMOTE_DATABASE_ID (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_IMAGE_REASON_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_FIELD_WORK_IMAGES (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_REPAIR_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_REPAIR_HISTORY (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_REGISTER_READ_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_EQUIPMENT_ASSEMBLY_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SUBSTITUTE_ASSEMBLY_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_FW_TWO_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_FW_ONE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SI_ONE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SI_TWO_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SI_THREE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SI_SIX_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SI_SEVEN_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_SI_EIGHT_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_PREMISE_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_EAC_VOLTAGE_LOOKUP (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_PRIMARY_INVENTORY (no script) I. 2016-02-06 16:26:51. <1> download_statistics REP_TASK_RESPONSE_AUDIT (no script) I. 2016-02-06 16:26:51. <1> download_statistics <connection> (no script) I. 2016-02-06 16:26:51. <1> Sending the download to the remote database I. 2016-02-06 16:26:51. <1> COMMIT Transaction: Download I. 2016-02-06 16:26:51. <1> System event on synchronization connection: SELECT sync_key FROM ml_database WHERE rid = ? FOR UPDATE NOWAIT I. 2016-02-06 16:26:51. <1> Translated SQL: SELECT sync_key FROM ml_database WHERE rid = :p1 FOR UPDATE NOWAIT I. 2016-02-06 16:26:51. <1> end_publication <connection> (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_APPOINTMENT_HISTORY (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_APPOINTMENT_TIME_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_BLACKOUT_SCHEDULE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_CLASS_TO_CLASS_GROUP_ID (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_DEVICE_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_FIELD_WORK_HISTORY (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_FUNCTION_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_GPS (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_LABOR_CLASSIFICATION_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_MFG_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_OBSERVATION_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_OBSERVATION_HISTORY (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_ROUTE_SELECT_METHOD_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_ROUTE_SUMMARY (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SAFETY_MESSAGE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SECURITY_ID_FUNCT_ASSIGN (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SECURITY_ID (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SITE_INFO_NOTES (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SITE_INFO (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SPECIAL_INSTRUCTION_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SPECIAL_INSTRUCTIONS (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_TELEPHONE_LOOKUP (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_VALIDATION_INFO (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_WO_TO_REMOTE_DB (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_WORK_COUNT_TABLE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_WORK_ORDER_HEADER (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_WORK_ORDER_STATUS_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_WORK_ORDER_STATUS_CONTROL (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_WORK_ORDER_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_INV_TO_REMOTE_DB (no script) I. 2016-02-06 16:26:51. <1> end_synchronization SHR_REMOTE_DATABASE_ID (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_IMAGE_REASON_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_FIELD_WORK_IMAGES (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_REPAIR_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_REPAIR_HISTORY (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_REGISTER_READ_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_EQUIPMENT_ASSEMBLY_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SUBSTITUTE_ASSEMBLY_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_FW_TWO_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_FW_ONE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SI_ONE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SI_TWO_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SI_THREE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SI_SIX_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SI_SEVEN_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_SI_EIGHT_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_PREMISE_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_EAC_VOLTAGE_LOOKUP (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_PRIMARY_INVENTORY (no script) I. 2016-02-06 16:26:51. <1> end_synchronization REP_TASK_RESPONSE_AUDIT (no script) I. 2016-02-06 16:26:51. <1> end_synchronization <connection> --call proc BEGIN SERVANY.PRC_REPLICATION_COMPLETE({ml s.username}, {ml s.synchronization_ok}); END; I. 2016-02-06 16:26:51. <1> System variable username value: FE_PAULA I. 2016-02-06 16:26:51. <1> System variable synchronization_ok value: 1 I. 2016-02-06 16:26:51. <1> Translated SQL: BEGIN SERVANY.PRC_REPLICATION_COMPLETE( :p1, :p2); END; I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_APPOINTMENT_HISTORY (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_APPOINTMENT_TIME_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_BLACKOUT_SCHEDULE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_CLASS_TO_CLASS_GROUP_ID (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_DEVICE_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_FIELD_WORK_HISTORY (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_FUNCTION_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_GPS (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_LABOR_CLASSIFICATION_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_MFG_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_OBSERVATION_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_OBSERVATION_HISTORY (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_ROUTE_SELECT_METHOD_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_ROUTE_SUMMARY (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SAFETY_MESSAGE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SECURITY_ID_FUNCT_ASSIGN (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SECURITY_ID (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SITE_INFO_NOTES (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SITE_INFO (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SPECIAL_INSTRUCTION_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SPECIAL_INSTRUCTIONS (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_TELEPHONE_LOOKUP (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_VALIDATION_INFO (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_WO_TO_REMOTE_DB (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_WORK_COUNT_TABLE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_WORK_ORDER_HEADER (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_WORK_ORDER_STATUS_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_WORK_ORDER_STATUS_CONTROL (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_WORK_ORDER_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_INV_TO_REMOTE_DB (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics SHR_REMOTE_DATABASE_ID (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_IMAGE_REASON_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_FIELD_WORK_IMAGES (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_REPAIR_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_REPAIR_HISTORY (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_REGISTER_READ_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_EQUIPMENT_ASSEMBLY_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SUBSTITUTE_ASSEMBLY_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_FW_TWO_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_FW_ONE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SI_ONE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SI_TWO_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SI_THREE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SI_SIX_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SI_SEVEN_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_SI_EIGHT_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_PREMISE_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_EAC_VOLTAGE_LOOKUP (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_PRIMARY_INVENTORY (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics REP_TASK_RESPONSE_AUDIT (no script) I. 2016-02-06 16:26:51. <1> synchronization_statistics <connection> (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_APPOINTMENT_HISTORY (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_APPOINTMENT_TIME_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_BLACKOUT_SCHEDULE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_CLASS_TO_CLASS_GROUP_ID (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_DEVICE_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_FIELD_WORK_HISTORY (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_FUNCTION_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_GPS (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_LABOR_CLASSIFICATION_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_MFG_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_OBSERVATION_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_OBSERVATION_HISTORY (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_ROUTE_SELECT_METHOD_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_ROUTE_SUMMARY (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SAFETY_MESSAGE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SECURITY_ID_FUNCT_ASSIGN (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SECURITY_ID (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SITE_INFO_NOTES (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SITE_INFO (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SPECIAL_INSTRUCTION_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SPECIAL_INSTRUCTIONS (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_TELEPHONE_LOOKUP (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_VALIDATION_INFO (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_WO_TO_REMOTE_DB (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_WORK_COUNT_TABLE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_WORK_ORDER_HEADER (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_WORK_ORDER_STATUS_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_WORK_ORDER_STATUS_CONTROL (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_WORK_ORDER_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_INV_TO_REMOTE_DB (no script) I. 2016-02-06 16:26:51. <1> time_statistics SHR_REMOTE_DATABASE_ID (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_IMAGE_REASON_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_FIELD_WORK_IMAGES (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_REPAIR_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_REPAIR_HISTORY (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_REGISTER_READ_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_EQUIPMENT_ASSEMBLY_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SUBSTITUTE_ASSEMBLY_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_FW_TWO_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_FW_ONE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SI_ONE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SI_TWO_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SI_THREE_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SI_SIX_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SI_SEVEN_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_SI_EIGHT_USER_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_PREMISE_TYPE_CODE (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_EAC_VOLTAGE_LOOKUP (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_PRIMARY_INVENTORY (no script) I. 2016-02-06 16:26:51. <1> time_statistics REP_TASK_RESPONSE_AUDIT (no script) I. 2016-02-06 16:26:51. <1> time_statistics <connection> (no script) I. 2016-02-06 16:26:51. <1> COMMIT Transaction: End synchronization E. 2016-02-06 16:26:55. <1> [-10410] The client failed to send a complete sequence of commands I. 2016-02-06 16:26:55. <1> Synchronization failed
The synchronization_ok parameter that is passed to the end_synchronization connection event only tracks whether the synchronization was successfull from the perspective of the MobiLink Server. Once the download stream has been written to the wire, the ML Server is finished, with the exception of possibly waiting for the download acknowledgement, so calling the end_synchronization connection event before the download is actually applied at the remote is expected. As it looks like you've discovered, it's the nonblocking_download_ack connection event that you want to define to see whether the client successfully applied the download.
I don't know why you can't define the nonblocking_download_ack connection event in Sybase Central. It's likely a bug that it should have been added to the list of connection level events, and not table level events. For now, the following SQL worked for me when executed against the consolidated database, and you can modify the code below to suit your needs.
create procedure nbda ( in @id varchar(128), in @user varchar(128), in @ld timestamp, in @sv varchar(128) ) begin message ' ID: ' || @id; message 'USER: ' || @user; message ' LD: ' || @ld; message ' SV: ' || @sv; end; call ml_add_connection_script( 'v16', 'nonblocking_download_ack', 'call nbda({ml s.remote_id}, {ml s.username},{ml s.last_download}, {ml s.script_version})' );
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I'm guessing this "Synchronization failed" symptom is MobiLink's version of "Did you remember to turn the iron off before we left home this morning?"... i.e., nothing to worry about.
Did the subsequent synchronization repeat the download? That would happen if the previous sync really did "fail".
Is this symptom repeating with every synchronization, or was if a one-time thing?
After a sync is possible to query the MobiLink ml_* tables on the consolidated database, and the SYS* tables on the remote database, to determine if the sync "really worked" or not. One moment while I go and look for them... 🙂
...oops, it's UltraLite, no client-side SYS* tables... one moment...
With a SQL Anywhere client dbmlsync, if the SendDownloadAck option is ON, the MobiLink consolidated database column ml_subscription.last_download_time column will be filled in after a successful download:
"%SQLANY16%\\bin64\\dbmlsync.exe"^ -c "ENG=remo;DBN=remo;UID=REMOTE_DBA;PWD=SQL"^ -e "adr='host=localhost';sv=v1;SendDownloadAck=ON"^ -o dbmlsync_log_remo.txt^ -os 10M^ -vnosu^ -x SELECT * FROM ml_subscription; rid,subscription_id,user_id,progress,publication_name,last_upload_time,last_download_time 1,'2',1,678617,'p1','2016-02-07 13:03:16.235','2016-02-07 13:03:16.236'
For the UltraLite client ulsync, there is a SendDownloadACK option that may have the same effect; for example:
ulsync -c DBF=myuldb.udb "MobiLinkUid=remoteA;ScriptVersion=2;SendDownloadACK=true;Stream=http"
Caveat Emptor: I have not tested it with UltraLite.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you for the information.
I modified my code to send the download acknowledgement and that is working. I tried to define a connection level nonblocking_download_ack event as described here: link Doc Exchange but Sybase Central does not have that option in the UI. I noticed a nonblocking_download_ack event for the table so I defined it there. This produces the following error
[-10207] Unrecognized event name: nonblocking_download_ack
Not sure what to try next...
User | Count |
---|---|
66 | |
11 | |
10 | |
10 | |
9 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.