View Revisions: Issue #3642
| Summary | 0003642: Monitor exceptions when there is a dash in the node name | ||
|---|---|---|---|
| Revision | 2018-07-20 17:49 by mmichalek | ||
| Description | When there is a dash in the node name, a batch error, and a user is using the web console, a lot of these messages can be generated in the log: 2018-07-20 00:33:36,090 INFO [corp-000] [MainWindow] [background-refresher-2] Failed to deserialize event: SystemBatchErrorMonitor {"outgoingErrors":[],"incomingErrors":[{"batchId":1556461,"nodeId":"Corp-01","channelId":"ecs_2way","errorFlag":true,"routerMillis":0,"networkMillis":0,"filterMillis":0,"loadMillis":0,"extractMillis":0,"transformExtractMillis":0,"transformLoadMillis":0,"byteCount":814,"ignoreCount":0,"sqlState":null,"sqlCode":0,"sqlMessage":"Could not find the target table 'WebsiteCentral.dbo.ECS_CreditCards'","lastUpdatedHostName":"mac-mmichalek.columbus.rr.com","lastUpdatedTime":1532061024132,"createTime":1532061024078,"createBy":null,"summary":"ecs_creditcards","status":"ER","loadFlag":false,"extractCount":0,"sentCount":0,"loadCount":0,"reloadRowCount":0,"otherRowCount":0,"dataRowCount":0,"dataInsertRowCount":0,"dataUpdateRowCount":0,"dataDeleteRowCount":0,"loadId":0,"commonFlag":false,"fallbackInsertCount":0,"fallbackUpdateCount":0,"ignoreRowCount":0,"missingDeleteCount":0,"skipCount":0,"loadRowCount":0,"loadInsertRowCount":0,"loadUpdateRowCount":0,"loadDeleteRowCount":0,"extractRowCount":0,"extractInsertRowCount":0,"extractUpdateRowCount":0,"extractDeleteRowCount":0,"failedDataId":0,"tableCounts":{},"processedRowCount":0,"failedRowNumber":0,"failedLineNumber":0,"startTime":0,"retry":false,"nodeBatchId":"Corp-01-1556461","persistable":true,"stagedLocation":"Corp-01"},{"batchId":2297558,"nodeId":"Website-01","channelId":"ecs_2way","errorFlag":true,"routerMillis":0,"networkMillis":0,"filterMillis":0,"loadMillis":0,"extractMillis":0,"transformExtractMillis":0,"transformLoadMillis":0,"byteCount":529,"ignoreCount":0,"sqlState":null,"sqlCode":0,"sqlMessage":"Could not find the target table 'WebsiteCentral.dbo.ECS_CartHeader'","lastUpdatedHostName":"mac-mmichalek.columbus.rr.com","lastUpdatedTime":1532061042988,"createTime":1532061042982,"createBy":null,"summary":"ecs_cartheader","status":"ER","loadFlag":false,"extractCount":0,"sentCount":0,"loadCount":0,"reloadRowCount":0,"otherRowCount":0,"dataRowCount":0,"dataInsertRowCount":0,"dataUpdateRowCount":0,"dataDeleteRowCount":0,"loadId":0,"commonFlag":false,"fallbackInsertCount":0,"fallbackUpdateCount":0,"ignoreRowCount":0,"missingDeleteCount":0,"skipCount":0,"loadRowCount":0,"loadInsertRowCount":0,"loadUpdateRowCount":0,"loadDeleteRowCount":0,"extractRowCount":0,"extractInsertRowCount":0,"extractUpdateRowCount":0,"extractDeleteRowCount":0,"failedDataId":0,"tableCounts":{},"processedRowCount":0,"failedRowNumber":0,"failedLineNumber":0,"startTime":0,"retry":false,"nodeBatchId":"Website-01-2297558","persistable":true,"stagedLocation":"Website-01"}]} com.fasterxml.jackson.databind.JsonMappingException: For input string: "01-1556461" at [Source: (String)"{"outgoingErrors":[],"incomingErrors":[{"batchId":1556461,"nodeId":"Corp-01","channelId":"ecs_2way","errorFlag":true,"routerMillis":0,"networkMillis":0,"filterMillis":0,"loadMillis":0,"extractMillis":0,"transformExtractMillis":0,"transformLoadMillis":0,"byteCount":814,"ignoreCount":0,"sqlState":null,"sqlCode":0,"sqlMessage":"Could not find the target table 'WebsiteCentral.dbo.ECS_CreditCards'","lastUpdatedHostName":"mac-mmichalek.columbus.rr.com","lastUpdatedTime":1532061024132,"createTime":15"[truncated 2025 chars]; line: 1, column: 1213] (through reference chain: org.jumpmind.symmetric.monitor.BatchErrorWrapper["incomingErrors"]->java.util.ArrayList[0]->org.jumpmind.symmetric.model.IncomingBatch["nodeBatchId"]) at com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:277) at com.fasterxml.jackson.databind.deser.SettableBeanProperty._throwAsIOE(SettableBeanProperty.java:598) at com.fasterxml.jackson.databind.deser.SettableBeanProperty._throwAsIOE(SettableBeanProperty.java:586) at com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:134) at com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:288) at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:151) at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:286) at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:245) at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:27) at com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:127) at com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:288) at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:151) at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:4001) at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:2992) at com.jumpmind.symmetric.console.ui.MainWindow.deserializeBatchErrorEvent(MainWindow.java:1327) at com.jumpmind.symmetric.console.ui.MainWindow.buildBatchErrorMap(MainWindow.java:1341) at com.jumpmind.symmetric.console.ui.MainWindow.getAlertCount(MainWindow.java:1030) at com.jumpmind.symmetric.console.ui.MainWindow$AlertsRefresher.onBackgroundDataRefresh(MainWindow.java:1464) at com.jumpmind.symmetric.console.ui.MainWindow$AlertsRefresher.onBackgroundDataRefresh(MainWindow.java:1) at com.jumpmind.symmetric.console.ui.BackgroundRefresherService.refresh(BackgroundRefresherService.java:99) at com.jumpmind.symmetric.console.ui.BackgroundRefresherService$1.run(BackgroundRefresherService.java:82) 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:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NumberFormatException: For input string: "01-1556461" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Long.parseLong(Long.java:589) at java.lang.Long.parseLong(Long.java:631) at org.jumpmind.symmetric.model.IncomingBatch.setNodeBatchId(IncomingBatch.java:109) 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.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:132) ... 25 more |
||
| Revision | 2018-07-20 17:55 by mmichalek | ||
| Description | When there is a dash in the node name, a batch error, and a user is using the web console, a lot of these messages can be generated in the log: 2018-07-20 00:33:36,090 INFO [corp-000] [MainWindow] [background-refresher-2] Failed to deserialize event: SystemBatchErrorMonitor {"outgoingErrors":[],"incomingErrors":[{"batchId":1556461,"nodeId":"Corp-01","channelId":"orders","errorFlag":true,"routerMillis":0,"networkMillis":0,"filterMillis":0,"loadMillis":0,"extractMillis":0,"transformExtractMillis":0,"transformLoadMillis":0,"byteCount":814,"ignoreCount":0,"sqlState":null,"sqlCode":0,"sqlMessage":"Could not find the target table 'Website.dbo.CreditCards'","lastUpdatedHostName":"mac-mmichalek.columbus.rr.com","lastUpdatedTime":1532061024132,"createTime":1532061024078,"createBy":null,"summary":"ecreditcards","status":"ER","loadFlag":false,"extractCount":0,"sentCount":0,"loadCount":0,"reloadRowCount":0,"otherRowCount":0,"dataRowCount":0,"dataInsertRowCount":0,"dataUpdateRowCount":0,"dataDeleteRowCount":0,"loadId":0,"commonFlag":false,"fallbackInsertCount":0,"fallbackUpdateCount":0,"ignoreRowCount":0,"missingDeleteCount":0,"skipCount":0,"loadRowCount":0,"loadInsertRowCount":0,"loadUpdateRowCount":0,"loadDeleteRowCount":0,"extractRowCount":0,"extractInsertRowCount":0,"extractUpdateRowCount":0,"extractDeleteRowCount":0,"failedDataId":0,"tableCounts":{},"processedRowCount":0,"failedRowNumber":0,"failedLineNumber":0,"startTime":0,"retry":false,"nodeBatchId":"Corp-01-1556461","persistable":true,"stagedLocation":"Corp-01"} ]} com.fasterxml.jackson.databind.JsonMappingException: For input string: "01-1556461" at [Source: (String)"{"outgoingErrors":[],"incomingErrors":[{"batchId":1556461,"nodeId":"Corp-01","channelId":"ecs_2way","errorFlag":true,"routerMillis":0,"networkMillis":0,"filterMillis":0,"loadMillis":0,"extractMillis":0,"transformExtractMillis":0,"transformLoadMillis":0,"byteCount":814,"ignoreCount":0,"sqlState":null,"sqlCode":0,"sqlMessage":"Could not find the target table 'Website.dbo.CreditCards'","lastUpdatedHostName":"mac-mmichalek.columbus.rr.com","lastUpdatedTime":1532061024132,"createTime":15"[truncated 2025 chars]; line: 1, column: 1213] (through reference chain: org.jumpmind.symmetric.monitor.BatchErrorWrapper["incomingErrors"]->java.util.ArrayList[0]->org.jumpmind.symmetric.model.IncomingBatch["nodeBatchId"]) at com.fasterxml.jackson.databind.JsonMappingException.from(JsonMappingException.java:277) at com.fasterxml.jackson.databind.deser.SettableBeanProperty._throwAsIOE(SettableBeanProperty.java:598) at com.fasterxml.jackson.databind.deser.SettableBeanProperty._throwAsIOE(SettableBeanProperty.java:586) at com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:134) at com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:288) at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:151) at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:286) at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:245) at com.fasterxml.jackson.databind.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:27) at com.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:127) at com.fasterxml.jackson.databind.deser.BeanDeserializer.vanillaDeserialize(BeanDeserializer.java:288) at com.fasterxml.jackson.databind.deser.BeanDeserializer.deserialize(BeanDeserializer.java:151) at com.fasterxml.jackson.databind.ObjectMapper._readMapAndClose(ObjectMapper.java:4001) at com.fasterxml.jackson.databind.ObjectMapper.readValue(ObjectMapper.java:2992) at com.jumpmind.symmetric.console.ui.MainWindow.deserializeBatchErrorEvent(MainWindow.java:1327) at com.jumpmind.symmetric.console.ui.MainWindow.buildBatchErrorMap(MainWindow.java:1341) at com.jumpmind.symmetric.console.ui.MainWindow.getAlertCount(MainWindow.java:1030) at com.jumpmind.symmetric.console.ui.MainWindow$AlertsRefresher.onBackgroundDataRefresh(MainWindow.java:1464) at com.jumpmind.symmetric.console.ui.MainWindow$AlertsRefresher.onBackgroundDataRefresh(MainWindow.java:1) at com.jumpmind.symmetric.console.ui.BackgroundRefresherService.refresh(BackgroundRefresherService.java:99) at com.jumpmind.symmetric.console.ui.BackgroundRefresherService$1.run(BackgroundRefresherService.java:82) 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:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NumberFormatException: For input string: "01-1556461" at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) at java.lang.Long.parseLong(Long.java:589) at java.lang.Long.parseLong(Long.java:631) at org.jumpmind.symmetric.model.IncomingBatch.setNodeBatchId(IncomingBatch.java:109) 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.fasterxml.jackson.databind.deser.impl.MethodProperty.deserializeAndSet(MethodProperty.java:132) ... 25 more |
||