1) Give a description of the problem
I’ve got a piston set up to notify me via push when the wash is done, and I have a simple “Wash is done!” notification that gives me the following in my log.
Error executing virtual command [].sendPushNotification: (20ms) org.hibernate.exception.SQLGrammarException: could not execute query
2) What is the expected behaviour?
I expect to receive a push notification on my phone
3) What is happening/not happening?
I’m not receiving the push notification and I’m seeing an error in the log
**4) Post a Green Snapshot of the piston![image|45x37]
5) Attach logs after turning logging level to Full
7/17/2020, 4:20:04 PM +67ms
+0ms ╔Received event [My home].time = 1595020805293 with a delay of -1227ms
+46ms ║RunTime Analysis CS > 14ms > PS > 4ms > PE > 28ms > CE
+48ms ║Runtime (40997 bytes) successfully initialized in 4ms (v0.3.110.20191009) (47ms)
+49ms ║╔Execution stage started
+55ms ║║Cancelling condition #1’s schedules…
+59ms ║║Cancelling condition #6’s schedules…
+60ms ║║Cancelling condition #7’s schedules…
+61ms ║║Condition #7 evaluated true (1ms)
+65ms ║║Comparison (boolean) true is (boolean) true = true (1ms)
+66ms ║║Condition #8 evaluated true (4ms)
+67ms ║║Condition group #6 evaluated true (state did not change) (7ms)
+69ms ║║Cancelling statement #9’s schedules…
+92ms ║║Error executing virtual command [].sendPushNotification: (20ms) org.hibernate.exception.SQLGrammarException: could not execute query
+99ms ║║Comparison (boolean) true is (boolean) true = true (1ms)
+100ms ║║Condition #18 evaluated true (4ms)
+101ms ║║Cancelling condition #11’s schedules…
+101ms ║║Condition group #11 evaluated true (state changed) (6ms)
+105ms ║║Comparison (boolean) true is (boolean) true = true (1ms)
+106ms ║║Condition #12 evaluated true (4ms)
+114ms ║║Condition #13 evaluated false (7ms)
+115ms ║║Cancelling condition #11’s schedules…
+115ms ║║Condition group #11 evaluated false (state changed) (13ms)
+117ms ║╚Execution stage complete. (69ms)
+118ms ╚Event processed successfully (118ms)