Thank J Clark,
I have tried as per your comment, the same error showing for ‘EVENT_TIMESTAMP’ column. Please advice.
Could I missing the quote for timestamp field. I have tried with quote also like (’?’).
Thank in advance.
Code :
currentDatetime = system.tag.read("[System]Gateway/CurrentDateTime")
CurrnetUser = system.tag.read("[System]Client/User/Username")
Hostname = system.tag.read("[System]Client/Network/Hostname")
TagPath = ‘FQ_ZEROED_EVENT’
action_name = ‘tag write’
tag_value = ‘zero’ #currentValue.value
statuscode = “0”
project = “project=WKWD”
originator = “2”
query = “SELECT max(AUDIT_EVENTS_ID) FROM audit_events”
rownumber = system.db.runScalarQuery(query)
rownumber1 = rownumber + 1
#insertQuery = “INSERT INTO event_test (Tagpath, Description, user, value1) VALUES (?,?,?,?)”, [Hostname, project, project, project]
#system.db.runPrepUpdate(“INSERT INTO inventory (name,description) VALUES (?,?)”,[name, description])
#system.gui.messageBox(str(insertQuery),“test”)
system.db.runPrepUpdate(“INSERT INTO event_test (EVENT_TIMESTAMP,ACTOR,ACTOR_HOST,ACTION,ACTION_TARGET,ACTION_VALUE,STATUS_CODE,ORIGINATING_SYSTEM,ORIGINATING_CONTEXT) VALUES (?,?,?,?,?,?,?,?,?)”,[currentDatetime.value,CurrnetUser.value,Hostname.value,action_name,TagPath ,tag_value,statuscode, project, originator])
Error:
Traceback (most recent call last):
File “”, line 16, in
java.lang.Exception: java.lang.Exception: Error executing system.db.runPrepUpdate(INSERT INTO event_test (EVENT_TIMESTAMP,ACTOR,ACTOR_HOST,ACTION,ACTION_TARGET,ACTION_VALUE,STATUS_CODE,ORIGINATING_SYSTEM,ORIGINATING_CONTEXT) VALUES (?,?,?,?,?,?,?,?,?), [Tue Oct 28 19:12:58 IST 2014, admin, auto6, tag write, FQ_ZEROED_EVENT, zero, 0, project=WKWD, 2], , , false, false)
caused by Exception: Error executing system.db.runPrepUpdate(INSERT INTO event_test (EVENT_TIMESTAMP,ACTOR,ACTOR_HOST,ACTION,ACTION_TARGET,ACTION_VALUE,STATUS_CODE,ORIGINATING_SYSTEM,ORIGINATING_CONTEXT) VALUES (?,?,?,?,?,?,?,?,?), [Tue Oct 28 19:12:58 IST 2014, admin, auto6, tag write, FQ_ZEROED_EVENT, zero, 0, project=WKWD, 2], , , false, false)
caused by GatewayException: SQL error for "INSERT INTO event_test (EVENT_TIMESTAMP,ACTOR,ACTOR_HOST,ACTION,ACTION_TARGET,ACTION_VALUE,STATUS_CODE,ORIGINATING_SYSTEM,ORIGINATING_CONTEXT) VALUES (?,?,?,?,?,?,?,?,?)": Unknown column 'EVENT_TIMESTAMP' in 'field list'
caused by MySQLSyntaxErrorException: Unknown column 'EVENT_TIMESTAMP' in 'field list'
Ignition v7.7.2-rc1 (b2014102314)
Java: Oracle Corporation 1.7.0_67