Manual recording failure, leaving no trace

[bitoclass]

I'm struggling to see what's going wrong with this manual recording:

[ATTACHMENT NOT FOUND]

All looks OK there. (I've been having EPG trouble with this particular channel on DVB-S but this is a very simple, predictable schedule so I thought I'd do a manual recording.)

But there's no sign of a recorded file, no sign in the NPVR logs of it even attempting the recording, and no sign of any failure in the list of completed (or failed) recordings.

This had happened yesterday so I deleted and recreated the manual recording and it happened again today - or rather didn't happen, no trace of it even attempting this recording!

Any ideas what I've done wrong?

[mvallevand]

Any ideas what I've done wrong?

You didn't include the logs. It is possible that the UK EPG problem is affecting all recordings not just those that are EPG based.

Martin

[bitoclass]

I should have said, all other recordings (from the EPG, on other channels) are working fine, it's just this one that's failing.

What logs shall I share? As I say there's literally nothing logged at 16.00 (or 15.58) today in any of the logfiles I've looked in.

[mvallevand]

Providing all of them from the Settings screen is easiest.

Martin

[bitoclass]

Thank you! Hopefully the attached covers it! Sorry for missing the obvious 🤦*♂️

[mvallevand]

Ok that is better the advanced rule you created is bad not sure where that "None" came from

Code:

2019-05-10 05:02:01.832    [INFO][10]    UpdateRecurringRecording(154, 'Eddie Mair on LBC'):
<Rules><ChannelOID>8590</ChannelOID><ChannelName>LBC</ChannelName><StartTime>2019-05-10T15:00:00.0000000Z</StartTime><EndTime>2019-05-10T18:00:00.0000000Z</EndTime><PrePadding>2</PrePadding><PostPadding>3</PostPadding><Quality>0</Quality><Keep>0</Keep><Days>MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY</Days><AdvancedRules>None</AdvancedRules></Rules>
2019-05-10 05:02:02.019    [DEBUG][10]    LoadListingByAdvancedRules(channel=8590,advancedRules=None)
2019-05-10 05:02:02.025    [ERROR][10]    Unexpected error in LoadListingByAdvancedRules: System.Data.SQLite.SQLiteException (0x80004005): SQL logic error or missing database
no such column: None
   at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
   at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
   at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
   at System.Data.SQLite.SQLiteDataReader.NextResult()
   at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
   at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SQLite.SQLiteCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader()
   at NShared.EPGManager.LoadListingByAdvancedRules(Channel channel, String advancedRules)

Martin

[bitoclass]

Woah, that's weird. I didn't actively create an advanced rule - has one crept in somehow? I didn't type "None" or anything - that's just what was in that field when I went into that screen to create the recording!

How can I remove this? When I'm in the Update screen, the left and right arrows on the Advanced Rule row don't do anything, so the row just stays saying "None".

Thanks very much for your excellent and speedy help by the way!

[mvallevand]

I would try deleting the rule and redoing it.

Martin

[bitoclass]

Thanks, but I did delete this recording yesterday when it first failed and created it again, and that's the recording that's gone wrong now - any way of knowing what I need to do differently when creating it this time, or a way to tell if it has this weird "None" rule in it without waiting for it to fail again?

[bitoclass]

I deleted that recording from the list and created an XML file as follows:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<recurrings>
  <recurring>
    <name>Eddie Mair LBC</name>
    <matchrules>
<Rules><ChannelOID>8590</ChannelOID><ChannelName>LBC</ChannelName><StartTime>2019-05-10T15:00:00.0000000Z</StartTime><EndTime>2019-05-10T18:00:00.0000000Z</EndTime><PrePadding>2</PrePadding><PostPadding>3</PostPadding><Quality>0</Quality><Keep>0</Keep><Days>MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY</Days></Rules>
    </matchrules>
  </recurring>
</recurrings>

In other words, I stripped out everything that seemed non-essential from the relevant bit of the XML that was last backed up for that recording.

I've imported that and it appears in the list of Recurring Recordings, although it doesn't appear in the list of Pending Recordings - not sure if that's anything to worry about? I can't see any errors in the log following my importing of it so perhaps that's it resolved now?

Unless you can point me to anywhere where I can check it's set up correctly this time, I will just have to see whether it succeeds on Monday I think.

Thanks for your help!