Announcement

Collapse
No announcement yet.

Blstat 1.0.27.0 Database error

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

    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 connectionCould 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,txtMessageVALUES('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,txtMessageVALUES('20150715T124347049','7/15/2015 12:43:47','I',1,'Manufacturer: Unknown; Model: Unknown')
    7/15/2015 12:43:47 PM ~!~Event~!~Running script in backgroundgarbageColDev.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,txtMessageVALUES('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,txtSecondsVALUES('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,txtMessageVALUES('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 backgroundSnevlLatitude.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 operationIt 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 backgroundlastIP.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 operationIt 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 backgroundMilfordWthr.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 operationIt 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(txtSecondsFROM 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 operationIt 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 
    Thanks,
    Tim
    FB Page - https://www.facebook.com/pages/Capt-Tim/209398425902188

    HSTouch Layouts - https://www.facebook.com/media/set/?...5902188&type=3

    #2
    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.
    Cheers,
    Bob
    Web site | Help Desk | Feature Requests | Message Board

    Comment

    Working...
    X