Hi - I've recently upgraded to v2.4. I'm not sure this problem is related to that but I wanted to note that anyway. I've noticed at various times of the day, I get some strange error messages. I thought they were associated with HSTV and started looking in that forum for help. Rupp suggested I downgrade to HS 2.3 which isn't really an option for me. But, Richard noted that these problems were coming from Ultralog and referred me to you (http://board.homeseer.com/showthread.php?t=138879) I'm not sure what to do next. Here's the thread that contains the error messages which started this whole search http://board.homeseer.com/showthread.php?t=138850
I would appreciate any suggestions you might have. And, if this same topic is covered elsewhere in this forum, could you provide reference to the appropriate solution thread. Thanks in advance.
(so you won't have to follow the above threads here's a copy from the original post of the messages)
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
I would appreciate any suggestions you might have. And, if this same topic is covered elsewhere in this forum, could you provide reference to the appropriate solution thread. Thanks in advance.
(so you won't have to follow the above threads here's a copy from the original post of the messages)
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
Comment