# system.db.prepUpdate error

**URL:** <https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344>\
**Category:** Ignition\
**Created:** [December 7, 2022, 4:58pm UTC](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344 "2022-12-07T16:58:55Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![rahman.tarek](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\
**Post date:** [December 7, 2022, 4:58pm UTC](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344/1 "2022-12-07T16:58:55Z")

</div>

Hi there,

I am suddenly getting a wierd error with the system.db.prepUpdate function. im calling it from an alarm active tag scripting function

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/c/1cc6d48702fc1a22c3338db8306675529cf4b277.png)

And i am getting this error which i wasnt before

Error executing script.  
Traceback (most recent call last):  
File "tagevent:alarmActive", line 2, in alarmActive  
File "module:GlobalScripts", line 189, in alarmact  
VALUES (?,?,?,?,?,?,?,?,?,?,?)  
, [2773, Tool\_Radius, 9376.0, 123456, A7890, TD Test, TD TEst, TD Test, Wed Dec 07 11:52:50 EST 2022, d680b796-2260-4ebc-83eb-015e4b6b4e4a, 3801\_42], DB, , false, false)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:392)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:268)  
at jdk.internal.reflect.GeneratedMethodAccessor149.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(INSERT INTO CT\_AlarmDetails(alarmid,alarmname,alarmvalue,workstation,program,operationNumber,partNumber,serialNumber,time,eventid,workcenter)  
VALUES (?,?,?,?,?,?,?,?,?,?,?)  
, [2773, Tool\_Radius, 9376.0, 123456, A7890, TD Test, TD TEst, TD Test, Wed Dec 07 11:52:50 EST 2022, d680b796-2260-4ebc-83eb-015e4b6b4e4a, 3801\_42], DB, , false, false)

Any idea why??

---

<div class="post-metadata">

**Author:** ![rahman.tarek](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\
**Post date:** [December 7, 2022, 5:57pm UTC](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344/2 "2022-12-07T17:57:03Z")

</div>

Update - i removed the system.db.prep.update functions and i am still getting an error! this must be a bug right

Error executing script.  
Traceback (most recent call last):  
File "tagevent:alarmActive", line 2, in alarmActive  
File "module:GlobalScripts", line 189, in alarmact  
VALUES (?,?,?,?,?,?,?,?,?,?,?)  
, [2773, Tool\_Radius, 9376.0, 123456, A7890, TD Test, TD TEst, TD Test, Wed Dec 07 11:52:50 EST 2022, d680b796-2260-4ebc-83eb-015e4b6b4e4a, 3801\_42], DB, , false, false)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:392)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:268)  
at jdk.internal.reflect.GeneratedMethodAccessor149.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(INSERT INTO CT\_AlarmDetails(alarmid,alarmname,alarmvalue,workstation,program,operationNumber,partNumber,serialNumber,time,eventid,workcenter)  
VALUES (?,?,?,?,?,?,?,?,?,?,?)  
, [2773, Tool\_Radius, 9376.0, 123456, A7890, TD Test, TD TEst, TD Test, Wed Dec 07 11:52:50 EST 2022, d680b796-2260-4ebc-83eb-015e4b6b4e4a, 3801\_42], DB, , false, false)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/7/f7f0aeb9fcf5f1bdc71c5d8c37412281d264106d.png)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 7, 2022, 6:09pm UTC](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344/3 "2022-12-07T18:09:01Z")

</div>

Please post the entire error, as there should be a 'Caused by' section.

---

<div class="post-metadata">

