# \[IGN-15326\]8.3 system.db.runPrepUpdate not throwing **URL:** \ **Category:** Ignition\ **Created:** [January 27, 2026, 3:35am UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554 "2026-01-27T03:35:23Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![ShaneH](https://avatars.discourse-cdn.com/v4/letter/s/3e96dc/32.png) [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Post date:** [January 27, 2026, 3:35am UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/1 "2026-01-27T03:35:24Z")
```python Ignition 8.3.3, 'ACME' is a valid db connection. Microsoft SQLServer db driver. There is no table x, y, or z. This throws an exception as expected: query = 'select y from x where z is null' system.db.runPrepQuery(query, [], 'ACME') Specifically, it passes back: Invalid object name 'x'. This does not return an error of any kind: query = 'update x set y=1 where z is null' system.db.runPrepUpdate(query, [], 'ACME') Any ideas? -Shane ``` ---
**Author:** ![ShaneH](https://avatars.discourse-cdn.com/v4/letter/s/3e96dc/32.png) [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Post date:** [January 27, 2026, 4:00pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/2 "2026-01-27T16:00:06Z")
Interestingly, the old deprecated runUpdateQuery ```python query = 'update x set y=1 where z is null' system.db.runUpdateQuery(query, 'ACME') throws as expected with the same error: Invalid object name 'x'. Testing these in SSMS also generates the same error. ``` ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [January 27, 2026, 4:10pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/3 "2026-01-27T16:10:33Z")
Sounds like a bug worth reporting. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 27, 2026, 4:58pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/4 "2026-01-27T16:58:00Z")
Well, it's not code I wrote at least, but it is code I reviewed... The bug is that as of 8.3.0, `system.db.runPrepUpdate` called with an empty args list short-circuits and doesn't even attempt to run your query. If you put an actual argument in the args list, even one that's not actually used in your query, it'll throw as you expect. ---
**Author:** ![ShaneH](https://avatars.discourse-cdn.com/v4/letter/s/3e96dc/32.png) [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Post date:** [January 27, 2026, 5:39pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/5 "2026-01-27T17:39:18Z")
This "feels" like a pretty important bug. Do you think it might make it into 8.3.4? ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 27, 2026, 5:40pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/6 "2026-01-27T17:40:24Z")
I've done what I can, as far as prioritization, but it may not make it before the release train leaves the station on Friday. ---
**Author:** ![ShaneH](https://avatars.discourse-cdn.com/v4/letter/s/3e96dc/32.png) [@ShaneH](https://forum.inductiveautomation.com/u/ShaneH)\ **Post date:** [January 27, 2026, 6:21pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/7 "2026-01-27T18:21:36Z")
Also, just adding an unused param doesn’t really work because then it throws for that… ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [January 27, 2026, 8:04pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/8 "2026-01-27T20:04:18Z")
Well, that's up to your JDBC driver/DB settings, it's out of our hands at that point. I'm not disagreeing with you that this is a bad bug, and I'm certainly trying to get it fixed for 8.3.4. I just want to temper expectations. ---
**Author:** ![jacob\_geers](https://avatars.discourse-cdn.com/v4/letter/j/4da419/32.png) [@jacob\_geers](https://forum.inductiveautomation.com/u/jacob_geers)\ **Post date:** [April 23, 2026, 7:32pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/9 "2026-04-23T19:32:10Z")
Was this fixed in 8.3.4? Sorry if I missed it in the patch notes - no search results. ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [April 23, 2026, 7:55pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/10 "2026-04-23T19:55:50Z")
It's still in the backlog unfortunately. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [April 28, 2026, 10:56pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/11 "2026-04-28T22:56:07Z")
This issue will be fixed in tomorrow's nightly/the full release of 8.3.7. ---
**Author:** ![Md\_Sabbir\_Ahamed](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/md_sabbir_ahamed/32/54273_2.png) [@Md\_Sabbir\_Ahamed](https://forum.inductiveautomation.com/u/Md_Sabbir_Ahamed)\ **Post date:** [September 5, 2026, 6:25am UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/12 "2026-09-05T06:25:18Z")
> [@ShaneH](#): > > `system.db.runPrepUpdate(query, [], 'ACME')` Use: `system.db.runPrepUpdate(query, [], 'ACME',"",false,false)` This will work perfectly. Note: `false` is not Python syntax; it's Java syntax. ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [September 8, 2026, 4:54pm UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/13 "2026-09-08T16:54:31Z")
> [@Md\_Sabbir\_Ahamed](#): > > `system.db.runPrepUpdate(query, [], 'ACME',"",false,false)` This will fail with a syntax error unless you've defined a local variable `false`. Have you actually tried this, before you resurrected this thread? ---
**Author:** ![Md\_Sabbir\_Ahamed](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/md_sabbir_ahamed/32/54273_2.png) [@Md\_Sabbir\_Ahamed](https://forum.inductiveautomation.com/u/Md_Sabbir_Ahamed)\ **Post date:** [September 15, 2026, 8:10am UTC](https://forum.inductiveautomation.com/t/ign-15326-8-3-system-db-runprepupdate-not-throwing/113554/14 "2026-09-15T08:10:37Z")
Paul, you're right. My apologies for saying otherwise.