View Issue Details

IDProjectCategoryView StatusLast Update
0006024SymmetricDS ProBugpublic2023-10-13 19:19
Reporteremiller Assigned Toemiller  
Prioritynormal 
Status closedResolutionfixed 
Product Version3.15.0 
Target Version3.15.1Fixed in Version3.15.1 
Summary0006024: JsonSyntaxException when deserializing monitor event details
DescriptionIt's possible for the below JsonSyntaxException to occur when deserializing the details of a monitor event. This deserialization is done in preparation to display the monitor event in the web console.

Failed to deserialize event: Data Error {"a":[],"b":[{"failedRowNumber":1,"startTime":0,"retry":false,"batchId":64,"nodeId":"nodeId","channelId":"reload","errorFlag":true,"routerMillis":0,"networkMillis":0,"filterMillis":2869,"loadMillis":2598,"extractMillis":45,"transformExtractMillis":0,"transformLoadMillis":0,"byteCount":3839,"ignoreCount":0,"sqlState":"42000","sqlCode":910,"sqlMessage":"ORA-00910: specified length too long for its datatype","lastUpdatedHostName":"VWS15663","lastUpdatedTime":"Oct 11, 2023, 4:06:46¿PM","createTime":"Oct 11, 2023, 1:03:07¿AM","summary":"oficio","status":"ER","loadFlag":true,"extractCount":1,"sentCount":2,"loadCount":1,"reloadRowCount":0,"otherRowCount":1,"dataRowCount":1,"dataInsertRowCount":0,"dataUpdateRowCount":0,"dataDeleteRowCount":0,"oldDataRowCount":0,"oldByteCount":0,"oldFilterMillis":0,"oldExtractMillis":0,"oldLoadMillis":0,"oldNetworkMillis":0,"loadId":2,"commonFlag":false,"bulkLoaderFlag":false,"fallbackInsertCount":0,"fallbackUpdateCount":0,"conflictWinCount":0,"conflictLoseCount":0,"ignoreRowCount":0,"missingDeleteCount":0,"skipCount":0,"loadRowCount":1,"loadInsertRowCount":0,"loadUpdateRowCount":0,"loadDeleteRowCount":0,"extractRowCount":1,"extractInsertRowCount":0,"extractUpdateRowCount":0,"extractDeleteRowCount":0,"failedDataId":0,"failedLineNumber":1}]} StackTraceKey.init [JsonSyntaxException:2353631915] com.google.gson.JsonSyntaxException: Failed parsing 'Oct 11, 2023, 4:06:46¿PM' as Date; at path $.b[0].lastUpdatedTime
    at com.google.gson.internal.bind.DateTypeAdapter.deserializeToDate(DateTypeAdapter.java:90)
    at com.google.gson.internal.bind.DateTypeAdapter.read(DateTypeAdapter.java:75)
    at com.google.gson.internal.bind.DateTypeAdapter.read(DateTypeAdapter.java:46)
    at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.read(ReflectiveTypeAdapterFactory.java:161)
    at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:266)
    at com.google.gson.internal.bind.TypeAdapterRuntimeTypeWrapper.read(TypeAdapterRuntimeTypeWrapper.java:41)
    at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:82)
    at com.google.gson.internal.bind.CollectionTypeAdapterFactory$Adapter.read(CollectionTypeAdapterFactory.java:61)
    at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$1.read(ReflectiveTypeAdapterFactory.java:161)
    at com.google.gson.internal.bind.ReflectiveTypeAdapterFactory$Adapter.read(ReflectiveTypeAdapterFactory.java:266)
    at com.google.gson.Gson.fromJson(Gson.java:1058)
    at com.google.gson.Gson.fromJson(Gson.java:1016)
    at com.google.gson.Gson.fromJson(Gson.java:959)
    at com.google.gson.Gson.fromJson(Gson.java:927)
    at com.jumpmind.symmetric.console.ui.d.c(MainWindow.java:1435)
    at com.jumpmind.symmetric.console.ui.d.c(MainWindow.java:1448)
    at com.jumpmind.symmetric.console.ui.d.b(MainWindow.java:1116)
    at com.jumpmind.symmetric.console.ui.d$a.a(MainWindow.java:1628)
    at com.jumpmind.symmetric.console.ui.d$a.onBackgroundDataRefresh(MainWindow.java:1625)
    at com.jumpmind.symmetric.console.ui.c.a(BackgroundRefresherService.java:89)
    at com.jumpmind.symmetric.console.ui.c$1.run(BackgroundRefresherService.java:74)
    at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:572)
    at java.base/java.util.concurrent.FutureTask.runAndReset(FutureTask.java:358)
    at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:305)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
    at java.base/java.lang.Thread.run(Thread.java:1583)
Caused by: java.text.ParseException: Failed to parse date ["Oct 11, 2023, 4:06:46¿PM"]: Invalid number: Oct
    at com.google.gson.internal.bind.util.ISO8601Utils.parse(ISO8601Utils.java:279)
    at com.google.gson.internal.bind.DateTypeAdapter.deserializeToDate(DateTypeAdapter.java:88)
    ... 27 more
Caused by: java.lang.NumberFormatException: Invalid number: Oct
    at com.google.gson.internal.bind.util.ISO8601Utils.parseInt(ISO8601Utils.java:316)
    at com.google.gson.internal.bind.util.ISO8601Utils.parse(ISO8601Utils.java:133)
    ... 28 more
Tagsui

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2023-10-12 20:12 emiller New Issue
2023-10-12 20:12 emiller Status new => assigned
2023-10-12 20:12 emiller Assigned To => emiller
2023-10-12 20:12 emiller Tag Attached: ui
2023-10-13 19:19 emiller Status assigned => resolved
2023-10-13 19:19 emiller Resolution open => fixed
2023-10-13 19:19 emiller Fixed in Version => 3.15.1
2023-11-14 21:10 admin Status resolved => closed