Page 1 of 1

Guide File Won't Load

Posted: Sat Nov 16, 2019 3:14 am
by tardyturtle
Gary,

First off, thanks again for creating such a great program!

I have been having a number of issues with my HTPC, likely most unrelated to EPG123. WMC would crash whenever I would try to do almost anything, and this would be fixed by a restart (but then recur later in the day). I did a system restore which fixed the issue, but then I got a notification that I only have a couple days' worth of guide data.

Looking through the logs, everything appeared to update properly last night

Code: Select all

[11/15/2019 12:07:41 AM] [ INFO] Generated .mxf file contains 583 services, 8763 series, 48985 programs, and 70613 people with 14298 image links.
[11/15/2019 12:07:41 AM] [ INFO] Completed EPG123 update execution. SUCCESS.
[11/15/2019 12:07:41 AM] [ INFO] epg123 update execution time was 00:07:40.8688171.
I figured I would try to re-execute the guide update in EPG123. Everything seems to work fine until the mxf file is getting imported. At around 30%, the progress window closes. I tried updating to the latest version and get the same issue. Now the current version of the Client seems to freeze and crash upon opening. When using an older version of the software to manually import the MXF file, I get the following:

Code: Select all

************** Exception Text **************
System.InvalidOperationException: RowSet::SetData failed (name=MergedLineup MergedLineupI_StoredObjectIdKey, rowHandle = 1, accessorHandle = 1) - HR = 0x80004005, minor = 25104, 2049, 0, 0, "", "", ""
   at MediaCenter.Store.SqlLite.Rowset.SetData(Byte[] data)
   at MediaCenter.Store.OleDB.StoredObjectsEnumerator.Update(Object obj, FieldBindings fieldBindings)
   at MediaCenter.Store.OleDB.StoredObjectRecord.Update(UpdateDelegate operation)
   at Microsoft.MediaCenter.Store.StoredObject.Update(UpdateDelegate operation)
   at epg123.clientForm.clientForm_FormClosing(Object sender, FormClosingEventArgs e)
   at epg123.clientForm.btnRefreshLineups_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ButtonBase.WndProc(Message& m)
   at System.Windows.Forms.Button.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Any ideas what is causing this?

Thanks in advance!

Re: Guide File Won't Load

Posted: Sat Nov 16, 2019 3:56 am
by garyan2
Looks like your WMC database is corrupted. I suggest you run "start /wait c:\windows\ehome\mcupdate.exe -uf -dbgc" from a command prompt. Wait for it to complete and then try to update again.

If it still fails, then you might need to do a database rebuild using the client guide tool.

Re: Guide File Won't Load

Posted: Sat Nov 16, 2019 4:25 am
by tardyturtle
Gary—you are quick!

After I posted, I tried restoring to an old image I had an re-running the update and everything seems to be working now. I probably took the difficult route to fixing the corrupt file :D

I was also having issues with the client tool always freezing up and crashing every time I try to run it.

With the database file being corrupted and having the previous issues with crashing, I’m starting to wonder if my SSD may be going bad... may be time to get a new drive.

Thanks again for your help!

Re: Guide File Won't Load

Posted: Sat Nov 16, 2019 4:43 am
by garyan2
Glad you got it running again.

The client crashing is more than likely related to the corrupted database, so I wouldn't think of them as separate. It is also not unheard of for the database to become corrupted, so time will tell if it happens again.