2018-12-17 16:08:53,502 INFO [startup] [AbstractCommandLauncher] [main] Option: name=max-idle-time, value={90000} 2018-12-17 16:08:53,502 INFO [startup] [AbstractCommandLauncher] [main] Option: name=no-log-console, value={} 2018-12-17 16:08:53,673 INFO [startup] [SymmetricUtils] [main] _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ | Copyright (C) 2007-2018 JumpMind, Inc. | | | | Licensed under one or more agreements from JumpMind, Inc. | | See doc/license.html | +-----------------------------------------------------------------+ 2018-12-17 16:08:53,712 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:55415 2018-12-17 16:08:55,927 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 55416 2018-12-17 16:08:55,946 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2018-12-17 16:12:42,152 INFO [startup] [AbstractCommandLauncher] [main] Option: name=max-idle-time, value={90000} 2018-12-17 16:12:42,152 INFO [startup] [AbstractCommandLauncher] [main] Option: name=no-log-console, value={} 2018-12-17 16:12:42,327 INFO [startup] [SymmetricUtils] [main] _____ __ _ ____ _____ / ___/ __ _____ __ ___ __ ___ _/ /_ ____(_)___ / __ | / ___/ \__ \ / / / / _ `_ \/ _ `_ \/ _ \/_ __// __/ / __/ / / / / \__ \ ___/ // /_/ / // // / // // / __// / / / / / /_ / /_/ / ___/ / /____/ \__ /_//_//_/_//_//_/\___/ \_/ /_/ /_/\__/ /_____/ /____/ /____/ +-----------------------------------------------------------------+ | Copyright (C) 2007-2018 JumpMind, Inc. | | | | Licensed under one or more agreements from JumpMind, Inc. | | See doc/license.html | +-----------------------------------------------------------------+ 2018-12-17 16:12:42,374 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:55415 2018-12-17 16:12:44,523 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 55416 2018-12-17 16:12:44,544 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2018-12-17 16:13:18,710 INFO [gui] [JdbcDatabasePlatformFactory] [qtp1156304131-19] Detected database 'InterBase', version '10', protocol 'interbase' 2018-12-17 16:13:18,728 INFO [gui] [JdbcDatabasePlatformFactory] [qtp1156304131-19] The IDatabasePlatform being used is org.jumpmind.db.platform.interbase.InterbaseDatabasePlatform 2018-12-17 16:13:18,752 INFO [gui] [InterbaseSymmetricDialect] [qtp1156304131-19] The DbDialect being used is org.jumpmind.symmetric.db.interbase.InterbaseSymmetricDialect 2018-12-17 16:13:21,818 INFO [SymmetricDS] [AbstractSymmetricEngine] [qtp1156304131-14] Initializing connection to database 2018-12-17 16:13:21,830 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp1156304131-14] Detected database 'InterBase', version '10', protocol 'interbase' 2018-12-17 16:13:21,830 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp1156304131-14] The IDatabasePlatform being used is org.jumpmind.db.platform.interbase.InterbaseDatabasePlatform 2018-12-17 16:13:21,846 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-14] The DbDialect being used is org.jumpmind.symmetric.db.interbase.InterbaseSymmetricDialect 2018-12-17 16:13:21,872 INFO [SymmetricDS] [StagingManager] [qtp1156304131-14] The staging directory was initialized at the following location: tmp\SymmetricDS 2018-12-17 16:13:21,873 INFO [SymmetricDS] [EnhancedStagingManager] [qtp1156304131-14] Compressed staging is enabled 2018-12-17 16:13:22,468 INFO [SymmetricDS] [ClientExtensionService] [qtp1156304131-14] Found 12 extension points from spring that will be registered 2018-12-17 16:14:22,785 INFO [SymmetricDS] [AbstractSymmetricEngine] [qtp1156304131-17] Initializing connection to database 2018-12-17 16:14:22,795 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp1156304131-17] Detected database 'InterBase', version '10', protocol 'interbase' 2018-12-17 16:14:22,795 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp1156304131-17] The IDatabasePlatform being used is org.jumpmind.db.platform.interbase.InterbaseDatabasePlatform 2018-12-17 16:14:22,809 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] The DbDialect being used is org.jumpmind.symmetric.db.interbase.InterbaseSymmetricDialect 2018-12-17 16:14:22,823 INFO [SymmetricDS] [StagingManager] [qtp1156304131-17] The staging directory was initialized at the following location: tmp\SymmetricDS 2018-12-17 16:14:22,824 INFO [SymmetricDS] [EnhancedStagingManager] [qtp1156304131-17] Compressed staging is enabled 2018-12-17 16:14:22,940 INFO [SymmetricDS] [ClientExtensionService] [qtp1156304131-17] Found 12 extension points from spring that will be registered 2018-12-17 16:14:22,941 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] Checking if SymmetricDS tables need created or altered 2018-12-17 16:14:23,453 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] There are SymmetricDS tables that needed altered 2018-12-17 16:14:23,469 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_CHANNEL"( "CHANNEL_ID" VARCHAR(128) NOT NULL, "PROCESSING_ORDER" INTEGER DEFAULT 1 NOT NULL, "MAX_BATCH_SIZE" INTEGER DEFAULT 1000 NOT NULL, "MAX_BATCH_TO_SEND" INTEGER DEFAULT 60 NOT NULL, "MAX_DATA_TO_ROUTE" INTEGER DEFAULT 100000 NOT NULL, "EXTRACT_PERIOD_MILLIS" INTEGER 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), "QUEUE" VARCHAR(25) DEFAULT 'default' NOT NULL, "MAX_NETWORK_KBPS" DECIMAL(10,3) DEFAULT 0.000 NOT NULL, "DATA_EVENT_ACTION" CHAR(1), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("CHANNEL_ID") ) 2018-12-17 16:14:23,535 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" VARCHAR(4096), "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" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("CONFLICT_ID") ) 2018-12-17 16:14:23,539 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_CONTEXT"( "NAME" VARCHAR(80) NOT NULL, "CONTEXT_VALUE" VARCHAR(4096), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NAME") ) 2018-12-17 16:14:23,545 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_DATA"( "DATA_ID" NUMERIC(18,0) NOT NULL , "TABLE_NAME" VARCHAR(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "ROW_DATA" VARCHAR(4096), "PK_DATA" VARCHAR(4096), "OLD_DATA" VARCHAR(4096), "TRIGGER_HIST_ID" INTEGER 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" TIMESTAMP, PRIMARY KEY ("DATA_ID") ) 2018-12-17 16:14:23,546 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID") 2018-12-17 16:14:23,546 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE GENERATOR "GEN_SYM_DATA_DATA_ID" 2018-12-17 16:14:23,548 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TRIGGER "TRG_SYM_DATA_DATA_ID" FOR "SYM_DATA" ACTIVE BEFORE INSERT POSITION 0 AS BEGIN IF (NEW."DATA_ID" IS NULL) THEN NEW."DATA_ID" = GEN_ID("GEN_SYM_DATA_DATA_ID", 1); END 2018-12-17 16:14:23,552 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_DATA_EVENT"( "DATA_ID" NUMERIC(18,0) NOT NULL, "BATCH_ID" NUMERIC(18,0) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("DATA_ID", "BATCH_ID", "ROUTER_ID") ) 2018-12-17 16:14:23,553 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID") 2018-12-17 16:14:23,558 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_DATA_GAP"( "START_ID" NUMERIC(18,0) NOT NULL, "END_ID" NUMERIC(18,0) NOT NULL, "STATUS" CHAR(2), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("START_ID", "END_ID") ) 2018-12-17 16:14:23,558 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_DG_STATUS" ON "SYM_DATA_GAP" ("STATUS") 2018-12-17 16:14:23,564 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" INTEGER DEFAULT 1 NOT NULL, "EXTENSION_TEXT" VARCHAR(4096), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("EXTENSION_ID") ) 2018-12-17 16:14:23,570 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_EXTRACT_REQUEST"( "REQUEST_ID" NUMERIC(18,0) NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "QUEUE" VARCHAR(128), "STATUS" CHAR(2), "START_BATCH_ID" NUMERIC(18,0) NOT NULL, "END_BATCH_ID" NUMERIC(18,0) NOT NULL, "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, PRIMARY KEY ("REQUEST_ID") ) 2018-12-17 16:14:23,573 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_FILE_INCOMING"( "RELATIVE_DIR" VARCHAR(255) NOT NULL, "FILE_NAME" VARCHAR(128) NOT NULL, "LAST_EVENT_TYPE" CHAR(1) NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "FILE_MODIFIED_TIME" NUMERIC(18,0), PRIMARY KEY ("RELATIVE_DIR", "FILE_NAME") ) 2018-12-17 16:14:23,580 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_FILE_SNAPSHOT"( "TRIGGER_ID" VARCHAR(128) NOT NULL, "ROUTER_ID" VARCHAR(50) NOT NULL, "RELATIVE_DIR" VARCHAR(255) NOT NULL, "FILE_NAME" VARCHAR(128) NOT NULL, "CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync' NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL, "LAST_EVENT_TYPE" CHAR(1) NOT NULL, "CRC32_CHECKSUM" NUMERIC(18,0), "FILE_SIZE" NUMERIC(18,0), "FILE_MODIFIED_TIME" NUMERIC(18,0), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "CREATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID", "RELATIVE_DIR", "FILE_NAME") ) 2018-12-17 16:14:23,581 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID") 2018-12-17 16:14:23,593 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" VARCHAR(4096), "AFTER_COPY_SCRIPT" VARCHAR(4096), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("TRIGGER_ID") ) 2018-12-17 16:14:23,599 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") ) 2018-12-17 16:14:23,603 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID") ) 2018-12-17 16:14:23,608 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_GROUPLET_LINK"( "GROUPLET_ID" VARCHAR(50) NOT NULL, "EXTERNAL_ID" VARCHAR(255) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID") ) 2018-12-17 16:14:23,630 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_INCOMING_BATCH"( "BATCH_ID" NUMERIC(18,0) NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128), "STATUS" CHAR(2), "ERROR_FLAG" SMALLINT DEFAULT 0, "SQL_STATE" VARCHAR(10), "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" VARCHAR(4096), "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "SUMMARY" VARCHAR(255), "IGNORE_COUNT" INTEGER DEFAULT 0 NOT NULL, "BYTE_COUNT" NUMERIC(18,0) DEFAULT 0 NOT NULL, "LOAD_FLAG" SMALLINT DEFAULT 0, "EXTRACT_COUNT" INTEGER DEFAULT 0 NOT NULL, "SENT_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_COUNT" INTEGER DEFAULT 0 NOT NULL, "RELOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "OTHER_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "NETWORK_MILLIS" INTEGER DEFAULT 0 NOT NULL, "FILTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "ROUTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_ID" NUMERIC(18,0), "COMMON_FLAG" SMALLINT DEFAULT 0, "FALLBACK_INSERT_COUNT" INTEGER DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" INTEGER DEFAULT 0 NOT NULL, "IGNORE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" INTEGER DEFAULT 0 NOT NULL, "SKIP_COUNT" INTEGER DEFAULT 0 NOT NULL, "FAILED_ROW_NUMBER" INTEGER DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" INTEGER DEFAULT 0 NOT NULL, "FAILED_DATA_ID" NUMERIC(18,0) DEFAULT 0 NOT NULL, PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2018-12-17 16:14:23,633 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS") 2018-12-17 16:14:23,635 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG") 2018-12-17 16:14:23,644 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_INCOMING_ERROR"( "BATCH_ID" NUMERIC(18,0) NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "FAILED_ROW_NUMBER" NUMERIC(18,0) NOT NULL, "FAILED_LINE_NUMBER" NUMERIC(18,0) DEFAULT 0 NOT NULL, "TARGET_CATALOG_NAME" VARCHAR(255), "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" VARCHAR(4096) NOT NULL, "PK_COLUMN_NAMES" VARCHAR(4096) NOT NULL, "ROW_DATA" VARCHAR(4096), "OLD_DATA" VARCHAR(4096), "CUR_DATA" VARCHAR(4096), "RESOLVE_DATA" VARCHAR(4096), "RESOLVE_IGNORE" SMALLINT DEFAULT 0, "CONFLICT_ID" VARCHAR(50), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("BATCH_ID", "NODE_ID", "FAILED_ROW_NUMBER") ) 2018-12-17 16:14:23,650 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_JOB"( "JOB_NAME" VARCHAR(50) NOT NULL, "JOB_TYPE" VARCHAR(10) NOT NULL, "REQUIRES_REGISTRATION" SMALLINT DEFAULT 1 NOT NULL, "JOB_EXPRESSION" VARCHAR(4096), "DESCRIPTION" VARCHAR(255), "DEFAULT_SCHEDULE" VARCHAR(50), "DEFAULT_AUTO_START" SMALLINT DEFAULT 1 NOT NULL, "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "CREATE_BY" VARCHAR(50), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("JOB_NAME") ) 2018-12-17 16:14:23,660 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" VARCHAR(4096), "AFTER_WRITE_SCRIPT" VARCHAR(4096), "BATCH_COMPLETE_SCRIPT" VARCHAR(4096), "BATCH_COMMIT_SCRIPT" VARCHAR(4096), "BATCH_ROLLBACK_SCRIPT" VARCHAR(4096), "HANDLE_ERROR_SCRIPT" VARCHAR(4096), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LOAD_FILTER_ORDER" INTEGER DEFAULT 1 NOT NULL, "FAIL_ON_ERROR" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("LOAD_FILTER_ID") ) 2018-12-17 16:14:23,665 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" TIMESTAMP, "SHARED_COUNT" INTEGER DEFAULT 0 NOT NULL, "SHARED_ENABLE" INTEGER DEFAULT 0 NOT NULL, "LAST_LOCK_TIME" TIMESTAMP, "LAST_LOCKING_SERVER_ID" VARCHAR(255), PRIMARY KEY ("LOCK_ACTION") ) 2018-12-17 16:14:23,672 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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, "HEARTBEAT_TIME" TIMESTAMP, "TIMEZONE_OFFSET" VARCHAR(6), "SYNC_ENABLED" SMALLINT DEFAULT 0, "SYNC_URL" VARCHAR(255), "SCHEMA_VERSION" VARCHAR(50), "SYMMETRIC_VERSION" VARCHAR(50), "CONFIG_VERSION" VARCHAR(50), "DATABASE_TYPE" VARCHAR(50), "DATABASE_VERSION" VARCHAR(50), "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0, "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0, "CREATED_AT_NODE_ID" VARCHAR(50), "DEPLOYMENT_TYPE" VARCHAR(50), "DEPLOYMENT_SUB_TYPE" VARCHAR(50), PRIMARY KEY ("NODE_ID") ) 2018-12-17 16:14:23,678 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_NODE_COMMUNICATION"( "NODE_ID" VARCHAR(50) NOT NULL, "QUEUE" VARCHAR(25) DEFAULT 'default' NOT NULL, "COMMUNICATION_TYPE" VARCHAR(10) NOT NULL, "LOCK_TIME" TIMESTAMP, "LOCKING_SERVER_ID" VARCHAR(255), "LAST_LOCK_TIME" TIMESTAMP, "LAST_LOCK_MILLIS" NUMERIC(18,0) DEFAULT 0, "SUCCESS_COUNT" NUMERIC(18,0) DEFAULT 0, "FAIL_COUNT" NUMERIC(18,0) DEFAULT 0, "SKIP_COUNT" NUMERIC(18,0) DEFAULT 0, "TOTAL_SUCCESS_COUNT" NUMERIC(18,0) DEFAULT 0, "TOTAL_FAIL_COUNT" NUMERIC(18,0) DEFAULT 0, "TOTAL_SUCCESS_MILLIS" NUMERIC(18,0) DEFAULT 0, "TOTAL_FAIL_MILLIS" NUMERIC(18,0) DEFAULT 0, "BATCH_TO_SEND_COUNT" NUMERIC(18,0) DEFAULT 0, "NODE_PRIORITY" INTEGER DEFAULT 0, PRIMARY KEY ("NODE_ID", "QUEUE", "COMMUNICATION_TYPE") ) 2018-12-17 16:14:23,682 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" TIMESTAMP, PRIMARY KEY ("NODE_ID", "CHANNEL_ID") ) 2018-12-17 16:14:23,686 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_NODE_GROUP"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "DESCRIPTION" VARCHAR(255), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NODE_GROUP_ID") ) 2018-12-17 16:14:23,691 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_NODE_GROUP_CHANNEL_WND"( "NODE_GROUP_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "ENABLED" SMALLINT DEFAULT 0 NOT NULL, PRIMARY KEY ("NODE_GROUP_ID", "CHANNEL_ID", "START_TIME", "END_TIME") ) 2018-12-17 16:14:23,696 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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, "IS_REVERSIBLE" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2018-12-17 16:14:23,710 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_NODE_HOST"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "INSTANCE_ID" VARCHAR(60), "IP_ADDRESS" VARCHAR(50), "OS_USER" VARCHAR(50), "OS_NAME" VARCHAR(50), "OS_ARCH" VARCHAR(50), "OS_VERSION" VARCHAR(50), "AVAILABLE_PROCESSORS" INTEGER DEFAULT 0, "FREE_MEMORY_BYTES" NUMERIC(18,0) DEFAULT 0, "TOTAL_MEMORY_BYTES" NUMERIC(18,0) DEFAULT 0, "MAX_MEMORY_BYTES" NUMERIC(18,0) DEFAULT 0, "JAVA_VERSION" VARCHAR(50), "JAVA_VENDOR" VARCHAR(255), "JDBC_VERSION" VARCHAR(255), "SYMMETRIC_VERSION" VARCHAR(50), "TIMEZONE_OFFSET" VARCHAR(6), "HEARTBEAT_TIME" TIMESTAMP, "LAST_RESTART_TIME" TIMESTAMP NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("NODE_ID", "HOST_NAME") ) 2018-12-17 16:14:23,717 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "DATA_ROUTED" NUMERIC(18,0) DEFAULT 0, "DATA_UNROUTED" NUMERIC(18,0) DEFAULT 0, "DATA_EVENT_INSERTED" NUMERIC(18,0) DEFAULT 0, "DATA_EXTRACTED" NUMERIC(18,0) DEFAULT 0, "DATA_BYTES_EXTRACTED" NUMERIC(18,0) DEFAULT 0, "DATA_EXTRACTED_ERRORS" NUMERIC(18,0) DEFAULT 0, "DATA_BYTES_SENT" NUMERIC(18,0) DEFAULT 0, "DATA_SENT" NUMERIC(18,0) DEFAULT 0, "DATA_SENT_ERRORS" NUMERIC(18,0) DEFAULT 0, "DATA_LOADED" NUMERIC(18,0) DEFAULT 0, "DATA_BYTES_LOADED" NUMERIC(18,0) DEFAULT 0, "DATA_LOADED_ERRORS" NUMERIC(18,0) DEFAULT 0, PRIMARY KEY ("NODE_ID", "HOST_NAME", "CHANNEL_ID", "START_TIME", "END_TIME") ) 2018-12-17 16:14:23,719 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2018-12-17 16:14:23,724 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "PROCESSED_COUNT" NUMERIC(18,0) DEFAULT 0, "TARGET_NODE_ID" VARCHAR(50), "TARGET_NODE_COUNT" INTEGER DEFAULT 0, PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME") ) 2018-12-17 16:14:23,725 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2018-12-17 16:14:23,733 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_NODE_HOST_STATS"( "NODE_ID" VARCHAR(50) NOT NULL, "HOST_NAME" VARCHAR(60) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "RESTARTED" NUMERIC(18,0) DEFAULT 0 NOT NULL, "NODES_PULLED" NUMERIC(18,0) DEFAULT 0, "TOTAL_NODES_PULL_TIME" NUMERIC(18,0) DEFAULT 0, "NODES_PUSHED" NUMERIC(18,0) DEFAULT 0, "TOTAL_NODES_PUSH_TIME" NUMERIC(18,0) DEFAULT 0, "NODES_REJECTED" NUMERIC(18,0) DEFAULT 0, "NODES_REGISTERED" NUMERIC(18,0) DEFAULT 0, "NODES_LOADED" NUMERIC(18,0) DEFAULT 0, "NODES_DISABLED" NUMERIC(18,0) DEFAULT 0, "PURGED_DATA_ROWS" NUMERIC(18,0) DEFAULT 0, "PURGED_DATA_EVENT_ROWS" NUMERIC(18,0) DEFAULT 0, "PURGED_BATCH_OUTGOING_ROWS" NUMERIC(18,0) DEFAULT 0, "PURGED_BATCH_INCOMING_ROWS" NUMERIC(18,0) DEFAULT 0, "TRIGGERS_CREATED_COUNT" NUMERIC(18,0), "TRIGGERS_REBUILT_COUNT" NUMERIC(18,0), "TRIGGERS_REMOVED_COUNT" NUMERIC(18,0), PRIMARY KEY ("NODE_ID", "HOST_NAME", "START_TIME", "END_TIME") ) 2018-12-17 16:14:23,735 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2018-12-17 16:14:23,737 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"( "NODE_ID" VARCHAR(50) NOT NULL, PRIMARY KEY ("NODE_ID") ) 2018-12-17 16:14:23,743 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" TIMESTAMP, "INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0, "INITIAL_LOAD_TIME" TIMESTAMP, "INITIAL_LOAD_ID" NUMERIC(18,0), "INITIAL_LOAD_CREATE_BY" VARCHAR(255), "REV_INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0, "REV_INITIAL_LOAD_TIME" TIMESTAMP, "REV_INITIAL_LOAD_ID" NUMERIC(18,0), "REV_INITIAL_LOAD_CREATE_BY" VARCHAR(255), "CREATED_AT_NODE_ID" VARCHAR(50), PRIMARY KEY ("NODE_ID") ) 2018-12-17 16:14:23,749 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_MONITOR"( "MONITOR_ID" VARCHAR(128) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) DEFAULT 'ALL' NOT NULL, "EXTERNAL_ID" VARCHAR(255) DEFAULT 'ALL' NOT NULL, "TYPE" VARCHAR(50) NOT NULL, "EXPRESSION" VARCHAR(4096), "THRESHOLD" NUMERIC(18,0) DEFAULT 0 NOT NULL, "RUN_PERIOD" INTEGER DEFAULT 0 NOT NULL, "RUN_COUNT" INTEGER DEFAULT 0 NOT NULL, "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL, "ENABLED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("MONITOR_ID") ) 2018-12-17 16:14:23,756 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_MONITOR_EVENT"( "MONITOR_ID" VARCHAR(128) NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "EVENT_TIME" TIMESTAMP NOT NULL, "HOST_NAME" VARCHAR(60), "TYPE" VARCHAR(50) NOT NULL, "THRESHOLD" NUMERIC(18,0) DEFAULT 0 NOT NULL, "EVENT_VALUE" NUMERIC(18,0) DEFAULT 0 NOT NULL, "EVENT_COUNT" INTEGER DEFAULT 0 NOT NULL, "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL, "IS_RESOLVED" SMALLINT DEFAULT 0 NOT NULL, "IS_NOTIFIED" SMALLINT DEFAULT 0 NOT NULL, "DETAILS" VARCHAR(4096), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("MONITOR_ID", "NODE_ID", "EVENT_TIME") ) 2018-12-17 16:14:23,762 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_NOTIFICATION"( "NOTIFICATION_ID" VARCHAR(128) NOT NULL, "NODE_GROUP_ID" VARCHAR(50) DEFAULT 'ALL' NOT NULL, "EXTERNAL_ID" VARCHAR(255) DEFAULT 'ALL' NOT NULL, "SEVERITY_LEVEL" INTEGER DEFAULT 0 NOT NULL, "TYPE" VARCHAR(50) NOT NULL, "EXPRESSION" VARCHAR(4096), "ENABLED" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("NOTIFICATION_ID") ) 2018-12-17 16:14:23,785 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_OUTGOING_BATCH"( "BATCH_ID" NUMERIC(18,0) NOT NULL, "NODE_ID" VARCHAR(50) NOT NULL, "CHANNEL_ID" VARCHAR(128), "STATUS" CHAR(2), "ERROR_FLAG" SMALLINT DEFAULT 0, "SQL_STATE" VARCHAR(10), "SQL_CODE" INTEGER DEFAULT 0 NOT NULL, "SQL_MESSAGE" VARCHAR(4096), "LAST_UPDATE_HOSTNAME" VARCHAR(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "SUMMARY" VARCHAR(255), "IGNORE_COUNT" INTEGER DEFAULT 0 NOT NULL, "BYTE_COUNT" NUMERIC(18,0) DEFAULT 0 NOT NULL, "LOAD_FLAG" SMALLINT DEFAULT 0, "EXTRACT_COUNT" INTEGER DEFAULT 0 NOT NULL, "SENT_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_COUNT" INTEGER DEFAULT 0 NOT NULL, "RELOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "OTHER_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "DATA_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_INSERT_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_UPDATE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "LOAD_DELETE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "NETWORK_MILLIS" INTEGER DEFAULT 0 NOT NULL, "FILTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "ROUTER_MILLIS" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TRANSFORM_LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "LOAD_ID" NUMERIC(18,0), "COMMON_FLAG" SMALLINT DEFAULT 0, "FALLBACK_INSERT_COUNT" INTEGER DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" INTEGER DEFAULT 0 NOT NULL, "IGNORE_ROW_COUNT" INTEGER DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" INTEGER DEFAULT 0 NOT NULL, "SKIP_COUNT" INTEGER DEFAULT 0 NOT NULL, "TOTAL_EXTRACT_MILLIS" INTEGER DEFAULT 0 NOT NULL, "TOTAL_LOAD_MILLIS" INTEGER DEFAULT 0 NOT NULL, "EXTRACT_JOB_FLAG" SMALLINT DEFAULT 0, "EXTRACT_START_TIME" TIMESTAMP, "TRANSFER_START_TIME" TIMESTAMP, "LOAD_START_TIME" TIMESTAMP, "FAILED_DATA_ID" NUMERIC(18,0) DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" NUMERIC(18,0) DEFAULT 0 NOT NULL, "CREATE_BY" VARCHAR(255), PRIMARY KEY ("BATCH_ID", "NODE_ID") ) 2018-12-17 16:14:23,788 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS") 2018-12-17 16:14:23,790 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS") 2018-12-17 16:14:23,793 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG") 2018-12-17 16:14:23,798 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" VARCHAR(4096), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY") ) 2018-12-17 16:14:23,801 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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") ) 2018-12-17 16:14:23,807 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" INTEGER DEFAULT 0, "REGISTERED_NODE_ID" VARCHAR(50), "ERROR_MESSAGE" VARCHAR(4096), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("NODE_GROUP_ID", "EXTERNAL_ID", "CREATE_TIME") ) 2018-12-17 16:14:23,809 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS") 2018-12-17 16:14:23,810 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS") 2018-12-17 16:14:23,818 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" VARCHAR(4096), "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" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("ROUTER_ID") ) 2018-12-17 16:14:23,849 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL applied: CREATE TABLE "SYM_SEQUENCE"( "SEQUENCE_NAME" VARCHAR(50) NOT NULL, "CURRENT_VALUE" NUMERIC(18,0) DEFAULT 0 NOT NULL, "INCREMENT_BY" INTEGER DEFAULT 1 NOT NULL, "MIN_VALUE" NUMERIC(18,0) DEFAULT 1 NOT NULL, "MAX_VALUE" NUMERIC(18,0) DEFAULT 9999999999 NOT NULL, "CYCLE_FLAG" SMALLINT DEFAULT 0, "CACHE_SIZE" INTEGER DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("SEQUENCE_NAME") ) 2018-12-17 16:14:23,858 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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, "CREATE_TIME" TIMESTAMP NOT NULL, "CREATE_TABLE" SMALLINT DEFAULT 0 NOT NULL, "DELETE_FIRST" SMALLINT DEFAULT 0 NOT NULL, "RELOAD_SELECT" VARCHAR(4096), "BEFORE_CUSTOM_SQL" VARCHAR(4096), "RELOAD_TIME" TIMESTAMP, "LOAD_ID" NUMERIC(18,0), "PROCESSED" SMALLINT DEFAULT 0 NOT NULL, "CHANNEL_ID" VARCHAR(128), "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID", "CREATE_TIME") ) 2018-12-17 16:14:23,869 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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' NOT NULL, "DELETE_ACTION" VARCHAR(10) NOT NULL, "TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL, "COLUMN_POLICY" VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") ) 2018-12-17 16:14:23,876 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] 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" VARCHAR(4096), "TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME") ) 2018-12-17 16:14:23,894 WARN [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL failed: 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" VARCHAR(4096), "SYNC_ON_INSERT_CONDITION" VARCHAR(4096), "SYNC_ON_DELETE_CONDITION" VARCHAR(4096), "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096), "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096), "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096), "EXTERNAL_SELECT" VARCHAR(4096), "TX_ID_EXPRESSION" VARCHAR(4096), "CHANNEL_EXPRESSION" VARCHAR(4096), "EXCLUDED_COLUMN_NAMES" VARCHAR(4096), "INCLUDED_COLUMN_NAMES" VARCHAR(4096), "SYNC_KEY_NAMES" VARCHAR(4096), "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 1 NOT NULL, "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("TRIGGER_ID") ) 2018-12-17 16:14:23,895 WARN [SymmetricDS] [JdbcSqlTemplate] [qtp1156304131-17] [interclient][interbase]no current record for fetch operation [interclient][interbase]unsuccessful metadata update [interclient][interbase]new record size of 67602 bytes is too big [interclient][interbase]TABLE SYM_TRIGGER. Failed to execute: 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" VARCHAR(4096), "SYNC_ON_INSERT_CONDITION" VARCHAR(4096), "SYNC_ON_DELETE_CONDITION" VARCHAR(4096), "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096), "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096), "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096), "EXTERNAL_SELECT" VARCHAR(4096), "TX_ID_EXPRESSION" VARCHAR(4096), "CHANNEL_EXPRESSION" VARCHAR(4096), "EXCLUDED_COLUMN_NAMES" VARCHAR(4096), "INCLUDED_COLUMN_NAMES" VARCHAR(4096), "SYNC_KEY_NAMES" VARCHAR(4096), "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 1 NOT NULL, "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("TRIGGER_ID") ) 2018-12-17 16:14:23,901 INFO [SymmetricDS] [AbstractSymmetricEngine] [qtp1156304131-17] Initializing connection to database 2018-12-17 16:14:23,911 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp1156304131-17] Detected database 'InterBase', version '10', protocol 'interbase' 2018-12-17 16:14:23,911 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp1156304131-17] The IDatabasePlatform being used is org.jumpmind.db.platform.interbase.InterbaseDatabasePlatform 2018-12-17 16:14:24,127 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] The DbDialect being used is org.jumpmind.symmetric.db.interbase.InterbaseSymmetricDialect 2018-12-17 16:14:24,282 INFO [SymmetricDS] [ExtensionService] [qtp1156304131-17] Found 0 extension points from the database that will be registered 2018-12-17 16:14:24,283 INFO [SymmetricDS] [StagingManager] [qtp1156304131-17] The staging directory was initialized at the following location: tmp\SymmetricDS 2018-12-17 16:14:24,283 INFO [SymmetricDS] [EnhancedStagingManager] [qtp1156304131-17] Compressed staging is enabled 2018-12-17 16:14:24,369 INFO [SymmetricDS] [ExtensionService] [qtp1156304131-17] Found 0 extension points from the database that will be registered 2018-12-17 16:14:24,369 INFO [SymmetricDS] [ClientExtensionService] [qtp1156304131-17] Found 12 extension points from spring that will be registered 2018-12-17 16:14:24,370 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] Checking if SymmetricDS tables need created or altered 2018-12-17 16:14:29,263 INFO [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] There are SymmetricDS tables that needed altered 2018-12-17 16:14:29,280 WARN [SymmetricDS] [InterbaseSymmetricDialect] [qtp1156304131-17] DDL failed: 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" VARCHAR(4096), "SYNC_ON_INSERT_CONDITION" VARCHAR(4096), "SYNC_ON_DELETE_CONDITION" VARCHAR(4096), "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096), "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096), "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096), "EXTERNAL_SELECT" VARCHAR(4096), "TX_ID_EXPRESSION" VARCHAR(4096), "CHANNEL_EXPRESSION" VARCHAR(4096), "EXCLUDED_COLUMN_NAMES" VARCHAR(4096), "INCLUDED_COLUMN_NAMES" VARCHAR(4096), "SYNC_KEY_NAMES" VARCHAR(4096), "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 1 NOT NULL, "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("TRIGGER_ID") ) 2018-12-17 16:14:29,280 WARN [SymmetricDS] [JdbcSqlTemplate] [qtp1156304131-17] [interclient][interbase]no current record for fetch operation [interclient][interbase]unsuccessful metadata update [interclient][interbase]new record size of 67602 bytes is too big [interclient][interbase]TABLE SYM_TRIGGER. Failed to execute: 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" VARCHAR(4096), "SYNC_ON_INSERT_CONDITION" VARCHAR(4096), "SYNC_ON_DELETE_CONDITION" VARCHAR(4096), "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096), "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096), "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096), "EXTERNAL_SELECT" VARCHAR(4096), "TX_ID_EXPRESSION" VARCHAR(4096), "CHANNEL_EXPRESSION" VARCHAR(4096), "EXCLUDED_COLUMN_NAMES" VARCHAR(4096), "INCLUDED_COLUMN_NAMES" VARCHAR(4096), "SYNC_KEY_NAMES" VARCHAR(4096), "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 1 NOT NULL, "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("TRIGGER_ID") ) 2018-12-17 16:14:29,282 ERROR [SymmetricDS] [AppUI] [qtp1156304131-17] Invocation of method uploadFinished in com.jumpmind.symmetric.console.impl.dq$5 failed. StackTraceKey.init [MethodException:468589223] com.vaadin.event.ListenerMethod$MethodException: Invocation of method uploadFinished in com.jumpmind.symmetric.console.impl.dq$5 failed. at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:531) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:211) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:174) at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1033) at com.vaadin.ui.Upload.fireUploadInterrupted(Upload.java:815) at com.vaadin.ui.Upload$2.streamingFailed(Upload.java:1107) at com.vaadin.server.communication.FileUploadHandler.streamToReceiver(FileUploadHandler.java:628) at com.vaadin.server.communication.FileUploadHandler.handleFileUploadValidationAndData(FileUploadHandler.java:460) at com.vaadin.server.communication.FileUploadHandler.doHandleSimpleMultipartFileUpload(FileUploadHandler.java:413) at com.vaadin.server.communication.FileUploadHandler.handleRequest(FileUploadHandler.java:290) at com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1568) at com.vaadin.server.VaadinServlet.service(VaadinServlet.java:381) at com.jumpmind.symmetric.console.ui.AppServlet.service(AppServlet.java:42) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:841) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650) at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:206) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637) at org.jumpmind.symmetric.web.HttpMethodFilter.doFilter(HttpMethodFilter.java:62) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1637) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:190) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:188) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:168) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:166) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132) at org.eclipse.jetty.server.Server.handle(Server.java:561) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:334) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:104) at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:247) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.produce(EatWhatYouKill.java:140) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:243) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:679) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:597) at java.lang.Thread.run(Unknown Source) Caused by: org.jumpmind.db.sql.SqlException: [interclient][interbase]no current record for fetch operation [interclient][interbase]unsuccessful metadata update [interclient][interbase]new record size of 67602 bytes is too big [interclient][interbase]TABLE SYM_TRIGGER at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:503) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:411) at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:115) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:542) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159) at com.jumpmind.symmetric.console.impl.dq$5.uploadFinished(NodeSetupWizard.java:147) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510) ... 47 more Caused by: java.sql.SQLException: [interclient][interbase]no current record for fetch operation [interclient][interbase]unsuccessful metadata update [interclient][interbase]new record size of 67602 bytes is too big [interclient][interbase]TABLE SYM_TRIGGER at interbase.interclient.Statement.remote_EXECUTE_STATEMENT(Unknown Source) at interbase.interclient.Statement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:426) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:411) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501) ... 57 more 2018-12-17 16:15:17,094 INFO [not available] [SecurityService] [background-refresher-1] Generated secret key using AES/GCM/PKCS5Padding 256 2018-12-17 16:15:17,230 INFO [not available] [SecurityService] [background-refresher-1] Initialized with AES 256-bit 2018-12-17 16:15:17,238 INFO [lame-easy_test_3_9_15] [AbstractSymmetricEngine] [background-refresher-1] Initializing connection to database 2018-12-17 16:15:17,339 INFO [lame-easy_test_3_9_15] [SecurityService] [background-refresher-1] Initialized with AES 256-bit 2018-12-17 16:15:17,350 INFO [lame-easy_test_3_9_15] [JdbcDatabasePlatformFactory] [background-refresher-1] Detected database 'InterBase', version '10', protocol 'interbase' 2018-12-17 16:15:17,350 INFO [lame-easy_test_3_9_15] [JdbcDatabasePlatformFactory] [background-refresher-1] The IDatabasePlatform being used is org.jumpmind.db.platform.interbase.InterbaseDatabasePlatform 2018-12-17 16:15:17,484 INFO [lame-easy_test_3_9_15] [InterbaseSymmetricDialect] [background-refresher-1] The DbDialect being used is org.jumpmind.symmetric.db.interbase.InterbaseSymmetricDialect 2018-12-17 16:15:17,602 INFO [lame-easy_test_3_9_15] [ExtensionService] [background-refresher-1] Found 0 extension points from the database that will be registered 2018-12-17 16:15:17,603 INFO [lame-easy_test_3_9_15] [StagingManager] [background-refresher-1] The staging directory was initialized at the following location: tmp\lame-easy_test_3_9_15 2018-12-17 16:15:17,603 INFO [lame-easy_test_3_9_15] [EnhancedStagingManager] [background-refresher-1] Compressed staging is enabled 2018-12-17 16:15:17,767 INFO [lame-easy_test_3_9_15] [ExtensionService] [background-refresher-1] Found 0 extension points from the database that will be registered 2018-12-17 16:15:17,767 INFO [lame-easy_test_3_9_15] [ClientExtensionService] [background-refresher-1] Found 14 extension points from spring that will be registered 2018-12-17 16:15:17,777 INFO [lame-easy_test_3_9_15] [AbstractSymmetricEngine] [background-refresher-1] Initializing SymmetricDS database 2018-12-17 16:15:17,777 INFO [lame-easy_test_3_9_15] [InterbaseSymmetricDialect] [background-refresher-1] Checking if SymmetricDS tables need created or altered 2018-12-17 16:15:22,531 INFO [lame-easy_test_3_9_15] [InterbaseSymmetricDialect] [background-refresher-1] There are SymmetricDS tables that needed altered 2018-12-17 16:15:22,546 WARN [lame-easy_test_3_9_15] [InterbaseSymmetricDialect] [background-refresher-1] DDL failed: 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" VARCHAR(4096), "SYNC_ON_INSERT_CONDITION" VARCHAR(4096), "SYNC_ON_DELETE_CONDITION" VARCHAR(4096), "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096), "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096), "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096), "EXTERNAL_SELECT" VARCHAR(4096), "TX_ID_EXPRESSION" VARCHAR(4096), "CHANNEL_EXPRESSION" VARCHAR(4096), "EXCLUDED_COLUMN_NAMES" VARCHAR(4096), "INCLUDED_COLUMN_NAMES" VARCHAR(4096), "SYNC_KEY_NAMES" VARCHAR(4096), "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 1 NOT NULL, "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("TRIGGER_ID") ) 2018-12-17 16:15:22,547 WARN [lame-easy_test_3_9_15] [JdbcSqlTemplate] [background-refresher-1] [interclient][interbase]no current record for fetch operation [interclient][interbase]unsuccessful metadata update [interclient][interbase]new record size of 67602 bytes is too big [interclient][interbase]TABLE SYM_TRIGGER. Failed to execute: 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" VARCHAR(4096), "SYNC_ON_INSERT_CONDITION" VARCHAR(4096), "SYNC_ON_DELETE_CONDITION" VARCHAR(4096), "CUSTOM_BEFORE_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_INSERT_TEXT" VARCHAR(4096), "CUSTOM_BEFORE_DELETE_TEXT" VARCHAR(4096), "CUSTOM_ON_UPDATE_TEXT" VARCHAR(4096), "CUSTOM_ON_INSERT_TEXT" VARCHAR(4096), "CUSTOM_ON_DELETE_TEXT" VARCHAR(4096), "EXTERNAL_SELECT" VARCHAR(4096), "TX_ID_EXPRESSION" VARCHAR(4096), "CHANNEL_EXPRESSION" VARCHAR(4096), "EXCLUDED_COLUMN_NAMES" VARCHAR(4096), "INCLUDED_COLUMN_NAMES" VARCHAR(4096), "SYNC_KEY_NAMES" VARCHAR(4096), "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 1 NOT NULL, "STREAM_ROW" SMALLINT DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" VARCHAR(4096), PRIMARY KEY ("TRIGGER_ID") ) 2018-12-17 16:15:22,547 ERROR [lame-easy_test_3_9_15] [AbstractSymmetricEngine] [background-refresher-1] An error occurred while starting SymmetricDS StackTraceKey.init [SqlException:2946958765] org.jumpmind.db.sql.SqlException: [interclient][interbase]no current record for fetch operation [interclient][interbase]unsuccessful metadata update [interclient][interbase]new record size of 67602 bytes is too big [interclient][interbase]TABLE SYM_TRIGGER at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:503) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:411) at org.jumpmind.db.sql.SqlScript.execute(SqlScript.java:115) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.createOrAlterTablesIfNecessary(AbstractSymmetricDialect.java:542) at org.jumpmind.symmetric.db.AbstractSymmetricDialect.initTablesAndDatabaseObjects(AbstractSymmetricDialect.java:159) at org.jumpmind.symmetric.AbstractSymmetricEngine.setupDatabase(AbstractSymmetricEngine.java:501) at org.jumpmind.symmetric.AbstractSymmetricEngine.setup(AbstractSymmetricEngine.java:475) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:645) at org.jumpmind.symmetric.AbstractSymmetricEngine.start(AbstractSymmetricEngine.java:634) at org.jumpmind.symmetric.ClientSymmetricEngine.start(ClientSymmetricEngine.java:276) at org.jumpmind.symmetric.web.SymmetricEngineHolder.install(SymmetricEngineHolder.java:429) at com.jumpmind.symmetric.console.impl.de.t(AbstractWizardScreen.java:149) at com.jumpmind.symmetric.console.impl.du$a.doWork(SummaryScreen.java:68) at com.jumpmind.symmetric.console.impl.ab$2.onBackgroundDataRefresh(InProgressDialog.java:99) at com.jumpmind.symmetric.console.ui.a.a(BackgroundRefresherService.java:99) at com.jumpmind.symmetric.console.ui.a$3.run(BackgroundRefresherService.java:142) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: [interclient][interbase]no current record for fetch operation [interclient][interbase]unsuccessful metadata update [interclient][interbase]new record size of 67602 bytes is too big [interclient][interbase]TABLE SYM_TRIGGER at interbase.interclient.Statement.remote_EXECUTE_STATEMENT(Unknown Source) at interbase.interclient.Statement.execute(Unknown Source) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:426) at org.jumpmind.db.sql.JdbcSqlTemplate$6.execute(JdbcSqlTemplate.java:411) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501) ... 22 more 2018-12-17 16:15:22,548 INFO [lame-easy_test_3_9_15] [AbstractSymmetricEngine] [background-refresher-1] Stopping SymmetricDS externalId=easy_test_3_9_15 version=3.9.15 database=InterBase 2018-12-17 16:15:22,548 INFO [lame-easy_test_3_9_15] [AbstractSymmetricEngine] [background-refresher-1] 2018-12-17 16:15:22,564 ERROR [lame-easy_test_3_9_15] [a] [background-refresher-1] Exception while refreshing class com.jumpmind.symmetric.console.impl.ab$2 StackTraceKey.init [SqlException:3796432620] org.jumpmind.db.sql.SqlException: [interclient][interbase]Dynamic SQL Error [interclient][interbase]SQL error code = -204 [interclient][interbase]Table unknown [interclient][interbase]SYM_CONSOLE_USER at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:302) at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:291) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:503) at org.jumpmind.db.sql.JdbcSqlTemplate.update(JdbcSqlTemplate.java:342) at org.jumpmind.db.sql.AbstractSqlTemplate.update(AbstractSqlTemplate.java:224) at com.jumpmind.symmetric.console.service.impl.ConsoleUserService.save(ConsoleUserService.java:112) at com.jumpmind.symmetric.console.impl.du.u(SummaryScreen.java:60) at com.jumpmind.symmetric.console.impl.de.t(AbstractWizardScreen.java:160) at com.jumpmind.symmetric.console.impl.du$a.doWork(SummaryScreen.java:68) at com.jumpmind.symmetric.console.impl.ab$2.onBackgroundDataRefresh(InProgressDialog.java:99) at com.jumpmind.symmetric.console.ui.a.a(BackgroundRefresherService.java:99) at com.jumpmind.symmetric.console.ui.a$3.run(BackgroundRefresherService.java:142) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: [interclient][interbase]Dynamic SQL Error [interclient][interbase]SQL error code = -204 [interclient][interbase]Table unknown [interclient][interbase]SYM_CONSOLE_USER at interbase.interclient.PreparedStatement.remote_PREPARE_STATEMENT(Unknown Source) at interbase.interclient.PreparedStatement.(Unknown Source) at interbase.interclient.Connection.prepareStatement(Unknown Source) at interbase.interclient.Connection.prepareStatement(Unknown Source) at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313) at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:369) at org.jumpmind.db.sql.JdbcSqlTemplate$5.execute(JdbcSqlTemplate.java:342) at org.jumpmind.db.sql.JdbcSqlTemplate.execute(JdbcSqlTemplate.java:501) ... 16 more