EPG doesn't seem to overwrite existing entries (1 Viewer)

[swifty]

So my system has been working well for a while, and a few weeks back I upgraded to 1.3.0 Final, but then a few days ago I noticed the around half of my TV channels list 'To Be Announced' as the guide data..

I use Digiguide, written out to XML and then imported via XMLTV plugin - the plugin reports it ran OK at the scheduled time (3am) and all my mappings look right.
I checked the actual XML file and I can see 'real' guide data for some of the channels that report 'To Be Announced'.

So, I can only assume that a few weeks ago, todays listings were still 'to be announced' when the info was grabbed from Digiguide - then when this got replaced with 'real' guide data, MP isn't overwriting the listings, because it already has something filled in for that channel/date/time.

I checked on the plugin, and 'delete existing data' (can't remember exact wording) is already ticked...

Anyone have any ideas?

 

[swifty]

Anybody have any suggestions on this?

I'm still seeing the issue, and have found that I can fix it (temporarily) by going into MP TV Server Configuration > XMLTV Plugin and hit the 'Force Import' button (without making any change to the XMLTV file that got imported via the schedule.) and it fixes things until for a week or so until the future data that was TBC needs to be overwritten.

 

[HomeY]

We can't see much without full debug logs & system specs filled in
https://forum.team-mediaportal.com/...-and-fill-in-system-specs-for-support.118424/

 

[swifty]

Ok sorry about that, specs now filled in.

I've attached the TV logs, there isn't anything useful looking in the others (OTA EPG grabbing is disabled, so I'm only using XMLTV which seems to write to the TV Log) - There isn't anything in error.log either.

You can see in the latest log (for 27th/28th) that yesterday (when I saw I had EPG problems again) I did a force EPG import at around 11pm (didn't change the XML at all... so it's the same file that imported the night before!) - after i'd done this my guide was fully populated as expected.
Then at 3am this morning (28th) you can see the normal import job at 3am which downloads the latest guide data and loads it..

There doesn't seem to be anything going wrong with the load from the logs, but I'm sure in a week or so I'll start seeing TBA program info again.

 

[HomeY]

Forgot the logs?

 

[swifty]

Yeah, it's been a long day.. lol

 

[swifty]

Well, after a couple of weeks the problem came back again as expected... but I was going away and had to leave the wife with working TV so just entered MP Configuration and hit 'Force Import' - then as before, it did the trick and I had full guide data again.

Anyone have any ideas why I need to keep doing this? - I thought if the 'delete before import' was checked, that I would overwrite?

 

[swifty]

I'm using Mepo 1.6 now and still have this issue every few weeks... is there any ideas on what the issue could be?

Or does anyone have any idea what I could manually clear from the MePo SQL database manually so that I could effectively wipe my EPG via a script each day before running an EPG import?

 

[mm1352000]

"Delete before import" does not delete all existing programs. It deletes the programs that are detected as overlapping with the new guide data. It is possible there is a bug in that functionality, but crucially there is no difference in the delete code that runs for a forced import (compared with an auto import). If a forced import solves the problem I'm far more inclined to suspect that the auto import fails for some other reason.

Are there epg.log files that go with the tv.log files?

 

[swifty]

@mm1352000 Thanks for the reply.

Well it's interesting you say that, as last time this happened (yesterday) - I did a 'force import' as usual and it didn't seem to fix the issue, I still had items listed 'to be announced' last night, even though I know the XML that I imported has data for that channel/time.

I just checked on the tv server and I have epg.log and an old one but both are totally blank files...

I've just looked through all of the files in the log folder and the only thing I can find is in SetupTV-Error.log, from around the time yesterday that I started the 'force import' :-

[2014-06-07 08:26:59,957] [Log ] [SQL EPG importer] [ERROR] - BusinessLayer: InsertProgramsThread error - Object reference not set to an instance of an object., at TvDatabase.Schedule.GetProgramsForSchedule(Schedule schedule)
at TvDatabase.Schedule.SynchProgramStates(Int32 idSchedule)
at TvDatabase.Schedule.SynchProgramStatesForAll()
at TvDatabase.TvBusinessLayer.InsertProgramsThreadStart()

Is there anything else I can do to try and help to troubleshoot this?