Page 1 of 1

Failed to import MXF file

Posted: Mon Aug 10, 2020 7:21 pm
by dmagerl
EPG123 has been work great for months. All of a sudden I ran out of listings. Running the EPG123 program and "save and execute" creates the mxf file, but the epg123 client, when doing a manual import, aborts.

I tried attaching the trace.log file but i cant get the forum software to accept the file.

Here is what I think the relevant part of the file is:

Any help is appreciated. I'm above my pay grade with this.

===============================================================================
[8/10/2020 1:47:19 PM] Activating the epg123 client GUI. version 1.3.0.0
[8/10/2020 1:47:19 PM] ===============================================================================
[8/10/2020 1:47:20 PM] [ INFO] Successfully queried the Task Scheduler for status. Ready. Last Run 8/10/2020 1:36:37 PM; Exit: 0x00041301
[8/10/2020 1:47:35 PM] Entering importMxfFile() for file "C:\ProgramData\GaRyan2\epg123\output\epg123.mxf"
[8/10/2020 1:48:12 PM] [ INFO] Error: The following error was encountered while processing the file. Aborting.
[8/10/2020 1:48:12 PM] [ INFO] Program: InsertRow() failed (attempt 0 of 10) for (1, 98B55E0200000E00000000000100000041997700000005000000000000000000200000004F007500720020004A0065007700690073006800200052006F006F0074007300000048006F0075007200000047006F00640000005300740061006E006C0065007900000020004B0065006E006D006F0072006500200049006E00740075006900740069006F006E000000200056006F007400650020003200300032003000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000B20000004200690062006C00650020007400650061006300680069006E00670020007700690074006800200061006E00200065006D0070006800610073006900730020006F006E002000700072006F00700068006500630079002C002000490073007200610065006C00200061006E006400200074006800650020004A0065007700690073006800200072006F006F007400730020006F0066002000430068007200690073007400690061006E006900740079002E000000650020004200690062006C0065002E00000070006900720069007400750061006C0020006200690072007400680020006900730020006C0069006B00650020006E00610074007500720061006C002000620069007200740068002E0000007400680072006F00750067006800200074006800650020006D0069006E00690073007400720069006500730020006F0066002000440072002E00200059006F0075007300730065006600200061006E00640020004C0065006100640069006E006700200054006800650020005700610079002E0020004C006500610072006E0020006D006F00720065002000610062006F00750074002000680069006D00200061006E00640020004C0065006100640069006E0067002000540068006500200057006100790020006100740020004C00540057002E006F00720067002E0000000000200074006800650020006D00610064006E006500730073002E00200054006800650020007300650072006900650073002C00200074006F006C0064002000660072006F006D0020004800610072006C006500790027007300200070006F0069006E00740020006F006600200076006900650077002C002000740065006E0064007300200074006F002000660069006E0064002000680075006D006F007200200069006E00200074006800650020006F007400680065007200770069007300650020006D0075006E00640061006E0065002000680061007000700065006E0069006E006700730020006F00660020006500760065007200790064006100790020006C006900660065002E00200054006800650020006D0065006E0061006700650072006900650020007400680061007400200069007300200074006800650020004400690061007A0020006300680069006C006400720065006E00200069006E0063006C0075006400650073002000730065006C0066002D0069006E0076006F006C007600650064002000520061006300680065006C002C0020006200610073006B0065007400620061006C006C002D0070006C006100790069006E0067002000470065006F0072006700690065002C00200069006E00760069006E006300690062006C00650020007400770069006E00730020004C006500770069006500200061006E00640020002200420065006100730074002C00220020007300740072006F006E0067002D00770069006C006C0065006400200079006F0075006E0067007300740065007200200044006100700068006E0065002C00200061006E006400200045007400680061006E002C0020004800610072006C006500790027007300200063006C006F007300650073007400200061006C006C0079002E0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000006500610072006E0069006E0067002000610062006F007500740020006E00650077002000620069007200740068002000660072006F006D0020004A006500730075007300200061006E00640020004E00690063006F00640065006D0075007300200061006E006400200068006F0077002000730070006900720069007400750061006C0020006200690072007400680020006900730020006C0069006B00650020006E00610074007500720061006C002000620069007200740068002E00000067002E000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001A000000540077006F0020005700690074006E006500730073006500730000002000420075006D007000200069006E00200074006800650020004E006900670068007400000075007200650020004500760065006E00740073000000630065006E0074002000500072006F0070006F00730061006C003F002100000074006800650020005200200057006F0072006400210000000000210000006400730020006F006E002000420061007400680072006F006F006D002000570061006C006C0073003B002000530075006D006D00650072006C0061006E00640000003F0020004D0069007200610063006C00650020005400770069006E00730021000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000400000065006E0000000000000000000000000000000000000000000000E40700001A00000000803053C03CD808DD4A23EF5D3DD80800000000000000006A975E020000200027439A0000001F00000000000000000000000000000000000000FFFF00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000FFFF0000000000000000) - HR = 0x80004005, minor = 25104, 2049, 0, 0, "", "", ""
[8/10/2020 1:48:12 PM] [ERROR] Error using loadmxf.exe to import new guide information. Exit code: -1
[8/10/2020 1:48:12 PM] Exiting importMxfFile(). FAILURE.
[8/10/2020 1:48:21 PM] ===============================================================================
[8/10/2020 1:48:21 PM] Activating the epg123 configuration GUI. version 1.3.0.0
[8/10/2020 1:48:21 PM] ===============================================================================
[8/10/2020 1:48:22 PM] [ INFO] epg123 is not up to date. Latest version is 1.3.9 and can be downloaded from http://epg123.garyan2.net.
[8/10/2020 1:48:23 PM] [ INFO] Successfully queried the Task Scheduler for status. Ready. Last Run 8/10/2020 1:36:37 PM; Exit: 0x00041301
[8/10/2020 1:48:23 PM] [ INFO] Token request successful. serverID: 20141201.web.1
[8/10/2020 1:48:23 PM] [ INFO] Status request successful. account expires: 2020-12-11T18:15:08Z , lineups: 4/4 , lastDataUpdate: 2020-08-10T14:21:06Z
[8/10/2020 1:48:23 PM] [ INFO] system status: Online , message: No known issues.
[8/10/2020 1:48:23 PM] [ INFO] Successfully requested listing of client lineups from Schedules Direct.
[8/10/2020 1:48:23 PM] [ INFO] Successfully retrieved the station mapping for lineup USA-OTA-53186.
[8/10/2020 1:48:24 PM] [ INFO] Successfully retrieved the station mapping for lineup USA-OTA-53701.
[8/10/2020 1:48:24 PM] [ INFO] Successfully retrieved the station mapping for lineup USA-OTA-60195.
[8/10/2020 1:48:24 PM] [ INFO] Successfully retrieved the station mapping for lineup USA-OTA-61102.

