Problem with HSTV 3.0

[skozin]

Jeff: I started a new thread because I can't seem to add anything else on the last one:

I don't know what could be going on here. I restarted Homeseer and checke d if I have the latest version of Xmltv and I have the latest 5.50 from November 2007. The error that I noticed is this:

1/9/2008 8:17:30 PM Info Event Trigger "HSTV Download XML Files"
1/9/2008 8:17:30 PM Info Running script statement immediately: &hs.Plugin("HSTV").DataDownload()
1/9/2008 8:17:30 PM HSTV Data Import: Downloading XML files.
1/9/2008 8:17:30 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 0 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080109.xml
1/9/2008 8:17:32 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 1 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080110.xml
1/9/2008 8:17:33 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 2 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080111.xml
1/9/2008 8:17:34 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 3 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080112.xml
1/9/2008 8:17:35 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 4 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080113.xml
1/9/2008 8:17:36 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 5 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080114.xml
1/9/2008 8:17:37 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 6 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080115.xml
1/9/2008 8:17:37 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 7 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080116.xml
1/9/2008 8:17:38 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 8 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080117.xml
1/9/2008 8:17:39 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 9 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080118.xml
1/9/2008 8:17:40 PM HSTV Running xmltv.exe tv_grab_na_dd --days 1 --offset 10 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080119.xml
1/9/2008 8:17:41 PM HSTV Running xmltv.exe tv_grab_na_dd --dd-data "C:\Program Files\HomeSeer 2\data\hstv\ddmessages.xml " --list-lineups
1/9/2008 8:18:00 PM HSTV Checking for Scheduled Actions
1/9/2008 8:18:00 PM HSTV SELECT top 1 c.channelID, c.channelNickName, c.channelName, c.channelNumber, s.starttime, l.endtime, l.title, l.episode, l.category, l.description FROM scheduledFavs s, tvListings l, tvChannels c WHERE s.starttime > Now() And s.channelID = l.channelID And s.starttime = l.starttime And l.channelID = c.channelID And s.isActive = 1 ORDER BY s.starttime
1/9/2008 8:18:45 PM Info Event Trigger "HSTV Import XML FIles"
1/9/2008 8:18:45 PM Info Running script statement immediately: &hs.Plugin("HSTV").dataImport()
1/9/2008 8:18:45 PM HSTV Data Import: Importing XML files.
1/9/2008 8:18:45 PM HSTV Deleting records from tvImport table.
1/9/2008 8:18:45 PM HSTV sql=DELETE * FROM tvImport
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080109.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080109.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080110.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080110.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080111.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080111.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080112.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080112.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080113.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080113.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080114.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080114.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080115.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080115.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080116.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080116.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080117.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080117.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080118.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080118.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV SELECT rating, ratingID FROM tvRatings WHERE ratingID = 1
1/9/2008 8:18:46 PM HSTV Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080119.xml
1/9/2008 8:18:46 PM HSTV ImportFile, tv_grab_na_dd20080119.xml is missing. Skipping import.
1/9/2008 8:18:46 PM HSTV Imported 0 in 0 minutes


It says that it is putting the xml file into the proper area but if I open up that folder (Listings), there is nothing in there just the hstv icon and the xmltv.dtd file. What would all of a sudden make this happen. The reason why I did not notice this earlier was because I had 10 days of programing in advance and was also on vacation.

The hstv.mdb file was big, I think over a gig, so I did what you said and compacted and repaired it. I also deleted all the old data in it. Still won't put any xml files in Listings folder.

The other error message I get was in the ddmessages.xml file. This was in this file:

