2014-11-18 15:57:52,884 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2014-11-18 15:57:52,886 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML} 2014-11-18 16:00:53,729 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2014-11-18 16:00:53,731 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML} 2014-11-18 16:00:54,209 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'Adaptive Server Enterprise', version '16', protocol 'sybase' 2014-11-18 16:00:54,335 WARN [] [AbstractDatabaseWriter] [main] Did not find the item table in the target database 2014-11-18 16:00:54,352 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2014-11-18 16:00:54,444 WARN [] [AbstractDatabaseWriter] [main] Did not find the item_selling_price table in the target database 2014-11-18 16:00:54,464 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2014-11-18 16:00:54,490 WARN [] [AbstractDatabaseWriter] [main] Did not find the sale_transaction table in the target database 2014-11-18 16:00:54,498 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2014-11-18 16:00:54,515 WARN [] [AbstractDatabaseWriter] [main] Did not find the sale_return_line_item table in the target database 2014-11-18 16:00:54,525 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition:
2014-11-18 16:01:13,812 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2014-11-18 16:01:14,279 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Adaptive Server Enterprise', version '16', protocol 'sybase' 2014-11-18 16:01:14,370 INFO [corp-000] [AseSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.ase.AseSymmetricDialect 2014-11-18 16:01:14,386 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: C:\Users\PhatHC\Desktop\sybase\symmetric-3.6.13\tmp\corp-000 2014-11-18 16:01:14,444 INFO [corp-000] [ClusterService] [main] This node picked a server id of 301PHATHC 2014-11-18 16:01:15,498 INFO [corp-000] [ExtensionPointManager] [main] Found 9 extension points that will be registered 2014-11-18 16:01:15,505 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database 2014-11-18 16:01:15,506 INFO [corp-000] [AseSymmetricDialect] [main] Checking if SymmetricDS tables need created or altered 2014-11-18 16:01:15,851 INFO [corp-000] [AseSymmetricDialect] [main] There are SymmetricDS tables that needed altered 2014-11-18 16:01:15,876 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:15,878 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:15,929 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_channel( channel_id VARCHAR(128) NOT NULL, processing_order NUMERIC(12,0) DEFAULT 1 NOT NULL, max_batch_size NUMERIC(12,0) DEFAULT 1000 NOT NULL, max_batch_to_send NUMERIC(12,0) DEFAULT 60 NOT NULL, max_data_to_route NUMERIC(12,0) DEFAULT 100000 NOT NULL, extract_period_millis NUMERIC(12,0) DEFAULT 0 NOT NULL, enabled SMALLINT DEFAULT 1 NOT NULL, use_old_data_to_route SMALLINT DEFAULT 1 NOT NULL, use_row_data_to_route SMALLINT DEFAULT 1 NOT NULL, use_pk_data_to_route SMALLINT DEFAULT 1 NOT NULL, reload_flag SMALLINT DEFAULT 0 NOT NULL, file_sync_flag SMALLINT DEFAULT 0 NOT NULL, contains_big_lob SMALLINT DEFAULT 0 NOT NULL, batch_algorithm VARCHAR(50) DEFAULT 'default' NOT NULL, data_loader_type VARCHAR(50) DEFAULT 'default' NOT NULL, description VARCHAR(255) NULL, create_time DATETIME NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NULL, PRIMARY KEY (channel_id) ) 2014-11-18 16:01:15,931 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:15,952 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_conflict( conflict_id VARCHAR(50) NOT NULL, source_node_group_id VARCHAR(50) NOT NULL, target_node_group_id VARCHAR(50) NOT NULL, target_channel_id VARCHAR(128) NULL, target_catalog_name VARCHAR(255) NULL, target_schema_name VARCHAR(255) NULL, target_table_name VARCHAR(255) NULL, detect_type VARCHAR(128) NOT NULL, detect_expression TEXT NULL, resolve_type VARCHAR(128) NOT NULL, ping_back VARCHAR(128) NOT NULL, resolve_changes_only SMALLINT DEFAULT 0 NULL, resolve_row_only SMALLINT DEFAULT 0 NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (conflict_id) ) 2014-11-18 16:01:15,953 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:15,971 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_data( data_id NUMERIC(18,0) IDENTITY, table_name VARCHAR(255) NOT NULL, event_type CHAR(1) NOT NULL, row_data TEXT NULL, pk_data TEXT NULL, old_data TEXT NULL, trigger_hist_id NUMERIC(12,0) NOT NULL, channel_id VARCHAR(128) NULL, transaction_id VARCHAR(255) NULL, source_node_id VARCHAR(50) NULL, external_data VARCHAR(50) NULL, node_list VARCHAR(255) NULL, create_time DATETIME NULL, PRIMARY KEY (data_id) ) 2014-11-18 16:01:15,975 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_d_channel_id ON sym_data (data_id, channel_id) 2014-11-18 16:01:15,976 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:15,985 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_data_event( data_id NUMERIC(18,0) NOT NULL, batch_id NUMERIC(18,0) NOT NULL, router_id VARCHAR(50) NOT NULL, create_time DATETIME NULL, PRIMARY KEY (data_id, batch_id, router_id) ) 2014-11-18 16:01:15,989 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_de_batchid ON sym_data_event (batch_id) 2014-11-18 16:01:15,989 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:15,996 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_data_gap( start_id NUMERIC(18,0) NOT NULL, end_id NUMERIC(18,0) NOT NULL, status CHAR(2) NULL, create_time DATETIME NOT NULL, last_update_hostname VARCHAR(255) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (start_id, end_id) ) 2014-11-18 16:01:15,998 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_dg_status ON sym_data_gap (status) 2014-11-18 16:01:15,999 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,005 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_extract_request( request_id NUMERIC(18,0) NOT NULL, node_id VARCHAR(50) NOT NULL, status CHAR(2) NULL, start_batch_id NUMERIC(18,0) NOT NULL, end_batch_id NUMERIC(18,0) NOT NULL, trigger_id VARCHAR(128) NOT NULL, router_id VARCHAR(50) NOT NULL, last_update_time DATETIME NULL, create_time DATETIME NULL, PRIMARY KEY (request_id) ) 2014-11-18 16:01:16,006 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,012 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_file_incoming( relative_dir VARCHAR(255) NOT NULL, file_name VARCHAR(128) NOT NULL, last_event_type CHAR(1) NOT NULL, node_id VARCHAR(50) NOT NULL, file_modified_time NUMERIC(18,0) NULL, PRIMARY KEY (relative_dir, file_name) ) 2014-11-18 16:01:16,014 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,023 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_file_snapshot( trigger_id VARCHAR(128) NOT NULL, router_id VARCHAR(50) NOT NULL, relative_dir VARCHAR(255) NOT NULL, file_name VARCHAR(128) NOT NULL, channel_id VARCHAR(128) DEFAULT 'filesync' NOT NULL, reload_channel_id VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL, last_event_type CHAR(1) NOT NULL, crc32_checksum NUMERIC(18,0) NULL, file_size NUMERIC(18,0) NULL, file_modified_time NUMERIC(18,0) NULL, last_update_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, create_time DATETIME NOT NULL, PRIMARY KEY (trigger_id, router_id, relative_dir, file_name) ) 2014-11-18 16:01:16,025 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_f_snpsht_chid ON sym_file_snapshot (reload_channel_id) 2014-11-18 16:01:16,026 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,040 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_file_trigger( trigger_id VARCHAR(128) NOT NULL, channel_id VARCHAR(128) DEFAULT 'filesync' NOT NULL, reload_channel_id VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL, base_dir VARCHAR(255) NOT NULL, recurse SMALLINT DEFAULT 1 NOT NULL, includes_files VARCHAR(255) NULL, excludes_files VARCHAR(255) NULL, sync_on_create SMALLINT DEFAULT 1 NOT NULL, sync_on_modified SMALLINT DEFAULT 1 NOT NULL, sync_on_delete SMALLINT DEFAULT 1 NOT NULL, sync_on_ctl_file SMALLINT DEFAULT 0 NOT NULL, delete_after_sync SMALLINT DEFAULT 0 NOT NULL, before_copy_script TEXT NULL, after_copy_script TEXT NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (trigger_id) ) 2014-11-18 16:01:16,041 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,049 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_file_trigger_router( trigger_id VARCHAR(128) NOT NULL, router_id VARCHAR(50) NOT NULL, enabled SMALLINT DEFAULT 1 NOT NULL, initial_load_enabled SMALLINT DEFAULT 1 NOT NULL, target_base_dir VARCHAR(255) NULL, conflict_strategy VARCHAR(128) DEFAULT 'source_wins' NOT NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (trigger_id, router_id) ) 2014-11-18 16:01:16,051 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,056 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_grouplet( grouplet_id VARCHAR(50) NOT NULL, grouplet_link_policy CHAR(1) DEFAULT 'I' NOT NULL, description VARCHAR(255) NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (grouplet_id) ) 2014-11-18 16:01:16,057 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,062 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_grouplet_link( grouplet_id VARCHAR(50) NOT NULL, external_id VARCHAR(50) NOT NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (grouplet_id, external_id) ) 2014-11-18 16:01:16,063 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,084 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_incoming_batch( batch_id NUMERIC(18,0) NOT NULL, node_id VARCHAR(50) NOT NULL, channel_id VARCHAR(128) NULL, status CHAR(2) NULL, error_flag SMALLINT DEFAULT 0 NULL, network_millis NUMERIC(18,0) DEFAULT 0 NOT NULL, filter_millis NUMERIC(18,0) DEFAULT 0 NOT NULL, database_millis NUMERIC(18,0) DEFAULT 0 NOT NULL, failed_row_number NUMERIC(18,0) DEFAULT 0 NOT NULL, failed_line_number NUMERIC(18,0) DEFAULT 0 NOT NULL, byte_count NUMERIC(18,0) DEFAULT 0 NOT NULL, statement_count NUMERIC(18,0) DEFAULT 0 NOT NULL, fallback_insert_count NUMERIC(18,0) DEFAULT 0 NOT NULL, fallback_update_count NUMERIC(18,0) DEFAULT 0 NOT NULL, ignore_count NUMERIC(18,0) DEFAULT 0 NOT NULL, missing_delete_count NUMERIC(18,0) DEFAULT 0 NOT NULL, skip_count NUMERIC(18,0) DEFAULT 0 NOT NULL, sql_state VARCHAR(10) NULL, sql_code NUMERIC(12,0) DEFAULT 0 NOT NULL, sql_message TEXT NULL, last_update_hostname VARCHAR(255) NULL, last_update_time DATETIME NULL, create_time DATETIME NULL, PRIMARY KEY (batch_id, node_id) ) 2014-11-18 16:01:16,087 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_ib_time_status ON sym_incoming_batch (create_time, status) 2014-11-18 16:01:16,089 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_ib_in_error ON sym_incoming_batch (error_flag) 2014-11-18 16:01:16,089 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,126 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_incoming_error( batch_id NUMERIC(18,0) NOT NULL, node_id VARCHAR(50) NOT NULL, failed_row_number NUMERIC(18,0) NOT NULL, failed_line_number NUMERIC(18,0) DEFAULT 0 NOT NULL, target_catalog_name VARCHAR(255) NULL, target_schema_name VARCHAR(255) NULL, target_table_name VARCHAR(255) NOT NULL, event_type CHAR(1) NOT NULL, binary_encoding VARCHAR(10) DEFAULT 'HEX' NOT NULL, column_names TEXT NOT NULL, pk_column_names TEXT NOT NULL, row_data TEXT NULL, old_data TEXT NULL, cur_data TEXT NULL, resolve_data TEXT NULL, resolve_ignore SMALLINT DEFAULT 0 NULL, conflict_id VARCHAR(50) NULL, create_time DATETIME NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (batch_id, node_id, failed_row_number) ) 2014-11-18 16:01:16,127 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,141 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_load_filter( load_filter_id VARCHAR(50) NOT NULL, load_filter_type VARCHAR(10) NOT NULL, source_node_group_id VARCHAR(50) NOT NULL, target_node_group_id VARCHAR(50) NOT NULL, target_catalog_name VARCHAR(255) NULL, target_schema_name VARCHAR(255) NULL, target_table_name VARCHAR(255) NULL, filter_on_update SMALLINT DEFAULT 1 NOT NULL, filter_on_insert SMALLINT DEFAULT 1 NOT NULL, filter_on_delete SMALLINT DEFAULT 1 NOT NULL, before_write_script TEXT NULL, after_write_script TEXT NULL, batch_complete_script TEXT NULL, batch_commit_script TEXT NULL, batch_rollback_script TEXT NULL, handle_error_script TEXT NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, load_filter_order NUMERIC(12,0) DEFAULT 1 NOT NULL, fail_on_error SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY (load_filter_id) ) 2014-11-18 16:01:16,145 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,167 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_lock( lock_action VARCHAR(50) NOT NULL, lock_type VARCHAR(50) NOT NULL, locking_server_id VARCHAR(255) NULL, lock_time DATETIME NULL, shared_count NUMERIC(12,0) DEFAULT 0 NOT NULL, shared_enable NUMERIC(12,0) DEFAULT 0 NOT NULL, last_lock_time DATETIME NULL, last_locking_server_id VARCHAR(255) NULL, PRIMARY KEY (lock_action) ) 2014-11-18 16:01:16,168 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,178 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node( node_id VARCHAR(50) NOT NULL, node_group_id VARCHAR(50) NOT NULL, external_id VARCHAR(50) NOT NULL, sync_enabled SMALLINT DEFAULT 0 NULL, sync_url VARCHAR(255) NULL, schema_version VARCHAR(50) NULL, symmetric_version VARCHAR(50) NULL, database_type VARCHAR(50) NULL, database_version VARCHAR(50) NULL, heartbeat_time DATETIME NULL, timezone_offset VARCHAR(6) NULL, batch_to_send_count NUMERIC(12,0) DEFAULT 0 NULL, batch_in_error_count NUMERIC(12,0) DEFAULT 0 NULL, created_at_node_id VARCHAR(50) NULL, deployment_type VARCHAR(50) NULL, PRIMARY KEY (node_id) ) 2014-11-18 16:01:16,180 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,212 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_communication( node_id VARCHAR(50) NOT NULL, communication_type VARCHAR(10) NOT NULL, lock_time DATETIME NULL, locking_server_id VARCHAR(255) NULL, last_lock_time DATETIME NULL, last_lock_millis NUMERIC(18,0) DEFAULT 0 NULL, success_count NUMERIC(18,0) DEFAULT 0 NULL, fail_count NUMERIC(18,0) DEFAULT 0 NULL, total_success_count NUMERIC(18,0) DEFAULT 0 NULL, total_fail_count NUMERIC(18,0) DEFAULT 0 NULL, total_success_millis NUMERIC(18,0) DEFAULT 0 NULL, total_fail_millis NUMERIC(18,0) DEFAULT 0 NULL, PRIMARY KEY (node_id, communication_type) ) 2014-11-18 16:01:16,213 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,233 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_channel_ctl( node_id VARCHAR(50) NOT NULL, channel_id VARCHAR(128) NOT NULL, suspend_enabled SMALLINT DEFAULT 0 NULL, ignore_enabled SMALLINT DEFAULT 0 NULL, last_extract_time DATETIME NULL, PRIMARY KEY (node_id, channel_id) ) 2014-11-18 16:01:16,235 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,240 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_group( node_group_id VARCHAR(50) NOT NULL, description VARCHAR(255) NULL, create_time DATETIME NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NULL, PRIMARY KEY (node_group_id) ) 2014-11-18 16:01:16,241 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,247 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_group_channel_wnd( node_group_id VARCHAR(50) NOT NULL, channel_id VARCHAR(128) NOT NULL, start_time DATETIME NOT NULL, end_time DATETIME NOT NULL, enabled SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY (node_group_id, channel_id, start_time, end_time) ) 2014-11-18 16:01:16,249 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,256 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_group_link( source_node_group_id VARCHAR(50) NOT NULL, target_node_group_id VARCHAR(50) NOT NULL, data_event_action CHAR(1) DEFAULT 'W' NOT NULL, sync_config_enabled SMALLINT DEFAULT 1 NOT NULL, create_time DATETIME NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NULL, PRIMARY KEY (source_node_group_id, target_node_group_id) ) 2014-11-18 16:01:16,257 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,270 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_host( node_id VARCHAR(50) NOT NULL, host_name VARCHAR(60) NOT NULL, ip_address VARCHAR(50) NULL, os_user VARCHAR(50) NULL, os_name VARCHAR(50) NULL, os_arch VARCHAR(50) NULL, os_version VARCHAR(50) NULL, available_processors NUMERIC(12,0) DEFAULT 0 NULL, free_memory_bytes NUMERIC(18,0) DEFAULT 0 NULL, total_memory_bytes NUMERIC(18,0) DEFAULT 0 NULL, max_memory_bytes NUMERIC(18,0) DEFAULT 0 NULL, java_version VARCHAR(50) NULL, java_vendor VARCHAR(255) NULL, jdbc_version VARCHAR(255) NULL, symmetric_version VARCHAR(50) NULL, timezone_offset VARCHAR(6) NULL, heartbeat_time DATETIME NULL, last_restart_time DATETIME NOT NULL, create_time DATETIME NOT NULL, PRIMARY KEY (node_id, host_name) ) 2014-11-18 16:01:16,271 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,286 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_host_channel_stats( node_id VARCHAR(50) NOT NULL, host_name VARCHAR(60) NOT NULL, channel_id VARCHAR(128) NOT NULL, start_time DATETIME NOT NULL, end_time DATETIME NOT NULL, data_routed NUMERIC(18,0) DEFAULT 0 NULL, data_unrouted NUMERIC(18,0) DEFAULT 0 NULL, data_event_inserted NUMERIC(18,0) DEFAULT 0 NULL, data_extracted NUMERIC(18,0) DEFAULT 0 NULL, data_bytes_extracted NUMERIC(18,0) DEFAULT 0 NULL, data_extracted_errors NUMERIC(18,0) DEFAULT 0 NULL, data_bytes_sent NUMERIC(18,0) DEFAULT 0 NULL, data_sent NUMERIC(18,0) DEFAULT 0 NULL, data_sent_errors NUMERIC(18,0) DEFAULT 0 NULL, data_loaded NUMERIC(18,0) DEFAULT 0 NULL, data_bytes_loaded NUMERIC(18,0) DEFAULT 0 NULL, data_loaded_errors NUMERIC(18,0) DEFAULT 0 NULL, PRIMARY KEY (node_id, host_name, channel_id, start_time, end_time) ) 2014-11-18 16:01:16,289 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_nd_hst_chnl_sts ON sym_node_host_channel_stats (node_id, start_time, end_time) 2014-11-18 16:01:16,289 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,296 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_host_job_stats( node_id VARCHAR(50) NOT NULL, host_name VARCHAR(60) NOT NULL, job_name VARCHAR(50) NOT NULL, start_time DATETIME NOT NULL, end_time DATETIME NOT NULL, processed_count NUMERIC(18,0) DEFAULT 0 NULL, PRIMARY KEY (node_id, host_name, job_name, start_time, end_time) ) 2014-11-18 16:01:16,299 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_nd_hst_job ON sym_node_host_job_stats (node_id, start_time, end_time) 2014-11-18 16:01:16,300 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,325 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_host_stats( node_id VARCHAR(50) NOT NULL, host_name VARCHAR(60) NOT NULL, start_time DATETIME NOT NULL, end_time DATETIME NOT NULL, restarted NUMERIC(18,0) DEFAULT 0 NOT NULL, nodes_pulled NUMERIC(18,0) DEFAULT 0 NULL, total_nodes_pull_time NUMERIC(18,0) DEFAULT 0 NULL, nodes_pushed NUMERIC(18,0) DEFAULT 0 NULL, total_nodes_push_time NUMERIC(18,0) DEFAULT 0 NULL, nodes_rejected NUMERIC(18,0) DEFAULT 0 NULL, nodes_registered NUMERIC(18,0) DEFAULT 0 NULL, nodes_loaded NUMERIC(18,0) DEFAULT 0 NULL, nodes_disabled NUMERIC(18,0) DEFAULT 0 NULL, purged_data_rows NUMERIC(18,0) DEFAULT 0 NULL, purged_data_event_rows NUMERIC(18,0) DEFAULT 0 NULL, purged_batch_outgoing_rows NUMERIC(18,0) DEFAULT 0 NULL, purged_batch_incoming_rows NUMERIC(18,0) DEFAULT 0 NULL, triggers_created_count NUMERIC(18,0) NULL, triggers_rebuilt_count NUMERIC(18,0) NULL, triggers_removed_count NUMERIC(18,0) NULL, PRIMARY KEY (node_id, host_name, start_time, end_time) ) 2014-11-18 16:01:16,341 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_nd_hst_sts ON sym_node_host_stats (node_id, start_time, end_time) 2014-11-18 16:01:16,342 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,348 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_identity( node_id VARCHAR(50) NOT NULL, PRIMARY KEY (node_id) ) 2014-11-18 16:01:16,349 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,359 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_node_security( node_id VARCHAR(50) NOT NULL, node_password VARCHAR(50) NOT NULL, registration_enabled SMALLINT DEFAULT 0 NULL, registration_time DATETIME NULL, initial_load_enabled SMALLINT DEFAULT 0 NULL, initial_load_time DATETIME NULL, initial_load_id NUMERIC(18,0) NULL, initial_load_create_by VARCHAR(255) NULL, rev_initial_load_enabled SMALLINT DEFAULT 0 NULL, rev_initial_load_time DATETIME NULL, rev_initial_load_id NUMERIC(18,0) NULL, rev_initial_load_create_by VARCHAR(255) NULL, created_at_node_id VARCHAR(50) NULL, PRIMARY KEY (node_id) ) 2014-11-18 16:01:16,360 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,410 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_outgoing_batch( batch_id NUMERIC(18,0) NOT NULL, node_id VARCHAR(50) NOT NULL, channel_id VARCHAR(128) NULL, status CHAR(2) NULL, load_id NUMERIC(18,0) NULL, extract_job_flag SMALLINT DEFAULT 0 NULL, load_flag SMALLINT DEFAULT 0 NULL, error_flag SMALLINT DEFAULT 0 NULL, common_flag SMALLINT DEFAULT 0 NULL, ignore_count NUMERIC(18,0) DEFAULT 0 NOT NULL, byte_count NUMERIC(18,0) DEFAULT 0 NOT NULL, extract_count NUMERIC(18,0) DEFAULT 0 NOT NULL, sent_count NUMERIC(18,0) DEFAULT 0 NOT NULL, load_count NUMERIC(18,0) DEFAULT 0 NOT NULL, data_event_count NUMERIC(18,0) DEFAULT 0 NOT NULL, reload_event_count NUMERIC(18,0) DEFAULT 0 NOT NULL, insert_event_count NUMERIC(18,0) DEFAULT 0 NOT NULL, update_event_count NUMERIC(18,0) DEFAULT 0 NOT NULL, delete_event_count NUMERIC(18,0) DEFAULT 0 NOT NULL, other_event_count NUMERIC(18,0) DEFAULT 0 NOT NULL, router_millis NUMERIC(18,0) DEFAULT 0 NOT NULL, network_millis NUMERIC(18,0) DEFAULT 0 NOT NULL, filter_millis NUMERIC(18,0) DEFAULT 0 NOT NULL, load_millis NUMERIC(18,0) DEFAULT 0 NOT NULL, extract_millis NUMERIC(18,0) DEFAULT 0 NOT NULL, sql_state VARCHAR(10) NULL, sql_code NUMERIC(12,0) DEFAULT 0 NOT NULL, sql_message TEXT NULL, failed_data_id NUMERIC(18,0) DEFAULT 0 NOT NULL, failed_line_number NUMERIC(18,0) DEFAULT 0 NOT NULL, last_update_hostname VARCHAR(255) NULL, last_update_time DATETIME NULL, create_time DATETIME NULL, create_by VARCHAR(255) NULL, PRIMARY KEY (batch_id, node_id) ) 2014-11-18 16:01:16,413 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_ob_node_status ON sym_outgoing_batch (node_id, status) 2014-11-18 16:01:16,414 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_ob_status ON sym_outgoing_batch (status) 2014-11-18 16:01:16,416 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_ob_in_error ON sym_outgoing_batch (error_flag) 2014-11-18 16:01:16,417 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,425 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_parameter( external_id VARCHAR(50) NOT NULL, node_group_id VARCHAR(50) NOT NULL, param_key VARCHAR(80) NOT NULL, param_value TEXT NULL, create_time DATETIME NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NULL, PRIMARY KEY (external_id, node_group_id, param_key) ) 2014-11-18 16:01:16,425 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,430 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_registration_redirect( registrant_external_id VARCHAR(50) NOT NULL, registration_node_id VARCHAR(50) NOT NULL, PRIMARY KEY (registrant_external_id) ) 2014-11-18 16:01:16,430 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,437 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_registration_request( node_group_id VARCHAR(50) NOT NULL, external_id VARCHAR(50) NOT NULL, status CHAR(2) NOT NULL, host_name VARCHAR(60) NOT NULL, ip_address VARCHAR(50) NOT NULL, attempt_count NUMERIC(12,0) DEFAULT 0 NULL, registered_node_id VARCHAR(50) NULL, error_message TEXT NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (node_group_id, external_id, create_time) ) 2014-11-18 16:01:16,439 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_reg_req_1 ON sym_registration_request (node_group_id, external_id, status, host_name, ip_address) 2014-11-18 16:01:16,441 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE INDEX sym_idx_reg_req_2 ON sym_registration_request (status) 2014-11-18 16:01:16,441 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,452 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_router( router_id VARCHAR(50) NOT NULL, target_catalog_name VARCHAR(255) NULL, target_schema_name VARCHAR(255) NULL, target_table_name VARCHAR(255) NULL, source_node_group_id VARCHAR(50) NOT NULL, target_node_group_id VARCHAR(50) NOT NULL, router_type VARCHAR(50) NULL, router_expression TEXT NULL, sync_on_update SMALLINT DEFAULT 1 NOT NULL, sync_on_insert SMALLINT DEFAULT 1 NOT NULL, sync_on_delete SMALLINT DEFAULT 1 NOT NULL, use_source_catalog_schema SMALLINT DEFAULT 1 NOT NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (router_id) ) 2014-11-18 16:01:16,453 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,461 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_sequence( sequence_name VARCHAR(50) NOT NULL, current_value NUMERIC(18,0) DEFAULT 0 NOT NULL, increment_by NUMERIC(12,0) DEFAULT 1 NOT NULL, min_value NUMERIC(18,0) DEFAULT 1 NOT NULL, max_value NUMERIC(18,0) DEFAULT 9999999999 NOT NULL, cycle SMALLINT DEFAULT 0 NULL, create_time DATETIME NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (sequence_name) ) 2014-11-18 16:01:16,462 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,468 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_table_reload_request( target_node_id VARCHAR(50) NOT NULL, source_node_id VARCHAR(50) NOT NULL, trigger_id VARCHAR(128) NOT NULL, router_id VARCHAR(50) NOT NULL, reload_select TEXT NULL, reload_delete_stmt TEXT NULL, reload_enabled SMALLINT DEFAULT 0 NULL, reload_time DATETIME NULL, create_time DATETIME NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (target_node_id, source_node_id, trigger_id, router_id) ) 2014-11-18 16:01:16,469 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,480 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_transform_table( transform_id VARCHAR(50) NOT NULL, source_node_group_id VARCHAR(50) NOT NULL, target_node_group_id VARCHAR(50) NOT NULL, transform_point VARCHAR(10) NOT NULL, source_catalog_name VARCHAR(255) NULL, source_schema_name VARCHAR(255) NULL, source_table_name VARCHAR(255) NOT NULL, target_catalog_name VARCHAR(255) NULL, target_schema_name VARCHAR(255) NULL, target_table_name VARCHAR(255) NULL, update_first SMALLINT DEFAULT 0 NULL, delete_action VARCHAR(10) NOT NULL, transform_order NUMERIC(12,0) DEFAULT 1 NOT NULL, column_policy VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL, create_time DATETIME NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NULL, PRIMARY KEY (transform_id, source_node_group_id, target_node_group_id) ) 2014-11-18 16:01:16,482 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,494 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_transform_column( transform_id VARCHAR(50) NOT NULL, include_on CHAR(1) DEFAULT '*' NOT NULL, target_column_name VARCHAR(128) NOT NULL, source_column_name VARCHAR(128) NULL, pk SMALLINT DEFAULT 0 NULL, transform_type VARCHAR(50) DEFAULT 'copy' NULL, transform_expression TEXT NULL, transform_order NUMERIC(12,0) DEFAULT 1 NOT NULL, create_time DATETIME NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NULL, PRIMARY KEY (transform_id, include_on, target_column_name) ) 2014-11-18 16:01:16,496 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,516 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_trigger( trigger_id VARCHAR(128) NOT NULL, source_catalog_name VARCHAR(255) NULL, source_schema_name VARCHAR(255) NULL, source_table_name VARCHAR(255) NOT NULL, channel_id VARCHAR(128) NOT NULL, reload_channel_id VARCHAR(128) DEFAULT 'reload' NOT NULL, sync_on_update SMALLINT DEFAULT 1 NOT NULL, sync_on_insert SMALLINT DEFAULT 1 NOT NULL, sync_on_delete SMALLINT DEFAULT 1 NOT NULL, sync_on_incoming_batch SMALLINT DEFAULT 0 NOT NULL, name_for_update_trigger VARCHAR(255) NULL, name_for_insert_trigger VARCHAR(255) NULL, name_for_delete_trigger VARCHAR(255) NULL, sync_on_update_condition TEXT NULL, sync_on_insert_condition TEXT NULL, sync_on_delete_condition TEXT NULL, custom_on_update_text TEXT NULL, custom_on_insert_text TEXT NULL, custom_on_delete_text TEXT NULL, external_select TEXT NULL, tx_id_expression TEXT NULL, channel_expression TEXT NULL, excluded_column_names TEXT NULL, sync_key_names TEXT NULL, use_stream_lobs SMALLINT DEFAULT 0 NOT NULL, use_capture_lobs SMALLINT DEFAULT 0 NOT NULL, use_capture_old_data SMALLINT DEFAULT 1 NOT NULL, use_handle_key_updates SMALLINT DEFAULT 0 NOT NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (trigger_id) ) 2014-11-18 16:01:16,518 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,527 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_trigger_hist( trigger_hist_id NUMERIC(12,0) NOT NULL, trigger_id VARCHAR(128) NOT NULL, source_table_name VARCHAR(255) NOT NULL, source_catalog_name VARCHAR(255) NULL, source_schema_name VARCHAR(255) NULL, name_for_update_trigger VARCHAR(255) NULL, name_for_insert_trigger VARCHAR(255) NULL, name_for_delete_trigger VARCHAR(255) NULL, table_hash NUMERIC(18,0) DEFAULT 0 NOT NULL, trigger_row_hash NUMERIC(18,0) DEFAULT 0 NOT NULL, trigger_template_hash NUMERIC(18,0) DEFAULT 0 NOT NULL, column_names TEXT NOT NULL, pk_column_names TEXT NOT NULL, last_trigger_build_reason CHAR(1) NOT NULL, error_message TEXT NULL, create_time DATETIME NOT NULL, inactive_time DATETIME NULL, PRIMARY KEY (trigger_hist_id) ) 2014-11-18 16:01:16,529 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,539 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_trigger_router( trigger_id VARCHAR(128) NOT NULL, router_id VARCHAR(50) NOT NULL, enabled SMALLINT DEFAULT 1 NOT NULL, initial_load_order NUMERIC(12,0) DEFAULT 1 NOT NULL, initial_load_select TEXT NULL, initial_load_delete_stmt TEXT NULL, initial_load_batch_count NUMERIC(12,0) DEFAULT 1 NULL, ping_back_enabled SMALLINT DEFAULT 0 NOT NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (trigger_id, router_id) ) 2014-11-18 16:01:16,539 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2014-11-18 16:01:16,545 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: CREATE TABLE sym_trigger_router_grouplet( grouplet_id VARCHAR(50) NOT NULL, trigger_id VARCHAR(128) NOT NULL, router_id VARCHAR(50) NOT NULL, applies_when CHAR(1) NOT NULL, create_time DATETIME NOT NULL, last_update_by VARCHAR(50) NULL, last_update_time DATETIME NOT NULL, PRIMARY KEY (grouplet_id, trigger_id, router_id, applies_when) ) 2014-11-18 16:01:16,546 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_conflict ADD CONSTRAINT sym_fk_cf_2_grp_lnk FOREIGN KEY (source_node_group_id, target_node_group_id) REFERENCES sym_node_group_link (source_node_group_id, target_node_group_id) 2014-11-18 16:01:16,548 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_file_trigger_router ADD CONSTRAINT sym_fk_ftr_2_ftrg FOREIGN KEY (trigger_id) REFERENCES sym_file_trigger (trigger_id) 2014-11-18 16:01:16,552 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_file_trigger_router ADD CONSTRAINT sym_fk_ftr_2_rtr FOREIGN KEY (router_id) REFERENCES sym_router (router_id) 2014-11-18 16:01:16,554 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_grouplet_link ADD CONSTRAINT sym_fk_gpltlnk_2_gplt FOREIGN KEY (grouplet_id) REFERENCES sym_grouplet (grouplet_id) 2014-11-18 16:01:16,555 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_node_group_link ADD CONSTRAINT sym_fk_lnk_2_grp_src FOREIGN KEY (source_node_group_id) REFERENCES sym_node_group (node_group_id) 2014-11-18 16:01:16,556 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_node_group_link ADD CONSTRAINT sym_fk_lnk_2_grp_tgt FOREIGN KEY (target_node_group_id) REFERENCES sym_node_group (node_group_id) 2014-11-18 16:01:16,560 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_node_identity ADD CONSTRAINT sym_fk_ident_2_node FOREIGN KEY (node_id) REFERENCES sym_node (node_id) 2014-11-18 16:01:16,562 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_node_security ADD CONSTRAINT sym_fk_sec_2_node FOREIGN KEY (node_id) REFERENCES sym_node (node_id) 2014-11-18 16:01:16,565 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_router ADD CONSTRAINT sym_fk_rt_2_grp_lnk FOREIGN KEY (source_node_group_id, target_node_group_id) REFERENCES sym_node_group_link (source_node_group_id, target_node_group_id) 2014-11-18 16:01:16,567 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_transform_table ADD CONSTRAINT sym_fk_tt_2_grp_lnk FOREIGN KEY (source_node_group_id, target_node_group_id) REFERENCES sym_node_group_link (source_node_group_id, target_node_group_id) 2014-11-18 16:01:16,571 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_trigger ADD CONSTRAINT sym_fk_trg_2_chnl FOREIGN KEY (channel_id) REFERENCES sym_channel (channel_id) 2014-11-18 16:01:16,574 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_trigger ADD CONSTRAINT sym_fk_trg_2_rld_chnl FOREIGN KEY (reload_channel_id) REFERENCES sym_channel (channel_id) 2014-11-18 16:01:16,576 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_trigger_router ADD CONSTRAINT sym_fk_tr_2_trg FOREIGN KEY (trigger_id) REFERENCES sym_trigger (trigger_id) 2014-11-18 16:01:16,579 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_trigger_router ADD CONSTRAINT sym_fk_tr_2_rtr FOREIGN KEY (router_id) REFERENCES sym_router (router_id) 2014-11-18 16:01:16,580 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_trigger_router_grouplet ADD CONSTRAINT sym_fk_trgplt_2_gplt FOREIGN KEY (grouplet_id) REFERENCES sym_grouplet (grouplet_id) 2014-11-18 16:01:16,583 INFO [corp-000] [AseSymmetricDialect] [main] DDL applied: ALTER TABLE sym_trigger_router_grouplet ADD CONSTRAINT sym_fk_trgplt_2_tr FOREIGN KEY (trigger_id, router_id) REFERENCES sym_trigger_router (trigger_id, router_id) 2014-11-18 16:01:16,586 INFO [corp-000] [AseSymmetricDialect] [main] Done with auto update of SymmetricDS tables 2014-11-18 16:01:16,671 INFO [corp-000] [ConfigurationService] [main] Auto-configuring config channel 2014-11-18 16:01:16,687 INFO [corp-000] [ConfigurationService] [main] Auto-configuring reload channel 2014-11-18 16:01:16,697 INFO [corp-000] [ConfigurationService] [main] Auto-configuring heartbeat channel 2014-11-18 16:01:16,708 INFO [corp-000] [ConfigurationService] [main] Auto-configuring default channel 2014-11-18 16:01:16,716 INFO [corp-000] [ConfigurationService] [main] Auto-configuring dynamic channel 2014-11-18 16:01:16,723 INFO [corp-000] [ConfigurationService] [main] Auto-configuring filesync channel 2014-11-18 16:01:16,732 INFO [corp-000] [ConfigurationService] [main] Auto-configuring filesync_reload channel 2014-11-18 16:01:16,819 INFO [corp-000] [AbstractSymmetricEngine] [main] Done initializing SymmetricDS database 2014-11-18 16:01:43,727 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2014-11-18 16:01:44,258 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'Adaptive Server Enterprise', version '16', protocol 'sybase' 2014-11-18 16:02:23,024 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000} 2014-11-18 16:02:23,025 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8181} 2014-11-18 16:02:23,107 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port default:8181 2014-11-18 16:02:24,554 INFO [startup] [/] [main] Initializing Spring root WebApplicationContext 2014-11-18 16:02:25,058 INFO [corp-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-0] Detected database 'Adaptive Server Enterprise', version '16', protocol 'sybase' 2014-11-18 16:02:25,387 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] The DbDialect being used is org.jumpmind.symmetric.db.ase.AseSymmetricDialect 2014-11-18 16:02:25,414 INFO [corp-000] [StagingManager] [symmetric-engine-startup-0] The staging directory was initialized at the following location: C:\Users\PhatHC\Desktop\sybase\symmetric-3.6.13\tmp\corp-000 2014-11-18 16:02:25,464 INFO [corp-000] [ClusterService] [symmetric-engine-startup-0] This node picked a server id of 301PHATHC 2014-11-18 16:02:26,640 INFO [corp-000] [ExtensionPointManager] [symmetric-engine-startup-0] Found 9 extension points that will be registered 2014-11-18 16:02:26,692 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Initializing SymmetricDS database 2014-11-18 16:02:26,693 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Checking if SymmetricDS tables need created or altered 2014-11-18 16:02:27,222 INFO [startup] [/] [main] Initializing Spring FrameworkServlet 'rest' 2014-11-18 16:02:27,827 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8182 2014-11-18 16:02:27,884 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2014-11-18 16:02:29,448 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Done initializing SymmetricDS database 2014-11-18 16:02:29,511 INFO [corp-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Starting registered node [group=corp, id=000, externalId=000] 2014-11-18 16:02:29,513 INFO [corp-000] [TriggerRouterService] [symmetric-engine-startup-0] Synchronizing triggers 2014-11-18 16:02:29,696 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_TM_SLLNG_PRC trigger for corp.dbo.item_selling_price 2014-11-18 16:02:29,743 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_TM_SLLNG_PRC trigger for corp.dbo.item_selling_price 2014-11-18 16:02:29,780 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_TM_SLLNG_PRC trigger for corp.dbo.item_selling_price 2014-11-18 16:02:29,878 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_RTR_CRP trigger for corp.dbo.sym_router 2014-11-18 16:02:29,912 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_RTR_CRP trigger for corp.dbo.sym_router 2014-11-18 16:02:29,942 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_RTR_CRP trigger for corp.dbo.sym_router 2014-11-18 16:02:30,048 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRNSFRM_TBL trigger for corp.dbo.sym_transform_table 2014-11-18 16:02:30,075 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRNSFRM_TBL trigger for corp.dbo.sym_transform_table 2014-11-18 16:02:30,131 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRNSFRM_TBL trigger for corp.dbo.sym_transform_table 2014-11-18 16:02:30,209 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_PRMTR_CRP trigger for corp.dbo.sym_parameter 2014-11-18 16:02:30,248 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_PRMTR_CRP trigger for corp.dbo.sym_parameter 2014-11-18 16:02:30,272 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_PRMTR_CRP trigger for corp.dbo.sym_parameter 2014-11-18 16:02:30,346 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_R trigger for corp.dbo.sym_file_trigger_router 2014-11-18 16:02:30,371 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_R trigger for corp.dbo.sym_file_trigger_router 2014-11-18 16:02:30,421 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_R trigger for corp.dbo.sym_file_trigger_router 2014-11-18 16:02:30,493 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TBL_RLD_RQ trigger for corp.dbo.sym_table_reload_request 2014-11-18 16:02:30,533 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TBL_RLD_RQ trigger for corp.dbo.sym_table_reload_request 2014-11-18 16:02:30,570 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TBL_RLD_RQ trigger for corp.dbo.sym_table_reload_request 2014-11-18 16:02:30,701 INFO [corp-000] [AseSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_GRPLT_LNK trigger for corp.dbo.sym_grouplet_link