Task not running

[Yosi]

Hi all, since couple days sonarr is no longer running its task. Logs are showing the follow:
Task Error: The DataMapper was unable to load the following field: ‘LastExecution’ value: ‘’. Invalid format string

Also,
Marr.Data.DataMappingException: The DataMapper was unable to load the following field: ‘LastExecution’ value: ‘’. Invalid format string —> System.FormatException: Invalid format string
at System.DateTime.ParseExact (System.String s, System.String[] formats, IFormatProvider provider, DateTimeStyles style) [0x00000] in :0
at System.Data.SQLite.SQLiteConvert.ToDateTime (System.String dateText, SQLiteDateFormats format, DateTimeKind kind, System.String formatString) [0x00000] in :0
at System.Data.SQLite.SQLiteConvert.ToDateTime (System.String dateText) [0x00000] in :0
at System.Data.SQLite.SQLiteConvert.ToDateTime (IntPtr ptr, Int32 len) [0x00000] in :0
at System.Data.SQLite.SQLite3.GetDateTime (System.Data.SQLite.SQLiteStatement stmt, Int32 index) [0x00000] in :0
at System.Data.SQLite.SQLite3.GetValue (System.Data.SQLite.SQLiteStatement stmt, SQLiteConnectionFlags flags, Int32 index, System.Data.SQLite.SQLiteType typ) [0x00000] in :0
at System.Data.SQLite.SQLiteDataReader.GetValue (Int32 i) [0x00000] in :0
at Marr.Data.Mapping.MappingHelper.LoadExistingEntity (Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, System.Object ent, Boolean useAltName) [0x00000] in :0
— End of inner exception stack trace —
at Marr.Data.Mapping.MappingHelper.LoadExistingEntity (Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, System.Object ent, Boolean useAltName) [0x00000] in :0
at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity (System.Type entityType, Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, Boolean useAltName) [0x00000] in :0
at Marr.Data.Mapping.MappingHelper.CreateAndLoadEntity[ScheduledTask] (Marr.Data.Mapping.ColumnMapCollection mappings, System.Data.Common.DbDataReader reader, Boolean useAltName) [0x00000] in :0
at Marr.Data.DataMapper.Query[ScheduledTask] (System.String sql, ICollection1 entityList, Boolean useAltName) [0x00000] in <filename unknown>:0 at Marr.Data.QGen.QueryBuilder1[NzbDrone.Core.Jobs.ScheduledTask].ToList () [0x00000] in :0
at NzbDrone.Core.Datastore.BasicRepository`1[NzbDrone.Core.Jobs.ScheduledTask].All () [0x00000] in :0
at NzbDrone.Core.Jobs.TaskManager.GetPending () [0x00000] in :0
at NzbDrone.Core.Jobs.Scheduler.ExecuteCommands () [0x00000] in :0
at System.Threading.Tasks.TaskActionInvoker+ActionInvoke.Invoke (System.Threading.Tasks.Task owner, System.Object state, System.Threading.Tasks.Task context) [0x00000] in :0
at System.Threading.Tasks.Task.InnerInvoke () [0x00000] in :0
at System.Threading.Tasks.Task.ThreadStart () [0x00000] in :0

Anybody any ideas?
Its running on a Debian Linux system tho.

Greetz.

[markus101]

Which version of Sonarr and which version of mono?

It looks like a bad value was stored in the Last Execution time, the quickest fix would be to restore the database to a previous version, see backup and restore for more details. Alternatively you could update the DB via sqlite, but thats more technical.

[Yosi]

Hi, Thanks for youre reply,

The versions are:
Sonarr Version 2.0.0.3594
Mono Version 3.2.8 (Debian 3.2.8+dfsg-10)

Since the last backup is made 22 days ago, i would like to edit the string ‘LastExecution’.
Can you recommend the best way of doing this. or just the default value for the string ‘LastExecution’? That would be helpfull.

Thanks.

[markus101]

Definitely upgrade mono, 3.10 or higher is required.

Probably easiest to set it to a specific time to be safe: UPDATE ScheduledTasks SET LastExecution = '2015-12-01 00:00:00.0' should do it.