View Issue Details

IDProjectCategoryView StatusLast Update
0002369SymmetricDSBugpublic2019-08-26 12:45
Reportersteffenb Assigned To 
Prioritynormal 
Status closedResolutionopen 
Product Version3.7.19 
Summary0002369: Firebird exception: "Implementation limit exceeded" when installing Sym tables
DescriptionI was following the install guide on SymmetricDS to try it out.
Both on an existing database and on a newly created one, it fails when creating the SymmetricDS tables in step 2.1.1.
Steps To Reproduce1. Create an empty Firebird DB.
2. Changed *.properties files to use firebird driver and our user/password.
3. ../bin/dbimport --engine corp-000 --format XML --alter-case create_sample.xml
4. ../bin/symadmin --engine corp-000 create-sym-tables
It install many tables but eventually fails:

declare external function sym_hex blob
  returns cstring(32660) free_it entry_point 'sym_hex' module_name 'sym_udf'
-------------------------------------------------------------------------------
An exception occurred. Please see the following for details:
-------------------------------------------------------------------------------
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -204
Data type unknown
Implementation limit exceeded
COLUMN DSQL internal
    at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>(AbstractPreparedStatement.java:147)
    at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.java:46)
    at sun.reflect.GeneratedConstructorAccessor6.newInstance(Unknown Source)
Additional InformationAttached log file.
I tried a few times, last time on a DB already containing some tables from previous attempt.
TagsNo tags attached.

Activities

steffenb

2015-08-11 12:53

reporter  

symmetric.log (85,191 bytes)   
2015-08-11 10:54:34,062 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2015-08-11 10:54:34,064 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML}
2015-08-11 10:54:34,065 INFO [] [AbstractCommandLauncher] [main] Option: name=alter-case, value={}
2015-08-11 10:54:34,727 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql'
2015-08-11 10:54:34,767 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform
2015-08-11 10:54:34,877 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dbimport">
	<table name="item">
		<column name="item_id" primaryKey="true" required="true" type="INTEGER"/>
		<column name="name" type="VARCHAR" size="100"/>
	</table>
</database>
2015-08-11 10:54:34,993 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dbimport">
	<table name="item_selling_price">
		<column name="item_id" primaryKey="true" required="true" type="INTEGER"/>
		<column name="store_id" primaryKey="true" required="true" type="VARCHAR" size="5"/>
		<column name="price" required="true" type="DECIMAL" size="10,2"/>
		<column name="cost" type="DECIMAL" size="10,2"/>
		<foreign-key name="fk_price_item_id" foreignTable="item">
			<reference local="item_id" foreign="item_id"/>
		</foreign-key>
	</table>
</database>
2015-08-11 10:54:35,158 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dbimport">
	<table name="sale_transaction">
		<column name="tran_id" primaryKey="true" required="true" type="INTEGER"/>
		<column name="store_id" required="true" type="VARCHAR" size="5"/>
		<column name="workstation" required="true" type="VARCHAR" size="3"/>
		<column name="day" required="true" type="VARCHAR" size="10"/>
		<column name="seq" required="true" type="INTEGER"/>
	</table>
</database>
2015-08-11 10:54:35,271 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dbimport">
	<table name="sale_return_line_item">
		<column name="tran_id" primaryKey="true" required="true" type="INTEGER"/>
		<column name="item_id" required="true" type="INTEGER"/>
		<column name="price" required="true" type="DECIMAL" size="10,2"/>
		<column name="quantity" required="true" type="INTEGER"/>
		<column name="returned_quantity" type="INTEGER"/>
		<foreign-key name="fk_srli_tran_id" foreignTable="sale_transaction">
			<reference local="tran_id" foreign="tran_id"/>
		</foreign-key>
		<foreign-key name="fk_srli_item_id" foreignTable="item">
			<reference local="item_id" foreign="item_id"/>
		</foreign-key>
	</table>
</database>
2015-08-11 11:00:32,674 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2015-08-11 11:00:32,680 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML}
2015-08-11 11:00:32,681 INFO [] [AbstractCommandLauncher] [main] Option: name=alter-case, value={}
2015-08-11 11:00:33,332 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql'
2015-08-11 11:00:33,372 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform
2015-08-11 11:00:33,594 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dbimport">
	<table name="item">
		<column name="item_id" primaryKey="true" required="true" type="INTEGER"/>
		<column name="name" type="VARCHAR" size="100"/>
	</table>
</database>
2015-08-11 11:00:33,631 WARN [] [JdbcSqlTemplate] [main] GDS Exception. 335544351. unsuccessful metadata update
Table ITEM already exists
null
null.  Failed to execute: CREATE TABLE "ITEM"(
    "ITEM_ID" INTEGER NOT NULL,
    "NAME" VARCHAR(100),
    PRIMARY KEY ("ITEM_ID")
)
2015-08-11 11:00:33,633 ERROR [] [DefaultDatabaseWriter] [main] Failed to alter table using the following xml: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dbimport">
	<table name="item">
		<column name="item_id" primaryKey="true" required="true" type="INTEGER"/>
		<column name="name" type="VARCHAR" size="100"/>
	</table>
</database>
2015-08-11 11:04:00,505 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2015-08-11 11:04:01,147 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql'
2015-08-11 11:04:01,163 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform
2015-08-11 11:04:01,239 INFO [corp-000] [Firebird21SymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.firebird.Firebird21SymmetricDialect
2015-08-11 11:04:01,296 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: /web/symmetric-server-3.7.19/tmp/corp-000
2015-08-11 11:04:01,386 INFO [corp-000] [ClusterService] [main] This node picked a server id of host4.webdts.eu
2015-08-11 11:04:02,648 INFO [corp-000] [ClientExtensionService] [main] Found 8 extension points from spring that will be registered
2015-08-11 11:04:02,649 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database
2015-08-11 11:04:02,649 INFO [corp-000] [Firebird21SymmetricDialect] [main] Checking if SymmetricDS tables need created or altered
2015-08-11 11:04:03,713 INFO [corp-000] [Firebird21SymmetricDialect] [main] There are SymmetricDS tables that needed altered
2015-08-11 11:04:03,799 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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),
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("CHANNEL_ID")
)
2015-08-11 11:04:03,881 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE 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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("CONFLICT_ID")
)
2015-08-11 11:04:04,009 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_DATA"(
    "DATA_ID" BIGINT NOT NULL ,
    "TABLE_NAME" VARCHAR(255) NOT NULL,
    "EVENT_TYPE" CHAR(1) NOT NULL,
    "ROW_DATA" BLOB SUB_TYPE TEXT,
    "PK_DATA" BLOB SUB_TYPE TEXT,
    "OLD_DATA" BLOB SUB_TYPE TEXT,
    "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")
)
2015-08-11 11:04:04,057 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID")
2015-08-11 11:04:04,061 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE GENERATOR "GEN_SYM_DATA_DATA_ID"
2015-08-11 11:04:04,080 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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
2015-08-11 11:04:04,138 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP,
    PRIMARY KEY ("DATA_ID", "BATCH_ID", "ROUTER_ID")
)
2015-08-11 11:04:04,187 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID")
2015-08-11 11:04:04,252 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_DATA_GAP"(
    "START_ID" BIGINT NOT NULL,
    "END_ID" BIGINT 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")
)
2015-08-11 11:04:04,274 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_DG_STATUS" ON "SYM_DATA_GAP" ("STATUS")
2015-08-11 11:04:04,362 INFO [corp-000] [Firebird21SymmetricDialect] [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" INTEGER DEFAULT 1 NOT NULL,
    "EXTENSION_TEXT" BLOB SUB_TYPE TEXT,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("EXTENSION_ID")
)
2015-08-11 11:04:04,443 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    PRIMARY KEY ("REQUEST_ID")
)
2015-08-11 11:04:04,559 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:04,666 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "CREATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID", "RELATIVE_DIR", "FILE_NAME")
)
2015-08-11 11:04:04,675 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID")
2015-08-11 11:04:04,745 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT,
    "AFTER_COPY_SCRIPT" BLOB SUB_TYPE TEXT,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID")
)
2015-08-11 11:04:04,844 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2015-08-11 11:04:04,992 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("GROUPLET_ID")
)
2015-08-11 11:04:05,049 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_GROUPLET_LINK"(
    "GROUPLET_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(50) NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID")
)
2015-08-11 11:04:05,125 INFO [corp-000] [Firebird21SymmetricDialect] [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" INTEGER DEFAULT 0 NOT NULL,
    "SQL_MESSAGE" BLOB SUB_TYPE TEXT,
    "LAST_UPDATE_HOSTNAME" VARCHAR(255),
    "LAST_UPDATE_TIME" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    PRIMARY KEY ("BATCH_ID", "NODE_ID")
)
2015-08-11 11:04:05,170 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS")
2015-08-11 11:04:05,270 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG")
2015-08-11 11:04:05,364 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT NOT NULL,
    "PK_COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL,
    "ROW_DATA" BLOB SUB_TYPE TEXT,
    "OLD_DATA" BLOB SUB_TYPE TEXT,
    "CUR_DATA" BLOB SUB_TYPE TEXT,
    "RESOLVE_DATA" BLOB SUB_TYPE TEXT,
    "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")
)
2015-08-11 11:04:05,436 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT,
    "AFTER_WRITE_SCRIPT" BLOB SUB_TYPE TEXT,
    "BATCH_COMPLETE_SCRIPT" BLOB SUB_TYPE TEXT,
    "BATCH_COMMIT_SCRIPT" BLOB SUB_TYPE TEXT,
    "BATCH_ROLLBACK_SCRIPT" BLOB SUB_TYPE TEXT,
    "HANDLE_ERROR_SCRIPT" BLOB SUB_TYPE TEXT,
    "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")
)
2015-08-11 11:04:05,618 INFO [corp-000] [Firebird21SymmetricDialect] [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" 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")
)
2015-08-11 11:04:05,709 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(50) NOT NULL,
    "SYNC_ENABLED" SMALLINT DEFAULT 0,
    "SYNC_URL" VARCHAR(255),
    "SCHEMA_VERSION" VARCHAR(50),
    "SYMMETRIC_VERSION" VARCHAR(50),
    "DATABASE_TYPE" VARCHAR(50),
    "DATABASE_VERSION" VARCHAR(50),
    "HEARTBEAT_TIME" TIMESTAMP,
    "TIMEZONE_OFFSET" VARCHAR(6),
    "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0,
    "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0,
    "CREATED_AT_NODE_ID" VARCHAR(50),
    "DEPLOYMENT_TYPE" VARCHAR(50),
    PRIMARY KEY ("NODE_ID")
)
2015-08-11 11:04:05,789 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE_COMMUNICATION"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "COMMUNICATION_TYPE" VARCHAR(10) NOT NULL,
    "LOCK_TIME" TIMESTAMP,
    "LOCKING_SERVER_ID" VARCHAR(255),
    "LAST_LOCK_TIME" TIMESTAMP,
    "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-08-11 11:04:05,860 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP,
    PRIMARY KEY ("NODE_ID", "CHANNEL_ID")
)
2015-08-11 11:04:05,977 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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")
)
2015-08-11 11:04:06,226 INFO [corp-000] [Firebird21SymmetricDialect] [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" 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")
)
2015-08-11 11:04:06,337 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID")
)
2015-08-11 11:04:06,376 INFO [corp-000] [Firebird21SymmetricDialect] [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" INTEGER 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" TIMESTAMP,
    "LAST_RESTART_TIME" TIMESTAMP NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("NODE_ID", "HOST_NAME")
)
2015-08-11 11:04:06,415 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "END_TIME" TIMESTAMP 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-08-11 11:04:06,425 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2015-08-11 11:04:06,597 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "END_TIME" TIMESTAMP NOT NULL,
    "PROCESSED_COUNT" BIGINT DEFAULT 0,
    PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME")
)
2015-08-11 11:04:06,663 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2015-08-11 11:04:06,811 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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" 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-08-11 11:04:06,861 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2015-08-11 11:04:06,971 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    PRIMARY KEY ("NODE_ID")
)
2015-08-11 11:04:07,048 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP,
    "INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0,
    "INITIAL_LOAD_TIME" TIMESTAMP,
    "INITIAL_LOAD_ID" BIGINT,
    "INITIAL_LOAD_CREATE_BY" VARCHAR(255),
    "REV_INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0,
    "REV_INITIAL_LOAD_TIME" TIMESTAMP,
    "REV_INITIAL_LOAD_ID" BIGINT,
    "REV_INITIAL_LOAD_CREATE_BY" VARCHAR(255),
    "CREATED_AT_NODE_ID" VARCHAR(50),
    PRIMARY KEY ("NODE_ID")
)
2015-08-11 11:04:07,301 INFO [corp-000] [Firebird21SymmetricDialect] [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" INTEGER DEFAULT 0 NOT NULL,
    "SQL_MESSAGE" BLOB SUB_TYPE 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" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    "CREATE_BY" VARCHAR(255),
    PRIMARY KEY ("BATCH_ID", "NODE_ID")
)
2015-08-11 11:04:07,391 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS")
2015-08-11 11:04:07,407 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS")
2015-08-11 11:04:07,426 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG")
2015-08-11 11:04:07,485 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_PARAMETER"(
    "EXTERNAL_ID" VARCHAR(50) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "PARAM_KEY" VARCHAR(80) NOT NULL,
    "PARAM_VALUE" BLOB SUB_TYPE TEXT,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY")
)
2015-08-11 11:04:07,578 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_REGISTRATION_REDIRECT"(
    "REGISTRANT_EXTERNAL_ID" VARCHAR(50) NOT NULL,
    "REGISTRATION_NODE_ID" VARCHAR(50) NOT NULL,
    PRIMARY KEY ("REGISTRANT_EXTERNAL_ID")
)
2015-08-11 11:04:07,675 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_REGISTRATION_REQUEST"(
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(50) NOT NULL,
    "STATUS" CHAR(2) NOT NULL,
    "HOST_NAME" VARCHAR(60) NOT NULL,
    "IP_ADDRESS" VARCHAR(50) NOT NULL,
    "ATTEMPT_COUNT" INTEGER DEFAULT 0,
    "REGISTERED_NODE_ID" VARCHAR(50),
    "ERROR_MESSAGE" BLOB SUB_TYPE TEXT,
    "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")
)
2015-08-11 11:04:07,713 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:07,769 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS")
2015-08-11 11:04:07,829 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE 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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("ROUTER_ID")
)
2015-08-11 11:04:07,901 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_SEQUENCE"(
    "SEQUENCE_NAME" VARCHAR(50) NOT NULL,
    "CURRENT_VALUE" BIGINT DEFAULT 0 NOT NULL,
    "INCREMENT_BY" INTEGER DEFAULT 1 NOT NULL,
    "MIN_VALUE" BIGINT DEFAULT 1 NOT NULL,
    "MAX_VALUE" BIGINT DEFAULT 9999999999 NOT NULL,
    "CYCLE" SMALLINT DEFAULT 0,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("SEQUENCE_NAME")
)
2015-08-11 11:04:08,116 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT,
    "RELOAD_DELETE_STMT" BLOB SUB_TYPE TEXT,
    "RELOAD_ENABLED" SMALLINT DEFAULT 0,
    "RELOAD_TIME" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID")
)
2015-08-11 11:04:08,267 INFO [corp-000] [Firebird21SymmetricDialect] [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,
    "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,
    PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID")
)
2015-08-11 11:04:08,425 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT,
    "TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME")
)
2015-08-11 11:04:08,500 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT,
    "SYNC_ON_INSERT_CONDITION" BLOB SUB_TYPE TEXT,
    "SYNC_ON_DELETE_CONDITION" BLOB SUB_TYPE TEXT,
    "CUSTOM_ON_UPDATE_TEXT" BLOB SUB_TYPE TEXT,
    "CUSTOM_ON_INSERT_TEXT" BLOB SUB_TYPE TEXT,
    "CUSTOM_ON_DELETE_TEXT" BLOB SUB_TYPE TEXT,
    "EXTERNAL_SELECT" BLOB SUB_TYPE TEXT,
    "TX_ID_EXPRESSION" BLOB SUB_TYPE TEXT,
    "CHANNEL_EXPRESSION" BLOB SUB_TYPE TEXT,
    "EXCLUDED_COLUMN_NAMES" BLOB SUB_TYPE TEXT,
    "SYNC_KEY_NAMES" BLOB SUB_TYPE 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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID")
)
2015-08-11 11:04:08,590 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_TRIGGER_HIST"(
    "TRIGGER_HIST_ID" INTEGER 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" BLOB SUB_TYPE TEXT NOT NULL,
    "PK_COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL,
    "LAST_TRIGGER_BUILD_REASON" CHAR(1) NOT NULL,
    "ERROR_MESSAGE" BLOB SUB_TYPE TEXT,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "INACTIVE_TIME" TIMESTAMP,
    PRIMARY KEY ("TRIGGER_HIST_ID")
)
2015-08-11 11:04:08,993 INFO [corp-000] [Firebird21SymmetricDialect] [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" INTEGER DEFAULT 1 NOT NULL,
    "INITIAL_LOAD_SELECT" BLOB SUB_TYPE TEXT,
    "INITIAL_LOAD_DELETE_STMT" BLOB SUB_TYPE TEXT,
    "INITIAL_LOAD_BATCH_COUNT" INTEGER DEFAULT 1,
    "PING_BACK_ENABLED" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2015-08-11 11:04:09,224 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("GROUPLET_ID", "TRIGGER_ID", "ROUTER_ID", "APPLIES_WHEN")
)
2015-08-11 11:04:09,273 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:09,297 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:09,325 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:09,339 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:09,567 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:09,623 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:09,812 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:09,887 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:09,944 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:10,156 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:10,311 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER"
    ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID")
2015-08-11 11:04:10,463 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:10,639 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:10,728 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:10,818 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:10,885 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:04:10,885 INFO [corp-000] [Firebird21SymmetricDialect] [main] Done with auto update of SymmetricDS tables
2015-08-11 11:04:11,242 INFO [corp-000] [Firebird21SymmetricDialect] [main] Installing SymmetricDS database object:
declare external function sym_hex blob                                                                                                                                                           returns cstring(32660) free_it entry_point 'sym_hex' module_name 'sym_udf'                                                                                             
2015-08-11 11:33:08,045 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2015-08-11 11:33:08,053 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML}
2015-08-11 11:33:08,053 INFO [] [AbstractCommandLauncher] [main] Option: name=alter-case, value={}
2015-08-11 11:36:26,216 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2015-08-11 11:36:26,227 INFO [] [AbstractCommandLauncher] [main] Option: name=format, value={XML}
2015-08-11 11:36:26,227 INFO [] [AbstractCommandLauncher] [main] Option: name=alter-case, value={}
2015-08-11 11:36:26,793 INFO [] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql'
2015-08-11 11:36:26,833 INFO [] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform
2015-08-11 11:36:26,923 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dbimport">
	<table name="item">
		<column name="item_id" primaryKey="true" required="true" type="INTEGER"/>
		<column name="name" type="VARCHAR" size="100"/>
	</table>
</database>
2015-08-11 11:36:27,020 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dbimport">
	<table name="item_selling_price">
		<column name="item_id" primaryKey="true" required="true" type="INTEGER"/>
		<column name="store_id" primaryKey="true" required="true" type="VARCHAR" size="5"/>
		<column name="price" required="true" type="DECIMAL" size="10,2"/>
		<column name="cost" type="DECIMAL" size="10,2"/>
		<foreign-key name="fk_price_item_id" foreignTable="item">
			<reference local="item_id" foreign="item_id"/>
		</foreign-key>
	</table>
</database>
2015-08-11 11:36:27,123 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dbimport">
	<table name="sale_transaction">
		<column name="tran_id" primaryKey="true" required="true" type="INTEGER"/>
		<column name="store_id" required="true" type="VARCHAR" size="5"/>
		<column name="workstation" required="true" type="VARCHAR" size="3"/>
		<column name="day" required="true" type="VARCHAR" size="10"/>
		<column name="seq" required="true" type="INTEGER"/>
	</table>
</database>
2015-08-11 11:36:27,284 INFO [] [DefaultDatabaseWriter] [main] About to create table using the following definition: <?xml version="1.0"?>
<!DOCTYPE database SYSTEM "http://db.apache.org/torque/dtd/database">
<database name="dbimport">
	<table name="sale_return_line_item">
		<column name="tran_id" primaryKey="true" required="true" type="INTEGER"/>
		<column name="item_id" required="true" type="INTEGER"/>
		<column name="price" required="true" type="DECIMAL" size="10,2"/>
		<column name="quantity" required="true" type="INTEGER"/>
		<column name="returned_quantity" type="INTEGER"/>
		<foreign-key name="fk_srli_tran_id" foreignTable="sale_transaction">
			<reference local="tran_id" foreign="tran_id"/>
		</foreign-key>
		<foreign-key name="fk_srli_item_id" foreignTable="item">
			<reference local="item_id" foreign="item_id"/>
		</foreign-key>
	</table>
