View Issue Details

Related ChangesetsJump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0003642SymmetricDS ProBugpublic2018-07-20 17:492018-08-03 14:13
Reportermmichalek Assigned Tommichalek  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.9.0 
Target Version3.9.10Fixed in Version3.9.10 
Summary0003642: Monitor exceptions when there is a dash in the node name
DescriptionWhen 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
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Related Changesets

SymmetricDS: 3.9 a81e5b14

2018-07-20 13:55:28

mmichalek

Details Diff 		0003642: Monitor exceptions when there is a dash in the node name Affected Issues
0003642
mod - symmetric-core/src/main/java/org/jumpmind/symmetric/model/IncomingBatch.java Diff File

Issue History

Date Modified Username Field Change
2018-07-20 17:49 mmichalek New Issue
2018-07-20 17:49 mmichalek Status new => assigned
2018-07-20 17:49 mmichalek Assigned To => mmichalek
2018-07-20 17:55 mmichalek Description Updated View Revisions
2018-07-20 17:56 mmichalek Status assigned => resolved
2018-07-20 17:56 mmichalek Resolution open => fixed
2018-07-20 17:56 mmichalek Fixed in Version => 3.9.10
2018-07-20 18:00 mmichalek Changeset attached => SymmetricDS 3.9 a81e5b14
2018-08-03 14:13 chenson Status resolved => closed