Hi,
I would like to create a workflow that connects to an SFTP, selects the latest file and uploads that file on the KNIME Server. I’m using the below workflow but the upload node fails with the error message ‘Execute failed: Connection information must not be null’ .
I would then want to publish this workflow on the KNIME Server in order to automate the process.
I’m not sure if I’m using the correct nodes here. Any help would be much appreciated.
Thanks
Kind regards,
Kon
Hi @Kon,
Can you please post the full error from knime.log? Can you also please try the “Test connection” button in the KNIME Server Connection node? I don’t see anything wrong with the nodes you are using, so I want to make sure that the connection actually works.
Cheers,
Roland
Hi @RolandBurger. Please see the full error below:
2018-11-12 13:50:15,830 : DEBUG : main : NodeContainerEditPart : : : Upload 12:357 (CONFIGURED)
2018-11-12 13:51:50,308 : DEBUG : main : NodeContainerEditPart : : : Upload 12:357 (CONFIGURED)
2018-11-12 13:51:50,475 : DEBUG : main : NodeContainerEditPart : : : Row Filter 12:336 (EXECUTED)
2018-11-12 13:51:50,476 : DEBUG : main : NodeContainerEditPart : : : Rank 12:337 (EXECUTED)
2018-11-12 13:51:50,476 : DEBUG : main : NodeContainerEditPart : : : URI to String 12:335 (EXECUTED)
2018-11-12 13:51:50,476 : DEBUG : main : NodeContainerEditPart : : : String to URI 12:358 (EXECUTED)
2018-11-12 13:51:50,511 : DEBUG : main : NodeContainerEditPart : : : Upload 12:357 (CONFIGURED)
2018-11-12 13:51:50,520 : DEBUG : main : NodeContainerEditPart : : : String to URI 12:358 (EXECUTED)
2018-11-12 13:51:50,567 : DEBUG : main : NodeContainerEditPart : : : List Remote Files 12:332 (EXECUTED)
2018-11-12 13:51:50,567 : DEBUG : main : NodeContainerEditPart : : : SSH Connection 12:331 (EXECUTED)
2018-11-12 13:51:50,567 : DEBUG : main : NodeContainerEditPart : : : KNIME Server Connection 12:351 (EXECUTED)
2018-11-12 13:51:50,605 : DEBUG : main : NodeContainerEditPart : : : Create Directory 12:352 (EXECUTED)
2018-11-12 13:51:53,773 : DEBUG : main : ResetAction : : : Resetting 9 node(s)
2018-11-12 13:51:53,773 : DEBUG : main : Node : Upload : 12:357 : reset
2018-11-12 13:51:53,773 : DEBUG : main : Node : Upload : 12:357 : clean output ports.
2018-11-12 13:51:53,773 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: IDLE
2018-11-12 13:51:53,773 : DEBUG : main : Node : String to URI : 12:358 : reset
2018-11-12 13:51:53,773 : DEBUG : main : Node : String to URI : 12:358 : clean output ports.
2018-11-12 13:51:53,773 : DEBUG : main : WorkflowFileStoreHandlerRepository : : : Removing handler 3e881d0e-7efb-4d3e-a22c-5e3fbb1c6a68 (String to URI 12:358: ) - 7 remaining
2018-11-12 13:51:53,773 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: IDLE
2018-11-12 13:51:53,773 : DEBUG : main : Node : Row Filter : 12:336 : reset
2018-11-12 13:51:53,773 : DEBUG : main : Node : Row Filter : 12:336 : clean output ports.
2018-11-12 13:51:53,773 : DEBUG : main : WorkflowFileStoreHandlerRepository : : : Removing handler 13ca5b9d-88bf-4357-871b-a17c3aace67b (Row Filter 12:336: ) - 6 remaining
2018-11-12 13:51:53,773 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: IDLE
2018-11-12 13:51:53,773 : DEBUG : main : Node : Row Filter : 12:336 : Configure succeeded. (Row Filter)
2018-11-12 13:51:53,773 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: CONFIGURED
2018-11-12 13:51:53,774 : DEBUG : main : Node : String to URI : 12:358 : Configure succeeded. (String to URI)
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: CONFIGURED
2018-11-12 13:51:53,774 : DEBUG : main : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: CONFIGURED
2018-11-12 13:51:53,774 : DEBUG : main : Node : Upload : 12:357 : reset
2018-11-12 13:51:53,774 : DEBUG : main : Node : Upload : 12:357 : clean output ports.
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: IDLE
2018-11-12 13:51:53,774 : DEBUG : main : Node : String to URI : 12:358 : reset
2018-11-12 13:51:53,774 : DEBUG : main : Node : String to URI : 12:358 : clean output ports.
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: IDLE
2018-11-12 13:51:53,774 : DEBUG : main : Node : Row Filter : 12:336 : reset
2018-11-12 13:51:53,774 : DEBUG : main : Node : Row Filter : 12:336 : clean output ports.
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: IDLE
2018-11-12 13:51:53,774 : DEBUG : main : Node : Rank : 12:337 : reset
2018-11-12 13:51:53,774 : DEBUG : main : Node : Rank : 12:337 : clean output ports.
2018-11-12 13:51:53,774 : DEBUG : main : WorkflowFileStoreHandlerRepository : : : Removing handler 4c00197a-f3bf-4e81-b088-4c71237588ed (Rank 12:337: ) - 5 remaining
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Rank 12:337 has new state: IDLE
2018-11-12 13:51:53,774 : DEBUG : main : Node : Rank : 12:337 : Configure succeeded. (Rank)
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Rank 12:337 has new state: CONFIGURED
2018-11-12 13:51:53,774 : DEBUG : main : Node : Row Filter : 12:336 : Configure succeeded. (Row Filter)
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: CONFIGURED
2018-11-12 13:51:53,774 : DEBUG : main : Node : String to URI : 12:358 : Configure succeeded. (String to URI)
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: CONFIGURED
2018-11-12 13:51:53,774 : DEBUG : main : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: CONFIGURED
2018-11-12 13:51:53,774 : DEBUG : main : Node : Upload : 12:357 : reset
2018-11-12 13:51:53,774 : DEBUG : main : Node : Upload : 12:357 : clean output ports.
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: IDLE
2018-11-12 13:51:53,774 : DEBUG : main : Node : String to URI : 12:358 : reset
2018-11-12 13:51:53,774 : DEBUG : main : Node : String to URI : 12:358 : clean output ports.
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: IDLE
2018-11-12 13:51:53,774 : DEBUG : main : Node : Row Filter : 12:336 : reset
2018-11-12 13:51:53,774 : DEBUG : main : Node : Row Filter : 12:336 : clean output ports.
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: IDLE
2018-11-12 13:51:53,774 : DEBUG : main : Node : Rank : 12:337 : reset
2018-11-12 13:51:53,774 : DEBUG : main : Node : Rank : 12:337 : clean output ports.
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Rank 12:337 has new state: IDLE
2018-11-12 13:51:53,774 : DEBUG : main : Node : URI to String : 12:335 : reset
2018-11-12 13:51:53,774 : DEBUG : main : Node : URI to String : 12:335 : clean output ports.
2018-11-12 13:51:53,774 : DEBUG : main : WorkflowFileStoreHandlerRepository : : : Removing handler 551f607f-9c52-49e3-aa88-17e64f1ac982 (URI to String 12:335: ) - 4 remaining
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : URI to String 12:335 has new state: IDLE
2018-11-12 13:51:53,774 : DEBUG : main : Node : List Remote Files : 12:332 : reset
2018-11-12 13:51:53,774 : DEBUG : main : Node : List Remote Files : 12:332 : clean output ports.
2018-11-12 13:51:53,774 : DEBUG : main : WorkflowFileStoreHandlerRepository : : : Removing handler cbd82fc6-966f-4cce-bdca-e0741c0bd8a4 (List Remote Files 12:332: ) - 3 remaining
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : List Remote Files 12:332 has new state: IDLE
2018-11-12 13:51:53,774 : DEBUG : main : Node : List Remote Files : 12:332 : Configure succeeded. (List Remote Files)
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : List Remote Files 12:332 has new state: CONFIGURED
2018-11-12 13:51:53,774 : DEBUG : main : Node : URI to String : 12:335 : Configure succeeded. (URI to String)
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : URI to String 12:335 has new state: CONFIGURED
2018-11-12 13:51:53,774 : DEBUG : main : Node : Rank : 12:337 : Configure succeeded. (Rank)
2018-11-12 13:51:53,774 : DEBUG : main : NodeContainer : : : Rank 12:337 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : Row Filter : 12:336 : Configure succeeded. (Row Filter)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : String to URI : 12:358 : Configure succeeded. (String to URI)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : Create Directory : 12:352 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : Create Directory : 12:352 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : WorkflowFileStoreHandlerRepository : : : Removing handler f7bf3224-93f3-4f97-a1eb-c7c293e8a057 (Create Directory 12:352: ) - 2 remaining
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Create Directory 12:352 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : Create Directory : 12:352 : Configure succeeded. (Create Directory)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Create Directory 12:352 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : String to URI : 12:358 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : String to URI : 12:358 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : Row Filter : 12:336 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : Row Filter : 12:336 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : Rank : 12:337 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : Rank : 12:337 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Rank 12:337 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : URI to String : 12:335 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : URI to String : 12:335 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : URI to String 12:335 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : URI to String : 12:335 : Configure succeeded. (URI to String)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : URI to String 12:335 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : Rank : 12:337 : Configure succeeded. (Rank)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Rank 12:337 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : Row Filter : 12:336 : Configure succeeded. (Row Filter)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : String to URI : 12:358 : Configure succeeded. (String to URI)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: CONFIGURED
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : Upload : 12:357 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : String to URI : 12:358 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : String to URI : 12:358 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : Row Filter : 12:336 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : Row Filter : 12:336 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : Rank : 12:337 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : Rank : 12:337 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : Rank 12:337 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : URI to String : 12:335 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : URI to String : 12:335 : clean output ports.
2018-11-12 13:51:53,775 : DEBUG : main : NodeContainer : : : URI to String 12:335 has new state: IDLE
2018-11-12 13:51:53,775 : DEBUG : main : Node : List Remote Files : 12:332 : reset
2018-11-12 13:51:53,775 : DEBUG : main : Node : List Remote Files : 12:332 : clean output ports.
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : List Remote Files 12:332 has new state: IDLE
2018-11-12 13:51:53,776 : DEBUG : main : Node : SSH Connection : 12:331 : reset
2018-11-12 13:51:53,776 : DEBUG : main : Node : SSH Connection : 12:331 : clean output ports.
2018-11-12 13:51:53,776 : DEBUG : main : WorkflowFileStoreHandlerRepository : : : Removing handler af1d9ad6-eeeb-424a-afe6-251327aaa416 (SSH Connection 12:331: ) - 1 remaining
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : SSH Connection 12:331 has new state: IDLE
2018-11-12 13:51:53,776 : DEBUG : main : Node : SSH Connection : 12:331 : Configure succeeded. (SSH Connection)
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : SSH Connection 12:331 has new state: CONFIGURED
2018-11-12 13:51:53,776 : DEBUG : main : Node : List Remote Files : 12:332 : Configure succeeded. (List Remote Files)
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : List Remote Files 12:332 has new state: CONFIGURED
2018-11-12 13:51:53,776 : DEBUG : main : Node : URI to String : 12:335 : Configure succeeded. (URI to String)
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : URI to String 12:335 has new state: CONFIGURED
2018-11-12 13:51:53,776 : DEBUG : main : Node : Rank : 12:337 : Configure succeeded. (Rank)
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : Rank 12:337 has new state: CONFIGURED
2018-11-12 13:51:53,776 : DEBUG : main : Node : Row Filter : 12:336 : Configure succeeded. (Row Filter)
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: CONFIGURED
2018-11-12 13:51:53,776 : DEBUG : main : Node : String to URI : 12:358 : Configure succeeded. (String to URI)
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: CONFIGURED
2018-11-12 13:51:53,776 : DEBUG : main : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: CONFIGURED
2018-11-12 13:51:53,776 : DEBUG : main : Node : Upload : 12:357 : reset
2018-11-12 13:51:53,776 : DEBUG : main : Node : Upload : 12:357 : clean output ports.
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: IDLE
2018-11-12 13:51:53,776 : DEBUG : main : Node : String to URI : 12:358 : reset
2018-11-12 13:51:53,776 : DEBUG : main : Node : String to URI : 12:358 : clean output ports.
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: IDLE
2018-11-12 13:51:53,776 : DEBUG : main : Node : String to URI : 12:358 : Configure succeeded. (String to URI)
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: CONFIGURED
2018-11-12 13:51:53,776 : DEBUG : main : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: CONFIGURED
2018-11-12 13:51:53,776 : DEBUG : main : Node : Upload : 12:357 : reset
2018-11-12 13:51:53,776 : DEBUG : main : Node : Upload : 12:357 : clean output ports.
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: IDLE
2018-11-12 13:51:53,776 : DEBUG : main : Node : Create Directory : 12:352 : reset
2018-11-12 13:51:53,776 : DEBUG : main : Node : Create Directory : 12:352 : clean output ports.
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : Create Directory 12:352 has new state: IDLE
2018-11-12 13:51:53,776 : DEBUG : main : Node : KNIME Server Connection : 12:351 : reset
2018-11-12 13:51:53,776 : DEBUG : main : Node : KNIME Server Connection : 12:351 : clean output ports.
2018-11-12 13:51:53,776 : DEBUG : main : WorkflowFileStoreHandlerRepository : : : Removing handler 97cb1045-68f9-4216-acde-b3dfdb81ce78 (KNIME Server Connection 12:351: ) - 0 remaining
2018-11-12 13:51:53,776 : DEBUG : main : NodeContainer : : : KNIME Server Connection 12:351 has new state: IDLE
2018-11-12 13:51:53,777 : DEBUG : main : Node : KNIME Server Connection : 12:351 : Configure succeeded. (KNIME Server Connection)
2018-11-12 13:51:53,777 : DEBUG : main : NodeContainer : : : KNIME Server Connection 12:351 has new state: CONFIGURED
2018-11-12 13:51:53,777 : DEBUG : main : Node : Create Directory : 12:352 : Configure succeeded. (Create Directory)
2018-11-12 13:51:53,777 : DEBUG : main : NodeContainer : : : Create Directory 12:352 has new state: CONFIGURED
2018-11-12 13:51:53,777 : DEBUG : main : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:53,777 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: CONFIGURED
2018-11-12 13:51:54,233 : DEBUG : main : NodeContainerEditPart : : : Row Filter 12:336 (CONFIGURED)
2018-11-12 13:51:54,234 : DEBUG : main : NodeContainerEditPart : : : Rank 12:337 (CONFIGURED)
2018-11-12 13:51:54,234 : DEBUG : main : NodeContainerEditPart : : : List Remote Files 12:332 (CONFIGURED)
2018-11-12 13:51:54,234 : DEBUG : main : NodeContainerEditPart : : : Create Directory 12:352 (CONFIGURED)
2018-11-12 13:51:54,234 : DEBUG : main : NodeContainerEditPart : : : Upload 12:357 (CONFIGURED)
2018-11-12 13:51:54,234 : DEBUG : main : NodeContainerEditPart : : : URI to String 12:335 (CONFIGURED)
2018-11-12 13:51:54,234 : DEBUG : main : NodeContainerEditPart : : : SSH Connection 12:331 (CONFIGURED)
2018-11-12 13:51:54,234 : DEBUG : main : NodeContainerEditPart : : : String to URI 12:358 (CONFIGURED)
2018-11-12 13:51:54,234 : DEBUG : main : NodeContainerEditPart : : : KNIME Server Connection 12:351 (CONFIGURED)
2018-11-12 13:51:55,196 : DEBUG : main : NodeContainer : : : SSH Connection 12:331 has new state: CONFIGURED_MARKEDFOREXEC
2018-11-12 13:51:55,196 : DEBUG : main : NodeContainer : : : SSH Connection 12:331 has new state: CONFIGURED_QUEUED
2018-11-12 13:51:55,197 : DEBUG : main : NodeContainer : : : List Remote Files 12:332 has new state: CONFIGURED_MARKEDFOREXEC
2018-11-12 13:51:55,197 : DEBUG : main : NodeContainer : : : URI to String 12:335 has new state: CONFIGURED_MARKEDFOREXEC
2018-11-12 13:51:55,197 : DEBUG : main : NodeContainer : : : Rank 12:337 has new state: CONFIGURED_MARKEDFOREXEC
2018-11-12 13:51:55,197 : DEBUG : main : NodeContainer : : : Row Filter 12:336 has new state: CONFIGURED_MARKEDFOREXEC
2018-11-12 13:51:55,197 : DEBUG : main : NodeContainer : : : String to URI 12:358 has new state: CONFIGURED_MARKEDFOREXEC
2018-11-12 13:51:55,197 : DEBUG : main : NodeContainer : : : KNIME Server Connection 12:351 has new state: CONFIGURED_MARKEDFOREXEC
2018-11-12 13:51:55,197 : DEBUG : main : NodeContainer : : : KNIME Server Connection 12:351 has new state: CONFIGURED_QUEUED
2018-11-12 13:51:55,197 : DEBUG : main : NodeContainer : : : Create Directory 12:352 has new state: CONFIGURED_MARKEDFOREXEC
2018-11-12 13:51:55,197 : DEBUG : main : NodeContainer : : : Upload 12:357 has new state: CONFIGURED_MARKEDFOREXEC
2018-11-12 13:51:55,197 : DEBUG : main : NodeContainer : : : SFTP_Connection 12 has new state: EXECUTING
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-193 : WorkflowManager : SSH Connection : 12:331 : SSH Connection 12:331 doBeforePreExecution
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-193 : NodeContainer : SSH Connection : 12:331 : SSH Connection 12:331 has new state: PREEXECUTE
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-193 : WorkflowManager : SSH Connection : 12:331 : SSH Connection 12:331 doBeforeExecution
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-193 : NodeContainer : SSH Connection : 12:331 : SSH Connection 12:331 has new state: EXECUTING
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-193 : WorkflowFileStoreHandlerRepository : SSH Connection : 12:331 : Adding handler 94cde17e-dd5d-4f8a-b47f-8bb3bfa219f3 (SSH Connection 12:331: ) - 1 in total
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-193 : LocalNodeExecutionJob : SSH Connection : 12:331 : SSH Connection 12:331 Start execute
2018-11-12 13:51:55,197 : DEBUG : KNIME-WFM-Parent-Notifier : NodeContainer : : : ROOT has new state: EXECUTING
2018-11-12 13:51:55,197 : INFO : KNIME-Worker-193 : LocalNodeExecutionJob : SSH Connection : 12:331 : SSH Connection 12:331 End execute (0 secs)
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-194 : WorkflowManager : KNIME Server Connection : 12:351 : KNIME Server Connection 12:351 doBeforePreExecution
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-194 : NodeContainer : KNIME Server Connection : 12:351 : KNIME Server Connection 12:351 has new state: PREEXECUTE
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-194 : WorkflowManager : KNIME Server Connection : 12:351 : KNIME Server Connection 12:351 doBeforeExecution
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-194 : NodeContainer : KNIME Server Connection : 12:351 : KNIME Server Connection 12:351 has new state: EXECUTING
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-194 : WorkflowFileStoreHandlerRepository : KNIME Server Connection : 12:351 : Adding handler 3f66a8cb-e0bf-4c59-869c-cf1b30041ff6 (KNIME Server Connection 12:351: ) - 2 in total
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-194 : LocalNodeExecutionJob : KNIME Server Connection : 12:351 : KNIME Server Connection 12:351 Start execute
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-193 : WorkflowManager : SSH Connection : 12:331 : SSH Connection 12:331 doBeforePostExecution
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-193 : NodeContainer : SSH Connection : 12:331 : SSH Connection 12:331 has new state: POSTEXECUTE
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-193 : WorkflowManager : SSH Connection : 12:331 : SSH Connection 12:331 doAfterExecute - success
2018-11-12 13:51:55,197 : DEBUG : KNIME-Worker-193 : NodeContainer : SSH Connection : 12:331 : SSH Connection 12:331 has new state: EXECUTED
2018-11-12 13:51:55,197 : INFO : KNIME-Worker-194 : LocalNodeExecutionJob : KNIME Server Connection : 12:351 : KNIME Server Connection 12:351 End execute (0 secs)
2018-11-12 13:51:55,198 : DEBUG : KNIME-Worker-193 : Node : List Remote Files : 12:332 : Configure succeeded. (List Remote Files)
2018-11-12 13:51:55,198 : DEBUG : KNIME-Worker-193 : NodeContainer : SSH Connection : 12:331 : List Remote Files 12:332 has new state: CONFIGURED_QUEUED
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-194 : WorkflowManager : KNIME Server Connection : 12:351 : KNIME Server Connection 12:351 doBeforePostExecution
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-194 : NodeContainer : KNIME Server Connection : 12:351 : KNIME Server Connection 12:351 has new state: POSTEXECUTE
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-194 : WorkflowManager : KNIME Server Connection : 12:351 : KNIME Server Connection 12:351 doAfterExecute - success
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-194 : NodeContainer : KNIME Server Connection : 12:351 : KNIME Server Connection 12:351 has new state: EXECUTED
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-194 : Node : Create Directory : 12:352 : Configure succeeded. (Create Directory)
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-194 : NodeContainer : KNIME Server Connection : 12:351 : Create Directory 12:352 has new state: CONFIGURED_QUEUED
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-194 : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-195 : WorkflowManager : List Remote Files : 12:332 : List Remote Files 12:332 doBeforePreExecution
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-195 : NodeContainer : List Remote Files : 12:332 : List Remote Files 12:332 has new state: PREEXECUTE
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-195 : WorkflowManager : List Remote Files : 12:332 : List Remote Files 12:332 doBeforeExecution
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-195 : NodeContainer : List Remote Files : 12:332 : List Remote Files 12:332 has new state: EXECUTING
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-195 : WorkflowFileStoreHandlerRepository : List Remote Files : 12:332 : Adding handler 0287c686-7fc5-4330-90d6-4478365809f9 (List Remote Files 12:332: ) - 3 in total
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-195 : LocalNodeExecutionJob : List Remote Files : 12:332 : List Remote Files 12:332 Start execute
2018-11-12 13:51:55,199 : DEBUG : KNIME-Worker-196 : WorkflowManager : Create Directory : 12:352 : Create Directory 12:352 doBeforePreExecution
2018-11-12 13:51:55,200 : DEBUG : KNIME-Worker-196 : NodeContainer : Create Directory : 12:352 : Create Directory 12:352 has new state: PREEXECUTE
2018-11-12 13:51:55,200 : DEBUG : KNIME-Worker-196 : WorkflowManager : Create Directory : 12:352 : Create Directory 12:352 doBeforeExecution
2018-11-12 13:51:55,200 : DEBUG : KNIME-Worker-196 : NodeContainer : Create Directory : 12:352 : Create Directory 12:352 has new state: EXECUTING
2018-11-12 13:51:55,200 : DEBUG : KNIME-Worker-196 : WorkflowFileStoreHandlerRepository : Create Directory : 12:352 : Adding handler 2593b024-4af0-46ae-a2ed-c4be1c7a0c9b (Create Directory 12:352: ) - 4 in total
2018-11-12 13:51:55,200 : DEBUG : KNIME-Worker-196 : LocalNodeExecutionJob : Create Directory : 12:352 : Create Directory 12:352 Start execute
2018-11-12 13:51:55,325 : INFO : KNIME-Worker-196 : LocalNodeExecutionJob : Create Directory : 12:352 : Create Directory 12:352 End execute (0 secs)
2018-11-12 13:51:55,325 : DEBUG : KNIME-Worker-196 : WorkflowManager : Create Directory : 12:352 : Create Directory 12:352 doBeforePostExecution
2018-11-12 13:51:55,325 : DEBUG : KNIME-Worker-196 : NodeContainer : Create Directory : 12:352 : Create Directory 12:352 has new state: POSTEXECUTE
2018-11-12 13:51:55,325 : DEBUG : KNIME-Worker-196 : WorkflowManager : Create Directory : 12:352 : Create Directory 12:352 doAfterExecute - success
2018-11-12 13:51:55,325 : DEBUG : KNIME-Worker-196 : NodeContainer : Create Directory : 12:352 : Create Directory 12:352 has new state: EXECUTED
2018-11-12 13:51:55,326 : DEBUG : KNIME-Worker-196 : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:55,469 : DEBUG : KNIME-Worker-195 : Buffer : List Remote Files : 12:332 : Using table format org.knime.core.data.container.DefaultTableStoreFormat
2018-11-12 13:51:55,470 : INFO : KNIME-Worker-195 : LocalNodeExecutionJob : List Remote Files : 12:332 : List Remote Files 12:332 End execute (0 secs)
2018-11-12 13:51:55,470 : DEBUG : KNIME-Worker-195 : WorkflowManager : List Remote Files : 12:332 : List Remote Files 12:332 doBeforePostExecution
2018-11-12 13:51:55,471 : DEBUG : KNIME-Worker-195 : NodeContainer : List Remote Files : 12:332 : List Remote Files 12:332 has new state: POSTEXECUTE
2018-11-12 13:51:55,471 : DEBUG : KNIME-Worker-195 : WorkflowManager : List Remote Files : 12:332 : List Remote Files 12:332 doAfterExecute - success
2018-11-12 13:51:55,471 : DEBUG : KNIME-Worker-195 : NodeContainer : List Remote Files : 12:332 : List Remote Files 12:332 has new state: EXECUTED
2018-11-12 13:51:55,473 : DEBUG : KNIME-Worker-195 : Node : URI to String : 12:335 : Configure succeeded. (URI to String)
2018-11-12 13:51:55,473 : DEBUG : KNIME-Worker-195 : NodeContainer : List Remote Files : 12:332 : URI to String 12:335 has new state: CONFIGURED_QUEUED
2018-11-12 13:51:55,474 : DEBUG : KNIME-Worker-195 : Node : Rank : 12:337 : Configure succeeded. (Rank)
2018-11-12 13:51:55,474 : DEBUG : KNIME-Worker-195 : Node : Row Filter : 12:336 : Configure succeeded. (Row Filter)
2018-11-12 13:51:55,474 : DEBUG : KNIME-Worker-195 : Node : String to URI : 12:358 : Configure succeeded. (String to URI)
2018-11-12 13:51:55,474 : DEBUG : KNIME-Worker-195 : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:55,474 : DEBUG : KNIME-Worker-197 : WorkflowManager : URI to String : 12:335 : URI to String 12:335 doBeforePreExecution
2018-11-12 13:51:55,474 : DEBUG : KNIME-Worker-197 : NodeContainer : URI to String : 12:335 : URI to String 12:335 has new state: PREEXECUTE
2018-11-12 13:51:55,474 : DEBUG : KNIME-Worker-197 : WorkflowManager : URI to String : 12:335 : URI to String 12:335 doBeforeExecution
2018-11-12 13:51:55,474 : DEBUG : KNIME-Worker-197 : NodeContainer : URI to String : 12:335 : URI to String 12:335 has new state: EXECUTING
2018-11-12 13:51:55,475 : DEBUG : KNIME-Worker-197 : WorkflowFileStoreHandlerRepository : URI to String : 12:335 : Adding handler c452ac18-0bb6-4c17-9554-ca031ec9630d (URI to String 12:335: ) - 5 in total
2018-11-12 13:51:55,475 : DEBUG : KNIME-Worker-197 : LocalNodeExecutionJob : URI to String : 12:335 : URI to String 12:335 Start execute
2018-11-12 13:51:55,475 : DEBUG : KNIME-Worker-197 : Buffer : URI to String : 12:335 : Using table format org.knime.core.data.container.DefaultTableStoreFormat
2018-11-12 13:51:55,476 : INFO : KNIME-Worker-197 : LocalNodeExecutionJob : URI to String : 12:335 : URI to String 12:335 End execute (0 secs)
2018-11-12 13:51:55,477 : DEBUG : KNIME-Worker-197 : WorkflowManager : URI to String : 12:335 : URI to String 12:335 doBeforePostExecution
2018-11-12 13:51:55,477 : DEBUG : KNIME-Worker-197 : NodeContainer : URI to String : 12:335 : URI to String 12:335 has new state: POSTEXECUTE
2018-11-12 13:51:55,477 : DEBUG : KNIME-Worker-197 : WorkflowManager : URI to String : 12:335 : URI to String 12:335 doAfterExecute - success
2018-11-12 13:51:55,477 : DEBUG : KNIME-Worker-197 : NodeContainer : URI to String : 12:335 : URI to String 12:335 has new state: EXECUTED
2018-11-12 13:51:55,479 : DEBUG : KNIME-Worker-197 : Node : Rank : 12:337 : Configure succeeded. (Rank)
2018-11-12 13:51:55,479 : DEBUG : KNIME-Worker-197 : NodeContainer : URI to String : 12:335 : Rank 12:337 has new state: CONFIGURED_QUEUED
2018-11-12 13:51:55,482 : DEBUG : KNIME-Worker-197 : Node : Row Filter : 12:336 : Configure succeeded. (Row Filter)
2018-11-12 13:51:55,482 : DEBUG : KNIME-Worker-197 : Node : String to URI : 12:358 : Configure succeeded. (String to URI)
2018-11-12 13:51:55,482 : DEBUG : KNIME-Worker-197 : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:55,482 : DEBUG : KNIME-Worker-198 : WorkflowManager : Rank : 12:337 : Rank 12:337 doBeforePreExecution
2018-11-12 13:51:55,482 : DEBUG : KNIME-Worker-198 : NodeContainer : Rank : 12:337 : Rank 12:337 has new state: PREEXECUTE
2018-11-12 13:51:55,482 : DEBUG : KNIME-Worker-198 : WorkflowManager : Rank : 12:337 : Rank 12:337 doBeforeExecution
2018-11-12 13:51:55,482 : DEBUG : KNIME-Worker-198 : NodeContainer : Rank : 12:337 : Rank 12:337 has new state: EXECUTING
2018-11-12 13:51:55,482 : DEBUG : KNIME-Worker-198 : WorkflowFileStoreHandlerRepository : Rank : 12:337 : Adding handler 6b34bf6c-e155-452d-b050-a7519b35bef5 (Rank 12:337: ) - 6 in total
2018-11-12 13:51:55,482 : DEBUG : KNIME-Worker-198 : LocalNodeExecutionJob : Rank : 12:337 : Rank 12:337 Start execute
2018-11-12 13:51:55,484 : DEBUG : KNIME-Worker-198 : Buffer : Rank : 12:337 : Using table format org.knime.core.data.container.DefaultTableStoreFormat
2018-11-12 13:51:55,485 : DEBUG : KNIME-Worker-198 : Buffer : Rank : 12:337 : Using table format org.knime.core.data.container.DefaultTableStoreFormat
2018-11-12 13:51:55,488 : INFO : KNIME-Worker-198 : LocalNodeExecutionJob : Rank : 12:337 : Rank 12:337 End execute (0 secs)
2018-11-12 13:51:55,488 : DEBUG : KNIME-Worker-198 : WorkflowManager : Rank : 12:337 : Rank 12:337 doBeforePostExecution
2018-11-12 13:51:55,488 : DEBUG : KNIME-Worker-198 : NodeContainer : Rank : 12:337 : Rank 12:337 has new state: POSTEXECUTE
2018-11-12 13:51:55,488 : DEBUG : KNIME-Worker-198 : WorkflowManager : Rank : 12:337 : Rank 12:337 doAfterExecute - success
2018-11-12 13:51:55,488 : DEBUG : KNIME-Worker-198 : NodeContainer : Rank : 12:337 : Rank 12:337 has new state: EXECUTED
2018-11-12 13:51:55,489 : DEBUG : KNIME-Worker-198 : Node : Row Filter : 12:336 : Configure succeeded. (Row Filter)
2018-11-12 13:51:55,489 : DEBUG : KNIME-Worker-198 : NodeContainer : Rank : 12:337 : Row Filter 12:336 has new state: CONFIGURED_QUEUED
2018-11-12 13:51:55,490 : DEBUG : KNIME-Worker-198 : Node : String to URI : 12:358 : Configure succeeded. (String to URI)
2018-11-12 13:51:55,490 : DEBUG : KNIME-Worker-198 : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:55,490 : DEBUG : KNIME-Worker-199 : WorkflowManager : Row Filter : 12:336 : Row Filter 12:336 doBeforePreExecution
2018-11-12 13:51:55,491 : DEBUG : KNIME-Worker-199 : NodeContainer : Row Filter : 12:336 : Row Filter 12:336 has new state: PREEXECUTE
2018-11-12 13:51:55,491 : DEBUG : KNIME-Worker-199 : WorkflowManager : Row Filter : 12:336 : Row Filter 12:336 doBeforeExecution
2018-11-12 13:51:55,491 : DEBUG : KNIME-Worker-199 : NodeContainer : Row Filter : 12:336 : Row Filter 12:336 has new state: EXECUTING
2018-11-12 13:51:55,491 : DEBUG : KNIME-Worker-199 : WorkflowFileStoreHandlerRepository : Row Filter : 12:336 : Adding handler 99ebcb6d-e5de-4d64-84c9-3412540fc3e5 (Row Filter 12:336: ) - 7 in total
2018-11-12 13:51:55,491 : DEBUG : KNIME-Worker-199 : LocalNodeExecutionJob : Row Filter : 12:336 : Row Filter 12:336 Start execute
2018-11-12 13:51:55,493 : DEBUG : KNIME-Worker-199 : Buffer : Row Filter : 12:336 : Using table format org.knime.core.data.container.DefaultTableStoreFormat
2018-11-12 13:51:55,493 : INFO : KNIME-Worker-199 : LocalNodeExecutionJob : Row Filter : 12:336 : Row Filter 12:336 End execute (0 secs)
2018-11-12 13:51:55,493 : DEBUG : KNIME-Worker-199 : WorkflowManager : Row Filter : 12:336 : Row Filter 12:336 doBeforePostExecution
2018-11-12 13:51:55,493 : DEBUG : KNIME-Worker-199 : NodeContainer : Row Filter : 12:336 : Row Filter 12:336 has new state: POSTEXECUTE
2018-11-12 13:51:55,493 : DEBUG : KNIME-Worker-199 : WorkflowManager : Row Filter : 12:336 : Row Filter 12:336 doAfterExecute - success
2018-11-12 13:51:55,493 : DEBUG : KNIME-Worker-199 : NodeContainer : Row Filter : 12:336 : Row Filter 12:336 has new state: EXECUTED
2018-11-12 13:51:55,494 : DEBUG : KNIME-Worker-199 : Node : String to URI : 12:358 : Configure succeeded. (String to URI)
2018-11-12 13:51:55,494 : DEBUG : KNIME-Worker-199 : NodeContainer : Row Filter : 12:336 : String to URI 12:358 has new state: CONFIGURED_QUEUED
2018-11-12 13:51:55,496 : DEBUG : KNIME-Worker-200 : WorkflowManager : String to URI : 12:358 : String to URI 12:358 doBeforePreExecution
2018-11-12 13:51:55,496 : DEBUG : KNIME-Worker-200 : NodeContainer : String to URI : 12:358 : String to URI 12:358 has new state: PREEXECUTE
2018-11-12 13:51:55,496 : DEBUG : KNIME-Worker-200 : WorkflowManager : String to URI : 12:358 : String to URI 12:358 doBeforeExecution
2018-11-12 13:51:55,496 : DEBUG : KNIME-Worker-200 : NodeContainer : String to URI : 12:358 : String to URI 12:358 has new state: EXECUTING
2018-11-12 13:51:55,496 : DEBUG : KNIME-Worker-200 : WorkflowFileStoreHandlerRepository : String to URI : 12:358 : Adding handler 5902e042-dcd6-4085-92a2-142ae738f9cc (String to URI 12:358: ) - 8 in total
2018-11-12 13:51:55,496 : DEBUG : KNIME-Worker-200 : LocalNodeExecutionJob : String to URI : 12:358 : String to URI 12:358 Start execute
2018-11-12 13:51:55,497 : DEBUG : KNIME-Worker-200 : Buffer : String to URI : 12:358 : Using table format org.knime.core.data.container.DefaultTableStoreFormat
2018-11-12 13:51:55,498 : INFO : KNIME-Worker-200 : LocalNodeExecutionJob : String to URI : 12:358 : String to URI 12:358 End execute (0 secs)
2018-11-12 13:51:55,498 : DEBUG : KNIME-Worker-200 : WorkflowManager : String to URI : 12:358 : String to URI 12:358 doBeforePostExecution
2018-11-12 13:51:55,498 : DEBUG : KNIME-Worker-200 : NodeContainer : String to URI : 12:358 : String to URI 12:358 has new state: POSTEXECUTE
2018-11-12 13:51:55,498 : DEBUG : KNIME-Worker-200 : WorkflowManager : String to URI : 12:358 : String to URI 12:358 doAfterExecute - success
2018-11-12 13:51:55,498 : DEBUG : KNIME-Worker-200 : NodeContainer : String to URI : 12:358 : String to URI 12:358 has new state: EXECUTED
2018-11-12 13:51:55,500 : DEBUG : KNIME-Worker-200 : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:55,500 : DEBUG : KNIME-Worker-200 : NodeContainer : String to URI : 12:358 : Upload 12:357 has new state: CONFIGURED_QUEUED
2018-11-12 13:51:55,501 : DEBUG : KNIME-Worker-201 : WorkflowManager : Upload : 12:357 : Upload 12:357 doBeforePreExecution
2018-11-12 13:51:55,501 : DEBUG : KNIME-Worker-201 : NodeContainer : Upload : 12:357 : Upload 12:357 has new state: PREEXECUTE
2018-11-12 13:51:55,501 : DEBUG : KNIME-Worker-201 : WorkflowManager : Upload : 12:357 : Upload 12:357 doBeforeExecution
2018-11-12 13:51:55,501 : DEBUG : KNIME-Worker-201 : NodeContainer : Upload : 12:357 : Upload 12:357 has new state: EXECUTING
2018-11-12 13:51:55,501 : DEBUG : KNIME-Worker-201 : WorkflowFileStoreHandlerRepository : Upload : 12:357 : Adding handler 460dabe6-924a-49ff-9741-10da246bdc0a (Upload 12:357: ) - 9 in total
2018-11-12 13:51:55,501 : DEBUG : KNIME-Worker-201 : LocalNodeExecutionJob : Upload : 12:357 : Upload 12:357 Start execute
2018-11-12 13:51:55,625 : DEBUG : KNIME-Worker-201 : Buffer : Upload : 12:357 : Using table format org.knime.core.data.container.DefaultTableStoreFormat
2018-11-12 13:51:55,625 : DEBUG : KNIME-Worker-201 : Node : Upload : 12:357 : reset
2018-11-12 13:51:55,626 : ERROR : KNIME-Worker-201 : Node : Upload : 12:357 : Execute failed: Connection information must not be null
2018-11-12 13:51:55,626 : DEBUG : KNIME-Worker-201 : Node : Upload : 12:357 : Execute failed: Connection information must not be null
java.lang.IllegalArgumentException: Connection information must not be null
at org.knime.core.node.util.CheckUtils.checkArgument(CheckUtils.java:255)
at org.knime.core.node.util.CheckUtils.checkArgumentNotNull(CheckUtils.java:242)
at org.knime.core.node.util.CheckUtils.checkArgumentNotNull(CheckUtils.java:91)
at org.knime.base.filehandling.remote.files.SFTPRemoteFile.(SFTPRemoteFile.java:119)
at org.knime.base.filehandling.remote.files.SSHRemoteFileHandler.createRemoteFile(SSHRemoteFileHandler.java:77)
at org.knime.base.filehandling.remote.files.RemoteFileFactory.createRemoteFile(RemoteFileFactory.java:98)
at org.knime.base.filehandling.upload2.UploadNodeModel.execute(UploadNodeModel.java:149)
at org.knime.core.node.NodeModel.executeModel(NodeModel.java:567)
at org.knime.core.node.Node.invokeFullyNodeModelExecute(Node.java:1177)
at org.knime.core.node.Node.execute(Node.java:964)
at org.knime.core.node.workflow.NativeNodeContainer.performExecuteNode(NativeNodeContainer.java:561)
at org.knime.core.node.exec.LocalNodeExecutionJob.mainExecute(LocalNodeExecutionJob.java:95)
at org.knime.core.node.workflow.NodeExecutionJob.internalRun(NodeExecutionJob.java:179)
at org.knime.core.node.workflow.NodeExecutionJob.run(NodeExecutionJob.java:110)
at org.knime.core.util.ThreadUtils$RunnableWithContextImpl.runWithContext(ThreadUtils.java:328)
at org.knime.core.util.ThreadUtils$RunnableWithContext.run(ThreadUtils.java:204)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.knime.core.util.ThreadPool$MyFuture.run(ThreadPool.java:123)
at org.knime.core.util.ThreadPool$Worker.run(ThreadPool.java:246)
2018-11-12 13:51:55,626 : DEBUG : KNIME-Worker-201 : WorkflowManager : Upload : 12:357 : Upload 12:357 doBeforePostExecution
2018-11-12 13:51:55,626 : DEBUG : KNIME-Worker-201 : NodeContainer : Upload : 12:357 : Upload 12:357 has new state: POSTEXECUTE
2018-11-12 13:51:55,627 : DEBUG : KNIME-Worker-201 : WorkflowManager : Upload : 12:357 : Upload 12:357 doAfterExecute - failure
2018-11-12 13:51:55,627 : DEBUG : KNIME-Worker-201 : Node : Upload : 12:357 : reset
2018-11-12 13:51:55,627 : DEBUG : KNIME-Worker-201 : Node : Upload : 12:357 : clean output ports.
2018-11-12 13:51:55,627 : DEBUG : KNIME-Worker-201 : WorkflowFileStoreHandlerRepository : Upload : 12:357 : Removing handler 460dabe6-924a-49ff-9741-10da246bdc0a (Upload 12:357: ) - 8 remaining
2018-11-12 13:51:55,627 : DEBUG : KNIME-Worker-201 : NodeContainer : Upload : 12:357 : Upload 12:357 has new state: IDLE
2018-11-12 13:51:55,628 : DEBUG : KNIME-Worker-201 : Node : Upload : 12:357 : Configure succeeded. (Upload)
2018-11-12 13:51:55,628 : DEBUG : KNIME-Worker-201 : NodeContainer : Upload : 12:357 : Upload 12:357 has new state: CONFIGURED
2018-11-12 13:51:55,628 : DEBUG : KNIME-Worker-201 : NodeContainer : Upload : 12:357 : SFTP_Connection 12 has new state: CONFIGURED
2018-11-12 13:51:55,628 : DEBUG : KNIME-WFM-Parent-Notifier : NodeContainer : : : ROOT has new state: IDLE
Hi @Kon
The problem is that the connection information for the SSH connection is not available in the Upload node connected to the KNIME Server Connection.
One solution would be to download the files from your SFTP locally to a temporary directory (using the Create Temp Dir node) and then upload the files from there.
Hi @oole,
Thanks for your help.
That would work but I’m looking for a solution that will be automated on the KNIME Server. i.e workflow that extracts data from SFTP, manipulates the data and then loads to DWH or displays a report.
Hi @Kon,
Ole’s suggestion would also work on KNIME Server. The Create Temp Dir node will create a new directory for each execution. You can then use the path of this directory to configure a Download node via flow variable. After that, you read the data into KNIME, transform it, write it to another Temp Dir, and use that path to upload.
Is this something that would work for you?
Cheers,
Roland
