Good morning all,
Yesterday before the hurricane hit, I had a lot of help learning and setting up a script to update a database table. It worked great in preview more and in the client.
Today, I startup and it does not work in preview mode but it works fine in the client. The only difference is a reboot.
I get this on the console…
10:56:30.114 [AWT-EventQueue-0] ERROR Vision.Components.AdvancedTable - Error invoking extension method.
org.python.core.PyException: Traceback (most recent call last):
File "<extension-method onCellEdited>", line 31, in onCellEdited
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:362)
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:258)
at jdk.internal.reflect.GeneratedMethodAccessor265.invoke(Unknown Source)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.base/java.lang.reflect.Method.invoke(Unknown Source)
java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepUpdate(UPDATE binder_names SET archive=? WHERE id=?, [false, 15], , , false, false)
plus a lot more.
What am I missing here? Again, it works fine in the client.
Thanks, Steven