View Issue Details

IDProjectCategoryView StatusLast Update
0004962SymmetricDS ProBugpublic2021-04-28 19:09
Reporterchenson Assigned Tochenson  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.12.8 
Target Version3.12.9Fixed in Version3.12.9 
Summary0004962: Error on outgoing batch panel on postrgres
Description2021-04-19T21:04:58.671129249Z2021-04-19 17:04:58.668 [qtp409114060-1115] ERROR Unable to invoke method click in com.vaadin.shared.ui.button.ButtonServerRpc - com.jumpmind.symmetric.console.ui.AppUI$1.error(AppUI.java:57)
Info
2021-04-19T21:04:58.671197409Zcom.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) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:116) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.communication.ServerRpcHandler.handleInvocation(ServerRpcHandler.java:445) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.communication.ServerRpcHandler.handleInvocations(ServerRpcHandler.java:410) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.communication.ServerRpcHandler.handleRpc(ServerRpcHandler.java:274) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.communication.PushHandler.lambda$new$1(PushHandler.java:151) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.communication.PushHandler.callWithUi(PushHandler.java:249) [vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.communication.PushHandler.onMessage(PushHandler.java:556) [vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.communication.PushAtmosphereHandler.onMessage(PushAtmosphereHandler.java:87) [vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.communication.PushAtmosphereHandler.onRequest(PushAtmosphereHandler.java:77) [vaadin-server-8.12.3.jar:8.12.3] at org.atmosphere.cpr.AsynchronousProcessor.action(AsynchronousProcessor.java:225) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.atmosphere.cpr.AsynchronousProcessor.suspended(AsynchronousProcessor.java:114) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.atmosphere.container.Servlet30CometSupport.service(Servlet30CometSupport.java:67) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.atmosphere.cpr.AtmosphereFramework.doCometSupport(AtmosphereFramework.java:2297) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:594) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.atmosphere.websocket.DefaultWebSocketProcessor$3.run(DefaultWebSocketProcessor.java:345) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.atmosphere.util.VoidExecutorService.execute(VoidExecutorService.java:101) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.atmosphere.websocket.DefaultWebSocketProcessor.dispatch(DefaultWebSocketProcessor.java:340) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.atmosphere.websocket.DefaultWebSocketProcessor.invokeWebSocketProtocol(DefaultWebSocketProcessor.java:448) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:272) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.atmosphere.container.JSR356Endpoint$3.onMessage(JSR356Endpoint.java:269) [atmosphere-runtime-2.4.30.vaadin2.jar:2.4.30.vaadin2] at org.eclipse.jetty.websocket.jsr356.messages.TextWholeMessage.messageComplete(TextWholeMessage.java:59) [javax-websocket-client-impl-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.jsr356.endpoints.JsrEndpointEventDriver.onTextFrame(JsrEndpointEventDriver.java:227) [javax-websocket-client-impl-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.events.AbstractEventDriver.incomingFrame(AbstractEventDriver.java:152) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.WebSocketSession.incomingFrame(WebSocketSession.java:326) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.extensions.AbstractExtension.nextIncomingFrame(AbstractExtension.java:148) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.nextIncomingFrame(PerMessageDeflateExtension.java:113) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.extensions.compress.CompressExtension.forwardIncoming(CompressExtension.java:168) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.extensions.compress.PerMessageDeflateExtension.incomingFrame(PerMessageDeflateExtension.java:92) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.extensions.ExtensionStack.incomingFrame(ExtensionStack.java:202) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.Parser.notifyFrame(Parser.java:225) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.Parser.parseSingleFrame(Parser.java:259) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:459) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.websocket.common.io.AbstractWebSocketConnection.onFillable(AbstractWebSocketConnection.java:440) [websocket-common-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) [jetty-io-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) [jetty-io-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) [jetty-io-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) [jetty-util-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) [jetty-util-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) [jetty-util-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) [jetty-util-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) [jetty-util-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) [jetty-util-9.4.32.v20200930.jar:9.4.32.v20200930] at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) [jetty-util-9.4.32.v20200930.jar:9.4.32.v20200930] at java.lang.Thread.run(Thread.java:832) [?:?] Caused by: java.lang.reflect.InvocationTargetException at jdk.internal.reflect.GeneratedMethodAccessor193.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:564) ~[?:?] at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:155) ~[vaadin-server-8.12.3.jar:8.12.3] ... 44 more Caused by: com.vaadin.event.ListenerMethod$MethodException: Invocation of method buttonClick in com.jumpmind.symmetric.console.impl.bh failed. at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:732) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:399) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:363) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1189) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.ui.Button.fireClick(Button.java:384) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.ui.Button$1.click(Button.java:57) ~[vaadin-server-8.12.3.jar:8.12.3] at jdk.internal.reflect.GeneratedMethodAccessor193.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:564) ~[?:?] at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:155) ~[vaadin-server-8.12.3.jar:8.12.3] ... 44 more Caused by: org.jumpmind.db.sql.SqlException:
Failed to execute sql: select b.node_id, b.channel_id, b.status, b.byte_count, b.extract_count, b.sent_count, b.load_count, b.data_row_count, b.reload_row_count, b.data_insert_row_count, b.data_update_row_count, b.data_delete_row_count, b.other_row_count, b.ignore_count, b.router_millis, b.network_millis, b.filter_millis, b.load_millis, b.extract_millis, b.extract_start_time, b.transfer_start_time, b.load_start_time, b.sql_state, b.sql_code, b.sql_message, b.load_insert_row_count, b.load_update_row_count, b.load_delete_row_count, b.load_row_count, b.extract_insert_row_count, b.extract_update_row_count, b.extract_delete_row_count, b.extract_row_count, b.transform_extract_millis, b.transform_load_millis, b.fallback_insert_count, b.fallback_update_count, b.ignore_row_count, b.missing_delete_count, b.skip_count, b.failed_data_id, b.failed_line_number, b.last_update_hostname, b.last_update_time, b.create_time, b.batch_id, b.extract_job_flag, b.load_flag, b.error_flag, b.common_flag, b.load_id, b.create_by, b.summary
from sym_outgoing_batch b where node_id = ? and batch_id = ? order by batch_id desc limit 2147483647 offset 0 at org.jumpmind.db.sql.AbstractSqlTemplate.translate(AbstractSqlTemplate.java:313) ~[symmetric-db-3.12.8.jar:3.12.8] at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:123) ~[symmetric-jdbc-3.12.8.jar:3.12.8] at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:160) ~[symmetric-jdbc-3.12.8.jar:3.12.8] at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:148) ~[symmetric-jdbc-3.12.8.jar:3.12.8] at org.jumpmind.db.sql.AbstractSqlTemplate.queryForCursor(AbstractSqlTemplate.java:113) ~[symmetric-db-3.12.8.jar:3.12.8] at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:210) ~[symmetric-db-3.12.8.jar:3.12.8] at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:206) ~[symmetric-db-3.12.8.jar:3.12.8] at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:169) ~[symmetric-db-3.12.8.jar:3.12.8] at org.jumpmind.symmetric.service.impl.OutgoingBatchService.listOutgoingBatchesWithLimit(OutgoingBatchService.java:473) ~[symmetric-core-3.12.8.jar:3.12.8] at com.jumpmind.symmetric.console.impl.cP.g(OutgoingBatchPanel.java:701) ~[symmetric-pro-3.12.8.jar:3.12.8] at com.jumpmind.symmetric.console.impl.cP.a(OutgoingBatchPanel.java:644) ~[symmetric-pro-3.12.8.jar:3.12.8] at com.jumpmind.symmetric.console.impl.cP.onRefresh(OutgoingBatchPanel.java:768) ~[symmetric-pro-3.12.8.jar:3.12.8] at com.jumpmind.symmetric.console.impl.r.addToView(AbstractMenuScreen.java:252) ~[symmetric-pro-3.12.8.jar:3.12.8] at com.jumpmind.symmetric.console.impl.r$3.run(AbstractMenuScreen.java:164) ~[symmetric-pro-3.12.8.jar:3.12.8] at com.jumpmind.symmetric.console.impl.r.buttonClick(AbstractMenuScreen.java:176) ~[symmetric-pro-3.12.8.jar:3.12.8] at jdk.internal.reflect.GeneratedMethodAccessor194.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:564) ~[?:?] at com.vaadin.event.ListenerMethod.receiveEvent(ListenerMethod.java:712) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:399) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.event.EventRouter.fireEvent(EventRouter.java:363) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.server.AbstractClientConnector.fireEvent(AbstractClientConnector.java:1189) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.ui.Button.fireClick(Button.java:384) ~[vaadin-server-8.12.3.jar:8.12.3] at com.vaadin.ui.Button$1.click(Button.java:57) ~[vaadin-server-8.12.3.jar:8.12.3] at jdk.internal.reflect.GeneratedMethodAccessor193.invoke(Unknown Source) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:564) ~[?:?] at com.vaadin.server.ServerRpcManager.applyInvocation(ServerRpcManager.java:155) ~[vaadin-server-8.12.3.jar:8.12.3] ... 44 more Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying
Info
2021-04-19T21:04:58.671664821Z Hint: No operator matches the given name and argument types. You might need to add explicit type casts.
Info
2021-04-19T21:04:58.671669458Z Position: 1065
Info
2021-04-19T21:04:58.671682538Z at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2532) ~[postgresql-42.2.14.jar:42.2.14]
Info
2021-04-19T21:04:58.671686743Z at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2267) ~[postgresql-42.2.14.jar:42.2.14]
Info
2021-04-19T21:04:58.671691508Z at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:312) ~[postgresql-42.2.14.jar:42.2.14]
Info
2021-04-19T21:04:58.671696145Z at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:448) ~[postgresql-42.2.14.jar:42.2.14]
Info
2021-04-19T21:04:58.671723389Z at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:369) ~[postgresql-42.2.14.jar:42.2.14]
Info
2021-04-19T21:04:58.671727384Z at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:153) ~[postgresql-42.2.14.jar:42.2.14]
Info
2021-04-19T21:04:58.671732447Z at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:103) ~[postgresql-42.2.14.jar:42.2.14]
Info
2021-04-19T21:04:58.671737751Z at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52) ~[HikariCP-3.4.5.jar:?]
Info
2021-04-19T21:04:58.671748933Z at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java) ~[HikariCP-3.4.5.jar:?]
Info
2021-04-19T21:04:58.671753630Z at org.jumpmind.db.sql.JdbcSqlReadCursor.<init>(JdbcSqlReadCursor.java:100) ~[symmetric-jdbc-3.12.8.jar:3.12.8]
Info
2021-04-19T21:04:58.671758358Z at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:160) ~[symmetric-jdbc-3.12.8.jar:3.12.8]
Info
2021-04-19T21:04:58.671762673Z at org.jumpmind.db.sql.JdbcSqlTemplate.queryForCursor(JdbcSqlTemplate.java:148) ~[symmetric-jdbc-3.12.8.jar:3.12.8]
Info
2021-04-19T21:04:58.671767083Z at org.jumpmind.db.sql.AbstractSqlTemplate.queryForCursor(AbstractSqlTemplate.java:113) ~[symmetric-db-3.12.8.jar:3.12.8]
Info
2021-04-19T21:04:58.671776951Z at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:210) ~[symmetric-db-3.12.8.jar:3.12.8]
Info
2021-04-19T21:04:58.671783924Z at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:206) ~[symmetric-db-3.12.8.jar:3.12.8]
Info
2021-04-19T21:04:58.671788527Z at org.jumpmind.db.sql.AbstractSqlTemplate.query(AbstractSqlTemplate.java:169) ~[symmetric-db-3.12.8.jar:3.12.8]
Info
2021-04-19T21:04:58.671793062Z at org.jumpmind.symmetric.service.impl.OutgoingBatchService.listOutgoingBatchesWithLimit(OutgoingBatchService.java:473) ~[symmetric-core-3.12.8.jar:3.12.8]
Info
2021-04-19T21:04:58.671797948Z at com.jumpmind.symmetric.console.impl.cP.g(OutgoingBatchPanel.java:701) ~[symmetric-pro-3.12.8.jar:3.12.8]
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2021-04-20 20:59 chenson New Issue
2021-04-20 20:59 chenson Status new => assigned
2021-04-20 20:59 chenson Assigned To => chenson
2021-04-20 21:07 elong Status assigned => resolved
2021-04-20 21:07 elong Resolution open => fixed
2021-04-20 21:07 elong Fixed in Version => 3.12.9
2021-04-28 19:09 admin Status resolved => closed