<html><head><title>Apache Tomcat/5.5.17 - Error report</title><style><!--H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}HR {color : #525D76;}--></style> </head><body><h1>HTTP Status 401 - </h1><HR size="1" noshade="noshade"><p><b>type</b> Status report</p><p><b>message</b> <u></u></p><p><b>description</b> <u>This request requires HTTP authentication ().</u></p><HR size="1" noshade="noshade"><h3>Apache Tomcat/5.5.17</h3></body></html>


End tag 'body' does not match the start tag 'HR'. Error processing resource 'file:///C:/Program Files/HomeSeer 2/DATA/hstv/...


Don't know what this means.

I hope you can help. I love this program.

Thanks,
Steve

[CFGuy]

Check your config file and make sure your password is there.

I would also check your subscription at Schedules Direct. Make sure everything is selected correctly there. There was a report of someones lineup disappearing.

http://forums.schedulesdirect.org/vi....php?f=5&t=525

[skozin]

No, that didn't help.

any other ideas?

Thanks,
Steve

[skozin]

Update

It was the guide that needed to be reset. Once I did this, I went into the config file and reinserted my password and all of a sudden when I downloaded the xml files appeared in the listings folder. That was weird. If there are any other issues I will let you know.

Thanks,
Steve

[skozin]

Jeff:

I noticed that when Microsoft Access is running with Homeseer you can't compact the database. It says that Access is being used by another use 'Admin' and you don't have permission to compact and repair the database. Is there a way to make an event in Homeseer to do this? I think that was creating one of the problems that I was having which locked up the database and made it over 1 gig.

Also, I got this error when importing data:

1/10/2008 5:32:00 AM ~!~Info~!~Event Trigger "HSTV Import Data"
1/10/2008 5:32:00 AM ~!~Info~!~Running script statement immediately: &hs.Plugin("HSTV").dataInsert()
1/10/2008 5:32:00 AM ~!~HSTV~!~Error Query: SELECT Distinct channelID, channelname, channelnum, configfile FROM tvImport WHERE channelID NOT In (SELECT channelID FROM tvChannels) ORDER BY channelID
1/10/2008 5:32:00 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
1/10/2008 5:32:00 AM ~!~HSTV~!~Error Import Cleanup: Operation is not allowed when the object is closed.

Why am I getting this. I reran this event at 6:50am and there was no error and the database imported all of the data. According to my status page the 2nd event only took 12 minutes to import the xml data so there should have been enough time to do the 3rd event.


Any suggestions?

[CFGuy]

Jeff:

I noticed that when Microsoft Access is running with Homeseer you can't compact the database. It says that Access is being used by another use 'Admin' and you don't have permission to compact and repair the database. Is there a way to make an event in Homeseer to do this? I think that was creating one of the problems that I was having which locked up the database and made it over 1 gig.

I have tried several ways to get HSTV to do this automatically. Nothing I have tried releases the db quick enough for the compact to work.
Usually when I have db questions I go to the admin where I work, but we don't use Access.
I have to remember to stop HS every so often so I can compact my db as well and would really like to find a way to do it automatically.

[skozin]

Jeff:

What about this error message:

1/10/2008 5:32:00 AM ~!~Info~!~Event Trigger "HSTV Import Data"
1/10/2008 5:32:00 AM ~!~Info~!~Running script statement immediately: &hs.Plugin("HSTV").dataInsert()
1/10/2008 5:32:00 AM ~!~HSTV~!~Error Query: SELECT Distinct channelID, channelname, channelnum, configfile FROM tvImport WHERE channelID NOT In (SELECT channelID FROM tvChannels) ORDER BY channelID
1/10/2008 5:32:00 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
1/10/2008 5:32:00 AM ~!~HSTV~!~Error Import Cleanup: Operation is not allowed when the object is closed.


What does this mean?

Steve

[CFGuy]

I know what the error messages mean, but I don't know why that particular query would have errored.
Do you get this every day? Or was it just that one day?

If it was pre-compacting then I think it is due to the flakiness of Access when its to big.

[skozin]

I have gotten this every day lately. I just reconfigured the database so the maximum size was 214,000 kb. Using Dish network with 10 days of info makes the database big.

FYI

Steve

[johnnybwis]

It was the guide that needed to be reset. Once I did this, I went into the config file and reinserted my password and all of a sudden when I downloaded the xml files appeared in the listings folder. That was weird. If there are any other issues I will let you know.

Thanks,
Steve

What do you mean by reset guide.
I am trying to reinstall hstv and it jumps from step four to step six and then to step eight. I am getting the same error:
1/11/2008 5:04:48 PM - HSTV - Starting import of file: C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20080113.xml
1/11/2008 5:04:48 PM - HSTV - ImportFile, tv_grab_na_dd20080113.xml is missing. Skipping import.

[skozin]

Reset guide means that I had to go to Schedules direct and delete my lineup and then reinstall the lineup. After I did this, I went into my tv_grab_dd.conf file and put my password in it. For some reason it got deleted. The next step was to rerun the events and then the xml files started appearing. Are you using Schedules direct or Zap 2 It. Zap 2 it is no longer being used.

Hope this helps,

Steve