2017-09-25 09:18:21,366 INFO [startup] [AbstractCommandLauncher] [main] Option: name=max-idle-time, value={90000} 2017-09-25 09:18:21,367 INFO [startup] [AbstractCommandLauncher] [main] Option: name=no-log-console, value={} 2017-09-25 09:18:21,424 INFO [startup] [SymmetricWebServer] [main] About to start SymmetricDS web server on host:port 0.0.0.0:33701 2017-09-25 09:18:23,478 INFO [startup] [SymmetricWebServer] [main] Starting JMX HTTP console on port 33702 2017-09-25 09:18:23,540 INFO [startup] [SymmetricWebServer] [main] Joining the web server main thread 2017-09-25 09:20:17,151 WARN [gui] [n] [qtp1730173572-24] Unsuccessful attempt to connect to a database using url: jdbc:oracle:thin:@localhost:49161 with driver: oracle.jdbc.driver.OracleDriver as user: system StackTraceKey.init [SQLException:1050491078] java.sql.SQLException: ORA-01017: invalid username/password; logon denied at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:546) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:236) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.jumpmind.db.util.ResettableBasicDataSource.createPoolableConnectionFactory(ResettableBasicDataSource.java:74) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at com.jumpmind.symmetric.console.ui.a.c.n.a(SetupDatabaseScreen.java:350) at com.jumpmind.symmetric.console.ui.a.c.n.p(SetupDatabaseScreen.java:424) at com.jumpmind.symmetric.console.ui.a.c.l.c(NodeSetupWizard.java:276) at com.jumpmind.symmetric.console.ui.a.c.l$4.buttonClick(NodeSetupWizard.java:133) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:211) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:174) at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1033) at com.vaadin.ui.Button.fireClick(Button.java:370) at com.vaadin.ui.Button$1.click(Button.java:57) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:155) at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:116) at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:445) at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:410) at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274) at com.vaadin.server.communication.PushHandler.lambda$new$1(PushHandler.java:145) at com.vaadin.server.communication.PushHandler.callWithUi(PushHandler.java:235) at com.vaadin.server.communication.PushHandler.onMessage(PushHandler.java:520) at com.vaadin.server.communication.PushAtmosphereHandler.onMessage(PushAtmosphereHandler.java:87) at com.vaadin.server.communication.PushAtmosphereHandler.onRequest(PushAtmosphereHandler.java:77) at org.atmosphere.cpr.AsynchronousProcessor.action(AsynchronousProcessor.java:223) at org.atmosphere.cpr.AsynchronousProcessor.suspended(AsynchronousProcessor.java:115) at org.atmosphere.container.Servlet30CometSupport.service(Servlet30CometSupport.java:67) at org.atmosphere.cpr.AtmosphereFramework.doCometSupport(AtmosphereFramework.java:2284) at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:593) at org.atmosphere.websocket.DefaultWebSocketProcessor$3.run(DefaultWebSocketProcessor.java:345) at org.atmosphere.util.VoidExecutorService.execute(VoidExecutorService.java:101) at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:340) at org.atmosphere.websocket.DefaultWebSocketProcessor.invokeWebSocketProtocol(DefaultWebSocketProcessor.java:447) at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:272) at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:269) at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:56) at org.eclipse.jetty.websocket.jsr356.endpoints.JsrEndpointEventDriver.onTextFrame(JsrEndpointEventDriver.java:218) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:162) at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:375) at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:182) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:105) at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:142) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:85) at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:220) at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:220) at org.eclipse.jetty.websocket.common.Parser.parse(Parser.java:256) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.readParse(AbstractWebSocketConnection.java:679) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:511) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:110) at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124) at org.eclipse.jetty.util.thread.Invocable.invokePreferred(Invocable.java:128) at org.eclipse.jetty.util.thread.Invocable$InvocableExecutor.invoke(Invocable.java:222) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:294) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:199) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:673) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:591) at java.lang.Thread.run(Thread.java:748) 2017-09-25 09:20:24,304 WARN [gui] [n] [qtp1730173572-22] Unsuccessful attempt to connect to a database using url: jdbc:oracle:thin:@localhost:49161 with driver: oracle.jdbc.driver.OracleDriver as user: system StackTraceKey.init [SQLException:3780049072] java.sql.SQLException: ORA-01017: invalid username/password; logon denied at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600) at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380) at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401) at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:546) at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:236) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38) at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556) at org.jumpmind.db.util.ResettableBasicDataSource.createPoolableConnectionFactory(ResettableBasicDataSource.java:74) at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388) at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at com.jumpmind.symmetric.console.ui.a.c.n.a(SetupDatabaseScreen.java:350) at com.jumpmind.symmetric.console.ui.a.c.n.p(SetupDatabaseScreen.java:424) at com.jumpmind.symmetric.console.ui.a.c.l.c(NodeSetupWizard.java:276) at com.jumpmind.symmetric.console.ui.a.c.l$4.buttonClick(NodeSetupWizard.java:133) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:211) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:174) at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1033) at com.vaadin.ui.Button.fireClick(Button.java:357) at com.vaadin.ui.Button.click(Button.java:346) at com.vaadin.ui.Button$ClickShortcut.handleAction(Button.java:463) at com.vaadin.event.ActionManager.handleAction(ActionManager.java:242) at com.vaadin.event.ConnectorActionManager.handleAction(ConnectorActionManager.java:77) at com.vaadin.event.ActionManager.handleAction(ActionManager.java:237) at com.vaadin.event.ActionManager.handleActions(ActionManager.java:220) at com.vaadin.ui.Panel.changeVariables(Panel.java:153) at com.vaadin.ui.Window.changeVariables(Window.java:213) at com.vaadin.server.communication.ServerRpcHandler.changeVariables(ServerRpcHandler.java:626) at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:471) at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:414) at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274) at com.vaadin.server.communication.PushHandler.lambda$new$1(PushHandler.java:145) at com.vaadin.server.communication.PushHandler.callWithUi(PushHandler.java:235) at com.vaadin.server.communication.PushHandler.onMessage(PushHandler.java:520) at com.vaadin.server.communication.PushAtmosphereHandler.onMessage(PushAtmosphereHandler.java:87) at com.vaadin.server.communication.PushAtmosphereHandler.onRequest(PushAtmosphereHandler.java:77) at org.atmosphere.cpr.AsynchronousProcessor.action(AsynchronousProcessor.java:223) at org.atmosphere.cpr.AsynchronousProcessor.suspended(AsynchronousProcessor.java:115) at org.atmosphere.container.Servlet30CometSupport.service(Servlet30CometSupport.java:67) at org.atmosphere.cpr.AtmosphereFramework.doCometSupport(AtmosphereFramework.java:2284) at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:593) at org.atmosphere.websocket.DefaultWebSocketProcessor$3.run(DefaultWebSocketProcessor.java:345) at org.atmosphere.util.VoidExecutorService.execute(VoidExecutorService.java:101) at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:340) at org.atmosphere.websocket.DefaultWebSocketProcessor.invokeWebSocketProtocol(DefaultWebSocketProcessor.java:447) at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:272) at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:269) at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:56) at org.eclipse.jetty.websocket.jsr356.endpoints.JsrEndpointEventDriver.onTextFrame(JsrEndpointEventDriver.java:218) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:162) at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:375) at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:182) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:105) at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:142) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:85) at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:220) at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:220) at org.eclipse.jetty.websocket.common.Parser.parse(Parser.java:256) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.readParse(AbstractWebSocketConnection.java:679) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:511) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:110) at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124) at org.eclipse.jetty.util.thread.Invocable.invokePreferred(Invocable.java:128) at org.eclipse.jetty.util.thread.Invocable$InvocableExecutor.invoke(Invocable.java:222) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:294) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:199) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:673) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:591) at java.lang.Thread.run(Thread.java:748) 2017-09-25 09:20:30,008 INFO [gui] [JdbcDatabasePlatformFactory] [qtp1730173572-12] Detected database 'Oracle', version '11', protocol 'oracle' 2017-09-25 09:20:30,039 INFO [gui] [JdbcDatabasePlatformFactory] [qtp1730173572-12] The IDatabasePlatform being used is org.jumpmind.db.platform.oracle.OracleDatabasePlatform 2017-09-25 09:20:30,076 INFO [gui] [OracleSymmetricDialect] [qtp1730173572-12] The DbDialect being used is org.jumpmind.symmetric.db.oracle.OracleSymmetricDialect 2017-09-25 09:20:37,434 INFO [SymmetricDS] [AbstractSymmetricEngine] [qtp1730173572-22] Initializing connection to database 2017-09-25 09:20:37,435 INFO [SymmetricDS] [BasicDataSourceFactory] [qtp1730173572-22] Setting database connection property oracle.net.CONNECT_TIMEOUT=60000 2017-09-25 09:20:37,435 INFO [SymmetricDS] [BasicDataSourceFactory] [qtp1730173572-22] Setting database connection property oracle.net.READ_TIMEOUT=60000 2017-09-25 09:20:37,435 INFO [SymmetricDS] [BasicDataSourceFactory] [qtp1730173572-22] Setting database connection property oracle.jdbc.ReadTimeout=60000 2017-09-25 09:20:37,435 INFO [SymmetricDS] [BasicDataSourceFactory] [qtp1730173572-22] Setting database connection property SetBigStringTryClob=true 2017-09-25 09:20:37,550 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp1730173572-22] Detected database 'Oracle', version '11', protocol 'oracle' 2017-09-25 09:20:37,550 INFO [SymmetricDS] [JdbcDatabasePlatformFactory] [qtp1730173572-22] The IDatabasePlatform being used is org.jumpmind.db.platform.oracle.OracleDatabasePlatform 2017-09-25 09:20:38,383 INFO [SymmetricDS] [OracleSymmetricDialect] [qtp1730173572-22] The DbDialect being used is org.jumpmind.symmetric.db.oracle.OracleSymmetricDialect 2017-09-25 09:20:39,559 INFO [SymmetricDS] [StagingManager] [qtp1730173572-22] The staging directory was initialized at the following location: tmp/SymmetricDS 2017-09-25 09:20:39,586 INFO [SymmetricDS] [ClusterService] [qtp1730173572-22] This node picked a server id of Kennys-MBP.loc 2017-09-25 09:20:39,636 INFO [SymmetricDS] [NodeService] [qtp1730173572-22] 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 2017-09-25 09:20:41,152 INFO [SymmetricDS] [ClientExtensionService] [qtp1730173572-22] Found 12 extension points from spring that will be registered 2017-09-25 09:20:58,399 INFO [server-000] [AbstractSymmetricEngine] [background-refresher-1] Initializing connection to database 2017-09-25 09:20:58,405 INFO [server-000] [BasicDataSourceFactory] [background-refresher-1] Setting database connection property oracle.net.CONNECT_TIMEOUT=60000 2017-09-25 09:20:58,405 INFO [server-000] [BasicDataSourceFactory] [background-refresher-1] Setting database connection property oracle.net.READ_TIMEOUT=60000 2017-09-25 09:20:58,405 INFO [server-000] [BasicDataSourceFactory] [background-refresher-1] Setting database connection property oracle.jdbc.ReadTimeout=60000 2017-09-25 09:20:58,405 INFO [server-000] [BasicDataSourceFactory] [background-refresher-1] Setting database connection property SetBigStringTryClob=true 2017-09-25 09:20:58,529 INFO [server-000] [JdbcDatabasePlatformFactory] [background-refresher-1] Detected database 'Oracle', version '11', protocol 'oracle' 2017-09-25 09:20:58,529 INFO [server-000] [JdbcDatabasePlatformFactory] [background-refresher-1] The IDatabasePlatform being used is org.jumpmind.db.platform.oracle.OracleDatabasePlatform 2017-09-25 09:20:59,393 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] The DbDialect being used is org.jumpmind.symmetric.db.oracle.OracleSymmetricDialect 2017-09-25 09:21:00,631 INFO [server-000] [StagingManager] [background-refresher-1] The staging directory was initialized at the following location: tmp/server-000 2017-09-25 09:21:00,638 INFO [server-000] [ClusterService] [background-refresher-1] This node picked a server id of Kennys-MBP.loc 2017-09-25 09:21:00,641 INFO [server-000] [NodeService] [background-refresher-1] 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 2017-09-25 09:21:02,141 INFO [server-000] [ClientExtensionService] [background-refresher-1] Found 14 extension points from spring that will be registered 2017-09-25 09:21:02,153 INFO [server-000] [AbstractSymmetricEngine] [background-refresher-1] Initializing SymmetricDS database 2017-09-25 09:21:02,154 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Checking if SymmetricDS tables need created or altered 2017-09-25 09:21:50,627 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] There are SymmetricDS tables that needed altered 2017-09-25 09:21:50,660 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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), "QUEUE" VARCHAR2(25) DEFAULT 'default' NOT NULL, "MAX_NETWORK_KBPS" NUMBER(10,3) DEFAULT 0.000 NOT NULL, "DATA_EVENT_ACTION" CHAR(1), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2017-09-25 09:21:50,680 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_CHANNEL" ADD CONSTRAINT "SYM_CHANNEL_PK" PRIMARY KEY ("CHANNEL_ID") 2017-09-25 09:21:50,695 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:21:50,701 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_CONFLICT" ADD CONSTRAINT "SYM_CONFLICT_PK" PRIMARY KEY ("CONFLICT_ID") 2017-09-25 09:21:50,921 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CONTEXT"( "NAME" VARCHAR2(80) NOT NULL, "CONTEXT_VALUE" CLOB, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_TIME" TIMESTAMP ) 2017-09-25 09:21:51,122 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_CONTEXT" ADD CONSTRAINT "SYM_CONTEXT_PK" PRIMARY KEY ("NAME") 2017-09-25 09:21:51,127 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE SEQUENCE "SEQ_SYM_DATA_DATA_ID" CACHE 1000 ORDER 2017-09-25 09:21:51,737 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:21:51,910 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_D_CHANNEL_ID" ON "SYM_DATA" ("DATA_ID", "CHANNEL_ID") 2017-09-25 09:21:51,917 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_DATA" ADD CONSTRAINT "SYM_DATA_PK" PRIMARY KEY ("DATA_ID") 2017-09-25 09:21:51,932 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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; 2017-09-25 09:21:51,938 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:21:52,110 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_DE_BATCHID" ON "SYM_DATA_EVENT" ("BATCH_ID") 2017-09-25 09:21:52,341 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_DATA_EVENT" ADD CONSTRAINT "SYM_DATA_EVENT_PK" PRIMARY KEY ("DATA_ID", "BATCH_ID", "ROUTER_ID") 2017-09-25 09:21:52,350 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:21:52,570 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_DG_STATUS" ON "SYM_DATA_GAP" ("STATUS") 2017-09-25 09:21:52,772 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_DATA_GAP" ADD CONSTRAINT "SYM_DATA_GAP_PK" PRIMARY KEY ("START_ID", "END_ID") 2017-09-25 09:21:52,958 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_EXTENSION"( "EXTENSION_ID" VARCHAR2(50) NOT NULL, "EXTENSION_TYPE" VARCHAR2(10) NOT NULL, "INTERFACE_NAME" VARCHAR2(255), "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "ENABLED" NUMBER(3) DEFAULT 1 NOT NULL, "EXTENSION_ORDER" NUMBER(22) DEFAULT 1 NOT NULL, "EXTENSION_TEXT" CLOB, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2017-09-25 09:21:53,212 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_EXTENSION" ADD CONSTRAINT "SYM_EXTENSION_PK" PRIMARY KEY ("EXTENSION_ID") 2017-09-25 09:21:53,222 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_EXTRACT_REQUEST"( "REQUEST_ID" NUMBER(38) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "QUEUE" VARCHAR2(128), "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 ) 2017-09-25 09:21:53,391 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_EXTRACT_REQUEST" ADD CONSTRAINT "SYM_EXTRACT_REQUEST_PK" PRIMARY KEY ("REQUEST_ID") 2017-09-25 09:21:53,399 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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) ) 2017-09-25 09:21:53,622 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_FILE_INCOMING" ADD CONSTRAINT "SYM_FILE_INCOMING_PK" PRIMARY KEY ("RELATIVE_DIR", "FILE_NAME") 2017-09-25 09:21:53,633 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:21:53,860 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_F_SNPSHT_CHID" ON "SYM_FILE_SNAPSHOT" ("RELOAD_CHANNEL_ID") 2017-09-25 09:21:54,063 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_FILE_SNAPSHOT" ADD CONSTRAINT "SYM_FILE_SNAPSHOT_PK" PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID", "RELATIVE_DIR", "FILE_NAME") 2017-09-25 09:21:54,609 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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, "DESCRIPTION" CLOB ) 2017-09-25 09:21:54,813 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER" ADD CONSTRAINT "SYM_FILE_TRIGGER_PK" PRIMARY KEY ("TRIGGER_ID") 2017-09-25 09:21:55,039 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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, "DESCRIPTION" CLOB ) 2017-09-25 09:21:55,212 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FILE_TRIGGER_ROUTER_PK" PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") 2017-09-25 09:21:55,220 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:21:55,401 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_GROUPLET" ADD CONSTRAINT "SYM_GROUPLET_PK" PRIMARY KEY ("GROUPLET_ID") 2017-09-25 09:21:55,409 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_GROUPLET_LINK"( "GROUPLET_ID" VARCHAR2(50) NOT NULL, "EXTERNAL_ID" VARCHAR2(255) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2017-09-25 09:21:55,641 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_GROUPLET_LINK_PK" PRIMARY KEY ("GROUPLET_ID", "EXTERNAL_ID") 2017-09-25 09:21:55,926 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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, "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, "SUMMARY" VARCHAR2(255), "IGNORE_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "BYTE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "LOAD_FLAG" NUMBER(3) DEFAULT 0, "EXTRACT_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "SENT_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "RELOAD_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "OTHER_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "DATA_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "DATA_INSERT_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "DATA_UPDATE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "DATA_DELETE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_INSERT_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_UPDATE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_DELETE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_INSERT_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_UPDATE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_DELETE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "NETWORK_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "FILTER_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "ROUTER_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "TRANSFORM_EXTRACT_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "TRANSFORM_LOAD_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_ID" NUMBER(38), "COMMON_FLAG" NUMBER(3) DEFAULT 0, "FALLBACK_INSERT_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "IGNORE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "SKIP_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "FAILED_ROW_NUMBER" NUMBER(22) DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" NUMBER(22) DEFAULT 0 NOT NULL, "FAILED_DATA_ID" NUMBER(38) DEFAULT 0 NOT NULL ) 2017-09-25 09:21:56,139 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_IB_TIME_STATUS" ON "SYM_INCOMING_BATCH" ("CREATE_TIME", "STATUS") 2017-09-25 09:21:56,371 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_IB_IN_ERROR" ON "SYM_INCOMING_BATCH" ("ERROR_FLAG") 2017-09-25 09:21:56,581 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_INCOMING_BATCH" ADD CONSTRAINT "SYM_INCOMING_BATCH_PK" PRIMARY KEY ("BATCH_ID", "NODE_ID") 2017-09-25 09:21:57,649 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:21:57,852 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_INCOMING_ERROR" ADD CONSTRAINT "SYM_INCOMING_ERROR_PK" PRIMARY KEY ("BATCH_ID", "NODE_ID", "FAILED_ROW_NUMBER") 2017-09-25 09:21:58,963 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:21:59,133 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_LOAD_FILTER" ADD CONSTRAINT "SYM_LOAD_FILTER_PK" PRIMARY KEY ("LOAD_FILTER_ID") 2017-09-25 09:21:59,145 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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) ) 2017-09-25 09:21:59,333 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_LOCK" ADD CONSTRAINT "SYM_LOCK_PK" PRIMARY KEY ("LOCK_ACTION") 2017-09-25 09:21:59,342 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE"( "NODE_ID" VARCHAR2(50) NOT NULL, "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "EXTERNAL_ID" VARCHAR2(255) NOT NULL, "SYNC_ENABLED" NUMBER(3) DEFAULT 0, "SYNC_URL" VARCHAR2(255), "SCHEMA_VERSION" VARCHAR2(50), "SYMMETRIC_VERSION" VARCHAR2(50), "CONFIG_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) ) 2017-09-25 09:21:59,531 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE" ADD CONSTRAINT "SYM_NODE_PK" PRIMARY KEY ("NODE_ID") 2017-09-25 09:21:59,541 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_COMMUNICATION"( "NODE_ID" VARCHAR2(50) NOT NULL, "QUEUE" VARCHAR2(25) 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, "SKIP_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, "BATCH_TO_SEND_COUNT" NUMBER(38) DEFAULT 0, "NODE_PRIORITY" NUMBER(22) DEFAULT 0 ) 2017-09-25 09:21:59,713 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_COMMUNICATION" ADD CONSTRAINT "SYM_NODE_COMMUNICATION_PK" PRIMARY KEY ("NODE_ID", "QUEUE", "COMMUNICATION_TYPE") 2017-09-25 09:21:59,721 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:21:59,890 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_CHANNEL_CTL" ADD CONSTRAINT "SYM_NODE_CHANNEL_CTL_PK" PRIMARY KEY ("NODE_ID", "CHANNEL_ID") 2017-09-25 09:21:59,899 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:22:00,091 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_GROUP" ADD CONSTRAINT "SYM_NODE_GROUP_PK" PRIMARY KEY ("NODE_GROUP_ID") 2017-09-25 09:22:00,100 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_GROUP_CHANNEL_WND"( "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "CHANNEL_ID" VARCHAR2(128) NOT NULL, "START_TIME" TIMESTAMP NOT NULL, "END_TIME" TIMESTAMP NOT NULL, "ENABLED" NUMBER(3) DEFAULT 0 NOT NULL ) 2017-09-25 09:22:00,292 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:00,302 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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, "IS_REVERSIBLE" NUMBER(3) DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2017-09-25 09:22:00,491 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:00,500 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_GROUP_TABLE_INFO"( "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "CATALOG_NAME" VARCHAR2(255) NOT NULL, "SCHEMA_NAME" VARCHAR2(255) NOT NULL, "TABLE_NAME" VARCHAR2(255) NOT NULL, "DEFAULT_CATALOG" NUMBER(3) DEFAULT 0, "DEFAULT_SCHEMA" NUMBER(3) DEFAULT 0, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2017-09-25 09:22:00,672 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_GROUP_TABLE_INFO" ADD CONSTRAINT "SYM_NODE_GROUP_TABLE_INFO_PK" PRIMARY KEY ("NODE_GROUP_ID", "CATALOG_NAME", "SCHEMA_NAME", "TABLE_NAME") 2017-09-25 09:22:00,686 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:22:00,891 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_HOST" ADD CONSTRAINT "SYM_NODE_HOST_PK" PRIMARY KEY ("NODE_ID", "HOST_NAME") 2017-09-25 09:22:00,902 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:22:01,071 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_CHNL_STS" ON "SYM_NODE_HOST_CHANNEL_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2017-09-25 09:22:01,253 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:01,263 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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, "TARGET_NODE_ID" VARCHAR2(50), "TARGET_NODE_COUNT" NUMBER(22) DEFAULT 0 ) 2017-09-25 09:22:01,430 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_JOB" ON "SYM_NODE_HOST_JOB_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2017-09-25 09:22:01,606 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:01,615 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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) ) 2017-09-25 09:22:01,850 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_ND_HST_STS" ON "SYM_NODE_HOST_STATS" ("NODE_ID", "START_TIME", "END_TIME") 2017-09-25 09:22:02,050 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:02,056 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NODE_IDENTITY"( "NODE_ID" VARCHAR2(50) NOT NULL ) 2017-09-25 09:22:02,231 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_NODE_IDENTITY_PK" PRIMARY KEY ("NODE_ID") 2017-09-25 09:22:02,240 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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) ) 2017-09-25 09:22:02,454 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_NODE_SECURITY_PK" PRIMARY KEY ("NODE_ID") 2017-09-25 09:22:02,680 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_MONITOR"( "MONITOR_ID" VARCHAR2(128) NOT NULL, "NODE_GROUP_ID" VARCHAR2(50) DEFAULT 'ALL' NOT NULL, "EXTERNAL_ID" VARCHAR2(255) DEFAULT 'ALL' NOT NULL, "TYPE" VARCHAR2(50) NOT NULL, "EXPRESSION" CLOB, "THRESHOLD" NUMBER(38) DEFAULT 0 NOT NULL, "RUN_PERIOD" NUMBER(22) DEFAULT 0 NOT NULL, "RUN_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "SEVERITY_LEVEL" NUMBER(22) DEFAULT 0 NOT NULL, "ENABLED" NUMBER(3) DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2017-09-25 09:22:02,872 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_MONITOR" ADD CONSTRAINT "SYM_MONITOR_PK" PRIMARY KEY ("MONITOR_ID") 2017-09-25 09:22:03,091 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_MONITOR_EVENT"( "MONITOR_ID" VARCHAR2(128) NOT NULL, "NODE_ID" VARCHAR2(50) NOT NULL, "EVENT_TIME" TIMESTAMP NOT NULL, "HOST_NAME" VARCHAR2(60), "TYPE" VARCHAR2(50) NOT NULL, "THRESHOLD" NUMBER(38) DEFAULT 0 NOT NULL, "EVENT_VALUE" NUMBER(38) DEFAULT 0 NOT NULL, "EVENT_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "SEVERITY_LEVEL" NUMBER(22) DEFAULT 0 NOT NULL, "IS_RESOLVED" NUMBER(3) DEFAULT 0 NOT NULL, "IS_NOTIFIED" NUMBER(3) DEFAULT 0 NOT NULL, "DETAILS" CLOB, "LAST_UPDATE_TIME" TIMESTAMP ) 2017-09-25 09:22:03,277 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_MONITOR_EVENT" ADD CONSTRAINT "SYM_MONITOR_EVENT_PK" PRIMARY KEY ("MONITOR_ID", "NODE_ID", "EVENT_TIME") 2017-09-25 09:22:03,478 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_NOTIFICATION"( "NOTIFICATION_ID" VARCHAR2(128) NOT NULL, "NODE_GROUP_ID" VARCHAR2(50) DEFAULT 'ALL' NOT NULL, "EXTERNAL_ID" VARCHAR2(255) DEFAULT 'ALL' NOT NULL, "SEVERITY_LEVEL" NUMBER(22) DEFAULT 0 NOT NULL, "TYPE" VARCHAR2(50) NOT NULL, "EXPRESSION" CLOB, "ENABLED" NUMBER(3) DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2017-09-25 09:22:03,691 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NOTIFICATION" ADD CONSTRAINT "SYM_NOTIFICATION_PK" PRIMARY KEY ("NOTIFICATION_ID") 2017-09-25 09:22:03,919 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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), "ERROR_FLAG" NUMBER(3) DEFAULT 0, "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, "SUMMARY" VARCHAR2(255), "IGNORE_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "BYTE_COUNT" NUMBER(38) DEFAULT 0 NOT NULL, "LOAD_FLAG" NUMBER(3) DEFAULT 0, "EXTRACT_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "SENT_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "RELOAD_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "OTHER_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "DATA_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "DATA_INSERT_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "DATA_UPDATE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "DATA_DELETE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_INSERT_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_UPDATE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_DELETE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_INSERT_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_UPDATE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_DELETE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "NETWORK_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "FILTER_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "ROUTER_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "TRANSFORM_EXTRACT_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "TRANSFORM_LOAD_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "LOAD_ID" NUMBER(38), "COMMON_FLAG" NUMBER(3) DEFAULT 0, "FALLBACK_INSERT_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "FALLBACK_UPDATE_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "IGNORE_ROW_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "MISSING_DELETE_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "SKIP_COUNT" NUMBER(22) DEFAULT 0 NOT NULL, "TOTAL_EXTRACT_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "TOTAL_LOAD_MILLIS" NUMBER(22) DEFAULT 0 NOT NULL, "EXTRACT_JOB_FLAG" NUMBER(3) DEFAULT 0, "EXTRACT_START_TIME" TIMESTAMP, "TRANSFER_START_TIME" TIMESTAMP, "LOAD_START_TIME" TIMESTAMP, "FAILED_DATA_ID" NUMBER(38) DEFAULT 0 NOT NULL, "FAILED_LINE_NUMBER" NUMBER(38) DEFAULT 0 NOT NULL, "CREATE_BY" VARCHAR2(255) ) 2017-09-25 09:22:04,089 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_OB_NODE_STATUS" ON "SYM_OUTGOING_BATCH" ("NODE_ID", "STATUS") 2017-09-25 09:22:04,248 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_OB_STATUS" ON "SYM_OUTGOING_BATCH" ("STATUS") 2017-09-25 09:22:04,459 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_OB_IN_ERROR" ON "SYM_OUTGOING_BATCH" ("ERROR_FLAG") 2017-09-25 09:22:04,630 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_OUTGOING_BATCH" ADD CONSTRAINT "SYM_OUTGOING_BATCH_PK" PRIMARY KEY ("BATCH_ID", "NODE_ID") 2017-09-25 09:22:04,793 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_PARAMETER"( "EXTERNAL_ID" VARCHAR2(255) NOT NULL, "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "PARAM_KEY" VARCHAR2(80) NOT NULL, "PARAM_VALUE" CLOB, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2017-09-25 09:22:04,982 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_PARAMETER" ADD CONSTRAINT "SYM_PARAMETER_PK" PRIMARY KEY ("EXTERNAL_ID", "NODE_GROUP_ID", "PARAM_KEY") 2017-09-25 09:22:04,990 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_REGISTRATION_REDIRECT"( "REGISTRANT_EXTERNAL_ID" VARCHAR2(255) NOT NULL, "REGISTRATION_NODE_ID" VARCHAR2(50) NOT NULL ) 2017-09-25 09:22:05,191 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_REGISTRATION_REDIRECT" ADD CONSTRAINT "SYM_REGISTRATION_REDIRECT_PK" PRIMARY KEY ("REGISTRANT_EXTERNAL_ID") 2017-09-25 09:22:05,375 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_REGISTRATION_REQUEST"( "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "EXTERNAL_ID" VARCHAR2(255) 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 ) 2017-09-25 09:22:05,610 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_1" ON "SYM_REGISTRATION_REQUEST" ("NODE_GROUP_ID", "EXTERNAL_ID", "STATUS", "HOST_NAME", "IP_ADDRESS") 2017-09-25 09:22:05,810 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_REG_REQ_2" ON "SYM_REGISTRATION_REQUEST" ("STATUS") 2017-09-25 09:22:05,982 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_REGISTRATION_REQUEST" ADD CONSTRAINT "SYM_REGISTRATION_REQUEST_PK" PRIMARY KEY ("NODE_GROUP_ID", "EXTERNAL_ID", "CREATE_TIME") 2017-09-25 09:22:06,370 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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, "DESCRIPTION" CLOB ) 2017-09-25 09:22:06,561 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_ROUTER" ADD CONSTRAINT "SYM_ROUTER_PK" PRIMARY KEY ("ROUTER_ID") 2017-09-25 09:22:06,571 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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_FLAG" NUMBER(3) DEFAULT 0, "CACHE_SIZE" NUMBER(22) DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2017-09-25 09:22:06,742 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_SEQUENCE" ADD CONSTRAINT "SYM_SEQUENCE_PK" PRIMARY KEY ("SEQUENCE_NAME") 2017-09-25 09:22:07,190 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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, "CREATE_TIME" TIMESTAMP NOT NULL, "CREATE_TABLE" NUMBER(3) DEFAULT 0 NOT NULL, "DELETE_FIRST" NUMBER(3) DEFAULT 0 NOT NULL, "RELOAD_SELECT" CLOB, "BEFORE_CUSTOM_SQL" CLOB, "RELOAD_TIME" TIMESTAMP, "LOAD_ID" NUMBER(38), "PROCESSED" NUMBER(3) DEFAULT 0 NOT NULL, "CHANNEL_ID" VARCHAR2(128), "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL ) 2017-09-25 09:22:07,381 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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", "CREATE_TIME") 2017-09-25 09:22:07,577 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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, "UPDATE_ACTION" VARCHAR2(255) DEFAULT 'UPDATE_COL' NOT NULL, "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, "DESCRIPTION" CLOB ) 2017-09-25 09:22:07,802 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:08,156 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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, "DESCRIPTION" CLOB ) 2017-09-25 09:22:08,332 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRANSFORM_COLUMN" ADD CONSTRAINT "SYM_TRANSFORM_COLUMN_PK" PRIMARY KEY ("TRANSFORM_ID", "INCLUDE_ON", "TARGET_COLUMN_NAME") 2017-09-25 09:22:11,690 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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_BEFORE_UPDATE_TEXT" CLOB, "CUSTOM_BEFORE_INSERT_TEXT" CLOB, "CUSTOM_BEFORE_DELETE_TEXT" 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, "INCLUDED_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 1 NOT NULL, "STREAM_ROW" NUMBER(3) DEFAULT 0 NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP NOT NULL, "DESCRIPTION" CLOB ) 2017-09-25 09:22:11,881 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_TRIGGER_PK" PRIMARY KEY ("TRIGGER_ID") 2017-09-25 09:22:12,502 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:22:12,720 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE INDEX "SYM_IDX_TRIGG_HIST_1" ON "SYM_TRIGGER_HIST" ("TRIGGER_ID", "INACTIVE_TIME") 2017-09-25 09:22:12,942 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER_HIST" ADD CONSTRAINT "SYM_TRIGGER_HIST_PK" PRIMARY KEY ("TRIGGER_HIST_ID") 2017-09-25 09:22:13,589 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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, "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, "DESCRIPTION" CLOB ) 2017-09-25 09:22:13,782 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_TRIGGER_ROUTER_PK" PRIMARY KEY ("TRIGGER_ID", "ROUTER_ID") 2017-09-25 09:22:13,795 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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 ) 2017-09-25 09:22:14,022 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:14,226 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_JOB"( "JOB_NAME" VARCHAR2(50) NOT NULL, "JOB_TYPE" VARCHAR2(10) NOT NULL, "REQUIRES_REGISTRATION" NUMBER(3) DEFAULT 1 NOT NULL, "JOB_EXPRESSION" CLOB, "DESCRIPTION" VARCHAR2(255), "DEFAULT_SCHEDULE" VARCHAR2(50), "DEFAULT_AUTO_START" NUMBER(3) DEFAULT 1 NOT NULL, "NODE_GROUP_ID" VARCHAR2(50) NOT NULL, "CREATE_BY" VARCHAR2(50), "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP ) 2017-09-25 09:22:14,460 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_JOB" ADD CONSTRAINT "SYM_JOB_PK" PRIMARY KEY ("JOB_NAME") 2017-09-25 09:22:14,468 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CONSOLE_USER"( "USER_ID" VARCHAR2(50) NOT NULL, "FIRST_NAME" VARCHAR2(50) NOT NULL, "LAST_NAME" VARCHAR2(50) NOT NULL, "EMAIL" VARCHAR2(50), "HASHED_PASSWORD" VARCHAR2(255), "SALT" VARCHAR2(50), "ENCRYPT_METH" VARCHAR2(50), "FAILED_LOGINS" NUMBER(3) DEFAULT 0, "AUTH_METH" VARCHAR2(50) DEFAULT 'INTERNAL', "USER_ROLE" VARCHAR2(50) DEFAULT 'ADMIN', "CREATE_TIME" TIMESTAMP, "LAST_UPDATE_BY" VARCHAR2(50), "LAST_UPDATE_TIME" TIMESTAMP, "LAST_PASSWORD_TIME" TIMESTAMP ) 2017-09-25 09:22:14,683 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_CONSOLE_USER" ADD CONSTRAINT "SYM_CONSOLE_USER_PK" PRIMARY KEY ("USER_ID") 2017-09-25 09:22:14,690 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CONSOLE_USER_HIST"( "HIST_ID" NUMBER(22) NOT NULL, "USER_ID" VARCHAR2(50) NOT NULL, "HASHED_PASSWORD" VARCHAR2(255), "SALT" VARCHAR2(50), "ENCRYPT_METH" VARCHAR2(50), "AUTH_METH" VARCHAR2(50) DEFAULT 'INTERNAL' ) 2017-09-25 09:22:14,871 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_CONSOLE_USER_HIST" ADD CONSTRAINT "SYM_CONSOLE_USER_HIST_PK" PRIMARY KEY ("HIST_ID", "USER_ID") 2017-09-25 09:22:15,035 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: CREATE TABLE "SYM_CONSOLE_EVENT"( "USER_ID" VARCHAR2(50) NOT NULL, "EVENT_CODE" VARCHAR2(25) NOT NULL, "CREATE_TIME" TIMESTAMP NOT NULL, "EVENT_NODE_ID" VARCHAR2(50), "SOURCE_NODE_ID" VARCHAR2(50), "TARGET_NODE_ID" VARCHAR2(50), "EVENT_VALUE" CLOB ) 2017-09-25 09:22:15,233 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_CONSOLE_EVENT" ADD CONSTRAINT "SYM_CONSOLE_EVENT_PK" PRIMARY KEY ("USER_ID", "EVENT_CODE", "CREATE_TIME") 2017-09-25 09:22:15,584 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:15,937 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:16,308 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_FILE_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_FTR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2017-09-25 09:22:16,706 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_GROUPLET_LINK" ADD CONSTRAINT "SYM_FK_GPLTLNK_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2017-09-25 09:22:16,927 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:17,112 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:17,454 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_IDENTITY" ADD CONSTRAINT "SYM_FK_IDENT_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2017-09-25 09:22:17,663 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_NODE_SECURITY" ADD CONSTRAINT "SYM_FK_SEC_2_NODE" FOREIGN KEY ("NODE_ID") REFERENCES "SYM_NODE" ("NODE_ID") 2017-09-25 09:22:17,878 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:18,057 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:18,419 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_CHNL" FOREIGN KEY ("CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2017-09-25 09:22:18,618 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER" ADD CONSTRAINT "SYM_FK_TRG_2_RLD_CHNL" FOREIGN KEY ("RELOAD_CHANNEL_ID") REFERENCES "SYM_CHANNEL" ("CHANNEL_ID") 2017-09-25 09:22:19,058 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_TRG" FOREIGN KEY ("TRIGGER_ID") REFERENCES "SYM_TRIGGER" ("TRIGGER_ID") 2017-09-25 09:22:19,427 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER" ADD CONSTRAINT "SYM_FK_TR_2_RTR" FOREIGN KEY ("ROUTER_ID") REFERENCES "SYM_ROUTER" ("ROUTER_ID") 2017-09-25 09:22:19,627 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] DDL applied: ALTER TABLE "SYM_TRIGGER_ROUTER_GROUPLET" ADD CONSTRAINT "SYM_FK_TRGPLT_2_GPLT" FOREIGN KEY ("GROUPLET_ID") REFERENCES "SYM_GROUPLET" ("GROUPLET_ID") 2017-09-25 09:22:20,045 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] 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") 2017-09-25 09:22:20,052 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Done with auto update of SymmetricDS tables 2017-09-25 09:22:20,066 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Installing SymmetricDS database object: CREATE OR REPLACE FUNCTION sym_blob2clob (blob_in IN BLOB) RETURN CLOB AS v_clob CLOB := null; v_varchar VARCHAR2(32767); v_start PLS_INTEGER := 1; v_buffer PLS_INTEGER := 999; BEGIN IF blob_in IS NOT NULL THEN IF DBMS_LOB.GETLENGTH(blob_in) > 0 THEN DBMS_LOB.CREATETEMPORARY(v_clob, TRUE); FOR i IN 1..CEIL(DBMS_LOB.GETLENGTH(blob_in) / v_buffer) LOOP v_varchar := UTL_RAW.CAST_TO_VARCHAR2(UTL_ENCODE.base64_encode(DBMS_LOB.SUBSTR(blob_in, v_buffer, v_start))); v_varchar := REPLACE(v_varchar,CHR(13)||CHR(10)); DBMS_LOB.WRITEAPPEND(v_clob, LENGTH(v_varchar), v_varchar); v_start := v_start + v_buffer; END LOOP; END IF; END IF; RETURN v_clob; END sym_blob2clob; 2017-09-25 09:22:20,095 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Just installed sym_blob2clob 2017-09-25 09:22:20,103 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Installing SymmetricDS database object: CREATE OR REPLACE function sym_transaction_id return varchar is begin return DBMS_TRANSACTION.local_transaction_id(false); end; 2017-09-25 09:22:20,114 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Just installed sym_transaction_id 2017-09-25 09:22:20,122 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Installing SymmetricDS database object: CREATE OR REPLACE function sym_trigger_disabled return varchar is begin return sym_pkg.disable_trigger; end; 2017-09-25 09:22:20,129 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Just installed sym_trigger_disabled 2017-09-25 09:22:20,136 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Installing SymmetricDS database object: CREATE OR REPLACE package sym_pkg as disable_trigger pls_integer; disable_node_id varchar(50); procedure setValue (a IN number); procedure setNodeValue (node_id IN varchar); end sym_pkg; 2017-09-25 09:22:20,143 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Just installed sym_pkg 2017-09-25 09:22:20,143 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Installing SymmetricDS database object: CREATE OR REPLACE package body sym_pkg as procedure setValue(a IN number) is begin sym_pkg.disable_trigger:=a; end; procedure setNodeValue(node_id IN varchar) is begin sym_pkg.disable_node_id := node_id; end; end sym_pkg; 2017-09-25 09:22:20,151 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Just installed sym_pkg 2017-09-25 09:22:20,161 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Installing SymmetricDS database object: CREATE OR REPLACE FUNCTION sym_wkt2geom( clob_in IN CLOB) RETURN SDO_GEOMETRY AS v_out SDO_GEOMETRY := NULL; BEGIN IF clob_in IS NOT NULL THEN IF DBMS_LOB.GETLENGTH(clob_in) > 0 THEN v_out := SDO_GEOMETRY(clob_in); END IF; END IF; RETURN v_out; END sym_wkt2geom; 2017-09-25 09:22:20,181 INFO [server-000] [OracleSymmetricDialect] [background-refresher-1] Just installed sym_wkt2geom 2017-09-25 09:22:20,183 INFO [server-000] [ConfigurationService] [background-refresher-1] Auto-configuring config channel 2017-09-25 09:22:20,190 INFO [server-000] [ConfigurationService] [background-refresher-1] Auto-configuring reload channel 2017-09-25 09:22:20,193 INFO [server-000] [ConfigurationService] [background-refresher-1] Auto-configuring monitor channel 2017-09-25 09:22:20,196 INFO [server-000] [ConfigurationService] [background-refresher-1] Auto-configuring heartbeat channel 2017-09-25 09:22:20,201 INFO [server-000] [ConfigurationService] [background-refresher-1] Auto-configuring default channel 2017-09-25 09:22:20,204 INFO [server-000] [ConfigurationService] [background-refresher-1] Auto-configuring dynamic channel 2017-09-25 09:22:20,238 INFO [server-000] [AbstractSymmetricEngine] [background-refresher-1] Inserting rows for node, security, identity and group for registration server 2017-09-25 09:22:20,269 INFO [server-000] [AbstractSymmetricEngine] [background-refresher-1] Done initializing SymmetricDS database 2017-09-25 09:22:20,269 INFO [server-000] [AbstractSymmetricEngine] [background-refresher-1] SymmetricDS database version : 3.9.x-SNAPSHOT 2017-09-25 09:22:20,269 INFO [server-000] [AbstractSymmetricEngine] [background-refresher-1] SymmetricDS software version : 3.9.x-SNAPSHOT 2017-09-25 09:22:21,272 INFO [server-000] [AbstractSymmetricEngine] [background-refresher-1] Starting registered node [group=server, id=000, externalId=000] 2017-09-25 09:22:21,275 INFO [server-000] [TriggerRouterService] [background-refresher-1] Synchronizing triggers 2017-09-25 09:22:21,302 INFO [server-000] [TriggerRouterService] [background-refresher-1] Done synchronizing triggers 2017-09-25 09:22:21,322 INFO [server-000] [NodeService] [background-refresher-1] Node group meta info, group server, results found 0 2017-09-25 09:22:21,324 INFO [server-000] [RouterJob] [background-refresher-1] Starting Routing on periodic schedule: every 10000ms with the first run at Mon Sep 25 09:22:31 EDT 2017 2017-09-25 09:22:21,326 INFO [server-000] [PushJob] [background-refresher-1] Starting Push on periodic schedule: every 60000ms with the first run at Mon Sep 25 09:22:31 EDT 2017 2017-09-25 09:22:21,326 INFO [server-000] [PullJob] [background-refresher-1] Starting Pull on periodic schedule: every 60000ms with the first run at Mon Sep 25 09:22:31 EDT 2017 2017-09-25 09:22:21,326 INFO [server-000] [JobManager] [background-refresher-1] Job Offline Push not configured for auto start 2017-09-25 09:22:21,327 INFO [server-000] [JobManager] [background-refresher-1] Job Offline Pull not configured for auto start 2017-09-25 09:22:21,327 INFO [server-000] [JobManager] [background-refresher-1] Job Purge Outgoing not configured for auto start 2017-09-25 09:22:21,327 INFO [server-000] [JobManager] [background-refresher-1] Job Purge Incoming not configured for auto start 2017-09-25 09:22:21,329 INFO [server-000] [StatisticFlushJob] [background-refresher-1] Starting job 'Stat Flush' with cron expression: '0 0/5 * * * *' 2017-09-25 09:22:21,330 INFO [server-000] [SyncTriggersJob] [background-refresher-1] Starting job 'SyncTriggers' with cron expression: '0 0 0 * * *' 2017-09-25 09:22:21,330 INFO [server-000] [HeartbeatJob] [background-refresher-1] Starting Heartbeat on periodic schedule: every 900000ms with the first run at Mon Sep 25 09:22:31 EDT 2017 2017-09-25 09:22:21,330 INFO [server-000] [WatchdogJob] [background-refresher-1] Starting Watchdog on periodic schedule: every 3600000ms with the first run at Mon Sep 25 09:22:31 EDT 2017 2017-09-25 09:22:21,330 INFO [server-000] [StageManagementJob] [background-refresher-1] Starting job 'Stage Management' with cron expression: '0 0 * * * *' 2017-09-25 09:22:21,330 INFO [server-000] [JobManager] [background-refresher-1] Job Refresh Cache not configured for auto start 2017-09-25 09:22:21,330 INFO [server-000] [JobManager] [background-refresher-1] Job File Sync Tracker not configured for auto start 2017-09-25 09:22:21,330 INFO [server-000] [JobManager] [background-refresher-1] Job File Sync Pull not configured for auto start 2017-09-25 09:22:21,331 INFO [server-000] [JobManager] [background-refresher-1] Job File Sync Push not configured for auto start 2017-09-25 09:22:21,331 INFO [server-000] [InitialLoadExtractorJob] [background-refresher-1] Starting Initial Load Extract on periodic schedule: every 10000ms with the first run at Mon Sep 25 09:22:31 EDT 2017 2017-09-25 09:22:21,331 INFO [server-000] [MonitorJob] [background-refresher-1] Starting Monitor on periodic schedule: every 60000ms with the first run at Mon Sep 25 09:22:31 EDT 2017 2017-09-25 09:22:21,331 INFO [server-000] [JobManager] [background-refresher-1] Job Report Status not configured for auto start 2017-09-25 09:22:21,331 INFO [server-000] [AbstractSymmetricEngine] [background-refresher-1] Started SymmetricDS 2017-09-25 09:22:21,331 INFO [server-000] [AbstractSymmetricEngine] [background-refresher-1] SymmetricDS: type=professional, name=server-000, version=3.9.x-SNAPSHOT, groupId=server, externalId=000, databaseName=Oracle, databaseVersion=11.2, driverName=Oracle JDBC driver, driverVersion=11.2.0.3.0 2017-09-25 09:22:22,802 INFO [server-000] [a] [background-refresher-1] refreshing data for for engine: not available took 84469ms 2017-09-25 09:22:31,071 INFO [server-000] [PushHeartbeatListener] [server-000-job-4] Some attribute(s) of node changed. Recording changes 2017-09-25 09:22:31,072 INFO [server-000] [PushHeartbeatListener] [server-000-job-4] Updating my node configuration info according to the symmetric properties 2017-09-25 09:22:31,103 INFO [server-000] [DataGapFastDetector] [server-000-job-1] Full gap analysis is running 2017-09-25 09:22:31,116 INFO [server-000] [DataService] [server-000-job-1] Inserting missing last data gap: { startId: 0, endId: 50000000, createTime: "Mon Sep 25 09:22:31 EDT 2017" } 2017-09-25 09:22:31,132 INFO [server-000] [DataGapFastDetector] [server-000-job-1] Querying data in gaps from database took 29 ms 2017-09-25 09:22:31,133 INFO [server-000] [DataGapFastDetector] [server-000-job-1] Full gap analysis is done after 30 ms 2017-09-25 09:22:31,391 INFO [server-000] [NodeCommunicationService] [server-000-job-3] pull will use 10 threads 2017-09-25 09:23:43,257 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey.init [SqlException:2724980413] org.jumpmind.db.sql.SqlException: Failed to execute sql: select m.monitor_id, m.external_id, m.node_group_id, m.type, m.expression, m.enabled, m.threshold, m.run_period, m.run_count, m.severity_level, m.create_time, m.last_update_by, m.last_update_time, me.is_resolved from sym_monitor m join sym_monitor_event me where m.monitor_id = me.monitor_id and (m.node_group_id = ? or m.node_group_id = 'ALL') and (m.external_id = ? or m.external_id = 'ALL') and m.enabled = 1 and me.is_resolved = 0 at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:300) at org.jumpmind.db.sql.JdbcSqlReadCursor.(JdbcSqlReadCursor.java:120) at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:140) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:199) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:195) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:185) at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:121) at org.jumpmind.symmetric.service.impl.MonitorService.getActiveMonitorsUnresolvedForNode(MonitorService.java:269) at com.jumpmind.symmetric.console.ui.screen.a.m.a(OverviewPanel.java:263) at com.jumpmind.symmetric.console.ui.screen.d.onBackgroundDataRefresh(DashboardScreen.java:108) at com.jumpmind.symmetric.console.ui.a.a(BackgroundRefresherService.java:97) at com.jumpmind.symmetric.console.ui.a$1.run(BackgroundRefresherService.java:81) at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54) at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180) at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: ORA-00905: missing keyword 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:97) ... 18 more 2017-09-25 09:23:53,272 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413] 2017-09-25 09:24:03,291 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413] 2017-09-25 09:24:08,595 INFO [gui] [TriggerRouterService] [qtp1730173572-31] Synchronizing triggers 2017-09-25 09:24:08,603 INFO [gui] [TriggerRouterService] [qtp1730173572-31] Done synchronizing triggers 2017-09-25 09:24:08,612 INFO [gui] [TriggerRouterService] [qtp1730173572-31] Synchronizing triggers 2017-09-25 09:24:10,190 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-1] Could not find any database tables matching 'sym_router' in the datasource that is configured 2017-09-25 09:24:11,711 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_transform_table' in the datasource that is configured 2017-09-25 09:24:13,210 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-2] Could not find any database tables matching 'sym_monitor_event' in the datasource that is configured 2017-09-25 09:24:13,311 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413] 2017-09-25 09:24:14,760 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_file_trigger_router' in the datasource that is configured 2017-09-25 09:24:16,380 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-1] Could not find any database tables matching 'sym_parameter' in the datasource that is configured 2017-09-25 09:24:17,888 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_table_reload_request' in the datasource that is configured 2017-09-25 09:24:19,410 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-2] Could not find any database tables matching 'sym_console_user_hist' in the datasource that is configured 2017-09-25 09:24:20,750 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_grouplet_link' in the datasource that is configured 2017-09-25 09:24:22,209 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-1] Could not find any database tables matching 'sym_node_identity' in the datasource that is configured 2017-09-25 09:24:23,329 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413] 2017-09-25 09:24:23,739 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_file_snapshot' in the datasource that is configured 2017-09-25 09:24:25,329 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-2] Could not find any database tables matching 'sym_grouplet' in the datasource that is configured 2017-09-25 09:24:26,928 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_transform_column' in the datasource that is configured 2017-09-25 09:24:28,461 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-1] Could not find any database tables matching 'sym_file_trigger' in the datasource that is configured 2017-09-25 09:24:30,041 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_trigger_router' in the datasource that is configured 2017-09-25 09:24:31,639 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-2] Could not find any database tables matching 'sym_job' in the datasource that is configured 2017-09-25 09:24:33,162 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_node_group_channel_wnd' in the datasource that is configured 2017-09-25 09:24:33,346 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413] 2017-09-25 09:24:34,761 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-1] Could not find any database tables matching 'sym_node' in the datasource that is configured 2017-09-25 09:24:36,449 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_console_event' in the datasource that is configured 2017-09-25 09:24:37,930 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-2] Could not find any database tables matching 'sym_notification' in the datasource that is configured 2017-09-25 09:24:39,520 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_console_user' in the datasource that is configured 2017-09-25 09:24:41,099 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-1] Could not find any database tables matching 'sym_node_group_link' in the datasource that is configured 2017-09-25 09:24:42,740 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_node_security' in the datasource that is configured 2017-09-25 09:24:43,861 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413] 2017-09-25 09:24:44,500 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-2] Could not find any database tables matching 'sym_node_group' in the datasource that is configured 2017-09-25 09:24:46,109 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_monitor' in the datasource that is configured 2017-09-25 09:24:47,551 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-1] Could not find any database tables matching 'sym_load_filter' in the datasource that is configured 2017-09-25 09:24:49,041 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_extension' in the datasource that is configured 2017-09-25 09:24:50,569 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-2] Could not find any database tables matching 'sym_node_group_table_info' in the datasource that is configured 2017-09-25 09:24:52,180 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_trigger' in the datasource that is configured 2017-09-25 09:24:53,713 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-1] Could not find any database tables matching 'sym_conflict' in the datasource that is configured 2017-09-25 09:24:54,292 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413] 2017-09-25 09:24:55,340 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-3] Could not find any database tables matching 'sym_trigger_router_grouplet' in the datasource that is configured 2017-09-25 09:24:56,941 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-2] Could not find any database tables matching 'sym_channel' in the datasource that is configured 2017-09-25 09:24:58,540 WARN [gui] [TriggerRouterService] [server-000-sync-triggers-1] Could not find any database tables matching 'sym_node_host' in the datasource that is configured 2017-09-25 09:24:58,541 INFO [gui] [TriggerRouterService] [qtp1730173572-31] Done synchronizing triggers 2017-09-25 09:25:04,310 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413] 2017-09-25 09:25:08,129 ERROR [gui] [AppUI] [qtp1730173572-129] Unable to invoke method click in com.vaadin.shared.ui.button.ButtonServerRpc StackTraceKey.init [RpcInvocationException:841036554] com.vaadin.server.ServerRpcManager$RpcInvocationException: Unable to invoke method click in com.vaadin.shared.ui.button.ButtonServerRpc at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:159) at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:116) at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:445) at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:410) at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274) at com.vaadin.server.communication.PushHandler.lambda$new$1(PushHandler.java:145) at com.vaadin.server.communication.PushHandler.callWithUi(PushHandler.java:235) at com.vaadin.server.communication.PushHandler.onMessage(PushHandler.java:520) at com.vaadin.server.communication.PushAtmosphereHandler.onMessage(PushAtmosphereHandler.java:87) at com.vaadin.server.communication.PushAtmosphereHandler.onRequest(PushAtmosphereHandler.java:77) at org.atmosphere.cpr.AsynchronousProcessor.action(AsynchronousProcessor.java:223) at org.atmosphere.cpr.AsynchronousProcessor.suspended(AsynchronousProcessor.java:115) at org.atmosphere.container.Servlet30CometSupport.service(Servlet30CometSupport.java:67) at org.atmosphere.cpr.AtmosphereFramework.doCometSupport(AtmosphereFramework.java:2284) at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:593) at org.atmosphere.websocket.DefaultWebSocketProcessor$3.run(DefaultWebSocketProcessor.java:345) at org.atmosphere.util.VoidExecutorService.execute(VoidExecutorService.java:101) at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:340) at org.atmosphere.websocket.DefaultWebSocketProcessor.invokeWebSocketProtocol(DefaultWebSocketProcessor.java:447) at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:272) at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:269) at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:56) at org.eclipse.jetty.websocket.jsr356.endpoints.JsrEndpointEventDriver.onTextFrame(JsrEndpointEventDriver.java:218) at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:162) at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:375) at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:182) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:105) at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:142) at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:85) at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:220) at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:220) at org.eclipse.jetty.websocket.common.Parser.parse(Parser.java:256) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.readParse(AbstractWebSocketConnection.java:679) at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:511) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:279) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:110) at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:124) at org.eclipse.jetty.util.thread.Invocable.invokePreferred(Invocable.java:128) at org.eclipse.jetty.util.thread.Invocable$InvocableExecutor.invoke(Invocable.java:222) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:294) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:199) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:673) at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:591) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:155) ... 43 more Caused by: com.vaadin.event.ListenerMethod$MethodException: Invocation of method buttonClick in com.jumpmind.symmetric.console.ui.c$1 failed. at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:531) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:211) at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:174) at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1033) at com.vaadin.ui.Button.fireClick(Button.java:370) at com.vaadin.ui.Button$1.click(Button.java:57) ... 48 more Caused by: java.lang.NullPointerException at org.jumpmind.symmetric.service.impl.DataService.insertScriptEvent(DataService.java:1150) at com.jumpmind.symmetric.console.ui.c$1.buttonClick(MonitorSummaryDialog.java:97) at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:510) ... 53 more 2017-09-25 09:25:14,328 ERROR [server-000] [a] [background-refresher-1] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413] 2017-09-25 09:25:24,346 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413] 2017-09-25 09:25:34,364 ERROR [server-000] [a] [background-refresher-2] Exception while refreshing class com.jumpmind.symmetric.console.ui.screen.d StackTraceKey [SqlException:2724980413]