View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001796 | SymmetricDS | Bug | public | 2014-07-08 12:43 | 2014-07-12 21:31 |
Reporter | azarubkin | Assigned To | chenson | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.5.22 | ||||
Target Version | 3.6.2 | Fixed in Version | 3.6.2 | ||
Summary | 0001796: Unable to parse ISO-8601 datetime on sqlite | ||||
Description | I'm trying to synchronize SQLite database to MS SQL. The datetime field in SQLite is stored in ISO-8601 format: 2014-07-07T13:44:36.734. The computer with SQLite runs SymmetricDS 3.5.13. The computer with MS SQL runs SymmetricDS 3.5.22. The problem arises on SymmetricDS 3.5.22 side, it is visible in logs (I've placed them in Additional information field). Apparently, it tries to parse the string it has received from SymmetricDS 3.5.13 node, and fails. Please check that SymmetricDS can parse ISO-8601 datetime strings. | ||||
Additional Information | 2014-07-08 16:25:29,906 ERROR [main] [DataLoaderService] [qtp27587325-25] Failed while parsing batch java.lang.RuntimeException: org.jumpmind.exception.ParseException: Unable to parse the date: 2014-07-07T13:44:36.734 at org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValues(AbstractDatabasePlatform.java:358) at org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValues(AbstractDatabasePlatform.java:339) at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.execute(DatabaseWriter.java:1129) at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.insert(DatabaseWriter.java:491) at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.write(DatabaseWriter.java:190) at org.jumpmind.symmetric.io.data.writer.DatabaseWriter.write(DatabaseWriter.java:167) at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64) at org.jumpmind.symmetric.model.ProcessInfoDataWriter.write(ProcessInfoDataWriter.java:65) at org.jumpmind.symmetric.io.data.writer.NestedDataWriter.write(NestedDataWriter.java:64) at org.jumpmind.symmetric.io.data.writer.TransformWriter.write(TransformWriter.java:217) at org.jumpmind.symmetric.io.data.DataProcessor.forEachDataInTable(DataProcessor.java:194) at org.jumpmind.symmetric.io.data.DataProcessor.forEachTableInBatch(DataProcessor.java:164) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:114) at org.jumpmind.symmetric.service.impl.DataLoaderService$LoadIntoDatabaseOnArrivalListener.end(DataLoaderService.java:779) at org.jumpmind.symmetric.io.data.writer.StagingDataWriter.notifyEndBatch(StagingDataWriter.java:75) at org.jumpmind.symmetric.io.data.writer.AbstractProtocolDataWriter.end(AbstractProtocolDataWriter.java:220) at org.jumpmind.symmetric.io.data.DataProcessor.process(DataProcessor.java:124) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromTransport(DataLoaderService.java:407) at org.jumpmind.symmetric.service.impl.DataLoaderService.loadDataFromPush(DataLoaderService.java:325) at org.jumpmind.symmetric.web.PushUriHandler.push(PushUriHandler.java:79) at org.jumpmind.symmetric.web.PushUriHandler.handle(PushUriHandler.java:66) at org.jumpmind.symmetric.web.SymmetricServlet.service(SymmetricServlet.java:98) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:565) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:479) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:524) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1031) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:406) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:965) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:111) at org.eclipse.jetty.server.Server.handle(Server.java:348) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:452) at org.eclipse.jetty.server.BlockingHttpConnection.handleRequest(BlockingHttpConnection.java:47) at org.eclipse.jetty.server.AbstractHttpConnection.content(AbstractHttpConnection.java:894) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:948) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:851) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:230) at org.eclipse.jetty.server.BlockingHttpConnection.handle(BlockingHttpConnection.java:66) at org.eclipse.jetty.server.bio.SocketConnector$ConnectorEndPoint.run(SocketConnector.java:254) at org.eclipse.jetty.server.ssl.SslSocketConnector$SslConnectorEndPoint.run(SslSocketConnector.java:665) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:603) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:538) at java.lang.Thread.run(Unknown Source) Caused by: org.jumpmind.exception.ParseException: Unable to parse the date: 2014-07-07T13:44:36.734 at org.jumpmind.util.FormatUtils.parseDate(FormatUtils.java:289) at org.jumpmind.util.FormatUtils.parseDate(FormatUtils.java:256) at org.jumpmind.db.platform.AbstractDatabasePlatform.parseDate(AbstractDatabasePlatform.java:536) at org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValue(AbstractDatabasePlatform.java:378) at org.jumpmind.db.platform.AbstractDatabasePlatform.getObjectValues(AbstractDatabasePlatform.java:351) ... 46 more | ||||
Tags | No tags attached. | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2014-07-08 12:43 | azarubkin | New Issue | |
2014-07-09 13:12 | chenson | Fixed in Version | => 3.6.2 |
2014-07-09 13:12 | chenson | Target Version | => 3.6.2 |
2014-07-09 13:12 | chenson | Summary | Unable to parse ISO-8601 datetime => Unable to parse ISO-8601 datetime on sqlite |
2014-07-09 13:21 | chenson | Status | new => resolved |
2014-07-09 13:21 | chenson | Resolution | open => fixed |
2014-07-09 13:21 | chenson | Assigned To | => chenson |
2014-07-09 14:00 | chenson | Changeset attached | => SymmetricDS trunk r8448 |
2014-07-12 21:31 | chenson | Status | resolved => closed |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 2ceed70b |