2020-01-15 11:27:03,616 DEBUG NodeContainerEditPart DB Writer 3:23 (IDLE) 2020-01-15 11:27:09,171 DEBUG ExecuteAction Creating execution job for 1 node(s)... 2020-01-15 11:27:09,171 DEBUG NodeContainer DB Connection Parameters Provider 3:3 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,171 DEBUG NodeContainer DB Connection Parameters Provider 3:3 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,171 DEBUG NodeContainer Credentials Configuration 3:4 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,171 DEBUG NodeContainer PostgreSQL Connector 3:5 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,171 DEBUG NodeContainer DB Table Selector 3:10 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,171 DEBUG NodeContainer DB Column Filter 3:12 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,171 DEBUG NodeContainer DB Column Rename 3:16 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,171 DEBUG NodeContainer DB Reader 3:14 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,171 DEBUG NodeContainer DB Table Selector 3:9 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer DB Column Filter 3:11 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer DB Reader 3:13 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer Concatenate 3:15 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer Row Filter 3:17 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer Row Filter 3:22 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer DB Connection Parameters Provider 3:8 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer DB Connection Parameters Provider 3:8 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,172 DEBUG NodeContainer Credentials Configuration 3:7 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer Table Row To Variable Loop Start 3:18 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer PostgreSQL Connector 3:6 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer DB Table Selector 3:20 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer DB Reader 3:21 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer DB Connection Parameters Provider 3:0 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer DB Connection Parameters Provider 3:0 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,172 DEBUG NodeContainer Credentials Configuration 3:2 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer Microsoft SQL Server Connector 3:1 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer DB Writer 3:23 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,172 DEBUG NodeContainer DWH to MS SQL 3 has new state: EXECUTING 2020-01-15 11:27:09,172 DEBUG NodeContainer ROOT has new state: EXECUTING 2020-01-15 11:27:09,172 DEBUG DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3 doBeforePreExecution 2020-01-15 11:27:09,173 DEBUG DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3 has new state: PREEXECUTE 2020-01-15 11:27:09,173 DEBUG DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8 doBeforePreExecution 2020-01-15 11:27:09,173 DEBUG DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8 has new state: PREEXECUTE 2020-01-15 11:27:09,173 DEBUG DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3 doBeforeExecution 2020-01-15 11:27:09,173 DEBUG DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3 has new state: EXECUTING 2020-01-15 11:27:09,173 DEBUG DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3 Start execute 2020-01-15 11:27:09,173 DEBUG DB Connection Parameters Provider 3:3 Component Input 3:3:0:6 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,173 DEBUG DB Connection Parameters Provider 3:3 Component Input 3:3:0:6 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,173 DEBUG DB Connection Parameters Provider 3:3 String Input 3:3:0:1 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,174 DEBUG DB Connection Parameters Provider 3:3 String Input 3:3:0:1 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,174 DEBUG DB Connection Parameters Provider 3:3 Read Configuration 3:3:0:0 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,174 DEBUG DB Connection Parameters Provider 3:3 Read Configuration 3:3:0:0 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,174 DEBUG DB Connection Parameters Provider 3:3 Merge Variables 3:3:0:5 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,174 DEBUG DB Connection Parameters Provider 3:3 Java Edit Variable 3:3:0:4 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,174 DEBUG DB Connection Parameters Provider 3:3 Component Output 3:3:0:7 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,174 DEBUG DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3:0 has new state: EXECUTING 2020-01-15 11:27:09,174 DEBUG Component Input 3:3:0:6 Component Input 3:3:0:6 doBeforePreExecution 2020-01-15 11:27:09,174 DEBUG Component Input 3:3:0:6 Component Input 3:3:0:6 has new state: PREEXECUTE 2020-01-15 11:27:09,175 DEBUG Component Input 3:3:0:6 Adding handler 07fd611a-3ae9-40c3-8b44-f111641f90c8 (Component Input 3:3:0:6: ) - 1 in total 2020-01-15 11:27:09,175 DEBUG Component Input 3:3:0:6 Component Input 3:3:0:6 doBeforeExecution 2020-01-15 11:27:09,175 DEBUG Component Input 3:3:0:6 Component Input 3:3:0:6 has new state: EXECUTING 2020-01-15 11:27:09,175 DEBUG Component Input 3:3:0:6 Component Input 3:3:0:6 Start execute 2020-01-15 11:27:09,175 INFO Component Input 3:3:0:6 Component Input 3:3:0:6 End execute (0 secs) 2020-01-15 11:27:09,175 DEBUG Component Input 3:3:0:6 Component Input 3:3:0:6 doBeforePostExecution 2020-01-15 11:27:09,175 DEBUG Component Input 3:3:0:6 Component Input 3:3:0:6 has new state: POSTEXECUTE 2020-01-15 11:27:09,175 DEBUG Component Input 3:3:0:6 Component Input 3:3:0:6 doAfterExecute - success 2020-01-15 11:27:09,176 DEBUG Component Input 3:3:0:6 Component Input 3:3:0:6 has new state: EXECUTED 2020-01-15 11:27:09,176 DEBUG String Input 3:3:0:1 String Input 3:3:0:1 doBeforePreExecution 2020-01-15 11:27:09,176 DEBUG String Input 3:3:0:1 String Input 3:3:0:1 has new state: PREEXECUTE 2020-01-15 11:27:09,176 DEBUG String Input 3:3:0:1 Adding handler cf00776b-a1d8-4759-bb27-d212c48ed491 (String Input 3:3:0:1: ) - 2 in total 2020-01-15 11:27:09,176 DEBUG String Input 3:3:0:1 String Input 3:3:0:1 doBeforeExecution 2020-01-15 11:27:09,177 DEBUG String Input 3:3:0:1 String Input 3:3:0:1 has new state: EXECUTING 2020-01-15 11:27:09,177 DEBUG String Input 3:3:0:1 String Input 3:3:0:1 Start execute 2020-01-15 11:27:09,177 INFO String Input 3:3:0:1 String Input 3:3:0:1 End execute (0 secs) 2020-01-15 11:27:09,177 DEBUG String Input 3:3:0:1 String Input 3:3:0:1 doBeforePostExecution 2020-01-15 11:27:09,177 DEBUG String Input 3:3:0:1 String Input 3:3:0:1 has new state: POSTEXECUTE 2020-01-15 11:27:09,177 DEBUG String Input 3:3:0:1 String Input 3:3:0:1 doAfterExecute - success 2020-01-15 11:27:09,177 DEBUG String Input 3:3:0:1 String Input 3:3:0:1 has new state: EXECUTED 2020-01-15 11:27:09,178 DEBUG Read Configuration 3:3:0:0 Read Configuration 3:3:0:0 doBeforePreExecution 2020-01-15 11:27:09,178 DEBUG Read Configuration 3:3:0:0 Read Configuration 3:3:0:0 has new state: PREEXECUTE 2020-01-15 11:27:09,179 DEBUG Read Configuration 3:3:0:0 Read Configuration 3:3:0:0 doBeforeExecution 2020-01-15 11:27:09,179 DEBUG Read Configuration 3:3:0:0 Read Configuration 3:3:0:0 has new state: EXECUTING 2020-01-15 11:27:09,180 DEBUG DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0 doBeforePreExecution 2020-01-15 11:27:09,180 DEBUG DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0 has new state: PREEXECUTE 2020-01-15 11:27:09,180 DEBUG Read Configuration 3:3:0:0 Read Configuration 3:3:0:0 Start execute 2020-01-15 11:27:09,180 DEBUG Read Configuration 3:3:0:0 File Chooser 3:3:0:0:0:10 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,180 DEBUG Read Configuration 3:3:0:0 File Chooser 3:3:0:0:0:10 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,181 DEBUG Read Configuration 3:3:0:0 Get Home Directory 3:3:0:0:0:0 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,181 DEBUG Read Configuration 3:3:0:0 Get Home Directory 3:3:0:0:0:0 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,181 DEBUG Read Configuration 3:3:0:0 String Manipulation (Variable) 3:3:0:0:0:15 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,181 DEBUG Read Configuration 3:3:0:0 File Reader 3:3:0:0:0:1 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,181 DEBUG Read Configuration 3:3:0:0 Regex Split 3:3:0:0:0:2 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,181 DEBUG Read Configuration 3:3:0:0 Column Filter 3:3:0:0:0:3 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,181 DEBUG Read Configuration 3:3:0:0 Column Rename 3:3:0:0:0:8 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,182 DEBUG Read Configuration 3:3:0:0 Pivoting 3:3:0:0:0:6 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,182 DEBUG Read Configuration 3:3:0:0 Column Rename (Regex) 3:3:0:0:0:9 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,182 DEBUG Read Configuration 3:3:0:0 Table Row to Variable (deprecated) 3:3:0:0:0:7 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,182 DEBUG Read Configuration 3:3:0:0 Component Output 3:3:0:0:0:14 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,182 DEBUG Read Configuration 3:3:0:0 Component Input 3:3:0:0:0:13 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,182 DEBUG Read Configuration 3:3:0:0 Component Input 3:3:0:0:0:13 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,182 DEBUG Read Configuration 3:3:0:0 Read Configuration 3:3:0:0:0 has new state: EXECUTING 2020-01-15 11:27:09,182 DEBUG DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8 doBeforeExecution 2020-01-15 11:27:09,182 DEBUG DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8 has new state: EXECUTING 2020-01-15 11:27:09,183 DEBUG DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8 Start execute 2020-01-15 11:27:09,183 DEBUG DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0 doBeforeExecution 2020-01-15 11:27:09,183 DEBUG DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0 has new state: EXECUTING 2020-01-15 11:27:09,183 DEBUG DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0 Start execute 2020-01-15 11:27:09,183 DEBUG File Chooser 3:3:0:0:0:10 File Chooser 3:3:0:0:0:10 doBeforePreExecution 2020-01-15 11:27:09,183 DEBUG File Chooser 3:3:0:0:0:10 File Chooser 3:3:0:0:0:10 has new state: PREEXECUTE 2020-01-15 11:27:09,183 DEBUG Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0 doBeforePreExecution 2020-01-15 11:27:09,183 DEBUG File Chooser 3:3:0:0:0:10 Adding handler 987a23ef-c07d-4a24-a34d-f52ce35ca6d2 (File Chooser 3:3:0:0:0:10: ) - 3 in total 2020-01-15 11:27:09,183 DEBUG Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0 has new state: PREEXECUTE 2020-01-15 11:27:09,183 DEBUG Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0 doBeforeExecution 2020-01-15 11:27:09,183 DEBUG Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0 has new state: EXECUTING 2020-01-15 11:27:09,183 DEBUG Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0 Start execute 2020-01-15 11:27:09,183 DEBUG Component Input 3:3:0:0:0:13 Component Input 3:3:0:0:0:13 doBeforePreExecution 2020-01-15 11:27:09,183 DEBUG Component Input 3:3:0:0:0:13 Component Input 3:3:0:0:0:13 has new state: PREEXECUTE 2020-01-15 11:27:09,184 DEBUG Component Input 3:3:0:0:0:13 Adding handler 4680105b-c6ad-48b2-9cab-cea2c1df5524 (Component Input 3:3:0:0:0:13: ) - 4 in total 2020-01-15 11:27:09,184 DEBUG DB Connection Parameters Provider 3:8 String Input 3:8:0:1 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,184 DEBUG DB Connection Parameters Provider 3:8 String Input 3:8:0:1 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,184 DEBUG DB Connection Parameters Provider 3:8 Read Configuration 3:8:0:0 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,184 DEBUG DB Connection Parameters Provider 3:8 Read Configuration 3:8:0:0 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,184 DEBUG DB Connection Parameters Provider 3:8 Merge Variables 3:8:0:5 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,184 DEBUG DB Connection Parameters Provider 3:8 Java Edit Variable 3:8:0:4 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,184 DEBUG DB Connection Parameters Provider 3:8 Component Output 3:8:0:7 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,184 DEBUG DB Connection Parameters Provider 3:8 Component Input 3:8:0:6 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,184 DEBUG DB Connection Parameters Provider 3:8 Component Input 3:8:0:6 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,185 DEBUG DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8:0 has new state: EXECUTING 2020-01-15 11:27:09,185 DEBUG DB Connection Parameters Provider 3:0 String Input 3:0:0:1 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,185 DEBUG DB Connection Parameters Provider 3:0 String Input 3:0:0:1 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,185 DEBUG DB Connection Parameters Provider 3:0 Read Configuration 3:0:0:0 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,185 DEBUG DB Connection Parameters Provider 3:0 Read Configuration 3:0:0:0 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,185 DEBUG DB Connection Parameters Provider 3:0 Merge Variables 3:0:0:5 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,185 DEBUG DB Connection Parameters Provider 3:0 Java Edit Variable 3:0:0:4 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,185 DEBUG DB Connection Parameters Provider 3:0 Component Output 3:0:0:7 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,186 DEBUG DB Connection Parameters Provider 3:0 Component Input 3:0:0:6 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,186 DEBUG DB Connection Parameters Provider 3:0 Component Input 3:0:0:6 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,186 DEBUG DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0:0 has new state: EXECUTING 2020-01-15 11:27:09,186 DEBUG File Chooser 3:3:0:0:0:10 File Chooser 3:3:0:0:0:10 doBeforeExecution 2020-01-15 11:27:09,186 DEBUG File Chooser 3:3:0:0:0:10 File Chooser 3:3:0:0:0:10 has new state: EXECUTING 2020-01-15 11:27:09,186 DEBUG File Chooser 3:3:0:0:0:10 File Chooser 3:3:0:0:0:10 Start execute 2020-01-15 11:27:09,186 DEBUG Get Home Directory 3:3:0:0:0:0 Component Input 3:3:0:0:0:0:0:6 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,186 DEBUG Get Home Directory 3:3:0:0:0:0 Component Input 3:3:0:0:0:0:0:6 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,186 DEBUG Get Home Directory 3:3:0:0:0:0 Java Edit Variable 3:3:0:0:0:0:0:5 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,186 DEBUG Get Home Directory 3:3:0:0:0:0 Component Output 3:3:0:0:0:0:0:7 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,187 DEBUG Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0:0 has new state: EXECUTING 2020-01-15 11:27:09,187 DEBUG Component Input 3:3:0:0:0:13 Component Input 3:3:0:0:0:13 doBeforeExecution 2020-01-15 11:27:09,187 DEBUG Component Input 3:3:0:0:0:13 Component Input 3:3:0:0:0:13 has new state: EXECUTING 2020-01-15 11:27:09,187 DEBUG File Chooser 3:3:0:0:0:10 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,187 DEBUG Component Input 3:3:0:0:0:13 Component Input 3:3:0:0:0:13 Start execute 2020-01-15 11:27:09,187 DEBUG String Input 3:8:0:1 String Input 3:8:0:1 doBeforePreExecution 2020-01-15 11:27:09,187 DEBUG String Input 3:8:0:1 String Input 3:8:0:1 has new state: PREEXECUTE 2020-01-15 11:27:09,187 DEBUG Component Input 3:3:0:0:0:0:0:6 Component Input 3:3:0:0:0:0:0:6 doBeforePreExecution 2020-01-15 11:27:09,188 DEBUG Component Input 3:3:0:0:0:0:0:6 Component Input 3:3:0:0:0:0:0:6 has new state: PREEXECUTE 2020-01-15 11:27:09,187 DEBUG String Input 3:8:0:1 Adding handler 5b93c352-1d6f-4a6b-a848-243c6a2f9121 (String Input 3:8:0:1: ) - 5 in total 2020-01-15 11:27:09,188 DEBUG Component Input 3:3:0:0:0:0:0:6 Adding handler b57ec863-2977-4834-a415-46350eec8a3e (Component Input 3:3:0:0:0:0:0:6: ) - 6 in total 2020-01-15 11:27:09,188 INFO File Chooser 3:3:0:0:0:10 File Chooser 3:3:0:0:0:10 End execute (0 secs) 2020-01-15 11:27:09,188 DEBUG Read Configuration 3:8:0:0 Read Configuration 3:8:0:0 doBeforePreExecution 2020-01-15 11:27:09,189 DEBUG Read Configuration 3:8:0:0 Read Configuration 3:8:0:0 has new state: PREEXECUTE 2020-01-15 11:27:09,189 DEBUG Component Input 3:8:0:6 Component Input 3:8:0:6 doBeforePreExecution 2020-01-15 11:27:09,189 DEBUG Component Input 3:8:0:6 Component Input 3:8:0:6 has new state: PREEXECUTE 2020-01-15 11:27:09,189 DEBUG String Input 3:0:0:1 String Input 3:0:0:1 doBeforePreExecution 2020-01-15 11:27:09,189 DEBUG Component Input 3:8:0:6 Adding handler aa9e01a4-676b-4ede-ab13-c819967d6c6c (Component Input 3:8:0:6: ) - 7 in total 2020-01-15 11:27:09,189 DEBUG String Input 3:0:0:1 String Input 3:0:0:1 has new state: PREEXECUTE 2020-01-15 11:27:09,189 DEBUG Read Configuration 3:0:0:0 Read Configuration 3:0:0:0 doBeforePreExecution 2020-01-15 11:27:09,189 DEBUG String Input 3:0:0:1 Adding handler a3c901c7-760c-40a5-ba7e-3169201bb2eb (String Input 3:0:0:1: ) - 8 in total 2020-01-15 11:27:09,189 DEBUG Read Configuration 3:0:0:0 Read Configuration 3:0:0:0 has new state: PREEXECUTE 2020-01-15 11:27:09,189 DEBUG Read Configuration 3:0:0:0 Read Configuration 3:0:0:0 doBeforeExecution 2020-01-15 11:27:09,189 DEBUG Read Configuration 3:0:0:0 Read Configuration 3:0:0:0 has new state: EXECUTING 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 Read Configuration 3:0:0:0 Start execute 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 File Chooser 3:0:0:0:0:10 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 File Chooser 3:0:0:0:0:10 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 Component Input 3:0:0:0:0:13 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 Component Input 3:0:0:0:0:13 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 Get Home Directory 3:0:0:0:0:0 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 Get Home Directory 3:0:0:0:0:0 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 String Manipulation (Variable) 3:0:0:0:0:15 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 File Reader 3:0:0:0:0:1 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 Regex Split 3:0:0:0:0:2 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 Column Filter 3:0:0:0:0:3 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 Column Rename 3:0:0:0:0:8 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 Pivoting 3:0:0:0:0:6 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,190 DEBUG Read Configuration 3:0:0:0 Column Rename (Regex) 3:0:0:0:0:9 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,191 DEBUG Read Configuration 3:0:0:0 Table Row to Variable (deprecated) 3:0:0:0:0:7 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,191 DEBUG Read Configuration 3:0:0:0 Component Output 3:0:0:0:0:14 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,191 DEBUG Read Configuration 3:0:0:0 Read Configuration 3:0:0:0:0 has new state: EXECUTING 2020-01-15 11:27:09,191 DEBUG Component Input 3:0:0:6 Component Input 3:0:0:6 doBeforePreExecution 2020-01-15 11:27:09,191 DEBUG Component Input 3:0:0:6 Component Input 3:0:0:6 has new state: PREEXECUTE 2020-01-15 11:27:09,191 DEBUG String Input 3:8:0:1 String Input 3:8:0:1 doBeforeExecution 2020-01-15 11:27:09,191 DEBUG Component Input 3:0:0:6 Adding handler 4e3e809d-9e3d-4041-8f42-4c8770adf7c8 (Component Input 3:0:0:6: ) - 9 in total 2020-01-15 11:27:09,191 DEBUG String Input 3:8:0:1 String Input 3:8:0:1 has new state: EXECUTING 2020-01-15 11:27:09,191 DEBUG String Input 3:8:0:1 String Input 3:8:0:1 Start execute 2020-01-15 11:27:09,191 DEBUG Component Input 3:3:0:0:0:0:0:6 Component Input 3:3:0:0:0:0:0:6 doBeforeExecution 2020-01-15 11:27:09,191 DEBUG Component Input 3:3:0:0:0:0:0:6 Component Input 3:3:0:0:0:0:0:6 has new state: EXECUTING 2020-01-15 11:27:09,191 INFO String Input 3:8:0:1 String Input 3:8:0:1 End execute (0 secs) 2020-01-15 11:27:09,192 DEBUG Component Input 3:3:0:0:0:0:0:6 Component Input 3:3:0:0:0:0:0:6 Start execute 2020-01-15 11:27:09,192 DEBUG File Chooser 3:3:0:0:0:10 File Chooser 3:3:0:0:0:10 doBeforePostExecution 2020-01-15 11:27:09,192 DEBUG File Chooser 3:3:0:0:0:10 File Chooser 3:3:0:0:0:10 has new state: POSTEXECUTE 2020-01-15 11:27:09,192 DEBUG File Chooser 3:3:0:0:0:10 File Chooser 3:3:0:0:0:10 doAfterExecute - success 2020-01-15 11:27:09,192 DEBUG File Chooser 3:3:0:0:0:10 File Chooser 3:3:0:0:0:10 has new state: EXECUTED 2020-01-15 11:27:09,192 DEBUG Read Configuration 3:8:0:0 Read Configuration 3:8:0:0 doBeforeExecution 2020-01-15 11:27:09,192 DEBUG Read Configuration 3:8:0:0 Read Configuration 3:8:0:0 has new state: EXECUTING 2020-01-15 11:27:09,192 DEBUG Read Configuration 3:8:0:0 Read Configuration 3:8:0:0 Start execute 2020-01-15 11:27:09,192 DEBUG Component Input 3:8:0:6 Component Input 3:8:0:6 doBeforeExecution 2020-01-15 11:27:09,192 DEBUG Component Input 3:8:0:6 Component Input 3:8:0:6 has new state: EXECUTING 2020-01-15 11:27:09,192 DEBUG Component Input 3:8:0:6 Component Input 3:8:0:6 Start execute 2020-01-15 11:27:09,192 DEBUG String Input 3:0:0:1 String Input 3:0:0:1 doBeforeExecution 2020-01-15 11:27:09,193 DEBUG String Input 3:0:0:1 String Input 3:0:0:1 has new state: EXECUTING 2020-01-15 11:27:09,193 DEBUG String Input 3:0:0:1 String Input 3:0:0:1 Start execute 2020-01-15 11:27:09,193 DEBUG File Chooser 3:0:0:0:0:10 File Chooser 3:0:0:0:0:10 doBeforePreExecution 2020-01-15 11:27:09,193 DEBUG File Chooser 3:0:0:0:0:10 File Chooser 3:0:0:0:0:10 has new state: PREEXECUTE 2020-01-15 11:27:09,193 INFO String Input 3:0:0:1 String Input 3:0:0:1 End execute (0 secs) 2020-01-15 11:27:09,193 DEBUG String Input 3:0:0:1 String Input 3:0:0:1 doBeforePostExecution 2020-01-15 11:27:09,193 DEBUG File Chooser 3:0:0:0:0:10 Adding handler e23df992-9d7b-400c-8e0f-a080c1299df7 (File Chooser 3:0:0:0:0:10: ) - 10 in total 2020-01-15 11:27:09,193 DEBUG String Input 3:0:0:1 String Input 3:0:0:1 has new state: POSTEXECUTE 2020-01-15 11:27:09,193 DEBUG String Input 3:0:0:1 String Input 3:0:0:1 doAfterExecute - success 2020-01-15 11:27:09,193 DEBUG String Input 3:0:0:1 String Input 3:0:0:1 has new state: EXECUTED 2020-01-15 11:27:09,193 DEBUG Component Input 3:0:0:6 Component Input 3:0:0:6 doBeforeExecution 2020-01-15 11:27:09,193 INFO Component Input 3:3:0:0:0:13 Component Input 3:3:0:0:0:13 End execute (0 secs) 2020-01-15 11:27:09,193 DEBUG Component Input 3:0:0:6 Component Input 3:0:0:6 has new state: EXECUTING 2020-01-15 11:27:09,194 DEBUG Component Input 3:0:0:6 Component Input 3:0:0:6 Start execute 2020-01-15 11:27:09,194 DEBUG String Input 3:8:0:1 String Input 3:8:0:1 doBeforePostExecution 2020-01-15 11:27:09,194 DEBUG String Input 3:8:0:1 String Input 3:8:0:1 has new state: POSTEXECUTE 2020-01-15 11:27:09,194 DEBUG String Input 3:8:0:1 String Input 3:8:0:1 doAfterExecute - success 2020-01-15 11:27:09,194 DEBUG String Input 3:8:0:1 String Input 3:8:0:1 has new state: EXECUTED 2020-01-15 11:27:09,194 DEBUG Component Input 3:0:0:0:0:13 Component Input 3:0:0:0:0:13 doBeforePreExecution 2020-01-15 11:27:09,194 DEBUG Component Input 3:0:0:0:0:13 Component Input 3:0:0:0:0:13 has new state: PREEXECUTE 2020-01-15 11:27:09,194 DEBUG Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0 doBeforePreExecution 2020-01-15 11:27:09,194 DEBUG Component Input 3:0:0:0:0:13 Adding handler 03dc9b34-64bc-4321-a2d0-b7721bd24fd8 (Component Input 3:0:0:0:0:13: ) - 11 in total 2020-01-15 11:27:09,195 DEBUG Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0 has new state: PREEXECUTE 2020-01-15 11:27:09,195 DEBUG Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0 doBeforeExecution 2020-01-15 11:27:09,195 DEBUG Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0 has new state: EXECUTING 2020-01-15 11:27:09,195 DEBUG Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0 Start execute 2020-01-15 11:27:09,195 DEBUG Read Configuration 3:8:0:0 Component Input 3:8:0:0:0:13 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,195 DEBUG Read Configuration 3:8:0:0 Component Input 3:8:0:0:0:13 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,195 DEBUG Read Configuration 3:8:0:0 Get Home Directory 3:8:0:0:0:0 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,195 DEBUG Read Configuration 3:8:0:0 Get Home Directory 3:8:0:0:0:0 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,195 DEBUG Read Configuration 3:8:0:0 String Manipulation (Variable) 3:8:0:0:0:15 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,195 DEBUG Read Configuration 3:8:0:0 File Reader 3:8:0:0:0:1 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,195 DEBUG Read Configuration 3:8:0:0 Regex Split 3:8:0:0:0:2 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,195 DEBUG Read Configuration 3:8:0:0 Column Filter 3:8:0:0:0:3 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,195 DEBUG Read Configuration 3:8:0:0 Column Rename 3:8:0:0:0:8 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,195 DEBUG Read Configuration 3:8:0:0 Pivoting 3:8:0:0:0:6 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,196 DEBUG Read Configuration 3:8:0:0 Column Rename (Regex) 3:8:0:0:0:9 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,196 DEBUG Read Configuration 3:8:0:0 Table Row to Variable (deprecated) 3:8:0:0:0:7 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,196 DEBUG Read Configuration 3:8:0:0 Component Output 3:8:0:0:0:14 has new state: UNCONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,196 DEBUG Read Configuration 3:8:0:0 File Chooser 3:8:0:0:0:10 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,196 DEBUG Read Configuration 3:8:0:0 File Chooser 3:8:0:0:0:10 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,196 DEBUG Read Configuration 3:8:0:0 Read Configuration 3:8:0:0:0 has new state: EXECUTING 2020-01-15 11:27:09,196 DEBUG File Chooser 3:0:0:0:0:10 File Chooser 3:0:0:0:0:10 doBeforeExecution 2020-01-15 11:27:09,196 DEBUG File Chooser 3:0:0:0:0:10 File Chooser 3:0:0:0:0:10 has new state: EXECUTING 2020-01-15 11:27:09,196 DEBUG File Chooser 3:0:0:0:0:10 File Chooser 3:0:0:0:0:10 Start execute 2020-01-15 11:27:09,196 DEBUG Component Input 3:3:0:0:0:13 Component Input 3:3:0:0:0:13 doBeforePostExecution 2020-01-15 11:27:09,196 DEBUG Component Input 3:3:0:0:0:13 Component Input 3:3:0:0:0:13 has new state: POSTEXECUTE 2020-01-15 11:27:09,196 DEBUG Component Input 3:3:0:0:0:13 Component Input 3:3:0:0:0:13 doAfterExecute - success 2020-01-15 11:27:09,197 DEBUG Component Input 3:3:0:0:0:13 Component Input 3:3:0:0:0:13 has new state: EXECUTED 2020-01-15 11:27:09,197 DEBUG File Chooser 3:0:0:0:0:10 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,197 INFO Component Input 3:0:0:6 Component Input 3:0:0:6 End execute (0 secs) 2020-01-15 11:27:09,197 DEBUG Component Input 3:0:0:6 Component Input 3:0:0:6 doBeforePostExecution 2020-01-15 11:27:09,197 DEBUG Component Input 3:0:0:6 Component Input 3:0:0:6 has new state: POSTEXECUTE 2020-01-15 11:27:09,197 DEBUG Component Input 3:0:0:6 Component Input 3:0:0:6 doAfterExecute - success 2020-01-15 11:27:09,197 DEBUG Component Input 3:0:0:6 Component Input 3:0:0:6 has new state: EXECUTED 2020-01-15 11:27:09,198 INFO File Chooser 3:0:0:0:0:10 File Chooser 3:0:0:0:0:10 End execute (0 secs) 2020-01-15 11:27:09,198 DEBUG Component Input 3:0:0:0:0:13 Component Input 3:0:0:0:0:13 doBeforeExecution 2020-01-15 11:27:09,198 DEBUG Component Input 3:0:0:0:0:13 Component Input 3:0:0:0:0:13 has new state: EXECUTING 2020-01-15 11:27:09,198 DEBUG Component Input 3:0:0:0:0:13 Component Input 3:0:0:0:0:13 Start execute 2020-01-15 11:27:09,198 DEBUG Get Home Directory 3:0:0:0:0:0 Component Input 3:0:0:0:0:0:0:6 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,198 DEBUG Get Home Directory 3:0:0:0:0:0 Component Input 3:0:0:0:0:0:0:6 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,198 DEBUG Get Home Directory 3:0:0:0:0:0 Java Edit Variable 3:0:0:0:0:0:0:5 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,198 DEBUG Get Home Directory 3:0:0:0:0:0 Component Output 3:0:0:0:0:0:0:7 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,198 DEBUG Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0:0 has new state: EXECUTING 2020-01-15 11:27:09,198 DEBUG Component Input 3:8:0:0:0:13 Component Input 3:8:0:0:0:13 doBeforePreExecution 2020-01-15 11:27:09,198 DEBUG Component Input 3:8:0:0:0:13 Component Input 3:8:0:0:0:13 has new state: PREEXECUTE 2020-01-15 11:27:09,198 DEBUG Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0 doBeforePreExecution 2020-01-15 11:27:09,198 DEBUG Component Input 3:8:0:0:0:13 Adding handler 0217efe8-0128-44cf-9fcb-6c50ebb03cee (Component Input 3:8:0:0:0:13: ) - 12 in total 2020-01-15 11:27:09,199 DEBUG Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0 has new state: PREEXECUTE 2020-01-15 11:27:09,200 DEBUG Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0 doBeforeExecution 2020-01-15 11:27:09,200 DEBUG Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0 has new state: EXECUTING 2020-01-15 11:27:09,200 DEBUG Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0 Start execute 2020-01-15 11:27:09,200 DEBUG File Chooser 3:8:0:0:0:10 File Chooser 3:8:0:0:0:10 doBeforePreExecution 2020-01-15 11:27:09,201 DEBUG File Chooser 3:8:0:0:0:10 File Chooser 3:8:0:0:0:10 has new state: PREEXECUTE 2020-01-15 11:27:09,201 DEBUG File Chooser 3:8:0:0:0:10 Adding handler 3eeeb00d-6ca5-4e41-a452-f89a7cc35ef6 (File Chooser 3:8:0:0:0:10: ) - 13 in total 2020-01-15 11:27:09,201 DEBUG File Chooser 3:8:0:0:0:10 File Chooser 3:8:0:0:0:10 doBeforeExecution 2020-01-15 11:27:09,201 DEBUG File Chooser 3:8:0:0:0:10 File Chooser 3:8:0:0:0:10 has new state: EXECUTING 2020-01-15 11:27:09,201 INFO Component Input 3:8:0:6 Component Input 3:8:0:6 End execute (0 secs) 2020-01-15 11:27:09,201 DEBUG File Chooser 3:0:0:0:0:10 File Chooser 3:0:0:0:0:10 doBeforePostExecution 2020-01-15 11:27:09,201 DEBUG File Chooser 3:8:0:0:0:10 File Chooser 3:8:0:0:0:10 Start execute 2020-01-15 11:27:09,201 INFO Component Input 3:3:0:0:0:0:0:6 Component Input 3:3:0:0:0:0:0:6 End execute (0 secs) 2020-01-15 11:27:09,201 DEBUG File Chooser 3:0:0:0:0:10 File Chooser 3:0:0:0:0:10 has new state: POSTEXECUTE 2020-01-15 11:27:09,201 DEBUG File Chooser 3:0:0:0:0:10 File Chooser 3:0:0:0:0:10 doAfterExecute - success 2020-01-15 11:27:09,202 DEBUG File Chooser 3:0:0:0:0:10 File Chooser 3:0:0:0:0:10 has new state: EXECUTED 2020-01-15 11:27:09,202 DEBUG File Chooser 3:8:0:0:0:10 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,202 INFO Component Input 3:0:0:0:0:13 Component Input 3:0:0:0:0:13 End execute (0 secs) 2020-01-15 11:27:09,202 DEBUG Component Input 3:0:0:0:0:13 Component Input 3:0:0:0:0:13 doBeforePostExecution 2020-01-15 11:27:09,202 DEBUG Component Input 3:0:0:0:0:13 Component Input 3:0:0:0:0:13 has new state: POSTEXECUTE 2020-01-15 11:27:09,202 DEBUG Component Input 3:0:0:0:0:13 Component Input 3:0:0:0:0:13 doAfterExecute - success 2020-01-15 11:27:09,202 DEBUG Component Input 3:0:0:0:0:13 Component Input 3:0:0:0:0:13 has new state: EXECUTED 2020-01-15 11:27:09,202 INFO File Chooser 3:8:0:0:0:10 File Chooser 3:8:0:0:0:10 End execute (0 secs) 2020-01-15 11:27:09,203 DEBUG Component Input 3:0:0:0:0:0:0:6 Component Input 3:0:0:0:0:0:0:6 doBeforePreExecution 2020-01-15 11:27:09,203 DEBUG Component Input 3:0:0:0:0:0:0:6 Component Input 3:0:0:0:0:0:0:6 has new state: PREEXECUTE 2020-01-15 11:27:09,203 DEBUG Component Input 3:0:0:0:0:0:0:6 Adding handler 1a5d8b11-1409-4e4d-976f-e664ca281b9a (Component Input 3:0:0:0:0:0:0:6: ) - 14 in total 2020-01-15 11:27:09,203 DEBUG Component Input 3:8:0:0:0:13 Component Input 3:8:0:0:0:13 doBeforeExecution 2020-01-15 11:27:09,203 DEBUG Component Input 3:8:0:0:0:13 Component Input 3:8:0:0:0:13 has new state: EXECUTING 2020-01-15 11:27:09,203 DEBUG Component Input 3:8:0:0:0:13 Component Input 3:8:0:0:0:13 Start execute 2020-01-15 11:27:09,203 DEBUG Get Home Directory 3:8:0:0:0:0 Component Input 3:8:0:0:0:0:0:6 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,203 DEBUG Get Home Directory 3:8:0:0:0:0 Component Input 3:8:0:0:0:0:0:6 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,203 DEBUG Get Home Directory 3:8:0:0:0:0 Java Edit Variable 3:8:0:0:0:0:0:5 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,203 DEBUG Get Home Directory 3:8:0:0:0:0 Component Output 3:8:0:0:0:0:0:7 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,204 DEBUG Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0:0 has new state: EXECUTING 2020-01-15 11:27:09,204 DEBUG Component Input 3:8:0:6 Component Input 3:8:0:6 doBeforePostExecution 2020-01-15 11:27:09,204 DEBUG Component Input 3:8:0:6 Component Input 3:8:0:6 has new state: POSTEXECUTE 2020-01-15 11:27:09,204 DEBUG Component Input 3:8:0:6 Component Input 3:8:0:6 doAfterExecute - success 2020-01-15 11:27:09,204 DEBUG Component Input 3:8:0:6 Component Input 3:8:0:6 has new state: EXECUTED 2020-01-15 11:27:09,204 DEBUG Component Input 3:3:0:0:0:0:0:6 Component Input 3:3:0:0:0:0:0:6 doBeforePostExecution 2020-01-15 11:27:09,204 DEBUG Component Input 3:3:0:0:0:0:0:6 Component Input 3:3:0:0:0:0:0:6 has new state: POSTEXECUTE 2020-01-15 11:27:09,205 DEBUG Component Input 3:3:0:0:0:0:0:6 Component Input 3:3:0:0:0:0:0:6 doAfterExecute - success 2020-01-15 11:27:09,205 DEBUG Component Input 3:3:0:0:0:0:0:6 Component Input 3:3:0:0:0:0:0:6 has new state: EXECUTED 2020-01-15 11:27:09,206 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Configure succeeded. (Java Edit Variable) 2020-01-15 11:27:09,206 DEBUG Component Input 3:3:0:0:0:0:0:6 Java Edit Variable 3:3:0:0:0:0:0:5 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,206 DEBUG File Chooser 3:8:0:0:0:10 File Chooser 3:8:0:0:0:10 doBeforePostExecution 2020-01-15 11:27:09,206 DEBUG File Chooser 3:8:0:0:0:10 File Chooser 3:8:0:0:0:10 has new state: POSTEXECUTE 2020-01-15 11:27:09,206 DEBUG File Chooser 3:8:0:0:0:10 File Chooser 3:8:0:0:0:10 doAfterExecute - success 2020-01-15 11:27:09,206 DEBUG File Chooser 3:8:0:0:0:10 File Chooser 3:8:0:0:0:10 has new state: EXECUTED 2020-01-15 11:27:09,207 DEBUG Component Input 3:0:0:0:0:0:0:6 Component Input 3:0:0:0:0:0:0:6 doBeforeExecution 2020-01-15 11:27:09,207 DEBUG Component Input 3:0:0:0:0:0:0:6 Component Input 3:0:0:0:0:0:0:6 has new state: EXECUTING 2020-01-15 11:27:09,207 DEBUG Component Input 3:0:0:0:0:0:0:6 Component Input 3:0:0:0:0:0:0:6 Start execute 2020-01-15 11:27:09,207 DEBUG Component Input 3:8:0:0:0:0:0:6 Component Input 3:8:0:0:0:0:0:6 doBeforePreExecution 2020-01-15 11:27:09,207 DEBUG Component Input 3:8:0:0:0:0:0:6 Component Input 3:8:0:0:0:0:0:6 has new state: PREEXECUTE 2020-01-15 11:27:09,207 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Java Edit Variable 3:3:0:0:0:0:0:5 doBeforePreExecution 2020-01-15 11:27:09,207 DEBUG Component Input 3:8:0:0:0:0:0:6 Adding handler e9d99c35-796b-44d8-919f-a9f5b0c11c22 (Component Input 3:8:0:0:0:0:0:6: ) - 15 in total 2020-01-15 11:27:09,207 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Java Edit Variable 3:3:0:0:0:0:0:5 has new state: PREEXECUTE 2020-01-15 11:27:09,207 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Adding handler ed76fe8d-cf4e-405f-9351-99a2102b4c69 (Java Edit Variable 3:3:0:0:0:0:0:5: ) - 16 in total 2020-01-15 11:27:09,207 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Java Edit Variable 3:3:0:0:0:0:0:5 doBeforeExecution 2020-01-15 11:27:09,207 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Java Edit Variable 3:3:0:0:0:0:0:5 has new state: EXECUTING 2020-01-15 11:27:09,207 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Java Edit Variable 3:3:0:0:0:0:0:5 Start execute 2020-01-15 11:27:09,207 DEBUG Component Input 3:8:0:0:0:0:0:6 Component Input 3:8:0:0:0:0:0:6 doBeforeExecution 2020-01-15 11:27:09,208 DEBUG Component Input 3:8:0:0:0:0:0:6 Component Input 3:8:0:0:0:0:0:6 has new state: EXECUTING 2020-01-15 11:27:09,208 DEBUG Component Input 3:8:0:0:0:0:0:6 Component Input 3:8:0:0:0:0:0:6 Start execute 2020-01-15 11:27:09,208 INFO Java Edit Variable 3:3:0:0:0:0:0:5 Java Edit Variable 3:3:0:0:0:0:0:5 End execute (0 secs) 2020-01-15 11:27:09,208 INFO Component Input 3:8:0:0:0:0:0:6 Component Input 3:8:0:0:0:0:0:6 End execute (0 secs) 2020-01-15 11:27:09,208 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Java Edit Variable 3:3:0:0:0:0:0:5 doBeforePostExecution 2020-01-15 11:27:09,208 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Java Edit Variable 3:3:0:0:0:0:0:5 has new state: POSTEXECUTE 2020-01-15 11:27:09,208 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Java Edit Variable 3:3:0:0:0:0:0:5 doAfterExecute - success 2020-01-15 11:27:09,208 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Java Edit Variable 3:3:0:0:0:0:0:5 has new state: EXECUTED 2020-01-15 11:27:09,209 DEBUG Component Output 3:3:0:0:0:0:0:7 Configure succeeded. (Component Output) 2020-01-15 11:27:09,209 DEBUG Java Edit Variable 3:3:0:0:0:0:0:5 Component Output 3:3:0:0:0:0:0:7 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,209 DEBUG Component Input 3:8:0:0:0:0:0:6 Component Input 3:8:0:0:0:0:0:6 doBeforePostExecution 2020-01-15 11:27:09,209 INFO Component Input 3:8:0:0:0:13 Component Input 3:8:0:0:0:13 End execute (0 secs) 2020-01-15 11:27:09,209 DEBUG Component Input 3:8:0:0:0:0:0:6 Component Input 3:8:0:0:0:0:0:6 has new state: POSTEXECUTE 2020-01-15 11:27:09,209 DEBUG Component Input 3:8:0:0:0:0:0:6 Component Input 3:8:0:0:0:0:0:6 doAfterExecute - success 2020-01-15 11:27:09,209 DEBUG Component Input 3:8:0:0:0:0:0:6 Component Input 3:8:0:0:0:0:0:6 has new state: EXECUTED 2020-01-15 11:27:09,210 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Configure succeeded. (Java Edit Variable) 2020-01-15 11:27:09,211 DEBUG Component Input 3:8:0:0:0:0:0:6 Java Edit Variable 3:8:0:0:0:0:0:5 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,211 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Java Edit Variable 3:8:0:0:0:0:0:5 doBeforePreExecution 2020-01-15 11:27:09,211 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Java Edit Variable 3:8:0:0:0:0:0:5 has new state: PREEXECUTE 2020-01-15 11:27:09,211 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Adding handler 6f147f4c-9031-4590-844d-ebf803386bae (Java Edit Variable 3:8:0:0:0:0:0:5: ) - 17 in total 2020-01-15 11:27:09,211 DEBUG Component Output 3:3:0:0:0:0:0:7 Component Output 3:3:0:0:0:0:0:7 doBeforePreExecution 2020-01-15 11:27:09,211 DEBUG Component Output 3:3:0:0:0:0:0:7 Component Output 3:3:0:0:0:0:0:7 has new state: PREEXECUTE 2020-01-15 11:27:09,211 DEBUG Component Input 3:8:0:0:0:13 Component Input 3:8:0:0:0:13 doBeforePostExecution 2020-01-15 11:27:09,211 DEBUG Component Output 3:3:0:0:0:0:0:7 Adding handler 8beb3f15-38b8-43af-9195-ef7c86560761 (Component Output 3:3:0:0:0:0:0:7: ) - 18 in total 2020-01-15 11:27:09,211 DEBUG Component Input 3:8:0:0:0:13 Component Input 3:8:0:0:0:13 has new state: POSTEXECUTE 2020-01-15 11:27:09,211 DEBUG Component Input 3:8:0:0:0:13 Component Input 3:8:0:0:0:13 doAfterExecute - success 2020-01-15 11:27:09,212 DEBUG Component Input 3:8:0:0:0:13 Component Input 3:8:0:0:0:13 has new state: EXECUTED 2020-01-15 11:27:09,212 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Java Edit Variable 3:8:0:0:0:0:0:5 doBeforeExecution 2020-01-15 11:27:09,212 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Java Edit Variable 3:8:0:0:0:0:0:5 has new state: EXECUTING 2020-01-15 11:27:09,212 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Java Edit Variable 3:8:0:0:0:0:0:5 Start execute 2020-01-15 11:27:09,212 INFO Component Input 3:0:0:0:0:0:0:6 Component Input 3:0:0:0:0:0:0:6 End execute (0 secs) 2020-01-15 11:27:09,212 DEBUG Component Output 3:3:0:0:0:0:0:7 Component Output 3:3:0:0:0:0:0:7 doBeforeExecution 2020-01-15 11:27:09,212 DEBUG Component Output 3:3:0:0:0:0:0:7 Component Output 3:3:0:0:0:0:0:7 has new state: EXECUTING 2020-01-15 11:27:09,212 DEBUG Component Input 3:0:0:0:0:0:0:6 Component Input 3:0:0:0:0:0:0:6 doBeforePostExecution 2020-01-15 11:27:09,212 INFO Java Edit Variable 3:8:0:0:0:0:0:5 Java Edit Variable 3:8:0:0:0:0:0:5 End execute (0 secs) 2020-01-15 11:27:09,212 DEBUG Component Input 3:0:0:0:0:0:0:6 Component Input 3:0:0:0:0:0:0:6 has new state: POSTEXECUTE 2020-01-15 11:27:09,212 DEBUG Component Output 3:3:0:0:0:0:0:7 Component Output 3:3:0:0:0:0:0:7 Start execute 2020-01-15 11:27:09,213 DEBUG Component Input 3:0:0:0:0:0:0:6 Component Input 3:0:0:0:0:0:0:6 doAfterExecute - success 2020-01-15 11:27:09,213 DEBUG Component Input 3:0:0:0:0:0:0:6 Component Input 3:0:0:0:0:0:0:6 has new state: EXECUTED 2020-01-15 11:27:09,213 INFO Component Output 3:3:0:0:0:0:0:7 Component Output 3:3:0:0:0:0:0:7 End execute (0 secs) 2020-01-15 11:27:09,217 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Configure succeeded. (Java Edit Variable) 2020-01-15 11:27:09,218 DEBUG Component Input 3:0:0:0:0:0:0:6 Java Edit Variable 3:0:0:0:0:0:0:5 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,218 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Java Edit Variable 3:8:0:0:0:0:0:5 doBeforePostExecution 2020-01-15 11:27:09,218 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Java Edit Variable 3:8:0:0:0:0:0:5 has new state: POSTEXECUTE 2020-01-15 11:27:09,218 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Java Edit Variable 3:8:0:0:0:0:0:5 doAfterExecute - success 2020-01-15 11:27:09,218 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Java Edit Variable 3:8:0:0:0:0:0:5 has new state: EXECUTED 2020-01-15 11:27:09,218 DEBUG Component Output 3:8:0:0:0:0:0:7 Configure succeeded. (Component Output) 2020-01-15 11:27:09,218 DEBUG Java Edit Variable 3:8:0:0:0:0:0:5 Component Output 3:8:0:0:0:0:0:7 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,219 DEBUG Component Output 3:3:0:0:0:0:0:7 Component Output 3:3:0:0:0:0:0:7 doBeforePostExecution 2020-01-15 11:27:09,220 DEBUG Component Output 3:3:0:0:0:0:0:7 Component Output 3:3:0:0:0:0:0:7 has new state: POSTEXECUTE 2020-01-15 11:27:09,220 DEBUG Component Output 3:3:0:0:0:0:0:7 Component Output 3:3:0:0:0:0:0:7 doAfterExecute - success 2020-01-15 11:27:09,220 DEBUG Component Output 3:3:0:0:0:0:0:7 Component Output 3:3:0:0:0:0:0:7 has new state: EXECUTED 2020-01-15 11:27:09,220 DEBUG Component Output 3:3:0:0:0:0:0:7 Get Home Directory 3:3:0:0:0:0:0 has new state: EXECUTED 2020-01-15 11:27:09,220 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Java Edit Variable 3:0:0:0:0:0:0:5 doBeforePreExecution 2020-01-15 11:27:09,220 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Java Edit Variable 3:0:0:0:0:0:0:5 has new state: PREEXECUTE 2020-01-15 11:27:09,221 DEBUG Component Output 3:8:0:0:0:0:0:7 Component Output 3:8:0:0:0:0:0:7 doBeforePreExecution 2020-01-15 11:27:09,221 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Adding handler f4b1bbf8-04fa-4534-b608-8263fbb68698 (Java Edit Variable 3:0:0:0:0:0:0:5: ) - 19 in total 2020-01-15 11:27:09,221 DEBUG Component Output 3:8:0:0:0:0:0:7 Component Output 3:8:0:0:0:0:0:7 has new state: PREEXECUTE 2020-01-15 11:27:09,221 DEBUG Component Output 3:8:0:0:0:0:0:7 Adding handler 670bb077-1e30-4703-abe5-f5ea745a2f8d (Component Output 3:8:0:0:0:0:0:7: ) - 20 in total 2020-01-15 11:27:09,221 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Java Edit Variable 3:0:0:0:0:0:0:5 doBeforeExecution 2020-01-15 11:27:09,221 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Java Edit Variable 3:0:0:0:0:0:0:5 has new state: EXECUTING 2020-01-15 11:27:09,221 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Java Edit Variable 3:0:0:0:0:0:0:5 Start execute 2020-01-15 11:27:09,221 DEBUG Component Output 3:8:0:0:0:0:0:7 Component Output 3:8:0:0:0:0:0:7 doBeforeExecution 2020-01-15 11:27:09,221 DEBUG Component Output 3:8:0:0:0:0:0:7 Component Output 3:8:0:0:0:0:0:7 has new state: EXECUTING 2020-01-15 11:27:09,221 DEBUG Component Output 3:8:0:0:0:0:0:7 Component Output 3:8:0:0:0:0:0:7 Start execute 2020-01-15 11:27:09,222 INFO Component Output 3:8:0:0:0:0:0:7 Component Output 3:8:0:0:0:0:0:7 End execute (0 secs) 2020-01-15 11:27:09,222 DEBUG Component Output 3:8:0:0:0:0:0:7 Component Output 3:8:0:0:0:0:0:7 doBeforePostExecution 2020-01-15 11:27:09,222 DEBUG Component Output 3:8:0:0:0:0:0:7 Component Output 3:8:0:0:0:0:0:7 has new state: POSTEXECUTE 2020-01-15 11:27:09,222 DEBUG Component Output 3:8:0:0:0:0:0:7 Component Output 3:8:0:0:0:0:0:7 doAfterExecute - success 2020-01-15 11:27:09,222 DEBUG Component Output 3:8:0:0:0:0:0:7 Component Output 3:8:0:0:0:0:0:7 has new state: EXECUTED 2020-01-15 11:27:09,222 DEBUG Component Output 3:8:0:0:0:0:0:7 Get Home Directory 3:8:0:0:0:0:0 has new state: EXECUTED 2020-01-15 11:27:09,223 INFO Java Edit Variable 3:0:0:0:0:0:0:5 Java Edit Variable 3:0:0:0:0:0:0:5 End execute (0 secs) 2020-01-15 11:27:09,223 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Java Edit Variable 3:0:0:0:0:0:0:5 doBeforePostExecution 2020-01-15 11:27:09,223 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Java Edit Variable 3:0:0:0:0:0:0:5 has new state: POSTEXECUTE 2020-01-15 11:27:09,223 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Java Edit Variable 3:0:0:0:0:0:0:5 doAfterExecute - success 2020-01-15 11:27:09,223 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Java Edit Variable 3:0:0:0:0:0:0:5 has new state: EXECUTED 2020-01-15 11:27:09,223 DEBUG Component Output 3:0:0:0:0:0:0:7 Configure succeeded. (Component Output) 2020-01-15 11:27:09,223 DEBUG Java Edit Variable 3:0:0:0:0:0:0:5 Component Output 3:0:0:0:0:0:0:7 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,223 DEBUG Component Output 3:0:0:0:0:0:0:7 Component Output 3:0:0:0:0:0:0:7 doBeforePreExecution 2020-01-15 11:27:09,223 INFO Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0 End execute (0 secs) 2020-01-15 11:27:09,224 DEBUG Component Output 3:0:0:0:0:0:0:7 Component Output 3:0:0:0:0:0:0:7 has new state: PREEXECUTE 2020-01-15 11:27:09,224 DEBUG Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0 doBeforePostExecution 2020-01-15 11:27:09,224 DEBUG Component Output 3:0:0:0:0:0:0:7 Adding handler a74bed97-157a-493e-9257-013c295d0070 (Component Output 3:0:0:0:0:0:0:7: ) - 21 in total 2020-01-15 11:27:09,224 DEBUG Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0 has new state: POSTEXECUTE 2020-01-15 11:27:09,224 DEBUG Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0 doAfterExecute - success 2020-01-15 11:27:09,224 DEBUG Get Home Directory 3:3:0:0:0:0 Get Home Directory 3:3:0:0:0:0 has new state: EXECUTED 2020-01-15 11:27:09,224 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 Configure succeeded. (String Manipulation (Variable)) 2020-01-15 11:27:09,224 DEBUG Get Home Directory 3:3:0:0:0:0 String Manipulation (Variable) 3:3:0:0:0:15 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,224 DEBUG Get Home Directory 3:3:0:0:0:0 String Manipulation (Variable) 3:3:0:0:0:15 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,236 DEBUG File Reader 3:3:0:0:0:1 Configure succeeded. (File Reader) 2020-01-15 11:27:09,236 DEBUG Get Home Directory 3:3:0:0:0:0 File Reader 3:3:0:0:0:1 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,236 DEBUG Regex Split 3:3:0:0:0:2 Configure succeeded. (Regex Split) 2020-01-15 11:27:09,236 DEBUG Get Home Directory 3:3:0:0:0:0 Regex Split 3:3:0:0:0:2 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,237 DEBUG Column Filter 3:3:0:0:0:3 Configure succeeded. (Column Filter) 2020-01-15 11:27:09,237 DEBUG Get Home Directory 3:3:0:0:0:0 Column Filter 3:3:0:0:0:3 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,237 DEBUG Column Rename 3:3:0:0:0:8 Configure succeeded. (Column Rename) 2020-01-15 11:27:09,237 DEBUG Get Home Directory 3:3:0:0:0:0 Column Rename 3:3:0:0:0:8 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,237 WARN Pivoting 3:3:0:0:0:6 No grouping column included. Aggregate complete table. 2020-01-15 11:27:09,237 DEBUG Pivoting 3:3:0:0:0:6 [value->First true] 2020-01-15 11:27:09,238 DEBUG Pivoting 3:3:0:0:0:6 [value->First true] 2020-01-15 11:27:09,238 DEBUG Pivoting 3:3:0:0:0:6 [value->First true] 2020-01-15 11:27:09,238 DEBUG Pivoting 3:3:0:0:0:6 Configure succeeded. (Pivoting) 2020-01-15 11:27:09,238 DEBUG Get Home Directory 3:3:0:0:0:0 Pivoting 3:3:0:0:0:6 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,238 DEBUG Component Output 3:0:0:0:0:0:0:7 Component Output 3:0:0:0:0:0:0:7 doBeforeExecution 2020-01-15 11:27:09,238 INFO Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0 End execute (0 secs) 2020-01-15 11:27:09,238 DEBUG Component Output 3:0:0:0:0:0:0:7 Component Output 3:0:0:0:0:0:0:7 has new state: EXECUTING 2020-01-15 11:27:09,238 DEBUG Component Output 3:0:0:0:0:0:0:7 Component Output 3:0:0:0:0:0:0:7 Start execute 2020-01-15 11:27:09,238 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 String Manipulation (Variable) 3:3:0:0:0:15 doBeforePreExecution 2020-01-15 11:27:09,239 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 String Manipulation (Variable) 3:3:0:0:0:15 has new state: PREEXECUTE 2020-01-15 11:27:09,240 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 Adding handler d61e4915-5d8b-4c4a-a879-e56e4260cde5 (String Manipulation (Variable) 3:3:0:0:0:15: ) - 22 in total 2020-01-15 11:27:09,241 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 String Manipulation (Variable) 3:3:0:0:0:15 doBeforeExecution 2020-01-15 11:27:09,241 INFO Component Output 3:0:0:0:0:0:0:7 Component Output 3:0:0:0:0:0:0:7 End execute (0 secs) 2020-01-15 11:27:09,242 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 String Manipulation (Variable) 3:3:0:0:0:15 has new state: EXECUTING 2020-01-15 11:27:09,242 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 String Manipulation (Variable) 3:3:0:0:0:15 Start execute 2020-01-15 11:27:09,242 DEBUG Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0 doBeforePostExecution 2020-01-15 11:27:09,242 DEBUG Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0 has new state: POSTEXECUTE 2020-01-15 11:27:09,243 DEBUG Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0 doAfterExecute - success 2020-01-15 11:27:09,243 DEBUG Get Home Directory 3:8:0:0:0:0 Get Home Directory 3:8:0:0:0:0 has new state: EXECUTED 2020-01-15 11:27:09,243 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 Configure succeeded. (String Manipulation (Variable)) 2020-01-15 11:27:09,243 DEBUG Get Home Directory 3:8:0:0:0:0 String Manipulation (Variable) 3:8:0:0:0:15 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,244 DEBUG Get Home Directory 3:8:0:0:0:0 String Manipulation (Variable) 3:8:0:0:0:15 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,271 DEBUG File Reader 3:8:0:0:0:1 Configure succeeded. (File Reader) 2020-01-15 11:27:09,272 DEBUG Get Home Directory 3:8:0:0:0:0 File Reader 3:8:0:0:0:1 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,272 DEBUG Regex Split 3:8:0:0:0:2 Configure succeeded. (Regex Split) 2020-01-15 11:27:09,272 DEBUG Get Home Directory 3:8:0:0:0:0 Regex Split 3:8:0:0:0:2 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,273 DEBUG Column Filter 3:8:0:0:0:3 Configure succeeded. (Column Filter) 2020-01-15 11:27:09,273 DEBUG Get Home Directory 3:8:0:0:0:0 Column Filter 3:8:0:0:0:3 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,273 INFO String Manipulation (Variable) 3:3:0:0:0:15 String Manipulation (Variable) 3:3:0:0:0:15 End execute (0 secs) 2020-01-15 11:27:09,273 DEBUG Column Rename 3:8:0:0:0:8 Configure succeeded. (Column Rename) 2020-01-15 11:27:09,273 DEBUG Get Home Directory 3:8:0:0:0:0 Column Rename 3:8:0:0:0:8 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,273 WARN Pivoting 3:8:0:0:0:6 No grouping column included. Aggregate complete table. 2020-01-15 11:27:09,274 DEBUG Pivoting 3:8:0:0:0:6 [value->First true] 2020-01-15 11:27:09,274 DEBUG Pivoting 3:8:0:0:0:6 [value->First true] 2020-01-15 11:27:09,274 DEBUG Pivoting 3:8:0:0:0:6 [value->First true] 2020-01-15 11:27:09,274 DEBUG Pivoting 3:8:0:0:0:6 Configure succeeded. (Pivoting) 2020-01-15 11:27:09,274 DEBUG Get Home Directory 3:8:0:0:0:0 Pivoting 3:8:0:0:0:6 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,274 DEBUG Component Output 3:0:0:0:0:0:0:7 Component Output 3:0:0:0:0:0:0:7 doBeforePostExecution 2020-01-15 11:27:09,274 DEBUG Component Output 3:0:0:0:0:0:0:7 Component Output 3:0:0:0:0:0:0:7 has new state: POSTEXECUTE 2020-01-15 11:27:09,275 DEBUG Component Output 3:0:0:0:0:0:0:7 Component Output 3:0:0:0:0:0:0:7 doAfterExecute - success 2020-01-15 11:27:09,275 DEBUG Component Output 3:0:0:0:0:0:0:7 Component Output 3:0:0:0:0:0:0:7 has new state: EXECUTED 2020-01-15 11:27:09,275 DEBUG Component Output 3:0:0:0:0:0:0:7 Get Home Directory 3:0:0:0:0:0:0 has new state: EXECUTED 2020-01-15 11:27:09,275 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 String Manipulation (Variable) 3:8:0:0:0:15 doBeforePreExecution 2020-01-15 11:27:09,276 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 String Manipulation (Variable) 3:8:0:0:0:15 has new state: PREEXECUTE 2020-01-15 11:27:09,276 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 String Manipulation (Variable) 3:3:0:0:0:15 doBeforePostExecution 2020-01-15 11:27:09,276 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 Adding handler 6799eaa4-8858-4d69-8a20-2f908576b914 (String Manipulation (Variable) 3:8:0:0:0:15: ) - 23 in total 2020-01-15 11:27:09,276 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 String Manipulation (Variable) 3:3:0:0:0:15 has new state: POSTEXECUTE 2020-01-15 11:27:09,276 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 String Manipulation (Variable) 3:3:0:0:0:15 doAfterExecute - success 2020-01-15 11:27:09,276 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 String Manipulation (Variable) 3:3:0:0:0:15 has new state: EXECUTED 2020-01-15 11:27:09,279 DEBUG File Reader 3:3:0:0:0:1 Configure succeeded. (File Reader) 2020-01-15 11:27:09,279 DEBUG String Manipulation (Variable) 3:3:0:0:0:15 File Reader 3:3:0:0:0:1 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,279 DEBUG File Reader 3:3:0:0:0:1 File Reader 3:3:0:0:0:1 doBeforePreExecution 2020-01-15 11:27:09,279 DEBUG File Reader 3:3:0:0:0:1 File Reader 3:3:0:0:0:1 has new state: PREEXECUTE 2020-01-15 11:27:09,279 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 String Manipulation (Variable) 3:8:0:0:0:15 doBeforeExecution 2020-01-15 11:27:09,279 DEBUG File Reader 3:3:0:0:0:1 Adding handler ab2a3b96-b41d-4d71-9090-53664e9df2b0 (File Reader 3:3:0:0:0:1: ) - 24 in total 2020-01-15 11:27:09,279 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 String Manipulation (Variable) 3:8:0:0:0:15 has new state: EXECUTING 2020-01-15 11:27:09,279 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 String Manipulation (Variable) 3:8:0:0:0:15 Start execute 2020-01-15 11:27:09,280 INFO String Manipulation (Variable) 3:8:0:0:0:15 String Manipulation (Variable) 3:8:0:0:0:15 End execute (0 secs) 2020-01-15 11:27:09,280 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 String Manipulation (Variable) 3:8:0:0:0:15 doBeforePostExecution 2020-01-15 11:27:09,280 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 String Manipulation (Variable) 3:8:0:0:0:15 has new state: POSTEXECUTE 2020-01-15 11:27:09,280 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 String Manipulation (Variable) 3:8:0:0:0:15 doAfterExecute - success 2020-01-15 11:27:09,280 INFO Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0 End execute (0 secs) 2020-01-15 11:27:09,280 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 String Manipulation (Variable) 3:8:0:0:0:15 has new state: EXECUTED 2020-01-15 11:27:09,283 DEBUG File Reader 3:8:0:0:0:1 Configure succeeded. (File Reader) 2020-01-15 11:27:09,283 DEBUG String Manipulation (Variable) 3:8:0:0:0:15 File Reader 3:8:0:0:0:1 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,283 DEBUG File Reader 3:3:0:0:0:1 File Reader 3:3:0:0:0:1 doBeforeExecution 2020-01-15 11:27:09,283 DEBUG File Reader 3:3:0:0:0:1 File Reader 3:3:0:0:0:1 has new state: EXECUTING 2020-01-15 11:27:09,284 DEBUG File Reader 3:3:0:0:0:1 File Reader 3:3:0:0:0:1 Start execute 2020-01-15 11:27:09,284 DEBUG Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0 doBeforePostExecution 2020-01-15 11:27:09,284 DEBUG Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0 has new state: POSTEXECUTE 2020-01-15 11:27:09,284 DEBUG Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0 doAfterExecute - success 2020-01-15 11:27:09,284 DEBUG Get Home Directory 3:0:0:0:0:0 Get Home Directory 3:0:0:0:0:0 has new state: EXECUTED 2020-01-15 11:27:09,284 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 Configure succeeded. (String Manipulation (Variable)) 2020-01-15 11:27:09,284 DEBUG Get Home Directory 3:0:0:0:0:0 String Manipulation (Variable) 3:0:0:0:0:15 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,284 DEBUG Get Home Directory 3:0:0:0:0:0 String Manipulation (Variable) 3:0:0:0:0:15 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,284 INFO File Reader 3:3:0:0:0:1 Preparing to read from 'file:/Users/jan/knime/workflow.properties'. 2020-01-15 11:27:09,287 DEBUG File Reader 3:0:0:0:0:1 Configure succeeded. (File Reader) 2020-01-15 11:27:09,287 DEBUG Get Home Directory 3:0:0:0:0:0 File Reader 3:0:0:0:0:1 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,287 DEBUG Regex Split 3:0:0:0:0:2 Configure succeeded. (Regex Split) 2020-01-15 11:27:09,287 DEBUG Get Home Directory 3:0:0:0:0:0 Regex Split 3:0:0:0:0:2 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,288 DEBUG Column Filter 3:0:0:0:0:3 Configure succeeded. (Column Filter) 2020-01-15 11:27:09,288 DEBUG Get Home Directory 3:0:0:0:0:0 Column Filter 3:0:0:0:0:3 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,288 DEBUG Column Rename 3:0:0:0:0:8 Configure succeeded. (Column Rename) 2020-01-15 11:27:09,288 DEBUG Get Home Directory 3:0:0:0:0:0 Column Rename 3:0:0:0:0:8 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,288 WARN Pivoting 3:0:0:0:0:6 No grouping column included. Aggregate complete table. 2020-01-15 11:27:09,288 DEBUG Pivoting 3:0:0:0:0:6 [value->First true] 2020-01-15 11:27:09,288 DEBUG Pivoting 3:0:0:0:0:6 [value->First true] 2020-01-15 11:27:09,288 DEBUG Pivoting 3:0:0:0:0:6 [value->First true] 2020-01-15 11:27:09,288 DEBUG Pivoting 3:0:0:0:0:6 Configure succeeded. (Pivoting) 2020-01-15 11:27:09,289 DEBUG Get Home Directory 3:0:0:0:0:0 Pivoting 3:0:0:0:0:6 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,290 DEBUG File Reader 3:8:0:0:0:1 File Reader 3:8:0:0:0:1 doBeforePreExecution 2020-01-15 11:27:09,290 DEBUG File Reader 3:8:0:0:0:1 File Reader 3:8:0:0:0:1 has new state: PREEXECUTE 2020-01-15 11:27:09,290 DEBUG File Reader 3:8:0:0:0:1 Adding handler 536f956d-0a19-4844-af11-5d64e7c799b7 (File Reader 3:8:0:0:0:1: ) - 25 in total 2020-01-15 11:27:09,290 DEBUG File Reader 3:8:0:0:0:1 File Reader 3:8:0:0:0:1 doBeforeExecution 2020-01-15 11:27:09,290 DEBUG File Reader 3:8:0:0:0:1 File Reader 3:8:0:0:0:1 has new state: EXECUTING 2020-01-15 11:27:09,290 DEBUG File Reader 3:8:0:0:0:1 File Reader 3:8:0:0:0:1 Start execute 2020-01-15 11:27:09,293 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 String Manipulation (Variable) 3:0:0:0:0:15 doBeforePreExecution 2020-01-15 11:27:09,293 DEBUG File Reader 3:3:0:0:0:1 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,293 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 String Manipulation (Variable) 3:0:0:0:0:15 has new state: PREEXECUTE 2020-01-15 11:27:09,295 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 Adding handler 7981c051-fa6d-42b4-b239-8e723716ddb5 (String Manipulation (Variable) 3:0:0:0:0:15: ) - 26 in total 2020-01-15 11:27:09,296 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 String Manipulation (Variable) 3:0:0:0:0:15 doBeforeExecution 2020-01-15 11:27:09,296 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 String Manipulation (Variable) 3:0:0:0:0:15 has new state: EXECUTING 2020-01-15 11:27:09,296 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 String Manipulation (Variable) 3:0:0:0:0:15 Start execute 2020-01-15 11:27:09,295 INFO File Reader 3:8:0:0:0:1 Preparing to read from 'file:/Users/jan/knime/workflow.properties'. 2020-01-15 11:27:09,300 INFO String Manipulation (Variable) 3:0:0:0:0:15 String Manipulation (Variable) 3:0:0:0:0:15 End execute (0 secs) 2020-01-15 11:27:09,301 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 String Manipulation (Variable) 3:0:0:0:0:15 doBeforePostExecution 2020-01-15 11:27:09,301 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 String Manipulation (Variable) 3:0:0:0:0:15 has new state: POSTEXECUTE 2020-01-15 11:27:09,301 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 String Manipulation (Variable) 3:0:0:0:0:15 doAfterExecute - success 2020-01-15 11:27:09,301 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 String Manipulation (Variable) 3:0:0:0:0:15 has new state: EXECUTED 2020-01-15 11:27:09,301 INFO File Reader 3:3:0:0:0:1 File Reader 3:3:0:0:0:1 End execute (0 secs) 2020-01-15 11:27:09,304 DEBUG File Reader 3:8:0:0:0:1 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,305 INFO File Reader 3:8:0:0:0:1 File Reader 3:8:0:0:0:1 End execute (0 secs) 2020-01-15 11:27:09,306 DEBUG File Reader 3:0:0:0:0:1 Configure succeeded. (File Reader) 2020-01-15 11:27:09,307 DEBUG String Manipulation (Variable) 3:0:0:0:0:15 File Reader 3:0:0:0:0:1 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,307 DEBUG File Reader 3:3:0:0:0:1 File Reader 3:3:0:0:0:1 doBeforePostExecution 2020-01-15 11:27:09,308 DEBUG File Reader 3:3:0:0:0:1 File Reader 3:3:0:0:0:1 has new state: POSTEXECUTE 2020-01-15 11:27:09,308 DEBUG File Reader 3:3:0:0:0:1 File Reader 3:3:0:0:0:1 doAfterExecute - success 2020-01-15 11:27:09,308 DEBUG File Reader 3:3:0:0:0:1 File Reader 3:3:0:0:0:1 has new state: EXECUTED 2020-01-15 11:27:09,309 DEBUG Regex Split 3:3:0:0:0:2 Configure succeeded. (Regex Split) 2020-01-15 11:27:09,309 DEBUG File Reader 3:3:0:0:0:1 Regex Split 3:3:0:0:0:2 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,309 DEBUG Column Filter 3:3:0:0:0:3 Configure succeeded. (Column Filter) 2020-01-15 11:27:09,309 DEBUG File Reader 3:8:0:0:0:1 File Reader 3:8:0:0:0:1 doBeforePostExecution 2020-01-15 11:27:09,309 DEBUG File Reader 3:8:0:0:0:1 File Reader 3:8:0:0:0:1 has new state: POSTEXECUTE 2020-01-15 11:27:09,309 DEBUG File Reader 3:8:0:0:0:1 File Reader 3:8:0:0:0:1 doAfterExecute - success 2020-01-15 11:27:09,309 DEBUG File Reader 3:8:0:0:0:1 File Reader 3:8:0:0:0:1 has new state: EXECUTED 2020-01-15 11:27:09,310 DEBUG Regex Split 3:8:0:0:0:2 Configure succeeded. (Regex Split) 2020-01-15 11:27:09,310 DEBUG File Reader 3:8:0:0:0:1 Regex Split 3:8:0:0:0:2 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,310 DEBUG Column Filter 3:8:0:0:0:3 Configure succeeded. (Column Filter) 2020-01-15 11:27:09,310 DEBUG File Reader 3:0:0:0:0:1 File Reader 3:0:0:0:0:1 doBeforePreExecution 2020-01-15 11:27:09,310 DEBUG File Reader 3:0:0:0:0:1 File Reader 3:0:0:0:0:1 has new state: PREEXECUTE 2020-01-15 11:27:09,310 DEBUG File Reader 3:0:0:0:0:1 Adding handler 59903ad1-b489-4040-8c31-bab6fdd79e20 (File Reader 3:0:0:0:0:1: ) - 27 in total 2020-01-15 11:27:09,310 DEBUG Regex Split 3:3:0:0:0:2 Regex Split 3:3:0:0:0:2 doBeforePreExecution 2020-01-15 11:27:09,310 DEBUG Regex Split 3:3:0:0:0:2 Regex Split 3:3:0:0:0:2 has new state: PREEXECUTE 2020-01-15 11:27:09,310 DEBUG Regex Split 3:3:0:0:0:2 Adding handler d6fec68e-85b3-4541-b1dd-cddea8c4f70a (Regex Split 3:3:0:0:0:2: ) - 28 in total 2020-01-15 11:27:09,310 DEBUG Regex Split 3:8:0:0:0:2 Regex Split 3:8:0:0:0:2 doBeforePreExecution 2020-01-15 11:27:09,310 DEBUG Regex Split 3:8:0:0:0:2 Regex Split 3:8:0:0:0:2 has new state: PREEXECUTE 2020-01-15 11:27:09,311 DEBUG File Reader 3:0:0:0:0:1 File Reader 3:0:0:0:0:1 doBeforeExecution 2020-01-15 11:27:09,311 DEBUG Regex Split 3:8:0:0:0:2 Adding handler e1189b1e-b287-40ea-ad30-b7bca3739edf (Regex Split 3:8:0:0:0:2: ) - 29 in total 2020-01-15 11:27:09,311 DEBUG File Reader 3:0:0:0:0:1 File Reader 3:0:0:0:0:1 has new state: EXECUTING 2020-01-15 11:27:09,311 DEBUG File Reader 3:0:0:0:0:1 File Reader 3:0:0:0:0:1 Start execute 2020-01-15 11:27:09,311 DEBUG Regex Split 3:3:0:0:0:2 Regex Split 3:3:0:0:0:2 doBeforeExecution 2020-01-15 11:27:09,311 DEBUG Regex Split 3:3:0:0:0:2 Regex Split 3:3:0:0:0:2 has new state: EXECUTING 2020-01-15 11:27:09,311 DEBUG Regex Split 3:3:0:0:0:2 Regex Split 3:3:0:0:0:2 Start execute 2020-01-15 11:27:09,311 DEBUG Regex Split 3:8:0:0:0:2 Regex Split 3:8:0:0:0:2 doBeforeExecution 2020-01-15 11:27:09,311 DEBUG Regex Split 3:8:0:0:0:2 Regex Split 3:8:0:0:0:2 has new state: EXECUTING 2020-01-15 11:27:09,311 DEBUG Regex Split 3:8:0:0:0:2 Regex Split 3:8:0:0:0:2 Start execute 2020-01-15 11:27:09,312 INFO File Reader 3:0:0:0:0:1 Preparing to read from 'file:/Users/jan/knime/workflow.properties'. 2020-01-15 11:27:09,312 DEBUG Regex Split 3:8:0:0:0:2 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,312 DEBUG Regex Split 3:3:0:0:0:2 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,321 INFO Regex Split 3:3:0:0:0:2 Regex Split 3:3:0:0:0:2 End execute (0 secs) 2020-01-15 11:27:09,321 DEBUG Regex Split 3:3:0:0:0:2 Regex Split 3:3:0:0:0:2 doBeforePostExecution 2020-01-15 11:27:09,321 DEBUG Regex Split 3:3:0:0:0:2 Regex Split 3:3:0:0:0:2 has new state: POSTEXECUTE 2020-01-15 11:27:09,321 DEBUG Regex Split 3:3:0:0:0:2 Regex Split 3:3:0:0:0:2 doAfterExecute - success 2020-01-15 11:27:09,321 DEBUG Regex Split 3:3:0:0:0:2 Regex Split 3:3:0:0:0:2 has new state: EXECUTED 2020-01-15 11:27:09,322 INFO Regex Split 3:8:0:0:0:2 Regex Split 3:8:0:0:0:2 End execute (0 secs) 2020-01-15 11:27:09,322 DEBUG Column Filter 3:3:0:0:0:3 Configure succeeded. (Column Filter) 2020-01-15 11:27:09,322 DEBUG Regex Split 3:3:0:0:0:2 Column Filter 3:3:0:0:0:3 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,322 DEBUG Column Rename 3:3:0:0:0:8 Configure succeeded. (Column Rename) 2020-01-15 11:27:09,322 WARN Pivoting 3:3:0:0:0:6 No grouping column included. Aggregate complete table. 2020-01-15 11:27:09,322 DEBUG Pivoting 3:3:0:0:0:6 [value->First true] 2020-01-15 11:27:09,323 DEBUG Pivoting 3:3:0:0:0:6 [value->First true] 2020-01-15 11:27:09,323 DEBUG Pivoting 3:3:0:0:0:6 [value->First true] 2020-01-15 11:27:09,323 DEBUG Pivoting 3:3:0:0:0:6 Configure succeeded. (Pivoting) 2020-01-15 11:27:09,323 DEBUG File Reader 3:0:0:0:0:1 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,323 DEBUG Regex Split 3:8:0:0:0:2 Regex Split 3:8:0:0:0:2 doBeforePostExecution 2020-01-15 11:27:09,323 DEBUG Regex Split 3:8:0:0:0:2 Regex Split 3:8:0:0:0:2 has new state: POSTEXECUTE 2020-01-15 11:27:09,323 DEBUG Regex Split 3:8:0:0:0:2 Regex Split 3:8:0:0:0:2 doAfterExecute - success 2020-01-15 11:27:09,323 DEBUG Regex Split 3:8:0:0:0:2 Regex Split 3:8:0:0:0:2 has new state: EXECUTED 2020-01-15 11:27:09,324 DEBUG Column Filter 3:8:0:0:0:3 Configure succeeded. (Column Filter) 2020-01-15 11:27:09,324 DEBUG Regex Split 3:8:0:0:0:2 Column Filter 3:8:0:0:0:3 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,324 DEBUG Column Rename 3:8:0:0:0:8 Configure succeeded. (Column Rename) 2020-01-15 11:27:09,324 WARN Pivoting 3:8:0:0:0:6 No grouping column included. Aggregate complete table. 2020-01-15 11:27:09,324 DEBUG Pivoting 3:8:0:0:0:6 [value->First true] 2020-01-15 11:27:09,324 INFO File Reader 3:0:0:0:0:1 File Reader 3:0:0:0:0:1 End execute (0 secs) 2020-01-15 11:27:09,324 DEBUG Pivoting 3:8:0:0:0:6 [value->First true] 2020-01-15 11:27:09,324 DEBUG Pivoting 3:8:0:0:0:6 [value->First true] 2020-01-15 11:27:09,324 DEBUG Pivoting 3:8:0:0:0:6 Configure succeeded. (Pivoting) 2020-01-15 11:27:09,324 DEBUG Column Filter 3:3:0:0:0:3 Column Filter 3:3:0:0:0:3 doBeforePreExecution 2020-01-15 11:27:09,324 DEBUG Column Filter 3:3:0:0:0:3 Column Filter 3:3:0:0:0:3 has new state: PREEXECUTE 2020-01-15 11:27:09,325 DEBUG Column Filter 3:3:0:0:0:3 Adding handler e9e05813-4846-4180-955d-bb0d8dd93f95 (Column Filter 3:3:0:0:0:3: ) - 30 in total 2020-01-15 11:27:09,325 DEBUG Column Filter 3:8:0:0:0:3 Column Filter 3:8:0:0:0:3 doBeforePreExecution 2020-01-15 11:27:09,325 DEBUG Column Filter 3:8:0:0:0:3 Column Filter 3:8:0:0:0:3 has new state: PREEXECUTE 2020-01-15 11:27:09,325 DEBUG File Reader 3:0:0:0:0:1 File Reader 3:0:0:0:0:1 doBeforePostExecution 2020-01-15 11:27:09,325 DEBUG Column Filter 3:8:0:0:0:3 Adding handler 90890c52-1e9d-4988-ac10-63405ffeb6b5 (Column Filter 3:8:0:0:0:3: ) - 31 in total 2020-01-15 11:27:09,325 DEBUG File Reader 3:0:0:0:0:1 File Reader 3:0:0:0:0:1 has new state: POSTEXECUTE 2020-01-15 11:27:09,325 DEBUG File Reader 3:0:0:0:0:1 File Reader 3:0:0:0:0:1 doAfterExecute - success 2020-01-15 11:27:09,325 DEBUG File Reader 3:0:0:0:0:1 File Reader 3:0:0:0:0:1 has new state: EXECUTED 2020-01-15 11:27:09,325 DEBUG Regex Split 3:0:0:0:0:2 Configure succeeded. (Regex Split) 2020-01-15 11:27:09,325 DEBUG File Reader 3:0:0:0:0:1 Regex Split 3:0:0:0:0:2 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,326 DEBUG Column Filter 3:0:0:0:0:3 Configure succeeded. (Column Filter) 2020-01-15 11:27:09,326 DEBUG Column Filter 3:3:0:0:0:3 Column Filter 3:3:0:0:0:3 doBeforeExecution 2020-01-15 11:27:09,326 DEBUG Column Filter 3:3:0:0:0:3 Column Filter 3:3:0:0:0:3 has new state: EXECUTING 2020-01-15 11:27:09,326 DEBUG Column Filter 3:3:0:0:0:3 Column Filter 3:3:0:0:0:3 Start execute 2020-01-15 11:27:09,326 DEBUG Column Filter 3:8:0:0:0:3 Column Filter 3:8:0:0:0:3 doBeforeExecution 2020-01-15 11:27:09,326 DEBUG Column Filter 3:8:0:0:0:3 Column Filter 3:8:0:0:0:3 has new state: EXECUTING 2020-01-15 11:27:09,326 DEBUG Column Filter 3:8:0:0:0:3 Column Filter 3:8:0:0:0:3 Start execute 2020-01-15 11:27:09,326 INFO Column Filter 3:3:0:0:0:3 Column Filter 3:3:0:0:0:3 End execute (0 secs) 2020-01-15 11:27:09,326 DEBUG Regex Split 3:0:0:0:0:2 Regex Split 3:0:0:0:0:2 doBeforePreExecution 2020-01-15 11:27:09,326 INFO Column Filter 3:8:0:0:0:3 Column Filter 3:8:0:0:0:3 End execute (0 secs) 2020-01-15 11:27:09,326 DEBUG Regex Split 3:0:0:0:0:2 Regex Split 3:0:0:0:0:2 has new state: PREEXECUTE 2020-01-15 11:27:09,326 DEBUG Column Filter 3:3:0:0:0:3 Column Filter 3:3:0:0:0:3 doBeforePostExecution 2020-01-15 11:27:09,327 DEBUG Regex Split 3:0:0:0:0:2 Adding handler 4392dd50-3bd3-4f1f-aa21-617928641766 (Regex Split 3:0:0:0:0:2: ) - 32 in total 2020-01-15 11:27:09,327 DEBUG Column Filter 3:3:0:0:0:3 Column Filter 3:3:0:0:0:3 has new state: POSTEXECUTE 2020-01-15 11:27:09,327 DEBUG Column Filter 3:3:0:0:0:3 Column Filter 3:3:0:0:0:3 doAfterExecute - success 2020-01-15 11:27:09,327 DEBUG Column Filter 3:3:0:0:0:3 Column Filter 3:3:0:0:0:3 has new state: EXECUTED 2020-01-15 11:27:09,327 DEBUG Column Rename 3:3:0:0:0:8 Configure succeeded. (Column Rename) 2020-01-15 11:27:09,327 DEBUG Column Filter 3:3:0:0:0:3 Column Rename 3:3:0:0:0:8 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,327 DEBUG Column Filter 3:8:0:0:0:3 Column Filter 3:8:0:0:0:3 doBeforePostExecution 2020-01-15 11:27:09,327 DEBUG Column Filter 3:8:0:0:0:3 Column Filter 3:8:0:0:0:3 has new state: POSTEXECUTE 2020-01-15 11:27:09,327 DEBUG Column Filter 3:8:0:0:0:3 Column Filter 3:8:0:0:0:3 doAfterExecute - success 2020-01-15 11:27:09,327 DEBUG Column Filter 3:8:0:0:0:3 Column Filter 3:8:0:0:0:3 has new state: EXECUTED 2020-01-15 11:27:09,328 DEBUG Column Rename 3:8:0:0:0:8 Configure succeeded. (Column Rename) 2020-01-15 11:27:09,328 DEBUG Column Filter 3:8:0:0:0:3 Column Rename 3:8:0:0:0:8 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,328 DEBUG Regex Split 3:0:0:0:0:2 Regex Split 3:0:0:0:0:2 doBeforeExecution 2020-01-15 11:27:09,328 DEBUG Regex Split 3:0:0:0:0:2 Regex Split 3:0:0:0:0:2 has new state: EXECUTING 2020-01-15 11:27:09,328 DEBUG Regex Split 3:0:0:0:0:2 Regex Split 3:0:0:0:0:2 Start execute 2020-01-15 11:27:09,328 DEBUG Column Rename 3:3:0:0:0:8 Column Rename 3:3:0:0:0:8 doBeforePreExecution 2020-01-15 11:27:09,328 DEBUG Column Rename 3:3:0:0:0:8 Column Rename 3:3:0:0:0:8 has new state: PREEXECUTE 2020-01-15 11:27:09,328 DEBUG Column Rename 3:8:0:0:0:8 Column Rename 3:8:0:0:0:8 doBeforePreExecution 2020-01-15 11:27:09,328 DEBUG Column Rename 3:3:0:0:0:8 Adding handler f6d76ece-13e4-462c-9dd3-ca0c2666f6b6 (Column Rename 3:3:0:0:0:8: ) - 33 in total 2020-01-15 11:27:09,328 DEBUG Column Rename 3:8:0:0:0:8 Column Rename 3:8:0:0:0:8 has new state: PREEXECUTE 2020-01-15 11:27:09,328 DEBUG Column Rename 3:8:0:0:0:8 Adding handler 7c984f58-2ede-4beb-8ea8-012ecc951256 (Column Rename 3:8:0:0:0:8: ) - 34 in total 2020-01-15 11:27:09,328 DEBUG Column Rename 3:3:0:0:0:8 Column Rename 3:3:0:0:0:8 doBeforeExecution 2020-01-15 11:27:09,328 DEBUG Column Rename 3:3:0:0:0:8 Column Rename 3:3:0:0:0:8 has new state: EXECUTING 2020-01-15 11:27:09,328 DEBUG Column Rename 3:3:0:0:0:8 Column Rename 3:3:0:0:0:8 Start execute 2020-01-15 11:27:09,328 DEBUG Column Rename 3:8:0:0:0:8 Column Rename 3:8:0:0:0:8 doBeforeExecution 2020-01-15 11:27:09,329 DEBUG Column Rename 3:8:0:0:0:8 Column Rename 3:8:0:0:0:8 has new state: EXECUTING 2020-01-15 11:27:09,329 DEBUG Regex Split 3:0:0:0:0:2 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,329 DEBUG Column Rename 3:8:0:0:0:8 Column Rename 3:8:0:0:0:8 Start execute 2020-01-15 11:27:09,329 INFO Column Rename 3:8:0:0:0:8 Column Rename 3:8:0:0:0:8 End execute (0 secs) 2020-01-15 11:27:09,329 INFO Column Rename 3:3:0:0:0:8 Column Rename 3:3:0:0:0:8 End execute (0 secs) 2020-01-15 11:27:09,330 DEBUG Column Rename 3:8:0:0:0:8 Column Rename 3:8:0:0:0:8 doBeforePostExecution 2020-01-15 11:27:09,330 DEBUG Column Rename 3:8:0:0:0:8 Column Rename 3:8:0:0:0:8 has new state: POSTEXECUTE 2020-01-15 11:27:09,330 DEBUG Column Rename 3:8:0:0:0:8 Column Rename 3:8:0:0:0:8 doAfterExecute - success 2020-01-15 11:27:09,330 DEBUG Column Rename 3:8:0:0:0:8 Column Rename 3:8:0:0:0:8 has new state: EXECUTED 2020-01-15 11:27:09,331 INFO Regex Split 3:0:0:0:0:2 Regex Split 3:0:0:0:0:2 End execute (0 secs) 2020-01-15 11:27:09,331 WARN Pivoting 3:8:0:0:0:6 No grouping column included. Aggregate complete table. 2020-01-15 11:27:09,331 DEBUG Pivoting 3:8:0:0:0:6 [value->First true] 2020-01-15 11:27:09,332 DEBUG Pivoting 3:8:0:0:0:6 [value->First true] 2020-01-15 11:27:09,332 DEBUG Pivoting 3:8:0:0:0:6 [value->First true] 2020-01-15 11:27:09,332 DEBUG Pivoting 3:8:0:0:0:6 Configure succeeded. (Pivoting) 2020-01-15 11:27:09,332 DEBUG Column Rename 3:8:0:0:0:8 Pivoting 3:8:0:0:0:6 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,332 DEBUG Column Rename 3:3:0:0:0:8 Column Rename 3:3:0:0:0:8 doBeforePostExecution 2020-01-15 11:27:09,332 DEBUG Column Rename 3:3:0:0:0:8 Column Rename 3:3:0:0:0:8 has new state: POSTEXECUTE 2020-01-15 11:27:09,332 DEBUG Column Rename 3:3:0:0:0:8 Column Rename 3:3:0:0:0:8 doAfterExecute - success 2020-01-15 11:27:09,332 DEBUG Column Rename 3:3:0:0:0:8 Column Rename 3:3:0:0:0:8 has new state: EXECUTED 2020-01-15 11:27:09,332 WARN Pivoting 3:3:0:0:0:6 No grouping column included. Aggregate complete table. 2020-01-15 11:27:09,333 DEBUG Pivoting 3:3:0:0:0:6 [value->First true] 2020-01-15 11:27:09,333 DEBUG Pivoting 3:3:0:0:0:6 [value->First true] 2020-01-15 11:27:09,333 DEBUG Pivoting 3:3:0:0:0:6 [value->First true] 2020-01-15 11:27:09,333 DEBUG Pivoting 3:3:0:0:0:6 Configure succeeded. (Pivoting) 2020-01-15 11:27:09,333 DEBUG Column Rename 3:3:0:0:0:8 Pivoting 3:3:0:0:0:6 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,333 DEBUG Pivoting 3:3:0:0:0:6 Pivoting 3:3:0:0:0:6 doBeforePreExecution 2020-01-15 11:27:09,333 DEBUG Pivoting 3:3:0:0:0:6 Pivoting 3:3:0:0:0:6 has new state: PREEXECUTE 2020-01-15 11:27:09,334 DEBUG Pivoting 3:3:0:0:0:6 Adding handler 9fcb4f24-9656-4619-b9cc-82b076ecf68f (Pivoting 3:3:0:0:0:6: ) - 35 in total 2020-01-15 11:27:09,334 DEBUG Pivoting 3:3:0:0:0:6 Pivoting 3:3:0:0:0:6 doBeforeExecution 2020-01-15 11:27:09,334 DEBUG Pivoting 3:3:0:0:0:6 Pivoting 3:3:0:0:0:6 has new state: EXECUTING 2020-01-15 11:27:09,334 DEBUG Pivoting 3:3:0:0:0:6 Pivoting 3:3:0:0:0:6 Start execute 2020-01-15 11:27:09,334 DEBUG Regex Split 3:0:0:0:0:2 Regex Split 3:0:0:0:0:2 doBeforePostExecution 2020-01-15 11:27:09,334 DEBUG Regex Split 3:0:0:0:0:2 Regex Split 3:0:0:0:0:2 has new state: POSTEXECUTE 2020-01-15 11:27:09,334 DEBUG Regex Split 3:0:0:0:0:2 Regex Split 3:0:0:0:0:2 doAfterExecute - success 2020-01-15 11:27:09,334 DEBUG Regex Split 3:0:0:0:0:2 Regex Split 3:0:0:0:0:2 has new state: EXECUTED 2020-01-15 11:27:09,335 DEBUG Column Filter 3:0:0:0:0:3 Configure succeeded. (Column Filter) 2020-01-15 11:27:09,335 DEBUG Regex Split 3:0:0:0:0:2 Column Filter 3:0:0:0:0:3 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,335 DEBUG Column Rename 3:0:0:0:0:8 Configure succeeded. (Column Rename) 2020-01-15 11:27:09,335 WARN Pivoting 3:0:0:0:0:6 No grouping column included. Aggregate complete table. 2020-01-15 11:27:09,335 DEBUG Pivoting 3:0:0:0:0:6 [value->First true] 2020-01-15 11:27:09,336 DEBUG Pivoting 3:0:0:0:0:6 [value->First true] 2020-01-15 11:27:09,336 DEBUG Pivoting 3:0:0:0:0:6 [value->First true] 2020-01-15 11:27:09,336 DEBUG Pivoting 3:0:0:0:0:6 Configure succeeded. (Pivoting) 2020-01-15 11:27:09,336 DEBUG Pivoting 3:8:0:0:0:6 Pivoting 3:8:0:0:0:6 doBeforePreExecution 2020-01-15 11:27:09,336 DEBUG Pivoting 3:8:0:0:0:6 Pivoting 3:8:0:0:0:6 has new state: PREEXECUTE 2020-01-15 11:27:09,337 DEBUG Pivoting 3:3:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,337 DEBUG Pivoting 3:8:0:0:0:6 Adding handler f588142e-dc2b-48c1-bbe2-9207b4d049d4 (Pivoting 3:8:0:0:0:6: ) - 36 in total 2020-01-15 11:27:09,338 DEBUG Pivoting 3:8:0:0:0:6 Pivoting 3:8:0:0:0:6 doBeforeExecution 2020-01-15 11:27:09,338 DEBUG Pivoting 3:8:0:0:0:6 Pivoting 3:8:0:0:0:6 has new state: EXECUTING 2020-01-15 11:27:09,338 DEBUG Pivoting 3:8:0:0:0:6 Pivoting 3:8:0:0:0:6 Start execute 2020-01-15 11:27:09,338 DEBUG Column Filter 3:0:0:0:0:3 Column Filter 3:0:0:0:0:3 doBeforePreExecution 2020-01-15 11:27:09,339 DEBUG Column Filter 3:0:0:0:0:3 Column Filter 3:0:0:0:0:3 has new state: PREEXECUTE 2020-01-15 11:27:09,339 DEBUG Column Filter 3:0:0:0:0:3 Adding handler 8844d04e-9b9a-4842-8300-4acd89fa05b2 (Column Filter 3:0:0:0:0:3: ) - 37 in total 2020-01-15 11:27:09,339 DEBUG Column Filter 3:0:0:0:0:3 Column Filter 3:0:0:0:0:3 doBeforeExecution 2020-01-15 11:27:09,339 DEBUG Column Filter 3:0:0:0:0:3 Column Filter 3:0:0:0:0:3 has new state: EXECUTING 2020-01-15 11:27:09,339 DEBUG Column Filter 3:0:0:0:0:3 Column Filter 3:0:0:0:0:3 Start execute 2020-01-15 11:27:09,339 INFO Column Filter 3:0:0:0:0:3 Column Filter 3:0:0:0:0:3 End execute (0 secs) 2020-01-15 11:27:09,339 DEBUG Column Filter 3:0:0:0:0:3 Column Filter 3:0:0:0:0:3 doBeforePostExecution 2020-01-15 11:27:09,339 DEBUG Column Filter 3:0:0:0:0:3 Column Filter 3:0:0:0:0:3 has new state: POSTEXECUTE 2020-01-15 11:27:09,340 DEBUG Column Filter 3:0:0:0:0:3 Column Filter 3:0:0:0:0:3 doAfterExecute - success 2020-01-15 11:27:09,340 DEBUG Pivoting 3:3:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,340 DEBUG Column Filter 3:0:0:0:0:3 Column Filter 3:0:0:0:0:3 has new state: EXECUTED 2020-01-15 11:27:09,340 DEBUG Column Rename 3:0:0:0:0:8 Configure succeeded. (Column Rename) 2020-01-15 11:27:09,340 DEBUG Column Filter 3:0:0:0:0:3 Column Rename 3:0:0:0:0:8 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,341 DEBUG Pivoting 3:8:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,341 DEBUG Column Rename 3:0:0:0:0:8 Column Rename 3:0:0:0:0:8 doBeforePreExecution 2020-01-15 11:27:09,341 DEBUG Column Rename 3:0:0:0:0:8 Column Rename 3:0:0:0:0:8 has new state: PREEXECUTE 2020-01-15 11:27:09,378 DEBUG Column Rename 3:0:0:0:0:8 Adding handler c484269f-cac2-4e8b-ba80-d596e7fbb79b (Column Rename 3:0:0:0:0:8: ) - 38 in total 2020-01-15 11:27:09,378 DEBUG Column Rename 3:0:0:0:0:8 Column Rename 3:0:0:0:0:8 doBeforeExecution 2020-01-15 11:27:09,378 DEBUG Column Rename 3:0:0:0:0:8 Column Rename 3:0:0:0:0:8 has new state: EXECUTING 2020-01-15 11:27:09,378 DEBUG Pivoting 3:8:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,378 DEBUG Column Rename 3:0:0:0:0:8 Column Rename 3:0:0:0:0:8 Start execute 2020-01-15 11:27:09,378 DEBUG Pivoting 3:3:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,379 INFO Column Rename 3:0:0:0:0:8 Column Rename 3:0:0:0:0:8 End execute (0 secs) 2020-01-15 11:27:09,379 DEBUG Column Rename 3:0:0:0:0:8 Column Rename 3:0:0:0:0:8 doBeforePostExecution 2020-01-15 11:27:09,379 DEBUG Column Rename 3:0:0:0:0:8 Column Rename 3:0:0:0:0:8 has new state: POSTEXECUTE 2020-01-15 11:27:09,379 DEBUG Column Rename 3:0:0:0:0:8 Column Rename 3:0:0:0:0:8 doAfterExecute - success 2020-01-15 11:27:09,379 DEBUG Column Rename 3:0:0:0:0:8 Column Rename 3:0:0:0:0:8 has new state: EXECUTED 2020-01-15 11:27:09,380 WARN Pivoting 3:0:0:0:0:6 No grouping column included. Aggregate complete table. 2020-01-15 11:27:09,381 DEBUG Pivoting 3:8:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,381 DEBUG Pivoting 3:0:0:0:0:6 [value->First true] 2020-01-15 11:27:09,382 DEBUG Pivoting 3:0:0:0:0:6 [value->First true] 2020-01-15 11:27:09,382 DEBUG Pivoting 3:0:0:0:0:6 [value->First true] 2020-01-15 11:27:09,382 DEBUG Pivoting 3:0:0:0:0:6 Configure succeeded. (Pivoting) 2020-01-15 11:27:09,382 DEBUG Column Rename 3:0:0:0:0:8 Pivoting 3:0:0:0:0:6 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,385 DEBUG Pivoting 3:3:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,386 DEBUG Pivoting 3:0:0:0:0:6 Pivoting 3:0:0:0:0:6 doBeforePreExecution 2020-01-15 11:27:09,386 DEBUG Pivoting 3:0:0:0:0:6 Pivoting 3:0:0:0:0:6 has new state: PREEXECUTE 2020-01-15 11:27:09,388 DEBUG Pivoting 3:0:0:0:0:6 Adding handler 929a4824-904c-4700-ab85-18c7739f44a9 (Pivoting 3:0:0:0:0:6: ) - 39 in total 2020-01-15 11:27:09,388 DEBUG Pivoting 3:0:0:0:0:6 Pivoting 3:0:0:0:0:6 doBeforeExecution 2020-01-15 11:27:09,388 DEBUG Pivoting 3:0:0:0:0:6 Pivoting 3:0:0:0:0:6 has new state: EXECUTING 2020-01-15 11:27:09,388 DEBUG Pivoting 3:0:0:0:0:6 Pivoting 3:0:0:0:0:6 Start execute 2020-01-15 11:27:09,388 DEBUG Pivoting 3:8:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,389 DEBUG Pivoting 3:0:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,393 DEBUG Pivoting 3:3:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,403 DEBUG Pivoting 3:3:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,405 DEBUG Pivoting 3:0:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,405 DEBUG Pivoting 3:8:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,407 DEBUG Pivoting 3:3:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,410 DEBUG Pivoting 3:8:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,415 DEBUG Pivoting 3:3:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,415 DEBUG Pivoting 3:0:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,425 INFO Pivoting 3:3:0:0:0:6 Pivoting 3:3:0:0:0:6 End execute (0 secs) 2020-01-15 11:27:09,425 DEBUG Pivoting 3:3:0:0:0:6 Pivoting 3:3:0:0:0:6 doBeforePostExecution 2020-01-15 11:27:09,425 DEBUG Pivoting 3:3:0:0:0:6 Pivoting 3:3:0:0:0:6 has new state: POSTEXECUTE 2020-01-15 11:27:09,425 DEBUG Pivoting 3:3:0:0:0:6 Pivoting 3:3:0:0:0:6 doAfterExecute - success 2020-01-15 11:27:09,425 DEBUG Pivoting 3:3:0:0:0:6 Pivoting 3:3:0:0:0:6 has new state: EXECUTED 2020-01-15 11:27:09,426 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Configure succeeded. (Column Rename (Regex)) 2020-01-15 11:27:09,426 DEBUG Pivoting 3:3:0:0:0:6 Column Rename (Regex) 3:3:0:0:0:9 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,426 DEBUG Pivoting 3:3:0:0:0:6 Column Rename (Regex) 3:3:0:0:0:9 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,427 DEBUG Pivoting 3:8:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,427 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Configure succeeded. (Table Row to Variable (deprecated)) 2020-01-15 11:27:09,427 DEBUG Pivoting 3:3:0:0:0:6 Table Row to Variable (deprecated) 3:3:0:0:0:7 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,427 DEBUG Pivoting 3:0:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,428 DEBUG Component Output 3:3:0:0:0:14 Configure succeeded. (Component Output) 2020-01-15 11:27:09,428 DEBUG Pivoting 3:3:0:0:0:6 Component Output 3:3:0:0:0:14 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,429 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Column Rename (Regex) 3:3:0:0:0:9 doBeforePreExecution 2020-01-15 11:27:09,429 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Column Rename (Regex) 3:3:0:0:0:9 has new state: PREEXECUTE 2020-01-15 11:27:09,429 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Adding handler af3b9e3a-1dbd-46c7-9d88-db1f4e6dfc26 (Column Rename (Regex) 3:3:0:0:0:9: ) - 40 in total 2020-01-15 11:27:09,429 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Column Rename (Regex) 3:3:0:0:0:9 doBeforeExecution 2020-01-15 11:27:09,430 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Column Rename (Regex) 3:3:0:0:0:9 has new state: EXECUTING 2020-01-15 11:27:09,430 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Column Rename (Regex) 3:3:0:0:0:9 Start execute 2020-01-15 11:27:09,431 INFO Column Rename (Regex) 3:3:0:0:0:9 Column Rename (Regex) 3:3:0:0:0:9 End execute (0 secs) 2020-01-15 11:27:09,432 DEBUG Pivoting 3:0:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,432 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Column Rename (Regex) 3:3:0:0:0:9 doBeforePostExecution 2020-01-15 11:27:09,432 DEBUG Pivoting 3:8:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,432 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Column Rename (Regex) 3:3:0:0:0:9 has new state: POSTEXECUTE 2020-01-15 11:27:09,432 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Column Rename (Regex) 3:3:0:0:0:9 doAfterExecute - success 2020-01-15 11:27:09,432 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Column Rename (Regex) 3:3:0:0:0:9 has new state: EXECUTED 2020-01-15 11:27:09,432 INFO Pivoting 3:8:0:0:0:6 Pivoting 3:8:0:0:0:6 End execute (0 secs) 2020-01-15 11:27:09,433 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Configure succeeded. (Table Row to Variable (deprecated)) 2020-01-15 11:27:09,433 DEBUG Column Rename (Regex) 3:3:0:0:0:9 Table Row to Variable (deprecated) 3:3:0:0:0:7 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,433 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Table Row to Variable (deprecated) 3:3:0:0:0:7 doBeforePreExecution 2020-01-15 11:27:09,433 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Table Row to Variable (deprecated) 3:3:0:0:0:7 has new state: PREEXECUTE 2020-01-15 11:27:09,433 DEBUG Pivoting 3:8:0:0:0:6 Pivoting 3:8:0:0:0:6 doBeforePostExecution 2020-01-15 11:27:09,433 DEBUG Pivoting 3:8:0:0:0:6 Pivoting 3:8:0:0:0:6 has new state: POSTEXECUTE 2020-01-15 11:27:09,433 DEBUG Pivoting 3:8:0:0:0:6 Pivoting 3:8:0:0:0:6 doAfterExecute - success 2020-01-15 11:27:09,433 DEBUG Pivoting 3:8:0:0:0:6 Pivoting 3:8:0:0:0:6 has new state: EXECUTED 2020-01-15 11:27:09,434 DEBUG Pivoting 3:0:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,434 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Configure succeeded. (Column Rename (Regex)) 2020-01-15 11:27:09,434 DEBUG Pivoting 3:8:0:0:0:6 Column Rename (Regex) 3:8:0:0:0:9 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,434 DEBUG Pivoting 3:8:0:0:0:6 Column Rename (Regex) 3:8:0:0:0:9 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,435 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Configure succeeded. (Table Row to Variable (deprecated)) 2020-01-15 11:27:09,435 DEBUG Pivoting 3:8:0:0:0:6 Table Row to Variable (deprecated) 3:8:0:0:0:7 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,435 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Adding handler c80307d1-4d11-49b1-ad97-b1edda280702 (Table Row to Variable (deprecated) 3:3:0:0:0:7: ) - 41 in total 2020-01-15 11:27:09,436 DEBUG Component Output 3:8:0:0:0:14 Configure succeeded. (Component Output) 2020-01-15 11:27:09,436 DEBUG Pivoting 3:8:0:0:0:6 Component Output 3:8:0:0:0:14 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,436 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Column Rename (Regex) 3:8:0:0:0:9 doBeforePreExecution 2020-01-15 11:27:09,436 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Column Rename (Regex) 3:8:0:0:0:9 has new state: PREEXECUTE 2020-01-15 11:27:09,436 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Table Row to Variable (deprecated) 3:3:0:0:0:7 doBeforeExecution 2020-01-15 11:27:09,436 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Adding handler 496af57a-bd22-44a3-92c8-32b8785e23cb (Column Rename (Regex) 3:8:0:0:0:9: ) - 42 in total 2020-01-15 11:27:09,436 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Table Row to Variable (deprecated) 3:3:0:0:0:7 has new state: EXECUTING 2020-01-15 11:27:09,436 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Table Row to Variable (deprecated) 3:3:0:0:0:7 Start execute 2020-01-15 11:27:09,437 INFO Table Row to Variable (deprecated) 3:3:0:0:0:7 Table Row to Variable (deprecated) 3:3:0:0:0:7 End execute (0 secs) 2020-01-15 11:27:09,437 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Table Row to Variable (deprecated) 3:3:0:0:0:7 doBeforePostExecution 2020-01-15 11:27:09,437 DEBUG Pivoting 3:0:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,437 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Table Row to Variable (deprecated) 3:3:0:0:0:7 has new state: POSTEXECUTE 2020-01-15 11:27:09,437 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Table Row to Variable (deprecated) 3:3:0:0:0:7 doAfterExecute - success 2020-01-15 11:27:09,437 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Table Row to Variable (deprecated) 3:3:0:0:0:7 has new state: EXECUTED 2020-01-15 11:27:09,438 DEBUG Component Output 3:3:0:0:0:14 Configure succeeded. (Component Output) 2020-01-15 11:27:09,438 DEBUG Table Row to Variable (deprecated) 3:3:0:0:0:7 Component Output 3:3:0:0:0:14 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,438 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Column Rename (Regex) 3:8:0:0:0:9 doBeforeExecution 2020-01-15 11:27:09,438 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Column Rename (Regex) 3:8:0:0:0:9 has new state: EXECUTING 2020-01-15 11:27:09,438 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Column Rename (Regex) 3:8:0:0:0:9 Start execute 2020-01-15 11:27:09,439 INFO Column Rename (Regex) 3:8:0:0:0:9 Column Rename (Regex) 3:8:0:0:0:9 End execute (0 secs) 2020-01-15 11:27:09,439 DEBUG Component Output 3:3:0:0:0:14 Component Output 3:3:0:0:0:14 doBeforePreExecution 2020-01-15 11:27:09,439 DEBUG Component Output 3:3:0:0:0:14 Component Output 3:3:0:0:0:14 has new state: PREEXECUTE 2020-01-15 11:27:09,439 DEBUG Pivoting 3:0:0:0:0:6 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,439 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Column Rename (Regex) 3:8:0:0:0:9 doBeforePostExecution 2020-01-15 11:27:09,439 DEBUG Component Output 3:3:0:0:0:14 Adding handler bfde97ff-1e4f-46a3-85c8-392fc5ff2bb6 (Component Output 3:3:0:0:0:14: ) - 43 in total 2020-01-15 11:27:09,439 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Column Rename (Regex) 3:8:0:0:0:9 has new state: POSTEXECUTE 2020-01-15 11:27:09,439 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Column Rename (Regex) 3:8:0:0:0:9 doAfterExecute - success 2020-01-15 11:27:09,439 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Column Rename (Regex) 3:8:0:0:0:9 has new state: EXECUTED 2020-01-15 11:27:09,439 INFO Pivoting 3:0:0:0:0:6 Pivoting 3:0:0:0:0:6 End execute (0 secs) 2020-01-15 11:27:09,440 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Configure succeeded. (Table Row to Variable (deprecated)) 2020-01-15 11:27:09,440 DEBUG Column Rename (Regex) 3:8:0:0:0:9 Table Row to Variable (deprecated) 3:8:0:0:0:7 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,440 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Table Row to Variable (deprecated) 3:8:0:0:0:7 doBeforePreExecution 2020-01-15 11:27:09,440 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Table Row to Variable (deprecated) 3:8:0:0:0:7 has new state: PREEXECUTE 2020-01-15 11:27:09,440 DEBUG Component Output 3:3:0:0:0:14 Component Output 3:3:0:0:0:14 doBeforeExecution 2020-01-15 11:27:09,440 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Adding handler 4c402c60-00fe-4482-8a9c-70a7f14eb587 (Table Row to Variable (deprecated) 3:8:0:0:0:7: ) - 44 in total 2020-01-15 11:27:09,440 DEBUG Component Output 3:3:0:0:0:14 Component Output 3:3:0:0:0:14 has new state: EXECUTING 2020-01-15 11:27:09,440 DEBUG Component Output 3:3:0:0:0:14 Component Output 3:3:0:0:0:14 Start execute 2020-01-15 11:27:09,441 DEBUG Pivoting 3:0:0:0:0:6 Pivoting 3:0:0:0:0:6 doBeforePostExecution 2020-01-15 11:27:09,441 DEBUG Pivoting 3:0:0:0:0:6 Pivoting 3:0:0:0:0:6 has new state: POSTEXECUTE 2020-01-15 11:27:09,441 DEBUG Pivoting 3:0:0:0:0:6 Pivoting 3:0:0:0:0:6 doAfterExecute - success 2020-01-15 11:27:09,441 DEBUG Pivoting 3:0:0:0:0:6 Pivoting 3:0:0:0:0:6 has new state: EXECUTED 2020-01-15 11:27:09,441 INFO Component Output 3:3:0:0:0:14 Component Output 3:3:0:0:0:14 End execute (0 secs) 2020-01-15 11:27:09,442 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Configure succeeded. (Column Rename (Regex)) 2020-01-15 11:27:09,442 DEBUG Pivoting 3:0:0:0:0:6 Column Rename (Regex) 3:0:0:0:0:9 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,442 DEBUG Pivoting 3:0:0:0:0:6 Column Rename (Regex) 3:0:0:0:0:9 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,442 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Configure succeeded. (Table Row to Variable (deprecated)) 2020-01-15 11:27:09,442 DEBUG Pivoting 3:0:0:0:0:6 Table Row to Variable (deprecated) 3:0:0:0:0:7 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,443 DEBUG Component Output 3:0:0:0:0:14 Configure succeeded. (Component Output) 2020-01-15 11:27:09,443 DEBUG Pivoting 3:0:0:0:0:6 Component Output 3:0:0:0:0:14 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,443 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Table Row to Variable (deprecated) 3:8:0:0:0:7 doBeforeExecution 2020-01-15 11:27:09,443 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Table Row to Variable (deprecated) 3:8:0:0:0:7 has new state: EXECUTING 2020-01-15 11:27:09,443 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Table Row to Variable (deprecated) 3:8:0:0:0:7 Start execute 2020-01-15 11:27:09,443 DEBUG Component Output 3:3:0:0:0:14 Component Output 3:3:0:0:0:14 doBeforePostExecution 2020-01-15 11:27:09,443 DEBUG Component Output 3:3:0:0:0:14 Component Output 3:3:0:0:0:14 has new state: POSTEXECUTE 2020-01-15 11:27:09,443 DEBUG Component Output 3:3:0:0:0:14 Component Output 3:3:0:0:0:14 doAfterExecute - success 2020-01-15 11:27:09,444 INFO Table Row to Variable (deprecated) 3:8:0:0:0:7 Table Row to Variable (deprecated) 3:8:0:0:0:7 End execute (0 secs) 2020-01-15 11:27:09,444 DEBUG Component Output 3:3:0:0:0:14 Component Output 3:3:0:0:0:14 has new state: EXECUTED 2020-01-15 11:27:09,444 DEBUG Component Output 3:3:0:0:0:14 Read Configuration 3:3:0:0:0 has new state: EXECUTED 2020-01-15 11:27:09,444 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Column Rename (Regex) 3:0:0:0:0:9 doBeforePreExecution 2020-01-15 11:27:09,444 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Column Rename (Regex) 3:0:0:0:0:9 has new state: PREEXECUTE 2020-01-15 11:27:09,444 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Adding handler d093c4d6-3d53-48d0-92fa-c983f212af31 (Column Rename (Regex) 3:0:0:0:0:9: ) - 45 in total 2020-01-15 11:27:09,444 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Table Row to Variable (deprecated) 3:8:0:0:0:7 doBeforePostExecution 2020-01-15 11:27:09,444 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Table Row to Variable (deprecated) 3:8:0:0:0:7 has new state: POSTEXECUTE 2020-01-15 11:27:09,444 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Table Row to Variable (deprecated) 3:8:0:0:0:7 doAfterExecute - success 2020-01-15 11:27:09,444 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Table Row to Variable (deprecated) 3:8:0:0:0:7 has new state: EXECUTED 2020-01-15 11:27:09,445 DEBUG Component Output 3:8:0:0:0:14 Configure succeeded. (Component Output) 2020-01-15 11:27:09,445 DEBUG Table Row to Variable (deprecated) 3:8:0:0:0:7 Component Output 3:8:0:0:0:14 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,445 DEBUG Component Output 3:8:0:0:0:14 Component Output 3:8:0:0:0:14 doBeforePreExecution 2020-01-15 11:27:09,445 DEBUG Component Output 3:8:0:0:0:14 Component Output 3:8:0:0:0:14 has new state: PREEXECUTE 2020-01-15 11:27:09,445 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Column Rename (Regex) 3:0:0:0:0:9 doBeforeExecution 2020-01-15 11:27:09,445 DEBUG Component Output 3:8:0:0:0:14 Adding handler f061d2f5-f81b-4603-9d5a-5f6e8772294a (Component Output 3:8:0:0:0:14: ) - 46 in total 2020-01-15 11:27:09,445 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Column Rename (Regex) 3:0:0:0:0:9 has new state: EXECUTING 2020-01-15 11:27:09,445 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Column Rename (Regex) 3:0:0:0:0:9 Start execute 2020-01-15 11:27:09,446 DEBUG Component Output 3:8:0:0:0:14 Component Output 3:8:0:0:0:14 doBeforeExecution 2020-01-15 11:27:09,446 INFO Read Configuration 3:3:0:0 Read Configuration 3:3:0:0 End execute (0 secs) 2020-01-15 11:27:09,446 DEBUG Component Output 3:8:0:0:0:14 Component Output 3:8:0:0:0:14 has new state: EXECUTING 2020-01-15 11:27:09,446 DEBUG Component Output 3:8:0:0:0:14 Component Output 3:8:0:0:0:14 Start execute 2020-01-15 11:27:09,446 INFO Column Rename (Regex) 3:0:0:0:0:9 Column Rename (Regex) 3:0:0:0:0:9 End execute (0 secs) 2020-01-15 11:27:09,446 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Column Rename (Regex) 3:0:0:0:0:9 doBeforePostExecution 2020-01-15 11:27:09,446 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Column Rename (Regex) 3:0:0:0:0:9 has new state: POSTEXECUTE 2020-01-15 11:27:09,446 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Column Rename (Regex) 3:0:0:0:0:9 doAfterExecute - success 2020-01-15 11:27:09,447 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Column Rename (Regex) 3:0:0:0:0:9 has new state: EXECUTED 2020-01-15 11:27:09,447 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Configure succeeded. (Table Row to Variable (deprecated)) 2020-01-15 11:27:09,448 INFO Component Output 3:8:0:0:0:14 Component Output 3:8:0:0:0:14 End execute (0 secs) 2020-01-15 11:27:09,448 DEBUG Column Rename (Regex) 3:0:0:0:0:9 Table Row to Variable (deprecated) 3:0:0:0:0:7 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,448 DEBUG Read Configuration 3:3:0:0 Read Configuration 3:3:0:0 doBeforePostExecution 2020-01-15 11:27:09,449 DEBUG Read Configuration 3:3:0:0 Read Configuration 3:3:0:0 has new state: POSTEXECUTE 2020-01-15 11:27:09,449 DEBUG Read Configuration 3:3:0:0 Read Configuration 3:3:0:0 doAfterExecute - success 2020-01-15 11:27:09,449 DEBUG Read Configuration 3:3:0:0 Read Configuration 3:3:0:0 has new state: EXECUTED 2020-01-15 11:27:09,449 DEBUG Merge Variables 3:3:0:5 Configure succeeded. (Merge Variables) 2020-01-15 11:27:09,449 DEBUG Read Configuration 3:3:0:0 Merge Variables 3:3:0:5 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,449 DEBUG Read Configuration 3:3:0:0 Merge Variables 3:3:0:5 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,450 DEBUG Java Edit Variable 3:3:0:4 Configure succeeded. (Java Edit Variable) 2020-01-15 11:27:09,451 DEBUG Read Configuration 3:3:0:0 Java Edit Variable 3:3:0:4 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,453 DEBUG Component Output 3:3:0:7 Configure succeeded. (Component Output) 2020-01-15 11:27:09,453 DEBUG Read Configuration 3:3:0:0 Component Output 3:3:0:7 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,453 DEBUG Component Output 3:8:0:0:0:14 Component Output 3:8:0:0:0:14 doBeforePostExecution 2020-01-15 11:27:09,453 DEBUG Component Output 3:8:0:0:0:14 Component Output 3:8:0:0:0:14 has new state: POSTEXECUTE 2020-01-15 11:27:09,453 DEBUG Component Output 3:8:0:0:0:14 Component Output 3:8:0:0:0:14 doAfterExecute - success 2020-01-15 11:27:09,453 DEBUG Component Output 3:8:0:0:0:14 Component Output 3:8:0:0:0:14 has new state: EXECUTED 2020-01-15 11:27:09,454 DEBUG Component Output 3:8:0:0:0:14 Read Configuration 3:8:0:0:0 has new state: EXECUTED 2020-01-15 11:27:09,454 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Table Row to Variable (deprecated) 3:0:0:0:0:7 doBeforePreExecution 2020-01-15 11:27:09,454 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Table Row to Variable (deprecated) 3:0:0:0:0:7 has new state: PREEXECUTE 2020-01-15 11:27:09,454 DEBUG Merge Variables 3:3:0:5 Merge Variables 3:3:0:5 doBeforePreExecution 2020-01-15 11:27:09,454 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Adding handler 2095ba4d-a274-4089-8350-143a39f5a71e (Table Row to Variable (deprecated) 3:0:0:0:0:7: ) - 47 in total 2020-01-15 11:27:09,454 DEBUG Merge Variables 3:3:0:5 Merge Variables 3:3:0:5 has new state: PREEXECUTE 2020-01-15 11:27:09,454 DEBUG Merge Variables 3:3:0:5 Adding handler 1f01d680-5f79-4a90-a157-567104e1474a (Merge Variables 3:3:0:5: ) - 48 in total 2020-01-15 11:27:09,454 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Table Row to Variable (deprecated) 3:0:0:0:0:7 doBeforeExecution 2020-01-15 11:27:09,454 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Table Row to Variable (deprecated) 3:0:0:0:0:7 has new state: EXECUTING 2020-01-15 11:27:09,454 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Table Row to Variable (deprecated) 3:0:0:0:0:7 Start execute 2020-01-15 11:27:09,454 DEBUG Merge Variables 3:3:0:5 Merge Variables 3:3:0:5 doBeforeExecution 2020-01-15 11:27:09,454 DEBUG Merge Variables 3:3:0:5 Merge Variables 3:3:0:5 has new state: EXECUTING 2020-01-15 11:27:09,455 DEBUG Merge Variables 3:3:0:5 Merge Variables 3:3:0:5 Start execute 2020-01-15 11:27:09,455 INFO Table Row to Variable (deprecated) 3:0:0:0:0:7 Table Row to Variable (deprecated) 3:0:0:0:0:7 End execute (0 secs) 2020-01-15 11:27:09,455 INFO Read Configuration 3:8:0:0 Read Configuration 3:8:0:0 End execute (0 secs) 2020-01-15 11:27:09,455 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Table Row to Variable (deprecated) 3:0:0:0:0:7 doBeforePostExecution 2020-01-15 11:27:09,455 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Table Row to Variable (deprecated) 3:0:0:0:0:7 has new state: POSTEXECUTE 2020-01-15 11:27:09,455 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Table Row to Variable (deprecated) 3:0:0:0:0:7 doAfterExecute - success 2020-01-15 11:27:09,455 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Table Row to Variable (deprecated) 3:0:0:0:0:7 has new state: EXECUTED 2020-01-15 11:27:09,455 INFO Merge Variables 3:3:0:5 Merge Variables 3:3:0:5 End execute (0 secs) 2020-01-15 11:27:09,456 DEBUG Component Output 3:0:0:0:0:14 Configure succeeded. (Component Output) 2020-01-15 11:27:09,456 DEBUG Table Row to Variable (deprecated) 3:0:0:0:0:7 Component Output 3:0:0:0:0:14 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,456 DEBUG Component Output 3:0:0:0:0:14 Component Output 3:0:0:0:0:14 doBeforePreExecution 2020-01-15 11:27:09,456 DEBUG Component Output 3:0:0:0:0:14 Component Output 3:0:0:0:0:14 has new state: PREEXECUTE 2020-01-15 11:27:09,456 DEBUG Read Configuration 3:8:0:0 Read Configuration 3:8:0:0 doBeforePostExecution 2020-01-15 11:27:09,456 DEBUG Component Output 3:0:0:0:0:14 Adding handler 4f9cdb9a-86c6-4e36-9441-d1d75e367e61 (Component Output 3:0:0:0:0:14: ) - 49 in total 2020-01-15 11:27:09,456 DEBUG Read Configuration 3:8:0:0 Read Configuration 3:8:0:0 has new state: POSTEXECUTE 2020-01-15 11:27:09,456 DEBUG Read Configuration 3:8:0:0 Read Configuration 3:8:0:0 doAfterExecute - success 2020-01-15 11:27:09,456 DEBUG Read Configuration 3:8:0:0 Read Configuration 3:8:0:0 has new state: EXECUTED 2020-01-15 11:27:09,457 DEBUG Merge Variables 3:8:0:5 Configure succeeded. (Merge Variables) 2020-01-15 11:27:09,457 DEBUG Read Configuration 3:8:0:0 Merge Variables 3:8:0:5 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,457 DEBUG Read Configuration 3:8:0:0 Merge Variables 3:8:0:5 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,458 DEBUG Java Edit Variable 3:8:0:4 Configure succeeded. (Java Edit Variable) 2020-01-15 11:27:09,458 DEBUG Read Configuration 3:8:0:0 Java Edit Variable 3:8:0:4 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,458 DEBUG Component Output 3:8:0:7 Configure succeeded. (Component Output) 2020-01-15 11:27:09,459 DEBUG Read Configuration 3:8:0:0 Component Output 3:8:0:7 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,459 DEBUG Merge Variables 3:3:0:5 Merge Variables 3:3:0:5 doBeforePostExecution 2020-01-15 11:27:09,459 DEBUG Merge Variables 3:3:0:5 Merge Variables 3:3:0:5 has new state: POSTEXECUTE 2020-01-15 11:27:09,459 DEBUG Merge Variables 3:3:0:5 Merge Variables 3:3:0:5 doAfterExecute - success 2020-01-15 11:27:09,459 DEBUG Merge Variables 3:3:0:5 Merge Variables 3:3:0:5 has new state: EXECUTED 2020-01-15 11:27:09,460 DEBUG Java Edit Variable 3:3:0:4 Configure succeeded. (Java Edit Variable) 2020-01-15 11:27:09,461 DEBUG Merge Variables 3:3:0:5 Java Edit Variable 3:3:0:4 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,461 DEBUG Java Edit Variable 3:3:0:4 Java Edit Variable 3:3:0:4 doBeforePreExecution 2020-01-15 11:27:09,461 DEBUG Java Edit Variable 3:3:0:4 Java Edit Variable 3:3:0:4 has new state: PREEXECUTE 2020-01-15 11:27:09,461 DEBUG Java Edit Variable 3:3:0:4 Adding handler 96b6dbbf-caf8-47d6-9910-ffc8d3e47c59 (Java Edit Variable 3:3:0:4: ) - 50 in total 2020-01-15 11:27:09,461 DEBUG Component Output 3:0:0:0:0:14 Component Output 3:0:0:0:0:14 doBeforeExecution 2020-01-15 11:27:09,461 DEBUG Component Output 3:0:0:0:0:14 Component Output 3:0:0:0:0:14 has new state: EXECUTING 2020-01-15 11:27:09,462 DEBUG Component Output 3:0:0:0:0:14 Component Output 3:0:0:0:0:14 Start execute 2020-01-15 11:27:09,462 DEBUG Merge Variables 3:8:0:5 Merge Variables 3:8:0:5 doBeforePreExecution 2020-01-15 11:27:09,462 DEBUG Merge Variables 3:8:0:5 Merge Variables 3:8:0:5 has new state: PREEXECUTE 2020-01-15 11:27:09,462 DEBUG Java Edit Variable 3:3:0:4 Java Edit Variable 3:3:0:4 doBeforeExecution 2020-01-15 11:27:09,462 DEBUG Merge Variables 3:8:0:5 Adding handler e799d4f4-66d7-4753-ac25-fcc23aaf8257 (Merge Variables 3:8:0:5: ) - 51 in total 2020-01-15 11:27:09,462 DEBUG Java Edit Variable 3:3:0:4 Java Edit Variable 3:3:0:4 has new state: EXECUTING 2020-01-15 11:27:09,462 DEBUG Merge Variables 3:8:0:5 Merge Variables 3:8:0:5 doBeforeExecution 2020-01-15 11:27:09,462 DEBUG Java Edit Variable 3:3:0:4 Java Edit Variable 3:3:0:4 Start execute 2020-01-15 11:27:09,462 DEBUG Merge Variables 3:8:0:5 Merge Variables 3:8:0:5 has new state: EXECUTING 2020-01-15 11:27:09,462 INFO Component Output 3:0:0:0:0:14 Component Output 3:0:0:0:0:14 End execute (0 secs) 2020-01-15 11:27:09,462 DEBUG Merge Variables 3:8:0:5 Merge Variables 3:8:0:5 Start execute 2020-01-15 11:27:09,462 DEBUG Component Output 3:0:0:0:0:14 Component Output 3:0:0:0:0:14 doBeforePostExecution 2020-01-15 11:27:09,462 DEBUG Component Output 3:0:0:0:0:14 Component Output 3:0:0:0:0:14 has new state: POSTEXECUTE 2020-01-15 11:27:09,462 DEBUG Component Output 3:0:0:0:0:14 Component Output 3:0:0:0:0:14 doAfterExecute - success 2020-01-15 11:27:09,462 DEBUG Component Output 3:0:0:0:0:14 Component Output 3:0:0:0:0:14 has new state: EXECUTED 2020-01-15 11:27:09,463 DEBUG Component Output 3:0:0:0:0:14 Read Configuration 3:0:0:0:0 has new state: EXECUTED 2020-01-15 11:27:09,463 INFO Merge Variables 3:8:0:5 Merge Variables 3:8:0:5 End execute (0 secs) 2020-01-15 11:27:09,463 DEBUG Merge Variables 3:8:0:5 Merge Variables 3:8:0:5 doBeforePostExecution 2020-01-15 11:27:09,463 DEBUG Merge Variables 3:8:0:5 Merge Variables 3:8:0:5 has new state: POSTEXECUTE 2020-01-15 11:27:09,463 DEBUG Merge Variables 3:8:0:5 Merge Variables 3:8:0:5 doAfterExecute - success 2020-01-15 11:27:09,463 DEBUG Merge Variables 3:8:0:5 Merge Variables 3:8:0:5 has new state: EXECUTED 2020-01-15 11:27:09,464 INFO Java Edit Variable 3:3:0:4 Java Edit Variable 3:3:0:4 End execute (0 secs) 2020-01-15 11:27:09,465 DEBUG Java Edit Variable 3:8:0:4 Configure succeeded. (Java Edit Variable) 2020-01-15 11:27:09,465 DEBUG Merge Variables 3:8:0:5 Java Edit Variable 3:8:0:4 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,465 DEBUG Java Edit Variable 3:3:0:4 Java Edit Variable 3:3:0:4 doBeforePostExecution 2020-01-15 11:27:09,465 DEBUG Java Edit Variable 3:3:0:4 Java Edit Variable 3:3:0:4 has new state: POSTEXECUTE 2020-01-15 11:27:09,465 DEBUG Java Edit Variable 3:3:0:4 Java Edit Variable 3:3:0:4 doAfterExecute - success 2020-01-15 11:27:09,465 DEBUG Java Edit Variable 3:3:0:4 Java Edit Variable 3:3:0:4 has new state: EXECUTED 2020-01-15 11:27:09,466 DEBUG Component Output 3:3:0:7 Configure succeeded. (Component Output) 2020-01-15 11:27:09,466 DEBUG Java Edit Variable 3:3:0:4 Component Output 3:3:0:7 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,466 DEBUG Java Edit Variable 3:8:0:4 Java Edit Variable 3:8:0:4 doBeforePreExecution 2020-01-15 11:27:09,466 DEBUG Java Edit Variable 3:8:0:4 Java Edit Variable 3:8:0:4 has new state: PREEXECUTE 2020-01-15 11:27:09,466 DEBUG Java Edit Variable 3:8:0:4 Adding handler bbdef4b8-a803-4ca1-8271-503385d392ec (Java Edit Variable 3:8:0:4: ) - 52 in total 2020-01-15 11:27:09,466 DEBUG Component Output 3:3:0:7 Component Output 3:3:0:7 doBeforePreExecution 2020-01-15 11:27:09,466 DEBUG Component Output 3:3:0:7 Component Output 3:3:0:7 has new state: PREEXECUTE 2020-01-15 11:27:09,466 INFO Read Configuration 3:0:0:0 Read Configuration 3:0:0:0 End execute (0 secs) 2020-01-15 11:27:09,467 DEBUG Java Edit Variable 3:8:0:4 Java Edit Variable 3:8:0:4 doBeforeExecution 2020-01-15 11:27:09,467 DEBUG Component Output 3:3:0:7 Adding handler 1a913e3f-2d41-4f9c-aabc-fa63281f2483 (Component Output 3:3:0:7: ) - 53 in total 2020-01-15 11:27:09,467 DEBUG Java Edit Variable 3:8:0:4 Java Edit Variable 3:8:0:4 has new state: EXECUTING 2020-01-15 11:27:09,467 DEBUG Read Configuration 3:0:0:0 Read Configuration 3:0:0:0 doBeforePostExecution 2020-01-15 11:27:09,467 DEBUG Java Edit Variable 3:8:0:4 Java Edit Variable 3:8:0:4 Start execute 2020-01-15 11:27:09,467 DEBUG Read Configuration 3:0:0:0 Read Configuration 3:0:0:0 has new state: POSTEXECUTE 2020-01-15 11:27:09,467 DEBUG Read Configuration 3:0:0:0 Read Configuration 3:0:0:0 doAfterExecute - success 2020-01-15 11:27:09,467 DEBUG Read Configuration 3:0:0:0 Read Configuration 3:0:0:0 has new state: EXECUTED 2020-01-15 11:27:09,467 DEBUG Merge Variables 3:0:0:5 Configure succeeded. (Merge Variables) 2020-01-15 11:27:09,467 DEBUG Read Configuration 3:0:0:0 Merge Variables 3:0:0:5 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,468 DEBUG Read Configuration 3:0:0:0 Merge Variables 3:0:0:5 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,469 DEBUG Java Edit Variable 3:0:0:4 Configure succeeded. (Java Edit Variable) 2020-01-15 11:27:09,469 DEBUG Read Configuration 3:0:0:0 Java Edit Variable 3:0:0:4 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,469 DEBUG Component Output 3:0:0:7 Configure succeeded. (Component Output) 2020-01-15 11:27:09,470 DEBUG Read Configuration 3:0:0:0 Component Output 3:0:0:7 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,470 DEBUG Component Output 3:3:0:7 Component Output 3:3:0:7 doBeforeExecution 2020-01-15 11:27:09,470 INFO Java Edit Variable 3:8:0:4 Java Edit Variable 3:8:0:4 End execute (0 secs) 2020-01-15 11:27:09,470 DEBUG Component Output 3:3:0:7 Component Output 3:3:0:7 has new state: EXECUTING 2020-01-15 11:27:09,470 DEBUG Component Output 3:3:0:7 Component Output 3:3:0:7 Start execute 2020-01-15 11:27:09,470 DEBUG Merge Variables 3:0:0:5 Merge Variables 3:0:0:5 doBeforePreExecution 2020-01-15 11:27:09,470 DEBUG Merge Variables 3:0:0:5 Merge Variables 3:0:0:5 has new state: PREEXECUTE 2020-01-15 11:27:09,470 DEBUG Java Edit Variable 3:8:0:4 Java Edit Variable 3:8:0:4 doBeforePostExecution 2020-01-15 11:27:09,470 DEBUG Java Edit Variable 3:8:0:4 Java Edit Variable 3:8:0:4 has new state: POSTEXECUTE 2020-01-15 11:27:09,471 DEBUG Java Edit Variable 3:8:0:4 Java Edit Variable 3:8:0:4 doAfterExecute - success 2020-01-15 11:27:09,471 INFO Component Output 3:3:0:7 Component Output 3:3:0:7 End execute (0 secs) 2020-01-15 11:27:09,471 DEBUG Java Edit Variable 3:8:0:4 Java Edit Variable 3:8:0:4 has new state: EXECUTED 2020-01-15 11:27:09,471 DEBUG Merge Variables 3:0:0:5 Adding handler 5d0e2d69-a93e-46df-b4a7-72684ff2e441 (Merge Variables 3:0:0:5: ) - 54 in total 2020-01-15 11:27:09,471 DEBUG Component Output 3:8:0:7 Configure succeeded. (Component Output) 2020-01-15 11:27:09,471 DEBUG Java Edit Variable 3:8:0:4 Component Output 3:8:0:7 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,471 DEBUG Component Output 3:8:0:7 Component Output 3:8:0:7 doBeforePreExecution 2020-01-15 11:27:09,472 DEBUG Component Output 3:8:0:7 Component Output 3:8:0:7 has new state: PREEXECUTE 2020-01-15 11:27:09,472 DEBUG Component Output 3:3:0:7 Component Output 3:3:0:7 doBeforePostExecution 2020-01-15 11:27:09,472 DEBUG Component Output 3:8:0:7 Adding handler c31934ec-aecc-43a4-8838-c3e11fb5b810 (Component Output 3:8:0:7: ) - 55 in total 2020-01-15 11:27:09,472 DEBUG Component Output 3:3:0:7 Component Output 3:3:0:7 has new state: POSTEXECUTE 2020-01-15 11:27:09,472 DEBUG Component Output 3:3:0:7 Component Output 3:3:0:7 doAfterExecute - success 2020-01-15 11:27:09,472 DEBUG Component Output 3:3:0:7 Component Output 3:3:0:7 has new state: EXECUTED 2020-01-15 11:27:09,472 DEBUG Component Output 3:3:0:7 DB Connection Parameters Provider 3:3:0 has new state: EXECUTED 2020-01-15 11:27:09,472 DEBUG Merge Variables 3:0:0:5 Merge Variables 3:0:0:5 doBeforeExecution 2020-01-15 11:27:09,472 DEBUG Merge Variables 3:0:0:5 Merge Variables 3:0:0:5 has new state: EXECUTING 2020-01-15 11:27:09,472 DEBUG Merge Variables 3:0:0:5 Merge Variables 3:0:0:5 Start execute 2020-01-15 11:27:09,472 DEBUG Component Output 3:8:0:7 Component Output 3:8:0:7 doBeforeExecution 2020-01-15 11:27:09,473 DEBUG Component Output 3:8:0:7 Component Output 3:8:0:7 has new state: EXECUTING 2020-01-15 11:27:09,473 DEBUG Component Output 3:8:0:7 Component Output 3:8:0:7 Start execute 2020-01-15 11:27:09,473 INFO Merge Variables 3:0:0:5 Merge Variables 3:0:0:5 End execute (0 secs) 2020-01-15 11:27:09,473 DEBUG Merge Variables 3:0:0:5 Merge Variables 3:0:0:5 doBeforePostExecution 2020-01-15 11:27:09,473 INFO Component Output 3:8:0:7 Component Output 3:8:0:7 End execute (0 secs) 2020-01-15 11:27:09,473 DEBUG Merge Variables 3:0:0:5 Merge Variables 3:0:0:5 has new state: POSTEXECUTE 2020-01-15 11:27:09,473 DEBUG Merge Variables 3:0:0:5 Merge Variables 3:0:0:5 doAfterExecute - success 2020-01-15 11:27:09,473 DEBUG Merge Variables 3:0:0:5 Merge Variables 3:0:0:5 has new state: EXECUTED 2020-01-15 11:27:09,475 DEBUG Java Edit Variable 3:0:0:4 Configure succeeded. (Java Edit Variable) 2020-01-15 11:27:09,475 DEBUG Merge Variables 3:0:0:5 Java Edit Variable 3:0:0:4 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,475 DEBUG Java Edit Variable 3:0:0:4 Java Edit Variable 3:0:0:4 doBeforePreExecution 2020-01-15 11:27:09,475 DEBUG Java Edit Variable 3:0:0:4 Java Edit Variable 3:0:0:4 has new state: PREEXECUTE 2020-01-15 11:27:09,475 DEBUG Component Output 3:8:0:7 Component Output 3:8:0:7 doBeforePostExecution 2020-01-15 11:27:09,475 INFO DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3 End execute (0 secs) 2020-01-15 11:27:09,475 DEBUG Java Edit Variable 3:0:0:4 Adding handler de947823-3555-494a-8332-73ebab3f1b8a (Java Edit Variable 3:0:0:4: ) - 56 in total 2020-01-15 11:27:09,475 DEBUG Component Output 3:8:0:7 Component Output 3:8:0:7 has new state: POSTEXECUTE 2020-01-15 11:27:09,476 DEBUG Component Output 3:8:0:7 Component Output 3:8:0:7 doAfterExecute - success 2020-01-15 11:27:09,476 DEBUG Component Output 3:8:0:7 Component Output 3:8:0:7 has new state: EXECUTED 2020-01-15 11:27:09,476 DEBUG Component Output 3:8:0:7 DB Connection Parameters Provider 3:8:0 has new state: EXECUTED 2020-01-15 11:27:09,476 DEBUG DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3 doBeforePostExecution 2020-01-15 11:27:09,477 DEBUG DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3 has new state: POSTEXECUTE 2020-01-15 11:27:09,477 DEBUG DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3 doAfterExecute - success 2020-01-15 11:27:09,477 DEBUG DB Connection Parameters Provider 3:3 DB Connection Parameters Provider 3:3 has new state: EXECUTED 2020-01-15 11:27:09,477 DEBUG Credentials Configuration 3:4 Configure succeeded. (Credentials Configuration) 2020-01-15 11:27:09,478 DEBUG DB Connection Parameters Provider 3:3 Credentials Configuration 3:4 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,478 DEBUG DB Connection Parameters Provider 3:3 Credentials Configuration 3:4 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,481 DEBUG PostgreSQL Connector 3:5 Configure succeeded. (PostgreSQL Connector) 2020-01-15 11:27:09,481 DEBUG DB Connection Parameters Provider 3:3 PostgreSQL Connector 3:5 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,481 DEBUG Java Edit Variable 3:0:0:4 Java Edit Variable 3:0:0:4 doBeforeExecution 2020-01-15 11:27:09,481 DEBUG Java Edit Variable 3:0:0:4 Java Edit Variable 3:0:0:4 has new state: EXECUTING 2020-01-15 11:27:09,481 DEBUG Java Edit Variable 3:0:0:4 Java Edit Variable 3:0:0:4 Start execute 2020-01-15 11:27:09,481 DEBUG Credentials Configuration 3:4 Credentials Configuration 3:4 doBeforePreExecution 2020-01-15 11:27:09,481 INFO DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8 End execute (0 secs) 2020-01-15 11:27:09,482 DEBUG Credentials Configuration 3:4 Credentials Configuration 3:4 has new state: PREEXECUTE 2020-01-15 11:27:09,482 DEBUG DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8 doBeforePostExecution 2020-01-15 11:27:09,482 DEBUG Credentials Configuration 3:4 Adding handler 063902d3-8671-4456-b666-4fb07aa0ba2d (Credentials Configuration 3:4: ) - 57 in total 2020-01-15 11:27:09,482 DEBUG DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8 has new state: POSTEXECUTE 2020-01-15 11:27:09,482 DEBUG DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8 doAfterExecute - success 2020-01-15 11:27:09,482 DEBUG DB Connection Parameters Provider 3:8 DB Connection Parameters Provider 3:8 has new state: EXECUTED 2020-01-15 11:27:09,483 DEBUG Credentials Configuration 3:7 Configure succeeded. (Credentials Configuration) 2020-01-15 11:27:09,483 DEBUG DB Connection Parameters Provider 3:8 Credentials Configuration 3:7 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,483 DEBUG DB Connection Parameters Provider 3:8 Credentials Configuration 3:7 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,483 INFO Java Edit Variable 3:0:0:4 Java Edit Variable 3:0:0:4 End execute (0 secs) 2020-01-15 11:27:09,483 DEBUG Credentials Configuration 3:4 Credentials Configuration 3:4 doBeforeExecution 2020-01-15 11:27:09,485 DEBUG Credentials Configuration 3:4 Credentials Configuration 3:4 has new state: EXECUTING 2020-01-15 11:27:09,485 DEBUG Credentials Configuration 3:4 Credentials Configuration 3:4 Start execute 2020-01-15 11:27:09,485 DEBUG Java Edit Variable 3:0:0:4 Java Edit Variable 3:0:0:4 doBeforePostExecution 2020-01-15 11:27:09,485 DEBUG Java Edit Variable 3:0:0:4 Java Edit Variable 3:0:0:4 has new state: POSTEXECUTE 2020-01-15 11:27:09,485 INFO Credentials Configuration 3:4 Credentials Configuration 3:4 End execute (0 secs) 2020-01-15 11:27:09,485 DEBUG Java Edit Variable 3:0:0:4 Java Edit Variable 3:0:0:4 doAfterExecute - success 2020-01-15 11:27:09,486 DEBUG Java Edit Variable 3:0:0:4 Java Edit Variable 3:0:0:4 has new state: EXECUTED 2020-01-15 11:27:09,486 DEBUG Component Output 3:0:0:7 Configure succeeded. (Component Output) 2020-01-15 11:27:09,487 DEBUG Java Edit Variable 3:0:0:4 Component Output 3:0:0:7 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,487 DEBUG Credentials Configuration 3:7 Credentials Configuration 3:7 doBeforePreExecution 2020-01-15 11:27:09,487 DEBUG Credentials Configuration 3:7 Credentials Configuration 3:7 has new state: PREEXECUTE 2020-01-15 11:27:09,487 DEBUG Credentials Configuration 3:4 Credentials Configuration 3:4 doBeforePostExecution 2020-01-15 11:27:09,487 DEBUG Credentials Configuration 3:7 Adding handler c476f550-4f7a-4397-959d-48e54b81b2f0 (Credentials Configuration 3:7: ) - 58 in total 2020-01-15 11:27:09,487 DEBUG Credentials Configuration 3:4 Credentials Configuration 3:4 has new state: POSTEXECUTE 2020-01-15 11:27:09,487 DEBUG Credentials Configuration 3:4 Credentials Configuration 3:4 doAfterExecute - success 2020-01-15 11:27:09,487 DEBUG Credentials Configuration 3:4 Credentials Configuration 3:4 has new state: EXECUTED 2020-01-15 11:27:09,491 DEBUG PostgreSQL Connector 3:5 Configure succeeded. (PostgreSQL Connector) 2020-01-15 11:27:09,492 DEBUG Credentials Configuration 3:4 PostgreSQL Connector 3:5 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,492 DEBUG Component Output 3:0:0:7 Component Output 3:0:0:7 doBeforePreExecution 2020-01-15 11:27:09,492 DEBUG Component Output 3:0:0:7 Component Output 3:0:0:7 has new state: PREEXECUTE 2020-01-15 11:27:09,492 DEBUG Component Output 3:0:0:7 Adding handler b440e700-12c4-488f-ae9f-d9c260879e23 (Component Output 3:0:0:7: ) - 59 in total 2020-01-15 11:27:09,492 DEBUG Component Output 3:0:0:7 Component Output 3:0:0:7 doBeforeExecution 2020-01-15 11:27:09,492 DEBUG Component Output 3:0:0:7 Component Output 3:0:0:7 has new state: EXECUTING 2020-01-15 11:27:09,492 DEBUG Component Output 3:0:0:7 Component Output 3:0:0:7 Start execute 2020-01-15 11:27:09,492 DEBUG Credentials Configuration 3:7 Credentials Configuration 3:7 doBeforeExecution 2020-01-15 11:27:09,493 DEBUG Credentials Configuration 3:7 Credentials Configuration 3:7 has new state: EXECUTING 2020-01-15 11:27:09,493 DEBUG Credentials Configuration 3:7 Credentials Configuration 3:7 Start execute 2020-01-15 11:27:09,493 DEBUG PostgreSQL Connector 3:5 PostgreSQL Connector 3:5 doBeforePreExecution 2020-01-15 11:27:09,493 DEBUG PostgreSQL Connector 3:5 PostgreSQL Connector 3:5 has new state: PREEXECUTE 2020-01-15 11:27:09,493 INFO Credentials Configuration 3:7 Credentials Configuration 3:7 End execute (0 secs) 2020-01-15 11:27:09,493 DEBUG PostgreSQL Connector 3:5 Adding handler 5ca94529-b49f-4085-a6e9-724bcddf2c81 (PostgreSQL Connector 3:5: ) - 60 in total 2020-01-15 11:27:09,493 DEBUG Credentials Configuration 3:7 Credentials Configuration 3:7 doBeforePostExecution 2020-01-15 11:27:09,493 INFO Component Output 3:0:0:7 Component Output 3:0:0:7 End execute (0 secs) 2020-01-15 11:27:09,493 DEBUG Credentials Configuration 3:7 Credentials Configuration 3:7 has new state: POSTEXECUTE 2020-01-15 11:27:09,493 DEBUG Credentials Configuration 3:7 Credentials Configuration 3:7 doAfterExecute - success 2020-01-15 11:27:09,493 DEBUG Credentials Configuration 3:7 Credentials Configuration 3:7 has new state: EXECUTED 2020-01-15 11:27:09,494 DEBUG PostgreSQL Connector 3:5 PostgreSQL Connector 3:5 doBeforeExecution 2020-01-15 11:27:09,494 DEBUG PostgreSQL Connector 3:5 PostgreSQL Connector 3:5 has new state: EXECUTING 2020-01-15 11:27:09,494 DEBUG PostgreSQL Connector 3:5 PostgreSQL Connector 3:5 Start execute 2020-01-15 11:27:09,494 DEBUG Component Output 3:0:0:7 Component Output 3:0:0:7 doBeforePostExecution 2020-01-15 11:27:09,496 DEBUG Component Output 3:0:0:7 Component Output 3:0:0:7 has new state: POSTEXECUTE 2020-01-15 11:27:09,496 DEBUG Component Output 3:0:0:7 Component Output 3:0:0:7 doAfterExecute - success 2020-01-15 11:27:09,496 DEBUG Component Output 3:0:0:7 Component Output 3:0:0:7 has new state: EXECUTED 2020-01-15 11:27:09,496 DEBUG Component Output 3:0:0:7 DB Connection Parameters Provider 3:0:0 has new state: EXECUTED 2020-01-15 11:27:09,496 DEBUG PostgreSQL Connector 3:5 New database session: DefaultDBSessionInformation(id=6460c599-06d6-4799-acfa-52446db2ab3c, dbType=DBType(id=postgres, name=PostgreSQL, description=null), driverDefinition=DBDriverDefinition(id=PostgreSQL, name=PostgreSQL, version=42.2.0, driverClass=org.postgresql.Driver, dbType=DBType(id=postgres, name=PostgreSQL, description=null), description=, origin=EXTENSION), connectionController=org.knime.database.connection.UserDBConnectionController=(url=jdbc:postgresql://ads_op_db_host:5432/pgtestdb, authenticationType=CREDENTIALS, credential=op_credentials), dialectId=postgres, attributeValues={}) 2020-01-15 11:27:09,496 INFO DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0 End execute (0 secs) 2020-01-15 11:27:09,497 DEBUG DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0 doBeforePostExecution 2020-01-15 11:27:09,497 DEBUG DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0 has new state: POSTEXECUTE 2020-01-15 11:27:09,497 DEBUG DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0 doAfterExecute - success 2020-01-15 11:27:09,497 DEBUG DB Connection Parameters Provider 3:0 DB Connection Parameters Provider 3:0 has new state: EXECUTED 2020-01-15 11:27:09,497 DEBUG Credentials Configuration 3:2 Configure succeeded. (Credentials Configuration) 2020-01-15 11:27:09,498 DEBUG DB Connection Parameters Provider 3:0 Credentials Configuration 3:2 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,498 DEBUG DB Connection Parameters Provider 3:0 Credentials Configuration 3:2 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,501 DEBUG Microsoft SQL Server Connector 3:1 Configure succeeded. (Microsoft SQL Server Connector) 2020-01-15 11:27:09,501 DEBUG DB Connection Parameters Provider 3:0 Microsoft SQL Server Connector 3:1 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,501 DEBUG Credentials Configuration 3:2 Credentials Configuration 3:2 doBeforePreExecution 2020-01-15 11:27:09,501 DEBUG Credentials Configuration 3:2 Credentials Configuration 3:2 has new state: PREEXECUTE 2020-01-15 11:27:09,501 DEBUG Credentials Configuration 3:2 Adding handler 0aeb9611-bc68-4998-a5f2-e51a15f36ff1 (Credentials Configuration 3:2: ) - 61 in total 2020-01-15 11:27:09,502 DEBUG Credentials Configuration 3:2 Credentials Configuration 3:2 doBeforeExecution 2020-01-15 11:27:09,502 DEBUG Credentials Configuration 3:2 Credentials Configuration 3:2 has new state: EXECUTING 2020-01-15 11:27:09,502 DEBUG Credentials Configuration 3:2 Credentials Configuration 3:2 Start execute 2020-01-15 11:27:09,502 INFO Credentials Configuration 3:2 Credentials Configuration 3:2 End execute (0 secs) 2020-01-15 11:27:09,502 DEBUG Credentials Configuration 3:2 Credentials Configuration 3:2 doBeforePostExecution 2020-01-15 11:27:09,502 DEBUG Credentials Configuration 3:2 Credentials Configuration 3:2 has new state: POSTEXECUTE 2020-01-15 11:27:09,503 DEBUG Credentials Configuration 3:2 Credentials Configuration 3:2 doAfterExecute - success 2020-01-15 11:27:09,503 DEBUG Credentials Configuration 3:2 Credentials Configuration 3:2 has new state: EXECUTED 2020-01-15 11:27:09,506 DEBUG Microsoft SQL Server Connector 3:1 Configure succeeded. (Microsoft SQL Server Connector) 2020-01-15 11:27:09,506 DEBUG Credentials Configuration 3:2 Microsoft SQL Server Connector 3:1 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,506 DEBUG Microsoft SQL Server Connector 3:1 Microsoft SQL Server Connector 3:1 doBeforePreExecution 2020-01-15 11:27:09,506 DEBUG Microsoft SQL Server Connector 3:1 Microsoft SQL Server Connector 3:1 has new state: PREEXECUTE 2020-01-15 11:27:09,510 DEBUG Microsoft SQL Server Connector 3:1 Adding handler 2b35a728-d6b3-4bbe-832d-18bff835663a (Microsoft SQL Server Connector 3:1: ) - 62 in total 2020-01-15 11:27:09,510 DEBUG Microsoft SQL Server Connector 3:1 Microsoft SQL Server Connector 3:1 doBeforeExecution 2020-01-15 11:27:09,510 DEBUG Microsoft SQL Server Connector 3:1 Microsoft SQL Server Connector 3:1 has new state: EXECUTING 2020-01-15 11:27:09,510 DEBUG Microsoft SQL Server Connector 3:1 Microsoft SQL Server Connector 3:1 Start execute 2020-01-15 11:27:09,512 DEBUG Microsoft SQL Server Connector 3:1 New database session: DefaultDBSessionInformation(id=cb134eb1-0819-4953-b7d6-09c4f8a95682, dbType=DBType(id=mssqlserver, name=Microsoft SQL Server, description=null), driverDefinition=DBDriverDefinition(id=jTDS for Microsoft SQL Server, name=jTDS for Microsoft SQL Server, version=1.3.0, driverClass=net.sourceforge.jtds.jdbc.Driver, dbType=DBType(id=mssqlserver, name=Microsoft SQL Server, description=null), description=, origin=EXTENSION), connectionController=org.knime.database.connection.UserDBConnectionController=(url=jdbc:jtds:sqlserver://ads.dersdomain.internal:1433/ads_dwh, authenticationType=CREDENTIALS, credential=ssas_credentials), dialectId=mssqlserver, attributeValues={knime.db.connection.restore=true}) 2020-01-15 11:27:09,516 DEBUG PostgreSQL Connector 3:5 Acquiring connection. 2020-01-15 11:27:09,535 DEBUG PostgreSQL Connector 3:5 The connection has been relinquished. 2020-01-15 11:27:09,535 DEBUG PostgreSQL Connector 3:5 The managed connection has been closed. 2020-01-15 11:27:09,535 DEBUG PostgreSQL Connector 3:5 The transaction managing connection has been closed. 2020-01-15 11:27:09,536 DEBUG PostgreSQL Connector 3:5 Database session information:DefaultDBSessionInformation(id=6460c599-06d6-4799-acfa-52446db2ab3c, dbType=DBType(id=postgres, name=PostgreSQL, description=null), driverDefinition=DBDriverDefinition(id=PostgreSQL, name=PostgreSQL, version=42.2.0, driverClass=org.postgresql.Driver, dbType=DBType(id=postgres, name=PostgreSQL, description=null), description=, origin=EXTENSION), connectionController=org.knime.database.connection.UserDBConnectionController=(url=jdbc:postgresql://ads_op_db_host:5432/pgtestdb, authenticationType=CREDENTIALS, credential=op_credentials), dialectId=postgres, attributeValues={}) 2020-01-15 11:27:09,536 DEBUG PostgreSQL Connector 3:5 Attribute details of database session 6460c599-06d6-4799-acfa-52446db2ab3c: AttributeValueRepository(attributes={knime.db.connection.jdbc.fetch_size=knime.db.connection.jdbc.fetch_size:10000, knime.db.connection.parameter.append.separator=knime.db.connection.parameter.append.separator:&, knime.db.dialect.sql.delimiter.identifier.opening=knime.db.dialect.sql.delimiter.identifier.opening:", knime.db.dialect.sql.table_reference.keyword=knime.db.dialect.sql.table_reference.keyword:AS, knime.db.dialect.sql.capability.operation.minus=knime.db.dialect.sql.capability.operation.minus:true, knime.db.dialect.sql.insert_into_table_with_select=knime.db.dialect.sql.insert_into_table_with_select:true, knime.db.agent.writer.autocommit_if_failing_on_error=knime.db.agent.writer.autocommit_if_failing_on_error:true, knime.db.dialect.sql.table_reference.derived_table=knime.db.dialect.sql.table_reference.derived_table:true, knime.db.connection.parameter.append=knime.db.connection.parameter.append:false, knime.db.connection.parameter.append.last.suffix=knime.db.connection.parameter.append.last.suffix:, knime.db.connection.jdbc.properties=knime.db.connection.jdbc.properties:#Tue Jan 14 09:50:18 CET 2020 , knime.db.connection.statement.cancellation.polling_period=knime.db.connection.statement.cancellation.polling_period:1000, knime.db.dialect.sql.capability.random=knime.db.dialect.sql.capability.random:true, knime.db.agent.writer.batch.enabled=knime.db.agent.writer.batch.enabled:true, knime.db.connection.statement.cancellation.enabled=knime.db.connection.statement.cancellation.enabled:true, knime.db.connection.metadata.configure.timeout=knime.db.connection.metadata.configure.timeout:3, knime.db.connection.metadata.configure.enabled=knime.db.connection.metadata.configure.enabled:true, knime.db.dialect.sql.create_table.define_constraint_name=knime.db.dialect.sql.create_table.define_constraint_name:true, knime.db.dialect.sql.identifier.delimiting.onlyspaces=knime.db.dialect.sql.identifier.delimiting.onlyspaces:false, knime.db.connection.time_zone=knime.db.connection.time_zone:UTC, knime.db.dialect.sql.capability.random_seed=knime.db.dialect.sql.capability.random_seed:false, knime.db.dialect.sql.identifier.replace.character.non_word.enabled=knime.db.dialect.sql.identifier.replace.character.non_word.enabled:false, knime.db.dialect.sql.create.table.temporary=knime.db.dialect.sql.create.table.temporary:GLOBAL TEMPORARY, knime.db.dialect.sql.minus_operator.keyword=knime.db.dialect.sql.minus_operator.keyword:EXCEPT, knime.db.dialect.sql.delimiter.identifier.closing=knime.db.dialect.sql.delimiter.identifier.closing:", knime.db.connection.logger.log.errors=knime.db.connection.logger.log.errors:false, knime.db.dialect.sql.capability.expression.case=knime.db.dialect.sql.capability.expression.case:true, knime.db.dialect.sql.identifier.replace.character.non_word.replacement=knime.db.dialect.sql.identifier.replace.character.non_word.replacement:, knime.db.connection.parameter.append.initial.separator=knime.db.connection.parameter.append.initial.separator:?, knime.db.connection.transaction.enabled=knime.db.connection.transaction.enabled:true, knime.db.dialect.sql.create_table.if_not_exists=knime.db.dialect.sql.create_table.if_not_exists:IF NOT EXISTS, knime.db.dialect.sql.drop_table=knime.db.dialect.sql.drop_table:true, knime.db.connection.validation_query=knime.db.connection.validation_query:SELECT 0, knime.db.connection.parameter.append.user_and_password=knime.db.connection.parameter.append.user_and_password:false, knime.db.connection.restore=knime.db.connection.restore:false, knime.db.connection.logger.enabled=knime.db.connection.logger.enabled:false}, none default values={}) 2020-01-15 11:27:09,537 DEBUG PostgreSQL Connector 3:5 Acquiring connection. 2020-01-15 11:27:09,539 DEBUG PostgreSQL Connector 3:5 All the statements have already been closed. 2020-01-15 11:27:09,539 DEBUG PostgreSQL Connector 3:5 The connection has been relinquished. 2020-01-15 11:27:09,539 DEBUG PostgreSQL Connector 3:5 The managed connection has been closed. 2020-01-15 11:27:09,539 DEBUG PostgreSQL Connector 3:5 The transaction managing connection has been closed. 2020-01-15 11:27:09,543 INFO PostgreSQL Connector 3:5 PostgreSQL Connector 3:5 End execute (0 secs) 2020-01-15 11:27:09,543 DEBUG PostgreSQL Connector 3:5 PostgreSQL Connector 3:5 doBeforePostExecution 2020-01-15 11:27:09,543 DEBUG PostgreSQL Connector 3:5 PostgreSQL Connector 3:5 has new state: POSTEXECUTE 2020-01-15 11:27:09,544 DEBUG PostgreSQL Connector 3:5 PostgreSQL Connector 3:5 doAfterExecute - success 2020-01-15 11:27:09,544 DEBUG PostgreSQL Connector 3:5 PostgreSQL Connector 3:5 has new state: EXECUTED 2020-01-15 11:27:09,545 DEBUG DB Table Selector 3:9 Acquiring connection. 2020-01-15 11:27:09,553 DEBUG Microsoft SQL Server Connector 3:1 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.BroadTransactionManagingWrapper. 2020-01-15 11:27:09,554 DEBUG Microsoft SQL Server Connector 3:1 Acquiring connection. 2020-01-15 11:27:09,555 DEBUG Microsoft SQL Server Connector 3:1 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.BroadTransactionManagingWrapper. 2020-01-15 11:27:09,555 DEBUG Microsoft SQL Server Connector 3:1 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.TransactionManagingWrapper. 2020-01-15 11:27:09,560 DEBUG Microsoft SQL Server Connector 3:1 The connection has been relinquished. 2020-01-15 11:27:09,560 DEBUG Microsoft SQL Server Connector 3:1 The managed connection has been closed. 2020-01-15 11:27:09,560 DEBUG Microsoft SQL Server Connector 3:1 The transaction managing connection has been closed. 2020-01-15 11:27:09,561 DEBUG Microsoft SQL Server Connector 3:1 Database session information:DefaultDBSessionInformation(id=cb134eb1-0819-4953-b7d6-09c4f8a95682, dbType=DBType(id=mssqlserver, name=Microsoft SQL Server, description=null), driverDefinition=DBDriverDefinition(id=jTDS for Microsoft SQL Server, name=jTDS for Microsoft SQL Server, version=1.3.0, driverClass=net.sourceforge.jtds.jdbc.Driver, dbType=DBType(id=mssqlserver, name=Microsoft SQL Server, description=null), description=, origin=EXTENSION), connectionController=org.knime.database.connection.UserDBConnectionController=(url=jdbc:jtds:sqlserver://ads.dersdomain.internal:1433/ads_dwh, authenticationType=CREDENTIALS, credential=ssas_credentials), dialectId=mssqlserver, attributeValues={knime.db.connection.restore=true}) 2020-01-15 11:27:09,562 DEBUG DB Table Selector 3:9 All the statements have already been closed. 2020-01-15 11:27:09,562 DEBUG DB Table Selector 3:9 The connection has been relinquished. 2020-01-15 11:27:09,562 DEBUG DB Table Selector 3:9 The managed connection has been closed. 2020-01-15 11:27:09,562 DEBUG DB Table Selector 3:9 The transaction managing connection has been closed. 2020-01-15 11:27:09,562 DEBUG DB Table Selector 3:9 Configure succeeded. (DB Table Selector) 2020-01-15 11:27:09,562 DEBUG PostgreSQL Connector 3:5 DB Table Selector 3:9 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,562 DEBUG PostgreSQL Connector 3:5 DB Table Selector 3:9 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,563 DEBUG Microsoft SQL Server Connector 3:1 Attribute details of database session cb134eb1-0819-4953-b7d6-09c4f8a95682: AttributeValueRepository(attributes={knime.db.connection.jdbc.fetch_size=knime.db.connection.jdbc.fetch_size:10000, knime.db.connection.parameter.append.separator=knime.db.connection.parameter.append.separator:&, knime.db.dialect.sql.delimiter.identifier.opening=knime.db.dialect.sql.delimiter.identifier.opening:", knime.db.dialect.sql.table_reference.keyword=knime.db.dialect.sql.table_reference.keyword:AS, knime.db.dialect.sql.capability.operation.minus=knime.db.dialect.sql.capability.operation.minus:true, knime.db.dialect.sql.insert_into_table_with_select=knime.db.dialect.sql.insert_into_table_with_select:true, knime.db.agent.writer.autocommit_if_failing_on_error=knime.db.agent.writer.autocommit_if_failing_on_error:false, knime.db.dialect.sql.table_reference.derived_table=knime.db.dialect.sql.table_reference.derived_table:true, knime.db.connection.parameter.append=knime.db.connection.parameter.append:false, knime.db.connection.parameter.append.last.suffix=knime.db.connection.parameter.append.last.suffix:, knime.db.connection.jdbc.properties=knime.db.connection.jdbc.properties:#Tue Jan 14 09:50:18 CET 2020 , knime.db.connection.statement.cancellation.polling_period=knime.db.connection.statement.cancellation.polling_period:1000, knime.db.dialect.sql.capability.random=knime.db.dialect.sql.capability.random:true, knime.db.agent.writer.batch.enabled=knime.db.agent.writer.batch.enabled:true, knime.db.connection.statement.cancellation.enabled=knime.db.connection.statement.cancellation.enabled:true, knime.db.connection.metadata.configure.timeout=knime.db.connection.metadata.configure.timeout:3, knime.db.connection.metadata.configure.enabled=knime.db.connection.metadata.configure.enabled:true, knime.db.dialect.sql.create_table.define_constraint_name=knime.db.dialect.sql.create_table.define_constraint_name:true, knime.db.dialect.sql.identifier.delimiting.onlyspaces=knime.db.dialect.sql.identifier.delimiting.onlyspaces:false, knime.db.connection.time_zone=knime.db.connection.time_zone:UTC, knime.db.dialect.sql.capability.random_seed=knime.db.dialect.sql.capability.random_seed:false, knime.db.dialect.sql.identifier.replace.character.non_word.enabled=knime.db.dialect.sql.identifier.replace.character.non_word.enabled:false, knime.db.dialect.sql.create.table.temporary=knime.db.dialect.sql.create.table.temporary:, knime.db.dialect.sql.minus_operator.keyword=knime.db.dialect.sql.minus_operator.keyword:EXCEPT, knime.db.dialect.sql.delimiter.identifier.closing=knime.db.dialect.sql.delimiter.identifier.closing:", knime.db.connection.logger.log.errors=knime.db.connection.logger.log.errors:false, knime.db.dialect.sql.capability.expression.case=knime.db.dialect.sql.capability.expression.case:true, knime.db.dialect.sql.identifier.replace.character.non_word.replacement=knime.db.dialect.sql.identifier.replace.character.non_word.replacement:, knime.db.connection.parameter.append.initial.separator=knime.db.connection.parameter.append.initial.separator:?, knime.db.connection.transaction.enabled=knime.db.connection.transaction.enabled:true, knime.db.dialect.sql.create_table.if_not_exists=knime.db.dialect.sql.create_table.if_not_exists:, knime.db.dialect.sql.drop_table=knime.db.dialect.sql.drop_table:true, knime.db.connection.validation_query=knime.db.connection.validation_query:SELECT 0, knime.db.connection.parameter.append.user_and_password=knime.db.connection.parameter.append.user_and_password:false, knime.db.connection.restore=knime.db.connection.restore:false, knime.db.connection.logger.enabled=knime.db.connection.logger.enabled:false}, none default values={knime.db.connection.restore=true}) 2020-01-15 11:27:09,564 DEBUG Microsoft SQL Server Connector 3:1 Acquiring connection. 2020-01-15 11:27:09,566 DEBUG Microsoft SQL Server Connector 3:1 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.BroadTransactionManagingWrapper. 2020-01-15 11:27:09,568 DEBUG DB Table Selector 3:10 Acquiring connection. 2020-01-15 11:27:09,568 DEBUG Microsoft SQL Server Connector 3:1 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.TransactionManagingWrapper. 2020-01-15 11:27:09,577 DEBUG DB Table Selector 3:10 All the statements have already been closed. 2020-01-15 11:27:09,577 DEBUG DB Table Selector 3:10 The connection has been relinquished. 2020-01-15 11:27:09,577 DEBUG DB Table Selector 3:10 The managed connection has been closed. 2020-01-15 11:27:09,577 DEBUG DB Table Selector 3:10 The transaction managing connection has been closed. 2020-01-15 11:27:09,577 DEBUG DB Table Selector 3:10 Configure succeeded. (DB Table Selector) 2020-01-15 11:27:09,577 DEBUG PostgreSQL Connector 3:5 DB Table Selector 3:10 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,577 DEBUG PostgreSQL Connector 3:5 DB Table Selector 3:10 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,578 DEBUG DB Column Filter 3:11 Acquiring connection. 2020-01-15 11:27:09,579 DEBUG Microsoft SQL Server Connector 3:1 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.BroadTransactionManagingWrapper. 2020-01-15 11:27:09,580 DEBUG DB Column Filter 3:11 All the statements have already been closed. 2020-01-15 11:27:09,581 DEBUG Microsoft SQL Server Connector 3:1 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.TransactionManagingWrapper. 2020-01-15 11:27:09,581 DEBUG DB Column Filter 3:11 The connection has been relinquished. 2020-01-15 11:27:09,582 DEBUG DB Column Filter 3:11 The managed connection has been closed. 2020-01-15 11:27:09,582 DEBUG Microsoft SQL Server Connector 3:1 All the statements have already been closed. 2020-01-15 11:27:09,582 DEBUG DB Column Filter 3:11 The transaction managing connection has been closed. 2020-01-15 11:27:09,582 DEBUG Microsoft SQL Server Connector 3:1 The connection has been relinquished. 2020-01-15 11:27:09,582 DEBUG DB Column Filter 3:11 Configure succeeded. (DB Column Filter) 2020-01-15 11:27:09,582 DEBUG Microsoft SQL Server Connector 3:1 The managed connection has been closed. 2020-01-15 11:27:09,582 DEBUG PostgreSQL Connector 3:5 DB Column Filter 3:11 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,582 DEBUG Microsoft SQL Server Connector 3:1 The transaction managing connection has been closed. 2020-01-15 11:27:09,584 DEBUG DB Column Filter 3:12 Acquiring connection. 2020-01-15 11:27:09,585 INFO Microsoft SQL Server Connector 3:1 Microsoft SQL Server Connector 3:1 End execute (0 secs) 2020-01-15 11:27:09,586 DEBUG DB Column Filter 3:12 All the statements have already been closed. 2020-01-15 11:27:09,586 DEBUG DB Column Filter 3:12 The connection has been relinquished. 2020-01-15 11:27:09,587 DEBUG DB Column Filter 3:12 The managed connection has been closed. 2020-01-15 11:27:09,587 DEBUG DB Column Filter 3:12 The transaction managing connection has been closed. 2020-01-15 11:27:09,587 DEBUG DB Column Filter 3:12 Configure succeeded. (DB Column Filter) 2020-01-15 11:27:09,587 DEBUG PostgreSQL Connector 3:5 DB Column Filter 3:12 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,587 DEBUG DB Reader 3:13 Configure succeeded. (DB Reader) 2020-01-15 11:27:09,587 DEBUG PostgreSQL Connector 3:5 DB Reader 3:13 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,588 DEBUG DB Column Rename 3:16 No rename settings for column "active", leaving it untouched. 2020-01-15 11:27:09,588 DEBUG DB Column Rename 3:16 Acquiring connection. 2020-01-15 11:27:09,590 DEBUG DB Column Rename 3:16 All the statements have already been closed. 2020-01-15 11:27:09,590 DEBUG DB Column Rename 3:16 The connection has been relinquished. 2020-01-15 11:27:09,590 DEBUG DB Column Rename 3:16 The managed connection has been closed. 2020-01-15 11:27:09,591 DEBUG DB Column Rename 3:16 The transaction managing connection has been closed. 2020-01-15 11:27:09,591 DEBUG DB Column Rename 3:16 Configure succeeded. (DB Column Rename) 2020-01-15 11:27:09,591 DEBUG PostgreSQL Connector 3:5 DB Column Rename 3:16 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,591 DEBUG DB Reader 3:14 Configure succeeded. (DB Reader) 2020-01-15 11:27:09,591 DEBUG PostgreSQL Connector 3:5 DB Reader 3:14 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,592 DEBUG Concatenate 3:15 Configure succeeded. (Concatenate) 2020-01-15 11:27:09,592 DEBUG PostgreSQL Connector 3:5 Concatenate 3:15 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,592 DEBUG Row Filter 3:17 Configure succeeded. (Row Filter) 2020-01-15 11:27:09,592 DEBUG PostgreSQL Connector 3:5 Row Filter 3:17 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,593 DEBUG Row Filter 3:22 Configure succeeded. (Row Filter) 2020-01-15 11:27:09,593 DEBUG PostgreSQL Connector 3:5 Row Filter 3:22 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,593 DEBUG Table Row To Variable Loop Start 3:18 Configure succeeded. (Table Row To Variable Loop Start) 2020-01-15 11:27:09,593 DEBUG PostgreSQL Connector 3:5 Table Row To Variable Loop Start 3:18 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,597 DEBUG PostgreSQL Connector 3:6 Configure succeeded. (PostgreSQL Connector) 2020-01-15 11:27:09,597 DEBUG PostgreSQL Connector 3:5 PostgreSQL Connector 3:6 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,598 DEBUG DB Table Selector 3:9 DB Table Selector 3:9 doBeforePreExecution 2020-01-15 11:27:09,598 DEBUG DB Table Selector 3:9 DB Table Selector 3:9 has new state: PREEXECUTE 2020-01-15 11:27:09,598 DEBUG DB Table Selector 3:10 DB Table Selector 3:10 doBeforePreExecution 2020-01-15 11:27:09,598 DEBUG DB Table Selector 3:10 DB Table Selector 3:10 has new state: PREEXECUTE 2020-01-15 11:27:09,598 DEBUG Microsoft SQL Server Connector 3:1 Microsoft SQL Server Connector 3:1 doBeforePostExecution 2020-01-15 11:27:09,598 DEBUG Microsoft SQL Server Connector 3:1 Microsoft SQL Server Connector 3:1 has new state: POSTEXECUTE 2020-01-15 11:27:09,599 DEBUG Microsoft SQL Server Connector 3:1 Microsoft SQL Server Connector 3:1 doAfterExecute - success 2020-01-15 11:27:09,599 DEBUG Microsoft SQL Server Connector 3:1 Microsoft SQL Server Connector 3:1 has new state: EXECUTED 2020-01-15 11:27:09,599 DEBUG DB Table Selector 3:10 Adding handler caa0f327-5f56-42cf-803e-c889d2c75a97 (DB Table Selector 3:10: ) - 64 in total 2020-01-15 11:27:09,598 DEBUG DB Table Selector 3:9 Adding handler 95dd3b18-b8be-42d4-90c3-35e58dccff1d (DB Table Selector 3:9: ) - 63 in total 2020-01-15 11:27:09,599 DEBUG DB Table Selector 3:10 DB Table Selector 3:10 doBeforeExecution 2020-01-15 11:27:09,599 DEBUG DB Table Selector 3:10 DB Table Selector 3:10 has new state: EXECUTING 2020-01-15 11:27:09,599 DEBUG DB Table Selector 3:10 DB Table Selector 3:10 Start execute 2020-01-15 11:27:09,600 DEBUG DB Table Selector 3:9 DB Table Selector 3:9 doBeforeExecution 2020-01-15 11:27:09,600 DEBUG DB Table Selector 3:9 DB Table Selector 3:9 has new state: EXECUTING 2020-01-15 11:27:09,600 DEBUG DB Table Selector 3:9 DB Table Selector 3:9 Start execute 2020-01-15 11:27:09,613 INFO DB Table Selector 3:10 DB Table Selector 3:10 End execute (0 secs) 2020-01-15 11:27:09,613 DEBUG DB Table Selector 3:10 DB Table Selector 3:10 doBeforePostExecution 2020-01-15 11:27:09,613 DEBUG DB Table Selector 3:10 DB Table Selector 3:10 has new state: POSTEXECUTE 2020-01-15 11:27:09,613 DEBUG DB Table Selector 3:10 DB Table Selector 3:10 doAfterExecute - success 2020-01-15 11:27:09,613 DEBUG DB Table Selector 3:10 DB Table Selector 3:10 has new state: EXECUTED 2020-01-15 11:27:09,614 DEBUG DB Column Filter 3:12 Acquiring connection. 2020-01-15 11:27:09,620 DEBUG DB Column Filter 3:12 All the statements have already been closed. 2020-01-15 11:27:09,620 DEBUG DB Column Filter 3:12 The connection has been relinquished. 2020-01-15 11:27:09,620 DEBUG DB Column Filter 3:12 The managed connection has been closed. 2020-01-15 11:27:09,620 DEBUG DB Column Filter 3:12 The transaction managing connection has been closed. 2020-01-15 11:27:09,621 DEBUG DB Column Filter 3:12 Configure succeeded. (DB Column Filter) 2020-01-15 11:27:09,621 DEBUG DB Table Selector 3:10 DB Column Filter 3:12 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,621 DEBUG DB Column Rename 3:16 No rename settings for column "active", leaving it untouched. 2020-01-15 11:27:09,622 DEBUG DB Column Rename 3:16 Acquiring connection. 2020-01-15 11:27:09,624 DEBUG DB Column Rename 3:16 All the statements have already been closed. 2020-01-15 11:27:09,625 DEBUG DB Column Rename 3:16 The connection has been relinquished. 2020-01-15 11:27:09,625 DEBUG DB Column Rename 3:16 The managed connection has been closed. 2020-01-15 11:27:09,625 DEBUG DB Column Rename 3:16 The transaction managing connection has been closed. 2020-01-15 11:27:09,625 DEBUG DB Column Rename 3:16 Configure succeeded. (DB Column Rename) 2020-01-15 11:27:09,625 DEBUG DB Reader 3:14 Configure succeeded. (DB Reader) 2020-01-15 11:27:09,626 DEBUG DB Column Filter 3:12 DB Column Filter 3:12 doBeforePreExecution 2020-01-15 11:27:09,626 DEBUG DB Column Filter 3:12 DB Column Filter 3:12 has new state: PREEXECUTE 2020-01-15 11:27:09,626 DEBUG DB Column Filter 3:12 Adding handler 0e300b06-eeb9-4f50-970b-78014fd14769 (DB Column Filter 3:12: ) - 65 in total 2020-01-15 11:27:09,626 DEBUG DB Column Filter 3:12 DB Column Filter 3:12 doBeforeExecution 2020-01-15 11:27:09,626 DEBUG DB Column Filter 3:12 DB Column Filter 3:12 has new state: EXECUTING 2020-01-15 11:27:09,626 DEBUG DB Column Filter 3:12 DB Column Filter 3:12 Start execute 2020-01-15 11:27:09,630 INFO DB Table Selector 3:9 DB Table Selector 3:9 End execute (0 secs) 2020-01-15 11:27:09,630 DEBUG DB Table Selector 3:9 DB Table Selector 3:9 doBeforePostExecution 2020-01-15 11:27:09,630 DEBUG DB Table Selector 3:9 DB Table Selector 3:9 has new state: POSTEXECUTE 2020-01-15 11:27:09,631 DEBUG DB Table Selector 3:9 DB Table Selector 3:9 doAfterExecute - success 2020-01-15 11:27:09,632 DEBUG DB Table Selector 3:9 DB Table Selector 3:9 has new state: EXECUTED 2020-01-15 11:27:09,633 DEBUG DB Column Filter 3:11 Acquiring connection. 2020-01-15 11:27:09,636 DEBUG DB Column Filter 3:11 All the statements have already been closed. 2020-01-15 11:27:09,636 DEBUG DB Column Filter 3:11 The connection has been relinquished. 2020-01-15 11:27:09,636 DEBUG DB Column Filter 3:11 The managed connection has been closed. 2020-01-15 11:27:09,636 DEBUG DB Column Filter 3:11 The transaction managing connection has been closed. 2020-01-15 11:27:09,636 DEBUG DB Column Filter 3:11 Configure succeeded. (DB Column Filter) 2020-01-15 11:27:09,637 DEBUG DB Table Selector 3:9 DB Column Filter 3:11 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,638 DEBUG DB Reader 3:13 Configure succeeded. (DB Reader) 2020-01-15 11:27:09,638 INFO DB Column Filter 3:12 DB Column Filter 3:12 End execute (0 secs) 2020-01-15 11:27:09,638 DEBUG DB Column Filter 3:11 DB Column Filter 3:11 doBeforePreExecution 2020-01-15 11:27:09,638 DEBUG DB Column Filter 3:11 DB Column Filter 3:11 has new state: PREEXECUTE 2020-01-15 11:27:09,638 DEBUG DB Column Filter 3:12 DB Column Filter 3:12 doBeforePostExecution 2020-01-15 11:27:09,638 DEBUG DB Column Filter 3:11 Adding handler 9b368455-2d1f-45bd-888c-6f6fef9e3d96 (DB Column Filter 3:11: ) - 66 in total 2020-01-15 11:27:09,638 DEBUG DB Column Filter 3:12 DB Column Filter 3:12 has new state: POSTEXECUTE 2020-01-15 11:27:09,638 DEBUG DB Column Filter 3:12 DB Column Filter 3:12 doAfterExecute - success 2020-01-15 11:27:09,638 DEBUG DB Column Filter 3:12 DB Column Filter 3:12 has new state: EXECUTED 2020-01-15 11:27:09,639 DEBUG DB Column Rename 3:16 No rename settings for column "active", leaving it untouched. 2020-01-15 11:27:09,639 DEBUG DB Column Rename 3:16 Acquiring connection. 2020-01-15 11:27:09,642 DEBUG DB Column Rename 3:16 All the statements have already been closed. 2020-01-15 11:27:09,642 DEBUG DB Column Rename 3:16 The connection has been relinquished. 2020-01-15 11:27:09,642 DEBUG DB Column Rename 3:16 The managed connection has been closed. 2020-01-15 11:27:09,642 DEBUG DB Column Rename 3:16 The transaction managing connection has been closed. 2020-01-15 11:27:09,643 DEBUG DB Column Rename 3:16 Configure succeeded. (DB Column Rename) 2020-01-15 11:27:09,643 DEBUG DB Column Filter 3:12 DB Column Rename 3:16 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,643 DEBUG DB Reader 3:14 Configure succeeded. (DB Reader) 2020-01-15 11:27:09,644 DEBUG DB Column Filter 3:11 DB Column Filter 3:11 doBeforeExecution 2020-01-15 11:27:09,644 DEBUG DB Column Filter 3:11 DB Column Filter 3:11 has new state: EXECUTING 2020-01-15 11:27:09,644 DEBUG DB Column Filter 3:11 DB Column Filter 3:11 Start execute 2020-01-15 11:27:09,646 DEBUG DB Column Rename 3:16 DB Column Rename 3:16 doBeforePreExecution 2020-01-15 11:27:09,646 DEBUG DB Column Rename 3:16 DB Column Rename 3:16 has new state: PREEXECUTE 2020-01-15 11:27:09,646 DEBUG DB Column Rename 3:16 Adding handler b3ac4942-965f-4303-8700-f20d35f2694a (DB Column Rename 3:16: ) - 67 in total 2020-01-15 11:27:09,646 DEBUG DB Column Rename 3:16 DB Column Rename 3:16 doBeforeExecution 2020-01-15 11:27:09,646 DEBUG DB Column Rename 3:16 DB Column Rename 3:16 has new state: EXECUTING 2020-01-15 11:27:09,646 DEBUG DB Column Rename 3:16 DB Column Rename 3:16 Start execute 2020-01-15 11:27:09,655 INFO DB Column Filter 3:11 DB Column Filter 3:11 End execute (0 secs) 2020-01-15 11:27:09,655 DEBUG DB Column Filter 3:11 DB Column Filter 3:11 doBeforePostExecution 2020-01-15 11:27:09,655 DEBUG DB Column Filter 3:11 DB Column Filter 3:11 has new state: POSTEXECUTE 2020-01-15 11:27:09,655 DEBUG DB Column Filter 3:11 DB Column Filter 3:11 doAfterExecute - success 2020-01-15 11:27:09,655 DEBUG DB Column Filter 3:11 DB Column Filter 3:11 has new state: EXECUTED 2020-01-15 11:27:09,656 DEBUG DB Reader 3:13 Configure succeeded. (DB Reader) 2020-01-15 11:27:09,656 DEBUG DB Column Filter 3:11 DB Reader 3:13 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,657 DEBUG DB Reader 3:13 DB Reader 3:13 doBeforePreExecution 2020-01-15 11:27:09,657 DEBUG DB Reader 3:13 DB Reader 3:13 has new state: PREEXECUTE 2020-01-15 11:27:09,657 DEBUG DB Reader 3:13 Adding handler 8e4abc50-dec7-412f-9767-fe1ee39a8bdc (DB Reader 3:13: ) - 68 in total 2020-01-15 11:27:09,657 DEBUG DB Reader 3:13 DB Reader 3:13 doBeforeExecution 2020-01-15 11:27:09,657 DEBUG DB Reader 3:13 DB Reader 3:13 has new state: EXECUTING 2020-01-15 11:27:09,657 DEBUG DB Reader 3:13 DB Reader 3:13 Start execute 2020-01-15 11:27:09,674 DEBUG DB Reader 3:13 Preparing to read from database 2020-01-15 11:27:09,674 DEBUG DB Reader 3:13 Acquiring connection. 2020-01-15 11:27:09,679 DEBUG DB Reader 3:13 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,679 INFO DB Column Rename 3:16 DB Column Rename 3:16 End execute (0 secs) 2020-01-15 11:27:09,679 DEBUG DB Reader 3:13 Closing the small-scale transaction... 2020-01-15 11:27:09,679 DEBUG DB Reader 3:13 Rolling back all uncommitted changes... 2020-01-15 11:27:09,679 DEBUG DB Column Rename 3:16 DB Column Rename 3:16 doBeforePostExecution 2020-01-15 11:27:09,680 DEBUG DB Column Rename 3:16 DB Column Rename 3:16 has new state: POSTEXECUTE 2020-01-15 11:27:09,680 DEBUG DB Column Rename 3:16 DB Column Rename 3:16 doAfterExecute - success 2020-01-15 11:27:09,680 DEBUG DB Column Rename 3:16 DB Column Rename 3:16 has new state: EXECUTED 2020-01-15 11:27:09,681 DEBUG DB Reader 3:13 Enabling auto-commit mode... 2020-01-15 11:27:09,681 DEBUG DB Reader 3:13 The small-scale transaction has been successfully closed. 2020-01-15 11:27:09,681 DEBUG DB Reader 3:13 The small-scale transaction has been removed. 2020-01-15 11:27:09,681 DEBUG DB Reader 3:13 All the statements have already been closed. 2020-01-15 11:27:09,681 DEBUG DB Reader 3:13 The connection has been relinquished. 2020-01-15 11:27:09,681 DEBUG DB Reader 3:13 The managed connection has been closed. 2020-01-15 11:27:09,681 DEBUG DB Reader 3:14 Configure succeeded. (DB Reader) 2020-01-15 11:27:09,681 DEBUG DB Reader 3:13 The transaction managing connection has been closed. 2020-01-15 11:27:09,681 DEBUG DB Column Rename 3:16 DB Reader 3:14 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,681 DEBUG DB Reader 3:14 DB Reader 3:14 doBeforePreExecution 2020-01-15 11:27:09,682 DEBUG DB Reader 3:14 DB Reader 3:14 has new state: PREEXECUTE 2020-01-15 11:27:09,682 INFO DB Reader 3:13 DB Reader 3:13 End execute (0 secs) 2020-01-15 11:27:09,682 DEBUG DB Reader 3:13 DB Reader 3:13 doBeforePostExecution 2020-01-15 11:27:09,682 DEBUG DB Reader 3:13 DB Reader 3:13 has new state: POSTEXECUTE 2020-01-15 11:27:09,682 DEBUG DB Reader 3:13 DB Reader 3:13 doAfterExecute - success 2020-01-15 11:27:09,682 DEBUG DB Reader 3:14 Adding handler 11e59ad0-afc7-4b65-9404-fbceecaa46b6 (DB Reader 3:14: ) - 69 in total 2020-01-15 11:27:09,682 DEBUG DB Reader 3:13 DB Reader 3:13 has new state: EXECUTED 2020-01-15 11:27:09,683 DEBUG Concatenate 3:15 Configure succeeded. (Concatenate) 2020-01-15 11:27:09,683 DEBUG DB Reader 3:14 DB Reader 3:14 doBeforeExecution 2020-01-15 11:27:09,683 DEBUG DB Reader 3:14 DB Reader 3:14 has new state: EXECUTING 2020-01-15 11:27:09,683 DEBUG DB Reader 3:14 DB Reader 3:14 Start execute 2020-01-15 11:27:09,696 DEBUG DB Reader 3:14 Preparing to read from database 2020-01-15 11:27:09,696 DEBUG DB Reader 3:14 Acquiring connection. 2020-01-15 11:27:09,700 DEBUG DB Reader 3:14 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,700 DEBUG DB Reader 3:14 Closing the small-scale transaction... 2020-01-15 11:27:09,700 DEBUG DB Reader 3:14 Rolling back all uncommitted changes... 2020-01-15 11:27:09,702 DEBUG DB Reader 3:14 Enabling auto-commit mode... 2020-01-15 11:27:09,702 DEBUG DB Reader 3:14 The small-scale transaction has been successfully closed. 2020-01-15 11:27:09,702 DEBUG DB Reader 3:14 The small-scale transaction has been removed. 2020-01-15 11:27:09,702 DEBUG DB Reader 3:14 All the statements have already been closed. 2020-01-15 11:27:09,702 DEBUG DB Reader 3:14 The connection has been relinquished. 2020-01-15 11:27:09,702 DEBUG DB Reader 3:14 The managed connection has been closed. 2020-01-15 11:27:09,702 DEBUG DB Reader 3:14 The transaction managing connection has been closed. 2020-01-15 11:27:09,703 INFO DB Reader 3:14 DB Reader 3:14 End execute (0 secs) 2020-01-15 11:27:09,703 DEBUG DB Reader 3:14 DB Reader 3:14 doBeforePostExecution 2020-01-15 11:27:09,703 DEBUG DB Reader 3:14 DB Reader 3:14 has new state: POSTEXECUTE 2020-01-15 11:27:09,703 DEBUG DB Reader 3:14 DB Reader 3:14 doAfterExecute - success 2020-01-15 11:27:09,703 DEBUG DB Reader 3:14 DB Reader 3:14 has new state: EXECUTED 2020-01-15 11:27:09,704 DEBUG Concatenate 3:15 Configure succeeded. (Concatenate) 2020-01-15 11:27:09,704 DEBUG DB Reader 3:14 Concatenate 3:15 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,704 DEBUG Row Filter 3:17 Configure succeeded. (Row Filter) 2020-01-15 11:27:09,705 DEBUG Row Filter 3:22 Configure succeeded. (Row Filter) 2020-01-15 11:27:09,705 DEBUG Table Row To Variable Loop Start 3:18 Configure succeeded. (Table Row To Variable Loop Start) 2020-01-15 11:27:09,705 DEBUG Concatenate 3:15 Concatenate 3:15 doBeforePreExecution 2020-01-15 11:27:09,705 DEBUG Concatenate 3:15 Concatenate 3:15 has new state: PREEXECUTE 2020-01-15 11:27:09,705 DEBUG Concatenate 3:15 Adding handler 94ee2383-253b-426d-84cc-8cdbd311be12 (Concatenate 3:15: ) - 70 in total 2020-01-15 11:27:09,705 DEBUG Concatenate 3:15 Concatenate 3:15 doBeforeExecution 2020-01-15 11:27:09,706 DEBUG Concatenate 3:15 Concatenate 3:15 has new state: EXECUTING 2020-01-15 11:27:09,706 DEBUG Concatenate 3:15 Concatenate 3:15 Start execute 2020-01-15 11:27:09,706 INFO Concatenate 3:15 Concatenate 3:15 End execute (0 secs) 2020-01-15 11:27:09,706 DEBUG Concatenate 3:15 Concatenate 3:15 doBeforePostExecution 2020-01-15 11:27:09,706 DEBUG Concatenate 3:15 Concatenate 3:15 has new state: POSTEXECUTE 2020-01-15 11:27:09,706 DEBUG Concatenate 3:15 Concatenate 3:15 doAfterExecute - success 2020-01-15 11:27:09,706 DEBUG Concatenate 3:15 Concatenate 3:15 has new state: EXECUTED 2020-01-15 11:27:09,707 DEBUG Row Filter 3:17 Configure succeeded. (Row Filter) 2020-01-15 11:27:09,707 DEBUG Concatenate 3:15 Row Filter 3:17 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,707 DEBUG Row Filter 3:17 Row Filter 3:17 doBeforePreExecution 2020-01-15 11:27:09,707 DEBUG Row Filter 3:17 Row Filter 3:17 has new state: PREEXECUTE 2020-01-15 11:27:09,707 DEBUG Row Filter 3:17 Adding handler ff00009d-f17f-4541-9de6-29ba91e113bd (Row Filter 3:17: ) - 71 in total 2020-01-15 11:27:09,708 DEBUG Row Filter 3:17 Row Filter 3:17 doBeforeExecution 2020-01-15 11:27:09,708 DEBUG Row Filter 3:17 Row Filter 3:17 has new state: EXECUTING 2020-01-15 11:27:09,708 DEBUG Row Filter 3:17 Row Filter 3:17 Start execute 2020-01-15 11:27:09,708 DEBUG Row Filter 3:17 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,711 INFO Row Filter 3:17 Row Filter 3:17 End execute (0 secs) 2020-01-15 11:27:09,712 DEBUG Row Filter 3:17 Row Filter 3:17 doBeforePostExecution 2020-01-15 11:27:09,712 DEBUG Row Filter 3:17 Row Filter 3:17 has new state: POSTEXECUTE 2020-01-15 11:27:09,712 DEBUG Row Filter 3:17 Row Filter 3:17 doAfterExecute - success 2020-01-15 11:27:09,712 DEBUG Row Filter 3:17 Row Filter 3:17 has new state: EXECUTED 2020-01-15 11:27:09,713 DEBUG Row Filter 3:22 Configure succeeded. (Row Filter) 2020-01-15 11:27:09,713 DEBUG Row Filter 3:17 Row Filter 3:22 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,713 DEBUG Row Filter 3:22 Row Filter 3:22 doBeforePreExecution 2020-01-15 11:27:09,713 DEBUG Row Filter 3:22 Row Filter 3:22 has new state: PREEXECUTE 2020-01-15 11:27:09,713 DEBUG Row Filter 3:22 Adding handler 3c3ac296-071c-4fc2-a2e3-e288d2462b3f (Row Filter 3:22: ) - 72 in total 2020-01-15 11:27:09,713 DEBUG Row Filter 3:22 Row Filter 3:22 doBeforeExecution 2020-01-15 11:27:09,713 DEBUG Row Filter 3:22 Row Filter 3:22 has new state: EXECUTING 2020-01-15 11:27:09,714 DEBUG Row Filter 3:22 Row Filter 3:22 Start execute 2020-01-15 11:27:09,714 DEBUG Row Filter 3:22 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:09,715 INFO Row Filter 3:22 Row Filter 3:22 End execute (0 secs) 2020-01-15 11:27:09,715 DEBUG Row Filter 3:22 Row Filter 3:22 doBeforePostExecution 2020-01-15 11:27:09,715 DEBUG Row Filter 3:22 Row Filter 3:22 has new state: POSTEXECUTE 2020-01-15 11:27:09,715 DEBUG Row Filter 3:22 Row Filter 3:22 doAfterExecute - success 2020-01-15 11:27:09,715 DEBUG Row Filter 3:22 Row Filter 3:22 has new state: EXECUTED 2020-01-15 11:27:09,716 DEBUG Table Row To Variable Loop Start 3:18 Configure succeeded. (Table Row To Variable Loop Start) 2020-01-15 11:27:09,716 DEBUG Row Filter 3:22 Table Row To Variable Loop Start 3:18 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,716 DEBUG Table Row To Variable Loop Start 3:18 Table Row To Variable Loop Start 3:18 doBeforePreExecution 2020-01-15 11:27:09,716 DEBUG Table Row To Variable Loop Start 3:18 Table Row To Variable Loop Start 3:18 has new state: PREEXECUTE 2020-01-15 11:27:09,716 DEBUG Table Row To Variable Loop Start 3:18 Adding handler 89c974aa-c2c9-462b-b83e-310f011ec00b (Table Row To Variable Loop Start 3:18: ) - 73 in total 2020-01-15 11:27:09,716 DEBUG Table Row To Variable Loop Start 3:18 Table Row To Variable Loop Start 3:18 doBeforeExecution 2020-01-15 11:27:09,716 DEBUG Table Row To Variable Loop Start 3:18 Table Row To Variable Loop Start 3:18 has new state: EXECUTING 2020-01-15 11:27:09,716 DEBUG Table Row To Variable Loop Start 3:18 Table Row To Variable Loop Start 3:18 Start execute 2020-01-15 11:27:09,717 INFO Table Row To Variable Loop Start 3:18 Table Row To Variable Loop Start 3:18 End execute (0 secs) 2020-01-15 11:27:09,717 DEBUG Table Row To Variable Loop Start 3:18 Table Row To Variable Loop Start 3:18 doBeforePostExecution 2020-01-15 11:27:09,717 DEBUG Table Row To Variable Loop Start 3:18 Table Row To Variable Loop Start 3:18 has new state: POSTEXECUTE 2020-01-15 11:27:09,717 DEBUG Table Row To Variable Loop Start 3:18 Table Row To Variable Loop Start 3:18 doAfterExecute - success 2020-01-15 11:27:09,717 DEBUG Table Row To Variable Loop Start 3:18 Table Row To Variable Loop Start 3:18 has new state: EXECUTED 2020-01-15 11:27:09,720 DEBUG PostgreSQL Connector 3:6 Configure succeeded. (PostgreSQL Connector) 2020-01-15 11:27:09,721 DEBUG Table Row To Variable Loop Start 3:18 PostgreSQL Connector 3:6 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,721 DEBUG PostgreSQL Connector 3:6 PostgreSQL Connector 3:6 doBeforePreExecution 2020-01-15 11:27:09,721 DEBUG PostgreSQL Connector 3:6 PostgreSQL Connector 3:6 has new state: PREEXECUTE 2020-01-15 11:27:09,721 DEBUG PostgreSQL Connector 3:6 PostgreSQL Connector 3:6 doBeforeExecution 2020-01-15 11:27:09,721 DEBUG PostgreSQL Connector 3:6 PostgreSQL Connector 3:6 has new state: EXECUTING 2020-01-15 11:27:09,721 DEBUG PostgreSQL Connector 3:6 PostgreSQL Connector 3:6 Start execute 2020-01-15 11:27:09,722 DEBUG PostgreSQL Connector 3:6 New database session: DefaultDBSessionInformation(id=2ee48693-a6a6-4efe-9b32-311018a147d0, dbType=DBType(id=postgres, name=PostgreSQL, description=null), driverDefinition=DBDriverDefinition(id=PostgreSQL, name=PostgreSQL, version=42.2.0, driverClass=org.postgresql.Driver, dbType=DBType(id=postgres, name=PostgreSQL, description=null), description=, origin=EXTENSION), connectionController=org.knime.database.connection.UserDBConnectionController=(url=jdbc:postgresql://ads_dwh_db_host:5432/pgtestdb, authenticationType=CREDENTIALS, credential=dwh_credentials), dialectId=postgres, attributeValues={knime.db.connection.restore=true}) 2020-01-15 11:27:09,739 DEBUG PostgreSQL Connector 3:6 Acquiring connection. 2020-01-15 11:27:09,754 DEBUG PostgreSQL Connector 3:6 The connection has been relinquished. 2020-01-15 11:27:09,754 DEBUG PostgreSQL Connector 3:6 The managed connection has been closed. 2020-01-15 11:27:09,754 DEBUG PostgreSQL Connector 3:6 The transaction managing connection has been closed. 2020-01-15 11:27:09,754 DEBUG PostgreSQL Connector 3:6 Database session information:DefaultDBSessionInformation(id=2ee48693-a6a6-4efe-9b32-311018a147d0, dbType=DBType(id=postgres, name=PostgreSQL, description=null), driverDefinition=DBDriverDefinition(id=PostgreSQL, name=PostgreSQL, version=42.2.0, driverClass=org.postgresql.Driver, dbType=DBType(id=postgres, name=PostgreSQL, description=null), description=, origin=EXTENSION), connectionController=org.knime.database.connection.UserDBConnectionController=(url=jdbc:postgresql://ads_dwh_db_host:5432/pgtestdb, authenticationType=CREDENTIALS, credential=dwh_credentials), dialectId=postgres, attributeValues={knime.db.connection.restore=true}) 2020-01-15 11:27:09,755 DEBUG PostgreSQL Connector 3:6 Attribute details of database session 2ee48693-a6a6-4efe-9b32-311018a147d0: AttributeValueRepository(attributes={knime.db.connection.jdbc.fetch_size=knime.db.connection.jdbc.fetch_size:10000, knime.db.connection.parameter.append.separator=knime.db.connection.parameter.append.separator:&, knime.db.dialect.sql.delimiter.identifier.opening=knime.db.dialect.sql.delimiter.identifier.opening:", knime.db.dialect.sql.table_reference.keyword=knime.db.dialect.sql.table_reference.keyword:AS, knime.db.dialect.sql.capability.operation.minus=knime.db.dialect.sql.capability.operation.minus:true, knime.db.dialect.sql.insert_into_table_with_select=knime.db.dialect.sql.insert_into_table_with_select:true, knime.db.agent.writer.autocommit_if_failing_on_error=knime.db.agent.writer.autocommit_if_failing_on_error:true, knime.db.dialect.sql.table_reference.derived_table=knime.db.dialect.sql.table_reference.derived_table:true, knime.db.connection.parameter.append=knime.db.connection.parameter.append:false, knime.db.connection.parameter.append.last.suffix=knime.db.connection.parameter.append.last.suffix:, knime.db.connection.jdbc.properties=knime.db.connection.jdbc.properties:#Tue Jan 14 09:50:18 CET 2020 , knime.db.connection.statement.cancellation.polling_period=knime.db.connection.statement.cancellation.polling_period:1000, knime.db.dialect.sql.capability.random=knime.db.dialect.sql.capability.random:true, knime.db.agent.writer.batch.enabled=knime.db.agent.writer.batch.enabled:true, knime.db.connection.statement.cancellation.enabled=knime.db.connection.statement.cancellation.enabled:true, knime.db.connection.metadata.configure.timeout=knime.db.connection.metadata.configure.timeout:3, knime.db.connection.metadata.configure.enabled=knime.db.connection.metadata.configure.enabled:true, knime.db.dialect.sql.create_table.define_constraint_name=knime.db.dialect.sql.create_table.define_constraint_name:true, knime.db.dialect.sql.identifier.delimiting.onlyspaces=knime.db.dialect.sql.identifier.delimiting.onlyspaces:false, knime.db.connection.time_zone=knime.db.connection.time_zone:UTC, knime.db.dialect.sql.capability.random_seed=knime.db.dialect.sql.capability.random_seed:false, knime.db.dialect.sql.identifier.replace.character.non_word.enabled=knime.db.dialect.sql.identifier.replace.character.non_word.enabled:false, knime.db.dialect.sql.create.table.temporary=knime.db.dialect.sql.create.table.temporary:GLOBAL TEMPORARY, knime.db.dialect.sql.minus_operator.keyword=knime.db.dialect.sql.minus_operator.keyword:EXCEPT, knime.db.dialect.sql.delimiter.identifier.closing=knime.db.dialect.sql.delimiter.identifier.closing:", knime.db.connection.logger.log.errors=knime.db.connection.logger.log.errors:false, knime.db.dialect.sql.capability.expression.case=knime.db.dialect.sql.capability.expression.case:true, knime.db.dialect.sql.identifier.replace.character.non_word.replacement=knime.db.dialect.sql.identifier.replace.character.non_word.replacement:, knime.db.connection.parameter.append.initial.separator=knime.db.connection.parameter.append.initial.separator:?, knime.db.connection.transaction.enabled=knime.db.connection.transaction.enabled:true, knime.db.dialect.sql.create_table.if_not_exists=knime.db.dialect.sql.create_table.if_not_exists:IF NOT EXISTS, knime.db.dialect.sql.drop_table=knime.db.dialect.sql.drop_table:true, knime.db.connection.validation_query=knime.db.connection.validation_query:SELECT 0, knime.db.connection.parameter.append.user_and_password=knime.db.connection.parameter.append.user_and_password:false, knime.db.connection.restore=knime.db.connection.restore:false, knime.db.connection.logger.enabled=knime.db.connection.logger.enabled:false}, none default values={knime.db.connection.restore=true}) 2020-01-15 11:27:09,755 DEBUG PostgreSQL Connector 3:6 Acquiring connection. 2020-01-15 11:27:09,757 DEBUG PostgreSQL Connector 3:6 All the statements have already been closed. 2020-01-15 11:27:09,757 DEBUG PostgreSQL Connector 3:6 The connection has been relinquished. 2020-01-15 11:27:09,757 DEBUG PostgreSQL Connector 3:6 The managed connection has been closed. 2020-01-15 11:27:09,757 DEBUG PostgreSQL Connector 3:6 The transaction managing connection has been closed. 2020-01-15 11:27:09,759 INFO PostgreSQL Connector 3:6 PostgreSQL Connector 3:6 End execute (0 secs) 2020-01-15 11:27:09,759 DEBUG PostgreSQL Connector 3:6 PostgreSQL Connector 3:6 doBeforePostExecution 2020-01-15 11:27:09,759 DEBUG PostgreSQL Connector 3:6 PostgreSQL Connector 3:6 has new state: POSTEXECUTE 2020-01-15 11:27:09,759 DEBUG PostgreSQL Connector 3:6 PostgreSQL Connector 3:6 doAfterExecute - success 2020-01-15 11:27:09,759 DEBUG PostgreSQL Connector 3:6 PostgreSQL Connector 3:6 has new state: EXECUTED 2020-01-15 11:27:09,762 DEBUG DB Table Selector 3:20 Acquiring connection. 2020-01-15 11:27:09,781 DEBUG DB Table Selector 3:20 All the statements have already been closed. 2020-01-15 11:27:09,781 DEBUG DB Table Selector 3:20 The connection has been relinquished. 2020-01-15 11:27:09,781 DEBUG DB Table Selector 3:20 The managed connection has been closed. 2020-01-15 11:27:09,781 DEBUG DB Table Selector 3:20 The transaction managing connection has been closed. 2020-01-15 11:27:09,781 DEBUG DB Table Selector 3:20 Configure succeeded. (DB Table Selector) 2020-01-15 11:27:09,781 DEBUG PostgreSQL Connector 3:6 DB Table Selector 3:20 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,781 DEBUG PostgreSQL Connector 3:6 DB Table Selector 3:20 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,786 DEBUG DB Reader 3:21 Configure succeeded. (DB Reader) 2020-01-15 11:27:09,786 DEBUG PostgreSQL Connector 3:6 DB Reader 3:21 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,789 DEBUG DB Writer 3:23 Acquiring connection. 2020-01-15 11:27:09,789 DEBUG DB Writer 3:23 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.BroadTransactionManagingWrapper. 2020-01-15 11:27:09,790 DEBUG DB Writer 3:23 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.TransactionManagingWrapper. 2020-01-15 11:27:09,803 DEBUG DB Writer 3:23 All the statements have already been closed. 2020-01-15 11:27:09,803 DEBUG DB Writer 3:23 The connection has been relinquished. 2020-01-15 11:27:09,803 DEBUG DB Writer 3:23 The managed connection has been closed. 2020-01-15 11:27:09,803 DEBUG DB Writer 3:23 The transaction managing connection has been closed. 2020-01-15 11:27:09,803 DEBUG DB Writer 3:23 Configure succeeded. (DB Writer) 2020-01-15 11:27:09,803 DEBUG PostgreSQL Connector 3:6 DB Writer 3:23 has new state: CONFIGURED_MARKEDFOREXEC 2020-01-15 11:27:09,804 DEBUG Variable Loop End 3:19 Configure succeeded. (Variable Loop End) 2020-01-15 11:27:09,804 DEBUG PostgreSQL Connector 3:6 Variable Loop End 3:19 has new state: CONFIGURED 2020-01-15 11:27:09,804 DEBUG DB Table Selector 3:20 DB Table Selector 3:20 doBeforePreExecution 2020-01-15 11:27:09,804 DEBUG DB Table Selector 3:20 DB Table Selector 3:20 has new state: PREEXECUTE 2020-01-15 11:27:09,804 DEBUG DB Table Selector 3:20 DB Table Selector 3:20 doBeforeExecution 2020-01-15 11:27:09,804 DEBUG DB Table Selector 3:20 DB Table Selector 3:20 has new state: EXECUTING 2020-01-15 11:27:09,804 DEBUG DB Table Selector 3:20 DB Table Selector 3:20 Start execute 2020-01-15 11:27:09,820 INFO DB Table Selector 3:20 DB Table Selector 3:20 End execute (0 secs) 2020-01-15 11:27:09,820 DEBUG DB Table Selector 3:20 DB Table Selector 3:20 doBeforePostExecution 2020-01-15 11:27:09,821 DEBUG DB Table Selector 3:20 DB Table Selector 3:20 has new state: POSTEXECUTE 2020-01-15 11:27:09,821 DEBUG DB Table Selector 3:20 DB Table Selector 3:20 doAfterExecute - success 2020-01-15 11:27:09,821 DEBUG DB Table Selector 3:20 DB Table Selector 3:20 has new state: EXECUTED 2020-01-15 11:27:09,821 DEBUG DB Reader 3:21 Configure succeeded. (DB Reader) 2020-01-15 11:27:09,822 DEBUG DB Table Selector 3:20 DB Reader 3:21 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:09,822 DEBUG DB Reader 3:21 DB Reader 3:21 doBeforePreExecution 2020-01-15 11:27:09,822 DEBUG DB Reader 3:21 DB Reader 3:21 has new state: PREEXECUTE 2020-01-15 11:27:09,822 DEBUG DB Reader 3:21 DB Reader 3:21 doBeforeExecution 2020-01-15 11:27:09,822 DEBUG DB Reader 3:21 DB Reader 3:21 has new state: EXECUTING 2020-01-15 11:27:09,822 DEBUG DB Reader 3:21 DB Reader 3:21 Start execute 2020-01-15 11:27:09,831 DEBUG DB Reader 3:21 Preparing to read from database 2020-01-15 11:27:09,832 DEBUG DB Reader 3:21 Acquiring connection. 2020-01-15 11:27:10,343 DEBUG DB Reader 3:21 Using table format org.knime.core.data.container.DefaultTableStoreFormat 2020-01-15 11:27:14,329 DEBUG DB Reader 3:21 Closing the small-scale transaction... 2020-01-15 11:27:14,330 DEBUG DB Reader 3:21 Rolling back all uncommitted changes... 2020-01-15 11:27:14,331 DEBUG DB Reader 3:21 Enabling auto-commit mode... 2020-01-15 11:27:14,331 DEBUG DB Reader 3:21 The small-scale transaction has been successfully closed. 2020-01-15 11:27:14,331 DEBUG DB Reader 3:21 The small-scale transaction has been removed. 2020-01-15 11:27:14,331 DEBUG DB Reader 3:21 All the statements have already been closed. 2020-01-15 11:27:14,331 DEBUG DB Reader 3:21 The connection has been relinquished. 2020-01-15 11:27:14,332 DEBUG DB Reader 3:21 The managed connection has been closed. 2020-01-15 11:27:14,332 DEBUG DB Reader 3:21 The transaction managing connection has been closed. 2020-01-15 11:27:14,333 INFO DB Reader 3:21 DB Reader 3:21 End execute (4 secs) 2020-01-15 11:27:14,333 DEBUG DB Reader 3:21 DB Reader 3:21 doBeforePostExecution 2020-01-15 11:27:14,333 DEBUG DB Reader 3:21 DB Reader 3:21 has new state: POSTEXECUTE 2020-01-15 11:27:14,333 DEBUG DB Reader 3:21 DB Reader 3:21 doAfterExecute - success 2020-01-15 11:27:14,333 DEBUG DB Reader 3:21 DB Reader 3:21 has new state: EXECUTED 2020-01-15 11:27:14,335 DEBUG DB Writer 3:23 Acquiring connection. 2020-01-15 11:27:14,335 DEBUG DB Writer 3:23 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.BroadTransactionManagingWrapper. 2020-01-15 11:27:14,359 DEBUG DB Writer 3:23 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.TransactionManagingWrapper. 2020-01-15 11:27:14,386 DEBUG DB Writer 3:23 All the statements have already been closed. 2020-01-15 11:27:14,387 DEBUG DB Writer 3:23 The connection has been relinquished. 2020-01-15 11:27:14,393 DEBUG DB Writer 3:23 The managed connection has been closed. 2020-01-15 11:27:14,394 DEBUG DB Writer 3:23 The transaction managing connection has been closed. 2020-01-15 11:27:14,394 DEBUG DB Writer 3:23 Configure succeeded. (DB Writer) 2020-01-15 11:27:14,394 DEBUG DB Reader 3:21 DB Writer 3:23 has new state: CONFIGURED_QUEUED 2020-01-15 11:27:14,396 DEBUG Variable Loop End 3:19 Configure succeeded. (Variable Loop End) 2020-01-15 11:27:14,398 DEBUG DB Writer 3:23 DB Writer 3:23 doBeforePreExecution 2020-01-15 11:27:14,398 DEBUG DB Writer 3:23 DB Writer 3:23 has new state: PREEXECUTE 2020-01-15 11:27:14,398 DEBUG DB Writer 3:23 DB Writer 3:23 doBeforeExecution 2020-01-15 11:27:14,398 DEBUG DB Writer 3:23 DB Writer 3:23 has new state: EXECUTING 2020-01-15 11:27:14,398 DEBUG DB Writer 3:23 DB Writer 3:23 Start execute 2020-01-15 11:27:14,440 DEBUG DB Writer 3:23 Acquiring connection. 2020-01-15 11:27:14,441 DEBUG DB Writer 3:23 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.BroadTransactionManagingWrapper. 2020-01-15 11:27:14,442 DEBUG DB Writer 3:23 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.TransactionManagingWrapper. 2020-01-15 11:27:14,454 DEBUG DB Writer 3:23 All the statements have already been closed. 2020-01-15 11:27:14,454 DEBUG DB Writer 3:23 The connection has been relinquished. 2020-01-15 11:27:14,454 DEBUG DB Writer 3:23 The managed connection has been closed. 2020-01-15 11:27:14,455 DEBUG DB Writer 3:23 The transaction managing connection has been closed. 2020-01-15 11:27:14,455 DEBUG DB Writer 3:23 Column type of VARCHAR: varchar(255) 2020-01-15 11:27:14,455 DEBUG DB Writer 3:23 Column type of TIMESTAMP: datetime 2020-01-15 11:27:14,455 DEBUG DB Writer 3:23 Column type of TIMESTAMP: datetime 2020-01-15 11:27:14,455 DEBUG DB Writer 3:23 Column type of VARCHAR: varchar(255) 2020-01-15 11:27:14,457 DEBUG DB Writer 3:23 Column type of VARCHAR: varchar(255) 2020-01-15 11:27:14,457 DEBUG DB Writer 3:23 Column type of DOUBLE: double precision 2020-01-15 11:27:14,457 DEBUG DB Writer 3:23 Column type of DOUBLE: double precision 2020-01-15 11:27:14,457 DEBUG DB Writer 3:23 Acquiring connection. 2020-01-15 11:27:14,458 DEBUG DB Writer 3:23 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.BroadTransactionManagingWrapper. 2020-01-15 11:27:14,458 DEBUG DB Writer 3:23 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.TransactionManagingWrapper. 2020-01-15 11:27:14,470 DEBUG DB Writer 3:23 All the statements have already been closed. 2020-01-15 11:27:14,471 DEBUG DB Writer 3:23 The connection has been relinquished. 2020-01-15 11:27:14,471 DEBUG DB Writer 3:23 The managed connection has been closed. 2020-01-15 11:27:14,471 DEBUG DB Writer 3:23 The transaction managing connection has been closed. 2020-01-15 11:27:14,471 DEBUG DB Writer 3:23 reset 2020-01-15 11:27:14,471 ERROR DB Writer 3:23 Execute failed: There is already an object named 'sat_tekstavu' in the database. 2020-01-15 11:27:14,471 DEBUG DB Writer 3:23 DB Writer 3:23 doBeforePostExecution 2020-01-15 11:27:14,472 DEBUG DB Writer 3:23 DB Writer 3:23 has new state: POSTEXECUTE 2020-01-15 11:27:14,472 DEBUG DB Writer 3:23 DB Writer 3:23 doAfterExecute - failure 2020-01-15 11:27:14,472 DEBUG DB Writer 3:23 reset 2020-01-15 11:27:14,472 DEBUG DB Writer 3:23 clean output ports. 2020-01-15 11:27:14,472 DEBUG DB Writer 3:23 DB Writer 3:23 has new state: IDLE 2020-01-15 11:27:14,474 DEBUG DB Writer 3:23 Acquiring connection. 2020-01-15 11:27:14,474 DEBUG DB Writer 3:23 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.BroadTransactionManagingWrapper. 2020-01-15 11:27:14,475 DEBUG DB Writer 3:23 An error of unexpected type occurred while checking if an object is a wrapper for org.knime.database.connection.impl.managing.transaction.TransactionManagingWrapper. 2020-01-15 11:27:14,486 DEBUG DB Writer 3:23 All the statements have already been closed. 2020-01-15 11:27:14,486 DEBUG DB Writer 3:23 The connection has been relinquished. 2020-01-15 11:27:14,486 DEBUG DB Writer 3:23 The managed connection has been closed. 2020-01-15 11:27:14,486 DEBUG DB Writer 3:23 The transaction managing connection has been closed. 2020-01-15 11:27:14,486 DEBUG DB Writer 3:23 Configure succeeded. (DB Writer) 2020-01-15 11:27:14,486 DEBUG DB Writer 3:23 DB Writer 3:23 has new state: CONFIGURED 2020-01-15 11:27:14,487 DEBUG Variable Loop End 3:19 Configure succeeded. (Variable Loop End) 2020-01-15 11:27:14,487 DEBUG DB Writer 3:23 DWH to MS SQL 3 has new state: CONFIGURED 2020-01-15 11:27:14,487 DEBUG NodeContainer ROOT has new state: IDLE 2020-01-15 11:27:14,907 DEBUG DB Reader 3:21 Buffer file (/private/var/folders/xd/w659wnz16y9gt_19mnvhwjrh0000gn/T/knime_DWH to MS SQL85835/knime_container_20200115_8626558486455501992.bin.snappy) is 4.381MB in size 2020-01-15 11:27:17,533 DEBUG NodeContainerEditPart DB Writer 3:23 (CONFIGURED) 2020-01-15 11:27:20,704 DEBUG MRUFileMenuItem Unable to open a connection to a recent workflow [knime://LOCAL/stage%20to%20dwh%202/workflow.knime]. 2020-01-15 11:27:20,706 DEBUG MRUFileMenuItem Unable to open a connection to a recent workflow [knime://LOCAL/ADS/PoC/pipelines/stage_to_dwh/workflow.knime]. 2020-01-15 11:27:23,296 DEBUG MRUFileMenuItem Unable to open a connection to a recent workflow [knime://LOCAL/stage%20to%20dwh%202/workflow.knime]. 2020-01-15 11:27:23,298 DEBUG MRUFileMenuItem Unable to open a connection to a recent workflow [knime://LOCAL/ADS/PoC/pipelines/stage_to_dwh/workflow.knime].