**Author:** ![rahman.tarek](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\
**Post date:** [December 7, 2022, 6:45pm UTC](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344/4 "2022-12-07T18:45:34Z")

</div>

this is everything in the error msg

Error executing script.  
Traceback (most recent call last):  
File "tagevent:alarmActive", line 2, in alarmActive  
File "module:GlobalScripts", line 185, in alarmact  
VALUES (?,?,?,?,?,?,?,?,?,?,?)  
, [2803, Tool\_Radius, 0.377, 123456, A7890, TD Test, TD TEst, TD Test, Wed Dec 07 13:43:39 EST 2022, b10febcc-6d9a-4499-891a-330329ef51a4, 3801\_42], DB, , false, false)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:392)  
at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:268)  
at jdk.internal.reflect.GeneratedMethodAccessor149.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(INSERT INTO CT\_AlarmDetails(alarmid,alarmname,alarmvalue,workstation,program,operationNumber,partNumber,serialNumber,time,eventid,workcenter)  
VALUES (?,?,?,?,?,?,?,?,?,?,?)  
, [2803, Tool\_Radius, 0.377, 123456, A7890, TD Test, TD TEst, TD Test, Wed Dec 07 13:43:39 EST 2022, b10febcc-6d9a-4499-891a-330329ef51a4, 3801\_42], DB, , false, false)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 7, 2022, 7:12pm UTC](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344/5 "2022-12-07T19:12:24Z")

</div>

The full error message should be in the gateway log, as it's running in a tag script.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 7, 2022, 7:14pm UTC](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344/6 "2022-12-07T19:14:49Z")

</div>

Also, your traceback states there error is at line 187, which you aren't showing.

---

<div class="post-metadata">

**Author:** ![rahman.tarek](https://avatars.discourse-cdn.com/v4/letter/r/b77776/32.png) [@rahman.tarek](https://forum.inductiveautomation.com/u/rahman.tarek)\
**Post date:** [December 7, 2022, 7:15pm UTC](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344/7 "2022-12-07T19:15:26Z")

</div>

com.inductiveautomation.ignition.common.script.JythonExecException: Traceback (most recent call last): File "", line 2, in alarmActive File "", line 162, in alarmact VALUES (?,?,?,?,?,?,?,?,?,?,?) , [2803, Tool\_Radius, 0.376, 123456, A7890, TD Test, TD TEst, TD Test, Wed Dec 07 13:50:17 EST 2022, ef2b1fbb-2f68-4bbd-93e1-c28bed1d593c, 3801\_42], DB, , false, false) at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:392) at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:268) at jdk.internal.reflect.GeneratedMethodAccessor149.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(INSERT INTO CT\_AlarmDetails(alarmid,alarmname,alarmvalue,workstation,program,operationNumber,partNumber,serialNumber,time,eventid,workcenter) VALUES (?,?,?,?,?,?,?,?,?,?,?) , [2803, Tool\_Radius, 0.376, 123456, A7890, TD Test, TD TEst, TD Test, Wed Dec 07 13:50:17 EST 2022, ef2b1fbb-2f68-4bbd-93e1-c28bed1d593c, 3801\_42], DB, , false, false)

at org.python.core.Py.JavaError(Py.java:547)

at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.error(AbstractDBUtilities.java:392)

at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:268)

at jdk.internal.reflect.GeneratedMethodAccessor149.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.base/java.lang.reflect.Method.invoke(Unknown Source)

at org.python.core.PyReflectedFunction. **call** (PyReflectedFunction.java:190)

at com.inductiveautomation.ignition.common.script.ScriptManager$ReflectedInstanceFunction. **call** (ScriptManager.java:541)

at org.python.core.PyObject. **call** (PyObject.java:494)

at org.python.core.PyObject. **call** (PyObject.java:498)

at org.python.pycode.\_pyx876835.alarmact$5(:162)

at org.python.pycode.\_pyx876835.call\_function()

at org.python.core.PyTableCode.call(PyTableCode.java:173)

at org.python.core.PyBaseCode.call(PyBaseCode.java:306)

at org.python.core.PyFunction.function\_\_\_call\_\_(PyFunction.java:474)

at org.python.core.PyFunction. **call** (PyFunction.java:469)

at org.python.core.PyFunction. **call** (PyFunction.java:459)

at org.python.pycode.\_pyx876861.alarmActive$1(:2)

at org.python.pycode.\_pyx876861.call\_function()

at org.python.core.PyTableCode.call(PyTableCode.java:173)

at org.python.core.PyBaseCode.call(PyBaseCode.java:306)

at org.python.core.PyFunction.function\_\_\_call\_\_(PyFunction.java:474)

at org.python.core.PyFunction. **call** (PyFunction.java:469)

at org.python.core.PyFunction. **call** (PyFunction.java:464)

at com.inductiveautomation.ignition.common.script.ScriptManager.runFunction(ScriptManager.java:831)

at com.inductiveautomation.ignition.common.script.ScriptManager.runFunction(ScriptManager.java:813)

at com.inductiveautomation.ignition.gateway.project.ProjectScriptLifecycle$TrackingProjectScriptManager.runFunction(ProjectScriptLifecycle.java:806)

at com.inductiveautomation.ignition.gateway.tags.scripting.TagScriptManagerImpl$FunctionInvokerImpl.run(TagScriptManagerImpl.java:533)

at com.inductiveautomation.ignition.gateway.tags.scripting.events.AbstractTagScript.invoke(AbstractTagScript.java:34)

at com.inductiveautomation.ignition.gateway.tags.scripting.TagScriptManagerImpl$Task.invoke(TagScriptManagerImpl.java:482)

at com.inductiveautomation.ignition.gateway.tags.scripting.TagScriptManagerImpl$TagScriptDispatcher.run(TagScriptManagerImpl.java:445)

at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:539)

at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.base/java.lang.Thread.run(Unknown Source)

Caused by: org.python.core.PyException: java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepUpdate(INSERT INTO CT\_AlarmDetails(alarmid,alarmname,alarmvalue,workstation,program,operationNumber,partNumber,serialNumber,time,eventid,workcenter) VALUES (?,?,?,?,?,?,?,?,?,?,?) , [2803, Tool\_Radius, 0.376, 123456, A7890, TD Test, TD TEst, TD Test, Wed Dec 07 13:50:17 EST 2022, ef2b1fbb-2f68-4bbd-93e1-c28bed1d593c, 3801\_42], DB, , false, false)

... 38 common frames omitted

Caused by: java.lang.Exception: Error executing system.db.runPrepUpdate(INSERT INTO CT\_AlarmDetails(alarmid,alarmname,alarmvalue,workstation,program,operationNumber,partNumber,serialNumber,time,eventid,workcenter) VALUES (?,?,?,?,?,?,?,?,?,?,?) , [2803, Tool\_Radius, 0.376, 123456, A7890, TD Test, TD TEst, TD Test, Wed Dec 07 13:50:17 EST 2022, ef2b1fbb-2f68-4bbd-93e1-c28bed1d593c, 3801\_42], DB, , false, false)

... 37 common frames omitted

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the nvarchar value 'TD Test' to data type int.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1662)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:615)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:537)

at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7417)

at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:3488)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:262)

at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:237)

at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(SQLServerPreparedStatement.java:483)

at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)

at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:136)

at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper$SRPreparedStatement.executeUpdate(SRConnectionWrapper.java:981)

at com.inductiveautomation.ignition.gateway.datasource.SRConnectionWrapper.runPrepUpdate(SRConnectionWrapper.java:181)

at com.inductiveautomation.ignition.gateway.script.GatewayDBUtilities.\_runPrepStmt(GatewayDBUtilities.java:202)

at com.inductiveautomation.ignition.common.script.builtin.AbstractDBUtilities.runPrepUpdate(AbstractDBUtilities.java:261)

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [December 7, 2022, 7:18pm UTC](https://forum.inductiveautomation.com/t/system-db-prepupdate-error/67344/8 "2022-12-07T19:18:29Z")

</div>

Here is the caused by:

> [@rahman.tarek](#):
>
> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Conversion failed when converting the nvarchar value 'TD Test' to data type int.