Related to the HUGE Database????

[Landru]

As I previously posted, gbpvr.mdb is 2GB. Now two new issues:

Config.exe will not shutdown properly. Hit the ok button and it goes off into Never-Never land. Ending the process after an hour in the task manager generates a log to send to Microsoft and config window just stays there until I reboot.

2) EPG download is failing. Relavent area in config.exe log file is:

3/8/2006 8:24:12 PM.593 VERBOSE [12] labelAction.Text = Requesting listing information from Zap2it.com
3/8/2006 8:24:12 PM.796 ERROR [165] Error UpdateEPG()'ing: System.Net.WebException: The operation has timed-out.
at System.Net.HttpWebRequest.GetRequestStream()
at System.Net.WebClient.UploadData(String address, String method, Byte[] data)
at GBPVR.Backend.Common.Zap2itEpgReader.x7174d5399cba81ee(IEpgUpdateProgressCallback x421ce789b9741187, DateTime xdc88f59e43b65f7f, DateTime x33db96d2cea26583)
at GBPVR.Backend.Common.Zap2itEpgReader.LoadChannels(IEpgUpdateProgressCallback x421ce789b9741187)
at GBPVR.Backend.Common.EpgUpdater.x52e8ddd0b9bc8c68(xda34526142ca690b x347261624b519e9a, IEpgUpdateProgressCallback x421ce789b9741187)
at xeb983fa94d0b4753.xca74b9c9b310df0b.xcba1f05fb5a46d5f()
3/8/2006 8:24:13 PM.593 VERBOSE [12] labelAction.Text = Requesting listing information from Zap2it.com
3/8/2006 8:24:14 PM.593 VERBOSE [12] labelAction.Text = Requesting listing information from Zap2it.com

Any ideas? Thanx!

[AOSandman]

Here's a simple 5 line batch file that can fix things up for you. Just make sure nothing is recording when you run it, since it will stop & restart the recording service.

net stop "GB-PVR Recording Service"
del gbpvr.mdb.backup
ren gbpvr.mdb gbpvr.mdb.backup
jetcomp.exe -src:gbpvr.mdb.backup -dest:gbpvr.mdb
net start "GB-PVR Recording Service"

[sub]

As I previously posted, gbpvr.mdb is 2GB. Now two new issues:

Config.exe will not shutdown properly. Hit the ok button and it goes off into Never-Never land. Ending the process after an hour in the task manager generates a log to send to Microsoft and config window just stays there until I reboot.

2) EPG download is failing. Relavent area in config.exe log file is:

3/8/2006 8:24:12 PM.593 VERBOSE [12] labelAction.Text = Requesting listing information from Zap2it.com
3/8/2006 8:24:12 PM.796 ERROR [165] Error UpdateEPG()'ing: System.Net.WebException: The operation has timed-out.
at System.Net.HttpWebRequest.GetRequestStream()
at System.Net.WebClient.UploadData(String address, String method, Byte[] data)
at GBPVR.Backend.Common.Zap2itEpgReader.x7174d5399cba81ee(IEpgUpdateProgressCallback x421ce789b9741187, DateTime xdc88f59e43b65f7f, DateTime x33db96d2cea26583)
at GBPVR.Backend.Common.Zap2itEpgReader.LoadChannels(IEpgUpdateProgressCallback x421ce789b9741187)
at GBPVR.Backend.Common.EpgUpdater.x52e8ddd0b9bc8c68(xda34526142ca690b x347261624b519e9a, IEpgUpdateProgressCallback x421ce789b9741187)
at xeb983fa94d0b4753.xca74b9c9b310df0b.xcba1f05fb5a46d5f()
3/8/2006 8:24:13 PM.593 VERBOSE [12] labelAction.Text = Requesting listing information from Zap2it.com
3/8/2006 8:24:14 PM.593 VERBOSE [12] labelAction.Text = Requesting listing information from Zap2it.com

Any ideas? Thanx!

Can you manually run jetcomp.exe from the gbpvr directory? Select the source file as gbpvr.mdb. Set the destination to something like temp.mdb, then hit the 'compact' button. I suspect it'll spit out an error. I'd be curious to know what that error says?

[Landru]

Got the database compressed, thax for the pointers.

Config will now sort of exit, the window shows a not responding message and I can get out of it.

When I tried to do a manual epg update I found the following in the config.exe-native logfile to go along with what is show in my first post for the config.exe logfile:

21:24:07.625 INFO Log started
21:24:07.625 VERBOSE FindFilterByName failed to locate filter: GB-PVR PSI Parser
21:24:07.687 VERBOSE FindFilterByName failed to locate filter: GB-PVR WST SRT Digital
21:24:07.750 VERBOSE FindFilterByName failed to locate filter: GB-PVR WST SRT Analog
21:24:08.687 VERBOSE getSetting(OSDTransparency)

Would these errors have anything to do with the epg update failing?

Thanx!

[sub]

Got the database compressed, thax for the pointers.

Config will now sort of exit, the window shows a not responding message and I can get out of it.

Did you get any error when you ran jetcomp manually?

21:24:07.625 INFO Log started
21:24:07.625 VERBOSE FindFilterByName failed to locate filter: GB-PVR PSI Parser
21:24:07.687 VERBOSE FindFilterByName failed to locate filter: GB-PVR WST SRT Digital
21:24:07.750 VERBOSE FindFilterByName failed to locate filter: GB-PVR WST SRT Analog
21:24:08.687 VERBOSE getSetting(OSDTransparency)

Would these errors have anything to do with the epg update failing?

No, it wont be causing that, but you can run the Re-RegisterFilters.bat file to correct these messages in the logs.

[sub]

3/8/2006 8:24:12 PM.593 VERBOSE [12] labelAction.Text = Requesting listing information from Zap2it.com
3/8/2006 8:24:12 PM.796 ERROR [165] Error UpdateEPG()'ing: System.Net.WebException: The operation has timed-out.

Based on that error message, I would guess one of two problems:

1) Firewall, virus scanner or filter software (net nanny etc) getting in the way
2) or, large channel lineup and slow internet connection.

[ydekmekji]

Hey Sub... you are the master multi-tasker--new born baby and respond to forum questions... nice! (but then again, what else did i do when my little one slept for 16-20 hours a day...)

[sub]

Yeah, the new one is doing plenty of sleeping. The previous one didnt. I've been a bit bored - so I'm answering a few questions. I'm not working on the next release though. I'll have a few weeks off from coding since it requires too much concentration and time.

[Landru]

Sub,

No errors when I ran jetcomp manually, once I shut down all of GBPVR.

You were right about the download issue, when I disabled Norton Internet Security, I got a good download. Now I need to find out what in it is causing the problem.

And congrats on the new little one! I have tow of my own, my son turns 6 Saturday, my daughter is 8 and a half.

Cheers! And Thanx for the help!
Landru