Recently I upgraded to HS 2 v2.4 (from v2.2.0.66) and seem to have lost many of my Events via a corrupted database. I'm not sure that's the issue with the following error message since I recreated all the HSTV events and the downloads appear to be working ok. But, since this erros is comes up at times when download isn't going on, I wanted to see what might be the root cause. Here are the messages that I found in the log which happen every day (or so it seems):
11/24/2009 12:13:30 AM ~!~UltraLog Error~!~An unexpected error occured in the PurgeLogs() function/subroutine: [System.InvalidCastException: Unable to cast object of type 'System.Data.OleDb.OleDbException' to type 'System.Data.Odbc.OdbcException'. at HSPI_ULTRALOG.Database.PurgeLogs(Hashtable PurgeHash)]
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Query: SELECT s.scheduledID, s.favID FROM userFavs u, scheduledFavs s WHERE u.favID = s.favID AND u.repeatType = 0 AND s.starttime < Now()
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Query: SELECT s.scheduledID, s.favID FROM userFavs u, scheduledFavs s WHERE u.favID = s.favID AND u.repeatType = 0 AND s.starttime < Now()
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Delete Old User Favs: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Delete Old User Favs: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 4:46:00 AM ~!~Event~!~Event Trigger "HSTV Download XML Files"
11/24/2009 4:46:00 AM ~!~Event~!~Running script statement immediately: &hs.Plugin("HSTV").dataDownload()
11/24/2009 4:46:01 AM ~!~HSTV~!~tv_grab_na_dd20091124.xml already exists. Skipping download.
11/24/2009 4:46:01 AM ~!~HSTV~!~tv_grab_na_dd20091125.xml already exists. Skipping download.
11/24/2009 4:46:01 AM ~!~HSTV~!~tv_grab_na_dd20091126.xml already exists. Skipping download.
11/24/2009 4:46:01 AM ~!~HSTV~!~Running xmltv.exe tv_grab_na_dd --days 1 --offset 3 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20091127.xml
11/24/2009 4:47:31 AM ~!~HSTV~!~Running xmltv.exe tv_grab_na_dd --dd-data "C:\Program Files\HomeSeer 2\data\hstv\ddmessages.xml " --list-lineups
Any help or advice would be appreciated. Thanks in advance.
11/24/2009 12:13:30 AM ~!~UltraLog Error~!~An unexpected error occured in the PurgeLogs() function/subroutine: [System.InvalidCastException: Unable to cast object of type 'System.Data.OleDb.OleDbException' to type 'System.Data.Odbc.OdbcException'. at HSPI_ULTRALOG.Database.PurgeLogs(Hashtable PurgeHash)]
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Query: SELECT s.scheduledID, s.favID FROM userFavs u, scheduledFavs s WHERE u.favID = s.favID AND u.repeatType = 0 AND s.starttime < Now()
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Query: SELECT s.scheduledID, s.favID FROM userFavs u, scheduledFavs s WHERE u.favID = s.favID AND u.repeatType = 0 AND s.starttime < Now()
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:30 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Delete Old User Favs: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Delete Old User Favs: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is open.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Query: 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
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Select Query: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 12:13:31 AM ~!~HSTV~!~Error Next Scheduled: Operation is not allowed when the object is closed.
11/24/2009 4:46:00 AM ~!~Event~!~Event Trigger "HSTV Download XML Files"
11/24/2009 4:46:00 AM ~!~Event~!~Running script statement immediately: &hs.Plugin("HSTV").dataDownload()
11/24/2009 4:46:01 AM ~!~HSTV~!~tv_grab_na_dd20091124.xml already exists. Skipping download.
11/24/2009 4:46:01 AM ~!~HSTV~!~tv_grab_na_dd20091125.xml already exists. Skipping download.
11/24/2009 4:46:01 AM ~!~HSTV~!~tv_grab_na_dd20091126.xml already exists. Skipping download.
11/24/2009 4:46:01 AM ~!~HSTV~!~Running xmltv.exe tv_grab_na_dd --days 1 --offset 3 --output "C:\Program Files\HomeSeer 2\data\hstv\listings\tv_grab_na_dd20091127.xml
11/24/2009 4:47:31 AM ~!~HSTV~!~Running xmltv.exe tv_grab_na_dd --dd-data "C:\Program Files\HomeSeer 2\data\hstv\ddmessages.xml " --list-lineups
Any help or advice would be appreciated. Thanks in advance.
Comment