This has worked great but I went to modify one of my triggers, and got this error, which is not corrected by reloading SQLLogger or restarting the computer.
- Code: Select all
Oct 19, 2014 10:38:25 PM
********Here is where I clicked "Edit Event Settings"******
Error (client) timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request UiGetValues2
Error (client) timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request CallPluginFunc
Error (client) dialogForEventId() caught exception: NSInvalidArgumentException -- *** -[__NSPlaceholderDictionary initWithObjects:forKeys:count:]: attempt to insert nil object from objects[0]
*********Reloaded. ***********
Oct 19, 2014 10:39:29 PM
Reloading plugin "SQL Logger 1.1.8"
Stopping plugin "SQL Logger 1.1.8" (pid 732)
Received INSTEON "Thermostat Main Bedrooms" temperature changed to 67.0
Error process (pid 732) failed to quit after polite request -- forcing it to quit now
Stopped plugin "SQL Logger 1.1.8"
Starting plugin "SQL Logger 1.1.8" (pid 1966)
Started plugin "SQL Logger 1.1.8"
SQL Logger connected to /Library/Application Support/Perceptive Automation/Indigo 6/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
****Click on the "Edit Event Settings" button again....No change even with SQL restart..********
Error (client) timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request UiGetValues2
Error (client) timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request CallPluginFunc
Error (client) dialogForEventId() caught exception: NSInvalidArgumentException -- *** -[__NSPlaceholderDictionary initWithObjects:forKeys:count:]: attempt to insert nil object from objects[0]
****Click on the "Edit Event Settings" button again....********
Error (client) timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request UiGetValues2
Error (client) timeout waiting for plugin response from com.perceptiveautomation.indigoplugin.sql-logger for request CallPluginFunc
Error (client) dialogForEventId() caught exception: NSInvalidArgumentException -- *** -[__NSPlaceholderDictionary initWithObjects:forKeys:count:]: attempt to insert nil object from objects[0]
I am running 10.8.3. I installed IndigoPlot a few weeks back. It has worked well; the errors above were with it disabled. I subsequently reloaded and it reported the following to the Event Log:
- Code: Select all
Oct 19, 2014 10:54:46 PM
Enabling plugin "INDIGOplotD 2.6.1"
Starting plugin "INDIGOplotD 2.6.1" (pid 2220)
Started plugin "INDIGOplotD 2.6.1"
INDIGOplotD initializing ... 2-6-1
INDIGOplotD indigo version found: 6
INDIGOplotD read file /Users/WilliamsEC/Documents/INDIGOPlotD/minute.dat lines: 2304
INDIGOplotD read file /Users/WilliamsEC/Documents/INDIGOPlotD/hour.dat lines: 912
INDIGOplotD read file /Users/WilliamsEC/Documents/INDIGOPlotD/day.dat lines: 390
INDIGOplotD wait for SQL logger to finish start up -- before retrieving SQL data
Oct 19, 2014 10:55:10 PM
INDIGOplotD sql commands launched 2014-10-19 22:55:10.192895 waiting for SQL tasks to end to read data into INDIGOplotD pid=2246
INDIGOplotD initializing ...2
INDIGOplotD SQL Data arrived 2014-10-19 22:55:21.074403 RFX CrawlSp 3 Game Rm-humidity sql files created
INDIGOplotD Convert2 device/prop from SQL db: 0:00:00.096777 RFX CrawlSp 3 Game Rm-humidity records read/converted: 1890/ 1890 to PLOT format ==== rejected bad.. DateField: 0 ..#ofColumns: 0 ..ValueRange: 0 ..BadNumber: 0 ..sameTimeStamp: 0
INDIGOplotD Convert2 device/prop from SQL db: 0:00:00.207419 RFX CrawlSp 3 Game Rm-humidity records read/converted: 1890/ 1890 to PLOT format ==== rejected bad.. DateField: 0 ..#ofColumns: 0 ..ValueRange: 0 ..BadNumber: 0 ..sameTimeStamp: 0
INDIGOplotD Convert2 device/prop from SQL db: 0:00:00.301236 RFX CrawlSp 3 Game Rm-temperature records read/converted: 1837/ 1837 to PLOT format ==== rejected bad.. DateField: 0 ..#ofColumns: 0 ..ValueRange: 0 ..BadNumber: 0 ..sameTimeStamp: 0
INDIGOplotD SQL Data arrived 2014-10-19 22:55:23.588229 RFX CrawlSp 2 Main House-humidity sql files created
INDIGOplotD Convert2 device/prop from SQL db: 0:00:00.283956 RFX CrawlSp 2 Main House-humidity records read/converted: 3221/ 3221 to PLOT format ==== rejected bad.. DateField: 0 ..#ofColumns: 0 ..ValueRange: 0 ..BadNumber: 0 ..sameTimeStamp: 0
INDIGOplotD Convert2 device/prop from SQL db: 0:00:00.436965 RFX CrawlSp 2 Main House-temperature records read/converted: 3057/ 3057 to PLOT format ==== rejected bad.. DateField: 0 ..#ofColumns: 0 ..ValueRange: 0 ..BadNumber: 0 ..sameTimeStamp: 0
INDIGOplotD SQL Data arrived 2014-10-19 22:55:37.950437 RFX CrawlSp 1 Fam Rm-humidity sql files created
INDIGOplotD Convert2 device/prop from SQL db: 0:00:00.220465 RFX CrawlSp 1 Fam Rm-humidity records read/converted: 5680/ 5680 to PLOT format ==== rejected bad.. DateField: 0 ..#ofColumns: 0 ..ValueRange: 0 ..BadNumber: 0 ..sameTimeStamp: 0
INDIGOplotD Convert2 device/prop from SQL db: 0:00:00.431412 RFX CrawlSp 1 Fam Rm-temperature records read/converted: 5444/ 5444 to PLOT format ==== rejected bad.. DateField: 0 ..#ofColumns: 0 ..ValueRange: 0 ..BadNumber: 0 ..sameTimeStamp: 0
INDIGOplotD SQL import 2014-10-19 22:55:38.525855 ... finished, total number of records imported: 23019
...And it no longer generates a plot:
Oct 19, 2014 10:58:50 PM
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
WebServer file:/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png load error: <urlopen error [Errno 2] No such file or directory: '/Users/WilliamsEC/Documents/INDIGOPlotD/Temp Hum Game Rm Crawl Space-minute-S1.png'>
Suggestions?