Announcement

Collapse
No announcement yet.

Scheduled Favorites stop announcing.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Scheduled Favorites stop announcing.

    I have been having issue now with the favorites stopping to announce and I have have to cycle HS and they will start working again. I turned up logging to detailed and have found the last 2 days it appears that the one minute check stops each morning. I have included the log information from this morning:

    3/23/2013 5:51:00 AM HSTV Checking for Scheduled Actions
    3/23/2013 5:51:00 AM HSTV SELECT d.appID as ID, 'app' as runTable, d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, deviceApp d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.padTime),s.starttime) = '3/23/2013 5:51:00 AM' UNION SELECT d.emailID, 'email', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, deviceEmail d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.emailEarly),s.starttime) = '3/23/2013 5:51:00 AM' UNION SELECT d.irID, 'ir', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, deviceIR d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.padTime),s.starttime) = '3/23/2013 5:51:00 AM' UNION SELECT d.scriptID, 'script', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, deviceScript d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.padTime),s.starttime) = '3/23/2013 5:51:00 AM' UNION SELECT d.speakID, 'speak', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, deviceSpeak d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.speakEarly),s.starttime) = '3/23/2013 5:51:00 AM' UNION SELECT d.pluginID, 'plugin', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM scheduledFavs s, userFavs u, devicePlugin d WHERE s.favID = u.favID AND u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',-(d.padTime),s.starttime) = '3/23/2013 5:51:00 AM' UNION SELECT d.irID, 'irstop', d.runOrder, s.favID, s.starttime, s.channelID, s.scheduledID, u.RepeatType FROM tvListings l, scheduledFavs s, userFavs u, deviceIR d WHERE l.starttime = s.starttime And l.channelID = s.channelID And s.favID = u.favID And u.deviceID = d.deviceID AND s.isActive = 1 AND u.isActive = 1 AND DateAdd('n',d.padTime,l.endtime) = '3/23/2013 5:51:00 AM' ORDER BY s.scheduledID, s.FavID, d.runOrder
    3/23/2013 5:51:00 AM HSTV Array Rows: -1, Cols: 7
    3/23/2013 5:51:01 AM X10 Received M5 (Basement Computer Area Computer Desk (MS)) M On
    3/23/2013 5:51:11 AM X10 Received M5 (Basement Computer Area Computer Desk (MS)) M On
    3/23/2013 5:51:19 AM X10 Received M5 (Basement Computer Area Computer Desk (MS)) M On
    3/23/2013 5:51:27 AM X10 Received M5 (Basement Computer Area Computer Desk (MS)) M On
    3/23/2013 5:51:42 AM X10 Received M5 (Basement Computer Area Computer Desk (MS)) M On
    3/23/2013 5:51:49 AM X10 Received M5 (Basement Computer Area Computer Desk (MS)) M On
    3/23/2013 5:51:57 AM X10 Received M5 (Basement Computer Area Computer Desk (MS)) M On
    3/23/2013 5:52:00 AM Event Event Trigger "HSTV Step 4: Compact Database"
    3/23/2013 5:52:00 AM Event Running script statement immediately: &hs.Plugin("HSTV").compactAccessDB()
    3/23/2013 5:52:00 AM HSTV Database Size Before Compact: 18260 KB
    3/23/2013 5:52:00 AM HSTV Compact C:\Program Files (x86)\HomeSeer HSPRO\data\hstv\hstv.mdb
    3/23/2013 5:52:00 AM HSTV HSTV will stop checking for Scheduled Favorite Events
    3/23/2013 5:52:00 AM HSTV Database Size After Compact: 18260 KB
    3/23/2013 5:52:00 AM HSTV Finished compacting Access database
    3/23/2013 5:52:00 AM HSTV HSTV will start checking for Scheduled Favorite Events

    The entry for 5:51:00 AM is the last one that shows up for "Checking for Scheduled Actions".

    I can try disabling the compact event for a while and see if that helps for now. I'm guessing it will. Any help would be appreciated.

    Thanks,
    Jeff

  • #2
    Go ahead and turn off the compact database for one day and let me know. That will narrow down where in the code I need to look.
    --
    Jeff Farmer
    HS 3, HSPhone
    My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
    Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

    Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

    Comment


    • #3
      Jeff,

      I disabled the compact event and the announcements/scheduled items worked fine through the night and until this morning. So I manually kicked off the compact event and sure enough the 1 minute update checks stopped right after it completed.

      Thanks,
      Jeff

      Comment


      • #4
        Found the bug.
        Version 3.1.6 is in the download thread.

        You don't need to do a full install. Just grab the hspi_hstv.dll from the zip file, stop HS, put the dll in the homeseer directory and restart HS.
        --
        Jeff Farmer
        HS 3, HSPhone
        My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
        Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

        Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

        Comment


        • #5
          I have installed it tonight and turned the event back on.

          Thanks,
          Jeff

          Comment

          Working...
          X