Unable to Import MXF after WU Problem

[Springsteen76]

So I thought I had solved the problem with the Windows Update affecting the ehtrace files. Unfortunately, I've realized that in fixing that, I must have messed up something with importing the data from EPG123 . . . which I only realized when the downloaded listings ran out.

I let it run automatically, and it gave an error on importing. I tried manually loading the MXF file, and it also gave an error. I've cut and pasted the parts of the log that give the errors (cutting all the stuff that looks--at least to my eyes--as normal).

I'm sure that this is an easy fix, but I just can't seem to get it to work. I did have to go in and adjust the registry settings that were changed ("broken") by the March update, and I thought that would solve it but no.

I have not updated EPG 123 in some time, but I don't think that's the cause, since it was working fine prior to the WU fiasco.

[9/10/2022 7:49:26 AM] Beginning epg123 client execution. version 1.3.4.0
[9/10/2022 7:49:26 AM] ===============================================================================
[9/10/2022 7:49:26 AM] [ INFO] Beginning epg123 client execution. 2022-09-10 11:49:26Z
[9/10/2022 7:49:26 AM] [ INFO] Import: True , Match: True , NoLogo: False , Force: False , ShowProgress: True
[9/10/2022 7:49:26 AM] Entering importMxfFile() for file "c:\programdata\garyan2\epg123\output\epg123.mxf"
[9/10/2022 7:50:05 AM] [ INFO] Error: The following error was encountered while processing the file. Aborting.
[9/10/2022 7:50:05 AM] [ INFO] RowSet::Seek failed on UId UIdI_UIdKey - HR = 0x80040e35, minor = 25155, 3944, 5340, 0, "c:\programdata\microsoft\ehome\mcepg3-1.db", "", ""
[9/10/2022 7:50:06 AM] [ERROR] Error using loadmxf.exe to import new guide information. Exit code: -1
[9/10/2022 7:50:06 AM] Exiting importMxfFile(). FAILURE.
[9/10/2022 7:50:06 AM] [ERROR] Failed to import .mxf file. Exiting.
[9/10/2022 8:06:43 AM] ===============================================================================
[9/10/2022 8:06:43 AM] Activating the epg123 client GUI. version 1.3.4.0
[9/10/2022 8:06:43 AM] ===============================================================================
[9/10/2022 8:06:44 AM] [ INFO] Successfully queried the Task Scheduler for status. Ready. Last Run 9/10/2022 7:15:59 AM; Exit: 0xFFFFFFFF
[9/10/2022 8:07:35 AM] Entering importMxfFile() for file "C:\ProgramData\GaRyan2\epg123\output\epg123.mxf"
[9/10/2022 8:11:32 AM] [ INFO] Error: The following error was encountered while processing the file. Aborting.
[9/10/2022 8:11:32 AM] [ INFO] ActorRole ActorRoleI_ProgramPersonCharacterKey: InsertRow() failed (attempt 0 of 10) for (1, E1B5090000001300000000000100000005A801000000050000000000000000006D15020000001800010000001A00000000000000540068006F006D006100730020005200650069006C006C00790000002000410072006900730074006F007300000000004400720065007900660075007300000000007200690061000000000074006500640029000000200043006800610070006C00610069006E0020002F00200043006100720074006500720020002F002000530070006100640067006500720020002F0020005300650072006700650061006E00740020004D0061006A006F00720020002F002000500061006B0065006E00680061006D002D00570061006C007300680020002F0020005200650061007200200045006E00640020002F0020004C006100640079002000700072006500730065006E0074006500720020002F0020004D0072002E0020004D0061007200760069006E002000480065006E006400790020002F0020004800610072007200790020002F0020005000610064007200650020002F00200044006500620062006900650020004B00610074007A0065006E00620065007200670020002F002000570069006E0064006F00770020005700610000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000E0B5090000000E00) - HR = 0x80004005, minor = 25155, 3748, 3648, 0, "c:\programdata\microsoft\ehome\mcepg3-1.db", "", ""
[9/10/2022 8:11:32 AM] [ERROR] Error using loadmxf.exe to import new guide information. Exit code: -1
[9/10/2022 8:11:32 AM] Exiting importMxfFile(). FAILURE.
[9/10/2022 8:13:14 AM] [ERROR] Unhandled thread exception caught from epg123Client.exe. message: RowSet::RestartPosition failed on Lineup. StackTrace= currentRowHandle=0 - HR = 0x80004005, minor = 25155, 3748, 3648, 0, "c:\programdata\microsoft\ehome\mcepg3-1.db", "", ""

[Space]

Looks like your WMC database may be corrupted.

Check out this post by Gary.

Also, you say you have not updated EPG123 in some time... 1.3.4.0 is pretty old, I'm not sure if it has the garbage cleanup that was added to EPG123 at some point. Without this cleanup there is a good chance you will eventually end up with a corrupted DB.

EDIT: Garbage cleanup was added in 1.3.8.0, so yes, you don't have it and could very well lead to the problem you are having now...

[Springsteen76]

Thanks! I'll give this a shot. I think I've tried the Rebuild Database but I don't remember if that was before or after I used a System Restore. I just hate messing with anything that is working, but I've done so much work to fix the latest Windows Update snafu that updating EPG is worth it at this point.

[sirlou2022]

Solved my problem as follows:

1. Tried to rebuild Database via EPG and that still failed.
2. Checked EPG123 Client and saw there was a new version.
3. D/L and install newest version and updated it.
4. Ran EPG123 Client again and EPG successfully updated.

sirlou

[Springsteen76]

Sorry for the delayed reply and thanks again for all of the help. Just updating EPG and cleaning the database, but that didn't work--or at least didn't work quickly enough for me to notice it. What did seem to help was updating the NET framework to the latest version. I haven't tried a manual import yet, but for the first time in a while I came down today to a guide full of listings!

I immediately created a System Restore point

Thanks to everyone for the help.