Hi @pturmel ,
Thanks a lot for your reply.
Below is what I got from the wrapper log…
INFO | jvm 1 | 2021/07/26 10:14:57 |
INFO | jvm 1 | 2021/07/26 10:14:57 | java.lang.Exception: java.lang.Exception: Error executing system.db.runQuery(SELECT “”, “”, Time, Location, Speed, Length FROM Table1 WHERE Time BETWEEN “2021-07-26 07:00:00” AND “2021-07-26 07:59:59”, Database1, )
INFO | jvm 1 | 2021/07/26 10:14:57 |
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.core.Py.JavaError(Py.java:495)
INFO | jvm 1 | 2021/07/26 10:14:57 | at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)
INFO | jvm 1 | 2021/07/26 10:14:57 | at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runQuery(AbstractDBUtilities.java:333)
INFO | jvm 1 | 2021/07/26 10:14:57 | at sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source)
INFO | jvm 1 | 2021/07/26 10:14:57 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2021/07/26 10:14:57 | at java.lang.reflect.Method.invoke(Unknown Source)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.core.PyReflectedFunction.call(PyReflectedFunction.java:186)
INFO | jvm 1 | 2021/07/26 10:14:57 | at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction.call(ScriptManager.java:431)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.core.PyObject.call(PyObject.java:404)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.core.PyObject.call(PyObject.java:408)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.pycode._pyx1057.exportReportAsCSV$1(module:shared.SampleProject.export:162)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.pycode._pyx1057.call_function(module:shared.SampleProject.export)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.core.PyTableCode.call(PyTableCode.java:165)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.core.PyBaseCode.call(PyBaseCode.java:134)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.core.PyFunction.call(PyFunction.java:317)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.pycode._pyx1056.f$0(<TimerScript:SampleProject/WriteHourlyLogs @10,000ms >:37)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.pycode._pyx1056.call_function(<TimerScript:SampleProject/WriteHourlyLogs @10,000ms >)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.core.PyTableCode.call(PyTableCode.java:165)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.core.PyCode.call(PyCode.java:18)
INFO | jvm 1 | 2021/07/26 10:14:57 | at org.python.core.Py.runCode(Py.java:1275)
INFO | jvm 1 | 2021/07/26 10:14:57 | at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:636)
INFO | jvm 1 | 2021/07/26 10:14:57 | at com.inductiveautomation.ignition.common.script.ScriptManager.runCode(ScriptManager.java:603)
INFO | jvm 1 | 2021/07/26 10:14:57 | at com.inductiveautomation.ignition.common.script.TimerScriptTask.run(TimerScriptTask.java:88)
INFO | jvm 1 | 2021/07/26 10:14:57 | at java.util.TimerThread.mainLoop(Unknown Source)
INFO | jvm 1 | 2021/07/26 10:14:57 | at java.util.TimerThread.run(Unknown Source)
INFO | jvm 1 | 2021/07/26 10:14:57 | Caused by: org.python.core.PyException: Traceback (most recent call last):
INFO | jvm 1 | 2021/07/26 10:14:57 | File “<TimerScript:SampleProject/WriteHourlyLogs @10,000ms >”, line 41, in
INFO | jvm 1 | 2021/07/26 10:14:57 | File “module:shared.SampleProject.export”, line 11, in exportReportAsCSV
INFO | jvm 1 | 2021/07/26 10:14:57 | at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)
INFO | jvm 1 | 2021/07/26 10:14:57 | at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runQuery(AbstractDBUtilities.java:333)
INFO | jvm 1 | 2021/07/26 10:14:57 | at sun.reflect.GeneratedMethodAccessor202.invoke(Unknown Source)
INFO | jvm 1 | 2021/07/26 10:14:57 | at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
INFO | jvm 1 | 2021/07/26 10:14:57 | at java.lang.reflect.Method.invoke(Unknown Source)
INFO | jvm 1 | 2021/07/26 10:14:57 |
INFO | jvm 1 | 2021/07/26 10:14:57 | java.lang.Exception: java.lang.Exception: Error executing system.db.runQuery(SELECT “”, “”, Time, Location, Speed, Length FROM Table1 WHERE Time BETWEEN “2021-07-26 07:00:00” AND “2021-07-26 07:59:59”, Database1, )
INFO | jvm 1 | 2021/07/26 10:14:57 |
INFO | jvm 1 | 2021/07/26 10:14:57 | … 25 common frames omitted
INFO | jvm 1 | 2021/07/26 10:14:57 | Caused by: java.lang.Exception: Error executing system.db.runQuery(SELECT “”, “”, Time, Location, Speed, Length FROM Table1 WHERE Time BETWEEN “2021-07-26 07:00:00” AND “2021-07-26 07:59:59”, Database1, )
INFO | jvm 1 | 2021/07/26 10:14:57 | … 24 common frames omitted
INFO | jvm 1 | 2021/07/26 10:14:57 | Caused by: java.lang.NullPointerException: null