AlarmChangeNotificationClient - Unable to parse time value

Description

Errors generated by alarm-change-notifier in karaf,log

2018-03-28T15:46:17,750 ERROR alarm-change-notifier.main-module:22.0.0.SNAPSHOT(56) [Thread-145] org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient: cannot parse database json time string dbTimeStr2018-03-22T15:51:01.384-05:00
java.sql.SQLException: Bad value for type timestamp : 2018-03-22T15:51:01.384-05:00
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.loadCalendar(TimestampUtils.java:269) [57:alarm-change-notifier.pg-jdbc-utils:22.0.0.SNAPSHOT]
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.toTimestamp(TimestampUtils.java:342) [57:alarm-change-notifier.pg-jdbc-utils:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.timeNormaliser(AlarmChangeNotificationClient.java:481) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.jsonAlarmTimeNormaliser(AlarmChangeNotificationClient.java:442) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.sendDbNotification(AlarmChangeNotificationClient.java:95) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.DbNotificationClientQueueImpl$RemovingConsumer.run(DbNotificationClientQueueImpl.java:157) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at java.lang.Thread.run(Thread.java:748) [?:?]
Caused by: java.lang.NumberFormatException: Trailing junk on timestamp: 'T15:51:01.384-05:00'
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.loadCalendar(TimestampUtils.java:262) ~[?:?]
... 6 more
2018-03-28T15:46:17,751 ERROR alarm-change-notifier.main-module:22.0.0.SNAPSHOT(56) [Thread-145] org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient: cannot parse database json time string dbTimeStr2018-03-22T15:51:01.384-05:00
java.sql.SQLException: Bad value for type timestamp : 2018-03-22T15:51:01.384-05:00
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.loadCalendar(TimestampUtils.java:269) [57:alarm-change-notifier.pg-jdbc-utils:22.0.0.SNAPSHOT]
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.toTimestamp(TimestampUtils.java:342) [57:alarm-change-notifier.pg-jdbc-utils:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.timeNormaliser(AlarmChangeNotificationClient.java:481) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.jsonAlarmTimeNormaliser(AlarmChangeNotificationClient.java:445) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.sendDbNotification(AlarmChangeNotificationClient.java:95) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.DbNotificationClientQueueImpl$RemovingConsumer.run(DbNotificationClientQueueImpl.java:157) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at java.lang.Thread.run(Thread.java:748) [?:?]
Caused by: java.lang.NumberFormatException: Trailing junk on timestamp: 'T15:51:01.384-05:00'
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.loadCalendar(TimestampUtils.java:262) ~[?:?]
... 6 more
2018-03-28T15:46:17,752 ERROR alarm-change-notifier.main-module:22.0.0.SNAPSHOT(56) [Thread-145] org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient: cannot parse database json time string dbTimeStr2018-03-28T15:46:17.146-05:00
java.sql.SQLException: Bad value for type timestamp : 2018-03-28T15:46:17.146-05:00
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.loadCalendar(TimestampUtils.java:269) [57:alarm-change-notifier.pg-jdbc-utils:22.0.0.SNAPSHOT]
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.toTimestamp(TimestampUtils.java:342) [57:alarm-change-notifier.pg-jdbc-utils:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.timeNormaliser(AlarmChangeNotificationClient.java:481) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.jsonAlarmTimeNormaliser(AlarmChangeNotificationClient.java:448) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.sendDbNotification(AlarmChangeNotificationClient.java:95) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.DbNotificationClientQueueImpl$RemovingConsumer.run(DbNotificationClientQueueImpl.java:157) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at java.lang.Thread.run(Thread.java:748) [?:?]
Caused by: java.lang.NumberFormatException: Trailing junk on timestamp: 'T15:46:17.146-05:00'
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.loadCalendar(TimestampUtils.java:262) ~[?:?]
... 6 more
2018-03-28T15:46:17,752 ERROR alarm-change-notifier.main-module:22.0.0.SNAPSHOT(56) [Thread-145] org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient: cannot parse database json time string dbTimeStr2018-03-22T15:51:01.384-05:00
java.sql.SQLException: Bad value for type timestamp : 2018-03-22T15:51:01.384-05:00
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.loadCalendar(TimestampUtils.java:269) [57:alarm-change-notifier.pg-jdbc-utils:22.0.0.SNAPSHOT]
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.toTimestamp(TimestampUtils.java:342) [57:alarm-change-notifier.pg-jdbc-utils:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.timeNormaliser(AlarmChangeNotificationClient.java:481) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.jsonAlarmTimeNormaliser(AlarmChangeNotificationClient.java:454) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.alarmnotifier.AlarmChangeNotificationClient.sendDbNotification(AlarmChangeNotificationClient.java:95) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at org.opennms.plugins.dbnotifier.DbNotificationClientQueueImpl$RemovingConsumer.run(DbNotificationClientQueueImpl.java:157) [56:alarm-change-notifier.main-module:22.0.0.SNAPSHOT]
at java.lang.Thread.run(Thread.java:748) [?:?]
Caused by: java.lang.NumberFormatException: Trailing junk on timestamp: 'T15:51:01.384-05:00'
at org.opennms.plugins.com.impossibl.postgres.jdbc.TimestampUtils.loadCalendar(TimestampUtils.java:262) ~[?:?]
... 6 more

Acceptance / Success Criteria

None

Lucidchart Diagrams

Activity

Show:

Patrick Schweizer May 21, 2018 at 8:01 PM

https://github.com/OpenNMS/opennms/pull/1990

Fixed

Details
Assignee
Patrick Schweizer
Reporter
Sean Torres
Labels
driftplugin
Sprint
None
Fix versions
22.0.1
Affects versions
22.0.0
Priority
Major

PagerDuty

Created March 28, 2018 at 8:50 PM

Updated June 3, 2019 at 7:08 AM

Resolved May 23, 2018 at 1:09 PM

AlarmChangeNotificationClient - Unable to parse time value

Description

Acceptance / Success Criteria

Lucidchart Diagrams

Activity

Patrick Schweizer May 21, 2018 at 8:01 PM

DetailsAssigneePatrick SchweizerPatrick SchweizerReporterSean TorresSean TorresLabelsdriftpluginSprintNone+1Fix versions22.0.1Affects versions22.0.0PriorityMajor

Details

Assignee

Reporter

Labels

Sprint

Fix versions

Affects versions

Priority

PagerDutyPagerDuty Incident

PagerDuty

Details
Assignee
Patrick Schweizer
Reporter
Sean Torres
Labels
driftplugin
Sprint
None
Fix versions
22.0.1
Affects versions
22.0.0
Priority
Major

PagerDuty