Re: Failed to import MXF file

Posted: Mon Aug 10, 2020 7:31 pm
by garyan2
Your WMC database is corrupted. Starting with EPG123 v1.3.8.0, I added the ability for EPG123 to handle database maintenance which would have happened every 5 days before MS shut down their servers which provided the client maintenance package. First thing to try is to perform a garbage cleanup manually from a command prompt "start /wait c:\windows\ehome\mcupdate.exe -dbgc -updateTrigger". When it completes, try again.

If it still fails, you will have to use the [Rebuild WMC Database] button in the client.

Either way, I recommend you update EPG123 to the latest version so the database maintenance will once again be performed every 5 days to avoid situations like this.

Re: Failed to import MXF file

Posted: Wed Aug 12, 2020 12:28 pm
by dmagerl
Here's an update. Success! But I dont know what fixed it.

First I tried that mcupdate command. No change.
Then I tried the Rebuild Database button. No change
Then I updated to latest EPG123. No change.
Then I tried the Rebuild Database button again. Fixed! MXF file imported with no errors.

So does that make sense? That the new version allowed the Rebuild Database button to work? Or is it just coincidence?

In any case, it's working so I'm happy.

Re: Failed to import MXF file

Posted: Wed Aug 12, 2020 2:49 pm
by garyan2
The first rebuild should have taken care of it unless it failed to delete the current database. Was there anything in the trace.log file to indicate problems doing the rebuild?