Change Value query script error

Ignition
1

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

2

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 as optional, but it isn’t optional when there’s no project to supply a default.

3

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)

:+1::+1:

1 Like
4

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

this is preformatted text