2021-09-19 19:16:18,487 INFO  (sync.starter) [org.jumpmind.symmetric.AbstractSymmetricEngine] Initializing SymmetricDS database
2021-09-19 19:16:18,532 INFO  (sync.starter) [za.sq.dbservice.sync.SyncEngine$DerbySymmetricDialectEx] Checking if SymmetricDS tables need created or altered
2021-09-19 19:16:19,028 INFO  (sync.starter) [za.sq.dbservice.sync.SyncEngine$DerbySymmetricDialectEx] There are SymmetricDS tables that needed altered
2021-09-19 19:16:19,034 INFO  (sync.starter) [za.sq.dbservice.sync.SyncEngine$DerbySymmetricDialectEx] DDL failed: DROP TABLE "JJZCK79K"."SYM_DATA_"
2021-09-19 19:16:19,105 INFO  (sync.starter) [za.sq.dbservice.sync.SyncEngine$DerbySymmetricDialectEx] DDL applied: CREATE TABLE "JJZCK79K"."SYM_DATA_"(
    "DATA_ID" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "TABLE_NAME" VARCHAR(255) NOT NULL,
    "EVENT_TYPE" CHAR(1) NOT NULL,
    "PK_DATA" LONG VARCHAR,
    "OLD_DATA" LONG VARCHAR,
    "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),
    "IS_PREROUTED" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP,
    "ROW_DATA" CLOB,
    PRIMARY KEY ("DATA_ID")
)
2021-09-19 19:16:19,149 INFO  (sync.starter) [za.sq.dbservice.sync.SyncEngine$DerbySymmetricDialectEx] DDL applied: INSERT INTO "JJZCK79K"."SYM_DATA_" ("DATA_ID","TABLE_NAME","EVENT_TYPE","PK_DATA","OLD_DATA","TRIGGER_HIST_ID","CHANNEL_ID","TRANSACTION_ID","SOURCE_NODE_ID","EXTERNAL_DATA","NODE_LIST","IS_PREROUTED","CREATE_TIME","ROW_DATA") SELECT "DATA_ID","TABLE_NAME","EVENT_TYPE","PK_DATA","OLD_DATA","TRIGGER_HIST_ID","CHANNEL_ID","TRANSACTION_ID","SOURCE_NODE_ID","EXTERNAL_DATA","NODE_LIST","IS_PREROUTED","CREATE_TIME","ROW_DATA" FROM "JJZCK79K"."SYM_DATA"
2021-09-19 19:16:19,182 INFO  (sync.starter) [za.sq.dbservice.sync.SyncEngine$DerbySymmetricDialectEx] DDL applied: DROP TABLE "JJZCK79K"."SYM_DATA"
2021-09-19 19:16:19,190 INFO  (sync.starter) [za.sq.dbservice.sync.SyncEngine$DerbySymmetricDialectEx] DDL applied: CREATE TABLE "SYM_DATA"(
    "DATA_ID" BIGINT NOT NULL GENERATED BY DEFAULT AS IDENTITY,
    "TABLE_NAME" VARCHAR(255) NOT NULL,
    "EVENT_TYPE" CHAR(1) NOT NULL,
    "ROW_DATA" LONG VARCHAR,
    "PK_DATA" LONG VARCHAR,
    "OLD_DATA" LONG VARCHAR,
    "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),
    "IS_PREROUTED" SMALLINT DEFAULT 0 NOT NULL,
    "CREATE_TIME" TIMESTAMP,
    PRIMARY KEY ("DATA_ID")
)
2021-09-19 19:16:19,195 INFO  (sync.starter) [za.sq.dbservice.sync.SyncEngine$DerbySymmetricDialectEx] DDL applied: CREATE UNIQUE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID")
2021-09-19 19:16:19,198 WARN  (sync.starter) [za.sq.dbservice.sync.SyncEngine$DerbySymmetricDialectEx] DDL failed: INSERT INTO "SYM_DATA" ("DATA_ID","TABLE_NAME","EVENT_TYPE","PK_DATA","OLD_DATA","TRIGGER_HIST_ID","CHANNEL_ID","TRANSACTION_ID","SOURCE_NODE_ID","EXTERNAL_DATA","NODE_LIST","IS_PREROUTED","CREATE_TIME","ROW_DATA") SELECT "DATA_ID","TABLE_NAME","EVENT_TYPE","PK_DATA","OLD_DATA","TRIGGER_HIST_ID","CHANNEL_ID","TRANSACTION_ID","SOURCE_NODE_ID","EXTERNAL_DATA","NODE_LIST","IS_PREROUTED","CREATE_TIME",LONG VARCHAR("ROW_DATA") FROM "JJZCK79K"."SYM_DATA_"
2021-09-19 19:16:19,198 WARN  (sync.starter) [org.jumpmind.db.sql.JdbcSqlTemplate] Syntax error: Encountered "VARCHAR" at line 1, column 407..  Failed to execute: INSERT INTO "SYM_DATA" ("DATA_ID","TABLE_NAME","EVENT_TYPE","PK_DATA","OLD_DATA","TRIGGER_HIST_ID","CHANNEL_ID","TRANSACTION_ID","SOURCE_NODE_ID","EXTERNAL_DATA","NODE_LIST","IS_PREROUTED","CREATE_TIME","ROW_DATA") SELECT "DATA_ID","TABLE_NAME","EVENT_TYPE","PK_DATA","OLD_DATA","TRIGGER_HIST_ID","CHANNEL_ID","TRANSACTION_ID","SOURCE_NODE_ID","EXTERNAL_DATA","NODE_LIST","IS_PREROUTED","CREATE_TIME",LONG VARCHAR("ROW_DATA") FROM "JJZCK79K"."SYM_DATA_"