View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0002423SymmetricDSBugpublic2015-10-23 20:302022-06-06 12:37
Reporterhaider.faraz Assigned Toemiller  
Priorityhigh 
Status closedResolutionfixed 
Product Version3.7.25 
Target Version3.13.5Fixed in Version3.13.5 
Summary0002423: Create table with max varchar supported by target
DescriptionI have an Apache Derby database as the source database and an MS SQL 2012 as the target database. One of my source database tables has a column of type varchar and size 10,000. When the source node registers with the target node, upon execution of the 'load initial data' request I get the error that the column size is larger than the size 8000 and the batch processing stops.
Tagsddl/schema, dialect: sql-server

Relationships

related to 0002324 closedchenson Creation of varchar(max) column fails with Error 2717 

Activities

chenson

2015-10-24 00:49

administrator   ~0000725

Can you please attach a full log file that exhibits the error?

haider.faraz

2015-10-24 06:58

reporter  

Logs_of_destination_node_MSSQL_Server_2012.log (221,259 bytes)    
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_MODIFIER_GROUP">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="ENABLED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="EXCLUSIVED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="REQUIRED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="CATEGORY" type="VARCHAR" size="24">
			<platform-column name="derby" type="VARCHAR" size="24"/>
		</column>
		<index name="MG_ENABLE">
			<index-column name="ENABLED"/>
		</index>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MODIFIERGROUP_SUBCATEGORY">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NAME" type="VARCHAR" size="24">
			<platform-column name="derby" type="VARCHAR" size="24"/>
		</column>
		<column name="MODIFIED_TIME" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="ENABLED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="EXCLUSIVED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="REQUIRED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="CATEGORY" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="VIEW_ORDER_VALUE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SUBCAT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="STYLE_NAME" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<foreign-key name="FK7D4CB47D7B72790" foreignTable="MENU_MODIFIER_GROUP">
			<reference local="SUBCAT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK7D4CB474324ED16" foreignTable="MENU_MODIFIER_GROUP">
			<reference local="SUBCAT_ID" foreign="ID"/>
		</foreign-key>
		<index name="MODIFIERGROUP_SUBCATEGORY_NAME_IDX">
			<index-column name="NAME"/>
		</index>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TAX">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" required="true" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="RATE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_MODIFIER">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" type="VARCHAR" size="50">
			<platform-column name="derby" type="VARCHAR" size="50"/>
		</column>
		<column name="PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="EXTRA_PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="ENABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINT_TO_KITCHEN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="GROUP_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TAX_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VIEW_ORDER_VALUE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="BUTTON_COLOR" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="IN_STOCK" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="GROUP_SUBCAT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SUBCAT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PLU" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK59B6B1B717A96F7" foreignTable="MODIFIERGROUP_SUBCATEGORY">
			<reference local="SUBCAT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK59B6B1B7F8D2AEB1" foreignTable="MODIFIERGROUP_SUBCATEGORY">
			<reference local="SUBCAT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK59B6B1B7D9D8E77D" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK59B6B1B7A4802F83" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
		<index name="MODIFIERENABLED">
			<index-column name="ENABLE"/>
		</index>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="CUSTOMER">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MOBILE" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="FIRSTNAME" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="LASTNAME" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="EMAIL" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="CITY" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="STATE" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="ZIP" type="VARCHAR" size="10">
			<platform-column name="derby" type="VARCHAR" size="10"/>
		</column>
		<column name="BIRTHDAY" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="BIRTHDAY_STRING" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="CUSTOMERNOTES" type="VARCHAR" size="5000">
			<platform-column name="derby" type="VARCHAR" size="5000"/>
		</column>
		<column name="ADDRESS1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="CURRENT_ADDRESS" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="ADDRESS2LINE1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS2LINE2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS3LINE1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS3LINE2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS4LINE1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS4LINE2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS5LINE1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS5LINE2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS6LINE1" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS6LINE2" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="ADDRESS2_1" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS2_2" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS3_1" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS3_2" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS4_1" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS4_2" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS5_1" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS5_2" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS6_1" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="ADDRESS6_2" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<column name="SELECTED_ADDRESS_INDEX" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="OPT_CC_TOKEN" required="true" type="SMALLINT" size="5" default="1">
			<platform-column name="derby" type="SMALLINT" size="5" default="1"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="DELIVERY">
		<column name="DELIVERY_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="EMPLOYEE_ID" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DELIVERY_START_TIME" type="DATE" size="10">
			<platform-column name="derby" type="DATE" size="10"/>
		</column>
		<column name="ARRIVAL_TIME" type="DATE" size="10">
			<platform-column name="derby" type="DATE" size="10"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="EMPLOYEE_JOB_CODE">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TITLE" required="true" type="VARCHAR" size="50">
			<platform-column name="derby" type="VARCHAR" size="50"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="SHIFT">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NAME" required="true" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="START_TIME" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="END_TIME" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="SHIFT_LEN" type="BIGINT" size="19">
			<platform-column name="derby" type="BIGINT" size="19"/>
		</column>
		<unique name="SQL091028025752330">
			<unique-column name="NAME"/>
		</unique>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TERMINAL">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="OPENING_BALANCE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CURRENT_BALANCE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="IS_DB_MACHINE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="USER_TYPE">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="P_NAME" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="USERS">
		<column name="AUTO_ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="USER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="USER_PASS" required="true" type="VARCHAR" size="16">
			<platform-column name="derby" type="VARCHAR" size="16"/>
		</column>
		<column name="FIRST_NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="LAST_NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="SSN" required="true" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="COST_PER_HOUR" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CLOCKED_IN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="LAST_CLOCK_IN_TIME" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="SHIFT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CURRENTTERMINAL" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="N_USER_TYPE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CASH_OUT_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CURRENT_POSITION" type="VARBINARY" size="255">
			<platform-column name="derby" type="VARCHAR () FOR BIT DATA" size="255"/>
		</column>
		<column name="JOB_CODE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SHOW_IN_PAYROLL" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="DELIVERING" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FK4D495E84B915F0E" foreignTable="EMPLOYEE_JOB_CODE">
			<reference local="JOB_CODE" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E8C49ECE14" foreignTable="EMPLOYEE_JOB_CODE">
			<reference local="JOB_CODE" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E8B86B475D" foreignTable="SHIFT">
			<reference local="SHIFT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E87660A5E3" foreignTable="SHIFT">
			<reference local="SHIFT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E82C5DCDAE" foreignTable="TERMINAL">
			<reference local="CURRENTTERMINAL" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E8D9409968" foreignTable="TERMINAL">
			<reference local="CURRENTTERMINAL" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E8DC98527F" foreignTable="USER_TYPE">
			<reference local="N_USER_TYPE" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4D495E8897B1E39" foreignTable="USER_TYPE">
			<reference local="N_USER_TYPE" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="DELIVERY_RUN">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="START_TIME" required="true" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="RETURN_TIME" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="TOTAL_ORDER_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="NUMBER_OF_ORDERS" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DRIVER_USER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FKB2D85FA0E2248B80" foreignTable="USERS">
			<reference local="DRIVER_USER_ID" foreign="AUTO_ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="GRATUITY">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="PAID" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="OWNER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TERMINAL_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK34E4E3777DF00477" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK34E4E3772AD2D031" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK34E4E3771FC5A4AF" foreignTable="USERS">
			<reference local="OWNER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK34E4E377AA075D69" foreignTable="USERS">
			<reference local="OWNER_ID" foreign="AUTO_ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKET_TYPE">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TYPE_NAME" required="true" type="VARCHAR" size="16">
			<platform-column name="derby" type="VARCHAR" size="16"/>
		</column>
		<column name="SURCHARGE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK97A4688DD9D8E77D" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK97A4688DA4802F83" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKET">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="CREATE_DATE" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="CLOSING_DATE" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="ACTIVE_DATE" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="CREATION_HOUR" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PAID" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="VOIDED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="REASON" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="WASTED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="SETTLED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="DRAWER_RESETTED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="SUB_TOTAL" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_DISCOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_TAX" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="PAID_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DUE_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TABLE_NUMBER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NUMBER_OF_GUESTS" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TRANSACTION_TYPE" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="TRANSACTION_CODE" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="BAR_CODE" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="CARD_TYPE" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="CARD_NUMBER" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="IS_TAX_EXEMPT" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="IS_RE_OPENED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="SHIFT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="OWNER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="GRATUITY_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VOID_BY_USER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TERMINAL_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CUST_LASTNAME" type="VARCHAR" size="200">
			<platform-column name="derby" type="VARCHAR" size="200"/>
		</column>
		<column name="CUST_FIRSTNAME" type="VARCHAR" size="200">
			<platform-column name="derby" type="VARCHAR" size="200"/>
		</column>
		<column name="DELIVERY_ADDRESS" type="VARCHAR" size="500">
			<platform-column name="derby" type="VARCHAR" size="500"/>
		</column>
		<column name="CUST_PHONENO" type="VARCHAR" size="15">
			<platform-column name="derby" type="VARCHAR" size="15"/>
		</column>
		<column name="TICKET_STATUS" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="DRIVER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DRIVER_NAME" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
		<column name="CUST_PHONE_NO" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="IS_DELIVERY" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="DELIVERY_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DELIVERY_STATUS" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DELIVERY_START_TIME" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="DELIVERY_END_TIME" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="DELIVERER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CUST_MOBILE_NUMBER" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="COMPED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="ONLINE_ORDER" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TICKET_TYPE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VOID_REASON" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="NOTES" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TRANSACTION_SUBTYPE" type="VARCHAR" size="1">
			<platform-column name="derby" type="VARCHAR" size="1"/>
		</column>
		<column name="SPLIT_TICKET" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="SPLIT_TICKET_ID" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TIP" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DISPLAY_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SURCHARGE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CUSTOMER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ONLINE_INVOICE_NUMBER" type="VARCHAR" size="25">
			<platform-column name="derby" type="VARCHAR" size="25"/>
		</column>
		<column name="MEMBER_ORDER" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="HEARTS_APPLIED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="DELIVERY_RUN_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="HEARTS_USED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="AMOUNT_OF_HEARTS_USED" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="AMOUNT_OF_HEARTS_APPLIED" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK937B5F0CF1397137" foreignTable="CUSTOMER">
			<reference local="CUSTOMER_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C9E1C3CF1" foreignTable="CUSTOMER">
			<reference local="CUSTOMER_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CDC30BD31" foreignTable="DELIVERY">
			<reference local="DELIVERY_ID" foreign="DELIVERY_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CC082E694" foreignTable="DELIVERY_RUN">
			<reference local="DELIVERY_RUN_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C14A61E97" foreignTable="GRATUITY">
			<reference local="GRATUITY_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CC188EA51" foreignTable="GRATUITY">
			<reference local="GRATUITY_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CB86B475D" foreignTable="SHIFT">
			<reference local="SHIFT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C7660A5E3" foreignTable="SHIFT">
			<reference local="SHIFT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C7DF00477" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C2AD2D031" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CF8C545F0" foreignTable="TICKET_TYPE">
			<reference local="TICKET_TYPE" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CF8240B2A" foreignTable="TICKET_TYPE">
			<reference local="TICKET_TYPE" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CE43D7670" foreignTable="USERS">
			<reference local="DELIVERER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C1FC5A4AF" foreignTable="USERS">
			<reference local="OWNER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C9528E190" foreignTable="USERS">
			<reference local="VOID_BY_USER" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C6E7F2F2A" foreignTable="USERS">
			<reference local="DELIVERER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CE672088" foreignTable="USERS">
			<reference local="DELIVERY_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0CAA075D69" foreignTable="USERS">
			<reference local="OWNER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK937B5F0C1F6A9A4A" foreignTable="USERS">
			<reference local="VOID_BY_USER" foreign="AUTO_ID"/>
		</foreign-key>
		<index name="CREATIONHOUR">
			<index-column name="CREATION_HOUR"/>
		</index>
		<index name="DRAWERRESETTED">
			<index-column name="DRAWER_RESETTED"/>
		</index>
		<index name="TICKETACTIVEDATE">
			<index-column name="ACTIVE_DATE"/>
		</index>
		<index name="TICKETCLOSINGDATE">
			<index-column name="CLOSING_DATE"/>
		</index>
		<index name="TICKETCREATEDATE">
			<index-column name="CREATE_DATE"/>
		</index>
		<index name="TICKETPAID">
			<index-column name="PAID"/>
		</index>
		<index name="TICKETSETTLED">
			<index-column name="SETTLED"/>
		</index>
		<index name="TICKETTRANSACTIONTYPE">
			<index-column name="TRANSACTION_TYPE"/>
		</index>
		<index name="TICKETVOIDED">
			<index-column name="VOIDED"/>
		</index>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="USER_TICKETS">
		<column name="USER_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TICKET_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK925912531D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK925912531DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK92591253B3DEF497" foreignTable="USERS">
			<reference local="USER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FK925912533E20AD51" foreignTable="USERS">
			<reference local="USER_ID" foreign="AUTO_ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_CATEGORY">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" required="true" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="VISIBLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="BEVERAGE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<index name="FOOD_CATEGORY_VISIBLE">
			<index-column name="VISIBLE"/>
		</index>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_GROUP">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" required="true" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="VISIBLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="CATEGORY_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MENU_CATEGORY_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="BAR" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="VIEW_ORDER_VALUE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="BUTTON_COLOR" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="IS_DEFAULT_SCREEN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINT_ORDER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK4DC1AB7F8B722136" foreignTable="MENU_CATEGORY">
			<reference local="CATEGORY_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4DC1AB7FF4397E56" foreignTable="MENU_CATEGORY">
			<reference local="MENU_CATEGORY_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4DC1AB7F2E347FF0" foreignTable="MENU_CATEGORY">
			<reference local="CATEGORY_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4DC1AB7F96FBDD10" foreignTable="MENU_CATEGORY">
			<reference local="MENU_CATEGORY_ID" foreign="ID"/>
		</foreign-key>
		<index name="MENUGROUPVISIBLE">
			<index-column name="VISIBLE"/>
		</index>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_ITEM">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="NAME" required="true" type="VARCHAR" size="50">
			<platform-column name="derby" type="VARCHAR" size="50"/>
		</column>
		<column name="PRICE" required="true" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DISCOUNT_RATE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="VISIBLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="GROUP_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TAX_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PLU" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VIEW_ORDER_VALUE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="BUTTON_COLOR" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NEXT_SCREEN" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="BUFFET" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINT_TO_KITCHEN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="AVAILABLE_ONLINE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="ONLINE_SPECIFIC" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="ENABLED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FK4CD5A1F36211FE9E" foreignTable="MENU_GROUP">
			<reference local="GROUP_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4CD5A1F35188AA24" foreignTable="MENU_GROUP">
			<reference local="GROUP_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4CD5A1F3D9D8E77D" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4CD5A1F3A4802F83" foreignTable="TAX">
			<reference local="TAX_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKET_ITEM">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="ITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_COUNT" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="GROUP_NAME" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="CATEGORY_NAME" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="ITEM_PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DISCOUNT_RATE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="ITEM_TAX_RATE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SUB_TOTAL" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SUB_TOTAL_WITH_MODIFIERS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DISCOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_AMOUNT_WITH_MODIFIERS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_PRICE_WITH_MODIFIERS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="BEVERAGE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINT_TO_KITCHEN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="HAS_MODIIERS" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINTED_TO_KITCHEN" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_ORDER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VOIDED" type="SMALLINT" size="5" default="0">
			<platform-column name="derby" type="SMALLINT" size="5" default="0"/>
		</column>
		<column name="COMPED" type="SMALLINT" size="5" default="0">
			<platform-column name="derby" type="SMALLINT" size="5" default="0"/>
		</column>
		<column name="BUFFET" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="MENU_ITEM" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ALREADY_SENT" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRINT_ORDER_VALUE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VOID_REASON" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="CONSTRUCTION_ZONE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FK979F546664931EFC" foreignTable="MENU_ITEM">
			<reference local="MENU_ITEM" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK979F54661D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK979F54661DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="COMP_REASONS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON_TEXT" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TICKET_ITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FKBD53115F1D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKBD53115F1DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKBD53115FDF674CD0" foreignTable="TICKET_ITEM">
			<reference local="TICKET_ITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKBD53115FDEC6120A" foreignTable="TICKET_ITEM">
			<reference local="TICKET_ITEM_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="CREDIT_CARD_INFO">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CUSTOMER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CARD_NUMBER" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="CARD_TYPE" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="RECORD_NO" type="VARCHAR" size="150">
			<platform-column name="derby" type="VARCHAR" size="150"/>
		</column>
		<foreign-key name="FK5A3902B7F1397137" foreignTable="CUSTOMER">
			<reference local="CUSTOMER_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="END_OF_DAY_REPORT">
		<column name="ID" primaryKey="true" required="true" type="NUMERIC" size="5">
			<platform-column name="derby" type="NUMERIC" size="5"/>
		</column>
		<column name="DATE" required="true" type="DATE" size="10">
			<platform-column name="derby" type="DATE" size="10"/>
		</column>
		<column name="TOTAL_SALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_VOIDS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_COMPS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_LABOR_COST" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_LABOR_HOURS" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NUM_TICKETS" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NUM_DELIVERIES" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="AVERAGE_CLAIM_TIME" type="BIGINT" size="19">
			<platform-column name="derby" type="BIGINT" size="19"/>
		</column>
		<column name="AVERAGE_DELIVERY_ROUTE_TIME" type="BIGINT" size="19">
			<platform-column name="derby" type="BIGINT" size="19"/>
		</column>
		<column name="FINAL_TICKET_NUMBER" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTAL_LABOR_HRS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TIMESTAMP" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<column name="CASH_DEPOSIT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DISCOUNTS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CHARGES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GIFT_CARD_REDEEMS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GIFT_CARD_SALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GROSS_SALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="NET_SALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="NET_TAXES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="OVER_UNDER" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="PAYOUTS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SALES_BEVERAGES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SALES_FOOD" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SALESMERCH" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_BEVERAGES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_FOOD" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TAX_MERCH" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CHARGE_TIPS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DELIVERY_CHARGES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DELIVERY_FEES_PAID_OUT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="POS_VERSION" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<unique name="SQL130330031001490">
			<unique-column name="DATE"/>
		</unique>
		<unique name="SQL130330031001491">
			<unique-column name="FINAL_TICKET_NUMBER"/>
		</unique>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="ADDRESSES_LATITUDES_LONGITUDES">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CUSTOMER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ADDRESS_1" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="ADDRESS_2" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="LATITUDE" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="LONGITUDE" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="IS_DELIVERY" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FK4A889B19F1397137" foreignTable="CUSTOMER">
			<reference local="CUSTOMER_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK4A889B199E1C3CF1" foreignTable="CUSTOMER">
			<reference local="CUSTOMER_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKET_COUPON_DISCOUNT">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="COUPON_DISCOUNT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="TYPE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VALUE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="D_ORDER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK3A1F32071D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK3A1F32071DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKETITEM_MODIFIERGROUP">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="GROUP_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MIN_QUANTITY" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MAX_QUANTITY" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PARENT" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TICKETITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_ORDER" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK21D455C8A7DD55E6" foreignTable="TICKET_ITEM">
			<reference local="PARENT" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK21D455C8DCBC5677" foreignTable="TICKET_ITEM">
			<reference local="TICKETITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK21D455C8A73C1B20" foreignTable="TICKET_ITEM">
			<reference local="PARENT" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK21D455C8DC1B1BB1" foreignTable="TICKET_ITEM">
			<reference local="TICKETITEM_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENU_ITEM_SUGGESTIONS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TYPE" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PARENT_ITEM_PLU" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SUGGESTION_PLU" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="RETURN_REASON">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TEXT" required="true" type="VARCHAR" size="256">
			<platform-column name="derby" type="VARCHAR" size="256"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="USER_PERMISSION">
		<column name="NAME" primaryKey="true" required="true" type="VARCHAR" size="40">
			<platform-column name="derby" type="VARCHAR" size="40"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="DRAWER_PULL_REPORT">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REPORT_TIME" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="REG" type="VARCHAR" size="15">
			<platform-column name="derby" type="VARCHAR" size="15"/>
		</column>
		<column name="TICKET_COUNT" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="BEGIN_CASH" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="NET_SALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="SALES_TAX" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_TAX" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_REVENUE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GROSS_RECEIPTS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GIFTCERTRETURNCOUNT" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="GIFTCERTRETURNAMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GIFTCERTCHANGEAMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_RECEIPT_NO" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CASH_RECEIPT_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CREDIT_CARD_RECEIPT_NO" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CREDIT_CARD_RECEIPT_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DEBIT_CARD_RECEIPT_NO" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DEBIT_CARD_RECEIPT_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="RECEIPT_DIFFERENTIAL" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_BACK" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_TIPS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CHARGED_TIPS" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TIPS_PAID" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TIPS_DIFFERENTIAL" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="PAY_OUT_NO" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PAY_OUT_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DRAWER_BLEED_NO" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DRAWER_BLEED_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DRAWER_ACCOUNTABLE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_TO_DEPOSIT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="VARIANCE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALVOIDWST" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALVOID" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALDISCOUNTCOUNT" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTALDISCOUNTAMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALDISCOUNTSALES" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALDISCOUNTGUEST" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTALDISCOUNTPARTYSIZE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTALDISCOUNTCHECKSIZE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTALDISCOUNTPERCENTAGE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTALDISCOUNTRATIO" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TERMINAL_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TOTALCOMP" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<foreign-key name="FKAEC362207DF00477" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKAEC362202AD2D031" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<index name="DRAWER_REPORT_TIME">
			<index-column name="REPORT_TIME"/>
		</index>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="COMPTICKETS">
		<column name="DPREPORT_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CODE" primaryKey="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON" primaryKey="true" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="HAST" primaryKey="true" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="QUANTITY" primaryKey="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="AMOUNT" primaryKey="true" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TICKET_ID" primaryKey="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_ID" primaryKey="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="COMPED_BY" primaryKey="true" type="VARCHAR" size="100">
			<platform-column name="derby" type="VARCHAR" size="100"/>
		</column>
		<foreign-key name="FK284DA0D896545BE1" foreignTable="DRAWER_PULL_REPORT">
			<reference local="DPREPORT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK284DA0D83EF4CD9B" foreignTable="DRAWER_PULL_REPORT">
			<reference local="DPREPORT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="SQL130209220535990" foreignTable="DRAWER_PULL_REPORT">
			<reference local="DPREPORT_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="PAYOUT_RECEPIENTS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NAME" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="COUPON_AND_DISCOUNT">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="TYPE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="VALUE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="EXPIRY_DATE" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="DISABLED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="NEVER_EXPIRE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TIME_FROM" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TIME_TO" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="RULE" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="SUN_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="MON_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TUE_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="WED_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="THUR_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="FRI_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="SAT_AVAILABLE" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="AUTOMATIC" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="PRIORITY" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="COUPON_CODE" type="VARCHAR" size="250">
			<platform-column name="derby" type="VARCHAR" size="250"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="COMBO_CATEGORY">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="COUPON_AND_DISCOUNT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="COMBO_GROUP" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MENU_GROUP_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="AVAILABILITY_DATE" type="TIMESTAMP" size="29,9">
			<platform-column name="derby" type="TIMESTAMP" size="29" decimalDigits="9"/>
		</column>
		<foreign-key name="FK49760AF304A40ED" foreignTable="COUPON_AND_DISCOUNT">
			<reference local="COUPON_AND_DISCOUNT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK49760AF9BB80673" foreignTable="COUPON_AND_DISCOUNT">
			<reference local="COUPON_AND_DISCOUNT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK49760AF9E2CB57E" foreignTable="MENU_GROUP">
			<reference local="MENU_GROUP_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK49760AF8DA36104" foreignTable="MENU_GROUP">
			<reference local="MENU_GROUP_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="DELIVERY_RETURN_REASON">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON_TEXT" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="CUSTOM_REASON" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FK66917F287014AE47" foreignTable="RETURN_REASON">
			<reference local="REASON_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK66917F2812D70D01" foreignTable="RETURN_REASON">
			<reference local="REASON_ID" foreign="ID"/>
		</foreign-key>
		<index name="DELIVERY_RETURN_REASON_REASON_ID_IDX">
			<index-column name="REASON_ID"/>
		</index>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="MENUITEM_MENUMODIFIERS">
		<column name="MENU_ITEM_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="MENU_MODIFIER_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK616CF150DD1B5836" foreignTable="MENU_ITEM">
			<reference local="MENU_ITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK616CF15089FE23F0" foreignTable="MENU_ITEM">
			<reference local="MENU_ITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK616CF15014DA03B6" foreignTable="MENU_MODIFIER">
			<reference local="MENU_MODIFIER_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK616CF150B79C6270" foreignTable="MENU_MODIFIER">
			<reference local="MENU_MODIFIER_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TICKET_COOKING_INSTRUCTION">
		<column name="TICKET_ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="DESCRIPTION" primaryKey="true" type="VARCHAR" size="60">
			<platform-column name="derby" type="VARCHAR" size="60"/>
		</column>
		<column name="PRINTEDTOKITCHEN" primaryKey="true" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<foreign-key name="FKD2C835761D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKD2C835761DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="VOID_REASONS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON_TEXT" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="ITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TICKET_ITEM_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<foreign-key name="FK8B275EE41D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK8B275EE41DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK8B275EE4DF674CD0" foreignTable="TICKET_ITEM">
			<reference local="TICKET_ITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK8B275EE4DEC6120A" foreignTable="TICKET_ITEM">
			<reference local="TICKET_ITEM_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FK8B275EE460B3CC3D" foreignTable="TICKET_ITEM">
			<reference local="ITEM_ID" foreign="ID"/>
		</foreign-key>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="CUSTOM_PAYMENT_TYPE">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TYPE_NAME" required="true" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="TIPS" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="PAYOUT_REASONS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="REASON" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
	</table>
