Announcement

Collapse

Contacting HomeSeer This Week

HomeSeer is open and operational this week. All orders are being processed and shipped as usual. However, some staff are working from home. If you need to contact HomeSeer for support or customer service, please use our Email or Chat options. https://homeseer.com/contact-us/
See more
See less

Blstat 1.0.27.0 Database error

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

  • Blade
    replied
    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.

    Leave a comment:


  • fungun
    started a topic Blstat 1.0.27.0 Database error

    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
Working...
X