I am getting the following errors most every night when HSTV does its updates. In searching the board, it appears that a few users were getting these errors as a result of the database getting to large. I have run the tool to compact the database, but I still get these errors nightly. The other thing that is odd is that these errors occur around 1AM, and my HSTV Download and Import events are setup to run at around 5AM. I also get a set of these errors at the expected time of ~5AM. Is there something else that has worked to correct this?
7/9/2008 1:12:28 AM HSTV Error Select Query: Operation is not allowed when the object is open.
7/9/2008 1:12:28 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
7/9/2008 1:12:28 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
7/9/2008 1:12:28 AM HSTV Error Select Query: Operation is not allowed when the object is closed.
7/9/2008 1:12:28 AM HSTV Error Select Query: Operation is not allowed when the object is open.
7/9/2008 1:12:28 AM HSTV Error Select Query: Operation is not allowed when the object is open.
7/9/2008 1:12:28 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
7/9/2008 1:12:28 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
7/9/2008 1:12:28 AM HSTV Error Select Query: Operation is not allowed when the object is closed.
7/9/2008 1:12:28 AM HSTV Error Select Query: Operation is not allowed when the object is open.
Comment