Announcement

**CFGuy** · January 1, 2008, 10:35 PM

If you look in the actual log file it should have the whole Insert statement. If you can get that then I'll take a look and try to figure out which value is causing the error.

**emtowle** · January 3, 2008, 01:39 PM

HSTV import log

1/1/2008 5:44:19 PM ~!~HSTV~!~Starting import of file: C:\Program Files\HomeSeer\data\hstv\listings\tv_grab_na_dd20080101.xml
1/1/2008 5:44:25 PM ~!~HSTV~!~INSERT INTO tvImport (channelID, channelname, channelnum, starttime, endtime, title, vrTitle, episode, description, category, episodenum, audio, subtitles, ratingsystem, rating, ratingadvisory, videoaspect, videocolor, starrating, actors, guests, director, producers, hosts, repeatshowing, programyear, channelDownload, configfile, viewhide) VALUES ('I10035.labs.zap2it.com','AETV','118',#2008/01/01 09:00:00#,#2008/01/01 10:00:00#,'CSI Miami','CSI Miami','No Man''s Land','Hijackers take a truck full of confiscated weapons, and Horatio links the crime to Clavo Cruz; a confiscated missile launched into the courthouse helps Clavo escape; a member of Horatio''s team is fatally shot.','Crime drama','..0/2','stereo','teletext','VCHIP','TV-14', Null,Null,Null,Null,'David Caruso,Emily Procter,Adam Rodriguez,Khandi Alexander,Jonathan Togo,Rex Linn,Eva LaRue','Brendan Fehr,Gonzalo Menendez,Robert Montano,Mykel Shannon Jenkins,Curtis Mark Williams,Danay Garcia,J.R. Villarreal,Gabriel Brock,Cody Lee,Billy Gallo,Shaun Baker,Jennifer Hall,Tom Choi,','Scott Lautanen',Null,Null,0,'2007',1,'tv_grab_na_dd',0)
1/1/2008 5:44:25 PM ~!~HSTV~!~Error Action Query: Invalid argument.

**CFGuy** · January 3, 2008, 06:38 PM

Is HSTV 3 the first version you have used or did you upgrade from an older version?

I copied the query you pasted and ran it in my access and it ran without error so I am trying to narrow down where to look to try to figure out why you are getting an error.

**emtowle** · January 4, 2008, 10:58 AM

Originally posted by CFGuy View Post

Is HSTV 3 the first version you have used or did you upgrade from an older version?

I copied the query you pasted and ran it in my access and it ran without error so I am trying to narrow down where to look to try to figure out why you are getting an error.

Yes, I upgraded from an earlier version soon after you poste the new version. It then worked until sometime in December and now it fails daily I believe.

I was also able to import that row from within access with no problem. My tvimport table was empty and now contains this one row.

**emtowle** · January 8, 2008, 10:52 AM

Originally posted by emtowle View Post

Yes, I upgraded from an earlier version soon after you poste the new version. It then worked until sometime in December and now it fails daily I believe.

I was also able to import that row from within access with no problem. My tvimport table was empty and now contains this one row.

Any thoughts?

**skozin** · January 9, 2008, 12:17 AM

Jeff, I am having the same problem. It stopped working about 2 weeks ago. I noticed that when it downloads the data it is saying that it is going into the listings folder but there are no xml files per day. Also, the ddmessages.xml file gives me this error:

The XML page cannot be displayed
Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later.

--------------------------------------------------------------------------------

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

<html><head><title>Apache Tomcat/5.5.17 - Error report</title><style><!--H1 {font-family:Ta...

Also, when I check the database there is no imported data for the last 2 weeks. I don't know why this is happening. Any suggestions?

Thanks,
Steve

**skozin** · January 9, 2008, 12:23 AM

Jeff:

Also nothing is being imported into the database. This has been happening for about 2 weeks. Any suggestions?

Thanks,
Steve

**CFGuy** · January 9, 2008, 02:46 PM

Since 2 of you are just starting to have a problem and had been fine working before I'm not sure of anything that would have changed.

I would say check the xmltv site to see if there is a newer version.

Check at the schedules direct site to make sure your profile is still set correctly.

Restart HomeSeer, perhaps something messed up the database connection between HSTV and hstv.mdb. Restarting HS would also restart HSTV and fix the connection if that is the problem.

One other thing what is the size of your Access db? If its over 1 GB then you need to run the Compact and Repair option in Access.

**skozin** · January 9, 2008, 09:31 PM

Jeff:

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:

/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></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>

Don't know what this means.

I hope you can help. I love this program.

Thanks,
Steve

**Wadenut** · January 20, 2008, 09:36 AM

On a positive note, I think I've tracked down the cause of my system crashes.
HSTV was running in the middle of the night and so. it seems, was my Kaskersky Antivirus scan. I've moved the HSTV event to 10:00AM when all but a couple of days per week, no-one is home anyway and even then not much goes on as far as motion sensor activity.
Since realizing this, I've had three days of no crashes. I plan to move the Kaspersky activity to run after HSTV during the night.

Anyway. I still have a couple of problems. I've created a single event to run HSTV update functions sequentially and this works OK. There are a couple of error messages however:

1/20/2008 10:00:00 AM - Info - Event Trigger "HSTV Download and Import Listings"
1/20/2008 10:00:00 AM - Info - Running script and waiting: &hs.Plugin("HSTV").dataDownload()
1/20/2008 10:00:29 AM - HSTV - Trigger Expire Date: Object reference not set to an instance of an object.
1/20/2008 10:00:29 AM - Info - Running script and waiting: &hs.Plugin("HSTV").dataImport()
1/20/2008 10:18:42 AM - Info - Waiting 2 minute(s) 0 second(s) 0 millisecond(s)
1/20/2008 10:20:42 AM - Info - Running script and waiting: &hs.Plugin("HSTV").dataInsert()
1/20/2008 10:21:23 AM - HSTV - Error Import Cleanup: String cannot be of zero length.Parameter name: oldValue

Lines three and seven from this log extract show the error which show up daily. There doesn't seem to be any problem with the final listing however.
In addition, old XML files aren't being deleted. This has been a problem from the start and I usually just periodically delete the files manually.

A bit of advice for those experencing sudden onset of database problems. Keep a copy of the empty HSTV database in a safe place. I've had to use this a couple of times when errors started popping up during import. I suppose the database had been corrupted when my sys rebooted. You can use Access to delete all records from an existing copy and then compact and save the file for future use.

**bmora** · January 21, 2008, 09:20 PM

It appears I'm having the same issue. Starting on 01/04 My log is getting FILLED with HSTV information. It has been working fine for several months.

Nothing has changes with my system.. Any thoughts on this??

1/5/2008 5:03:26 AM ~!~HSTV~!~INSERT INTO tvImport (channelID, channelname, channelnum, starttime, endtime, title, vrTitle, episode, description, category, episodenum, audio, subtitles, ratingsystem, rating, ratingadvisory, videoaspect, videocolor, starrating, actors, guests, director, producers, hosts, repeatshowing, programyear, channelDownload, configfile, viewhide) VALUES ('I16615.labs.zap2it.com','DTIMES','105',#2008/01/05 20:00:00#,#2008/01/05 21:00:00#,'Supermax','Supermax','The SHU Nurse','Nurses of the Secured Housing Unit; a child murderer is stabbed; weightlifting competition.','Documentary','EP00440413.0001',Null,'teletext ','VCHIP','TV-PG', Null,Null,Null,Null,Null,Null,Null,Null,Null,0,'2001',1,'tv_ grab_na_dd',0)
1/5/2008 5:03:26 AM ~!~HSTV~!~Error Action Query: Invalid argument.
1/5/2008 5:03:26 AM ~!~HSTV~!~INSERT INTO tvImport (channelID, channelname, channelnum, starttime, endtime, title, vrTitle, episode, description, category, episodenum, audio, subtitles, ratingsystem, rating, ratingadvisory, videoaspect, videocolor, starrating, actors, guests, director, producers, hosts, repeatshowing, programyear, channelDownload, configfile, viewhide) VALUES ('I16615.labs.zap2it.com','DTIMES','105',#2008/01/05 21:00:00#,#2008/01/05 22:00:00#,'Supermax','Supermax','Internal Affairs','Knife-wielding inmates attack a security guard; inmate argues with prison lawyer.','Documentary','EP00440413.0002',Null,'teletext','VC HIP','TV-PG', Null,Null,Null,Null,Null,Null,Null,Null,Null,0,'2001',1,'tv_ grab_na_dd',0)

**CFGuy** · January 22, 2008, 09:36 AM

First thing take a look at the database. If it is over a gig you need to close HomeSeer, open Access and do a Repair/Compact on the database.

That usually fixes the odd errors that just start happening with no changes.
Also if you are getting tons of entries in the log, check and see what setting you have the debug info set to. It's on the HSTV General Options page. If you have it set to high, it will fill your log.

**bmora** · January 23, 2008, 08:41 AM

The Repair/Compact worked!! The DB was over 2gigs now is 900kb! So going forward is this something that will need to be done on a regular basis? Thanks Jeff!!

**CFGuy** · January 24, 2008, 09:02 PM

Yeah, it will need to be done as it starts getting too big.

Someone posted a script that will do it automatically whenever you restart HS.
I tried to build it into HSTV but the database locks when its in use and the compact fails.

Announcement

HSTV import error messages

HSTV import error messages

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment