Announcement

Collapse
No announcement yet.

Database error - Solved!

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

    Database error - Solved!

    I am getting this BLSecurity error in the log when arming/disarming:
    May-25 5:44:47 PM BLSecurity Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: INSERT INTO tblSecurityActivity (txtDateTime,txtAction,txtSecurityMode,txtDeviceRef,txtCondi tion,txtZone,txtComments) VALUES('5/25/2014 5:44:47 PM','Perimeter','Perimeter',-1,'','','System was set to Perimeter mode (User: Andre)')

    May-25 5:44:47 PM BLSecurity Error DatabaseFunctionsSingleton.PerformDatabaseUpdate(): DatabasePathAndName: C:\Program Files (x86)\HomeSeer HS3\Data\BLSecurity\BLSecurity.mdb

    May-25 5:44:47 PM BLSecurity 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.

    Using HS3 on WHS11, and just testing BLSecurity.

    #2
    A quick search turned up this thread:
    http://forums.homeseer.com/showthread.php?t=160399
    -Rupp
    sigpic

    Comment


      #3
      Resolved

      Solved with http://www.microsoft.com/en-us/downl....aspx?id=13255

      Thanks RUPP.

      Comment


        #4
        Blade,

        I just got this error when install new update.

        Starting up....
        5/17/2015 9:08:38 AM ~!~BLSecurity Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): An error has occurred during database update statement: file is encrypted or is not a databasefile is encrypted or is not a database
        5/17/2015 9:08:38 AM ~!~BLSecurity Error~!~DatabaseFunctionsSingleton.PerformDatabaseUpdate(): sqlUpdateString: DELETE from tblSecurityActivity WHERE txtDateTime < '2015-05-03 09:08:37.690'Startup Complete, 2 errors detected, check the log for more information.


        Thank you

        Greg

        Comment

        Working...
        X