# Change Value query script error

**URL:** <https://forum.inductiveautomation.com/t/change-value-query-script-error/27752>\
**Category:** Ignition\
**Tags:** ignition80\
**Created:** [August 26, 2019, 8:18am UTC](https://forum.inductiveautomation.com/t/change-value-query-script-error/27752 "2019-08-26T08:18:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sarmad.al-rubaye](https://avatars.discourse-cdn.com/v4/letter/s/a5b964/32.png) [@sarmad.al-rubaye](https://forum.inductiveautomation.com/u/sarmad.al-rubaye)\
**Post date:** [August 26, 2019, 8:18am UTC](https://forum.inductiveautomation.com/t/change-value-query-script-error/27752/1 "2019-08-26T08:18:29Z")

</div>

Hi,  
I 'm trying to write a script that update a DB in Change value of a Tag, the query script working fine in the global Script Console, but it doesn’t work in Change value script and generat the error below.

is there any one can help!!

script:

if system.tag.read("[default]predictive\_maintenance\_plc\_data/test\_routine\_active\_flag").value == True:  
st\_number=system.tag.read("[default]predictive\_maintenance\_plc\_data/station\_nummber").value  
plm\_num =system.tag.read("[default]predictive\_maintenance\_plc\_data/PLM\_number").value  
test\_id= system.tag.read("[default]predictive\_maintenance\_plc\_data/test\_ID").value  
test\_value= system.tag.read("[default]predictive\_maintenance\_plc\_data/test\_value").value  
from datetime import datetime  
now=datetime.now()  
datetime = now.strftime("%Y.%m.%d %H:%M:%S")  
print st\_number,plm\_num,test\_id,test\_value,datetime  
print plm\_num  
query\_01=“INSERT INTO predictive\_test\_data (station\_number, line\_number, test\_ID, test\_result\_value, test\_date\_and\_time)”  
query\_02=" VALUES (?,?,?,?,?)"  
row\_data= (st\_number,plm\_num,test\_id ,test\_value ,datetime)  
query=query\_01 + query\_02  
print query  
system.db.runPrepUpdate(query,row\_data)  
system.tag.write("[default]Mem\_tag\_int",20000)  
else:  
system.tag.write("[default]Mem\_tag\_int",50000)

Error:  
Error executing script.  
Traceback (most recent call last):  
File “tagevent:valueChanged”, line 17, in valueChanged  
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 java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)  
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.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 predictive\_test\_data (station\_number, line\_number, test\_ID, test\_result\_value, test\_date\_and\_time) VALUES (?,?,?,?,?), [10, s000001, 13, 1754, 2019.08.26 08:28:08], , , false, false)

many thanx

---

<div class="post-metadata">

**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:** [August 26, 2019, 11:48am UTC](https://forum.inductiveautomation.com/t/change-value-query-script-error/27752/2 "2019-08-26T11:48:09Z")

</div>

Tag events run outside of project scope, so they don’t have a default database connection. You must specify it. The manual shows that parameter to [system.db.runPrepUpdate](https://docs.inductiveautomation.com/display/DOC79/system.db.runPrepUpdate) as optional, but it isn’t optional when there’s no project to supply a default.

---

<div class="post-metadata">

**Author:** ![sarmad.al-rubaye](https://avatars.discourse-cdn.com/v4/letter/s/a5b964/32.png) [@sarmad.al-rubaye](https://forum.inductiveautomation.com/u/sarmad.al-rubaye)\
**Post date:** [August 27, 2019, 7:30am UTC](https://forum.inductiveautomation.com/t/change-value-query-script-error/27752/3 "2019-08-27T07:30:43Z")

</div>

Thank you pturmel, I do the Change below and it’s working.

old: system.db.runPrepUpdate(query,row\_data)  
new: system.db.runPrepUpdate(query,row\_data, my\_DB\_connection\_name)

👍👍

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [August 27, 2019, 1:27pm UTC](https://forum.inductiveautomation.com/t/change-value-query-script-error/27752/4 "2019-08-27T13:27:09Z")

</div>

Also, you should put any preformatted text blocks within triple tildes, e.g.

```auto
this is preformatted text

```