Today I discovered it was not only me but one of my feeders had the same error at exactly the same time and the Database Writer plugin stopped updating the Reports.[2015-04-18 14:34:03.032 UTC] [t28] Database writer plugin caught exception on message processing: System.FormatException: String was not recognized as a valid DateTime.
at System.DateTimeParse.ParseExactMultiple(String s, String[] formats, DateTimeFormatInfo dtfi, DateTimeStyles style)
at System.DateTime.ParseExact(String s, String[] formats, IFormatProvider provider, DateTimeStyles style)
at System.Data.SQLite.SQLiteConvert.ToDateTime(String dateText, SQLiteDateFormats format, DateTimeKind kind, String formatString)
at System.Data.SQLite.SQLiteConvert.ToDateTime(String dateText)
at System.Data.SQLite.SQLite3.GetDateTime(SQLiteStatement stmt, Int32 index)
at System.Data.SQLite.SQLite3.GetValue(SQLiteStatement stmt, SQLiteConnectionFlags flags, Int32 index, SQLiteType typ)
at System.Data.SQLite.SQLiteDataReader.GetValue(Int32 i)
at System.Data.SQLite.SQLiteDataReader.get_Item(Int32 i)
at VirtualRadar.Database.Sql.GetDateTime(IDataReader reader, Int32 ordinal)
at VirtualRadar.Database.BaseStation.AircraftTable.DecodeFullAircraft(IDataReader reader, Int32& ordinal, Boolean createBaseStationAircraftAndFlightsCount)
at VirtualRadar.Database.BaseStation.AircraftTable.GetByIcao(IDbConnection connection, IDbTransaction transaction, TextWriter log, String icao)
at VirtualRadar.Database.BaseStation.Database.GetAircraftByCode(String icao24)
at VirtualRadar.Plugin.BaseStationDatabaseWriter.Plugin.FetchOrCreateAircraft(DateTime now, String icao24)
at VirtualRadar.Plugin.BaseStationDatabaseWriter.Plugin.TrackFlight(BaseStationMessage message)
at VirtualRadar.Plugin.BaseStationDatabaseWriter.Plugin.MessageQueue_MessageReceived(BaseStationMessageEventArgs args)
Looking back through my logs this error is common ever since the plugin was replaced from version 2.0. /plugins/database writer/options/ok seems to reset things and reports for today start logging at that time.
To check to see if this is a global problem check your log for this exception [2015-04-18 14:34:03.032 UTC].Caught an exception on a slow tick heartbeat event: System.FormatException: String was not recognized as a valid DateTime.
Andrew any thoughts?
John
paradiselost