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