Hi.
I have a gateway script, where i log a bunch of data to mssql.
on each sql run, i print out the sql string (ends up in wrapper.log)
the print out, is however NOT the same as written as i have in my ide/project.
If you compare what is written out on the print, and whats the script is putting together… a bunch of columns in the sql strings are missing from the query string.
Wrapper.log:
INFO | jvm 1 | 2014/07/30 10:46:49 | INFO [LocalDBManagerImpl ] [10:46:49,948]: Created auto-backup of internal database "settings" in 340 ms
INFO | jvm 1 | 2014/07/30 10:57:21 | 3184
INFO | jvm 1 | 2014/07/30 10:58:30 | Loggar batch...
INFO | jvm 1 | 2014/07/30 10:58:30 |
INFO | jvm 1 | 2014/07/30 10:58:30 | INSERT INTO ignition.dbo.sandvik_batchlogg (
INFO | jvm 1 | 2014/07/30 10:58:30 | [dt]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[TO_nr]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[S_nr]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[capp_id]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[pulver_batch_nr]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[pulver_fatnr]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[pulver_sort]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[bv_uppvagning]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[av_uppvagning]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[event]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[event_info]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[silo_nr]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[vikt_uppvagning]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[vikt_finmatning]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[vals_ytter_diam]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[vals_inner_diam]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[vals_vikt]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[vals_hojd]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[kommentar]
INFO | jvm 1 | 2014/07/30 10:58:30 | ,[sammansatt])
INFO | jvm 1 | 2014/07/30 10:58:30 | VALUES
INFO | jvm 1 | 2014/07/30 10:58:30 | ('2014-07-30 10:58:29.924',-3178, 3185, -20674, '115', 0, 467, 11.200000, -0.080000, 0, 'Ingen händelse under uppvägning', 1, 194.400009, 9.040000,0, 0, 0, 0, 'kommentar', 'sammansatt')
INFO | jvm 1 | 2014/07/30 11:07:46 | INFO [Project[sandvik] ] [11:07:46,843]: Restarting gateway scripts...
INFO | jvm 1 | 2014/07/30 11:07:58 | Loggar batch...
INFO | jvm 1 | 2014/07/30 11:07:58 |
INFO | jvm 1 | 2014/07/30 11:07:58 | INSERT INTO ignition.dbo.sandvik_batchlogg (
INFO | jvm 1 | 2014/07/30 11:07:58 | [dt]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[TO_nr]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[S_nr]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[capp_id]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[pulver_batch_nr]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[pulver_fatnr]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[pulver_sort]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[bv_uppvagning]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[av_uppvagning]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[event]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[event_info]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[silo_nr]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[vikt_uppvagning]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[vikt_finmatning]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[vals_ytter_diam]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[vals_inner_diam]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[vals_vikt]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[vals_hojd]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[kommentar]
INFO | jvm 1 | 2014/07/30 11:07:58 | ,[sammansatt])
INFO | jvm 1 | 2014/07/30 11:07:59 | VALUES
INFO | jvm 1 | 2014/07/30 11:07:59 | ('2014-07-30 11:07:58.937',-3178, 3185, -20674, '115', 0, 467, 11.200000, -0.080000, 0, 'Ingen händelse under uppvägning', 1, 194.400009, 9.040000,0, 0, 0, 0, 'kommentar', 'sammansatt')
The actual gateway script in the designer:
[code]import sys
from datetime import datetime, date
tmpTuplesEventInfo = (
‘Ingen händelse under uppvägning’,
‘Maskinen har nödstoppats under uppvägning’,
‘Maskinen har varit strömlös alt. andra delar varit strömlöst’,
‘Sekevensen har pausats mitt i’,
‘Timeout pga utebliven viktförändring på våg’,
‘Sekvensen avbröts’,
‘Reserv 6’,
‘Reserv 7’,
‘Reserv 8’,
‘Reserv 9’,
‘Reserv 10’,
‘Reserv 11’,
‘Reserv 12’)
if initialChange:
pass
elif newValue.value:
print “Loggar batch…”
#Läs loggdata från DB10-taggar
tmp_TimeStamp = str(datetime.now())[0:-3]
tmp_TO_nr = system.tag.read(“S7_300/DB10/I2_TONummer”)
tmp_S_nr = system.tag.read(“S7_300/DB10/I0_SNummer”)
tmp_capp_id = system.tag.read(“S7_300/DB10/I4_CappID”)
tmp_pulver_batchnr = system.tag.getTagValue(“S7_300/DB10/STRING22_BatchNummer”)
tmp_pulver_fatnr = system.tag.read(“S7_300/DB3/I46_FatNummer”)
tmp_pulver_sort = system.tag.read(“S7_300/DB10/I6_Pulversort”)
tmp_bv_uppvagning = system.tag.read(“S7_300/DB10/REAL8_Borvarde”)
tmp_av_uppvagning = system.tag.read(“S7_300/DB10/REAL12_ArVarde”)
tmp_event = system.tag.read(“S7_300/DB10/I16_Event”)
try:
tmp_event_info = tmpTuplesEventInfo[int(tmp_event.value)]
except:
tmp_event_info = “Event ej specificerat”
tmp_silo_nr = system.tag.read(“S7_300/DB10/I18_SiloNummer”)
tmp_vikt_uppvagning = system.tag.read(“S7_300/DB10/REAL30_ViktUppvagning”)
tmp_vikt_finmatning = system.tag.read(“S7_300/DB10/REAL34_ViktFinmatning”)
tmp_vals_ytter_diam = system.tag.read(“S7_300/DB10/I38_YtterDiamVals”)
tmp_vals_inner_diam = system.tag.read(“S7_300/DB10/I40_InnerDiamVals”)
tmp_vals_vikt = system.tag.read(“S7_300/DB3/REAL66_ViktVals”)
tmp_vals_hojd = system.tag.read(“S7_300/DB10/I42_HojdVals”)
tmp_kund_nr = system.tag.read(“S7_300/DB3/I70_KundNummer”)
tmp_kommentar = “kommentar”
tmp_sammansatt = “sammansatt”
#Skriver till
#print tmp_TimeStamp
#tmpQueryString = "INSERT INTO ignition.dbo.sandvik_batchlogg ([dt],[TO_nr],[S_nr],[capp_id],[pulver_batch_nr],[pulver_fatnr],[pulver_sort],[bv_uppvagning],[av_uppvagning],[event],[event_info],[silo_nr],[vikt_uppvagning],[vikt_finmatning],[vals_ytter_diam],[vals_inner_diam],[vals_vikt],[vals_hojd],[kundnr],[kommentar],[sammansatt]) VALUES ('GetDate()',%d, %d, %d,'%s', %d, %d, %f, %f, %d, '%s', %d, %f, %f,%d, %d, %d, %d, %d,'%s','%s')" % (
#tmp_TimeStamp,tmp_TO_nr.value,tmp_S_nr.value,tmp_capp_id.value,tmp_pulver_batchnr,tmp_pulver_fatnr.value,tmp_pulver_sort.value,tmp_bv_uppvagning.value,tmp_av_uppvagning.value,tmp_event.value,tmp_event_info,tmp_silo_nr.value,tmp_vikt_uppvagning.value,tmp_vikt_finmatning.value,tmp_vals_ytter_diam.value,tmp_vals_inner_diam.value,tmp_vals_vikt.value,tmp_vals_hojd.value,tmp_kund_nr.value,tmp_kommentar,tmp_sammansatt)
tmpQueryString = """
INSERT INTO ignition.dbo.sandvik_batchlogg (
[dt]
,[TO_nr]
,[S_nr]
,[capp_id]
,[pulver_batch_nr]
,[pulver_fatnr]
,[pulver_sort]
,[bv_uppvagning]
,[av_uppvagning]
,[event]
,[event_info]
,[silo_nr]
,[vikt_uppvagning]
,[vikt_finmatning]
,[vals_ytter_diam]
,[vals_inner_diam]
,[vals_vikt]
,[vals_hojd]
,[kundnr]
,[kommentar]
,[sammansatt])
VALUES ('GetDate()',%d, %d, %d, '%s', %d, %d, %f, %f, %d, '%s', %d, %f, %f, %d, %d, %f, %d, %d, '%s', '%s')""" % (
int(tmp_TO_nr.value),
int(tmp_S_nr.value),
int(tmp_capp_id.value),
tmp_pulver_batchnr,
int(tmp_pulver_fatnr.value),
int(tmp_pulver_sort.value),
toFloat(tmp_bv_uppvagning.value),
toFloat(tmp_av_uppvagning.value),
int(tmp_event.value),
tmp_event_info,
int(tmp_silo_nr.value),
tmp_vikt_uppvagning.value,
tmp_vikt_finmatning.value,
int(tmp_vals_ytter_diam.value),
int(tmp_vals_inner_diam.value),
toFloat(tmp_vals_vikt.value),
int(tmp_vals_hojd.value),
int(tmp_kund_nr.value),
tmp_kommentar,
tmp_sammansatt)
try:
system.db.runUpdateQuery(tmpQueryString,"MSSqlLocal")
system.tag.write("S7_300/DB3/X16_1_LoggData",0)
system.tag.write("mem_FelVidBatchloggningTillDatabas",0)
except:
system.tag.write("mem_FelVidBatchloggningTillDatabas",1)
system.tag.write("S7_300/DB3/X16_1_LoggData",0)
print tmpQueryString [/code]