BLStat beta

[Blade]

The events are not working.

Under devices the thermostat is called "Thermostat 1". When creating an event it is called "z-wave Interface thermostat". New events seem to run, but nothing changes on the thermostat.

These events were working, but appear to have been broken a couple releases back - now running beta 1.0.2d

I will have a look and test it when I get home later today

[Richel]

Polling is at 120 sec. The thermostat is a 2GIG CT30. I didn't have the debug log option checked. It is checked now and I will send you the log that gets generated. Elliott

[Blade]

The events are not working.

Under devices the thermostat is called "Thermostat 1". When creating an event it is called "z-wave Interface thermostat". New events seem to run, but nothing changes on the thermostat.

These events were working, but appear to have been broken a couple releases back - now running beta 1.0.2d

If you were using an older build you may have to re-create the events because I change the format of them.
Try that and let me know

[gelessor]

Tried creating new event -still not working

[Blade]

Tried creating new event -still not working

OK you need to tell what you created (trigger or action) and capture a debug log of the event not firing. Then attach the BLStat-Detailed.log file

[gelessor]

Requested log info...

HS log shows event triggered


1/3/2011 7:18:53 PM - Event - Event Trigger "Decrease heat setpoint by 1 degree"
1/3/2011 7:19:08 PM - Media Player - Warning, queued command did not complete due to timeout: player_state
1/3/2011 7:19:12 PM - X10 Received - O13 (Theater Motion) O On
1/3/2011 7:19:19 PM - X10 Received - O13 (Theater Motion) O On
1/3/2011 7:19:38 PM - Device Control - Device: Hallways Plants (F10) ON
1/3/2011 7:19:38 PM - OCCUPANCY - \ \ \ \ \ \ \ \ \ \ Alarm Upstairs Occupancy set to "Occupied" - Vacant (00:07)
1/3/2011 7:19:38 PM - MOTION - >>>>>>>> Motion Detected with Hallways Motion - No Motion (00:37)



BLSTAT Log...

1/3/2011 7:10:15 PM Information Z-Wave Interface Thermostat (1) Manufacturer: 2GIG; Model: ZSTAT CT30E
1/3/2011 7:10:15 PM Information 1 Thermostat has been loaded
1/3/2011 7:09:57 PM Information Z-Wave Interface Thermostat (1) System is now Idle
1/3/2011 7:08:53 PM Information Z-Wave Interface Thermostat (1) System is now Heating
1/3/2011 7:08:53 PM Information Polling has been activated for all thermostats
1/3/2011 7:08:50 PM Information Scheduling has been activated for all thermostats
1/3/2011 7:08:48 PM Information Z-Wave Interface Thermostat (1) Manufacturer: 2GIG; Model: ZSTAT CT30E
1/3/2011 7:08:48 PM Information 1 Thermostat has been loaded

[gelessor]

Thought this might help troubleshoot

[Blade]

I will look into it.

You might be better to use the BLStat conditions on the Increase and Decrease events.
You are setting the system mode and then increasing or decreasing. Why not use the condition to say only increase if the system mode is Heat, etc

[gelessor]

Great idea. I will update the events using conditions.

Were you able to determine why none of these events work for me?

[Blade]

Not yet. I am going to need a debug log from you as well capturing the event running so I can see what is going on.
Attach the BLStat-Detailed.log (ZIPPED) to thsi thread when you have it.

[Blade]

I have posted 1.0.2e

This adds the ability to hide cool control for a specific thermostat. You will see an options link for each thermostat on the Thermostats web page.

[Richel]

Debug file

Blade:

Attached is part of the debug file. The error in my HomeSeer log starts at 7:51:17 PM

1/3/2011 7:52:09 PM BLStat Info BLStat Debug Logging Disabled!
1/3/2011 7:51:31 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): selectQueryString: SELECT txtDateTime,txtThermostatNumber,txtMode,txtState,txtSeconds FROM tblStatData WHERE txtDateTime >= #1/3/2011 0:0:0# AND txtDateTime <= #1/3/2011 23:59:59# ORDER BY txtDateTime DESC
1/3/2011 7:51:31 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): connString: DSN=BLStat
1/3/2011 7:51:31 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files\HomeSeer HS2\Data\BLStat\BLStat.mdb
1/3/2011 7:51:31 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): An error has occurred during database select query: No value given for one or more required parameters.
1/3/2011 7:51:27 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): selectQueryString: SELECT txtThermostatNumber,txtMode,txtState,SUM(txtSeconds) FROM tblStatData WHERE txtDateTime >= #1/3/2011 0:0:0# AND txtDateTime <= #1/3/2011 23:59:59# GROUP BY txtThermostatNumber,txtMode,txtState ORDER BY txtThermostatNumber,txtMode
1/3/2011 7:51:27 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): connString: DSN=BLStat
1/3/2011 7:51:27 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files\HomeSeer HS2\Data\BLStat\BLStat.mdb
1/3/2011 7:51:27 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): An error has occurred during database select query: No value given for one or more required parameters.
1/3/2011 7:51:21 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): selectQueryString: SELECT txtDateTime,txtThermostatNumber,txtMode,txtState,txtSeconds FROM tblStatData ORDER BY txtDateTime DESC
1/3/2011 7:51:21 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): connString: DSN=BLStat
1/3/2011 7:51:21 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files\HomeSeer HS2\Data\BLStat\BLStat.mdb
1/3/2011 7:51:21 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): An error has occurred during database select query: No value given for one or more required parameters.
1/3/2011 7:51:17 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): selectQueryString: SELECT txtThermostatNumber,txtMode,txtState,SUM(txtSeconds) FROM tblStatData WHERE txtDateTime >= #1/3/2011 0:0:0# AND txtDateTime <= #1/3/2011 23:59:59# GROUP BY txtThermostatNumber,txtMode,txtState ORDER BY txtThermostatNumber,txtMode
1/3/2011 7:51:17 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): connString: DSN=BLStat
1/3/2011 7:51:17 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files\HomeSeer HS2\Data\BLStat\BLStat.mdb
1/3/2011 7:51:17 PM BLStat Error DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): An error has occurred during database select query: No value given for one or more required parameters.

Elliott

[stevea]

Bob,

I am getting ready to write an ASPX page to graph the daily run-times for the HVAC system, and I have a quick question for you: I took a look at your database, and I *THINK* I should be able to walk through and compute the times between "System is now Heating" and "System is now Idle" activity entries. Does that sound right?

Also: It looks like some of the earlier Betas were not logging the Idle event. Is that true? As long as it logs it now, I'll be fine. If there is some other situation where it doesn't log idle, my plan is busted.

Thanks again for a great PI.

Steve

[Blade]

Yes it should log the idle and running now

[gelessor]

Bob,

FYI

Un-installed and reloaded several times. Finally started rebuilding and gt up thru beta 1.01g before the events stopped working...

Sitting on g for now.