Works in Client but not in Vision Preview

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(
	at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(
	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

What’s the rest?

Is your gateway in read-only or read/write?


Thats what it was. I forgot to turn read/right back on after a fresh start. I thought about changing that in the project settings so I would not make this mistake, and something made me not do it…and I forgot!!

Thanks for the reminder!


1 Like