2015-10-24 01:03:54,647 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={reportsdb-000} 2015-10-24 01:03:56,038 INFO [reportsdb-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Microsoft SQL Server', version '11', protocol 'jtds' 2015-10-24 01:03:56,116 INFO [reportsdb-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform 2015-10-24 01:03:56,757 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect 2015-10-24 01:03:56,882 INFO [reportsdb-000] [StagingManager] [main] The staging directory was initialized at the following location: C:\Users\Faraz\Desktop\destination-node\symmetric-server-3.7.25\tmp\reportsdb-000 2015-10-24 01:03:57,272 INFO [reportsdb-000] [ClusterService] [main] This node picked a server id of BREPORTSDBVM 2015-10-24 01:03:59,647 INFO [reportsdb-000] [ClientExtensionService] [main] Found 9 extension points from spring that will be registered 2015-10-24 01:03:59,647 INFO [reportsdb-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database 2015-10-24 01:03:59,647 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Checking if SymmetricDS tables need created or altered 2015-10-24 01:04:02,413 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] There are SymmetricDS tables that needed altered 2015-10-24 01:04:02,429 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,429 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,507 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_channel"( "channel_id" VARCHAR(128) NOT NULL, "processing_order" INT DEFAULT 1 NOT NULL, "max_batch_size" INT DEFAULT 1000 NOT NULL, "max_batch_to_send" INT DEFAULT 60 NOT NULL, "max_data_to_route" INT DEFAULT 100000 NOT NULL, "extract_period_millis" INT 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), "create_time" DATETIME, "last_update_by" VARCHAR(50), "last_update_time" DATETIME, PRIMARY KEY ("channel_id") ) 2015-10-24 01:04:02,522 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,538 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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), "target_catalog_name" VARCHAR(255), "target_schema_name" VARCHAR(255), "target_table_name" VARCHAR(255), "detect_type" VARCHAR(128) NOT NULL, "detect_expression" TEXT, "resolve_type" VARCHAR(128) NOT NULL, "ping_back" VARCHAR(128) NOT NULL, "resolve_changes_only" SMALLINT DEFAULT 0, "resolve_row_only" SMALLINT DEFAULT 0, "create_time" DATETIME NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("conflict_id") ) 2015-10-24 01:04:02,663 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,679 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data"( "data_id" BIGINT NOT NULL IDENTITY (1,1) , "table_name" VARCHAR(255) NOT NULL, "event_type" CHAR(1) NOT NULL, "row_data" TEXT, "pk_data" TEXT, "old_data" TEXT, "trigger_hist_id" INT NOT NULL, "channel_id" VARCHAR(128), "transaction_id" VARCHAR(255), "source_node_id" VARCHAR(50), "external_data" VARCHAR(50), "node_list" VARCHAR(255), "create_time" DATETIME, PRIMARY KEY ("data_id") ) 2015-10-24 01:04:02,694 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_d_channel_id" ON "sym_data" ("data_id", "channel_id") 2015-10-24 01:04:02,710 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,725 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_event"( "data_id" BIGINT NOT NULL, "batch_id" BIGINT NOT NULL, "router_id" VARCHAR(50) NOT NULL, "create_time" DATETIME, PRIMARY KEY ("data_id", "batch_id", "router_id") ) 2015-10-24 01:04:02,725 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_de_batchid" ON "sym_data_event" ("batch_id") 2015-10-24 01:04:02,741 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,757 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_data_gap"( "start_id" BIGINT NOT NULL, "end_id" BIGINT NOT NULL, "status" CHAR(2), "create_time" DATETIME NOT NULL, "last_update_hostname" VARCHAR(255), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("start_id", "end_id") ) 2015-10-24 01:04:02,772 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_dg_status" ON "sym_data_gap" ("status") 2015-10-24 01:04:02,788 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,804 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_extension"( "extension_id" VARCHAR(50) NOT NULL, "extension_type" VARCHAR(10) NOT NULL, "interface_name" VARCHAR(255), "node_group_id" VARCHAR(50) NOT NULL, "enabled" SMALLINT DEFAULT 1 NOT NULL, "extension_order" INT DEFAULT 1 NOT NULL, "extension_text" TEXT, "create_time" DATETIME, "last_update_by" VARCHAR(50), "last_update_time" DATETIME, PRIMARY KEY ("extension_id") ) 2015-10-24 01:04:02,819 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,835 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_extract_request"( "request_id" BIGINT NOT NULL, "node_id" VARCHAR(50) NOT NULL, "status" CHAR(2), "start_batch_id" BIGINT NOT NULL, "end_batch_id" BIGINT NOT NULL, "trigger_id" VARCHAR(128) NOT NULL, "router_id" VARCHAR(50) NOT NULL, "last_update_time" DATETIME, "create_time" DATETIME, PRIMARY KEY ("request_id") ) 2015-10-24 01:04:02,835 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,850 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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" BIGINT, PRIMARY KEY ("relative_dir", "file_name") ) 2015-10-24 01:04:02,850 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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" BIGINT, "file_size" BIGINT, "file_modified_time" BIGINT, "last_update_time" DATETIME NOT NULL, "last_update_by" VARCHAR(50), "create_time" DATETIME NOT NULL, PRIMARY KEY ("trigger_id", "router_id", "relative_dir", "file_name") ) 2015-10-24 01:04:02,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_f_snpsht_chid" ON "sym_file_snapshot" ("reload_channel_id") 2015-10-24 01:04:02,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,882 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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), "excludes_files" VARCHAR(255), "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, "after_copy_script" TEXT, "create_time" DATETIME NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("trigger_id") ) 2015-10-24 01:04:02,882 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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), "conflict_strategy" VARCHAR(128) DEFAULT 'source_wins' NOT NULL, "create_time" DATETIME NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("trigger_id", "router_id") ) 2015-10-24 01:04:02,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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), "create_time" DATETIME NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("grouplet_id") ) 2015-10-24 01:04:02,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,913 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_grouplet_link"( "grouplet_id" VARCHAR(50) NOT NULL, "external_id" VARCHAR(255) NOT NULL, "create_time" DATETIME NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("grouplet_id", "external_id") ) 2015-10-24 01:04:02,913 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,944 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_batch"( "batch_id" BIGINT NOT NULL, "node_id" VARCHAR(50) NOT NULL, "channel_id" VARCHAR(128), "status" CHAR(2), "error_flag" SMALLINT DEFAULT 0, "network_millis" BIGINT DEFAULT 0 NOT NULL, "filter_millis" BIGINT DEFAULT 0 NOT NULL, "database_millis" BIGINT DEFAULT 0 NOT NULL, "failed_row_number" BIGINT DEFAULT 0 NOT NULL, "failed_line_number" BIGINT DEFAULT 0 NOT NULL, "byte_count" BIGINT DEFAULT 0 NOT NULL, "statement_count" BIGINT DEFAULT 0 NOT NULL, "fallback_insert_count" BIGINT DEFAULT 0 NOT NULL, "fallback_update_count" BIGINT DEFAULT 0 NOT NULL, "ignore_count" BIGINT DEFAULT 0 NOT NULL, "missing_delete_count" BIGINT DEFAULT 0 NOT NULL, "skip_count" BIGINT DEFAULT 0 NOT NULL, "sql_state" VARCHAR(10), "sql_code" INT DEFAULT 0 NOT NULL, "sql_message" TEXT, "last_update_hostname" VARCHAR(255), "last_update_time" DATETIME, "create_time" DATETIME, PRIMARY KEY ("batch_id", "node_id") ) 2015-10-24 01:04:02,944 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_time_status" ON "sym_incoming_batch" ("create_time", "status") 2015-10-24 01:04:02,944 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ib_in_error" ON "sym_incoming_batch" ("error_flag") 2015-10-24 01:04:02,944 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:02,975 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_incoming_error"( "batch_id" BIGINT NOT NULL, "node_id" VARCHAR(50) NOT NULL, "failed_row_number" BIGINT NOT NULL, "failed_line_number" BIGINT DEFAULT 0 NOT NULL, "target_catalog_name" VARCHAR(255), "target_schema_name" VARCHAR(255), "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, "old_data" TEXT, "cur_data" TEXT, "resolve_data" TEXT, "resolve_ignore" SMALLINT DEFAULT 0, "conflict_id" VARCHAR(50), "create_time" DATETIME, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("batch_id", "node_id", "failed_row_number") ) 2015-10-24 01:04:02,991 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,007 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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), "target_schema_name" VARCHAR(255), "target_table_name" VARCHAR(255), "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, "after_write_script" TEXT, "batch_complete_script" TEXT, "batch_commit_script" TEXT, "batch_rollback_script" TEXT, "handle_error_script" TEXT, "create_time" DATETIME NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, "load_filter_order" INT DEFAULT 1 NOT NULL, "fail_on_error" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("load_filter_id") ) 2015-10-24 01:04:03,007 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,022 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_lock"( "lock_action" VARCHAR(50) NOT NULL, "lock_type" VARCHAR(50) NOT NULL, "locking_server_id" VARCHAR(255), "lock_time" DATETIME, "shared_count" INT DEFAULT 0 NOT NULL, "shared_enable" INT DEFAULT 0 NOT NULL, "last_lock_time" DATETIME, "last_locking_server_id" VARCHAR(255), PRIMARY KEY ("lock_action") ) 2015-10-24 01:04:03,022 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,038 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node"( "node_id" VARCHAR(50) NOT NULL, "node_group_id" VARCHAR(50) NOT NULL, "external_id" VARCHAR(255) NOT NULL, "sync_enabled" SMALLINT DEFAULT 0, "sync_url" VARCHAR(255), "schema_version" VARCHAR(50), "symmetric_version" VARCHAR(50), "database_type" VARCHAR(50), "database_version" VARCHAR(50), "heartbeat_time" DATETIME, "timezone_offset" VARCHAR(6), "batch_to_send_count" INT DEFAULT 0, "batch_in_error_count" INT DEFAULT 0, "created_at_node_id" VARCHAR(50), "deployment_type" VARCHAR(50), PRIMARY KEY ("node_id") ) 2015-10-24 01:04:03,038 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,054 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_communication"( "node_id" VARCHAR(50) NOT NULL, "communication_type" VARCHAR(10) NOT NULL, "lock_time" DATETIME, "locking_server_id" VARCHAR(255), "last_lock_time" DATETIME, "last_lock_millis" BIGINT DEFAULT 0, "success_count" BIGINT DEFAULT 0, "fail_count" BIGINT DEFAULT 0, "total_success_count" BIGINT DEFAULT 0, "total_fail_count" BIGINT DEFAULT 0, "total_success_millis" BIGINT DEFAULT 0, "total_fail_millis" BIGINT DEFAULT 0, PRIMARY KEY ("node_id", "communication_type") ) 2015-10-24 01:04:03,054 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,069 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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, "ignore_enabled" SMALLINT DEFAULT 0, "last_extract_time" DATETIME, PRIMARY KEY ("node_id", "channel_id") ) 2015-10-24 01:04:03,069 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,069 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_group"( "node_group_id" VARCHAR(50) NOT NULL, "description" VARCHAR(255), "create_time" DATETIME, "last_update_by" VARCHAR(50), "last_update_time" DATETIME, PRIMARY KEY ("node_group_id") ) 2015-10-24 01:04:03,069 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,085 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") ) 2015-10-24 01:04:03,085 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,100 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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, "last_update_by" VARCHAR(50), "last_update_time" DATETIME, PRIMARY KEY ("source_node_group_id", "target_node_group_id") ) 2015-10-24 01:04:03,100 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,147 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_host"( "node_id" VARCHAR(50) NOT NULL, "host_name" VARCHAR(60) NOT NULL, "ip_address" VARCHAR(50), "os_user" VARCHAR(50), "os_name" VARCHAR(50), "os_arch" VARCHAR(50), "os_version" VARCHAR(50), "available_processors" INT DEFAULT 0, "free_memory_bytes" BIGINT DEFAULT 0, "total_memory_bytes" BIGINT DEFAULT 0, "max_memory_bytes" BIGINT DEFAULT 0, "java_version" VARCHAR(50), "java_vendor" VARCHAR(255), "jdbc_version" VARCHAR(255), "symmetric_version" VARCHAR(50), "timezone_offset" VARCHAR(6), "heartbeat_time" DATETIME, "last_restart_time" DATETIME NOT NULL, "create_time" DATETIME NOT NULL, PRIMARY KEY ("node_id", "host_name") ) 2015-10-24 01:04:03,147 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,179 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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" BIGINT DEFAULT 0, "data_unrouted" BIGINT DEFAULT 0, "data_event_inserted" BIGINT DEFAULT 0, "data_extracted" BIGINT DEFAULT 0, "data_bytes_extracted" BIGINT DEFAULT 0, "data_extracted_errors" BIGINT DEFAULT 0, "data_bytes_sent" BIGINT DEFAULT 0, "data_sent" BIGINT DEFAULT 0, "data_sent_errors" BIGINT DEFAULT 0, "data_loaded" BIGINT DEFAULT 0, "data_bytes_loaded" BIGINT DEFAULT 0, "data_loaded_errors" BIGINT DEFAULT 0, PRIMARY KEY ("node_id", "host_name", "channel_id", "start_time", "end_time") ) 2015-10-24 01:04:03,179 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_chnl_sts" ON "sym_node_host_channel_stats" ("node_id", "start_time", "end_time") 2015-10-24 01:04:03,179 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,194 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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" BIGINT DEFAULT 0, PRIMARY KEY ("node_id", "host_name", "job_name", "start_time", "end_time") ) 2015-10-24 01:04:03,194 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_job" ON "sym_node_host_job_stats" ("node_id", "start_time", "end_time") 2015-10-24 01:04:03,194 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,225 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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" BIGINT DEFAULT 0 NOT NULL, "nodes_pulled" BIGINT DEFAULT 0, "total_nodes_pull_time" BIGINT DEFAULT 0, "nodes_pushed" BIGINT DEFAULT 0, "total_nodes_push_time" BIGINT DEFAULT 0, "nodes_rejected" BIGINT DEFAULT 0, "nodes_registered" BIGINT DEFAULT 0, "nodes_loaded" BIGINT DEFAULT 0, "nodes_disabled" BIGINT DEFAULT 0, "purged_data_rows" BIGINT DEFAULT 0, "purged_data_event_rows" BIGINT DEFAULT 0, "purged_batch_outgoing_rows" BIGINT DEFAULT 0, "purged_batch_incoming_rows" BIGINT DEFAULT 0, "triggers_created_count" BIGINT, "triggers_rebuilt_count" BIGINT, "triggers_removed_count" BIGINT, PRIMARY KEY ("node_id", "host_name", "start_time", "end_time") ) 2015-10-24 01:04:03,225 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_nd_hst_sts" ON "sym_node_host_stats" ("node_id", "start_time", "end_time") 2015-10-24 01:04:03,225 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,241 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_node_identity"( "node_id" VARCHAR(50) NOT NULL, PRIMARY KEY ("node_id") ) 2015-10-24 01:04:03,241 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,257 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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, "registration_time" DATETIME, "initial_load_enabled" SMALLINT DEFAULT 0, "initial_load_time" DATETIME, "initial_load_id" BIGINT, "initial_load_create_by" VARCHAR(255), "rev_initial_load_enabled" SMALLINT DEFAULT 0, "rev_initial_load_time" DATETIME, "rev_initial_load_id" BIGINT, "rev_initial_load_create_by" VARCHAR(255), "created_at_node_id" VARCHAR(50), PRIMARY KEY ("node_id") ) 2015-10-24 01:04:03,257 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,444 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_outgoing_batch"( "batch_id" BIGINT NOT NULL, "node_id" VARCHAR(50) NOT NULL, "channel_id" VARCHAR(128), "status" CHAR(2), "load_id" BIGINT, "extract_job_flag" SMALLINT DEFAULT 0, "load_flag" SMALLINT DEFAULT 0, "error_flag" SMALLINT DEFAULT 0, "common_flag" SMALLINT DEFAULT 0, "ignore_count" BIGINT DEFAULT 0 NOT NULL, "byte_count" BIGINT DEFAULT 0 NOT NULL, "extract_count" BIGINT DEFAULT 0 NOT NULL, "sent_count" BIGINT DEFAULT 0 NOT NULL, "load_count" BIGINT DEFAULT 0 NOT NULL, "data_event_count" BIGINT DEFAULT 0 NOT NULL, "reload_event_count" BIGINT DEFAULT 0 NOT NULL, "insert_event_count" BIGINT DEFAULT 0 NOT NULL, "update_event_count" BIGINT DEFAULT 0 NOT NULL, "delete_event_count" BIGINT DEFAULT 0 NOT NULL, "other_event_count" BIGINT DEFAULT 0 NOT NULL, "router_millis" BIGINT DEFAULT 0 NOT NULL, "network_millis" BIGINT DEFAULT 0 NOT NULL, "filter_millis" BIGINT DEFAULT 0 NOT NULL, "load_millis" BIGINT DEFAULT 0 NOT NULL, "extract_millis" BIGINT DEFAULT 0 NOT NULL, "transform_extract_millis" BIGINT DEFAULT 0 NOT NULL, "transform_load_millis" BIGINT DEFAULT 0 NOT NULL, "total_extract_millis" BIGINT DEFAULT 0 NOT NULL, "total_load_millis" BIGINT DEFAULT 0 NOT NULL, "sql_state" VARCHAR(10), "sql_code" INT DEFAULT 0 NOT NULL, "sql_message" TEXT, "failed_data_id" BIGINT DEFAULT 0 NOT NULL, "failed_line_number" BIGINT DEFAULT 0 NOT NULL, "last_update_hostname" VARCHAR(255), "last_update_time" DATETIME, "create_time" DATETIME, "create_by" VARCHAR(255), PRIMARY KEY ("batch_id", "node_id") ) 2015-10-24 01:04:03,460 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_node_status" ON "sym_outgoing_batch" ("node_id", "status") 2015-10-24 01:04:03,460 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_status" ON "sym_outgoing_batch" ("status") 2015-10-24 01:04:03,491 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_ob_in_error" ON "sym_outgoing_batch" ("error_flag") 2015-10-24 01:04:03,491 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,491 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_parameter"( "external_id" VARCHAR(255) NOT NULL, "node_group_id" VARCHAR(50) NOT NULL, "param_key" VARCHAR(80) NOT NULL, "param_value" TEXT, "create_time" DATETIME, "last_update_by" VARCHAR(50), "last_update_time" DATETIME, PRIMARY KEY ("external_id", "node_group_id", "param_key") ) 2015-10-24 01:04:03,507 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,538 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_registration_redirect"( "registrant_external_id" VARCHAR(255) NOT NULL, "registration_node_id" VARCHAR(50) NOT NULL, PRIMARY KEY ("registrant_external_id") ) 2015-10-24 01:04:03,538 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,538 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_registration_request"( "node_group_id" VARCHAR(50) NOT NULL, "external_id" VARCHAR(255) NOT NULL, "status" CHAR(2) NOT NULL, "host_name" VARCHAR(60) NOT NULL, "ip_address" VARCHAR(50) NOT NULL, "attempt_count" INT DEFAULT 0, "registered_node_id" VARCHAR(50), "error_message" TEXT, "create_time" DATETIME NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("node_group_id", "external_id", "create_time") ) 2015-10-24 01:04:03,554 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_1" ON "sym_registration_request" ("node_group_id", "external_id", "status", "host_name", "ip_address") 2015-10-24 01:04:03,554 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE INDEX "sym_idx_reg_req_2" ON "sym_registration_request" ("status") 2015-10-24 01:04:03,554 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,569 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_router"( "router_id" VARCHAR(50) NOT NULL, "target_catalog_name" VARCHAR(255), "target_schema_name" VARCHAR(255), "target_table_name" VARCHAR(255), "source_node_group_id" VARCHAR(50) NOT NULL, "target_node_group_id" VARCHAR(50) NOT NULL, "router_type" VARCHAR(50), "router_expression" TEXT, "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), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("router_id") ) 2015-10-24 01:04:03,569 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,585 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_sequence"( "sequence_name" VARCHAR(50) NOT NULL, "current_value" BIGINT DEFAULT 0 NOT NULL, "increment_by" INT DEFAULT 1 NOT NULL, "min_value" BIGINT DEFAULT 1 NOT NULL, "max_value" BIGINT DEFAULT 9999999999 NOT NULL, "cycle" SMALLINT DEFAULT 0, "create_time" DATETIME, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("sequence_name") ) 2015-10-24 01:04:03,585 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,600 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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, "reload_delete_stmt" TEXT, "reload_enabled" SMALLINT DEFAULT 0, "reload_time" DATETIME, "create_time" DATETIME, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("target_node_id", "source_node_id", "trigger_id", "router_id") ) 2015-10-24 01:04:03,600 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,616 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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), "source_schema_name" VARCHAR(255), "source_table_name" VARCHAR(255) NOT NULL, "target_catalog_name" VARCHAR(255), "target_schema_name" VARCHAR(255), "target_table_name" VARCHAR(255), "update_first" SMALLINT DEFAULT 0, "update_action" VARCHAR(255) DEFAULT 'UPDATE_COL', "delete_action" VARCHAR(10) NOT NULL, "transform_order" INT DEFAULT 1 NOT NULL, "column_policy" VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL, "create_time" DATETIME, "last_update_by" VARCHAR(50), "last_update_time" DATETIME, PRIMARY KEY ("transform_id", "source_node_group_id", "target_node_group_id") ) 2015-10-24 01:04:03,616 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,694 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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), "pk" SMALLINT DEFAULT 0, "transform_type" VARCHAR(50) DEFAULT 'copy', "transform_expression" TEXT, "transform_order" INT DEFAULT 1 NOT NULL, "create_time" DATETIME, "last_update_by" VARCHAR(50), "last_update_time" DATETIME, PRIMARY KEY ("transform_id", "include_on", "target_column_name") ) 2015-10-24 01:04:03,694 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,725 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger"( "trigger_id" VARCHAR(128) NOT NULL, "source_catalog_name" VARCHAR(255), "source_schema_name" VARCHAR(255), "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), "name_for_insert_trigger" VARCHAR(255), "name_for_delete_trigger" VARCHAR(255), "sync_on_update_condition" TEXT, "sync_on_insert_condition" TEXT, "sync_on_delete_condition" TEXT, "custom_on_update_text" TEXT, "custom_on_insert_text" TEXT, "custom_on_delete_text" TEXT, "external_select" TEXT, "tx_id_expression" TEXT, "channel_expression" TEXT, "excluded_column_names" TEXT, "sync_key_names" TEXT, "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), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("trigger_id") ) 2015-10-24 01:04:03,741 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,757 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: CREATE TABLE "sym_trigger_hist"( "trigger_hist_id" INT NOT NULL, "trigger_id" VARCHAR(128) NOT NULL, "source_table_name" VARCHAR(255) NOT NULL, "source_catalog_name" VARCHAR(255), "source_schema_name" VARCHAR(255), "name_for_update_trigger" VARCHAR(255), "name_for_insert_trigger" VARCHAR(255), "name_for_delete_trigger" VARCHAR(255), "table_hash" BIGINT DEFAULT 0 NOT NULL, "trigger_row_hash" BIGINT DEFAULT 0 NOT NULL, "trigger_template_hash" BIGINT 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, "create_time" DATETIME NOT NULL, "inactive_time" DATETIME, PRIMARY KEY ("trigger_hist_id") ) 2015-10-24 01:04:03,757 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,757 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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" INT DEFAULT 1 NOT NULL, "initial_load_select" TEXT, "initial_load_delete_stmt" TEXT, "initial_load_batch_count" INT DEFAULT 1, "ping_back_enabled" SMALLINT DEFAULT 0 NOT NULL, "create_time" DATETIME NOT NULL, "last_update_by" VARCHAR(50), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("trigger_id", "router_id") ) 2015-10-24 01:04:03,772 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: SET quoted_identifier on 2015-10-24 01:04:03,772 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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), "last_update_time" DATETIME NOT NULL, PRIMARY KEY ("grouplet_id", "trigger_id", "router_id", "applies_when") ) 2015-10-24 01:04:03,788 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") 2015-10-24 01:04:03,788 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") 2015-10-24 01:04:03,804 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") 2015-10-24 01:04:03,804 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_grouplet_link" ADD CONSTRAINT "sym_fk_gpltlnk_2_gplt" FOREIGN KEY ("grouplet_id") REFERENCES "sym_grouplet" ("grouplet_id") 2015-10-24 01:04:03,804 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") 2015-10-24 01:04:03,819 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") 2015-10-24 01:04:03,819 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_identity" ADD CONSTRAINT "sym_fk_ident_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id") 2015-10-24 01:04:03,819 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_node_security" ADD CONSTRAINT "sym_fk_sec_2_node" FOREIGN KEY ("node_id") REFERENCES "sym_node" ("node_id") 2015-10-24 01:04:03,835 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") 2015-10-24 01:04:03,835 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") 2015-10-24 01:04:03,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger" ADD CONSTRAINT "sym_fk_trg_2_chnl" FOREIGN KEY ("channel_id") REFERENCES "sym_channel" ("channel_id") 2015-10-24 01:04:03,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") 2015-10-24 01:04:03,866 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router" ADD CONSTRAINT "sym_fk_tr_2_trg" FOREIGN KEY ("trigger_id") REFERENCES "sym_trigger" ("trigger_id") 2015-10-24 01:04:03,882 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] DDL applied: ALTER TABLE "sym_trigger_router" ADD CONSTRAINT "sym_fk_tr_2_rtr" FOREIGN KEY ("router_id") REFERENCES "sym_router" ("router_id") 2015-10-24 01:04:03,882 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") 2015-10-24 01:04:03,882 INFO [reportsdb-000] [MsSqlSymmetricDialect] [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") 2015-10-24 01:04:03,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Done with auto update of SymmetricDS tables 2015-10-24 01:04:04,054 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Updating indexes to prevent lock escalation 2015-10-24 01:04:04,210 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Installing SymmetricDS database object: create function dbo.sym_base64_encode(@data varbinary(max)) returns varchar(max) with schemabinding, returns null on null input begin return ( select [text()] = @data for xml path('') ) end 2015-10-24 01:04:04,210 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Just installed sym_base64_encode 2015-10-24 01:04:04,225 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Installing SymmetricDS database object: create function dbo.sym_triggers_disabled() returns smallint begin declare @disabled varchar(1); set @disabled = coalesce(replace(substring(cast(context_info() as varchar), 1, 1), 0x0, ''), ''); if @disabled is null or @disabled != '1' return 0; return 1; end 2015-10-24 01:04:04,225 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Just installed sym_triggers_disabled 2015-10-24 01:04:04,241 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Installing SymmetricDS database object: create function dbo.sym_node_disabled() returns varchar(50) begin declare @node varchar(50); set @node = coalesce(replace(substring(cast(context_info() as varchar) collate SQL_Latin1_General_CP1_CI_AS, 2, 50), 0x0, ''), ''); return @node; end 2015-10-24 01:04:04,241 INFO [reportsdb-000] [MsSqlSymmetricDialect] [main] Just installed sym_node_disabled 2015-10-24 01:04:04,272 INFO [reportsdb-000] [ConfigurationService] [main] Auto-configuring config channel 2015-10-24 01:04:04,319 INFO [reportsdb-000] [ConfigurationService] [main] Auto-configuring reload channel 2015-10-24 01:04:04,335 INFO [reportsdb-000] [ConfigurationService] [main] Auto-configuring heartbeat channel 2015-10-24 01:04:04,382 INFO [reportsdb-000] [ConfigurationService] [main] Auto-configuring default channel 2015-10-24 01:04:04,382 INFO [reportsdb-000] [ConfigurationService] [main] Auto-configuring dynamic channel 2015-10-24 01:04:04,491 INFO [reportsdb-000] [AbstractSymmetricEngine] [main] Done initializing SymmetricDS database 2015-10-24 01:05:48,866 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={reportsdb-000} 2015-10-24 01:05:48,882 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8080} 2015-10-24 01:05:48,960 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port default:8080 2015-10-24 01:05:49,757 INFO [startup] [/] [main] Initializing Spring root WebApplicationContext 2015-10-24 01:05:50,382 INFO [reportsdb-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-0] Detected database 'Microsoft SQL Server', version '11', protocol 'jtds' 2015-10-24 01:05:50,413 INFO [reportsdb-000] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-0] The IDatabasePlatform being used is org.jumpmind.db.platform.mssql.MsSql2008DatabasePlatform 2015-10-24 01:05:51,473 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] The DbDialect being used is org.jumpmind.symmetric.db.mssql.MsSqlSymmetricDialect 2015-10-24 01:05:51,629 INFO [reportsdb-000] [ExtensionService] [symmetric-engine-startup-0] Found 0 extension points from the database that will be registered 2015-10-24 01:05:51,660 INFO [reportsdb-000] [StagingManager] [symmetric-engine-startup-0] The staging directory was initialized at the following location: C:\Users\Faraz\Desktop\destination-node\symmetric-server-3.7.25\tmp\reportsdb-000 2015-10-24 01:05:51,738 INFO [reportsdb-000] [ClusterService] [symmetric-engine-startup-0] This node picked a server id of BREPORTSDBVM 2015-10-24 01:05:53,144 INFO [reportsdb-000] [ExtensionService] [symmetric-engine-startup-0] Found 0 extension points from the database that will be registered 2015-10-24 01:05:53,144 INFO [reportsdb-000] [ClientExtensionService] [symmetric-engine-startup-0] Found 9 extension points from spring that will be registered 2015-10-24 01:05:53,223 INFO [reportsdb-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Initializing SymmetricDS database 2015-10-24 01:05:53,223 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Checking if SymmetricDS tables need created or altered 2015-10-24 01:05:53,410 INFO [startup] [/] [main] Initializing Spring FrameworkServlet 'rest' 2015-10-24 01:05:53,749 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8081 2015-10-24 01:05:53,791 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2015-10-24 01:05:55,226 INFO [reportsdb-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Done initializing SymmetricDS database 2015-10-24 01:05:55,268 INFO [reportsdb-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Starting registered node [group=reportsdb, id=000, externalId=000] 2015-10-24 01:05:55,282 INFO [reportsdb-000] [TriggerRouterService] [symmetric-engine-startup-0] Synchronizing triggers 2015-10-24 01:05:55,662 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_RTR_RPRTSDB trigger for dposdb.dbo.sym_router 2015-10-24 01:05:55,690 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_RTR_RPRTSDB trigger for dposdb.dbo.sym_router 2015-10-24 01:05:55,718 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_RTR_RPRTSDB trigger for dposdb.dbo.sym_router 2015-10-24 01:05:55,816 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRNSFRM_TBL_RPRTSDB trigger for dposdb.dbo.sym_transform_table 2015-10-24 01:05:55,873 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRNSFRM_TBL_RPRTSDB trigger for dposdb.dbo.sym_transform_table 2015-10-24 01:05:55,901 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRNSFRM_TBL_RPRTSDB trigger for dposdb.dbo.sym_transform_table 2015-10-24 01:05:55,967 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_PRMTR_RPRTSDB trigger for dposdb.dbo.sym_parameter 2015-10-24 01:05:55,989 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_PRMTR_RPRTSDB trigger for dposdb.dbo.sym_parameter 2015-10-24 01:05:56,007 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_PRMTR_RPRTSDB trigger for dposdb.dbo.sym_parameter 2015-10-24 01:05:56,097 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger_router 2015-10-24 01:05:56,139 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger_router 2015-10-24 01:05:56,153 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger_router 2015-10-24 01:05:56,223 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_GRP_CHNNL_WND_RPRTSDB trigger for dposdb.dbo.sym_node_group_channel_wnd 2015-10-24 01:05:56,251 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_GRP_CHNNL_WND_RPRTSDB trigger for dposdb.dbo.sym_node_group_channel_wnd 2015-10-24 01:05:56,265 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_GRP_CHNNL_WND_RPRTSDB trigger for dposdb.dbo.sym_node_group_channel_wnd 2015-10-24 01:05:56,350 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TBL_RLD_RQST_RPRTSDB trigger for dposdb.dbo.sym_table_reload_request 2015-10-24 01:05:56,364 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TBL_RLD_RQST_RPRTSDB trigger for dposdb.dbo.sym_table_reload_request 2015-10-24 01:05:56,378 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TBL_RLD_RQST_RPRTSDB trigger for dposdb.dbo.sym_table_reload_request 2015-10-24 01:05:56,519 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_GRPLT_LNK_RPRTSDB trigger for dposdb.dbo.sym_grouplet_link 2015-10-24 01:05:56,547 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_GRPLT_LNK_RPRTSDB trigger for dposdb.dbo.sym_grouplet_link 2015-10-24 01:05:56,561 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_GRPLT_LNK_RPRTSDB trigger for dposdb.dbo.sym_grouplet_link 2015-10-24 01:05:56,631 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_GRP_LNK_RPRTSDB trigger for dposdb.dbo.sym_node_group_link 2015-10-24 01:05:56,645 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_GRP_LNK_RPRTSDB trigger for dposdb.dbo.sym_node_group_link 2015-10-24 01:05:56,659 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_GRP_LNK_RPRTSDB trigger for dposdb.dbo.sym_node_group_link 2015-10-24 01:05:56,729 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_grouplet 2015-10-24 01:05:56,856 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_grouplet 2015-10-24 01:05:56,898 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_grouplet 2015-10-24 01:05:56,969 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_GRP_RPRTSDB trigger for dposdb.dbo.sym_node_group 2015-10-24 01:05:56,983 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_GRP_RPRTSDB trigger for dposdb.dbo.sym_node_group 2015-10-24 01:05:57,011 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_GRP_RPRTSDB trigger for dposdb.dbo.sym_node_group 2015-10-24 01:05:57,151 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_SCRTY_RPRTSDB trigger for dposdb.dbo.sym_node_security 2015-10-24 01:05:57,165 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_SCRTY_RPRTSDB trigger for dposdb.dbo.sym_node_security 2015-10-24 01:05:57,179 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_SCRTY_RPRTSDB trigger for dposdb.dbo.sym_node_security 2015-10-24 01:05:57,278 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_FL_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger 2015-10-24 01:05:57,292 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_FL_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger 2015-10-24 01:05:57,306 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_FL_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_file_trigger 2015-10-24 01:05:57,390 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRNSFRM_CLMN_RPRTSDB trigger for dposdb.dbo.sym_transform_column 2015-10-24 01:05:57,404 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRNSFRM_CLMN_RPRTSDB trigger for dposdb.dbo.sym_transform_column 2015-10-24 01:05:57,419 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRNSFRM_CLMN_RPRTSDB trigger for dposdb.dbo.sym_transform_column 2015-10-24 01:05:57,503 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_LD_FLTR_RPRTSDB trigger for dposdb.dbo.sym_load_filter 2015-10-24 01:05:57,517 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_LD_FLTR_RPRTSDB trigger for dposdb.dbo.sym_load_filter 2015-10-24 01:05:57,545 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_LD_FLTR_RPRTSDB trigger for dposdb.dbo.sym_load_filter 2015-10-24 01:05:57,615 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_XTNSN_RPRTSDB trigger for dposdb.dbo.sym_extension 2015-10-24 01:05:57,644 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_XTNSN_RPRTSDB trigger for dposdb.dbo.sym_extension 2015-10-24 01:05:57,658 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_XTNSN_RPRTSDB trigger for dposdb.dbo.sym_extension 2015-10-24 01:05:57,728 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_CNFLCT_RPRTSDB trigger for dposdb.dbo.sym_conflict 2015-10-24 01:05:57,756 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_CNFLCT_RPRTSDB trigger for dposdb.dbo.sym_conflict 2015-10-24 01:05:57,770 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_CNFLCT_RPRTSDB trigger for dposdb.dbo.sym_conflict 2015-10-24 01:05:57,854 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_trigger 2015-10-24 01:05:57,869 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_trigger 2015-10-24 01:05:57,897 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRGGR_RPRTSDB trigger for dposdb.dbo.sym_trigger 2015-10-24 01:05:57,967 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_trigger_router 2015-10-24 01:05:57,995 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_trigger_router 2015-10-24 01:05:58,009 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_RPRTSDB trigger for dposdb.dbo.sym_trigger_router 2015-10-24 01:05:58,079 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_CHNNL_RPRTSDB trigger for dposdb.dbo.sym_channel 2015-10-24 01:05:58,108 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_CHNNL_RPRTSDB trigger for dposdb.dbo.sym_channel 2015-10-24 01:05:58,122 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_CHNNL_RPRTSDB trigger for dposdb.dbo.sym_channel 2015-10-24 01:05:58,178 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_RPRTSDB trigger for dposdb.dbo.sym_node 2015-10-24 01:05:58,192 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_RPRTSDB trigger for dposdb.dbo.sym_node 2015-10-24 01:05:58,206 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_RPRTSDB trigger for dposdb.dbo.sym_node 2015-10-24 01:05:58,304 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_TRGGR_RTR_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_trigger_router_grouplet 2015-10-24 01:05:58,319 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_TRGGR_RTR_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_trigger_router_grouplet 2015-10-24 01:05:58,333 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_TRGGR_RTR_GRPLT_RPRTSDB trigger for dposdb.dbo.sym_trigger_router_grouplet 2015-10-24 01:05:58,403 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_I_FOR_SYM_ND_HST_RPRTSDB trigger for dposdb.dbo.sym_node_host 2015-10-24 01:05:58,431 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_U_FOR_SYM_ND_HST_RPRTSDB trigger for dposdb.dbo.sym_node_host 2015-10-24 01:05:58,445 INFO [reportsdb-000] [MsSqlSymmetricDialect] [symmetric-engine-startup-0] Creating SYM_ON_D_FOR_SYM_ND_HST_RPRTSDB trigger for dposdb.dbo.sym_node_host 2015-10-24 01:05:58,459 INFO [reportsdb-000] [TriggerRouterService] [symmetric-engine-startup-0] Done synchronizing triggers 2015-10-24 01:05:58,473 INFO [reportsdb-000] [PushHeartbeatListener] [symmetric-engine-startup-0] Some attribute(s) of node changed. Recording changes 2015-10-24 01:05:58,473 INFO [reportsdb-000] [PushHeartbeatListener] [symmetric-engine-startup-0] Updating my node configuration info according to the symmetric properties 2015-10-24 01:05:58,783 INFO [reportsdb-000] [RouterJob] [symmetric-engine-startup-0] Starting job.routing on periodic schedule: every 10000ms with the first run at Sat Oct 24 01:06:08 PKT 2015 2015-10-24 01:05:58,867 INFO [reportsdb-000] [PushJob] [symmetric-engine-startup-0] Starting job.push on periodic schedule: every 60000ms with the first run at Sat Oct 24 01:06:08 PKT 2015 2015-10-24 01:05:58,867 INFO [reportsdb-000] [PullJob] [symmetric-engine-startup-0] Starting job.pull on periodic schedule: every 60000ms with the first run at Sat Oct 24 01:06:08 PKT 2015 2015-10-24 01:05:58,881 INFO [reportsdb-000] [OfflinePushJob] [symmetric-engine-startup-0] Starting job.offline.push on periodic schedule: every 60000ms with the first run at Sat Oct 24 01:06:08 PKT 2015 2015-10-24 01:05:58,895 INFO [reportsdb-000] [OfflinePullJob] [symmetric-engine-startup-0] Starting job.offline.pull on periodic schedule: every 60000ms with the first run at Sat Oct 24 01:06:08 PKT 2015 2015-10-24 01:05:58,895 INFO [reportsdb-000] [OutgoingPurgeJob] [symmetric-engine-startup-0] Starting job.purge.outgoing with cron expression: 0 0 0 * * * 2015-10-24 01:05:58,909 INFO [reportsdb-000] [IncomingPurgeJob] [symmetric-engine-startup-0] Starting job.purge.incoming with cron expression: 0 0 0 * * * 2015-10-24 01:05:58,909 INFO [reportsdb-000] [StatisticFlushJob] [symmetric-engine-startup-0] Starting job.stat.flush with cron expression: 0 0/5 * * * * 2015-10-24 01:05:58,923 INFO [reportsdb-000] [SyncTriggersJob] [symmetric-engine-startup-0] Starting job.synctriggers with cron expression: 0 0 0 * * * 2015-10-24 01:05:58,923 INFO [reportsdb-000] [HeartbeatJob] [symmetric-engine-startup-0] Starting job.heartbeat on periodic schedule: every 900000ms with the first run at Sat Oct 24 01:06:08 PKT 2015 2015-10-24 01:05:58,937 INFO [reportsdb-000] [WatchdogJob] [symmetric-engine-startup-0] Starting job.watchdog on periodic schedule: every 3600000ms with the first run at Sat Oct 24 01:06:08 PKT 2015 2015-10-24 01:05:58,937 INFO [reportsdb-000] [StageManagementJob] [symmetric-engine-startup-0] Starting job.stage.management on periodic schedule: every 15000ms with the first run at Sat Oct 24 01:06:08 PKT 2015 2015-10-24 01:05:58,951 INFO [reportsdb-000] [JobManager] [symmetric-engine-startup-0] Job job.refresh.cache not configured for auto start 2015-10-24 01:05:58,951 INFO [reportsdb-000] [JobManager] [symmetric-engine-startup-0] Job job.file.sync.tracker not configured for auto start 2015-10-24 01:05:58,951 INFO [reportsdb-000] [JobManager] [symmetric-engine-startup-0] Job job.file.sync.pull not configured for auto start 2015-10-24 01:05:58,951 INFO [reportsdb-000] [JobManager] [symmetric-engine-startup-0] Job job.file.sync.push not configured for auto start 2015-10-24 01:05:58,965 INFO [reportsdb-000] [InitialLoadExtractorJob] [symmetric-engine-startup-0] Starting job.initial.load.extract on periodic schedule: every 10000ms with the first run at Sat Oct 24 01:06:08 PKT 2015 2015-10-24 01:05:58,965 INFO [reportsdb-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Started SymmetricDS 2015-10-24 01:05:58,965 INFO [reportsdb-000] [AbstractSymmetricEngine] [symmetric-engine-startup-0] SymmetricDS: type=server, name=reportsdb-000, version=3.7.25, groupId=reportsdb, externalId=000, databaseName=Microsoft SQL Server, databaseVersion=11.0, driverName=jTDS Type 4 JDBC Driver for MS SQL Server and Sybase, driverVersion=1.2.8 2015-10-24 01:06:08,211 INFO [reportsdb-000] [NodeCommunicationService] [reportsdb-000-job-3] pull will use 10 threads 2015-10-24 01:06:08,258 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'config' channel is NOT in common batch mode 2015-10-24 01:06:08,536 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'reload' channel is NOT in common batch mode 2015-10-24 01:06:08,552 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'heartbeat' channel is NOT in common batch mode 2015-10-24 01:06:08,660 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'RESTAURANT' channel is in common batch mode 2015-10-24 01:06:08,660 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'RESTAURANT' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,706 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'SHIFT' channel is in common batch mode 2015-10-24 01:06:08,706 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'SHIFT' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,722 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TERMINAL' channel is in common batch mode 2015-10-24 01:06:08,737 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TERMINAL' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,737 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_TYPE' channel is in common batch mode 2015-10-24 01:06:08,737 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_TYPE' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,753 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'EMPLOYEE_JOB_CODE' channel is in common batch mode 2015-10-24 01:06:08,753 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'EMPLOYEE_JOB_CODE' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,768 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USERS' channel is in common batch mode 2015-10-24 01:06:08,768 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USERS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,784 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_JOB_CODES' channel is in common batch mode 2015-10-24 01:06:08,784 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_JOB_CODES' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,799 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOMER' channel is in common batch mode 2015-10-24 01:06:08,799 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOMER' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,815 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ATTENDENCE_HISTORY' channel is in common batch mode 2015-10-24 01:06:08,815 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ATTENDENCE_HISTORY' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,830 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_CATEGORY' channel is in common batch mode 2015-10-24 01:06:08,830 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_CATEGORY' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,846 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_GROUP' channel is in common batch mode 2015-10-24 01:06:08,846 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_GROUP' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,861 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COUPON_AND_DISCOUNT' channel is in common batch mode 2015-10-24 01:06:08,861 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COUPON_AND_DISCOUNT' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,877 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMBO_CATEGORY' channel is in common batch mode 2015-10-24 01:06:08,877 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMBO_CATEGORY' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,892 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TAX' channel is in common batch mode 2015-10-24 01:06:08,892 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TAX' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,908 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_ITEM' channel is in common batch mode 2015-10-24 01:06:08,908 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_ITEM' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,923 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMBO_ITEM' channel is in common batch mode 2015-10-24 01:06:08,923 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMBO_ITEM' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,939 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'END_OF_DAY_REPORT' channel is in common batch mode 2015-10-24 01:06:08,939 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'END_OF_DAY_REPORT' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,954 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DRIVER_REPORT' channel is in common batch mode 2015-10-24 01:06:08,954 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DRIVER_REPORT' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:08,985 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DRAWER_PULL_REPORT' channel is in common batch mode 2015-10-24 01:06:08,985 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DRAWER_PULL_REPORT' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,000 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY' channel is in common batch mode 2015-10-24 01:06:09,000 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,016 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMPTICKETS' channel is in common batch mode 2015-10-24 01:06:09,016 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMPTICKETS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,031 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_TYPE' channel is in common batch mode 2015-10-24 01:06:09,031 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_TYPE' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,031 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'VOIDTICKETS' channel is in common batch mode 2015-10-24 01:06:09,047 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'VOIDTICKETS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,062 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY_RUN' channel is in common batch mode 2015-10-24 01:06:09,062 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY_RUN' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,062 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET' channel is in common batch mode 2015-10-24 01:06:09,078 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,078 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'GRATUITY' channel is in common batch mode 2015-10-24 01:06:09,093 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'GRATUITY' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,093 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_ITEM' channel is in common batch mode 2015-10-24 01:06:09,093 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_ITEM' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,109 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMP_REASONS' channel is in common batch mode 2015-10-24 01:06:09,124 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COMP_REASONS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,124 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COOKING_INSTRUCTION' channel is in common batch mode 2015-10-24 01:06:09,124 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'COOKING_INSTRUCTION' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,140 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CREDIT_CARD_INFO' channel is in common batch mode 2015-10-24 01:06:09,155 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CREDIT_CARD_INFO' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,155 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOMER_CREDIT_CARDS' channel is in common batch mode 2015-10-24 01:06:09,155 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOMER_CREDIT_CARDS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,171 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOM_PAYMENT_TYPE' channel is in common batch mode 2015-10-24 01:06:09,171 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'CUSTOM_PAYMENT_TYPE' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,186 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'RETURN_REASON' channel is in common batch mode 2015-10-24 01:06:09,186 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'RETURN_REASON' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,201 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY_RETURN_REASON' channel is in common batch mode 2015-10-24 01:06:09,201 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'DELIVERY_RETURN_REASON' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,217 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'EMPLOYEE_DEPOSITS' channel is in common batch mode 2015-10-24 01:06:09,217 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'EMPLOYEE_DEPOSITS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,232 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'FAILED_OLO_TICKETS' channel is in common batch mode 2015-10-24 01:06:09,232 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'FAILED_OLO_TICKETS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,248 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKETITEM_MODIFIERGROUP' channel is in common batch mode 2015-10-24 01:06:09,263 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKETITEM_MODIFIERGROUP' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,263 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_COOKING_INSTRUCTION' channel is in common batch mode 2015-10-24 01:06:09,310 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_COOKING_INSTRUCTION' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,341 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_COUPON_DISCOUNT' channel is in common batch mode 2015-10-24 01:06:09,341 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_COUPON_DISCOUNT' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,341 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_ITEM_MODIFIER' channel is in common batch mode 2015-10-24 01:06:09,341 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TICKET_ITEM_MODIFIER' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,356 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ACTION_HISTORY' channel is in common batch mode 2015-10-24 01:06:09,356 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ACTION_HISTORY' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,372 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ADDRESSES_LATITUDES_LONGITUDES' channel is in common batch mode 2015-10-24 01:06:09,387 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'ADDRESSES_LATITUDES_LONGITUDES' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,387 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'APPLICATION_DATA' channel is in common batch mode 2015-10-24 01:06:09,387 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'APPLICATION_DATA' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,403 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_MENUMODIFIERS' channel is in common batch mode 2015-10-24 01:06:09,418 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_MENUMODIFIERS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,418 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_MODIFIERGROUP' channel is in common batch mode 2015-10-24 01:06:09,418 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_MODIFIERGROUP' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,434 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_SHIFT' channel is in common batch mode 2015-10-24 01:06:09,434 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENUITEM_SHIFT' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,449 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_ITEM_SUGGESTIONS' channel is in common batch mode 2015-10-24 01:06:09,449 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_ITEM_SUGGESTIONS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,464 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_MODIFIER' channel is in common batch mode 2015-10-24 01:06:09,464 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_MODIFIER' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,480 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_MODIFIER_GROUP' channel is in common batch mode 2015-10-24 01:06:09,480 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MENU_MODIFIER_GROUP' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,495 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MODIFIERGROUP_SUBCATEGORY' channel is in common batch mode 2015-10-24 01:06:09,495 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'MODIFIERGROUP_SUBCATEGORY' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,511 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'PAYOUT_REASONS' channel is in common batch mode 2015-10-24 01:06:09,511 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'PAYOUT_REASONS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,526 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'PAYOUT_RECEPIENTS' channel is in common batch mode 2015-10-24 01:06:09,526 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'PAYOUT_RECEPIENTS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,542 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TRANSACTIONS' channel is in common batch mode 2015-10-24 01:06:09,542 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'TRANSACTIONS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,557 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_PERMISSION' channel is in common batch mode 2015-10-24 01:06:09,557 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_PERMISSION' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,573 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_PERMISSIONS' channel is in common batch mode 2015-10-24 01:06:09,573 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_PERMISSIONS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,588 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_TICKETS' channel is in common batch mode 2015-10-24 01:06:09,588 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_TICKETS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,604 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_USER_PERMISSION' channel is in common batch mode 2015-10-24 01:06:09,604 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'USER_USER_PERMISSION' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,619 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'VOID_REASONS' channel is in common batch mode 2015-10-24 01:06:09,619 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'VOID_REASONS' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,635 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'default' channel is in common batch mode 2015-10-24 01:06:09,635 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'default' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,650 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'dynamic' channel is in common batch mode 2015-10-24 01:06:09,650 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] The 'dynamic' channel for the 'reportsdb' node group has only default routers assigned to it. Change data won't be selected during routing 2015-10-24 01:06:09,666 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-2] Routed 3 data events in 1501 ms 2015-10-24 01:06:59,385 INFO [reportsdb-000] [RegistrationService] [qtp28759214-16] Registration was opened for 001 2015-10-24 01:06:59,401 INFO [reportsdb-000] [MsSqlSymmetricDialect] [qtp28759214-16] This database DOES support disabling triggers during a symmetricds data load 2015-10-24 01:07:03,432 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-17] Routed 4 data events in 438 ms 2015-10-24 01:07:24,619 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-12] Routed 1 data events in 734 ms 2015-10-24 01:08:15,432 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:15,807 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:16,463 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition:
2015-10-24 01:08:16,510 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "menu_modifier_group"( "id" INT NOT NULL, "modified_time" DATETIME NOT NULL, "name" VARCHAR(60), "enabled" SMALLINT, "exclusived" SMALLINT, "required" SMALLINT, "category" VARCHAR(24), PRIMARY KEY ("id") ); CREATE INDEX "mg_enable" ON "menu_modifier_group" ("enabled"); 2015-10-24 01:08:16,635 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:17,072 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition:
2015-10-24 01:08:17,104 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "modifiergroup_subcategory"( "id" INT NOT NULL, "name" VARCHAR(24), "modified_time" DATETIME, "enabled" SMALLINT, "exclusived" SMALLINT, "required" SMALLINT, "category" VARCHAR(60), "view_order_value" INT, "subcat_id" INT, "style_name" VARCHAR(255), PRIMARY KEY ("id") ); CREATE INDEX "modifiergroup_subcategory_name_idx" ON "modifiergroup_subcategory" ("name"); ALTER TABLE "modifiergroup_subcategory" ADD CONSTRAINT "fk7d4cb47d7b72790" FOREIGN KEY ("subcat_id") REFERENCES "menu_modifier_group" ("id"); ALTER TABLE "modifiergroup_subcategory" ADD CONSTRAINT "fk7d4cb474324ed16" FOREIGN KEY ("subcat_id") REFERENCES "menu_modifier_group" ("id"); 2015-10-24 01:08:17,213 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:17,666 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition:
2015-10-24 01:08:17,682 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "tax"( "id" INT NOT NULL IDENTITY (1,1) , "modified_time" DATETIME NOT NULL, "name" VARCHAR(20) NOT NULL, "rate" FLOAT, PRIMARY KEY ("id") ); 2015-10-24 01:08:17,760 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:18,244 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition:
2015-10-24 01:08:18,276 INFO [reportsdb-000] [RouterService] [reportsdb-000-job-20] Routed 1 data events in 532 ms 2015-10-24 01:08:18,276 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "menu_modifier"( "id" INT NOT NULL, "modified_time" DATETIME NOT NULL, "name" VARCHAR(50), "price" FLOAT, "extra_price" FLOAT, "enable" SMALLINT, "print_to_kitchen" SMALLINT, "group_id" INT, "tax_id" INT, "view_order_value" INT, "button_color" INT, "in_stock" SMALLINT, "group_subcat_id" INT, "subcat_id" INT, "plu" INT, PRIMARY KEY ("id") ); CREATE INDEX "modifierenabled" ON "menu_modifier" ("enable"); ALTER TABLE "menu_modifier" ADD CONSTRAINT "fk59b6b1b717a96f7" FOREIGN KEY ("subcat_id") REFERENCES "modifiergroup_subcategory" ("id"); ALTER TABLE "menu_modifier" ADD CONSTRAINT "fk59b6b1b7f8d2aeb1" FOREIGN KEY ("subcat_id") REFERENCES "modifiergroup_subcategory" ("id"); ALTER TABLE "menu_modifier" ADD CONSTRAINT "fk59b6b1b7d9d8e77d" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id"); ALTER TABLE "menu_modifier" ADD CONSTRAINT "fk59b6b1b7a4802f83" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id"); 2015-10-24 01:08:18,338 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:18,572 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition:
2015-10-24 01:08:18,635 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "customer"( "id" INT NOT NULL IDENTITY (1,1) , "mobile" VARCHAR(250), "firstname" VARCHAR(100), "lastname" VARCHAR(250), "email" VARCHAR(100), "city" VARCHAR(20), "state" VARCHAR(30), "zip" VARCHAR(10), "birthday" DATETIME, "birthday_string" VARCHAR(255), "customernotes" VARCHAR(5000), "address1" VARCHAR(250), "address2" VARCHAR(250), "current_address" VARCHAR(255), "address2line1" VARCHAR(250), "address2line2" VARCHAR(250), "address3line1" VARCHAR(250), "address3line2" VARCHAR(250), "address4line1" VARCHAR(250), "address4line2" VARCHAR(250), "address5line1" VARCHAR(250), "address5line2" VARCHAR(250), "address6line1" VARCHAR(250), "address6line2" VARCHAR(250), "address2_1" VARCHAR(100), "address2_2" VARCHAR(100), "address3_1" VARCHAR(100), "address3_2" VARCHAR(100), "address4_1" VARCHAR(100), "address4_2" VARCHAR(100), "address5_1" VARCHAR(100), "address5_2" VARCHAR(100), "address6_1" VARCHAR(100), "address6_2" VARCHAR(100), "selected_address_index" INT, "opt_cc_token" SMALLINT DEFAULT 1 NOT NULL, PRIMARY KEY ("id") ); 2015-10-24 01:08:18,729 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:19,166 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition:
2015-10-24 01:08:19,182 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "delivery"( "delivery_id" INT NOT NULL, "employee_id" INT NOT NULL, "delivery_start_time" DATETIME, "arrival_time" DATETIME, PRIMARY KEY ("delivery_id") ); 2015-10-24 01:08:19,244 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:19,619 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition:
2015-10-24 01:08:19,635 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "employee_job_code"( "id" INT NOT NULL, "title" VARCHAR(50) NOT NULL, PRIMARY KEY ("id") ); 2015-10-24 01:08:19,729 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:20,182 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition:
2015-10-24 01:08:20,197 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "shift"( "id" INT NOT NULL IDENTITY (1,1) , "name" VARCHAR(60) NOT NULL, "start_time" DATETIME, "end_time" DATETIME, "shift_len" BIGINT, PRIMARY KEY ("id") ); CREATE UNIQUE INDEX "sql091028025752330" ON "shift" ("name"); 2015-10-24 01:08:20,276 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:20,651 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition:
2015-10-24 01:08:20,666 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "terminal"( "id" INT NOT NULL, "modified_time" DATETIME NOT NULL, "name" VARCHAR(60), "opening_balance" FLOAT, "current_balance" FLOAT, "is_db_machine" SMALLINT, PRIMARY KEY ("id") ); 2015-10-24 01:08:20,744 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:21,182 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition:
2015-10-24 01:08:21,197 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "user_type"( "id" INT NOT NULL IDENTITY (1,1) , "p_name" VARCHAR(60), PRIMARY KEY ("id") ); 2015-10-24 01:08:21,291 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:21,744 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition:
2015-10-24 01:08:21,791 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "users"( "auto_id" INT NOT NULL IDENTITY (1,1) , "modified_time" DATETIME NOT NULL, "user_id" INT, "user_pass" VARCHAR(16) NOT NULL, "first_name" VARCHAR(30), "last_name" VARCHAR(30), "ssn" VARCHAR(30) NOT NULL, "cost_per_hour" FLOAT, "clocked_in" SMALLINT, "last_clock_in_time" DATETIME, "shift_id" INT, "currentterminal" INT, "n_user_type" INT, "cash_out_amount" FLOAT, "current_position" VARBINARY(255), "job_code" INT, "show_in_payroll" SMALLINT, "delivering" SMALLINT, PRIMARY KEY ("auto_id") ); ALTER TABLE "users" ADD CONSTRAINT "fk4d495e84b915f0e" FOREIGN KEY ("job_code") REFERENCES "employee_job_code" ("id"); ALTER TABLE "users" ADD CONSTRAINT "fk4d495e8c49ece14" FOREIGN KEY ("job_code") REFERENCES "employee_job_code" ("id"); ALTER TABLE "users" ADD CONSTRAINT "fk4d495e8b86b475d" FOREIGN KEY ("shift_id") REFERENCES "shift" ("id"); ALTER TABLE "users" ADD CONSTRAINT "fk4d495e87660a5e3" FOREIGN KEY ("shift_id") REFERENCES "shift" ("id"); ALTER TABLE "users" ADD CONSTRAINT "fk4d495e82c5dcdae" FOREIGN KEY ("currentterminal") REFERENCES "terminal" ("id"); ALTER TABLE "users" ADD CONSTRAINT "fk4d495e8d9409968" FOREIGN KEY ("currentterminal") REFERENCES "terminal" ("id"); ALTER TABLE "users" ADD CONSTRAINT "fk4d495e8dc98527f" FOREIGN KEY ("n_user_type") REFERENCES "user_type" ("id"); ALTER TABLE "users" ADD CONSTRAINT "fk4d495e8897b1e39" FOREIGN KEY ("n_user_type") REFERENCES "user_type" ("id"); 2015-10-24 01:08:21,901 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:22,369 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition:
2015-10-24 01:08:22,401 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "delivery_run"( "id" INT NOT NULL, "start_time" DATETIME NOT NULL, "modified_time" DATETIME NOT NULL, "return_time" DATETIME, "total_order_amount" FLOAT, "number_of_orders" INT, "driver_user_id" INT, PRIMARY KEY ("id") ); ALTER TABLE "delivery_run" ADD CONSTRAINT "fkb2d85fa0e2248b80" FOREIGN KEY ("driver_user_id") REFERENCES "users" ("auto_id"); 2015-10-24 01:08:22,479 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:22,916 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition:
2015-10-24 01:08:22,947 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "gratuity"( "id" INT NOT NULL IDENTITY (1,1) , "modified_time" DATETIME NOT NULL, "amount" FLOAT, "paid" SMALLINT, "ticket_id" INT, "owner_id" INT, "terminal_id" INT, PRIMARY KEY ("id") ); ALTER TABLE "gratuity" ADD CONSTRAINT "fk34e4e3777df00477" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id"); ALTER TABLE "gratuity" ADD CONSTRAINT "fk34e4e3772ad2d031" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id"); ALTER TABLE "gratuity" ADD CONSTRAINT "fk34e4e3771fc5a4af" FOREIGN KEY ("owner_id") REFERENCES "users" ("auto_id"); ALTER TABLE "gratuity" ADD CONSTRAINT "fk34e4e377aa075d69" FOREIGN KEY ("owner_id") REFERENCES "users" ("auto_id"); 2015-10-24 01:08:23,213 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:23,651 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition:
2015-10-24 01:08:23,682 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "ticket_type"( "id" INT NOT NULL, "type_name" VARCHAR(16) NOT NULL, "surcharge" FLOAT, "tax_id" INT, PRIMARY KEY ("id") ); ALTER TABLE "ticket_type" ADD CONSTRAINT "fk97a4688dd9d8e77d" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id"); ALTER TABLE "ticket_type" ADD CONSTRAINT "fk97a4688da4802f83" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id"); 2015-10-24 01:08:23,854 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:24,307 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition:
2015-10-24 01:08:24,416 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "ticket"( "id" INT NOT NULL IDENTITY (1,1) , "modified_time" DATETIME NOT NULL, "create_date" DATETIME, "closing_date" DATETIME, "active_date" DATETIME, "creation_hour" INT, "paid" SMALLINT, "voided" SMALLINT, "reason" VARCHAR(255), "wasted" SMALLINT, "settled" SMALLINT, "drawer_resetted" SMALLINT, "sub_total" FLOAT, "total_discount" FLOAT, "total_tax" FLOAT, "total_price" FLOAT, "paid_amount" FLOAT, "due_amount" FLOAT, "table_number" INT, "number_of_guests" INT, "transaction_type" VARCHAR(20), "transaction_code" VARCHAR(60), "bar_code" VARCHAR(60), "card_type" VARCHAR(60), "card_number" VARCHAR(60), "is_tax_exempt" SMALLINT, "is_re_opened" SMALLINT, "shift_id" INT, "owner_id" INT, "gratuity_id" INT, "void_by_user" INT, "terminal_id" INT, "cust_lastname" VARCHAR(200), "cust_firstname" VARCHAR(200), "delivery_address" VARCHAR(500), "cust_phoneno" VARCHAR(15), "ticket_status" VARCHAR(20), "driver_id" INT, "driver_name" VARCHAR(250), "cust_phone_no" VARCHAR(255), "is_delivery" SMALLINT, "delivery_id" INT, "delivery_status" INT, "delivery_start_time" DATETIME, "delivery_end_time" DATETIME, "deliverer_id" INT, "cust_mobile_number" VARCHAR(255), "comped" SMALLINT, "online_order" SMALLINT, "ticket_type" INT, "void_reason" VARCHAR(255), "notes" VARCHAR(255), "transaction_subtype" VARCHAR(1), "split_ticket" SMALLINT, "split_ticket_id" VARCHAR(255), "tip" FLOAT, "display_id" INT, "surcharge" FLOAT, "customer_id" INT, "online_invoice_number" VARCHAR(25), "member_order" SMALLINT, "hearts_applied" SMALLINT, "delivery_run_id" INT, "hearts_used" SMALLINT, "amount_of_hearts_used" INT, "amount_of_hearts_applied" INT, PRIMARY KEY ("id") ); CREATE INDEX "creationhour" ON "ticket" ("creation_hour"); CREATE INDEX "drawerresetted" ON "ticket" ("drawer_resetted"); CREATE INDEX "ticketactivedate" ON "ticket" ("active_date"); CREATE INDEX "ticketclosingdate" ON "ticket" ("closing_date"); CREATE INDEX "ticketcreatedate" ON "ticket" ("create_date"); CREATE INDEX "ticketpaid" ON "ticket" ("paid"); CREATE INDEX "ticketsettled" ON "ticket" ("settled"); CREATE INDEX "tickettransactiontype" ON "ticket" ("transaction_type"); CREATE INDEX "ticketvoided" ON "ticket" ("voided"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0cf1397137" FOREIGN KEY ("customer_id") REFERENCES "customer" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0c9e1c3cf1" FOREIGN KEY ("customer_id") REFERENCES "customer" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0cdc30bd31" FOREIGN KEY ("delivery_id") REFERENCES "delivery" ("delivery_id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0cc082e694" FOREIGN KEY ("delivery_run_id") REFERENCES "delivery_run" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0c14a61e97" FOREIGN KEY ("gratuity_id") REFERENCES "gratuity" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0cc188ea51" FOREIGN KEY ("gratuity_id") REFERENCES "gratuity" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0cb86b475d" FOREIGN KEY ("shift_id") REFERENCES "shift" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0c7660a5e3" FOREIGN KEY ("shift_id") REFERENCES "shift" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0c7df00477" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0c2ad2d031" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0cf8c545f0" FOREIGN KEY ("ticket_type") REFERENCES "ticket_type" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0cf8240b2a" FOREIGN KEY ("ticket_type") REFERENCES "ticket_type" ("id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0ce43d7670" FOREIGN KEY ("deliverer_id") REFERENCES "users" ("auto_id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0c1fc5a4af" FOREIGN KEY ("owner_id") REFERENCES "users" ("auto_id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0c9528e190" FOREIGN KEY ("void_by_user") REFERENCES "users" ("auto_id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0c6e7f2f2a" FOREIGN KEY ("deliverer_id") REFERENCES "users" ("auto_id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0ce672088" FOREIGN KEY ("delivery_id") REFERENCES "users" ("auto_id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0caa075d69" FOREIGN KEY ("owner_id") REFERENCES "users" ("auto_id"); ALTER TABLE "ticket" ADD CONSTRAINT "fk937b5f0c1f6a9a4a" FOREIGN KEY ("void_by_user") REFERENCES "users" ("auto_id"); 2015-10-24 01:08:24,682 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:25,135 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition:
2015-10-24 01:08:25,166 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "user_tickets"( "user_id" INT NOT NULL, "ticket_id" INT NOT NULL, PRIMARY KEY ("user_id", "ticket_id") ); ALTER TABLE "user_tickets" ADD CONSTRAINT "fk925912531d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "user_tickets" ADD CONSTRAINT "fk925912531df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "user_tickets" ADD CONSTRAINT "fk92591253b3def497" FOREIGN KEY ("user_id") REFERENCES "users" ("auto_id"); ALTER TABLE "user_tickets" ADD CONSTRAINT "fk925912533e20ad51" FOREIGN KEY ("user_id") REFERENCES "users" ("auto_id"); 2015-10-24 01:08:25,260 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:25,697 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition:
2015-10-24 01:08:25,713 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "menu_category"( "id" INT NOT NULL, "modified_time" DATETIME NOT NULL, "name" VARCHAR(20) NOT NULL, "visible" SMALLINT, "beverage" SMALLINT, PRIMARY KEY ("id") ); CREATE INDEX "food_category_visible" ON "menu_category" ("visible"); 2015-10-24 01:08:25,791 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:26,244 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition:
2015-10-24 01:08:26,276 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "menu_group"( "id" INT NOT NULL, "modified_time" DATETIME NOT NULL, "name" VARCHAR(20) NOT NULL, "visible" SMALLINT, "category_id" INT, "menu_category_id" INT, "bar" SMALLINT, "view_order_value" INT, "button_color" INT, "is_default_screen" SMALLINT, "print_order" INT, PRIMARY KEY ("id") ); CREATE INDEX "menugroupvisible" ON "menu_group" ("visible"); ALTER TABLE "menu_group" ADD CONSTRAINT "fk4dc1ab7f8b722136" FOREIGN KEY ("category_id") REFERENCES "menu_category" ("id"); ALTER TABLE "menu_group" ADD CONSTRAINT "fk4dc1ab7ff4397e56" FOREIGN KEY ("menu_category_id") REFERENCES "menu_category" ("id"); ALTER TABLE "menu_group" ADD CONSTRAINT "fk4dc1ab7f2e347ff0" FOREIGN KEY ("category_id") REFERENCES "menu_category" ("id"); ALTER TABLE "menu_group" ADD CONSTRAINT "fk4dc1ab7f96fbdd10" FOREIGN KEY ("menu_category_id") REFERENCES "menu_category" ("id"); 2015-10-24 01:08:26,385 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:26,822 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition:
2015-10-24 01:08:26,854 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "menu_item"( "id" INT NOT NULL, "modified_time" DATETIME NOT NULL, "name" VARCHAR(50) NOT NULL, "price" FLOAT NOT NULL, "discount_rate" FLOAT, "visible" SMALLINT, "group_id" INT, "tax_id" INT, "plu" INT, "view_order_value" INT, "button_color" INT, "next_screen" VARCHAR(30), "buffet" SMALLINT, "print_to_kitchen" SMALLINT, "available_online" SMALLINT, "online_specific" VARCHAR(255), "enabled" SMALLINT, PRIMARY KEY ("id") ); ALTER TABLE "menu_item" ADD CONSTRAINT "fk4cd5a1f36211fe9e" FOREIGN KEY ("group_id") REFERENCES "menu_group" ("id"); ALTER TABLE "menu_item" ADD CONSTRAINT "fk4cd5a1f35188aa24" FOREIGN KEY ("group_id") REFERENCES "menu_group" ("id"); ALTER TABLE "menu_item" ADD CONSTRAINT "fk4cd5a1f3d9d8e77d" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id"); ALTER TABLE "menu_item" ADD CONSTRAINT "fk4cd5a1f3a4802f83" FOREIGN KEY ("tax_id") REFERENCES "tax" ("id"); 2015-10-24 01:08:26,979 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:27,447 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition:
2015-10-24 01:08:27,494 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "ticket_item"( "id" INT NOT NULL IDENTITY (1,1) , "modified_time" DATETIME NOT NULL, "item_id" INT, "item_count" INT, "item_name" VARCHAR(30), "group_name" VARCHAR(20), "category_name" VARCHAR(20), "item_price" FLOAT, "discount_rate" FLOAT, "item_tax_rate" FLOAT, "sub_total" FLOAT, "sub_total_with_modifiers" FLOAT, "discount" FLOAT, "tax_amount" FLOAT, "tax_amount_with_modifiers" FLOAT, "total_price" FLOAT, "total_price_with_modifiers" FLOAT, "beverage" SMALLINT, "print_to_kitchen" SMALLINT, "has_modiiers" SMALLINT, "printed_to_kitchen" SMALLINT, "ticket_id" INT, "item_order" INT, "voided" SMALLINT DEFAULT 0, "comped" SMALLINT DEFAULT 0, "buffet" SMALLINT, "menu_item" INT, "already_sent" SMALLINT, "print_order_value" INT, "void_reason" VARCHAR(255), "construction_zone" SMALLINT, PRIMARY KEY ("id") ); ALTER TABLE "ticket_item" ADD CONSTRAINT "fk979f546664931efc" FOREIGN KEY ("menu_item") REFERENCES "menu_item" ("id"); ALTER TABLE "ticket_item" ADD CONSTRAINT "fk979f54661d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "ticket_item" ADD CONSTRAINT "fk979f54661df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); 2015-10-24 01:08:27,619 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:28,072 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition:
2015-10-24 01:08:28,104 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "comp_reasons"( "id" INT NOT NULL IDENTITY (1,1) , "reason_text" VARCHAR(255), "ticket_id" INT, "item_id" INT, "ticket_item_id" INT, PRIMARY KEY ("id") ); ALTER TABLE "comp_reasons" ADD CONSTRAINT "fkbd53115f1d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "comp_reasons" ADD CONSTRAINT "fkbd53115f1df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "comp_reasons" ADD CONSTRAINT "fkbd53115fdf674cd0" FOREIGN KEY ("ticket_item_id") REFERENCES "ticket_item" ("id"); ALTER TABLE "comp_reasons" ADD CONSTRAINT "fkbd53115fdec6120a" FOREIGN KEY ("ticket_item_id") REFERENCES "ticket_item" ("id"); 2015-10-24 01:08:28,213 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:28,760 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition:
2015-10-24 01:08:28,776 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "credit_card_info"( "id" INT NOT NULL IDENTITY (1,1) , "customer_id" INT, "card_number" VARCHAR(30), "card_type" VARCHAR(30), "record_no" VARCHAR(150), PRIMARY KEY ("id") ); ALTER TABLE "credit_card_info" ADD CONSTRAINT "fk5a3902b7f1397137" FOREIGN KEY ("customer_id") REFERENCES "customer" ("id"); 2015-10-24 01:08:28,901 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:29,322 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition:
2015-10-24 01:08:29,369 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "end_of_day_report"( "id" NUMERIC(5,0) NOT NULL, "date" DATETIME NOT NULL, "total_sales" FLOAT, "total_voids" FLOAT, "total_comps" FLOAT, "total_labor_cost" FLOAT, "total_labor_hours" INT, "num_tickets" INT, "num_deliveries" INT, "average_claim_time" BIGINT, "average_delivery_route_time" BIGINT, "final_ticket_number" INT NOT NULL, "total_labor_hrs" FLOAT, "timestamp" DATETIME, "cash_deposit" FLOAT, "discounts" FLOAT, "charges" FLOAT, "gift_card_redeems" FLOAT, "gift_card_sales" FLOAT, "gross_sales" FLOAT, "net_sales" FLOAT, "net_taxes" FLOAT, "over_under" FLOAT, "payouts" FLOAT, "sales_beverages" FLOAT, "sales_food" FLOAT, "salesmerch" FLOAT, "tax_beverages" FLOAT, "tax_food" FLOAT, "tax_merch" FLOAT, "charge_tips" FLOAT, "delivery_charges" FLOAT, "delivery_fees_paid_out" FLOAT, "pos_version" INT, PRIMARY KEY ("id") ); CREATE UNIQUE INDEX "sql130330031001490" ON "end_of_day_report" ("date"); CREATE UNIQUE INDEX "sql130330031001491" ON "end_of_day_report" ("final_ticket_number"); 2015-10-24 01:08:29,494 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:29,885 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition:
2015-10-24 01:08:29,901 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "addresses_latitudes_longitudes"( "id" INT NOT NULL, "customer_id" INT, "address_1" VARCHAR(255), "address_2" VARCHAR(255), "latitude" VARCHAR(255), "longitude" VARCHAR(255), "is_delivery" SMALLINT, PRIMARY KEY ("id") ); ALTER TABLE "addresses_latitudes_longitudes" ADD CONSTRAINT "fk4a889b19f1397137" FOREIGN KEY ("customer_id") REFERENCES "customer" ("id"); ALTER TABLE "addresses_latitudes_longitudes" ADD CONSTRAINT "fk4a889b199e1c3cf1" FOREIGN KEY ("customer_id") REFERENCES "customer" ("id"); 2015-10-24 01:08:30,010 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:30,432 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition:
2015-10-24 01:08:30,447 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "ticket_coupon_discount"( "id" INT NOT NULL IDENTITY (1,1) , "coupon_discount_id" INT, "name" VARCHAR(30), "type" INT, "value" FLOAT, "ticket_id" INT, "d_order" INT, PRIMARY KEY ("id") ); ALTER TABLE "ticket_coupon_discount" ADD CONSTRAINT "fk3a1f32071d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "ticket_coupon_discount" ADD CONSTRAINT "fk3a1f32071df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); 2015-10-24 01:08:30,541 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:30,994 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition:
2015-10-24 01:08:31,010 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "ticketitem_modifiergroup"( "id" INT NOT NULL IDENTITY (1,1) , "modified_time" DATETIME NOT NULL, "group_id" INT, "min_quantity" INT, "max_quantity" INT, "parent" INT, "ticketitem_id" INT, "item_order" INT, PRIMARY KEY ("id") ); ALTER TABLE "ticketitem_modifiergroup" ADD CONSTRAINT "fk21d455c8a7dd55e6" FOREIGN KEY ("parent") REFERENCES "ticket_item" ("id"); ALTER TABLE "ticketitem_modifiergroup" ADD CONSTRAINT "fk21d455c8dcbc5677" FOREIGN KEY ("ticketitem_id") REFERENCES "ticket_item" ("id"); ALTER TABLE "ticketitem_modifiergroup" ADD CONSTRAINT "fk21d455c8a73c1b20" FOREIGN KEY ("parent") REFERENCES "ticket_item" ("id"); ALTER TABLE "ticketitem_modifiergroup" ADD CONSTRAINT "fk21d455c8dc1b1bb1" FOREIGN KEY ("ticketitem_id") REFERENCES "ticket_item" ("id"); 2015-10-24 01:08:31,119 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:31,604 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition:
2015-10-24 01:08:31,619 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "menu_item_suggestions"( "id" INT NOT NULL, "type" INT NOT NULL, "parent_item_plu" INT NOT NULL, "suggestion_plu" INT NOT NULL, PRIMARY KEY ("id") ); 2015-10-24 01:08:31,713 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:32,166 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition:
2015-10-24 01:08:32,166 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "return_reason"( "id" INT NOT NULL, "text" VARCHAR(256) NOT NULL, PRIMARY KEY ("id") ); 2015-10-24 01:08:32,260 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:32,682 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition:
2015-10-24 01:08:32,697 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "user_permission"( "name" VARCHAR(40) NOT NULL, PRIMARY KEY ("name") ); 2015-10-24 01:08:32,791 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:33,244 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition:
2015-10-24 01:08:33,291 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "drawer_pull_report"( "id" INT NOT NULL IDENTITY (1,1) , "report_time" DATETIME, "reg" VARCHAR(15), "ticket_count" INT, "begin_cash" FLOAT, "net_sales" FLOAT, "sales_tax" FLOAT, "cash_tax" FLOAT, "total_revenue" FLOAT, "gross_receipts" FLOAT, "giftcertreturncount" INT, "giftcertreturnamount" FLOAT, "giftcertchangeamount" FLOAT, "cash_receipt_no" INT, "cash_receipt_amount" FLOAT, "credit_card_receipt_no" INT, "credit_card_receipt_amount" FLOAT, "debit_card_receipt_no" INT, "debit_card_receipt_amount" FLOAT, "receipt_differential" FLOAT, "cash_back" FLOAT, "cash_tips" FLOAT, "charged_tips" FLOAT, "tips_paid" FLOAT, "tips_differential" FLOAT, "pay_out_no" INT, "pay_out_amount" FLOAT, "drawer_bleed_no" INT, "drawer_bleed_amount" FLOAT, "drawer_accountable" FLOAT, "cash_to_deposit" FLOAT, "variance" FLOAT, "totalvoidwst" FLOAT, "totalvoid" FLOAT, "totaldiscountcount" INT, "totaldiscountamount" FLOAT, "totaldiscountsales" FLOAT, "totaldiscountguest" INT, "totaldiscountpartysize" INT, "totaldiscountchecksize" INT, "totaldiscountpercentage" FLOAT, "totaldiscountratio" FLOAT, "terminal_id" INT, "totalcomp" FLOAT, PRIMARY KEY ("id") ); CREATE INDEX "drawer_report_time" ON "drawer_pull_report" ("report_time"); ALTER TABLE "drawer_pull_report" ADD CONSTRAINT "fkaec362207df00477" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id"); ALTER TABLE "drawer_pull_report" ADD CONSTRAINT "fkaec362202ad2d031" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id"); 2015-10-24 01:08:33,463 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:33,932 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition:
2015-10-24 01:08:33,947 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "comptickets"( "dpreport_id" INT NOT NULL, "code" INT, "reason" VARCHAR(255), "hast" VARCHAR(255), "quantity" INT, "amount" FLOAT, "ticket_id" INT, "item_id" INT, "comped_by" VARCHAR(100), PRIMARY KEY ("dpreport_id", "code", "reason", "hast", "quantity", "amount", "ticket_id", "item_id", "comped_by") ); ALTER TABLE "comptickets" ADD CONSTRAINT "fk284da0d896545be1" FOREIGN KEY ("dpreport_id") REFERENCES "drawer_pull_report" ("id"); ALTER TABLE "comptickets" ADD CONSTRAINT "fk284da0d83ef4cd9b" FOREIGN KEY ("dpreport_id") REFERENCES "drawer_pull_report" ("id"); ALTER TABLE "comptickets" ADD CONSTRAINT "sql130209220535990" FOREIGN KEY ("dpreport_id") REFERENCES "drawer_pull_report" ("id"); 2015-10-24 01:08:34,010 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:34,447 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition:
2015-10-24 01:08:34,463 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "payout_recepients"( "id" INT NOT NULL IDENTITY (1,1) , "name" VARCHAR(255), PRIMARY KEY ("id") ); 2015-10-24 01:08:34,557 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:35,041 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition:
2015-10-24 01:08:35,072 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "coupon_and_discount"( "id" INT NOT NULL IDENTITY (1,1) , "name" VARCHAR(30), "type" INT, "value" FLOAT, "expiry_date" DATETIME, "disabled" SMALLINT, "never_expire" SMALLINT, "time_from" VARCHAR(255), "time_to" VARCHAR(255), "rule" INT, "sun_available" SMALLINT, "mon_available" SMALLINT, "tue_available" SMALLINT, "wed_available" SMALLINT, "thur_available" SMALLINT, "fri_available" SMALLINT, "sat_available" SMALLINT, "automatic" SMALLINT, "priority" INT, "coupon_code" VARCHAR(250), PRIMARY KEY ("id") ); 2015-10-24 01:08:35,166 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:35,604 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition:
2015-10-24 01:08:35,619 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "combo_category"( "id" INT NOT NULL IDENTITY (1,1) , "coupon_and_discount_id" INT, "combo_group" INT, "menu_group_id" INT, "availability_date" DATETIME, PRIMARY KEY ("id") ); ALTER TABLE "combo_category" ADD CONSTRAINT "fk49760af304a40ed" FOREIGN KEY ("coupon_and_discount_id") REFERENCES "coupon_and_discount" ("id"); ALTER TABLE "combo_category" ADD CONSTRAINT "fk49760af9bb80673" FOREIGN KEY ("coupon_and_discount_id") REFERENCES "coupon_and_discount" ("id"); ALTER TABLE "combo_category" ADD CONSTRAINT "fk49760af9e2cb57e" FOREIGN KEY ("menu_group_id") REFERENCES "menu_group" ("id"); ALTER TABLE "combo_category" ADD CONSTRAINT "fk49760af8da36104" FOREIGN KEY ("menu_group_id") REFERENCES "menu_group" ("id"); 2015-10-24 01:08:35,729 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:36,182 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition:
2015-10-24 01:08:36,213 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "delivery_return_reason"( "id" INT NOT NULL, "reason_text" VARCHAR(255), "ticket_id" INT, "reason_id" INT, "custom_reason" SMALLINT, PRIMARY KEY ("id") ); CREATE INDEX "delivery_return_reason_reason_id_idx" ON "delivery_return_reason" ("reason_id"); ALTER TABLE "delivery_return_reason" ADD CONSTRAINT "fk66917f287014ae47" FOREIGN KEY ("reason_id") REFERENCES "return_reason" ("id"); ALTER TABLE "delivery_return_reason" ADD CONSTRAINT "fk66917f2812d70d01" FOREIGN KEY ("reason_id") REFERENCES "return_reason" ("id"); 2015-10-24 01:08:36,307 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:36,760 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition:
2015-10-24 01:08:36,776 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "menuitem_menumodifiers"( "menu_item_id" INT NOT NULL, "menu_modifier_id" INT NOT NULL, PRIMARY KEY ("menu_item_id", "menu_modifier_id") ); ALTER TABLE "menuitem_menumodifiers" ADD CONSTRAINT "fk616cf150dd1b5836" FOREIGN KEY ("menu_item_id") REFERENCES "menu_item" ("id"); ALTER TABLE "menuitem_menumodifiers" ADD CONSTRAINT "fk616cf15089fe23f0" FOREIGN KEY ("menu_item_id") REFERENCES "menu_item" ("id"); ALTER TABLE "menuitem_menumodifiers" ADD CONSTRAINT "fk616cf15014da03b6" FOREIGN KEY ("menu_modifier_id") REFERENCES "menu_modifier" ("id"); ALTER TABLE "menuitem_menumodifiers" ADD CONSTRAINT "fk616cf150b79c6270" FOREIGN KEY ("menu_modifier_id") REFERENCES "menu_modifier" ("id"); 2015-10-24 01:08:36,885 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-11] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:37,338 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-16] About to create table using the following definition:
2015-10-24 01:08:37,354 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-16] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "ticket_cooking_instruction"( "ticket_id" INT NOT NULL, "description" VARCHAR(60), "printedtokitchen" SMALLINT, PRIMARY KEY ("ticket_id", "description", "printedtokitchen") ); ALTER TABLE "ticket_cooking_instruction" ADD CONSTRAINT "fkd2c835761d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "ticket_cooking_instruction" ADD CONSTRAINT "fkd2c835761df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); 2015-10-24 01:08:37,447 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-16] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:37,916 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-13] About to create table using the following definition:
2015-10-24 01:08:37,932 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-13] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "void_reasons"( "id" INT NOT NULL IDENTITY (1,1) , "reason_text" VARCHAR(255), "ticket_id" INT, "item_id" INT, "ticket_item_id" INT, PRIMARY KEY ("id") ); ALTER TABLE "void_reasons" ADD CONSTRAINT "fk8b275ee41d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "void_reasons" ADD CONSTRAINT "fk8b275ee41df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "void_reasons" ADD CONSTRAINT "fk8b275ee4df674cd0" FOREIGN KEY ("ticket_item_id") REFERENCES "ticket_item" ("id"); ALTER TABLE "void_reasons" ADD CONSTRAINT "fk8b275ee4dec6120a" FOREIGN KEY ("ticket_item_id") REFERENCES "ticket_item" ("id"); ALTER TABLE "void_reasons" ADD CONSTRAINT "fk8b275ee460b3cc3d" FOREIGN KEY ("item_id") REFERENCES "ticket_item" ("id"); 2015-10-24 01:08:38,057 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-13] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:38,526 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-15] About to create table using the following definition:
2015-10-24 01:08:38,541 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-15] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "custom_payment_type"( "id" INT NOT NULL, "type_name" VARCHAR(30) NOT NULL, "tips" SMALLINT, PRIMARY KEY ("id") ); 2015-10-24 01:08:38,619 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-15] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:39,072 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-17] About to create table using the following definition:
2015-10-24 01:08:39,088 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-17] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "payout_reasons"( "id" INT NOT NULL IDENTITY (1,1) , "reason" VARCHAR(255), PRIMARY KEY ("id") ); 2015-10-24 01:08:39,182 INFO [reportsdb-000] [DataLoaderService] [qtp28759214-17] 1 data and 1 batches loaded during push request from anchorage:001:001. There were 0 batches in error 2015-10-24 01:08:39,713 INFO [reportsdb-000] [DefaultDatabaseWriter] [qtp28759214-11] About to create table using the following definition:
2015-10-24 01:08:39,744 INFO [reportsdb-000] [MsSql2008DatabasePlatform] [qtp28759214-11] Running alter sql: SET quoted_identifier on; SET quoted_identifier on; CREATE TABLE "transactions"( "id" INT NOT NULL IDENTITY (1,1) , "payment_type" VARCHAR(20) NOT NULL, "modified_time" DATETIME NOT NULL, "transaction_time" DATETIME, "sub_total" FLOAT, "total_discount" FLOAT, "total_tax" FLOAT, "total_price" FLOAT, "gratuity_amount" FLOAT, "drawer_resetted" SMALLINT, "terminal_id" INT, "ticket_id" INT, "user_id" INT, "face_value" FLOAT, "paid_amount" FLOAT, "cash_back_amount" FLOAT, "card_number" VARCHAR(30), "card_type" VARCHAR(30), "note" VARCHAR(255), "reason_id" INT, "recepient_id" INT, "raw_xml_response" VARCHAR(10000), "due_amount" FLOAT, "type_name" VARCHAR(30), "delivery_fee" FLOAT, PRIMARY KEY ("id") ); CREATE INDEX "tran_drawer_resetted" ON "transactions" ("drawer_resetted"); ALTER TABLE "transactions" ADD CONSTRAINT "fkfe987155cdfc1e3d" FOREIGN KEY ("reason_id") REFERENCES "payout_reasons" ("id"); ALTER TABLE "transactions" ADD CONSTRAINT "fkfe98715570be7cf7" FOREIGN KEY ("reason_id") REFERENCES "payout_reasons" ("id"); ALTER TABLE "transactions" ADD CONSTRAINT "fkfe987155b00959bd" FOREIGN KEY ("recepient_id") REFERENCES "payout_recepients" ("id"); ALTER TABLE "transactions" ADD CONSTRAINT "fkfe9871557df00477" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id"); ALTER TABLE "transactions" ADD CONSTRAINT "fkfe9871552ad2d031" FOREIGN KEY ("terminal_id") REFERENCES "terminal" ("id"); ALTER TABLE "transactions" ADD CONSTRAINT "fkfe9871551d3c65b7" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "transactions" ADD CONSTRAINT "fkfe9871551df2d7f1" FOREIGN KEY ("ticket_id") REFERENCES "ticket" ("id"); ALTER TABLE "transactions" ADD CONSTRAINT "fkfe987155b3def497" FOREIGN KEY ("user_id") REFERENCES "users" ("auto_id"); ALTER TABLE "transactions" ADD CONSTRAINT "fkfe9871553e20ad51" FOREIGN KEY ("user_id") REFERENCES "users" ("auto_id"); 2015-10-24 01:08:39,776 WARN [reportsdb-000] [JdbcSqlTemplate] [qtp28759214-11] The size (10000) given to the column 'raw_xml_response' exceeds the maximum allowed for any data type (8000).. Failed to execute: CREATE TABLE "transactions"( "id" INT NOT NULL IDENTITY (1,1) , "payment_type" VARCHAR(20) NOT NULL, "modified_time" DATETIME NOT NULL, "transaction_time" DATETIME, "sub_total" FLOAT, "total_discount" FLOAT, "total_tax" FLOAT, "total_price" FLOAT, "gratuity_amount" FLOAT, "drawer_resetted" SMALLINT, "terminal_id" INT, "ticket_id" INT, "user_id" INT, "face_value" FLOAT, "paid_amount" FLOAT, "cash_back_amount" FLOAT, "card_number" VARCHAR(30), "card_type" VARCHAR(30), "note" VARCHAR(255), "reason_id" INT, "recepient_id" INT, "raw_xml_response" VARCHAR(10000), "due_amount" FLOAT, "type_name" VARCHAR(30), "delivery_fee" FLOAT, PRIMARY KEY ("id") )