</database>
2015-08-11 11:37:10,108 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2015-08-11 11:37:10,762 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql'
2015-08-11 11:37:10,778 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform
2015-08-11 11:37:10,839 INFO [corp-000] [Firebird21SymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.firebird.Firebird21SymmetricDialect
2015-08-11 11:37:10,865 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: /web/symmetric-server-3.7.19/tmp/corp-000
2015-08-11 11:37:10,952 INFO [corp-000] [ClusterService] [main] This node picked a server id of host4.webdts.eu
2015-08-11 11:37:12,055 INFO [corp-000] [ClientExtensionService] [main] Found 8 extension points from spring that will be registered
2015-08-11 11:37:12,056 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database
2015-08-11 11:37:12,056 INFO [corp-000] [Firebird21SymmetricDialect] [main] Checking if SymmetricDS tables need created or altered
2015-08-11 11:37:12,559 INFO [corp-000] [Firebird21SymmetricDialect] [main] There are SymmetricDS tables that needed altered
2015-08-11 11:37:12,635 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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),
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("CHANNEL_ID")
)
2015-08-11 11:37:12,712 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE 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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("CONFLICT_ID")
)
2015-08-11 11:37:12,793 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_DATA"(
    "DATA_ID" BIGINT NOT NULL ,
    "TABLE_NAME" VARCHAR(255) NOT NULL,
    "EVENT_TYPE" CHAR(1) NOT NULL,
    "ROW_DATA" BLOB SUB_TYPE TEXT,
    "PK_DATA" BLOB SUB_TYPE TEXT,
    "OLD_DATA" BLOB SUB_TYPE TEXT,
    "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")
)
2015-08-11 11:37:12,884 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID")
2015-08-11 11:37:12,892 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE GENERATOR "GEN_SYM_DATA_DATA_ID"
2015-08-11 11:37:12,924 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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
2015-08-11 11:37:12,967 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP,
    PRIMARY KEY ("DATA_ID", "BATCH_ID", "ROUTER_ID")
)
2015-08-11 11:37:12,976 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID")
2015-08-11 11:37:12,999 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_DATA_GAP"(
    "START_ID" BIGINT NOT NULL,
    "END_ID" BIGINT 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")
)
2015-08-11 11:37:13,008 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_DG_STATUS" ON "SYM_DATA_GAP" ("STATUS")
2015-08-11 11:37:13,140 INFO [corp-000] [Firebird21SymmetricDialect] [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" INTEGER DEFAULT 1 NOT NULL,
    "EXTENSION_TEXT" BLOB SUB_TYPE TEXT,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("EXTENSION_ID")
)
2015-08-11 11:37:13,278 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    PRIMARY KEY ("REQUEST_ID")
)
2015-08-11 11:37:13,383 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:13,488 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "CREATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID", "RELATIVE_DIR", "FILE_NAME")
)
2015-08-11 11:37:13,538 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID")
2015-08-11 11:37:13,646 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT,
    "AFTER_COPY_SCRIPT" BLOB SUB_TYPE TEXT,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID")
)
2015-08-11 11:37:13,730 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2015-08-11 11:37:13,761 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("GROUPLET_ID")
)
2015-08-11 11:37:13,857 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_GROUPLET_LINK"(
    "GROUPLET_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(50) NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID")
)
2015-08-11 11:37:13,946 INFO [corp-000] [Firebird21SymmetricDialect] [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" INTEGER DEFAULT 0 NOT NULL,
    "SQL_MESSAGE" BLOB SUB_TYPE TEXT,
    "LAST_UPDATE_HOSTNAME" VARCHAR(255),
    "LAST_UPDATE_TIME" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    PRIMARY KEY ("BATCH_ID", "NODE_ID")
)
2015-08-11 11:37:14,029 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS")
2015-08-11 11:37:14,067 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG")
2015-08-11 11:37:14,174 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT NOT NULL,
    "PK_COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL,
    "ROW_DATA" BLOB SUB_TYPE TEXT,
    "OLD_DATA" BLOB SUB_TYPE TEXT,
    "CUR_DATA" BLOB SUB_TYPE TEXT,
    "RESOLVE_DATA" BLOB SUB_TYPE TEXT,
    "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")
)
2015-08-11 11:37:14,316 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT,
    "AFTER_WRITE_SCRIPT" BLOB SUB_TYPE TEXT,
    "BATCH_COMPLETE_SCRIPT" BLOB SUB_TYPE TEXT,
    "BATCH_COMMIT_SCRIPT" BLOB SUB_TYPE TEXT,
    "BATCH_ROLLBACK_SCRIPT" BLOB SUB_TYPE TEXT,
    "HANDLE_ERROR_SCRIPT" BLOB SUB_TYPE TEXT,
    "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")
)
2015-08-11 11:37:14,404 INFO [corp-000] [Firebird21SymmetricDialect] [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" 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")
)
2015-08-11 11:37:14,566 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(50) NOT NULL,
    "SYNC_ENABLED" SMALLINT DEFAULT 0,
    "SYNC_URL" VARCHAR(255),
    "SCHEMA_VERSION" VARCHAR(50),
    "SYMMETRIC_VERSION" VARCHAR(50),
    "DATABASE_TYPE" VARCHAR(50),
    "DATABASE_VERSION" VARCHAR(50),
    "HEARTBEAT_TIME" TIMESTAMP,
    "TIMEZONE_OFFSET" VARCHAR(6),
    "BATCH_TO_SEND_COUNT" INTEGER DEFAULT 0,
    "BATCH_IN_ERROR_COUNT" INTEGER DEFAULT 0,
    "CREATED_AT_NODE_ID" VARCHAR(50),
    "DEPLOYMENT_TYPE" VARCHAR(50),
    PRIMARY KEY ("NODE_ID")
)
2015-08-11 11:37:14,694 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE_COMMUNICATION"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    "COMMUNICATION_TYPE" VARCHAR(10) NOT NULL,
    "LOCK_TIME" TIMESTAMP,
    "LOCKING_SERVER_ID" VARCHAR(255),
    "LAST_LOCK_TIME" TIMESTAMP,
    "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-08-11 11:37:14,749 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP,
    PRIMARY KEY ("NODE_ID", "CHANNEL_ID")
)
2015-08-11 11:37:14,838 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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")
)
2015-08-11 11:37:14,984 INFO [corp-000] [Firebird21SymmetricDialect] [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" 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")
)
2015-08-11 11:37:15,047 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID")
)
2015-08-11 11:37:15,161 INFO [corp-000] [Firebird21SymmetricDialect] [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" INTEGER 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" TIMESTAMP,
    "LAST_RESTART_TIME" TIMESTAMP NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("NODE_ID", "HOST_NAME")
)
2015-08-11 11:37:15,276 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "END_TIME" TIMESTAMP 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-08-11 11:37:15,347 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2015-08-11 11:37:15,472 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "END_TIME" TIMESTAMP NOT NULL,
    "PROCESSED_COUNT" BIGINT DEFAULT 0,
    PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME")
)
2015-08-11 11:37:15,509 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2015-08-11 11:37:15,666 INFO [corp-000] [Firebird21SymmetricDialect] [main] 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" 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-08-11 11:37:15,754 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME")
2015-08-11 11:37:15,870 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"(
    "NODE_ID" VARCHAR(50) NOT NULL,
    PRIMARY KEY ("NODE_ID")
)
2015-08-11 11:37:15,923 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP,
    "INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0,
    "INITIAL_LOAD_TIME" TIMESTAMP,
    "INITIAL_LOAD_ID" BIGINT,
    "INITIAL_LOAD_CREATE_BY" VARCHAR(255),
    "REV_INITIAL_LOAD_ENABLED" SMALLINT DEFAULT 0,
    "REV_INITIAL_LOAD_TIME" TIMESTAMP,
    "REV_INITIAL_LOAD_ID" BIGINT,
    "REV_INITIAL_LOAD_CREATE_BY" VARCHAR(255),
    "CREATED_AT_NODE_ID" VARCHAR(50),
    PRIMARY KEY ("NODE_ID")
)
2015-08-11 11:37:16,075 INFO [corp-000] [Firebird21SymmetricDialect] [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" INTEGER DEFAULT 0 NOT NULL,
    "SQL_MESSAGE" BLOB SUB_TYPE 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" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    "CREATE_BY" VARCHAR(255),
    PRIMARY KEY ("BATCH_ID", "NODE_ID")
)
2015-08-11 11:37:16,142 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS")
2015-08-11 11:37:16,167 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS")
2015-08-11 11:37:16,212 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG")
2015-08-11 11:37:16,268 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_PARAMETER"(
    "EXTERNAL_ID" VARCHAR(50) NOT NULL,
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "PARAM_KEY" VARCHAR(80) NOT NULL,
    "PARAM_VALUE" BLOB SUB_TYPE TEXT,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY")
)
2015-08-11 11:37:16,374 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_REGISTRATION_REDIRECT"(
    "REGISTRANT_EXTERNAL_ID" VARCHAR(50) NOT NULL,
    "REGISTRATION_NODE_ID" VARCHAR(50) NOT NULL,
    PRIMARY KEY ("REGISTRANT_EXTERNAL_ID")
)
2015-08-11 11:37:16,590 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_REGISTRATION_REQUEST"(
    "NODE_GROUP_ID" VARCHAR(50) NOT NULL,
    "EXTERNAL_ID" VARCHAR(50) NOT NULL,
    "STATUS" CHAR(2) NOT NULL,
    "HOST_NAME" VARCHAR(60) NOT NULL,
    "IP_ADDRESS" VARCHAR(50) NOT NULL,
    "ATTEMPT_COUNT" INTEGER DEFAULT 0,
    "REGISTERED_NODE_ID" VARCHAR(50),
    "ERROR_MESSAGE" BLOB SUB_TYPE TEXT,
    "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")
)
2015-08-11 11:37:16,625 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:16,650 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS")
2015-08-11 11:37:16,737 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE 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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("ROUTER_ID")
)
2015-08-11 11:37:16,887 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_SEQUENCE"(
    "SEQUENCE_NAME" VARCHAR(50) NOT NULL,
    "CURRENT_VALUE" BIGINT DEFAULT 0 NOT NULL,
    "INCREMENT_BY" INTEGER DEFAULT 1 NOT NULL,
    "MIN_VALUE" BIGINT DEFAULT 1 NOT NULL,
    "MAX_VALUE" BIGINT DEFAULT 9999999999 NOT NULL,
    "CYCLE" SMALLINT DEFAULT 0,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("SEQUENCE_NAME")
)
2015-08-11 11:37:16,955 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT,
    "RELOAD_DELETE_STMT" BLOB SUB_TYPE TEXT,
    "RELOAD_ENABLED" SMALLINT DEFAULT 0,
    "RELOAD_TIME" TIMESTAMP,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID")
)
2015-08-11 11:37:17,048 INFO [corp-000] [Firebird21SymmetricDialect] [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,
    "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,
    PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID")
)
2015-08-11 11:37:17,157 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT,
    "TRANSFORM_ORDER" INTEGER DEFAULT 1 NOT NULL,
    "CREATE_TIME" TIMESTAMP,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP,
    PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME")
)
2015-08-11 11:37:17,250 INFO [corp-000] [Firebird21SymmetricDialect] [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" BLOB SUB_TYPE TEXT,
    "SYNC_ON_INSERT_CONDITION" BLOB SUB_TYPE TEXT,
    "SYNC_ON_DELETE_CONDITION" BLOB SUB_TYPE TEXT,
    "CUSTOM_ON_UPDATE_TEXT" BLOB SUB_TYPE TEXT,
    "CUSTOM_ON_INSERT_TEXT" BLOB SUB_TYPE TEXT,
    "CUSTOM_ON_DELETE_TEXT" BLOB SUB_TYPE TEXT,
    "EXTERNAL_SELECT" BLOB SUB_TYPE TEXT,
    "TX_ID_EXPRESSION" BLOB SUB_TYPE TEXT,
    "CHANNEL_EXPRESSION" BLOB SUB_TYPE TEXT,
    "EXCLUDED_COLUMN_NAMES" BLOB SUB_TYPE TEXT,
    "SYNC_KEY_NAMES" BLOB SUB_TYPE 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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID")
)
2015-08-11 11:37:17,311 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: CREATE TABLE "SYM_TRIGGER_HIST"(
    "TRIGGER_HIST_ID" INTEGER 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" BLOB SUB_TYPE TEXT NOT NULL,
    "PK_COLUMN_NAMES" BLOB SUB_TYPE TEXT NOT NULL,
    "LAST_TRIGGER_BUILD_REASON" CHAR(1) NOT NULL,
    "ERROR_MESSAGE" BLOB SUB_TYPE TEXT,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "INACTIVE_TIME" TIMESTAMP,
    PRIMARY KEY ("TRIGGER_HIST_ID")
)
2015-08-11 11:37:17,680 INFO [corp-000] [Firebird21SymmetricDialect] [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" INTEGER DEFAULT 1 NOT NULL,
    "INITIAL_LOAD_SELECT" BLOB SUB_TYPE TEXT,
    "INITIAL_LOAD_DELETE_STMT" BLOB SUB_TYPE TEXT,
    "INITIAL_LOAD_BATCH_COUNT" INTEGER DEFAULT 1,
    "PING_BACK_ENABLED" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID")
)
2015-08-11 11:37:17,721 INFO [corp-000] [Firebird21SymmetricDialect] [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" TIMESTAMP NOT NULL,
    "LAST_UPDATE_BY" VARCHAR(50),
    "LAST_UPDATE_TIME" TIMESTAMP NOT NULL,
    PRIMARY KEY ("GROUPLET_ID", "TRIGGER_ID", "ROUTER_ID", "APPLIES_WHEN")
)
2015-08-11 11:37:17,846 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:17,887 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:17,903 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:17,920 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:17,935 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,009 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,040 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,074 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,108 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,123 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,218 INFO [corp-000] [Firebird21SymmetricDialect] [main] DDL applied: ALTER TABLE "SYM_TRIGGER"
    ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID")
