I am trying to create a trigger to capture errors occurring with a Z-Wave Device. For some reason the error does not seem to be recorded in the database.
Here is information from the Event Log - reloading the SQL Logger PlugIn
Jul 26, 2020 at 8:13:56 AM
Reloading plugin "SQL Logger 7.4.1"
Stopping plugin "SQL Logger 7.4.1" (pid 34769)
SQL Logger closing SQL connection
Stopped plugin "SQL Logger 7.4.1"
Starting plugin "SQL Logger 7.4.1" (pid 46355)
Started plugin "SQL Logger 7.4.1"
SQL Logger connected to /Library/Application Support/Perceptive Automation/Indigo 7.4/Logs/indigo_history.sqlite
SQL Logger searching for unused device and variable tables
SQL Logger search complete (none found)
SQL Logger updating all device tables
SQL Logger updating all variable tables
SQL Logger update complete
So I sent a Status Update request to my FRONT DOOR z-Wave Lock ... and you can see that there is an error.
Jul 26, 2020 at 8:15:00 AM
Z-Wave Error send "FRONT DOOR LOCK (Schlage 469)" status request failed
Z-Wave received "STUDY - AIR PURIFIER" energy total to 150.741 kWh
Z-Wave received "STUDY - AIR PURIFIER" power load to 26.210 W
When I run "Debug" in the SQL Logger - the error does not get added to the database.
Z-Wave Error send "FRONT DOOR LOCK (Schlage 469)" status request failed
SQL Logger Debug INSERT INTO device_history_623522302 ("longstatusstring", "timeleftseconds") VALUES (?, ?);
SQL Logger Debug (u'13:37:46', u'49066')
SQL Logger Debug INSERT INTO device_history_1741244237 ("time_24hmmssampm", "time_24hmmss", "time_24hhmmss", "time_12hmmssampm", "time_12hhmmss", "time_12hhmmssampm", "time_12hmmss", "time_24hhmmssampm", "time_12hmmssampml", "time_12hhmmssampml", "localtime") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);
SQL Logger Debug (u'8:09:39AM', u'8:09:39', u'08:09:39', u'8:09:39AM', u'08:09:39', u'08:09:39AM', u'8:09:39', u'08:09:39AM', u'8:09:39am', u'08:09:39am', u'08:09:39')
SQL Logger Debug INSERT INTO device_history_623522302 ("longstatusstring", "timeleftseconds") VALUES (?, ?);
I have my Trigger setup as follows:
TYPE: SQL Logger Event
Event: Error in Event Log
Errors to monitor for: All (I have tried Specific Type as "Z-Wave Error")
String to match: "FRONT DOOR LOCK (Schlage 469)" ... with and without " "
Thanks in advance for any assistance!
Harold