2014-10-09 08:50:34,367 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={oraclenept-004} 2014-10-09 08:50:34,367 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8080} 2014-10-09 08:50:34,680 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port default:8080 2014-10-09 08:50:36,945 INFO [startup] [/] [main] Initializing Spring root WebApplicationContext 2014-10-09 08:50:37,335 INFO [oraclenept-004] [BasicDataSourceFactory] [symmetric-engine-startup-0] Setting database connection property oracle.net.CONNECT_TIMEOUT=300000 2014-10-09 08:50:37,335 INFO [oraclenept-004] [BasicDataSourceFactory] [symmetric-engine-startup-0] Setting database connection property oracle.net.READ_TIMEOUT=300000 2014-10-09 08:50:37,335 INFO [oraclenept-004] [BasicDataSourceFactory] [symmetric-engine-startup-0] Setting database connection property SetBigStringTryClob=true 2014-10-09 08:50:38,117 INFO [oraclenept-004] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-0] Detected database 'Oracle', version '10', protocol 'oracle' 2014-10-09 08:50:38,351 ERROR [oraclenept-004] [ParameterService] [symmetric-engine-startup-0] Could not read database parameters and they have not yet been initialized 2014-10-09 08:50:38,366 ERROR [oraclenept-004] [ParameterService] [symmetric-engine-startup-0] Could not read database parameters and they have not yet been initialized 2014-10-09 08:50:38,366 ERROR [oraclenept-004] [SymmetricEngineHolder] [symmetric-engine-startup-0] Failed to execute sql: select param_key, param_value from sym_parameter where external_id=? and node_group_id=? org.jumpmind.db.sql.SqlException: Failed to execute sql: select param_key, param_value from sym_parameter where external_id=? and node_group_id=? at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:288) at org.jumpmind.db.sql.JdbcSqlReadCursor.(JdbcSqlReadCursor.java:104) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:127) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:187) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:182) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:123) at org.jumpmind.symmetric.service.impl.ParameterService.readParametersFromDatabase(ParameterService.java:140) at org.jumpmind.symmetric.service.impl.ParameterService.getDatabaseParameters(ParameterService.java:171) at org.jumpmind.symmetric.service.impl.AbstractParameterService.rereadDatabaseParameters(AbstractParameterService.java:223) at org.jumpmind.symmetric.service.impl.ParameterService.rereadApplicationParameters(ParameterService.java:161) at org.jumpmind.symmetric.service.impl.AbstractParameterService.getParameters(AbstractParameterService.java:155) at org.jumpmind.symmetric.service.impl.AbstractParameterService.getString(AbstractParameterService.java:118) at org.jumpmind.symmetric.service.impl.AbstractParameterService.getString(AbstractParameterService.java:129) at org.jumpmind.symmetric.service.impl.AbstractParameterService.substituteVariables(AbstractParameterService.java:238) at org.jumpmind.symmetric.service.impl.AbstractParameterService.getExternalId(AbstractParameterService.java:184) at org.jumpmind.symmetric.AbstractSymmetricEngine.stop(AbstractSymmetricEngine.java:696) at org.jumpmind.symmetric.ClientSymmetricEngine.stop(ClientSymmetricEngine.java:240) at org.jumpmind.symmetric.AbstractSymmetricEngine.destroy(AbstractSymmetricEngine.java:714) at org.jumpmind.symmetric.ClientSymmetricEngine.destroy(ClientSymmetricEngine.java:412) at org.jumpmind.symmetric.ClientSymmetricEngine.init(ClientSymmetricEngine.java:222) at org.jumpmind.symmetric.web.ServerSymmetricEngine.init(ServerSymmetricEngine.java:51) at org.jumpmind.symmetric.ClientSymmetricEngine.(ClientSymmetricEngine.java:140) at org.jumpmind.symmetric.web.ServerSymmetricEngine.(ServerSymmetricEngine.java:41) at org.jumpmind.symmetric.web.SymmetricEngineHolder.create(SymmetricEngineHolder.java:219) at org.jumpmind.symmetric.web.SymmetricEngineHolder$EngineStarter.run(SymmetricEngineHolder.java:438) Caused by: java.sql.SQLException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:877) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1281) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1205) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.jumpmind.db.sql.JdbcSqlReadCursor.(JdbcSqlReadCursor.java:81) ... 23 more 2014-10-09 08:50:39,304 INFO [startup] [/] [main] Initializing Spring FrameworkServlet 'rest' 2014-10-09 08:50:39,819 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8081 2014-10-09 08:50:39,850 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread --mark-- created sym_parameter table in ORACLE DB 2014-10-09 10:16:33,521 INFO [startup] [AbstractCommandLauncher] [main] Option: name=engine, value={oraclenept-004} 2014-10-09 10:16:33,521 INFO [startup] [AbstractCommandLauncher] [main] Option: name=port, value={8080} 2014-10-09 10:16:33,850 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port default:8080 2014-10-09 10:16:35,631 INFO [startup] [/] [main] Initializing Spring root WebApplicationContext 2014-10-09 10:16:36,037 INFO [oraclenept-004] [BasicDataSourceFactory] [symmetric-engine-startup-0] Setting database connection property oracle.net.CONNECT_TIMEOUT=300000 2014-10-09 10:16:36,037 INFO [oraclenept-004] [BasicDataSourceFactory] [symmetric-engine-startup-0] Setting database connection property oracle.net.READ_TIMEOUT=300000 2014-10-09 10:16:36,037 INFO [oraclenept-004] [BasicDataSourceFactory] [symmetric-engine-startup-0] Setting database connection property SetBigStringTryClob=true 2014-10-09 10:16:36,771 INFO [oraclenept-004] [JdbcDatabasePlatformFactory] [symmetric-engine-startup-0] Detected database 'Oracle', version '10', protocol 'oracle' 2014-10-09 10:16:37,053 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] The DbDialect being used is org.jumpmind.symmetric.db.oracle.OracleSymmetricDialect 2014-10-09 10:16:37,115 INFO [oraclenept-004] [StagingManager] [symmetric-engine-startup-0] The staging directory was initialized at the following location: C:\symmetric-3.6.7\tmp\oraclenept-004 2014-10-09 10:16:37,193 INFO [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] This node picked a server id of ORABIT 2014-10-09 10:16:38,084 INFO [startup] [/] [main] Initializing Spring FrameworkServlet 'rest' 2014-10-09 10:16:38,365 INFO [oraclenept-004] [ExtensionPointManager] [symmetric-engine-startup-0] Found 9 extension points that will be registered 2014-10-09 10:16:38,365 DEBUG [oraclenept-004] [ExtensionPointManager] [symmetric-engine-startup-0] Registering an extension point named ftp_example of type 'FtpDataLoaderFactory' with SymmetricDS 2014-10-09 10:16:38,381 DEBUG [oraclenept-004] [ExtensionPointManager] [symmetric-engine-startup-0] Registering an extension point named mongoLoaderFactory of type 'MongoDataLoaderFactory' with SymmetricDS 2014-10-09 10:16:38,381 DEBUG [oraclenept-004] [ExtensionPointManager] [symmetric-engine-startup-0] Registering an extension point named mssqlBulkLoaderFactory of type 'MsSqlBulkDataLoaderFactory' with SymmetricDS 2014-10-09 10:16:38,381 DEBUG [oraclenept-004] [ExtensionPointManager] [symmetric-engine-startup-0] Registering an extension point named mysqlBulkLoaderFactory of type 'MySqlBulkDataLoaderFactory' with SymmetricDS 2014-10-09 10:16:38,381 DEBUG [oraclenept-004] [ExtensionPointManager] [symmetric-engine-startup-0] Registering an extension point named nodeManagementService of type 'NodeManagementService' with SymmetricDS 2014-10-09 10:16:38,381 DEBUG [oraclenept-004] [ExtensionPointManager] [symmetric-engine-startup-0] Registering an extension point named oracleBulkLoaderFactory of type 'OracleBulkDataLoaderFactory' with SymmetricDS 2014-10-09 10:16:38,381 DEBUG [oraclenept-004] [ExtensionPointManager] [symmetric-engine-startup-0] Registering an extension point named parameterManagementService of type 'ParameterManagementService' with SymmetricDS 2014-10-09 10:16:38,381 DEBUG [oraclenept-004] [ExtensionPointManager] [symmetric-engine-startup-0] Registering an extension point named postgresBulkLoaderFactory of type 'PostgresBulkDataLoaderFactory' with SymmetricDS 2014-10-09 10:16:38,381 DEBUG [oraclenept-004] [ExtensionPointManager] [symmetric-engine-startup-0] Registering an extension point named redshiftBulkLoaderFactory of type 'RedshiftBulkDataLoaderFactory' with SymmetricDS 2014-10-09 10:16:38,396 INFO [oraclenept-004] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Initializing SymmetricDS database 2014-10-09 10:16:38,412 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] Checking if SymmetricDS tables need created or altered 2014-10-09 10:16:38,600 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 8081 2014-10-09 10:16:38,631 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2014-10-09 10:16:38,787 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] There are SymmetricDS tables that needed altered 2014-10-09 10:16:38,803 DEBUG [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] Alter SQL generated: ALTER TABLE "NEPT"."SYM_PARAMETER" MODIFY ("EXTERNAL_ID" NOT NULL ); ALTER TABLE "NEPT"."SYM_PARAMETER" MODIFY ("NODE_GROUP_ID" NOT NULL ); ALTER TABLE "NEPT"."SYM_PARAMETER" MODIFY ("PARAM_KEY" NOT NULL ); ALTER TABLE "SYM_PARAMETER" ADD CONSTRAINT "SYM_PARAMETER_PK" PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY"); CREATE TABLE "SYM_CHANNEL"( "CHANNEL_ID" VARCHAR2(128) NOT NULL, "PROCESSING_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "MAX_BATCH_SIZE" NUMBER(22) DEFAULT 1000 NOT NULL, "MAX_BATCH_TO_SEND" NUMBER(22) DEFAULT 60 NOT NULL, "MAX_DATA_TO_ROUTE" NUMBER(22) DEFAULT 100000 NOT NULL, "EXTRACT_PERIOD_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "USE_OLD_DATA_TO_ROUTE" NUMBER(3) DEFAULT 1 NOT NULL, "USE_ROW_DATA_TO_ROUTE" NUMBER(3) DEFAULT 1 NOT NULL, "USE_PK_DATA_TO_ROUTE" NUMBER(3) DEFAULT 1 NOT NULL, "RELOAD_FLAG" NUMBER(3) DEFAULT 0 NOT NULL, "FILE_SYNC_FLAG" NUMBER(3) DEFAULT 0 NOT NULL, "CONTAINS_BIG_LOB" NUMBER(3) DEFAULT 0 NOT NULL, "BATCH_ALGORITHM" VARCHAR2(50) DEFAULT 'default' NOT NULL, "DATA_LOADER_TYPE" VARCHAR2(50) DEFAULT 'default' NOT NULL, "DESCRIPTION" VARCHAR2(255), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ); ALTER TABLE "SYM_CHANNEL" ADD CONSTRAINT "SYM_CHANNEL_PK" PRIMARY KEY ("CHANNEL_ID"); CREATE TABLE "SYM_CONFLICT"( "CONFLICT_ID" VARCHAR2(50) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_CHANNEL_ID" VARCHAR2(128), "TARGET_CATALOG_NAME" VARCHAR2(255), "TARGET_SCHEMA_NAME" VARCHAR2(255), "TARGET_TABLE_NAME" VARCHAR2(255), "DETECT_TYPE" VARCHAR2(128) NOT NULL, "DETECT_EXPRESSION" CLOB, "RESOLVE_TYPE" VARCHAR2(128) NOT NULL, "PING_BACK" VARCHAR2(128) NOT NULL, "RESOLVE_CHANGES_ONLY" NUMBER(3) DEFAULT 0, "RESOLVE_ROW_ONLY" NUMBER(3) DEFAULT 0, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_CONFLICT" ADD CONSTRAINT "SYM_CONFLICT_PK" PRIMARY KEY ("CONFLICT_ID"); CREATE SEQUENCE "SEQ_SYM_DATA_DATA_ID" CACHE 1000 ORDER; CREATE TABLE "SYM_DATA"( "DATA_ID" NUMBER(38) NOT NULL , "TABLE_NAME" VARCHAR2(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "ROW_DATA" CLOB, "PK_DATA" CLOB, "OLD_DATA" CLOB, "TRIGGER_HIST_ID" NUMBER(22) NOT NULL, "CHANNEL_ID" VARCHAR2(128), "TRANSACTION_ID" VARCHAR2(255), "SOURCE_NODE_ID" VARCHAR2(50), "EXTERNAL_DATA" VARCHAR2(50), "NODE_LIST" VARCHAR2(255), "CREATE_TIME" TIMESTAMP ); CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID"); ALTER TABLE "SYM_DATA" ADD CONSTRAINT "SYM_DATA_PK" PRIMARY KEY ("DATA_ID"); CREATE OR REPLACE TRIGGER "TRG_SYM_DATA_DATA_ID" BEFORE INSERT ON "SYM_DATA" FOR EACH ROW WHEN (new."DATA_ID" IS NULL) BEGIN SELECT "SEQ_SYM_DATA_DATA_ID".nextval INTO :new."DATA_ID" FROM dual; END;; CREATE TABLE "SYM_DATA_EVENT"( "DATA_ID" NUMBER(38) NOT NULL, "BATCH_ID" NUMBER(38) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "CREATE_TIME" TIMESTAMP ); CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID"); ALTER TABLE "SYM_DATA_EVENT" ADD CONSTRAINT "SYM_DATA_EVENT_PK" PRIMARY KEY ("DATA_ID", "BATCH_ID", "ROUTER_ID"); CREATE TABLE "SYM_DATA_GAP"( "START_ID" NUMBER(38) NOT NULL, "END_ID" NUMBER(38) NOT NULL, "STATUS" CHAR(2), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR2(255), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); CREATE INDEX "SYM_IDX_DG_STATUS" ON "SYM_DATA_GAP" ("STATUS"); ALTER TABLE "SYM_DATA_GAP" ADD CONSTRAINT "SYM_DATA_GAP_PK" PRIMARY KEY ("START_ID", "END_ID"); CREATE TABLE "SYM_EXTRACT_REQUEST"( "REQUEST_ID" NUMBER(38) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "STATUS" CHAR(2), "START_BATCH_ID" NUMBER(38) NOT NULL, "END_BATCH_ID" NUMBER(38) NOT NULL, "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP ); ALTER TABLE "SYM_EXTRACT_REQUEST" ADD CONSTRAINT "SYM_EXTRACT_REQUEST_PK" PRIMARY KEY ("REQUEST_ID"); CREATE TABLE "SYM_FILE_INCOMING"( "RELATIVE_DIR" VARCHAR2(255) NOT NULL, "FILE_NAME" VARCHAR2(128) NOT NULL, "LAST_EVENT_TYPE" CHAR(1) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "FILE_MODIFIED_TIME" NUMBER(38) ); ALTER TABLE "SYM_FILE_INCOMING" ADD CONSTRAINT "SYM_FILE_INCOMING_PK" PRIMARY KEY ("RELATIVE_DIR", "FILE_NAME"); CREATE TABLE "SYM_FILE_SNAPSHOT"( "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "RELATIVE_DIR" VARCHAR2(255) NOT NULL, "FILE_NAME" VARCHAR2(128) NOT NULL, "CHANNEL_ID" VARCHAR2(128) DEFAULT 'filesync' NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR2(128) DEFAULT 'filesync_reload' NOT NULL, "LAST_EVENT_TYPE" CHAR(1) NOT NULL, "CRC32_CHECKSUM" NUMBER(38), "FILE_SIZE" NUMBER(38), "FILE_MODIFIED_TIME" NUMBER(38), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "CREATE_TIME" TIMESTAMP NOT NULL ); CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID"); ALTER TABLE "SYM_FILE_SNAPSHOT" ADD CONSTRAINT "SYM_FILE_SNAPSHOT_PK" PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID", "RELATIVE_DIR", "FILE_NAME"); CREATE TABLE "SYM_FILE_TRIGGER"( "TRIGGER_ID" VARCHAR2(128) NOT NULL, "CHANNEL_ID" VARCHAR2(128) DEFAULT 'filesync' NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR2(128) DEFAULT 'filesync_reload' NOT NULL, "BASE_DIR" VARCHAR2(255) NOT NULL, "RECURSE" NUMBER(3) DEFAULT 1 NOT NULL, "INCLUDES_FILES" VARCHAR2(255), "EXCLUDES_FILES" VARCHAR2(255), "SYNC_ON_CREATE" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_MODIFIED" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_CTL_FILE" NUMBER(3) DEFAULT 0 NOT NULL, "DELETE_AFTER_SYNC" NUMBER(3) DEFAULT 0 NOT NULL, "BEFORE_COPY_SCRIPT" CLOB, "AFTER_COPY_SCRIPT" CLOB, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_FILE_TRIGGER" ADD CONSTRAINT "SYM_FILE_TRIGGER_PK" PRIMARY KEY ("TRIGGER_ID"); CREATE TABLE "SYM_FILE_TRIGGER_ROUTER"( "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "INITIAL_LOAD_ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "TARGET_BASE_DIR" VARCHAR2(255), "CONFLICT_STRATEGY" VARCHAR2(128) DEFAULT 'source_wins' NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FILE_TRIGGER_ROUTER_PK" PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID"); CREATE TABLE "SYM_GROUPLET"( "GROUPLET_ID" VARCHAR2(50) NOT NULL, "GROUPLET_LINK_POLICY" CHAR(1) DEFAULT 'I' NOT NULL, "DESCRIPTION" VARCHAR2(255), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_GROUPLET" ADD CONSTRAINT "SYM_GROUPLET_PK" PRIMARY KEY ("GROUPLET_ID"); CREATE TABLE "SYM_GROUPLET_LINK"( "GROUPLET_ID" VARCHAR2(50) NOT NULL, "EXTERNAL_ID" VARCHAR2(50) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_GROUPLET_LINK_PK" PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID"); CREATE TABLE "SYM_INCOMING_BATCH"( "BATCH_ID" NUMBER(38) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "CHANNEL_ID" VARCHAR2(128), "STATUS" CHAR(2), "ERROR_FLAG" NUMBER(3) DEFAULT 0, "NETWORK_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "FILTER_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "DATABASE_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "FAILED_ROW_NUMBER" NUMBER(38) DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" NUMBER(38) DEFAULT 0 NOT NULL, "BYTE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "STATEMENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "FALLBACK_INSERT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "IGNORE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "SKIP_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "SQL_STATE" VARCHAR2(10), "SQL_CODE" NUMBER(22) DEFAULT 0 NOT NULL, "SQL_MESSAGE" CLOB, "LAST_UPDATE_HOSTNAME" VARCHAR2(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP ); CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS"); CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG"); ALTER TABLE "SYM_INCOMING_BATCH" ADD CONSTRAINT "SYM_INCOMING_BATCH_PK" PRIMARY KEY ("BATCH_ID", "NODE_ID"); CREATE TABLE "SYM_INCOMING_ERROR"( "BATCH_ID" NUMBER(38) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "FAILED_ROW_NUMBER" NUMBER(38) NOT NULL, "FAILED_LINE_NUMBER" NUMBER(38) DEFAULT 0 NOT NULL, "TARGET_CATALOG_NAME" VARCHAR2(255), "TARGET_SCHEMA_NAME" VARCHAR2(255), "TARGET_TABLE_NAME" VARCHAR2(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "BINARY_ENCODING" VARCHAR2(10) DEFAULT 'HEX' NOT NULL, "COLUMN_NAMES" CLOB NOT NULL, "PK_COLUMN_NAMES" CLOB NOT NULL, "ROW_DATA" CLOB, "OLD_DATA" CLOB, "CUR_DATA" CLOB, "RESOLVE_DATA" CLOB, "RESOLVE_IGNORE" NUMBER(3) DEFAULT 0, "CONFLICT_ID" VARCHAR2(50), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_INCOMING_ERROR" ADD CONSTRAINT "SYM_INCOMING_ERROR_PK" PRIMARY KEY ("BATCH_ID", "NODE_ID", "FAILED_ROW_NUMBER"); CREATE TABLE "SYM_LOAD_FILTER"( "LOAD_FILTER_ID" VARCHAR2(50) NOT NULL, "LOAD_FILTER_TYPE" VARCHAR2(10) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR2(255), "TARGET_SCHEMA_NAME" VARCHAR2(255), "TARGET_TABLE_NAME" VARCHAR2(255), "FILTER_ON_UPDATE" NUMBER(3) DEFAULT 1 NOT NULL, "FILTER_ON_INSERT" NUMBER(3) DEFAULT 1 NOT NULL, "FILTER_ON_DELETE" NUMBER(3) DEFAULT 1 NOT NULL, "BEFORE_WRITE_SCRIPT" CLOB, "AFTER_WRITE_SCRIPT" CLOB, "BATCH_COMPLETE_SCRIPT" CLOB, "BATCH_COMMIT_SCRIPT" CLOB, "BATCH_ROLLBACK_SCRIPT" CLOB, "HANDLE_ERROR_SCRIPT" CLOB, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LOAD_FILTER_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "FAIL_ON_ERROR" NUMBER(3) DEFAULT 0 NOT NULL ); ALTER TABLE "SYM_LOAD_FILTER" ADD CONSTRAINT "SYM_LOAD_FILTER_PK" PRIMARY KEY ("LOAD_FILTER_ID"); CREATE TABLE "SYM_LOCK"( "LOCK_ACTION" VARCHAR2(50) NOT NULL, "LOCK_TYPE" VARCHAR2(50) NOT NULL, "LOCKING_SERVER_ID" VARCHAR2(255), "LOCK_TIME" TIMESTAMP, "SHARED_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "SHARED_ENABLE" NUMBER(22) DEFAULT 0 NOT NULL, "LAST_LOCK_TIME" TIMESTAMP, "LAST_LOCKING_SERVER_ID" VARCHAR2(255) ); ALTER TABLE "SYM_LOCK" ADD CONSTRAINT "SYM_LOCK_PK" PRIMARY KEY ("LOCK_ACTION"); CREATE TABLE "SYM_NODE"( "NODE_ID" VARCHAR2(50) NOT NULL, "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "EXTERNAL_ID" VARCHAR2(50) NOT NULL, "SYNC_ENABLED" NUMBER(3) DEFAULT 0, "SYNC_URL" VARCHAR2(255), "SCHEMA_VERSION" VARCHAR2(50), "SYMMETRIC_VERSION" VARCHAR2(50), "DATABASE_TYPE" VARCHAR2(50), "DATABASE_VERSION" VARCHAR2(50), "HEARTBEAT_TIME" TIMESTAMP, "TIMEZONE_OFFSET" VARCHAR2(6), "BATCH_TO_SEND_COUNT" NUMBER(22) DEFAULT 0, "BATCH_IN_ERROR_COUNT" NUMBER(22) DEFAULT 0, "CREATED_AT_NODE_ID" VARCHAR2(50), "DEPLOYMENT_TYPE" VARCHAR2(50) ); ALTER TABLE "SYM_NODE" ADD CONSTRAINT "SYM_NODE_PK" PRIMARY KEY ("NODE_ID"); CREATE TABLE "SYM_NODE_COMMUNICATION"( "NODE_ID" VARCHAR2(50) NOT NULL, "COMMUNICATION_TYPE" VARCHAR2(10) NOT NULL, "LOCK_TIME" TIMESTAMP, "LOCKING_SERVER_ID" VARCHAR2(255), "LAST_LOCK_TIME" TIMESTAMP, "LAST_LOCK_MILLIS" NUMBER(38) DEFAULT 0, "SUCCESS_COUNT" NUMBER(38) DEFAULT 0, "FAIL_COUNT" NUMBER(38) DEFAULT 0, "TOTAL_SUCCESS_COUNT" NUMBER(38) DEFAULT 0, "TOTAL_FAIL_COUNT" NUMBER(38) DEFAULT 0, "TOTAL_SUCCESS_MILLIS" NUMBER(38) DEFAULT 0, "TOTAL_FAIL_MILLIS" NUMBER(38) DEFAULT 0 ); ALTER TABLE "SYM_NODE_COMMUNICATION" ADD CONSTRAINT "SYM_NODE_COMMUNICATION_PK" PRIMARY KEY ("NODE_ID", "COMMUNICATION_TYPE"); CREATE TABLE "SYM_NODE_CHANNEL_CTL"( "NODE_ID" VARCHAR2(50) NOT NULL, "CHANNEL_ID" VARCHAR2(128) NOT NULL, "SUSPEND_ENABLED" NUMBER(3) DEFAULT 0, "IGNORE_ENABLED" NUMBER(3) DEFAULT 0, "LAST_EXTRACT_TIME" TIMESTAMP ); ALTER TABLE "SYM_NODE_CHANNEL_CTL" ADD CONSTRAINT "SYM_NODE_CHANNEL_CTL_PK" PRIMARY KEY ("NODE_ID", "CHANNEL_ID"); CREATE TABLE "SYM_NODE_GROUP"( "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "DESCRIPTION" VARCHAR2(255), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ); ALTER TABLE "SYM_NODE_GROUP" ADD CONSTRAINT "SYM_NODE_GROUP_PK" PRIMARY KEY ("NODE_GROUP_ID"); CREATE TABLE "SYM_NODE_GROUP_CHANNEL_WND"( "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "CHANNEL_ID" VARCHAR2(128) NOT NULL, "START_TIME" DATE NOT NULL, "END_TIME" DATE NOT NULL, "ENABLED" NUMBER(3) DEFAULT 0 NOT NULL ); ALTER TABLE "SYM_NODE_GROUP_CHANNEL_WND" ADD CONSTRAINT "SYM_NODE_GROUP_CHANNEL_WND_PK" PRIMARY KEY ("NODE_GROUP_ID", "CHANNEL_ID", "START_TIME", "END_TIME"); CREATE TABLE "SYM_NODE_GROUP_LINK"( "SOURCE_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "DATA_EVENT_ACTION" CHAR(1) DEFAULT 'W' NOT NULL, "SYNC_CONFIG_ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ); ALTER TABLE "SYM_NODE_GROUP_LINK" ADD CONSTRAINT "SYM_NODE_GROUP_LINK_PK" PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID"); CREATE TABLE "SYM_NODE_HOST"( "NODE_ID" VARCHAR2(50) NOT NULL, "HOST_NAME" VARCHAR2(60) NOT NULL, "IP_ADDRESS" VARCHAR2(50), "OS_USER" VARCHAR2(50), "OS_NAME" VARCHAR2(50), "OS_ARCH" VARCHAR2(50), "OS_VERSION" VARCHAR2(50), "AVAILABLE_PROCESSORS" NUMBER(22) DEFAULT 0, "FREE_MEMORY_BYTES" NUMBER(38) DEFAULT 0, "TOTAL_MEMORY_BYTES" NUMBER(38) DEFAULT 0, "MAX_MEMORY_BYTES" NUMBER(38) DEFAULT 0, "JAVA_VERSION" VARCHAR2(50), "JAVA_VENDOR" VARCHAR2(255), "JDBC_VERSION" VARCHAR2(255), "SYMMETRIC_VERSION" VARCHAR2(50), "TIMEZONE_OFFSET" VARCHAR2(6), "HEARTBEAT_TIME" TIMESTAMP, "LAST_RESTART_TIME" TIMESTAMP NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_NODE_HOST" ADD CONSTRAINT "SYM_NODE_HOST_PK" PRIMARY KEY ("NODE_ID", "HOST_NAME"); CREATE TABLE "SYM_NODE_HOST_CHANNEL_STATS"( "NODE_ID" VARCHAR2(50) NOT NULL, "HOST_NAME" VARCHAR2(60) NOT NULL, "CHANNEL_ID" VARCHAR2(128) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "DATA_ROUTED" NUMBER(38) DEFAULT 0, "DATA_UNROUTED" NUMBER(38) DEFAULT 0, "DATA_EVENT_INSERTED" NUMBER(38) DEFAULT 0, "DATA_EXTRACTED" NUMBER(38) DEFAULT 0, "DATA_BYTES_EXTRACTED" NUMBER(38) DEFAULT 0, "DATA_EXTRACTED_ERRORS" NUMBER(38) DEFAULT 0, "DATA_BYTES_SENT" NUMBER(38) DEFAULT 0, "DATA_SENT" NUMBER(38) DEFAULT 0, "DATA_SENT_ERRORS" NUMBER(38) DEFAULT 0, "DATA_LOADED" NUMBER(38) DEFAULT 0, "DATA_BYTES_LOADED" NUMBER(38) DEFAULT 0, "DATA_LOADED_ERRORS" NUMBER(38) DEFAULT 0 ); CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME"); ALTER TABLE "SYM_NODE_HOST_CHANNEL_STATS" ADD CONSTRAINT "SYM_NODE_HOST_CHANNEL_STATS_PK" PRIMARY KEY ("NODE_ID", "HOST_NAME", "CHANNEL_ID", "START_TIME", "END_TIME"); CREATE TABLE "SYM_NODE_HOST_JOB_STATS"( "NODE_ID" VARCHAR2(50) NOT NULL, "HOST_NAME" VARCHAR2(60) NOT NULL, "JOB_NAME" VARCHAR2(50) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "PROCESSED_COUNT" NUMBER(38) DEFAULT 0 ); CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME"); ALTER TABLE "SYM_NODE_HOST_JOB_STATS" ADD CONSTRAINT "SYM_NODE_HOST_JOB_STATS_PK" PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME"); CREATE TABLE "SYM_NODE_HOST_STATS"( "NODE_ID" VARCHAR2(50) NOT NULL, "HOST_NAME" VARCHAR2(60) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "RESTARTED" NUMBER(38) DEFAULT 0 NOT NULL, "NODES_PULLED" NUMBER(38) DEFAULT 0, "TOTAL_NODES_PULL_TIME" NUMBER(38) DEFAULT 0, "NODES_PUSHED" NUMBER(38) DEFAULT 0, "TOTAL_NODES_PUSH_TIME" NUMBER(38) DEFAULT 0, "NODES_REJECTED" NUMBER(38) DEFAULT 0, "NODES_REGISTERED" NUMBER(38) DEFAULT 0, "NODES_LOADED" NUMBER(38) DEFAULT 0, "NODES_DISABLED" NUMBER(38) DEFAULT 0, "PURGED_DATA_ROWS" NUMBER(38) DEFAULT 0, "PURGED_DATA_EVENT_ROWS" NUMBER(38) DEFAULT 0, "PURGED_BATCH_OUTGOING_ROWS" NUMBER(38) DEFAULT 0, "PURGED_BATCH_INCOMING_ROWS" NUMBER(38) DEFAULT 0, "TRIGGERS_CREATED_COUNT" NUMBER(38), "TRIGGERS_REBUILT_COUNT" NUMBER(38), "TRIGGERS_REMOVED_COUNT" NUMBER(38) ); CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME"); ALTER TABLE "SYM_NODE_HOST_STATS" ADD CONSTRAINT "SYM_NODE_HOST_STATS_PK" PRIMARY KEY ("NODE_ID", "HOST_NAME", "START_TIME", "END_TIME"); CREATE TABLE "SYM_NODE_IDENTITY"( "NODE_ID" VARCHAR2(50) NOT NULL ); ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_NODE_IDENTITY_PK" PRIMARY KEY ("NODE_ID"); CREATE TABLE "SYM_NODE_SECURITY"( "NODE_ID" VARCHAR2(50) NOT NULL, "NODE_PASSWORD" VARCHAR2(50) NOT NULL, "REGISTRATION_ENABLED" NUMBER(3) DEFAULT 0, "REGISTRATION_TIME" TIMESTAMP, "INITIAL_LOAD_ENABLED" NUMBER(3) DEFAULT 0, "INITIAL_LOAD_TIME" TIMESTAMP, "INITIAL_LOAD_ID" NUMBER(38), "INITIAL_LOAD_CREATE_BY" VARCHAR2(255), "REV_INITIAL_LOAD_ENABLED" NUMBER(3) DEFAULT 0, "REV_INITIAL_LOAD_TIME" TIMESTAMP, "REV_INITIAL_LOAD_ID" NUMBER(38), "REV_INITIAL_LOAD_CREATE_BY" VARCHAR2(255), "CREATED_AT_NODE_ID" VARCHAR2(50) ); ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_NODE_SECURITY_PK" PRIMARY KEY ("NODE_ID"); CREATE TABLE "SYM_OUTGOING_BATCH"( "BATCH_ID" NUMBER(38) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "CHANNEL_ID" VARCHAR2(128), "STATUS" CHAR(2), "LOAD_ID" NUMBER(38), "EXTRACT_JOB_FLAG" NUMBER(3) DEFAULT 0, "LOAD_FLAG" NUMBER(3) DEFAULT 0, "ERROR_FLAG" NUMBER(3) DEFAULT 0, "COMMON_FLAG" NUMBER(3) DEFAULT 0, "IGNORE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "BYTE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "EXTRACT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "SENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "LOAD_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "DATA_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "RELOAD_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "INSERT_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "UPDATE_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "DELETE_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "OTHER_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "ROUTER_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "NETWORK_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "FILTER_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "LOAD_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "SQL_STATE" VARCHAR2(10), "SQL_CODE" NUMBER(22) DEFAULT 0 NOT NULL, "SQL_MESSAGE" CLOB, "FAILED_DATA_ID" NUMBER(38) DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" NUMBER(38) DEFAULT 0 NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR2(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "CREATE_BY" VARCHAR2(255) ); CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS"); CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS"); CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG"); ALTER TABLE "SYM_OUTGOING_BATCH" ADD CONSTRAINT "SYM_OUTGOING_BATCH_PK" PRIMARY KEY ("BATCH_ID", "NODE_ID"); CREATE TABLE "SYM_REGISTRATION_REDIRECT"( "REGISTRANT_EXTERNAL_ID" VARCHAR2(50) NOT NULL, "REGISTRATION_NODE_ID" VARCHAR2(50) NOT NULL ); ALTER TABLE "SYM_REGISTRATION_REDIRECT" ADD CONSTRAINT "SYM_REGISTRATION_REDIRECT_PK" PRIMARY KEY ("REGISTRANT_EXTERNAL_ID"); CREATE TABLE "SYM_REGISTRATION_REQUEST"( "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "EXTERNAL_ID" VARCHAR2(50) NOT NULL, "STATUS" CHAR(2) NOT NULL, "HOST_NAME" VARCHAR2(60) NOT NULL, "IP_ADDRESS" VARCHAR2(50) NOT NULL, "ATTEMPT_COUNT" NUMBER(22) DEFAULT 0, "REGISTERED_NODE_ID" VARCHAR2(50), "ERROR_MESSAGE" CLOB, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS"); CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS"); ALTER TABLE "SYM_REGISTRATION_REQUEST" ADD CONSTRAINT "SYM_REGISTRATION_REQUEST_PK" PRIMARY KEY ("NODE_GROUP_ID", "EXTERNAL_ID", "CREATE_TIME"); CREATE TABLE "SYM_ROUTER"( "ROUTER_ID" VARCHAR2(50) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR2(255), "TARGET_SCHEMA_NAME" VARCHAR2(255), "TARGET_TABLE_NAME" VARCHAR2(255), "SOURCE_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "ROUTER_TYPE" VARCHAR2(50), "ROUTER_EXPRESSION" CLOB, "SYNC_ON_UPDATE" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_INSERT" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" NUMBER(3) DEFAULT 1 NOT NULL, "USE_SOURCE_CATALOG_SCHEMA" NUMBER(3) DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_ROUTER" ADD CONSTRAINT "SYM_ROUTER_PK" PRIMARY KEY ("ROUTER_ID"); CREATE TABLE "SYM_SEQUENCE"( "SEQUENCE_NAME" VARCHAR2(50) NOT NULL, "CURRENT_VALUE" NUMBER(38) DEFAULT 0 NOT NULL, "INCREMENT_BY" NUMBER(22) DEFAULT 1 NOT NULL, "MIN_VALUE" NUMBER(38) DEFAULT 1 NOT NULL, "MAX_VALUE" NUMBER(38) DEFAULT 9999999999 NOT NULL, "CYCLE" NUMBER(3) DEFAULT 0, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_SEQUENCE" ADD CONSTRAINT "SYM_SEQUENCE_PK" PRIMARY KEY ("SEQUENCE_NAME"); CREATE TABLE "SYM_TABLE_RELOAD_REQUEST"( "TARGET_NODE_ID" VARCHAR2(50) NOT NULL, "SOURCE_NODE_ID" VARCHAR2(50) NOT NULL, "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "RELOAD_SELECT" CLOB, "RELOAD_DELETE_STMT" CLOB, "RELOAD_ENABLED" NUMBER(3) DEFAULT 0, "RELOAD_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_TABLE_RELOAD_REQUEST" ADD CONSTRAINT "SYM_TABLE_RELOAD_REQUEST_PK" PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID"); CREATE TABLE "SYM_TRANSFORM_TABLE"( "TRANSFORM_ID" VARCHAR2(50) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TRANSFORM_POINT" VARCHAR2(10) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR2(255), "SOURCE_SCHEMA_NAME" VARCHAR2(255), "SOURCE_TABLE_NAME" VARCHAR2(255) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR2(255), "TARGET_SCHEMA_NAME" VARCHAR2(255), "TARGET_TABLE_NAME" VARCHAR2(255), "UPDATE_FIRST" NUMBER(3) DEFAULT 0, "DELETE_ACTION" VARCHAR2(10) NOT NULL, "TRANSFORM_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "COLUMN_POLICY" VARCHAR2(10) DEFAULT 'SPECIFIED' NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ); ALTER TABLE "SYM_TRANSFORM_TABLE" ADD CONSTRAINT "SYM_TRANSFORM_TABLE_PK" PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID"); CREATE TABLE "SYM_TRANSFORM_COLUMN"( "TRANSFORM_ID" VARCHAR2(50) NOT NULL, "INCLUDE_ON" CHAR(1) DEFAULT '*' NOT NULL, "TARGET_COLUMN_NAME" VARCHAR2(128) NOT NULL, "SOURCE_COLUMN_NAME" VARCHAR2(128), "PK" NUMBER(3) DEFAULT 0, "TRANSFORM_TYPE" VARCHAR2(50) DEFAULT 'copy', "TRANSFORM_EXPRESSION" CLOB, "TRANSFORM_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ); ALTER TABLE "SYM_TRANSFORM_COLUMN" ADD CONSTRAINT "SYM_TRANSFORM_COLUMN_PK" PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME"); CREATE TABLE "SYM_TRIGGER"( "TRIGGER_ID" VARCHAR2(128) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR2(255), "SOURCE_SCHEMA_NAME" VARCHAR2(255), "SOURCE_TABLE_NAME" VARCHAR2(255) NOT NULL, "CHANNEL_ID" VARCHAR2(128) NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR2(128) DEFAULT 'reload' NOT NULL, "SYNC_ON_UPDATE" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_INSERT" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_INCOMING_BATCH" NUMBER(3) DEFAULT 0 NOT NULL, "NAME_FOR_UPDATE_TRIGGER" VARCHAR2(255), "NAME_FOR_INSERT_TRIGGER" VARCHAR2(255), "NAME_FOR_DELETE_TRIGGER" VARCHAR2(255), "SYNC_ON_UPDATE_CONDITION" CLOB, "SYNC_ON_INSERT_CONDITION" CLOB, "SYNC_ON_DELETE_CONDITION" CLOB, "CUSTOM_ON_UPDATE_TEXT" CLOB, "CUSTOM_ON_INSERT_TEXT" CLOB, "CUSTOM_ON_DELETE_TEXT" CLOB, "EXTERNAL_SELECT" CLOB, "TX_ID_EXPRESSION" CLOB, "CHANNEL_EXPRESSION" CLOB, "EXCLUDED_COLUMN_NAMES" CLOB, "SYNC_KEY_NAMES" CLOB, "USE_STREAM_LOBS" NUMBER(3) DEFAULT 0 NOT NULL, "USE_CAPTURE_LOBS" NUMBER(3) DEFAULT 0 NOT NULL, "USE_CAPTURE_OLD_DATA" NUMBER(3) DEFAULT 1 NOT NULL, "USE_HANDLE_KEY_UPDATES" NUMBER(3) DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_TRIGGER_PK" PRIMARY KEY ("TRIGGER_ID"); CREATE TABLE "SYM_TRIGGER_HIST"( "TRIGGER_HIST_ID" NUMBER(22) NOT NULL, "TRIGGER_ID" VARCHAR2(128) NOT NULL, "SOURCE_TABLE_NAME" VARCHAR2(255) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR2(255), "SOURCE_SCHEMA_NAME" VARCHAR2(255), "NAME_FOR_UPDATE_TRIGGER" VARCHAR2(255), "NAME_FOR_INSERT_TRIGGER" VARCHAR2(255), "NAME_FOR_DELETE_TRIGGER" VARCHAR2(255), "TABLE_HASH" NUMBER(38) DEFAULT 0 NOT NULL, "TRIGGER_ROW_HASH" NUMBER(38) DEFAULT 0 NOT NULL, "TRIGGER_TEMPLATE_HASH" NUMBER(38) DEFAULT 0 NOT NULL, "COLUMN_NAMES" CLOB NOT NULL, "PK_COLUMN_NAMES" CLOB NOT NULL, "LAST_TRIGGER_BUILD_REASON" CHAR(1) NOT NULL, "ERROR_MESSAGE" CLOB, "CREATE_TIME" TIMESTAMP NOT NULL, "INACTIVE_TIME" TIMESTAMP ); ALTER TABLE "SYM_TRIGGER_HIST" ADD CONSTRAINT "SYM_TRIGGER_HIST_PK" PRIMARY KEY ("TRIGGER_HIST_ID"); CREATE TABLE "SYM_TRIGGER_ROUTER"( "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "INITIAL_LOAD_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "INITIAL_LOAD_SELECT" CLOB, "INITIAL_LOAD_DELETE_STMT" CLOB, "INITIAL_LOAD_BATCH_COUNT" NUMBER(22) DEFAULT 1, "PING_BACK_ENABLED" NUMBER(3) DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_TRIGGER_ROUTER_PK" PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID"); CREATE TABLE "SYM_TRIGGER_ROUTER_GROUPLET"( "GROUPLET_ID" VARCHAR2(50) NOT NULL, "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "APPLIES_WHEN" CHAR(1) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ); ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_TRIGGER_ROUTER_GROUPLET_PK" PRIMARY KEY ("GROUPLET_ID", "TRIGGER_ID", "ROUTER_ID", "APPLIES_WHEN"); 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"); ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_FTR_2_FTRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_FILE_TRIGGER" ("TRIGGER_ID"); ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_FTR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID"); ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_FK_GPLTLNK_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID"); 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"); 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"); ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_FK_IDENT_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID"); ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_FK_SEC_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID"); 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"); 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"); ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID"); ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_RLD_CHNL" FOREIGN KEY ("RELOAD_CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID"); ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_TRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_TRIGGER" ("TRIGGER_ID"); ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID"); ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_FK_TRGPLT_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID"); 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"); 2014-10-09 10:16:39,271 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "NEPT"."SYM_PARAMETER" MODIFY ("EXTERNAL_ID" NOT NULL ) 2014-10-09 10:16:39,287 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "NEPT"."SYM_PARAMETER" MODIFY ("NODE_GROUP_ID" NOT NULL ) 2014-10-09 10:16:39,287 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "NEPT"."SYM_PARAMETER" MODIFY ("PARAM_KEY" NOT NULL ) 2014-10-09 10:16:39,318 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_PARAMETER" ADD CONSTRAINT "SYM_PARAMETER_PK" PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY") 2014-10-09 10:16:39,365 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_CHANNEL"( "CHANNEL_ID" VARCHAR2(128) NOT NULL, "PROCESSING_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "MAX_BATCH_SIZE" NUMBER(22) DEFAULT 1000 NOT NULL, "MAX_BATCH_TO_SEND" NUMBER(22) DEFAULT 60 NOT NULL, "MAX_DATA_TO_ROUTE" NUMBER(22) DEFAULT 100000 NOT NULL, "EXTRACT_PERIOD_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "USE_OLD_DATA_TO_ROUTE" NUMBER(3) DEFAULT 1 NOT NULL, "USE_ROW_DATA_TO_ROUTE" NUMBER(3) DEFAULT 1 NOT NULL, "USE_PK_DATA_TO_ROUTE" NUMBER(3) DEFAULT 1 NOT NULL, "RELOAD_FLAG" NUMBER(3) DEFAULT 0 NOT NULL, "FILE_SYNC_FLAG" NUMBER(3) DEFAULT 0 NOT NULL, "CONTAINS_BIG_LOB" NUMBER(3) DEFAULT 0 NOT NULL, "BATCH_ALGORITHM" VARCHAR2(50) DEFAULT 'default' NOT NULL, "DATA_LOADER_TYPE" VARCHAR2(50) DEFAULT 'default' NOT NULL, "DESCRIPTION" VARCHAR2(255), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2014-10-09 10:16:39,381 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_CHANNEL" ADD CONSTRAINT "SYM_CHANNEL_PK" PRIMARY KEY ("CHANNEL_ID") 2014-10-09 10:16:39,428 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_CONFLICT"( "CONFLICT_ID" VARCHAR2(50) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_CHANNEL_ID" VARCHAR2(128), "TARGET_CATALOG_NAME" VARCHAR2(255), "TARGET_SCHEMA_NAME" VARCHAR2(255), "TARGET_TABLE_NAME" VARCHAR2(255), "DETECT_TYPE" VARCHAR2(128) NOT NULL, "DETECT_EXPRESSION" CLOB, "RESOLVE_TYPE" VARCHAR2(128) NOT NULL, "PING_BACK" VARCHAR2(128) NOT NULL, "RESOLVE_CHANGES_ONLY" NUMBER(3) DEFAULT 0, "RESOLVE_ROW_ONLY" NUMBER(3) DEFAULT 0, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:39,443 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_CONFLICT" ADD CONSTRAINT "SYM_CONFLICT_PK" PRIMARY KEY ("CONFLICT_ID") 2014-10-09 10:16:39,443 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE SEQUENCE "SEQ_SYM_DATA_DATA_ID" CACHE 1000 ORDER 2014-10-09 10:16:39,490 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_DATA"( "DATA_ID" NUMBER(38) NOT NULL , "TABLE_NAME" VARCHAR2(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "ROW_DATA" CLOB, "PK_DATA" CLOB, "OLD_DATA" CLOB, "TRIGGER_HIST_ID" NUMBER(22) NOT NULL, "CHANNEL_ID" VARCHAR2(128), "TRANSACTION_ID" VARCHAR2(255), "SOURCE_NODE_ID" VARCHAR2(50), "EXTERNAL_DATA" VARCHAR2(50), "NODE_LIST" VARCHAR2(255), "CREATE_TIME" TIMESTAMP ) 2014-10-09 10:16:39,490 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID") 2014-10-09 10:16:39,506 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_DATA" ADD CONSTRAINT "SYM_DATA_PK" PRIMARY KEY ("DATA_ID") 2014-10-09 10:16:39,725 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE OR REPLACE TRIGGER "TRG_SYM_DATA_DATA_ID" BEFORE INSERT ON "SYM_DATA" FOR EACH ROW WHEN (new."DATA_ID" IS NULL) BEGIN SELECT "SEQ_SYM_DATA_DATA_ID".nextval INTO :new."DATA_ID" FROM dual; END; 2014-10-09 10:16:39,740 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_DATA_EVENT"( "DATA_ID" NUMBER(38) NOT NULL, "BATCH_ID" NUMBER(38) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "CREATE_TIME" TIMESTAMP ) 2014-10-09 10:16:39,740 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID") 2014-10-09 10:16:39,756 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_DATA_EVENT" ADD CONSTRAINT "SYM_DATA_EVENT_PK" PRIMARY KEY ("DATA_ID", "BATCH_ID", "ROUTER_ID") 2014-10-09 10:16:39,771 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_DATA_GAP"( "START_ID" NUMBER(38) NOT NULL, "END_ID" NUMBER(38) NOT NULL, "STATUS" CHAR(2), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR2(255), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:39,787 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_DG_STATUS" ON "SYM_DATA_GAP" ("STATUS") 2014-10-09 10:16:39,803 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_DATA_GAP" ADD CONSTRAINT "SYM_DATA_GAP_PK" PRIMARY KEY ("START_ID", "END_ID") 2014-10-09 10:16:39,834 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_EXTRACT_REQUEST"( "REQUEST_ID" NUMBER(38) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "STATUS" CHAR(2), "START_BATCH_ID" NUMBER(38) NOT NULL, "END_BATCH_ID" NUMBER(38) NOT NULL, "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP ) 2014-10-09 10:16:39,850 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_EXTRACT_REQUEST" ADD CONSTRAINT "SYM_EXTRACT_REQUEST_PK" PRIMARY KEY ("REQUEST_ID") 2014-10-09 10:16:39,865 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_FILE_INCOMING"( "RELATIVE_DIR" VARCHAR2(255) NOT NULL, "FILE_NAME" VARCHAR2(128) NOT NULL, "LAST_EVENT_TYPE" CHAR(1) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "FILE_MODIFIED_TIME" NUMBER(38) ) 2014-10-09 10:16:39,881 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_FILE_INCOMING" ADD CONSTRAINT "SYM_FILE_INCOMING_PK" PRIMARY KEY ("RELATIVE_DIR", "FILE_NAME") 2014-10-09 10:16:39,896 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_FILE_SNAPSHOT"( "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "RELATIVE_DIR" VARCHAR2(255) NOT NULL, "FILE_NAME" VARCHAR2(128) NOT NULL, "CHANNEL_ID" VARCHAR2(128) DEFAULT 'filesync' NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR2(128) DEFAULT 'filesync_reload' NOT NULL, "LAST_EVENT_TYPE" CHAR(1) NOT NULL, "CRC32_CHECKSUM" NUMBER(38), "FILE_SIZE" NUMBER(38), "FILE_MODIFIED_TIME" NUMBER(38), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "CREATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:39,912 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID") 2014-10-09 10:16:39,928 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_FILE_SNAPSHOT" ADD CONSTRAINT "SYM_FILE_SNAPSHOT_PK" PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID", "RELATIVE_DIR", "FILE_NAME") 2014-10-09 10:16:39,990 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_FILE_TRIGGER"( "TRIGGER_ID" VARCHAR2(128) NOT NULL, "CHANNEL_ID" VARCHAR2(128) DEFAULT 'filesync' NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR2(128) DEFAULT 'filesync_reload' NOT NULL, "BASE_DIR" VARCHAR2(255) NOT NULL, "RECURSE" NUMBER(3) DEFAULT 1 NOT NULL, "INCLUDES_FILES" VARCHAR2(255), "EXCLUDES_FILES" VARCHAR2(255), "SYNC_ON_CREATE" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_MODIFIED" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_CTL_FILE" NUMBER(3) DEFAULT 0 NOT NULL, "DELETE_AFTER_SYNC" NUMBER(3) DEFAULT 0 NOT NULL, "BEFORE_COPY_SCRIPT" CLOB, "AFTER_COPY_SCRIPT" CLOB, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:40,006 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER" ADD CONSTRAINT "SYM_FILE_TRIGGER_PK" PRIMARY KEY ("TRIGGER_ID") 2014-10-09 10:16:40,037 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_FILE_TRIGGER_ROUTER"( "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "INITIAL_LOAD_ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "TARGET_BASE_DIR" VARCHAR2(255), "CONFLICT_STRATEGY" VARCHAR2(128) DEFAULT 'source_wins' NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:40,053 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FILE_TRIGGER_ROUTER_PK" PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") 2014-10-09 10:16:40,068 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_GROUPLET"( "GROUPLET_ID" VARCHAR2(50) NOT NULL, "GROUPLET_LINK_POLICY" CHAR(1) DEFAULT 'I' NOT NULL, "DESCRIPTION" VARCHAR2(255), "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:40,084 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_GROUPLET" ADD CONSTRAINT "SYM_GROUPLET_PK" PRIMARY KEY ("GROUPLET_ID") 2014-10-09 10:16:40,100 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_GROUPLET_LINK"( "GROUPLET_ID" VARCHAR2(50) NOT NULL, "EXTERNAL_ID" VARCHAR2(50) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:40,115 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_GROUPLET_LINK_PK" PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID") 2014-10-09 10:16:40,178 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_INCOMING_BATCH"( "BATCH_ID" NUMBER(38) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "CHANNEL_ID" VARCHAR2(128), "STATUS" CHAR(2), "ERROR_FLAG" NUMBER(3) DEFAULT 0, "NETWORK_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "FILTER_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "DATABASE_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "FAILED_ROW_NUMBER" NUMBER(38) DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" NUMBER(38) DEFAULT 0 NOT NULL, "BYTE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "STATEMENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "FALLBACK_INSERT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "IGNORE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "SKIP_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "SQL_STATE" VARCHAR2(10), "SQL_CODE" NUMBER(22) DEFAULT 0 NOT NULL, "SQL_MESSAGE" CLOB, "LAST_UPDATE_HOSTNAME" VARCHAR2(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP ) 2014-10-09 10:16:40,193 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS") 2014-10-09 10:16:40,193 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG") 2014-10-09 10:16:40,209 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_INCOMING_BATCH" ADD CONSTRAINT "SYM_INCOMING_BATCH_PK" PRIMARY KEY ("BATCH_ID", "NODE_ID") 2014-10-09 10:16:40,271 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_INCOMING_ERROR"( "BATCH_ID" NUMBER(38) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "FAILED_ROW_NUMBER" NUMBER(38) NOT NULL, "FAILED_LINE_NUMBER" NUMBER(38) DEFAULT 0 NOT NULL, "TARGET_CATALOG_NAME" VARCHAR2(255), "TARGET_SCHEMA_NAME" VARCHAR2(255), "TARGET_TABLE_NAME" VARCHAR2(255) NOT NULL, "EVENT_TYPE" CHAR(1) NOT NULL, "BINARY_ENCODING" VARCHAR2(10) DEFAULT 'HEX' NOT NULL, "COLUMN_NAMES" CLOB NOT NULL, "PK_COLUMN_NAMES" CLOB NOT NULL, "ROW_DATA" CLOB, "OLD_DATA" CLOB, "CUR_DATA" CLOB, "RESOLVE_DATA" CLOB, "RESOLVE_IGNORE" NUMBER(3) DEFAULT 0, "CONFLICT_ID" VARCHAR2(50), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:40,303 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_INCOMING_ERROR" ADD CONSTRAINT "SYM_INCOMING_ERROR_PK" PRIMARY KEY ("BATCH_ID", "NODE_ID", "FAILED_ROW_NUMBER") 2014-10-09 10:16:40,412 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_LOAD_FILTER"( "LOAD_FILTER_ID" VARCHAR2(50) NOT NULL, "LOAD_FILTER_TYPE" VARCHAR2(10) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR2(255), "TARGET_SCHEMA_NAME" VARCHAR2(255), "TARGET_TABLE_NAME" VARCHAR2(255), "FILTER_ON_UPDATE" NUMBER(3) DEFAULT 1 NOT NULL, "FILTER_ON_INSERT" NUMBER(3) DEFAULT 1 NOT NULL, "FILTER_ON_DELETE" NUMBER(3) DEFAULT 1 NOT NULL, "BEFORE_WRITE_SCRIPT" CLOB, "AFTER_WRITE_SCRIPT" CLOB, "BATCH_COMPLETE_SCRIPT" CLOB, "BATCH_COMMIT_SCRIPT" CLOB, "BATCH_ROLLBACK_SCRIPT" CLOB, "HANDLE_ERROR_SCRIPT" CLOB, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "LOAD_FILTER_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "FAIL_ON_ERROR" NUMBER(3) DEFAULT 0 NOT NULL ) 2014-10-09 10:16:40,428 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_LOAD_FILTER" ADD CONSTRAINT "SYM_LOAD_FILTER_PK" PRIMARY KEY ("LOAD_FILTER_ID") 2014-10-09 10:16:40,443 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_LOCK"( "LOCK_ACTION" VARCHAR2(50) NOT NULL, "LOCK_TYPE" VARCHAR2(50) NOT NULL, "LOCKING_SERVER_ID" VARCHAR2(255), "LOCK_TIME" TIMESTAMP, "SHARED_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "SHARED_ENABLE" NUMBER(22) DEFAULT 0 NOT NULL, "LAST_LOCK_TIME" TIMESTAMP, "LAST_LOCKING_SERVER_ID" VARCHAR2(255) ) 2014-10-09 10:16:40,459 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_LOCK" ADD CONSTRAINT "SYM_LOCK_PK" PRIMARY KEY ("LOCK_ACTION") 2014-10-09 10:16:40,474 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE"( "NODE_ID" VARCHAR2(50) NOT NULL, "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "EXTERNAL_ID" VARCHAR2(50) NOT NULL, "SYNC_ENABLED" NUMBER(3) DEFAULT 0, "SYNC_URL" VARCHAR2(255), "SCHEMA_VERSION" VARCHAR2(50), "SYMMETRIC_VERSION" VARCHAR2(50), "DATABASE_TYPE" VARCHAR2(50), "DATABASE_VERSION" VARCHAR2(50), "HEARTBEAT_TIME" TIMESTAMP, "TIMEZONE_OFFSET" VARCHAR2(6), "BATCH_TO_SEND_COUNT" NUMBER(22) DEFAULT 0, "BATCH_IN_ERROR_COUNT" NUMBER(22) DEFAULT 0, "CREATED_AT_NODE_ID" VARCHAR2(50), "DEPLOYMENT_TYPE" VARCHAR2(50) ) 2014-10-09 10:16:40,490 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE" ADD CONSTRAINT "SYM_NODE_PK" PRIMARY KEY ("NODE_ID") 2014-10-09 10:16:40,506 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_COMMUNICATION"( "NODE_ID" VARCHAR2(50) NOT NULL, "COMMUNICATION_TYPE" VARCHAR2(10) NOT NULL, "LOCK_TIME" TIMESTAMP, "LOCKING_SERVER_ID" VARCHAR2(255), "LAST_LOCK_TIME" TIMESTAMP, "LAST_LOCK_MILLIS" NUMBER(38) DEFAULT 0, "SUCCESS_COUNT" NUMBER(38) DEFAULT 0, "FAIL_COUNT" NUMBER(38) DEFAULT 0, "TOTAL_SUCCESS_COUNT" NUMBER(38) DEFAULT 0, "TOTAL_FAIL_COUNT" NUMBER(38) DEFAULT 0, "TOTAL_SUCCESS_MILLIS" NUMBER(38) DEFAULT 0, "TOTAL_FAIL_MILLIS" NUMBER(38) DEFAULT 0 ) 2014-10-09 10:16:40,537 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_COMMUNICATION" ADD CONSTRAINT "SYM_NODE_COMMUNICATION_PK" PRIMARY KEY ("NODE_ID", "COMMUNICATION_TYPE") 2014-10-09 10:16:40,537 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_CHANNEL_CTL"( "NODE_ID" VARCHAR2(50) NOT NULL, "CHANNEL_ID" VARCHAR2(128) NOT NULL, "SUSPEND_ENABLED" NUMBER(3) DEFAULT 0, "IGNORE_ENABLED" NUMBER(3) DEFAULT 0, "LAST_EXTRACT_TIME" TIMESTAMP ) 2014-10-09 10:16:40,568 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_CHANNEL_CTL" ADD CONSTRAINT "SYM_NODE_CHANNEL_CTL_PK" PRIMARY KEY ("NODE_ID", "CHANNEL_ID") 2014-10-09 10:16:40,568 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_GROUP"( "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "DESCRIPTION" VARCHAR2(255), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2014-10-09 10:16:40,584 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_GROUP" ADD CONSTRAINT "SYM_NODE_GROUP_PK" PRIMARY KEY ("NODE_GROUP_ID") 2014-10-09 10:16:40,615 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_GROUP_CHANNEL_WND"( "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "CHANNEL_ID" VARCHAR2(128) NOT NULL, "START_TIME" DATE NOT NULL, "END_TIME" DATE NOT NULL, "ENABLED" NUMBER(3) DEFAULT 0 NOT NULL ) 2014-10-09 10:16:40,631 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_GROUP_CHANNEL_WND" ADD CONSTRAINT "SYM_NODE_GROUP_CHANNEL_WND_PK" PRIMARY KEY ("NODE_GROUP_ID", "CHANNEL_ID", "START_TIME", "END_TIME") 2014-10-09 10:16:40,646 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_GROUP_LINK"( "SOURCE_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "DATA_EVENT_ACTION" CHAR(1) DEFAULT 'W' NOT NULL, "SYNC_CONFIG_ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2014-10-09 10:16:40,678 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_GROUP_LINK" ADD CONSTRAINT "SYM_NODE_GROUP_LINK_PK" PRIMARY KEY ("SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") 2014-10-09 10:16:40,693 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_HOST"( "NODE_ID" VARCHAR2(50) NOT NULL, "HOST_NAME" VARCHAR2(60) NOT NULL, "IP_ADDRESS" VARCHAR2(50), "OS_USER" VARCHAR2(50), "OS_NAME" VARCHAR2(50), "OS_ARCH" VARCHAR2(50), "OS_VERSION" VARCHAR2(50), "AVAILABLE_PROCESSORS" NUMBER(22) DEFAULT 0, "FREE_MEMORY_BYTES" NUMBER(38) DEFAULT 0, "TOTAL_MEMORY_BYTES" NUMBER(38) DEFAULT 0, "MAX_MEMORY_BYTES" NUMBER(38) DEFAULT 0, "JAVA_VERSION" VARCHAR2(50), "JAVA_VENDOR" VARCHAR2(255), "JDBC_VERSION" VARCHAR2(255), "SYMMETRIC_VERSION" VARCHAR2(50), "TIMEZONE_OFFSET" VARCHAR2(6), "HEARTBEAT_TIME" TIMESTAMP, "LAST_RESTART_TIME" TIMESTAMP NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:40,724 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_HOST" ADD CONSTRAINT "SYM_NODE_HOST_PK" PRIMARY KEY ("NODE_ID", "HOST_NAME") 2014-10-09 10:16:40,740 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_HOST_CHANNEL_STATS"( "NODE_ID" VARCHAR2(50) NOT NULL, "HOST_NAME" VARCHAR2(60) NOT NULL, "CHANNEL_ID" VARCHAR2(128) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "DATA_ROUTED" NUMBER(38) DEFAULT 0, "DATA_UNROUTED" NUMBER(38) DEFAULT 0, "DATA_EVENT_INSERTED" NUMBER(38) DEFAULT 0, "DATA_EXTRACTED" NUMBER(38) DEFAULT 0, "DATA_BYTES_EXTRACTED" NUMBER(38) DEFAULT 0, "DATA_EXTRACTED_ERRORS" NUMBER(38) DEFAULT 0, "DATA_BYTES_SENT" NUMBER(38) DEFAULT 0, "DATA_SENT" NUMBER(38) DEFAULT 0, "DATA_SENT_ERRORS" NUMBER(38) DEFAULT 0, "DATA_LOADED" NUMBER(38) DEFAULT 0, "DATA_BYTES_LOADED" NUMBER(38) DEFAULT 0, "DATA_LOADED_ERRORS" NUMBER(38) DEFAULT 0 ) 2014-10-09 10:16:40,771 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2014-10-09 10:16:40,787 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_HOST_CHANNEL_STATS" ADD CONSTRAINT "SYM_NODE_HOST_CHANNEL_STATS_PK" PRIMARY KEY ("NODE_ID", "HOST_NAME", "CHANNEL_ID", "START_TIME", "END_TIME") 2014-10-09 10:16:40,803 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_HOST_JOB_STATS"( "NODE_ID" VARCHAR2(50) NOT NULL, "HOST_NAME" VARCHAR2(60) NOT NULL, "JOB_NAME" VARCHAR2(50) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "PROCESSED_COUNT" NUMBER(38) DEFAULT 0 ) 2014-10-09 10:16:40,818 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2014-10-09 10:16:40,834 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_HOST_JOB_STATS" ADD CONSTRAINT "SYM_NODE_HOST_JOB_STATS_PK" PRIMARY KEY ("NODE_ID", "HOST_NAME", "JOB_NAME", "START_TIME", "END_TIME") 2014-10-09 10:16:40,865 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_HOST_STATS"( "NODE_ID" VARCHAR2(50) NOT NULL, "HOST_NAME" VARCHAR2(60) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "RESTARTED" NUMBER(38) DEFAULT 0 NOT NULL, "NODES_PULLED" NUMBER(38) DEFAULT 0, "TOTAL_NODES_PULL_TIME" NUMBER(38) DEFAULT 0, "NODES_PUSHED" NUMBER(38) DEFAULT 0, "TOTAL_NODES_PUSH_TIME" NUMBER(38) DEFAULT 0, "NODES_REJECTED" NUMBER(38) DEFAULT 0, "NODES_REGISTERED" NUMBER(38) DEFAULT 0, "NODES_LOADED" NUMBER(38) DEFAULT 0, "NODES_DISABLED" NUMBER(38) DEFAULT 0, "PURGED_DATA_ROWS" NUMBER(38) DEFAULT 0, "PURGED_DATA_EVENT_ROWS" NUMBER(38) DEFAULT 0, "PURGED_BATCH_OUTGOING_ROWS" NUMBER(38) DEFAULT 0, "PURGED_BATCH_INCOMING_ROWS" NUMBER(38) DEFAULT 0, "TRIGGERS_CREATED_COUNT" NUMBER(38), "TRIGGERS_REBUILT_COUNT" NUMBER(38), "TRIGGERS_REMOVED_COUNT" NUMBER(38) ) 2014-10-09 10:16:40,881 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2014-10-09 10:16:40,896 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_HOST_STATS" ADD CONSTRAINT "SYM_NODE_HOST_STATS_PK" PRIMARY KEY ("NODE_ID", "HOST_NAME", "START_TIME", "END_TIME") 2014-10-09 10:16:40,896 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"( "NODE_ID" VARCHAR2(50) NOT NULL ) 2014-10-09 10:16:40,912 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_NODE_IDENTITY_PK" PRIMARY KEY ("NODE_ID") 2014-10-09 10:16:40,928 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_NODE_SECURITY"( "NODE_ID" VARCHAR2(50) NOT NULL, "NODE_PASSWORD" VARCHAR2(50) NOT NULL, "REGISTRATION_ENABLED" NUMBER(3) DEFAULT 0, "REGISTRATION_TIME" TIMESTAMP, "INITIAL_LOAD_ENABLED" NUMBER(3) DEFAULT 0, "INITIAL_LOAD_TIME" TIMESTAMP, "INITIAL_LOAD_ID" NUMBER(38), "INITIAL_LOAD_CREATE_BY" VARCHAR2(255), "REV_INITIAL_LOAD_ENABLED" NUMBER(3) DEFAULT 0, "REV_INITIAL_LOAD_TIME" TIMESTAMP, "REV_INITIAL_LOAD_ID" NUMBER(38), "REV_INITIAL_LOAD_CREATE_BY" VARCHAR2(255), "CREATED_AT_NODE_ID" VARCHAR2(50) ) 2014-10-09 10:16:40,943 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_NODE_SECURITY_PK" PRIMARY KEY ("NODE_ID") 2014-10-09 10:16:41,037 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_OUTGOING_BATCH"( "BATCH_ID" NUMBER(38) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "CHANNEL_ID" VARCHAR2(128), "STATUS" CHAR(2), "LOAD_ID" NUMBER(38), "EXTRACT_JOB_FLAG" NUMBER(3) DEFAULT 0, "LOAD_FLAG" NUMBER(3) DEFAULT 0, "ERROR_FLAG" NUMBER(3) DEFAULT 0, "COMMON_FLAG" NUMBER(3) DEFAULT 0, "IGNORE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "BYTE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "EXTRACT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "SENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "LOAD_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "DATA_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "RELOAD_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "INSERT_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "UPDATE_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "DELETE_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "OTHER_EVENT_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "ROUTER_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "NETWORK_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "FILTER_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "LOAD_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" NUMBER(38) DEFAULT 0 NOT NULL, "SQL_STATE" VARCHAR2(10), "SQL_CODE" NUMBER(22) DEFAULT 0 NOT NULL, "SQL_MESSAGE" CLOB, "FAILED_DATA_ID" NUMBER(38) DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" NUMBER(38) DEFAULT 0 NOT NULL, "LAST_UPDATE_HOSTNAME" VARCHAR2(255), "LAST_UPDATE_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "CREATE_BY" VARCHAR2(255) ) 2014-10-09 10:16:41,053 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS") 2014-10-09 10:16:41,068 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS") 2014-10-09 10:16:41,068 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG") 2014-10-09 10:16:41,084 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_OUTGOING_BATCH" ADD CONSTRAINT "SYM_OUTGOING_BATCH_PK" PRIMARY KEY ("BATCH_ID", "NODE_ID") 2014-10-09 10:16:41,099 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_REGISTRATION_REDIRECT"( "REGISTRANT_EXTERNAL_ID" VARCHAR2(50) NOT NULL, "REGISTRATION_NODE_ID" VARCHAR2(50) NOT NULL ) 2014-10-09 10:16:41,131 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_REGISTRATION_REDIRECT" ADD CONSTRAINT "SYM_REGISTRATION_REDIRECT_PK" PRIMARY KEY ("REGISTRANT_EXTERNAL_ID") 2014-10-09 10:16:41,162 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_REGISTRATION_REQUEST"( "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "EXTERNAL_ID" VARCHAR2(50) NOT NULL, "STATUS" CHAR(2) NOT NULL, "HOST_NAME" VARCHAR2(60) NOT NULL, "IP_ADDRESS" VARCHAR2(50) NOT NULL, "ATTEMPT_COUNT" NUMBER(22) DEFAULT 0, "REGISTERED_NODE_ID" VARCHAR2(50), "ERROR_MESSAGE" CLOB, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:41,162 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS") 2014-10-09 10:16:41,178 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS") 2014-10-09 10:16:41,193 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_REGISTRATION_REQUEST" ADD CONSTRAINT "SYM_REGISTRATION_REQUEST_PK" PRIMARY KEY ("NODE_GROUP_ID", "EXTERNAL_ID", "CREATE_TIME") 2014-10-09 10:16:41,224 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_ROUTER"( "ROUTER_ID" VARCHAR2(50) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR2(255), "TARGET_SCHEMA_NAME" VARCHAR2(255), "TARGET_TABLE_NAME" VARCHAR2(255), "SOURCE_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "ROUTER_TYPE" VARCHAR2(50), "ROUTER_EXPRESSION" CLOB, "SYNC_ON_UPDATE" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_INSERT" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" NUMBER(3) DEFAULT 1 NOT NULL, "USE_SOURCE_CATALOG_SCHEMA" NUMBER(3) DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:41,240 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_ROUTER" ADD CONSTRAINT "SYM_ROUTER_PK" PRIMARY KEY ("ROUTER_ID") 2014-10-09 10:16:41,271 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_SEQUENCE"( "SEQUENCE_NAME" VARCHAR2(50) NOT NULL, "CURRENT_VALUE" NUMBER(38) DEFAULT 0 NOT NULL, "INCREMENT_BY" NUMBER(22) DEFAULT 1 NOT NULL, "MIN_VALUE" NUMBER(38) DEFAULT 1 NOT NULL, "MAX_VALUE" NUMBER(38) DEFAULT 9999999999 NOT NULL, "CYCLE" NUMBER(3) DEFAULT 0, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:41,287 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_SEQUENCE" ADD CONSTRAINT "SYM_SEQUENCE_PK" PRIMARY KEY ("SEQUENCE_NAME") 2014-10-09 10:16:41,318 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_TABLE_RELOAD_REQUEST"( "TARGET_NODE_ID" VARCHAR2(50) NOT NULL, "SOURCE_NODE_ID" VARCHAR2(50) NOT NULL, "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "RELOAD_SELECT" CLOB, "RELOAD_DELETE_STMT" CLOB, "RELOAD_ENABLED" NUMBER(3) DEFAULT 0, "RELOAD_TIME" TIMESTAMP, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:41,349 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TABLE_RELOAD_REQUEST" ADD CONSTRAINT "SYM_TABLE_RELOAD_REQUEST_PK" PRIMARY KEY ("TARGET_NODE_ID", "SOURCE_NODE_ID", "TRIGGER_ID", "ROUTER_ID") 2014-10-09 10:16:41,381 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_TRANSFORM_TABLE"( "TRANSFORM_ID" VARCHAR2(50) NOT NULL, "SOURCE_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TARGET_NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "TRANSFORM_POINT" VARCHAR2(10) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR2(255), "SOURCE_SCHEMA_NAME" VARCHAR2(255), "SOURCE_TABLE_NAME" VARCHAR2(255) NOT NULL, "TARGET_CATALOG_NAME" VARCHAR2(255), "TARGET_SCHEMA_NAME" VARCHAR2(255), "TARGET_TABLE_NAME" VARCHAR2(255), "UPDATE_FIRST" NUMBER(3) DEFAULT 0, "DELETE_ACTION" VARCHAR2(10) NOT NULL, "TRANSFORM_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "COLUMN_POLICY" VARCHAR2(10) DEFAULT 'SPECIFIED' NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2014-10-09 10:16:41,396 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRANSFORM_TABLE" ADD CONSTRAINT "SYM_TRANSFORM_TABLE_PK" PRIMARY KEY ("TRANSFORM_ID", "SOURCE_NODE_GROUP_ID", "TARGET_NODE_GROUP_ID") 2014-10-09 10:16:41,428 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_TRANSFORM_COLUMN"( "TRANSFORM_ID" VARCHAR2(50) NOT NULL, "INCLUDE_ON" CHAR(1) DEFAULT '*' NOT NULL, "TARGET_COLUMN_NAME" VARCHAR2(128) NOT NULL, "SOURCE_COLUMN_NAME" VARCHAR2(128), "PK" NUMBER(3) DEFAULT 0, "TRANSFORM_TYPE" VARCHAR2(50) DEFAULT 'copy', "TRANSFORM_EXPRESSION" CLOB, "TRANSFORM_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2014-10-09 10:16:41,443 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRANSFORM_COLUMN" ADD CONSTRAINT "SYM_TRANSFORM_COLUMN_PK" PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME") 2014-10-09 10:16:41,553 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_TRIGGER"( "TRIGGER_ID" VARCHAR2(128) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR2(255), "SOURCE_SCHEMA_NAME" VARCHAR2(255), "SOURCE_TABLE_NAME" VARCHAR2(255) NOT NULL, "CHANNEL_ID" VARCHAR2(128) NOT NULL, "RELOAD_CHANNEL_ID" VARCHAR2(128) DEFAULT 'reload' NOT NULL, "SYNC_ON_UPDATE" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_INSERT" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_DELETE" NUMBER(3) DEFAULT 1 NOT NULL, "SYNC_ON_INCOMING_BATCH" NUMBER(3) DEFAULT 0 NOT NULL, "NAME_FOR_UPDATE_TRIGGER" VARCHAR2(255), "NAME_FOR_INSERT_TRIGGER" VARCHAR2(255), "NAME_FOR_DELETE_TRIGGER" VARCHAR2(255), "SYNC_ON_UPDATE_CONDITION" CLOB, "SYNC_ON_INSERT_CONDITION" CLOB, "SYNC_ON_DELETE_CONDITION" CLOB, "CUSTOM_ON_UPDATE_TEXT" CLOB, "CUSTOM_ON_INSERT_TEXT" CLOB, "CUSTOM_ON_DELETE_TEXT" CLOB, "EXTERNAL_SELECT" CLOB, "TX_ID_EXPRESSION" CLOB, "CHANNEL_EXPRESSION" CLOB, "EXCLUDED_COLUMN_NAMES" CLOB, "SYNC_KEY_NAMES" CLOB, "USE_STREAM_LOBS" NUMBER(3) DEFAULT 0 NOT NULL, "USE_CAPTURE_LOBS" NUMBER(3) DEFAULT 0 NOT NULL, "USE_CAPTURE_OLD_DATA" NUMBER(3) DEFAULT 1 NOT NULL, "USE_HANDLE_KEY_UPDATES" NUMBER(3) DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:41,568 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_TRIGGER_PK" PRIMARY KEY ("TRIGGER_ID") 2014-10-09 10:16:41,631 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_TRIGGER_HIST"( "TRIGGER_HIST_ID" NUMBER(22) NOT NULL, "TRIGGER_ID" VARCHAR2(128) NOT NULL, "SOURCE_TABLE_NAME" VARCHAR2(255) NOT NULL, "SOURCE_CATALOG_NAME" VARCHAR2(255), "SOURCE_SCHEMA_NAME" VARCHAR2(255), "NAME_FOR_UPDATE_TRIGGER" VARCHAR2(255), "NAME_FOR_INSERT_TRIGGER" VARCHAR2(255), "NAME_FOR_DELETE_TRIGGER" VARCHAR2(255), "TABLE_HASH" NUMBER(38) DEFAULT 0 NOT NULL, "TRIGGER_ROW_HASH" NUMBER(38) DEFAULT 0 NOT NULL, "TRIGGER_TEMPLATE_HASH" NUMBER(38) DEFAULT 0 NOT NULL, "COLUMN_NAMES" CLOB NOT NULL, "PK_COLUMN_NAMES" CLOB NOT NULL, "LAST_TRIGGER_BUILD_REASON" CHAR(1) NOT NULL, "ERROR_MESSAGE" CLOB, "CREATE_TIME" TIMESTAMP NOT NULL, "INACTIVE_TIME" TIMESTAMP ) 2014-10-09 10:16:41,662 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRIGGER_HIST" ADD CONSTRAINT "SYM_TRIGGER_HIST_PK" PRIMARY KEY ("TRIGGER_HIST_ID") 2014-10-09 10:16:41,693 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_TRIGGER_ROUTER"( "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "INITIAL_LOAD_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "INITIAL_LOAD_SELECT" CLOB, "INITIAL_LOAD_DELETE_STMT" CLOB, "INITIAL_LOAD_BATCH_COUNT" NUMBER(22) DEFAULT 1, "PING_BACK_ENABLED" NUMBER(3) DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:41,709 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_TRIGGER_ROUTER_PK" PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") 2014-10-09 10:16:41,724 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: CREATE TABLE "SYM_TRIGGER_ROUTER_GROUPLET"( "GROUPLET_ID" VARCHAR2(50) NOT NULL, "TRIGGER_ID" VARCHAR2(128) NOT NULL, "ROUTER_ID" VARCHAR2(50) NOT NULL, "APPLIES_WHEN" CHAR(1) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2014-10-09 10:16:41,740 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_TRIGGER_ROUTER_GROUPLET_PK" PRIMARY KEY ("GROUPLET_ID", "TRIGGER_ID", "ROUTER_ID", "APPLIES_WHEN") 2014-10-09 10:16:41,771 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] 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") 2014-10-09 10:16:41,787 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] 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") 2014-10-09 10:16:41,803 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_FTR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2014-10-09 10:16:41,818 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_FK_GPLTLNK_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2014-10-09 10:16:41,834 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] 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") 2014-10-09 10:16:41,849 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] 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") 2014-10-09 10:16:41,849 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_FK_IDENT_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2014-10-09 10:16:41,865 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_FK_SEC_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2014-10-09 10:16:41,881 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] 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") 2014-10-09 10:16:41,896 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] 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") 2014-10-09 10:16:41,912 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2014-10-09 10:16:41,912 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_RLD_CHNL" FOREIGN KEY ("RELOAD_CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2014-10-09 10:16:41,943 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_TRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_TRIGGER" ("TRIGGER_ID") 2014-10-09 10:16:41,959 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2014-10-09 10:16:41,959 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_FK_TRGPLT_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2014-10-09 10:16:41,974 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] 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") 2014-10-09 10:16:41,974 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] Done with auto update of SymmetricDS tables 2014-10-09 10:16:42,240 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] Just installed sym_blob2clob 2014-10-09 10:16:42,271 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] Just installed sym_transaction_id 2014-10-09 10:16:42,318 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] Just installed sym_trigger_disabled 2014-10-09 10:16:42,349 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] Just installed sym_pkg 2014-10-09 10:16:42,365 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] Just installed sym_pkg 2014-10-09 10:16:42,490 INFO [oraclenept-004] [OracleSymmetricDialect] [symmetric-engine-startup-0] Just installed sym_wkt2geom 2014-10-09 10:16:42,506 INFO [oraclenept-004] [ConfigurationService] [symmetric-engine-startup-0] Auto-configuring config channel 2014-10-09 10:16:42,521 INFO [oraclenept-004] [ConfigurationService] [symmetric-engine-startup-0] Auto-configuring reload channel 2014-10-09 10:16:42,537 INFO [oraclenept-004] [ConfigurationService] [symmetric-engine-startup-0] Auto-configuring heartbeat channel 2014-10-09 10:16:42,537 INFO [oraclenept-004] [ConfigurationService] [symmetric-engine-startup-0] Auto-configuring default channel 2014-10-09 10:16:42,537 INFO [oraclenept-004] [ConfigurationService] [symmetric-engine-startup-0] Auto-configuring dynamic channel 2014-10-09 10:16:42,553 INFO [oraclenept-004] [ConfigurationService] [symmetric-engine-startup-0] Auto-configuring filesync channel 2014-10-09 10:16:42,553 INFO [oraclenept-004] [ConfigurationService] [symmetric-engine-startup-0] Auto-configuring filesync_reload channel 2014-10-09 10:16:42,568 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for ROUTE, CLUSTER 2014-10-09 10:16:42,568 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for PULL, CLUSTER 2014-10-09 10:16:42,568 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for PUSH, CLUSTER 2014-10-09 10:16:42,584 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for HEARTBEAT, CLUSTER 2014-10-09 10:16:42,584 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for PURGE_INCOMING, CLUSTER 2014-10-09 10:16:42,584 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for PURGE_OUTGOING, CLUSTER 2014-10-09 10:16:42,584 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for PURGE_STATISTICS, CLUSTER 2014-10-09 10:16:42,584 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for SYNCTRIGGERS, CLUSTER 2014-10-09 10:16:42,584 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for PURGE_DATA_GAPS, CLUSTER 2014-10-09 10:16:42,599 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for STAGE_MANAGEMENT, CLUSTER 2014-10-09 10:16:42,599 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for WATCHDOG, CLUSTER 2014-10-09 10:16:42,599 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for STATISTICS, CLUSTER 2014-10-09 10:16:42,599 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for FILE_SYNC_PULL, CLUSTER 2014-10-09 10:16:42,599 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for FILE_SYNC_PUSH, CLUSTER 2014-10-09 10:16:42,615 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for FILE_SYNC_TRACKER, CLUSTER 2014-10-09 10:16:42,615 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for INITIAL_LOAD_EXTRACT, CLUSTER 2014-10-09 10:16:42,615 DEBUG [oraclenept-004] [ClusterService] [symmetric-engine-startup-0] Inserted into the LOCK table for FILE_SYNC_SHARED, SHARED 2014-10-09 10:16:42,678 INFO [oraclenept-004] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Done initializing SymmetricDS database 2014-10-09 10:16:42,756 INFO [oraclenept-004] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Starting unregistered node [group=oraclenept, externalId=004] 2014-10-09 10:16:42,756 INFO [oraclenept-004] [RouterJob] [symmetric-engine-startup-0] Starting job.routing on periodic schedule: every 10000ms with the first run at Thu Oct 09 10:16:42 CEST 2014 2014-10-09 10:16:42,756 INFO [oraclenept-004] [PushJob] [symmetric-engine-startup-0] Starting job.push on periodic schedule: every 60000ms with the first run at Thu Oct 09 10:16:42 CEST 2014 2014-10-09 10:16:42,756 INFO [oraclenept-004] [PullJob] [symmetric-engine-startup-0] Starting job.pull on periodic schedule: every 180000ms with the first run at Thu Oct 09 10:16:42 CEST 2014 2014-10-09 10:16:42,756 INFO [oraclenept-004] [OutgoingPurgeJob] [symmetric-engine-startup-0] Starting job.purge.outgoing with cron expression: 0 0 0 * * * 2014-10-09 10:16:42,771 INFO [oraclenept-004] [IncomingPurgeJob] [symmetric-engine-startup-0] Starting job.purge.incoming with cron expression: 0 0 0 * * * 2014-10-09 10:16:42,771 INFO [oraclenept-004] [DataGapPurgeJob] [symmetric-engine-startup-0] Starting job.purge.datagaps with cron expression: 0 0 0 * * * 2014-10-09 10:16:42,771 INFO [oraclenept-004] [StatisticFlushJob] [symmetric-engine-startup-0] Starting job.stat.flush with cron expression: 0 0/5 * * * * 2014-10-09 10:16:42,771 INFO [oraclenept-004] [SyncTriggersJob] [symmetric-engine-startup-0] Starting job.synctriggers with cron expression: 0 0 0 * * * 2014-10-09 10:16:42,787 INFO [oraclenept-004] [HeartbeatJob] [symmetric-engine-startup-0] Starting job.heartbeat on periodic schedule: every 900000ms with the first run at Thu Oct 09 10:16:43 CEST 2014 2014-10-09 10:16:42,787 INFO [oraclenept-004] [WatchdogJob] [symmetric-engine-startup-0] Starting job.watchdog on periodic schedule: every 3600000ms with the first run at Thu Oct 09 10:16:43 CEST 2014 2014-10-09 10:16:42,787 INFO [oraclenept-004] [StageManagementJob] [symmetric-engine-startup-0] Starting job.stage.management on periodic schedule: every 15000ms with the first run at Thu Oct 09 10:16:43 CEST 2014 2014-10-09 10:16:42,787 INFO [oraclenept-004] [JobManager] [symmetric-engine-startup-0] Job job.refresh.cache not configured for auto start 2014-10-09 10:16:42,787 INFO [oraclenept-004] [FileSyncTrackerJob] [symmetric-engine-startup-0] Starting job.file.sync.tracker with cron expression: 0 0/5 * * * * 2014-10-09 10:16:42,787 INFO [oraclenept-004] [FileSyncPullJob] [symmetric-engine-startup-0] Starting job.file.sync.pull on periodic schedule: every 60000ms with the first run at Thu Oct 09 10:16:43 CEST 2014 2014-10-09 10:16:42,803 INFO [oraclenept-004] [FileSyncPushJob] [symmetric-engine-startup-0] Starting job.file.sync.push on periodic schedule: every 60000ms with the first run at Thu Oct 09 10:16:43 CEST 2014 2014-10-09 10:16:42,803 INFO [oraclenept-004] [InitialLoadExtractorJob] [symmetric-engine-startup-0] Starting job.initial.load.extract on periodic schedule: every 10000ms with the first run at Thu Oct 09 10:16:43 CEST 2014 2014-10-09 10:16:42,803 INFO [oraclenept-004] [AbstractSymmetricEngine] [symmetric-engine-startup-0] Started SymmetricDS 2014-10-09 10:16:42,803 INFO [oraclenept-004] [AbstractSymmetricEngine] [symmetric-engine-startup-0] SymmetricDS: type=server, name=oraclenept-004, version=3.6.7, groupId=oraclenept, externalId=004, databaseName=Oracle, databaseVersion=10.2, driverName=Oracle JDBC driver, driverVersion=11.2.0.3.0 2014-10-09 10:16:43,021 INFO [oraclenept-004] [PushJob] [oraclenept-004-job-2] Did not run the job.push job because the engine is not registered. 2014-10-09 10:16:43,021 INFO [oraclenept-004] [FileSyncPullJob] [oraclenept-004-job-4] Did not run the job.file.sync.pull job because the engine is not registered. 2014-10-09 10:16:43,037 DEBUG [oraclenept-004] [DataService] [oraclenept-004-job-5] Did not run the heartbeat process because the node has not been configured 2014-10-09 10:16:43,037 INFO [oraclenept-004] [RouterJob] [oraclenept-004-job-1] Did not run the job.routing job because the engine is not registered. 2014-10-09 10:16:43,037 INFO [oraclenept-004] [StageManagementJob] [oraclenept-004-job-7] Did not run the job.stage.management job because the engine is not registered. 2014-10-09 10:16:43,037 INFO [oraclenept-004] [FileSyncPushJob] [oraclenept-004-job-18] Did not run the job.file.sync.push job because the engine is not registered. 2014-10-09 10:16:43,037 INFO [oraclenept-004] [InitialLoadExtractorJob] [oraclenept-004-job-20] Did not run the job.initial.load.extract job because the engine is not registered. 2014-10-09 10:16:43,053 INFO [oraclenept-004] [RegistrationService] [oraclenept-004-job-3] This node is unregistered. It will attempt to register using the registration.url 2014-10-09 10:16:43,053 DEBUG [oraclenept-004] [NodeService] [oraclenept-004-job-3] A 'null' node id was passed into findNodeSecurity 2014-10-09 10:16:43,131 INFO [oraclenept-004] [DataLoaderService] [oraclenept-004-job-3] Using registration URL of http://192.168.10.23:8080/sync/nept-000/registration?nodeGroupId=oraclenept&externalId=004&syncURL=http%3A%2F%2FORABIT%3A8080%2Fsync%2Foraclenept-004&schemaVersion=%3F&databaseType=Oracle&databaseVersion=10.2&symmetricVersion=3.6.7&hostName=ORABIT&ipAddress=fe80%3A0%3A0%3A0%3A3118%3A2f4f%3A1b37%3A5499%2514