</database>
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: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dataextractor">
	<table name="TRANSACTIONS">
		<column name="ID" primaryKey="true" required="true" type="INTEGER" size="10" autoIncrement="true">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="PAYMENT_TYPE" required="true" type="VARCHAR" size="20">
			<platform-column name="derby" type="VARCHAR" size="20"/>
		</column>
		<column name="MODIFIED_TIME" required="true" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="TRANSACTION_TIME" type="TIMESTAMP" size="26,6">
			<platform-column name="derby" type="TIMESTAMP" size="26" decimalDigits="6"/>
		</column>
		<column name="SUB_TOTAL" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_DISCOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_TAX" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TOTAL_PRICE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="GRATUITY_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="DRAWER_RESETTED" type="SMALLINT" size="5">
			<platform-column name="derby" type="SMALLINT" size="5"/>
		</column>
		<column name="TERMINAL_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="TICKET_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="USER_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="FACE_VALUE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="PAID_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CASH_BACK_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="CARD_NUMBER" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="CARD_TYPE" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="NOTE" type="VARCHAR" size="255">
			<platform-column name="derby" type="VARCHAR" size="255"/>
		</column>
		<column name="REASON_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="RECEPIENT_ID" type="INTEGER" size="10">
			<platform-column name="derby" type="INTEGER" size="10"/>
		</column>
		<column name="RAW_XML_RESPONSE" type="VARCHAR" size="10000">
			<platform-column name="derby" type="VARCHAR" size="10000"/>
		</column>
		<column name="DUE_AMOUNT" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<column name="TYPE_NAME" type="VARCHAR" size="30">
			<platform-column name="derby" type="VARCHAR" size="30"/>
		</column>
		<column name="DELIVERY_FEE" type="DOUBLE" size="52">
			<platform-column name="derby" type="DOUBLE" size="52"/>
		</column>
		<foreign-key name="FKFE987155CDFC1E3D" foreignTable="PAYOUT_REASONS">
			<reference local="REASON_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE98715570BE7CF7" foreignTable="PAYOUT_REASONS">
			<reference local="REASON_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE987155B00959BD" foreignTable="PAYOUT_RECEPIENTS">
			<reference local="RECEPIENT_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE9871557DF00477" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE9871552AD2D031" foreignTable="TERMINAL">
			<reference local="TERMINAL_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE9871551D3C65B7" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE9871551DF2D7F1" foreignTable="TICKET">
			<reference local="TICKET_ID" foreign="ID"/>
		</foreign-key>
		<foreign-key name="FKFE987155B3DEF497" foreignTable="USERS">
			<reference local="USER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<foreign-key name="FKFE9871553E20AD51" foreignTable="USERS">
			<reference local="USER_ID" foreign="AUTO_ID"/>
		</foreign-key>
		<index name="TRAN_DRAWER_RESETTED">
			<index-column name="DRAWER_RESETTED"/>
		</index>
	</table>
</database>
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")
)
Logs_of_destination_node_MSSQL_Server_2012.log (221,259 bytes)   

haider.faraz

2015-10-24 06:59

reporter   ~0000726

Last edited: 2015-10-24 07:06

View 2 revisions

 Log file of destination node attached. The error is at the end of the log file. The name of the table is 'TRANSACTIONS' and the name of the column that fails to convert is 'raw_xml_response'.

Related Changesets

SymmetricDS: 3.14 5b5ab69b

2022-05-24 17:43:47

admin

Details Diff 		0002423: table with max varchar Affected Issues
0002423
mod - symmetric-db/src/main/java/org/jumpmind/db/model/PlatformColumn.java Diff File

Issue History

Date Modified Username Field Change
2015-10-23 20:30 haider.faraz New Issue
2015-10-24 00:49 chenson Note Added: 0000725
2015-10-24 06:58 haider.faraz File Added: Logs_of_destination_node_MSSQL_Server_2012.log
2015-10-24 06:59 haider.faraz Note Added: 0000726
2015-10-24 07:06 haider.faraz Note Edited: 0000726 View Revisions
2019-04-23 19:36 elong Tag Attached: ddl/schema
2019-04-23 19:36 elong Tag Attached: mssql
2019-04-23 19:36 elong Relationship added related to 0002324
2019-04-23 19:37 elong Summary Request to re-open Bug ID: 0002324 => Create table with max varchar supported by target
2019-04-23 20:49 admin Tag Renamed mssql => dialect: mssql
2019-04-24 12:50 admin Tag Renamed dialect: mssql => dialect: sql-server
2022-05-24 17:39 elong Assigned To => emiller
2022-05-24 17:39 elong Status new => resolved
2022-05-24 17:39 elong Resolution open => fixed
2022-05-24 17:39 elong Fixed in Version => 3.13.5
2022-05-24 17:39 elong Target Version => 3.13.5
2022-05-24 18:00 admin Changeset attached => SymmetricDS 3.14 5b5ab69b
2022-06-06 12:37 admin Status resolved => closed