Looks like the database did not close properly.
Shutdown HS2.
In the [HS root]\Data\BLStat you should see the database.
There is an mdb file (which is the actual database)
If there is a ldb file then delete it and try restarting HS2
You really should switch to HS3 as it uses SQLite for the database.
Announcement
Collapse
No announcement yet.
Blstat 1.0.27.0 Database error
Collapse
X
-
Blstat 1.0.27.0 Database error
I had to kill HS2 -( 2.5.0.80), got stuck on shutting down the X10 plugin.(another story)
After a complete system reboot I got this error.
PHP Code:7/15/2015 12:43:46 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.GetADODBConnection(): Caught exception opening database connection: Could not use ''; file already in use.
7/15/2015 12:43:47 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: Operation is not allowed when the object is closed.
7/15/2015 12:43:47 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS2\Data\BLStat\BLStat.mdb
7/15/2015 12:43:47 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblActivity (txtKey,txtDateTime,txtMessageType,txtThermostatNumber,txtMessage) VALUES('20150715T124345926','7/15/2015 12:43:45','I',0,'1 Thermostat has been loaded')
7/15/2015 12:43:47 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: Operation is not allowed when the object is closed.
7/15/2015 12:43:47 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS2\Data\BLStat\BLStat.mdb
7/15/2015 12:43:47 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblActivity (txtKey,txtDateTime,txtMessageType,txtThermostatNumber,txtMessage) VALUES('20150715T124347049','7/15/2015 12:43:47','I',1,'Manufacturer: Unknown; Model: Unknown')
7/15/2015 12:43:47 PM ~!~Event~!~Running script in background: garbageColDev.txt
7/15/2015 12:46:51 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: Operation is not allowed when the object is closed.
7/15/2015 12:46:51 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS2\Data\BLStat\BLStat.mdb
7/15/2015 12:46:51 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblActivity (txtKey,txtDateTime,txtMessageType,txtThermostatNumber,txtMessage) VALUES('20150715T124651437','7/15/2015 12:46:51','I',1,'System is now Idle')
7/15/2015 12:46:51 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: Operation is not allowed when the object is closed.
7/15/2015 12:46:51 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS2\Data\BLStat\BLStat.mdb
7/15/2015 12:46:51 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblStatData (txtDateTime,txtThermostatNumber,txtMode,txtState,txtSeconds) VALUES('7/15/2015 12:46:51',1,2,1,179)
7/15/2015 12:46:51 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: Operation is not allowed when the object is closed.
7/15/2015 12:46:51 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS2\Data\BLStat\BLStat.mdb
7/15/2015 12:46:51 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblActivity (txtKey,txtDateTime,txtMessageType,txtThermostatNumber,txtMessage) VALUES('20150715T124651467','7/15/2015 12:46:51','I',1,'Fan is Idle')
7/15/2015 12:47:00 PM ~!~Event~!~Event Trigger "IpodLoc"
7/15/2015 12:47:00 PM ~!~Event~!~Running script in background: SnevlLatitude.vb
7/15/2015 12:47:27 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): An error has occurred during database select query: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
7/15/2015 12:47:27 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS2\Data\BLStat\BLStat.mdb
7/15/2015 12:47:27 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): connString: DSN=BLStat
7/15/2015 12:47:27 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): selectQueryString: SELECT txtKey,txtDateTime,txtMessageType,txtThermostatNumber,txtMessage FROM tblActivity ORDER BY txtKey DESC
7/15/2015 12:47:30 PM ~!~Event~!~Event Trigger "LastRemoteIP"
7/15/2015 12:47:30 PM ~!~Event~!~Running script in background: lastIP.txt
7/15/2015 12:47:38 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): An error has occurred during database select query: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
7/15/2015 12:47:38 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS2\Data\BLStat\BLStat.mdb
7/15/2015 12:47:38 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): connString: DSN=BLStat
7/15/2015 12:47:38 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): selectQueryString: SELECT txtDateTime,txtThermostatNumber,txtMode,txtState,txtSeconds FROM tblStatData ORDER BY txtDateTime DESC
7/15/2015 12:47:41 PM ~!~Event~!~Event Trigger "UpDateDevices"
7/15/2015 12:47:41 PM ~!~Event~!~Running script in background: MilfordWthr.txt
7/15/2015 12:47:42 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): An error has occurred during database select query: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
7/15/2015 12:47:42 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS2\Data\BLStat\BLStat.mdb
7/15/2015 12:47:42 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): connString: DSN=BLStat
7/15/2015 12:47:42 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): selectQueryString: SELECT txtThermostatNumber,txtMode,txtState,SUM(txtSeconds) FROM tblStatData WHERE txtDateTime >= #7/15/2015 0:0:0# AND txtDateTime <= #7/15/2015 23:59:59# GROUP BY txtThermostatNumber,txtMode,txtState ORDER BY txtThermostatNumber,txtMode
7/15/2015 12:47:49 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): An error has occurred during database select query: The connection cannot be used to perform this operation. It is either closed or invalid in this context.
7/15/2015 12:47:49 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS2\Data\BLStat\BLStat.mdb
7/15/2015 12:47:49 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): connString: DSN=BLStat
7/15/2015 12:47:49 PM ~!~BLStat Error~!~DatabaseFunctionsSingleton.PerformDatabaseMultiSelect(): selectQueryString: SELECT txtDateTime,txtThermostatNumber,txtMode,txtState,txtSeconds FROM tblStatData WHERE txtDateTime >= #7/15/2015 0:0:0# AND txtDateTime <= #7/15/2015 23:59:59# ORDER BY txtDateTime DESC
TimTags: None
Leave a comment: