jdbcEventWriter: Failed to convert time to Timestamp
Description
It seems that your code is converting Date to string and back. It fails when locales are not set to EN because it cant parse string back to date
2010-05-27 22:02:49,421 WARN [EventHandlerPool-fiber3] JdbcEventWriter: Failed to convert time Ä?tvrtek, 27. kvÄ›ten 2010 20:02:49 GMT to Timestamp, setting current time instead. Exception: java.text.ParseException: Unparseable date: "Ä?tvrtek, 27. kvÄ›ten 2010 20:02:49 GMT" java.text.ParseException: Unparseable date: "Ä?tvrtek, 27. kvÄ›ten 2010 20:02:49 GMT" at java.text.DateFormat.parse(DateFormat.java:352) at org.opennms.netmgt.EventConstants.parseToDate(EventConstants.java:906) at org.opennms.netmgt.eventd.processor.AbstractJdbcPersister.getEventTime(AbstractJdbcPersister.java:274) at org.opennms.netmgt.eventd.processor.JdbcEventWriter.insertEvent(JdbcEventWriter.java:191) at org.opennms.netmgt.eventd.processor.JdbcEventWriter.process(JdbcEventWriter.java:118) at org.opennms.netmgt.eventd.DefaultEventHandlerImpl$EventHandlerRunnable.run(DefaultEventHandlerImpl.java:134) at org.opennms.core.concurrent.RunnableConsumerThreadPool$FiberThreadImpl.run(RunnableConsumerThreadPool.java:422) at java.lang.Thread.run(Thread.java:811)
Environment
Operating System: Windows XP/2003 (NT 5.1)
Platform: PC
Acceptance / Success Criteria
None
Lucidchart Diagrams
Activity
Show:
Seth Leger November 24, 2014 at 3:55 PM
I've changed the Event type to use java.util.Date fields for the createTime and time bean fields so that we won't have to deal with Date -> String -> Date conversions that were causing this type of problem. Marking as fixed.
2010-05-27 18:32:21,421 WARN [RTC Updater Pool-fiber1] DataUpdater: Failed to convert time -1 to java.util.Date, Setting current time instead java.text.ParseException: Unparseable date: "Ä?tvrtek, 27. kvÄ›ten 2010 16:32:21 GMT" at java.text.DateFormat.parse(DateFormat.java:352) at org.opennms.netmgt.EventConstants.parseToDate(EventConstants.java:906) at org.opennms.netmgt.rtc.DataUpdater.processEvent(DataUpdater.java:451) at org.opennms.netmgt.rtc.DataUpdater.run(DataUpdater.java:529) at org.opennms.core.concurrent.RunnableConsumerThreadPool$FiberThreadImpl.run(RunnableConsumerThreadPool.java:422) at java.lang.Thread.run(Thread.java:811)
It seems that your code is converting Date to string and back. It fails when locales are not set to EN because it cant parse string back to date
2010-05-27 22:02:49,421 WARN [EventHandlerPool-fiber3] JdbcEventWriter: Failed to convert time Ä?tvrtek, 27. kvÄ›ten 2010 20:02:49 GMT to Timestamp, setting current time instead. Exception: java.text.ParseException: Unparseable date: "Ä?tvrtek, 27. kvÄ›ten 2010 20:02:49 GMT"
java.text.ParseException: Unparseable date: "Ä?tvrtek, 27. kvÄ›ten 2010 20:02:49 GMT"
at java.text.DateFormat.parse(DateFormat.java:352)
at org.opennms.netmgt.EventConstants.parseToDate(EventConstants.java:906)
at org.opennms.netmgt.eventd.processor.AbstractJdbcPersister.getEventTime(AbstractJdbcPersister.java:274)
at org.opennms.netmgt.eventd.processor.JdbcEventWriter.insertEvent(JdbcEventWriter.java:191)
at org.opennms.netmgt.eventd.processor.JdbcEventWriter.process(JdbcEventWriter.java:118)
at org.opennms.netmgt.eventd.DefaultEventHandlerImpl$EventHandlerRunnable.run(DefaultEventHandlerImpl.java:134)
at org.opennms.core.concurrent.RunnableConsumerThreadPool$FiberThreadImpl.run(RunnableConsumerThreadPool.java:422)
at java.lang.Thread.run(Thread.java:811)