2015-08-11 11:37:18,288 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,317 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,339 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,379 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,396 INFO [corp-000] [Firebird21SymmetricDialect] [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-08-11 11:37:18,396 INFO [corp-000] [Firebird21SymmetricDialect] [main] Done with auto update of SymmetricDS tables
2015-08-11 11:37:18,672 INFO [corp-000] [Firebird21SymmetricDialect] [main] Installing SymmetricDS database object:
declare external function sym_hex blob                                                                                                                                                           returns cstring(32660) free_it entry_point 'sym_hex' module_name 'sym_udf'                                                                                             
2015-08-11 12:00:04,867 INFO [] [AbstractCommandLauncher] [main] Option: name=engine, value={corp-000}
2015-08-11 12:00:05,465 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] Detected database 'Firebird 2.56LI-V2.5.4.26856 Firebird 2.5/tcp (host4.webdts.eu)/P10', version '2', protocol 'firebirdsql'
2015-08-11 12:00:05,481 INFO [corp-000] [JdbcDatabasePlatformFactory] [main] The IDatabasePlatform being used is org.jumpmind.db.platform.firebird.FirebirdDatabasePlatform
2015-08-11 12:00:05,955 INFO [corp-000] [Firebird21SymmetricDialect] [main] The DbDialect being used is org.jumpmind.symmetric.db.firebird.Firebird21SymmetricDialect
2015-08-11 12:00:06,212 INFO [corp-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2015-08-11 12:00:06,224 INFO [corp-000] [StagingManager] [main] The staging directory was initialized at the following location: /web/symmetric-server-3.7.19/tmp/corp-000
2015-08-11 12:00:06,363 INFO [corp-000] [ClusterService] [main] This node picked a server id of host4.webdts.eu
2015-08-11 12:00:07,465 INFO [corp-000] [ExtensionService] [main] Found 0 extension points from the database that will be registered
2015-08-11 12:00:07,465 INFO [corp-000] [ClientExtensionService] [main] Found 8 extension points from spring that will be registered
2015-08-11 12:00:07,467 INFO [corp-000] [AbstractSymmetricEngine] [main] Initializing SymmetricDS database
2015-08-11 12:00:07,467 INFO [corp-000] [Firebird21SymmetricDialect] [main] Checking if SymmetricDS tables need created or altered
2015-08-11 12:00:10,232 INFO [corp-000] [Firebird21SymmetricDialect] [main] Installing SymmetricDS database object:
declare external function sym_hex blob                                                                                                                                                           returns cstring(32660) free_it entry_point 'sym_hex' module_name 'sym_udf'                                                                                             
symmetric.log (85,191 bytes)   

elong

2019-04-23 19:25

developer   ~0001424

Did you follow the Firebird notes to copy the sym_udf file to the server?

https://www.symmetricds.org/doc/3.10/html/user-guide.html#_firebird

The logs you attached look clean. I don't see that error in the logs. We test on Firebird 2.5, and can't reproduce this.

admin

2019-08-26 12:45

administrator   ~0001589

Auto closing all issues waiting for feedback after 4 months. We don't have enough information to take any action.

Issue History

Date Modified Username Field Change
2015-08-11 12:53 steffenb New Issue
2015-08-11 12:53 steffenb File Added: symmetric.log
2019-04-23 19:25 elong Assigned To => elong
2019-04-23 19:25 elong Status new => feedback
2019-04-23 19:25 elong Note Added: 0001424
2019-04-23 19:25 elong Assigned To elong =>
2019-08-26 12:45 admin Note Added: 0001589
2019-08-26 12:45 admin Status feedback => closed