{"@timestamp":"2018-02-06T18:52:49.145Z","source_host":"usmvvjairath.infor.com","file":"ClientSymmetricEngine.java","method":"createDatabasePlatform","level":"INFO","line_number":"288","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.AbstractSymmetricEngine","message":"Initializing connection to database","class":"org.jumpmind.symmetric.ClientSymmetricEngine","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:50.614Z","source_host":"usmvvjairath.infor.com","file":"JdbcDatabasePlatformFactory.java","method":"determineDatabaseNameVersionSubprotocol","level":"INFO","line_number":"266","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.db.platform.JdbcDatabasePlatformFactory","message":"Detected database 'H2', version '1', protocol 'h2'","class":"org.jumpmind.db.platform.JdbcDatabasePlatformFactory","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:50.638Z","source_host":"usmvvjairath.infor.com","file":"JdbcDatabasePlatformFactory.java","method":"createNewPlatformInstance","level":"INFO","line_number":"172","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.db.platform.JdbcDatabasePlatformFactory","message":"The IDatabasePlatform being used is org.jumpmind.db.platform.h2.H2DatabasePlatform","class":"org.jumpmind.db.platform.JdbcDatabasePlatformFactory","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:50.762Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricDialect.java","method":"","level":"INFO","line_number":"117","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"The DbDialect being used is org.jumpmind.symmetric.db.h2.H2SymmetricDialect","class":"org.jumpmind.symmetric.db.AbstractSymmetricDialect","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:50.790Z","source_host":"usmvvjairath.infor.com","file":"StagingManager.java","method":"","level":"INFO","line_number":"55","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.io.stage.StagingManager","message":"The staging directory was initialized at the following location: \/Users\/vjairath\/devtools\/apache-tomcat-7.0.75\/temp\/SymmetricDS","class":"org.jumpmind.symmetric.io.stage.StagingManager","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:50.842Z","source_host":"usmvvjairath.infor.com","file":"ClusterService.java","method":"getServerId","level":"INFO","line_number":"350","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.service.impl.ClusterService","message":"This node picked a server id of usmvvjairath.infor.com","class":"org.jumpmind.symmetric.service.impl.ClusterService","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:50.903Z","source_host":"usmvvjairath.infor.com","file":"NodeService.java","method":"findIdentity","level":"INFO","line_number":"362","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.service.impl.NodeService","message":"Failed to load the node identity because: org.jumpmind.db.sql.SqlException Failed to execute sql: select c.node_id, c.node_group_id, c.external_id, c.sync_enabled, c.sync_url, c.schema_version, c.database_type, c.database_version, c.symmetric_version, c.created_at_node_id, c.heartbeat_time, c.timezone_offset, c.batch_to_send_count, c.batch_in_error_count, c.deployment_type, c.config_version from sym_node c inner join sym_node_identity i on c.node_id = i.node_id . Returning null","class":"org.jumpmind.symmetric.service.impl.NodeService","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.384Z","source_host":"usmvvjairath.infor.com","file":"ClientExtensionService.java","method":"refresh","level":"INFO","line_number":"57","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.service.impl.ClientExtensionService","message":"Found 13 extension points from spring that will be registered","class":"org.jumpmind.symmetric.service.impl.ClientExtensionService","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.423Z","source_host":"usmvvjairath.infor.com","file":"ExtensionService.java","method":"registerExtension","level":"INFO","line_number":"148","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.service.impl.ExtensionService","message":"Registering extension named 'extractTimestamp' of type 'ISingleNewAndOldValueColumnTransform'","class":"org.jumpmind.symmetric.service.impl.ExtensionService","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.424Z","source_host":"usmvvjairath.infor.com","file":"ExtensionService.java","method":"registerExtension","level":"INFO","line_number":"148","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.service.impl.ExtensionService","message":"Registering extension named 'extractTimestamp' of type 'IColumnTransform'","class":"org.jumpmind.symmetric.service.impl.ExtensionService","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.424Z","source_host":"usmvvjairath.infor.com","file":"ExtensionService.java","method":"registerExtension","level":"INFO","line_number":"148","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.service.impl.ExtensionService","message":"Registering extension named 'loadTimestamp' of type 'ISingleNewAndOldValueColumnTransform'","class":"org.jumpmind.symmetric.service.impl.ExtensionService","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.424Z","source_host":"usmvvjairath.infor.com","file":"ExtensionService.java","method":"registerExtension","level":"INFO","line_number":"148","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.service.impl.ExtensionService","message":"Registering extension named 'loadTimestamp' of type 'IColumnTransform'","class":"org.jumpmind.symmetric.service.impl.ExtensionService","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.436Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricEngine.java","method":"setupDatabase","level":"INFO","line_number":"451","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.AbstractSymmetricEngine","message":"Initializing SymmetricDS database","class":"org.jumpmind.symmetric.AbstractSymmetricEngine","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.437Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricDialect.java","method":"createOrAlterTablesIfNecessary","level":"INFO","line_number":"483","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"Checking if SymmetricDS tables need created or altered","class":"org.jumpmind.symmetric.db.AbstractSymmetricDialect","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.621Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricDialect.java","method":"createOrAlterTablesIfNecessary","level":"INFO","line_number":"519","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"There are SymmetricDS tables that needed altered","class":"org.jumpmind.symmetric.db.AbstractSymmetricDialect","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.634Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_CHANNEL(\n CHANNEL_ID VARCHAR(128) NOT NULL,\n PROCESSING_ORDER INTEGER DEFAULT 1 NOT NULL,\n MAX_BATCH_SIZE INTEGER DEFAULT 1000 NOT NULL,\n MAX_BATCH_TO_SEND INTEGER DEFAULT 60 NOT NULL,\n MAX_DATA_TO_ROUTE INTEGER DEFAULT 100000 NOT NULL,\n EXTRACT_PERIOD_MILLIS INTEGER DEFAULT 0 NOT NULL,\n ENABLED TINYINT DEFAULT 1 NOT NULL,\n USE_OLD_DATA_TO_ROUTE TINYINT DEFAULT 1 NOT NULL,\n USE_ROW_DATA_TO_ROUTE TINYINT DEFAULT 1 NOT NULL,\n USE_PK_DATA_TO_ROUTE TINYINT DEFAULT 1 NOT NULL,\n RELOAD_FLAG TINYINT DEFAULT 0 NOT NULL,\n FILE_SYNC_FLAG TINYINT DEFAULT 0 NOT NULL,\n CONTAINS_BIG_LOB TINYINT DEFAULT 0 NOT NULL,\n BATCH_ALGORITHM VARCHAR(50) DEFAULT 'default' NOT NULL,\n DATA_LOADER_TYPE VARCHAR(50) DEFAULT 'default' NOT NULL,\n DESCRIPTION VARCHAR(255) NULL,\n QUEUE VARCHAR(25) DEFAULT 'default' NOT NULL,\n MAX_NETWORK_KBPS DECIMAL(10,3) DEFAULT 0.000 NOT NULL,\n DATA_EVENT_ACTION CHAR(1) NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (CHANNEL_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.638Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_CONFLICT(\n CONFLICT_ID VARCHAR(50) NOT NULL,\n SOURCE_NODE_GROUP_ID VARCHAR(50) NOT NULL,\n TARGET_NODE_GROUP_ID VARCHAR(50) NOT NULL,\n TARGET_CHANNEL_ID VARCHAR(128) NULL,\n TARGET_CATALOG_NAME VARCHAR(255) NULL,\n TARGET_SCHEMA_NAME VARCHAR(255) NULL,\n TARGET_TABLE_NAME VARCHAR(255) NULL,\n DETECT_TYPE VARCHAR(128) NOT NULL,\n DETECT_EXPRESSION VARCHAR(2147483647) NULL,\n RESOLVE_TYPE VARCHAR(128) NOT NULL,\n PING_BACK VARCHAR(128) NOT NULL,\n RESOLVE_CHANGES_ONLY TINYINT DEFAULT 0,\n RESOLVE_ROW_ONLY TINYINT DEFAULT 0,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (CONFLICT_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.639Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_CONTEXT(\n NAME VARCHAR(80) NOT NULL,\n CONTEXT_VALUE VARCHAR(2147483647) NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (NAME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.644Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_DATA(\n DATA_ID BIGINT NOT NULL AUTO_INCREMENT,\n TABLE_NAME VARCHAR(255) NOT NULL,\n EVENT_TYPE CHAR(1) NOT NULL,\n ROW_DATA VARCHAR(2147483647) NULL,\n PK_DATA VARCHAR(2147483647) NULL,\n OLD_DATA VARCHAR(2147483647) NULL,\n TRIGGER_HIST_ID INTEGER NOT NULL,\n CHANNEL_ID VARCHAR(128) NULL,\n TRANSACTION_ID VARCHAR(255) NULL,\n SOURCE_NODE_ID VARCHAR(50) NULL,\n EXTERNAL_DATA VARCHAR(50) NULL,\n NODE_LIST VARCHAR(255) NULL,\n CREATE_TIME TIMESTAMP,\n PRIMARY KEY (DATA_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.645Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_D_CHANNEL_ID ON SYM_DATA (DATA_ID, CHANNEL_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.647Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_DATA_EVENT(\n DATA_ID BIGINT NOT NULL,\n BATCH_ID BIGINT NOT NULL,\n ROUTER_ID VARCHAR(50) NOT NULL,\n CREATE_TIME TIMESTAMP,\n PRIMARY KEY (DATA_ID, BATCH_ID, ROUTER_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.647Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_DE_BATCHID ON SYM_DATA_EVENT (BATCH_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.649Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_DATA_GAP(\n START_ID BIGINT NOT NULL,\n END_ID BIGINT NOT NULL,\n STATUS CHAR(2) NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_HOSTNAME VARCHAR(255) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (START_ID, END_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.649Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_DG_STATUS ON SYM_DATA_GAP (STATUS)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.651Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_EXTENSION(\n EXTENSION_ID VARCHAR(50) NOT NULL,\n EXTENSION_TYPE VARCHAR(10) NOT NULL,\n INTERFACE_NAME VARCHAR(255) NULL,\n NODE_GROUP_ID VARCHAR(50) NOT NULL,\n ENABLED TINYINT DEFAULT 1 NOT NULL,\n EXTENSION_ORDER INTEGER DEFAULT 1 NOT NULL,\n EXTENSION_TEXT VARCHAR(2147483647) NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (EXTENSION_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.652Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_EXTRACT_REQUEST(\n REQUEST_ID BIGINT NOT NULL,\n NODE_ID VARCHAR(50) NOT NULL,\n QUEUE VARCHAR(128) NULL,\n STATUS CHAR(2) NULL,\n START_BATCH_ID BIGINT NOT NULL,\n END_BATCH_ID BIGINT NOT NULL,\n TRIGGER_ID VARCHAR(128) NOT NULL,\n ROUTER_ID VARCHAR(50) NOT NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n CREATE_TIME TIMESTAMP,\n PRIMARY KEY (REQUEST_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.653Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_FILE_INCOMING(\n RELATIVE_DIR VARCHAR(255) NOT NULL,\n FILE_NAME VARCHAR(128) NOT NULL,\n LAST_EVENT_TYPE CHAR(1) NOT NULL,\n NODE_ID VARCHAR(50) NOT NULL,\n FILE_MODIFIED_TIME BIGINT,\n PRIMARY KEY (RELATIVE_DIR, FILE_NAME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.655Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_FILE_SNAPSHOT(\n TRIGGER_ID VARCHAR(128) NOT NULL,\n ROUTER_ID VARCHAR(50) NOT NULL,\n RELATIVE_DIR VARCHAR(255) NOT NULL,\n FILE_NAME VARCHAR(128) NOT NULL,\n CHANNEL_ID VARCHAR(128) DEFAULT 'filesync' NOT NULL,\n RELOAD_CHANNEL_ID VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,\n LAST_EVENT_TYPE CHAR(1) NOT NULL,\n CRC32_CHECKSUM BIGINT,\n FILE_SIZE BIGINT,\n FILE_MODIFIED_TIME BIGINT,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (TRIGGER_ID, ROUTER_ID, RELATIVE_DIR, FILE_NAME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.656Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_F_SNPSHT_CHID ON SYM_FILE_SNAPSHOT (RELOAD_CHANNEL_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.658Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_FILE_TRIGGER(\n TRIGGER_ID VARCHAR(128) NOT NULL,\n CHANNEL_ID VARCHAR(128) DEFAULT 'filesync' NOT NULL,\n RELOAD_CHANNEL_ID VARCHAR(128) DEFAULT 'filesync_reload' NOT NULL,\n BASE_DIR VARCHAR(255) NOT NULL,\n RECURSE TINYINT DEFAULT 1 NOT NULL,\n INCLUDES_FILES VARCHAR(255) NULL,\n EXCLUDES_FILES VARCHAR(255) NULL,\n SYNC_ON_CREATE TINYINT DEFAULT 1 NOT NULL,\n SYNC_ON_MODIFIED TINYINT DEFAULT 1 NOT NULL,\n SYNC_ON_DELETE TINYINT DEFAULT 1 NOT NULL,\n SYNC_ON_CTL_FILE TINYINT DEFAULT 0 NOT NULL,\n DELETE_AFTER_SYNC TINYINT DEFAULT 0 NOT NULL,\n BEFORE_COPY_SCRIPT VARCHAR(2147483647) NULL,\n AFTER_COPY_SCRIPT VARCHAR(2147483647) NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (TRIGGER_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.660Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_FILE_TRIGGER_ROUTER(\n TRIGGER_ID VARCHAR(128) NOT NULL,\n ROUTER_ID VARCHAR(50) NOT NULL,\n ENABLED TINYINT DEFAULT 1 NOT NULL,\n INITIAL_LOAD_ENABLED TINYINT DEFAULT 1 NOT NULL,\n TARGET_BASE_DIR VARCHAR(255) NULL,\n CONFLICT_STRATEGY VARCHAR(128) DEFAULT 'source_wins' NOT NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (TRIGGER_ID, ROUTER_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.661Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_GROUPLET(\n GROUPLET_ID VARCHAR(50) NOT NULL,\n GROUPLET_LINK_POLICY CHAR(1) DEFAULT 'I' NOT NULL,\n DESCRIPTION VARCHAR(255) NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (GROUPLET_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.663Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_GROUPLET_LINK(\n GROUPLET_ID VARCHAR(50) NOT NULL,\n EXTERNAL_ID VARCHAR(255) NOT NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (GROUPLET_ID, EXTERNAL_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.665Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_INCOMING_BATCH(\n BATCH_ID BIGINT NOT NULL,\n NODE_ID VARCHAR(50) NOT NULL,\n CHANNEL_ID VARCHAR(128) NULL,\n STATUS CHAR(2) NULL,\n ERROR_FLAG TINYINT DEFAULT 0,\n NETWORK_MILLIS BIGINT DEFAULT 0 NOT NULL,\n FILTER_MILLIS BIGINT DEFAULT 0 NOT NULL,\n DATABASE_MILLIS BIGINT DEFAULT 0 NOT NULL,\n FAILED_ROW_NUMBER BIGINT DEFAULT 0 NOT NULL,\n FAILED_LINE_NUMBER BIGINT DEFAULT 0 NOT NULL,\n BYTE_COUNT BIGINT DEFAULT 0 NOT NULL,\n STATEMENT_COUNT BIGINT DEFAULT 0 NOT NULL,\n FALLBACK_INSERT_COUNT BIGINT DEFAULT 0 NOT NULL,\n FALLBACK_UPDATE_COUNT BIGINT DEFAULT 0 NOT NULL,\n IGNORE_COUNT BIGINT DEFAULT 0 NOT NULL,\n IGNORE_ROW_COUNT BIGINT DEFAULT 0 NOT NULL,\n MISSING_DELETE_COUNT BIGINT DEFAULT 0 NOT NULL,\n SKIP_COUNT BIGINT DEFAULT 0 NOT NULL,\n SQL_STATE VARCHAR(10) NULL,\n SQL_CODE INTEGER DEFAULT 0 NOT NULL,\n SQL_MESSAGE VARCHAR(2147483647) NULL,\n LAST_UPDATE_HOSTNAME VARCHAR(255) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n CREATE_TIME TIMESTAMP,\n SUMMARY VARCHAR(255) NULL,\n PRIMARY KEY (BATCH_ID, NODE_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.666Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_IB_TIME_STATUS ON SYM_INCOMING_BATCH (CREATE_TIME, STATUS)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.667Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_IB_IN_ERROR ON SYM_INCOMING_BATCH (ERROR_FLAG)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.668Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_INCOMING_ERROR(\n BATCH_ID BIGINT NOT NULL,\n NODE_ID VARCHAR(50) NOT NULL,\n FAILED_ROW_NUMBER BIGINT NOT NULL,\n FAILED_LINE_NUMBER BIGINT DEFAULT 0 NOT NULL,\n TARGET_CATALOG_NAME VARCHAR(255) NULL,\n TARGET_SCHEMA_NAME VARCHAR(255) NULL,\n TARGET_TABLE_NAME VARCHAR(255) NOT NULL,\n EVENT_TYPE CHAR(1) NOT NULL,\n BINARY_ENCODING VARCHAR(10) DEFAULT 'HEX' NOT NULL,\n COLUMN_NAMES VARCHAR(2147483647) NOT NULL,\n PK_COLUMN_NAMES VARCHAR(2147483647) NOT NULL,\n ROW_DATA VARCHAR(2147483647) NULL,\n OLD_DATA VARCHAR(2147483647) NULL,\n CUR_DATA VARCHAR(2147483647) NULL,\n RESOLVE_DATA VARCHAR(2147483647) NULL,\n RESOLVE_IGNORE TINYINT DEFAULT 0,\n CONFLICT_ID VARCHAR(50) NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (BATCH_ID, NODE_ID, FAILED_ROW_NUMBER)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.670Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_LOAD_FILTER(\n LOAD_FILTER_ID VARCHAR(50) NOT NULL,\n LOAD_FILTER_TYPE VARCHAR(10) NOT NULL,\n SOURCE_NODE_GROUP_ID VARCHAR(50) NOT NULL,\n TARGET_NODE_GROUP_ID VARCHAR(50) NOT NULL,\n TARGET_CATALOG_NAME VARCHAR(255) NULL,\n TARGET_SCHEMA_NAME VARCHAR(255) NULL,\n TARGET_TABLE_NAME VARCHAR(255) NULL,\n FILTER_ON_UPDATE TINYINT DEFAULT 1 NOT NULL,\n FILTER_ON_INSERT TINYINT DEFAULT 1 NOT NULL,\n FILTER_ON_DELETE TINYINT DEFAULT 1 NOT NULL,\n BEFORE_WRITE_SCRIPT VARCHAR(2147483647) NULL,\n AFTER_WRITE_SCRIPT VARCHAR(2147483647) NULL,\n BATCH_COMPLETE_SCRIPT VARCHAR(2147483647) NULL,\n BATCH_COMMIT_SCRIPT VARCHAR(2147483647) NULL,\n BATCH_ROLLBACK_SCRIPT VARCHAR(2147483647) NULL,\n HANDLE_ERROR_SCRIPT VARCHAR(2147483647) NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n LOAD_FILTER_ORDER INTEGER DEFAULT 1 NOT NULL,\n FAIL_ON_ERROR TINYINT DEFAULT 0 NOT NULL,\n PRIMARY KEY (LOAD_FILTER_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.672Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_LOCK(\n LOCK_ACTION VARCHAR(50) NOT NULL,\n LOCK_TYPE VARCHAR(50) NOT NULL,\n LOCKING_SERVER_ID VARCHAR(255) NULL,\n LOCK_TIME TIMESTAMP,\n SHARED_COUNT INTEGER DEFAULT 0 NOT NULL,\n SHARED_ENABLE INTEGER DEFAULT 0 NOT NULL,\n LAST_LOCK_TIME TIMESTAMP,\n LAST_LOCKING_SERVER_ID VARCHAR(255) NULL,\n PRIMARY KEY (LOCK_ACTION)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.674Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE(\n NODE_ID VARCHAR(50) NOT NULL,\n NODE_GROUP_ID VARCHAR(50) NOT NULL,\n EXTERNAL_ID VARCHAR(255) NOT NULL,\n SYNC_ENABLED TINYINT DEFAULT 0,\n SYNC_URL VARCHAR(255) NULL,\n SCHEMA_VERSION VARCHAR(50) NULL,\n SYMMETRIC_VERSION VARCHAR(50) NULL,\n CONFIG_VERSION VARCHAR(50) NULL,\n DATABASE_TYPE VARCHAR(50) NULL,\n DATABASE_VERSION VARCHAR(50) NULL,\n HEARTBEAT_TIME TIMESTAMP,\n TIMEZONE_OFFSET VARCHAR(6) NULL,\n BATCH_TO_SEND_COUNT INTEGER DEFAULT 0,\n BATCH_IN_ERROR_COUNT INTEGER DEFAULT 0,\n CREATED_AT_NODE_ID VARCHAR(50) NULL,\n DEPLOYMENT_TYPE VARCHAR(50) NULL,\n PRIMARY KEY (NODE_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.675Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_COMMUNICATION(\n NODE_ID VARCHAR(50) NOT NULL,\n QUEUE VARCHAR(25) NOT NULL,\n COMMUNICATION_TYPE VARCHAR(10) NOT NULL,\n LOCK_TIME TIMESTAMP,\n LOCKING_SERVER_ID VARCHAR(255) NULL,\n LAST_LOCK_TIME TIMESTAMP,\n LAST_LOCK_MILLIS BIGINT DEFAULT 0,\n SUCCESS_COUNT BIGINT DEFAULT 0,\n FAIL_COUNT BIGINT DEFAULT 0,\n SKIP_COUNT BIGINT DEFAULT 0,\n TOTAL_SUCCESS_COUNT BIGINT DEFAULT 0,\n TOTAL_FAIL_COUNT BIGINT DEFAULT 0,\n TOTAL_SUCCESS_MILLIS BIGINT DEFAULT 0,\n TOTAL_FAIL_MILLIS BIGINT DEFAULT 0,\n BATCH_TO_SEND_COUNT BIGINT DEFAULT 0,\n NODE_PRIORITY INTEGER DEFAULT 0,\n PRIMARY KEY (NODE_ID, QUEUE, COMMUNICATION_TYPE)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.677Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_CHANNEL_CTL(\n NODE_ID VARCHAR(50) NOT NULL,\n CHANNEL_ID VARCHAR(128) NOT NULL,\n SUSPEND_ENABLED TINYINT DEFAULT 0,\n IGNORE_ENABLED TINYINT DEFAULT 0,\n LAST_EXTRACT_TIME TIMESTAMP,\n PRIMARY KEY (NODE_ID, CHANNEL_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.678Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_GROUP(\n NODE_GROUP_ID VARCHAR(50) NOT NULL,\n DESCRIPTION VARCHAR(255) NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (NODE_GROUP_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.679Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_GROUP_CHANNEL_WND(\n NODE_GROUP_ID VARCHAR(50) NOT NULL,\n CHANNEL_ID VARCHAR(128) NOT NULL,\n START_TIME TIMESTAMP NOT NULL,\n END_TIME TIMESTAMP NOT NULL,\n ENABLED TINYINT DEFAULT 0 NOT NULL,\n PRIMARY KEY (NODE_GROUP_ID, CHANNEL_ID, START_TIME, END_TIME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.680Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_GROUP_LINK(\n SOURCE_NODE_GROUP_ID VARCHAR(50) NOT NULL,\n TARGET_NODE_GROUP_ID VARCHAR(50) NOT NULL,\n DATA_EVENT_ACTION CHAR(1) DEFAULT 'W' NOT NULL,\n SYNC_CONFIG_ENABLED TINYINT DEFAULT 1 NOT NULL,\n IS_REVERSIBLE TINYINT DEFAULT 0 NOT NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.682Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_HOST(\n NODE_ID VARCHAR(50) NOT NULL,\n HOST_NAME VARCHAR(60) NOT NULL,\n IP_ADDRESS VARCHAR(50) NULL,\n OS_USER VARCHAR(50) NULL,\n OS_NAME VARCHAR(50) NULL,\n OS_ARCH VARCHAR(50) NULL,\n OS_VERSION VARCHAR(50) NULL,\n AVAILABLE_PROCESSORS INTEGER DEFAULT 0,\n FREE_MEMORY_BYTES BIGINT DEFAULT 0,\n TOTAL_MEMORY_BYTES BIGINT DEFAULT 0,\n MAX_MEMORY_BYTES BIGINT DEFAULT 0,\n JAVA_VERSION VARCHAR(50) NULL,\n JAVA_VENDOR VARCHAR(255) NULL,\n JDBC_VERSION VARCHAR(255) NULL,\n SYMMETRIC_VERSION VARCHAR(50) NULL,\n TIMEZONE_OFFSET VARCHAR(6) NULL,\n HEARTBEAT_TIME TIMESTAMP,\n LAST_RESTART_TIME TIMESTAMP NOT NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (NODE_ID, HOST_NAME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.683Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_HOST_CHANNEL_STATS(\n NODE_ID VARCHAR(50) NOT NULL,\n HOST_NAME VARCHAR(60) NOT NULL,\n CHANNEL_ID VARCHAR(128) NOT NULL,\n START_TIME TIMESTAMP NOT NULL,\n END_TIME TIMESTAMP NOT NULL,\n DATA_ROUTED BIGINT DEFAULT 0,\n DATA_UNROUTED BIGINT DEFAULT 0,\n DATA_EVENT_INSERTED BIGINT DEFAULT 0,\n DATA_EXTRACTED BIGINT DEFAULT 0,\n DATA_BYTES_EXTRACTED BIGINT DEFAULT 0,\n DATA_EXTRACTED_ERRORS BIGINT DEFAULT 0,\n DATA_BYTES_SENT BIGINT DEFAULT 0,\n DATA_SENT BIGINT DEFAULT 0,\n DATA_SENT_ERRORS BIGINT DEFAULT 0,\n DATA_LOADED BIGINT DEFAULT 0,\n DATA_BYTES_LOADED BIGINT DEFAULT 0,\n DATA_LOADED_ERRORS BIGINT DEFAULT 0,\n PRIMARY KEY (NODE_ID, HOST_NAME, CHANNEL_ID, START_TIME, END_TIME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.684Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_ND_HST_CHNL_STS ON SYM_NODE_HOST_CHANNEL_STATS (NODE_ID, START_TIME, END_TIME)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.685Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_HOST_JOB_STATS(\n NODE_ID VARCHAR(50) NOT NULL,\n HOST_NAME VARCHAR(60) NOT NULL,\n JOB_NAME VARCHAR(50) NOT NULL,\n START_TIME TIMESTAMP NOT NULL,\n END_TIME TIMESTAMP NOT NULL,\n PROCESSED_COUNT BIGINT DEFAULT 0,\n PRIMARY KEY (NODE_ID, HOST_NAME, JOB_NAME, START_TIME, END_TIME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.686Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_ND_HST_JOB ON SYM_NODE_HOST_JOB_STATS (NODE_ID, START_TIME, END_TIME)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.688Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_HOST_STATS(\n NODE_ID VARCHAR(50) NOT NULL,\n HOST_NAME VARCHAR(60) NOT NULL,\n START_TIME TIMESTAMP NOT NULL,\n END_TIME TIMESTAMP NOT NULL,\n RESTARTED BIGINT DEFAULT 0 NOT NULL,\n NODES_PULLED BIGINT DEFAULT 0,\n TOTAL_NODES_PULL_TIME BIGINT DEFAULT 0,\n NODES_PUSHED BIGINT DEFAULT 0,\n TOTAL_NODES_PUSH_TIME BIGINT DEFAULT 0,\n NODES_REJECTED BIGINT DEFAULT 0,\n NODES_REGISTERED BIGINT DEFAULT 0,\n NODES_LOADED BIGINT DEFAULT 0,\n NODES_DISABLED BIGINT DEFAULT 0,\n PURGED_DATA_ROWS BIGINT DEFAULT 0,\n PURGED_DATA_EVENT_ROWS BIGINT DEFAULT 0,\n PURGED_BATCH_OUTGOING_ROWS BIGINT DEFAULT 0,\n PURGED_BATCH_INCOMING_ROWS BIGINT DEFAULT 0,\n TRIGGERS_CREATED_COUNT BIGINT,\n TRIGGERS_REBUILT_COUNT BIGINT,\n TRIGGERS_REMOVED_COUNT BIGINT,\n PRIMARY KEY (NODE_ID, HOST_NAME, START_TIME, END_TIME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.689Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_ND_HST_STS ON SYM_NODE_HOST_STATS (NODE_ID, START_TIME, END_TIME)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.690Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_IDENTITY(\n NODE_ID VARCHAR(50) NOT NULL,\n PRIMARY KEY (NODE_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.691Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NODE_SECURITY(\n NODE_ID VARCHAR(50) NOT NULL,\n NODE_PASSWORD VARCHAR(50) NOT NULL,\n REGISTRATION_ENABLED TINYINT DEFAULT 0,\n REGISTRATION_TIME TIMESTAMP,\n INITIAL_LOAD_ENABLED TINYINT DEFAULT 0,\n INITIAL_LOAD_TIME TIMESTAMP,\n INITIAL_LOAD_ID BIGINT,\n INITIAL_LOAD_CREATE_BY VARCHAR(255) NULL,\n REV_INITIAL_LOAD_ENABLED TINYINT DEFAULT 0,\n REV_INITIAL_LOAD_TIME TIMESTAMP,\n REV_INITIAL_LOAD_ID BIGINT,\n REV_INITIAL_LOAD_CREATE_BY VARCHAR(255) NULL,\n CREATED_AT_NODE_ID VARCHAR(50) NULL,\n PRIMARY KEY (NODE_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.693Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_MONITOR(\n MONITOR_ID VARCHAR(128) NOT NULL,\n NODE_GROUP_ID VARCHAR(50) DEFAULT 'ALL' NOT NULL,\n EXTERNAL_ID VARCHAR(255) DEFAULT 'ALL' NOT NULL,\n TYPE VARCHAR(50) NOT NULL,\n EXPRESSION VARCHAR(2147483647) NULL,\n THRESHOLD BIGINT DEFAULT 0 NOT NULL,\n RUN_PERIOD INTEGER DEFAULT 0 NOT NULL,\n RUN_COUNT INTEGER DEFAULT 0 NOT NULL,\n SEVERITY_LEVEL INTEGER DEFAULT 0 NOT NULL,\n ENABLED TINYINT DEFAULT 0 NOT NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (MONITOR_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.694Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_MONITOR_EVENT(\n MONITOR_ID VARCHAR(128) NOT NULL,\n NODE_ID VARCHAR(50) NOT NULL,\n EVENT_TIME TIMESTAMP NOT NULL,\n HOST_NAME VARCHAR(60) NULL,\n TYPE VARCHAR(50) NOT NULL,\n THRESHOLD BIGINT DEFAULT 0 NOT NULL,\n EVENT_VALUE BIGINT DEFAULT 0 NOT NULL,\n EVENT_COUNT INTEGER DEFAULT 0 NOT NULL,\n SEVERITY_LEVEL INTEGER DEFAULT 0 NOT NULL,\n IS_RESOLVED TINYINT DEFAULT 0 NOT NULL,\n IS_NOTIFIED TINYINT DEFAULT 0 NOT NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (MONITOR_ID, NODE_ID, EVENT_TIME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.696Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_NOTIFICATION(\n NOTIFICATION_ID VARCHAR(128) NOT NULL,\n NODE_GROUP_ID VARCHAR(50) DEFAULT 'ALL' NOT NULL,\n EXTERNAL_ID VARCHAR(255) DEFAULT 'ALL' NOT NULL,\n SEVERITY_LEVEL INTEGER DEFAULT 0 NOT NULL,\n TYPE VARCHAR(50) NOT NULL,\n EXPRESSION VARCHAR(2147483647) NULL,\n ENABLED TINYINT DEFAULT 0 NOT NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (NOTIFICATION_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.699Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_OUTGOING_BATCH(\n BATCH_ID BIGINT NOT NULL,\n NODE_ID VARCHAR(50) NOT NULL,\n CHANNEL_ID VARCHAR(128) NULL,\n STATUS CHAR(2) NULL,\n LOAD_ID BIGINT,\n EXTRACT_JOB_FLAG TINYINT DEFAULT 0,\n LOAD_FLAG TINYINT DEFAULT 0,\n ERROR_FLAG TINYINT DEFAULT 0,\n COMMON_FLAG TINYINT DEFAULT 0,\n IGNORE_COUNT BIGINT DEFAULT 0 NOT NULL,\n BYTE_COUNT BIGINT DEFAULT 0 NOT NULL,\n EXTRACT_COUNT BIGINT DEFAULT 0 NOT NULL,\n SENT_COUNT BIGINT DEFAULT 0 NOT NULL,\n LOAD_COUNT BIGINT DEFAULT 0 NOT NULL,\n DATA_EVENT_COUNT BIGINT DEFAULT 0 NOT NULL,\n RELOAD_EVENT_COUNT BIGINT DEFAULT 0 NOT NULL,\n INSERT_EVENT_COUNT BIGINT DEFAULT 0 NOT NULL,\n UPDATE_EVENT_COUNT BIGINT DEFAULT 0 NOT NULL,\n DELETE_EVENT_COUNT BIGINT DEFAULT 0 NOT NULL,\n OTHER_EVENT_COUNT BIGINT DEFAULT 0 NOT NULL,\n ROUTER_MILLIS BIGINT DEFAULT 0 NOT NULL,\n NETWORK_MILLIS BIGINT DEFAULT 0 NOT NULL,\n FILTER_MILLIS BIGINT DEFAULT 0 NOT NULL,\n LOAD_MILLIS BIGINT DEFAULT 0 NOT NULL,\n EXTRACT_MILLIS BIGINT DEFAULT 0 NOT NULL,\n TRANSFORM_EXTRACT_MILLIS BIGINT DEFAULT 0 NOT NULL,\n TRANSFORM_LOAD_MILLIS BIGINT DEFAULT 0 NOT NULL,\n TOTAL_EXTRACT_MILLIS BIGINT DEFAULT 0 NOT NULL,\n TOTAL_LOAD_MILLIS BIGINT DEFAULT 0 NOT NULL,\n SQL_STATE VARCHAR(10) NULL,\n SQL_CODE INTEGER DEFAULT 0 NOT NULL,\n SQL_MESSAGE VARCHAR(2147483647) NULL,\n FAILED_DATA_ID BIGINT DEFAULT 0 NOT NULL,\n FAILED_LINE_NUMBER BIGINT DEFAULT 0 NOT NULL,\n LAST_UPDATE_HOSTNAME VARCHAR(255) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n CREATE_TIME TIMESTAMP,\n CREATE_BY VARCHAR(255) NULL,\n SUMMARY VARCHAR(255) NULL,\n PRIMARY KEY (BATCH_ID, NODE_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.700Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_OB_NODE_STATUS ON SYM_OUTGOING_BATCH (NODE_ID, STATUS)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.701Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_OB_STATUS ON SYM_OUTGOING_BATCH (STATUS)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.702Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_OB_IN_ERROR ON SYM_OUTGOING_BATCH (ERROR_FLAG)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.703Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_PARAMETER(\n EXTERNAL_ID VARCHAR(255) NOT NULL,\n NODE_GROUP_ID VARCHAR(50) NOT NULL,\n PARAM_KEY VARCHAR(80) NOT NULL,\n PARAM_VALUE VARCHAR(2147483647) NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (EXTERNAL_ID, NODE_GROUP_ID, PARAM_KEY)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.704Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_REGISTRATION_REDIRECT(\n REGISTRANT_EXTERNAL_ID VARCHAR(255) NOT NULL,\n REGISTRATION_NODE_ID VARCHAR(50) NOT NULL,\n PRIMARY KEY (REGISTRANT_EXTERNAL_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.705Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_REGISTRATION_REQUEST(\n NODE_GROUP_ID VARCHAR(50) NOT NULL,\n EXTERNAL_ID VARCHAR(255) NOT NULL,\n STATUS CHAR(2) NOT NULL,\n HOST_NAME VARCHAR(60) NOT NULL,\n IP_ADDRESS VARCHAR(50) NOT NULL,\n ATTEMPT_COUNT INTEGER DEFAULT 0,\n REGISTERED_NODE_ID VARCHAR(50) NULL,\n ERROR_MESSAGE VARCHAR(2147483647) NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (NODE_GROUP_ID, EXTERNAL_ID, CREATE_TIME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.706Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_REG_REQ_1 ON SYM_REGISTRATION_REQUEST (NODE_GROUP_ID, EXTERNAL_ID, STATUS, HOST_NAME, IP_ADDRESS)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.707Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_REG_REQ_2 ON SYM_REGISTRATION_REQUEST (STATUS)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.708Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_ROUTER(\n ROUTER_ID VARCHAR(50) NOT NULL,\n TARGET_CATALOG_NAME VARCHAR(255) NULL,\n TARGET_SCHEMA_NAME VARCHAR(255) NULL,\n TARGET_TABLE_NAME VARCHAR(255) NULL,\n SOURCE_NODE_GROUP_ID VARCHAR(50) NOT NULL,\n TARGET_NODE_GROUP_ID VARCHAR(50) NOT NULL,\n ROUTER_TYPE VARCHAR(50) NULL,\n ROUTER_EXPRESSION VARCHAR(2147483647) NULL,\n SYNC_ON_UPDATE TINYINT DEFAULT 1 NOT NULL,\n SYNC_ON_INSERT TINYINT DEFAULT 1 NOT NULL,\n SYNC_ON_DELETE TINYINT DEFAULT 1 NOT NULL,\n USE_SOURCE_CATALOG_SCHEMA TINYINT DEFAULT 1 NOT NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (ROUTER_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.710Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_SEQUENCE(\n SEQUENCE_NAME VARCHAR(50) NOT NULL,\n CURRENT_VALUE BIGINT DEFAULT 0 NOT NULL,\n INCREMENT_BY INTEGER DEFAULT 1 NOT NULL,\n MIN_VALUE BIGINT DEFAULT 1 NOT NULL,\n MAX_VALUE BIGINT DEFAULT 9999999999 NOT NULL,\n CYCLE TINYINT DEFAULT 0,\n CACHE_SIZE INTEGER DEFAULT 0 NOT NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (SEQUENCE_NAME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.712Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_TABLE_RELOAD_REQUEST(\n TARGET_NODE_ID VARCHAR(50) NOT NULL,\n SOURCE_NODE_ID VARCHAR(50) NOT NULL,\n TRIGGER_ID VARCHAR(128) NOT NULL,\n ROUTER_ID VARCHAR(50) NOT NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n CREATE_TABLE TINYINT DEFAULT 0 NOT NULL,\n DELETE_FIRST TINYINT DEFAULT 0 NOT NULL,\n RELOAD_SELECT VARCHAR(2147483647) NULL,\n BEFORE_CUSTOM_SQL VARCHAR(2147483647) NULL,\n RELOAD_TIME TIMESTAMP,\n LOAD_ID BIGINT,\n PROCESSED TINYINT DEFAULT 0 NOT NULL,\n CHANNEL_ID VARCHAR(128) NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (TARGET_NODE_ID, SOURCE_NODE_ID, TRIGGER_ID, ROUTER_ID, CREATE_TIME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.713Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_TRANSFORM_TABLE(\n TRANSFORM_ID VARCHAR(50) NOT NULL,\n SOURCE_NODE_GROUP_ID VARCHAR(50) NOT NULL,\n TARGET_NODE_GROUP_ID VARCHAR(50) NOT NULL,\n TRANSFORM_POINT VARCHAR(10) NOT NULL,\n SOURCE_CATALOG_NAME VARCHAR(255) NULL,\n SOURCE_SCHEMA_NAME VARCHAR(255) NULL,\n SOURCE_TABLE_NAME VARCHAR(255) NOT NULL,\n TARGET_CATALOG_NAME VARCHAR(255) NULL,\n TARGET_SCHEMA_NAME VARCHAR(255) NULL,\n TARGET_TABLE_NAME VARCHAR(255) NULL,\n UPDATE_FIRST TINYINT DEFAULT 0,\n UPDATE_ACTION VARCHAR(255) DEFAULT 'UPDATE_COL' NOT NULL,\n DELETE_ACTION VARCHAR(10) NOT NULL,\n TRANSFORM_ORDER INTEGER DEFAULT 1 NOT NULL,\n COLUMN_POLICY VARCHAR(10) DEFAULT 'SPECIFIED' NOT NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (TRANSFORM_ID, SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.715Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_TRANSFORM_COLUMN(\n TRANSFORM_ID VARCHAR(50) NOT NULL,\n INCLUDE_ON CHAR(1) DEFAULT '*' NOT NULL,\n TARGET_COLUMN_NAME VARCHAR(128) NOT NULL,\n SOURCE_COLUMN_NAME VARCHAR(128) NULL,\n PK TINYINT DEFAULT 0,\n TRANSFORM_TYPE VARCHAR(50) DEFAULT 'copy' NULL,\n TRANSFORM_EXPRESSION VARCHAR(2147483647) NULL,\n TRANSFORM_ORDER INTEGER DEFAULT 1 NOT NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n PRIMARY KEY (TRANSFORM_ID, INCLUDE_ON, TARGET_COLUMN_NAME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.718Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_TRIGGER(\n TRIGGER_ID VARCHAR(128) NOT NULL,\n SOURCE_CATALOG_NAME VARCHAR(255) NULL,\n SOURCE_SCHEMA_NAME VARCHAR(255) NULL,\n SOURCE_TABLE_NAME VARCHAR(255) NOT NULL,\n CHANNEL_ID VARCHAR(128) NOT NULL,\n RELOAD_CHANNEL_ID VARCHAR(128) DEFAULT 'reload' NOT NULL,\n SYNC_ON_UPDATE TINYINT DEFAULT 1 NOT NULL,\n SYNC_ON_INSERT TINYINT DEFAULT 1 NOT NULL,\n SYNC_ON_DELETE TINYINT DEFAULT 1 NOT NULL,\n SYNC_ON_INCOMING_BATCH TINYINT DEFAULT 0 NOT NULL,\n NAME_FOR_UPDATE_TRIGGER VARCHAR(255) NULL,\n NAME_FOR_INSERT_TRIGGER VARCHAR(255) NULL,\n NAME_FOR_DELETE_TRIGGER VARCHAR(255) NULL,\n SYNC_ON_UPDATE_CONDITION VARCHAR(2147483647) NULL,\n SYNC_ON_INSERT_CONDITION VARCHAR(2147483647) NULL,\n SYNC_ON_DELETE_CONDITION VARCHAR(2147483647) NULL,\n CUSTOM_BEFORE_UPDATE_TEXT VARCHAR(2147483647) NULL,\n CUSTOM_BEFORE_INSERT_TEXT VARCHAR(2147483647) NULL,\n CUSTOM_BEFORE_DELETE_TEXT VARCHAR(2147483647) NULL,\n CUSTOM_ON_UPDATE_TEXT VARCHAR(2147483647) NULL,\n CUSTOM_ON_INSERT_TEXT VARCHAR(2147483647) NULL,\n CUSTOM_ON_DELETE_TEXT VARCHAR(2147483647) NULL,\n EXTERNAL_SELECT VARCHAR(2147483647) NULL,\n TX_ID_EXPRESSION VARCHAR(2147483647) NULL,\n CHANNEL_EXPRESSION VARCHAR(2147483647) NULL,\n EXCLUDED_COLUMN_NAMES VARCHAR(2147483647) NULL,\n INCLUDED_COLUMN_NAMES VARCHAR(2147483647) NULL,\n SYNC_KEY_NAMES VARCHAR(2147483647) NULL,\n USE_STREAM_LOBS TINYINT DEFAULT 0 NOT NULL,\n USE_CAPTURE_LOBS TINYINT DEFAULT 0 NOT NULL,\n USE_CAPTURE_OLD_DATA TINYINT DEFAULT 1 NOT NULL,\n USE_HANDLE_KEY_UPDATES TINYINT DEFAULT 0 NOT NULL,\n STREAM_ROW TINYINT DEFAULT 0 NOT NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (TRIGGER_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.719Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_TRIGGER_HIST(\n TRIGGER_HIST_ID INTEGER NOT NULL,\n TRIGGER_ID VARCHAR(128) NOT NULL,\n SOURCE_TABLE_NAME VARCHAR(255) NOT NULL,\n SOURCE_CATALOG_NAME VARCHAR(255) NULL,\n SOURCE_SCHEMA_NAME VARCHAR(255) NULL,\n NAME_FOR_UPDATE_TRIGGER VARCHAR(255) NULL,\n NAME_FOR_INSERT_TRIGGER VARCHAR(255) NULL,\n NAME_FOR_DELETE_TRIGGER VARCHAR(255) NULL,\n TABLE_HASH BIGINT DEFAULT 0 NOT NULL,\n TRIGGER_ROW_HASH BIGINT DEFAULT 0 NOT NULL,\n TRIGGER_TEMPLATE_HASH BIGINT DEFAULT 0 NOT NULL,\n COLUMN_NAMES VARCHAR(2147483647) NOT NULL,\n PK_COLUMN_NAMES VARCHAR(2147483647) NOT NULL,\n LAST_TRIGGER_BUILD_REASON CHAR(1) NOT NULL,\n ERROR_MESSAGE VARCHAR(2147483647) NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n INACTIVE_TIME TIMESTAMP,\n PRIMARY KEY (TRIGGER_HIST_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.720Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE INDEX SYM_IDX_TRIGG_HIST_1 ON SYM_TRIGGER_HIST (TRIGGER_ID, INACTIVE_TIME)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.721Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_TRIGGER_ROUTER(\n TRIGGER_ID VARCHAR(128) NOT NULL,\n ROUTER_ID VARCHAR(50) NOT NULL,\n ENABLED TINYINT DEFAULT 1 NOT NULL,\n INITIAL_LOAD_ORDER INTEGER DEFAULT 1 NOT NULL,\n INITIAL_LOAD_SELECT VARCHAR(2147483647) NULL,\n INITIAL_LOAD_DELETE_STMT VARCHAR(2147483647) NULL,\n INITIAL_LOAD_BATCH_COUNT INTEGER DEFAULT 1,\n PING_BACK_ENABLED TINYINT DEFAULT 0 NOT NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (TRIGGER_ID, ROUTER_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.723Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_TRIGGER_ROUTER_GROUPLET(\n GROUPLET_ID VARCHAR(50) NOT NULL,\n TRIGGER_ID VARCHAR(128) NOT NULL,\n ROUTER_ID VARCHAR(50) NOT NULL,\n APPLIES_WHEN CHAR(1) NOT NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP NOT NULL,\n PRIMARY KEY (GROUPLET_ID, TRIGGER_ID, ROUTER_ID, APPLIES_WHEN)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.724Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_CONSOLE_USER(\n USER_ID VARCHAR(50) NOT NULL,\n FIRST_NAME VARCHAR(50) NOT NULL,\n LAST_NAME VARCHAR(50) NOT NULL,\n EMAIL VARCHAR(50) NULL,\n HASHED_PASSWORD VARCHAR(255) NULL,\n SALT VARCHAR(50) NULL,\n ENCRYPT_METH VARCHAR(50) NULL,\n FAILED_LOGINS TINYINT DEFAULT 0,\n AUTH_METH VARCHAR(50) DEFAULT 'INTERNAL' NULL,\n USER_ROLE VARCHAR(50) DEFAULT 'ADMIN' NULL,\n CREATE_TIME TIMESTAMP,\n LAST_UPDATE_BY VARCHAR(50) NULL,\n LAST_UPDATE_TIME TIMESTAMP,\n LAST_PASSWORD_TIME TIMESTAMP,\n PRIMARY KEY (USER_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.725Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_CONSOLE_USER_HIST(\n HIST_ID INTEGER NOT NULL,\n USER_ID VARCHAR(50) NOT NULL,\n HASHED_PASSWORD VARCHAR(255) NULL,\n SALT VARCHAR(50) NULL,\n ENCRYPT_METH VARCHAR(50) NULL,\n AUTH_METH VARCHAR(50) DEFAULT 'INTERNAL' NULL,\n PRIMARY KEY (HIST_ID, USER_ID)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.727Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: CREATE TABLE SYM_CONSOLE_EVENT(\n USER_ID VARCHAR(50) NOT NULL,\n EVENT_CODE VARCHAR(25) NOT NULL,\n CREATE_TIME TIMESTAMP NOT NULL,\n EVENT_NODE_ID VARCHAR(50) NULL,\n SOURCE_NODE_ID VARCHAR(50) NULL,\n TARGET_NODE_ID VARCHAR(50) NULL,\n EVENT_VALUE VARCHAR(2147483647) NULL,\n PRIMARY KEY (USER_ID, EVENT_CODE, CREATE_TIME)\n)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.738Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_CONFLICT\n 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)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.740Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_FILE_TRIGGER_ROUTER\n ADD CONSTRAINT SYM_FK_FTR_2_FTRG FOREIGN KEY (TRIGGER_ID) REFERENCES SYM_FILE_TRIGGER (TRIGGER_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.743Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_FILE_TRIGGER_ROUTER\n ADD CONSTRAINT SYM_FK_FTR_2_RTR FOREIGN KEY (ROUTER_ID) REFERENCES SYM_ROUTER (ROUTER_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.744Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_GROUPLET_LINK\n ADD CONSTRAINT SYM_FK_GPLTLNK_2_GPLT FOREIGN KEY (GROUPLET_ID) REFERENCES SYM_GROUPLET (GROUPLET_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.746Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_NODE_GROUP_LINK\n ADD CONSTRAINT SYM_FK_LNK_2_GRP_SRC FOREIGN KEY (SOURCE_NODE_GROUP_ID) REFERENCES SYM_NODE_GROUP (NODE_GROUP_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.748Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_NODE_GROUP_LINK\n ADD CONSTRAINT SYM_FK_LNK_2_GRP_TGT FOREIGN KEY (TARGET_NODE_GROUP_ID) REFERENCES SYM_NODE_GROUP (NODE_GROUP_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.749Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_NODE_IDENTITY\n ADD CONSTRAINT SYM_FK_IDENT_2_NODE FOREIGN KEY (NODE_ID) REFERENCES SYM_NODE (NODE_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.750Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_NODE_SECURITY\n ADD CONSTRAINT SYM_FK_SEC_2_NODE FOREIGN KEY (NODE_ID) REFERENCES SYM_NODE (NODE_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.752Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_ROUTER\n 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)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.754Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_TRANSFORM_TABLE\n 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)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.756Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_TRIGGER\n ADD CONSTRAINT SYM_FK_TRG_2_CHNL FOREIGN KEY (CHANNEL_ID) REFERENCES SYM_CHANNEL (CHANNEL_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.758Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_TRIGGER\n ADD CONSTRAINT SYM_FK_TRG_2_RLD_CHNL FOREIGN KEY (RELOAD_CHANNEL_ID) REFERENCES SYM_CHANNEL (CHANNEL_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.760Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_TRIGGER_ROUTER\n ADD CONSTRAINT SYM_FK_TR_2_TRG FOREIGN KEY (TRIGGER_ID) REFERENCES SYM_TRIGGER (TRIGGER_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.761Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_TRIGGER_ROUTER\n ADD CONSTRAINT SYM_FK_TR_2_RTR FOREIGN KEY (ROUTER_ID) REFERENCES SYM_ROUTER (ROUTER_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.763Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_TRIGGER_ROUTER_GROUPLET\n ADD CONSTRAINT SYM_FK_TRGPLT_2_GPLT FOREIGN KEY (GROUPLET_ID) REFERENCES SYM_GROUPLET (GROUPLET_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.764Z","source_host":"usmvvjairath.infor.com","file":"LogSqlResultsListener.java","method":"sqlApplied","level":"INFO","line_number":"43","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"DDL applied: ALTER TABLE SYM_TRIGGER_ROUTER_GROUPLET\n ADD CONSTRAINT SYM_FK_TRGPLT_2_TR FOREIGN KEY (TRIGGER_ID, ROUTER_ID) REFERENCES SYM_TRIGGER_ROUTER (TRIGGER_ID, ROUTER_ID)","class":"org.jumpmind.db.sql.LogSqlResultsListener","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.768Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricDialect.java","method":"createOrAlterTablesIfNecessary","level":"INFO","line_number":"537","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"Done with auto update of SymmetricDS tables","class":"org.jumpmind.symmetric.db.AbstractSymmetricDialect","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.773Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricDialect.java","method":"install","level":"INFO","line_number":"175","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"Installing SymmetricDS database object:\nCREATE ALIAS IF NOT EXISTS SYM_BASE64_ENCODE for \"org.jumpmind.symmetric.db.EmbeddedDbFunctions.encodeBase64\"; ","class":"org.jumpmind.symmetric.db.AbstractSymmetricDialect","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.778Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricDialect.java","method":"install","level":"INFO","line_number":"177","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.db.h2.H2SymmetricDialect","message":"Just installed SYM_BASE64_ENCODE","class":"org.jumpmind.symmetric.db.AbstractSymmetricDialect","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.811Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricEngine.java","method":"setupDatabase","level":"INFO","line_number":"471","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.AbstractSymmetricEngine","message":"Done initializing SymmetricDS database","class":"org.jumpmind.symmetric.AbstractSymmetricEngine","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.812Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricEngine.java","method":"setup","level":"INFO","line_number":"434","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.AbstractSymmetricEngine","message":"SymmetricDS database version : null","class":"org.jumpmind.symmetric.AbstractSymmetricEngine","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.812Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricEngine.java","method":"setup","level":"INFO","line_number":"435","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.AbstractSymmetricEngine","message":"SymmetricDS software version : 3.8.33","class":"org.jumpmind.symmetric.AbstractSymmetricEngine","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.859Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricEngine.java","method":"isConfigured","level":"WARN","line_number":"881","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.AbstractSymmetricEngine","message":"Please set the registration.url for the node","class":"org.jumpmind.symmetric.AbstractSymmetricEngine","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.861Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricEngine.java","method":"start","level":"ERROR","line_number":"655","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.AbstractSymmetricEngine","message":"Did not start SymmetricDS. It has not been configured properly","class":"org.jumpmind.symmetric.AbstractSymmetricEngine","mdc":{"engineName":"SymmetricDS"}} {"@timestamp":"2018-02-06T18:52:51.861Z","source_host":"usmvvjairath.infor.com","file":"AbstractSymmetricEngine.java","method":"start","level":"INFO","line_number":"666","thread_name":"symmetric-engine-startup-0","@version":1,"logger_name":"org.jumpmind.symmetric.AbstractSymmetricEngine","message":"SymmetricDS: type=professional, name=SymmetricDS, version=3.8.33, groupId=please set me, externalId=please set me, databaseName=H2, databaseVersion=1.4, driverName=H2 JDBC Driver, driverVersion=1.4.195 (2017-04-23)","class":"org.jumpmind.symmetric.AbstractSymmetricEngine","mdc":{"engineName":"SymmetricDS"}}