zjkgqRJV

12018-09-10 13:39:52,138 : DEBUG : main : NodeContainer :  :  : 4. Run Jelly Val 2 has new state: EXECUTING
22018-09-10 13:39:52,139 : DEBUG : KNIME-Worker-17 : WorkflowManager : Database Writer : 2:1271 : Database Writer 2:1271 doBeforePreExecution
32018-09-10 13:39:52,140 : DEBUG : KNIME-Worker-17 : NodeContainer : Database Writer : 2:1271 : Database Writer 2:1271 has new state: PREEXECUTE
42018-09-10 13:39:52,140 : DEBUG : KNIME-Worker-17 : WorkflowManager : Database Writer : 2:1271 : Database Writer 2:1271 doBeforeExecution
52018-09-10 13:39:52,140 : DEBUG : KNIME-Worker-17 : NodeContainer : Database Writer : 2:1271 : Database Writer 2:1271 has new state: EXECUTING
62018-09-10 13:39:52,140 : DEBUG : KNIME-Worker-17 : WorkflowFileStoreHandlerRepository : Database Writer : 2:1271 : Adding handler 068bd77d-bc61-4b74-ae8a-deb80ead7f3f (Database Writer 2:1271: <no directory>) - 1 in total
72018-09-10 13:39:52,140 : DEBUG : KNIME-WFM-Parent-Notifier : NodeContainer :  :  : ROOT  has new state: EXECUTING
82018-09-10 13:39:52,140 : DEBUG : KNIME-Worker-17 : LocalNodeExecutionJob : Database Writer : 2:1271 : Database Writer 2:1271 Start execute
92018-09-10 13:39:52,182 : DEBUG : KNIME-Worker-17 : Buffer : Database Writer : 2:1271 : Opening input stream on file "C:\Users\USER.NAME\AppData\Local\Temp\knime_4_ Run Jelly Va82656\knime_container_20180910_4949396331104237027.tmp", 0 open streams
102018-09-10 13:39:52,191 : DEBUG : KNIME-Worker-17 : NodeContext : Database Writer : 2:1271 : Workflow user found: USER.NAME
112018-09-10 13:39:52,233 : DEBUG : KNIME-Worker-17 : RegisteredDriversConnectionFactory : Database Writer : 2:1271 : Valid connection found in cache with key: ConnectionKey [db-user=USER.NAME, db-name=jdbc:netezza://HOST:5480/DATABASE_NAME, wf-user=USER.NAME]
122018-09-10 13:39:52,233 : DEBUG : KNIME-Worker-17 : NodeContext : Database Writer : 2:1271 : Workflow user found: USER.NAME
132018-09-10 13:39:52,261 : DEBUG : KNIME-Worker-17 : DBWriterImpl : Database Writer : 2:1271 : Append not enabled. Table TABLE_NAME_IM_WRITING_TO will be dropped if exists.
142018-09-10 13:39:52,261 : DEBUG : KNIME-Worker-17 : DBWriterImpl : Database Writer : 2:1271 : Executing SQL statement as execute: DROP TABLE TABLE_NAME_IM_WRITING_TO
152018-09-10 13:39:52,353 : DEBUG : KNIME-Worker-17 : DBWriterImpl : Database Writer : 2:1271 : Executing SQL statement as execute: CREATE TABLE TABLE_NAME_IM_WRITING_TO (PRODUCT_NUM integer, STORE_NUM integer, Linear numeric(30,10), "Target Linear" integer, "Assortment Cluster" varchar(255), "Closest Proto" varchar(255), P_UNITS numeric(30,10), P_POS numeric(30,10), "Reco POS At Risk" numeric(30,10), "Proto POS At Risk" numeric(30,10), "Reco Capacity Overstock POS" numeric(30,10), "Proto Capacity Overstock POS" numeric(30,10), "Reco Capacity POS Covered" numeric(30,10), "Proto Capacity POS Covered" numeric(30,10))
162018-09-10 13:39:52,503 : DEBUG : KNIME-Worker-17 : DBWriterImpl : Database Writer : 2:1271 : Executing SQL statement as prepareStatement: INSERT INTO TABLE_NAME_IM_WRITING_TO (PRODUCT_NUM, STORE_NUM, Linear, "Target Linear", "Assortment Cluster", "Closest Proto", P_UNITS, P_POS, "Reco POS At Risk", "Proto POS At Risk", "Reco Capacity Overstock POS", "Proto Capacity Overstock POS", "Reco Capacity POS Covered", "Proto Capacity POS Covered") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
172018-09-10 13:39:53,318 : DEBUG : KNIME-Worker-17 : Buffer : Database Writer : 2:1271 : Closing input stream on "C:\Users\USER.NAME\AppData\Local\Temp\knime_4_ Run Jelly Va82656\knime_container_20180910_4949396331104237027.tmp", 0 remaining
182018-09-10 13:39:54,957 : DEBUG : main : NodeContainerEditPart :  :  : Database Writer 2:1271 (EXECUTING)