I am trying out BLCharting for HS3.
The plugin installed easily and I enabled it.
I downloaded the Office Web Components 11 Download and installed that.
Restarted HS3.
added a few devices to begin collecting chart data.
But I see the following in the log:
Oct-30 3:41:37 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblDeviceData (txtDateTime,txtDeviceRef,txtDeviceValue) VALUES('10/30/2013 3:41:37 PM',3571,'')
Oct-30 3:41:37 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS3\Data\BLChart\BLChart.mdb
Oct-30 3:41:37 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
Oct-30 3:41:18 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblDeviceData (txtDateTime,txtDeviceRef,txtDeviceValue) VALUES('10/30/2013 3:41:18 PM',6637,'')
Oct-30 3:41:18 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS3\Data\BLChart\BLChart.mdb
Oct-30 3:41:18 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
Oct-30 3:41:03 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblDeviceData (txtDateTime,txtDeviceRef,txtDeviceValue) VALUES('10/30/2013 3:41:03 PM',9444,'')
-------------------------------------
Here are the startup messages:
Oct-30 3:16:56 PM Plug-In Finished initializing plug-in BLChart
Oct-30 3:16:56 PM BLChart start BLChart plugin has been initialized
Oct-30 3:16:56 PM BLChart Error DatabaseFunctionsSingleton.CompactDatabase(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS3\Data\BLChart\BLChart.mdb
Oct-30 3:16:56 PM BLChart Error DatabaseFunctionsSingleton.CompactDatabase(): An error has occurred during compacting of the database: Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
Oct-30 3:16:55 PM BLChart Error [Log Entry Contains Chars Converted to Hex in Brackets{}]DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: DELETE from tblDeviceData WHERE txtDateTime {3C} #8/1/2013 15:16:55#
Oct-30 3:16:55 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS3\Data\BLChart\BLChart.mdb
Oct-30 3:16:55 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
Oct-30 3:16:55 PM BLChart Error DatabaseFunctionsSingleton.GetADODBConnection(): Caught exception opening database connection: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Oct-30 3:16:55 PM BLChart start Devices and Groups have been loaded.
Oct-30 3:16:54 PM BLChart start Loaded configuration successfully
Oct-30 3:16:54 PM BLChart start BLChart version is: 2.0.1.0
Oct-30 3:16:54 PM BLChart start Initializing BLChart...
Oct-30 3:16:54 PM Info Plug-in BLChart has connected successfully
Oct-30 3:16:54 PM Info Remote application or plugin has connected: 127.0.0.1:64605
Oct-30 3:16:54 PM Info Remote application or plugin has connected: 127.0.0.1:64604
Oct-30 3:16:54 PM Plug-In Interface BLChart is running as a trial, 30 days remaining.
Oh - and I did try rebooting the HS3 machine as well (Win7 HTPC).
The plugin installed easily and I enabled it.
I downloaded the Office Web Components 11 Download and installed that.
Restarted HS3.
added a few devices to begin collecting chart data.
But I see the following in the log:
Oct-30 3:41:37 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblDeviceData (txtDateTime,txtDeviceRef,txtDeviceValue) VALUES('10/30/2013 3:41:37 PM',3571,'')
Oct-30 3:41:37 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS3\Data\BLChart\BLChart.mdb
Oct-30 3:41:37 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
Oct-30 3:41:18 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblDeviceData (txtDateTime,txtDeviceRef,txtDeviceValue) VALUES('10/30/2013 3:41:18 PM',6637,'')
Oct-30 3:41:18 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS3\Data\BLChart\BLChart.mdb
Oct-30 3:41:18 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
Oct-30 3:41:03 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblDeviceData (txtDateTime,txtDeviceRef,txtDeviceValue) VALUES('10/30/2013 3:41:03 PM',9444,'')
-------------------------------------
Here are the startup messages:
Oct-30 3:16:56 PM Plug-In Finished initializing plug-in BLChart
Oct-30 3:16:56 PM BLChart start BLChart plugin has been initialized
Oct-30 3:16:56 PM BLChart Error DatabaseFunctionsSingleton.CompactDatabase(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS3\Data\BLChart\BLChart.mdb
Oct-30 3:16:56 PM BLChart Error DatabaseFunctionsSingleton.CompactDatabase(): An error has occurred during compacting of the database: Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).
Oct-30 3:16:55 PM BLChart Error [Log Entry Contains Chars Converted to Hex in Brackets{}]DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: DELETE from tblDeviceData WHERE txtDateTime {3C} #8/1/2013 15:16:55#
Oct-30 3:16:55 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS3\Data\BLChart\BLChart.mdb
Oct-30 3:16:55 PM BLChart Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: ExecuteNonQuery requires an open and available Connection. The connection's current state is closed.
Oct-30 3:16:55 PM BLChart Error DatabaseFunctionsSingleton.GetADODBConnection(): Caught exception opening database connection: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Oct-30 3:16:55 PM BLChart start Devices and Groups have been loaded.
Oct-30 3:16:54 PM BLChart start Loaded configuration successfully
Oct-30 3:16:54 PM BLChart start BLChart version is: 2.0.1.0
Oct-30 3:16:54 PM BLChart start Initializing BLChart...
Oct-30 3:16:54 PM Info Plug-in BLChart has connected successfully
Oct-30 3:16:54 PM Info Remote application or plugin has connected: 127.0.0.1:64605
Oct-30 3:16:54 PM Info Remote application or plugin has connected: 127.0.0.1:64604
Oct-30 3:16:54 PM Plug-In Interface BLChart is running as a trial, 30 days remaining.
Oh - and I did try rebooting the HS3 machine as well (Win7 HTPC).
Comment