How to close Chunk Loop with CASE Switch Variable, ending with 3 Google Sheets Updater nodes?

Hi everyone, hope you are having a great weekend.

This is related to my other post, which I managed to get it working almost - Google Form with File Upload, then Google Drive with Google Sheet in Loop

In the below screenshot, [A] downloads xlsx attachment submitted via Google Form and renames each file with Google’s dynamic file ID and moves to another folder, ready to be referenced by [B] above. [B] reads Google Form submissions and parses out the Google dynamic file ID and performs 1) add URLs, 2) update URLs or 3) delete URLs with CASE Switch. I will need to add the logic to update Processed col after all these as well as to skip Processed records, but this is mostly working. …except that I don’t know how to effectively close this loop and CASE Switch with 3 Google Sheets Updater nodes that only have output variable ports. And I’m sure once I close the loop, there is something I need to tweak, but that’s after I’m able to close the loop first. :slight_smile:

Could anyone please educate me how I can accomplish that? I’ll keep trying out now. Thank you so much for your help!!!

Ha, I closed it with CASE Switch Variable (End) then Variable Loop End, but somehow one of the Google Sheets Updater node stays Queued and won’t execute. Debugging now…wow, sooo many errors in the log?

DEBUG String to Path (Variable) 7:3590 Configure succeeded. (String to Path (Variable))
DEBUG Cell Splitter 7:3565 String to Path (Variable) 7:3590 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Rule Engine Variable 7:3553 Configure succeeded. (Rule Engine Variable)
DEBUG Cell Splitter 7:3565 Rule Engine Variable 7:3553 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Configure succeeded. (CASE Switch Variable (Start))
DEBUG Cell Splitter 7:3565 CASE Switch Variable (Start) 7:3554 has new state: CONFIGURED_MARKEDFOREXEC
WARN Excel Reader 7:3589 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
DEBUG Excel Reader 7:3589 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
WARN Excel Reader 7:3592 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
DEBUG Excel Reader 7:3592 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
WARN Excel Reader 7:3599 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
DEBUG Excel Reader 7:3599 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
DEBUG String Manipulation 7:3585 String Manipulation 7:3585 doBeforePreExecution
DEBUG String Manipulation 7:3585 String Manipulation 7:3585 has new state: PREEXECUTE
DEBUG String Manipulation 7:3585 String Manipulation 7:3585 doBeforeExecution
DEBUG String Manipulation 7:3585 String Manipulation 7:3585 has new state: EXECUTING
DEBUG String Manipulation 7:3585 String Manipulation 7:3585 Start execute
DEBUG String Manipulation 7:3585 Using Table Backend “BufferedTableBackend”.
DEBUG String Manipulation 7:3585 Using table format org.knime.core.data.container.DefaultTableStoreFormat
INFO String Manipulation 7:3585 String Manipulation 7:3585 End execute (0 secs)
DEBUG String Manipulation 7:3585 String Manipulation 7:3585 doBeforePostExecution
DEBUG String Manipulation 7:3585 String Manipulation 7:3585 has new state: POSTEXECUTE
DEBUG String Manipulation 7:3585 String Manipulation 7:3585 doAfterExecute - success
DEBUG String Manipulation 7:3585 String Manipulation 7:3585 has new state: EXECUTED
DEBUG Table Row to Variable 7:3552 Configure succeeded. (Table Row to Variable)
DEBUG String Manipulation 7:3585 Table Row to Variable 7:3552 has new state: CONFIGURED_QUEUED
DEBUG Table Row to Variable 7:3552 Table Row to Variable 7:3552 doBeforePreExecution
DEBUG Table Row to Variable 7:3552 Table Row to Variable 7:3552 has new state: PREEXECUTE
DEBUG Table Row to Variable 7:3552 Table Row to Variable 7:3552 doBeforeExecution
DEBUG Table Row to Variable 7:3552 Table Row to Variable 7:3552 has new state: EXECUTING
DEBUG Table Row to Variable 7:3552 Table Row to Variable 7:3552 Start execute
INFO Table Row to Variable 7:3552 Table Row to Variable 7:3552 End execute (0 secs)
DEBUG Table Row to Variable 7:3552 Table Row to Variable 7:3552 doBeforePostExecution
DEBUG Table Row to Variable 7:3552 Table Row to Variable 7:3552 has new state: POSTEXECUTE
DEBUG Table Row to Variable 7:3552 Table Row to Variable 7:3552 doAfterExecute - success
DEBUG Table Row to Variable 7:3552 Table Row to Variable 7:3552 has new state: EXECUTED
DEBUG String to Path (Variable) 7:3590 Configure succeeded. (String to Path (Variable))
DEBUG Table Row to Variable 7:3552 String to Path (Variable) 7:3590 has new state: CONFIGURED_QUEUED
DEBUG Rule Engine Variable 7:3553 Configure succeeded. (Rule Engine Variable)
DEBUG CASE Switch Variable (Start) 7:3554 Configure succeeded. (CASE Switch Variable (Start))
WARN Excel Reader 7:3589 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
DEBUG Excel Reader 7:3589 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
WARN Excel Reader 7:3592 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
DEBUG Excel Reader 7:3592 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
WARN Excel Reader 7:3599 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
DEBUG Excel Reader 7:3599 Errors overwriting node settings with flow variables: Unknown variable “filenamexlsx_location”
DEBUG String to Path (Variable) 7:3590 String to Path (Variable) 7:3590 doBeforePreExecution
DEBUG String to Path (Variable) 7:3590 String to Path (Variable) 7:3590 has new state: PREEXECUTE
DEBUG String to Path (Variable) 7:3590 String to Path (Variable) 7:3590 doBeforeExecution
DEBUG String to Path (Variable) 7:3590 String to Path (Variable) 7:3590 has new state: EXECUTING
DEBUG String to Path (Variable) 7:3590 String to Path (Variable) 7:3590 Start execute
INFO String to Path (Variable) 7:3590 String to Path (Variable) 7:3590 End execute (0 secs)
DEBUG String to Path (Variable) 7:3590 String to Path (Variable) 7:3590 doBeforePostExecution
DEBUG String to Path (Variable) 7:3590 String to Path (Variable) 7:3590 has new state: POSTEXECUTE
DEBUG String to Path (Variable) 7:3590 String to Path (Variable) 7:3590 doAfterExecute - success
DEBUG String to Path (Variable) 7:3590 String to Path (Variable) 7:3590 has new state: EXECUTED
DEBUG Rule Engine Variable 7:3553 Configure succeeded. (Rule Engine Variable)
DEBUG String to Path (Variable) 7:3590 Rule Engine Variable 7:3553 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 Configure succeeded. (CASE Switch Variable (Start))
WARN Excel Reader 7:3589 The stored spec has not been created with the given file/path.
DEBUG Excel Reader 7:3589 Configure succeeded. (Excel Reader)
DEBUG String to Path (Variable) 7:3590 Excel Reader 7:3589 has new state: CONFIGURED_MARKEDFOREXEC
WARN Excel Reader 7:3592 The stored spec has not been created with the given file/path.
DEBUG Excel Reader 7:3592 Configure succeeded. (Excel Reader)
DEBUG String to Path (Variable) 7:3590 Excel Reader 7:3592 has new state: CONFIGURED_MARKEDFOREXEC
WARN Excel Reader 7:3599 The stored spec has not been created with the given file/path.
DEBUG Excel Reader 7:3599 Configure succeeded. (Excel Reader)
DEBUG String to Path (Variable) 7:3590 Excel Reader 7:3599 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doBeforePreExecution
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: PREEXECUTE
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doBeforeExecution
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: EXECUTING
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 Start execute
INFO Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 End execute (0 secs)
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doBeforePostExecution
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: POSTEXECUTE
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doAfterExecute - success
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: EXECUTED
DEBUG CASE Switch Variable (Start) 7:3554 Configure succeeded. (CASE Switch Variable (Start))
DEBUG Rule Engine Variable 7:3553 CASE Switch Variable (Start) 7:3554 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doBeforePreExecution
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: PREEXECUTE
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doBeforeExecution
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: EXECUTING
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 Start execute
INFO CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 End execute (0 secs)
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doBeforePostExecution
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: POSTEXECUTE
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doAfterExecute - success
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: EXECUTED
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3589 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3589 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3589 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3592 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3592 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3592 has new state: CONFIGURED_QUEUED
WARN Excel Reader 7:3599 The stored spec has not been created with the given file/path.
DEBUG Excel Reader 7:3599 Configure succeeded. (Excel Reader)
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3599 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3571 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3571 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3571 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3594 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3594 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3594 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3593 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3593 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3593 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3597 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3597 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3597 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doBeforePreExecution
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: PREEXECUTE
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doBeforeExecution
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: EXECUTING
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 Start execute
DEBUG Excel Reader 7:3589 No file store handler set on “Excel Reader” (possibly running in 3rd party executor)
INFO Excel Reader 7:3589 Excel Reader 7:3589 End execute (0 secs)
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doBeforePreExecution
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: PREEXECUTE
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doBeforeExecution
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: EXECUTING
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 Start execute
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doBeforePreExecution
DEBUG Excel Reader 7:3592 No file store handler set on “Excel Reader” (possibly running in 3rd party executor)
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: PREEXECUTE
INFO Excel Reader 7:3592 Excel Reader 7:3592 End execute (0 secs)
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doBeforeExecution
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: EXECUTING
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 Start execute
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doBeforePostExecution
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: POSTEXECUTE
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doAfterExecute - success
DEBUG Excel Reader 7:3589 Can’t close file store handler, not writable:
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: EXECUTED
DEBUG Excel Reader 7:3589 Google Sheets Updater 7:3571 has new state: CONFIGURED_QUEUED
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doBeforePreExecution
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: PREEXECUTE
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doBeforeExecution
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: EXECUTING
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 Start execute
DEBUG Google Sheets Updater 7:3571 No file store handler set on “Google Sheets Updater” (possibly running in 3rd party executor)
INFO Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 End execute (0 secs)
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doBeforePostExecution
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: POSTEXECUTE
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doAfterExecute - success
DEBUG Google Sheets Updater 7:3571 Can’t close file store handler, not writable:
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: EXECUTED
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doBeforePostExecution
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: POSTEXECUTE
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doAfterExecute - success
DEBUG Excel Reader 7:3592 Can’t close file store handler, not writable:
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: EXECUTED
DEBUG Excel Reader 7:3592 Table Row to Variable 7:3594 has new state: CONFIGURED_QUEUED
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doBeforePreExecution
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: PREEXECUTE
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doBeforeExecution
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: EXECUTING
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 Start execute
DEBUG Table Row to Variable 7:3594 No file store handler set on “Table Row to Variable” (possibly running in 3rd party executor)
INFO Table Row to Variable 7:3594 Table Row to Variable 7:3594 End execute (0 secs)
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doBeforePostExecution
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: POSTEXECUTE
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doAfterExecute - success
DEBUG Table Row to Variable 7:3594 Can’t close file store handler, not writable:
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: EXECUTED
DEBUG Table Row to Variable 7:3594 Rule-based Row Filter 7:3593 has new state: CONFIGURED_QUEUED
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doBeforePreExecution
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: PREEXECUTE
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doBeforeExecution
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: EXECUTING
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 Start execute
DEBUG Rule-based Row Filter 7:3593 No file store handler set on “Rule-based Row Filter” (possibly running in 3rd party executor)
INFO Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 End execute (0 secs)
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doBeforePostExecution
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: POSTEXECUTE
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doAfterExecute - success
DEBUG Rule-based Row Filter 7:3593 Can’t close file store handler, not writable:
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: EXECUTED
DEBUG Rule-based Row Filter 7:3593 Google Sheets Updater 7:3597 has new state: CONFIGURED_QUEUED
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doBeforePreExecution
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: PREEXECUTE
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doBeforeExecution
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: EXECUTING
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 Start execute
DEBUG Google Sheets Updater 7:3597 No file store handler set on “Google Sheets Updater” (possibly running in 3rd party executor)
INFO Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 End execute (0 secs)
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doBeforePostExecution
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: POSTEXECUTE
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doAfterExecute - success
DEBUG Google Sheets Updater 7:3597 Can’t close file store handler, not writable:
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: EXECUTED
DEBUG Excel Reader 7:3599 Thread parsing an Excel spreadsheet started.
DEBUG Excel Reader 7:3599 Thread parsing an Excel spreadsheet finished successfully.
DEBUG Excel Reader 7:3599 Using Table Backend “BufferedTableBackend”.
DEBUG Excel Reader 7:3599 Thread parsing an Excel spreadsheet started.
DEBUG Excel Reader 7:3599 Using table format org.knime.core.data.container.DefaultTableStoreFormat
DEBUG Excel Reader 7:3599 Thread parsing an Excel spreadsheet finished successfully.
INFO Excel Reader 7:3599 Excel Reader 7:3599 End execute (0 secs)
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doBeforePostExecution
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: POSTEXECUTE
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doAfterExecute - success
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: EXECUTED
DEBUG Table Row to Variable 7:3600 Configure succeeded. (Table Row to Variable)
DEBUG Excel Reader 7:3599 Table Row to Variable 7:3600 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Excel Reader 7:3599 Table Row to Variable 7:3600 has new state: CONFIGURED_QUEUED
DEBUG Rule-based Row Filter 7:3601 Configure succeeded. (Rule-based Row Filter)
DEBUG Excel Reader 7:3599 Rule-based Row Filter 7:3601 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Google Sheets Updater 7:3598 Configure succeeded. (Google Sheets Updater)
DEBUG Excel Reader 7:3599 Google Sheets Updater 7:3598 has new state: CONFIGURED_MARKEDFOREXEC
WARN Excel Reader 7:3604 The stored spec has not been created with the given file/path.
DEBUG Excel Reader 7:3604 Configure succeeded. (Excel Reader)
DEBUG Excel Reader 7:3599 Excel Reader 7:3604 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doBeforePreExecution
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: PREEXECUTE
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doBeforeExecution
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: EXECUTING
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 Start execute
INFO Table Row to Variable 7:3600 Table Row to Variable 7:3600 End execute (0 secs)
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doBeforePostExecution
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: POSTEXECUTE
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doAfterExecute - success
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: EXECUTED
DEBUG Rule-based Row Filter 7:3601 Configure succeeded. (Rule-based Row Filter)
DEBUG Table Row to Variable 7:3600 Rule-based Row Filter 7:3601 has new state: CONFIGURED_QUEUED
DEBUG Google Sheets Updater 7:3598 Configure succeeded. (Google Sheets Updater)
WARN Excel Reader 7:3604 The stored spec has not been created with the given file/path.
DEBUG Excel Reader 7:3604 Configure succeeded. (Excel Reader)
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doBeforePreExecution
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: PREEXECUTE
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doBeforeExecution
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: EXECUTING
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 Start execute
DEBUG Rule-based Row Filter 7:3601 Using Table Backend “BufferedTableBackend”.
DEBUG Rule-based Row Filter 7:3601 Using Table Backend “BufferedTableBackend”.
DEBUG Rule-based Row Filter 7:3601 Using table format org.knime.core.data.container.DefaultTableStoreFormat
DEBUG Rule-based Row Filter 7:3601 Using table format org.knime.core.data.container.DefaultTableStoreFormat
INFO Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 End execute (0 secs)
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doBeforePostExecution
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: POSTEXECUTE
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doAfterExecute - success
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: EXECUTED
ERROR Rule-based Row Filter 7:3601 Caught “IllegalStateException”: Illegal state “IDLE” encountered in method “org.knime.core.node.workflow.SingleNodeContainer#markForReExecution” in node Chunk Loop Start 7:3628
DEBUG Rule-based Row Filter 7:3601 PageSpeed Submission Form 7 has new state: UNCONFIGURED_MARKEDFOREXEC
DEBUG NodeContainer ROOT has new state: UNCONFIGURED_MARKEDFOREXEC

I read this Which loop is the right one for me? – blog.statinfer.com, and I think Variable Loop End is the correct end loop but it’s not looping. The previous log and screenshot was from the middle port #1. I changed the data to come from the top port #0 and it’s stuck at CASE Switch Variable End node (queued).

The log from the top port execution.

DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doBeforePreExecution
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: PREEXECUTE
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doBeforeExecution
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: EXECUTING
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 Start execute
INFO Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 End execute (0 secs)
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doBeforePostExecution
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: POSTEXECUTE
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doAfterExecute - success
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: EXECUTED
DEBUG CASE Switch Variable (Start) 7:3554 Configure succeeded. (CASE Switch Variable (Start))
DEBUG Rule Engine Variable 7:3553 CASE Switch Variable (Start) 7:3554 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doBeforePreExecution
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: PREEXECUTE
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doBeforeExecution
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: EXECUTING
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 Start execute
INFO CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 End execute (0 secs)
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doBeforePostExecution
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: POSTEXECUTE
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doAfterExecute - success
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: EXECUTED
WARN Excel Reader 7:3589 The stored spec has not been created with the given file/path.
DEBUG Excel Reader 7:3589 Configure succeeded. (Excel Reader)
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3589 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3592 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3592 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3592 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3599 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3599 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3599 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3594 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3594 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3594 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3600 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3600 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3600 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3593 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3593 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3593 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3601 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3601 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3601 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3597 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3597 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3597 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3598 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3598 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3598 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3604 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3604 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3604 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3605 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3605 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3605 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doBeforePreExecution
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: PREEXECUTE
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doBeforeExecution
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: EXECUTING
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 Start execute
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doBeforePreExecution
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: PREEXECUTE
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doBeforeExecution
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: EXECUTING
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 Start execute
DEBUG Excel Reader 7:3592 No file store handler set on “Excel Reader” (possibly running in 3rd party executor)
INFO Excel Reader 7:3592 Excel Reader 7:3592 End execute (0 secs)
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doBeforePostExecution
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: POSTEXECUTE
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doAfterExecute - success
DEBUG Excel Reader 7:3592 Can’t close file store handler, not writable:
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: EXECUTED
DEBUG Excel Reader 7:3592 Table Row to Variable 7:3594 has new state: CONFIGURED_QUEUED
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doBeforePreExecution
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: PREEXECUTE
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doBeforeExecution
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: EXECUTING
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 Start execute
DEBUG Excel Reader 7:3599 No file store handler set on “Excel Reader” (possibly running in 3rd party executor)
INFO Excel Reader 7:3599 Excel Reader 7:3599 End execute (0 secs)
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doBeforePostExecution
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: POSTEXECUTE
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doAfterExecute - success
DEBUG Excel Reader 7:3599 Can’t close file store handler, not writable:
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: EXECUTED
DEBUG Excel Reader 7:3599 Table Row to Variable 7:3600 has new state: CONFIGURED_QUEUED
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doBeforePreExecution
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: PREEXECUTE
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doBeforeExecution
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: EXECUTING
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 Start execute
DEBUG Table Row to Variable 7:3600 No file store handler set on “Table Row to Variable” (possibly running in 3rd party executor)
INFO Table Row to Variable 7:3600 Table Row to Variable 7:3600 End execute (0 secs)
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doBeforePostExecution
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: POSTEXECUTE
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doAfterExecute - success
DEBUG Table Row to Variable 7:3600 Can’t close file store handler, not writable:
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: EXECUTED
DEBUG Table Row to Variable 7:3600 Rule-based Row Filter 7:3601 has new state: CONFIGURED_QUEUED
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doBeforePreExecution
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: PREEXECUTE
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doBeforeExecution
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: EXECUTING
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 Start execute
DEBUG Table Row to Variable 7:3594 No file store handler set on “Table Row to Variable” (possibly running in 3rd party executor)
INFO Table Row to Variable 7:3594 Table Row to Variable 7:3594 End execute (0 secs)
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doBeforePostExecution
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: POSTEXECUTE
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doAfterExecute - success
DEBUG Table Row to Variable 7:3594 Can’t close file store handler, not writable:
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: EXECUTED
DEBUG Table Row to Variable 7:3594 Rule-based Row Filter 7:3593 has new state: CONFIGURED_QUEUED
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doBeforePreExecution
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: PREEXECUTE
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doBeforeExecution
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: EXECUTING
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 Start execute
DEBUG Rule-based Row Filter 7:3601 No file store handler set on “Rule-based Row Filter” (possibly running in 3rd party executor)
INFO Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 End execute (0 secs)
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doBeforePostExecution
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: POSTEXECUTE
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doAfterExecute - success
DEBUG Rule-based Row Filter 7:3601 Can’t close file store handler, not writable:
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: EXECUTED
ERROR Rule-based Row Filter 7:3601 Caught “IllegalStateException”: Illegal state “IDLE” encountered in method “org.knime.core.node.workflow.SingleNodeContainer#markForReExecution” in node Chunk Loop Start 7:3628
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doBeforePreExecution
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: PREEXECUTE
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doBeforeExecution
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: EXECUTING
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 Start execute
DEBUG Rule-based Row Filter 7:3593 No file store handler set on “Rule-based Row Filter” (possibly running in 3rd party executor)
INFO Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 End execute (0 secs)
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doBeforePostExecution
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: POSTEXECUTE
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doAfterExecute - success
DEBUG Rule-based Row Filter 7:3593 Can’t close file store handler, not writable:
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: EXECUTED
DEBUG Rule-based Row Filter 7:3593 Google Sheets Updater 7:3597 has new state: CONFIGURED_QUEUED
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doBeforePreExecution
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: PREEXECUTE
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doBeforeExecution
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: EXECUTING
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 Start execute
DEBUG Google Sheets Updater 7:3597 No file store handler set on “Google Sheets Updater” (possibly running in 3rd party executor)
INFO Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 End execute (0 secs)
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doBeforePostExecution
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: POSTEXECUTE
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doAfterExecute - success
DEBUG Google Sheets Updater 7:3597 Can’t close file store handler, not writable:
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: EXECUTED
DEBUG Excel Reader 7:3589 Thread parsing an Excel spreadsheet started.
DEBUG Excel Reader 7:3589 Thread parsing an Excel spreadsheet finished successfully.
DEBUG Excel Reader 7:3589 Using Table Backend “BufferedTableBackend”.
DEBUG Excel Reader 7:3589 Thread parsing an Excel spreadsheet started.
DEBUG Excel Reader 7:3589 Using table format org.knime.core.data.container.DefaultTableStoreFormat
DEBUG Excel Reader 7:3589 Thread parsing an Excel spreadsheet finished successfully.
INFO Excel Reader 7:3589 Excel Reader 7:3589 End execute (0 secs)
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doBeforePostExecution
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: POSTEXECUTE
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doAfterExecute - success
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: EXECUTED
DEBUG Google Sheets Updater 7:3571 Configure succeeded. (Google Sheets Updater)
DEBUG Excel Reader 7:3589 Google Sheets Updater 7:3571 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Excel Reader 7:3589 Google Sheets Updater 7:3571 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (End) 7:3636 Configure succeeded. (CASE Switch Variable (End))
DEBUG Excel Reader 7:3589 CASE Switch Variable (End) 7:3636 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Variable Loop End 7:3632 Configure succeeded. (Variable Loop End)
DEBUG Excel Reader 7:3589 Variable Loop End 7:3632 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doBeforePreExecution
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: PREEXECUTE
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doBeforeExecution
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: EXECUTING
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 Start execute
INFO Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 End execute (0 secs)
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doBeforePostExecution
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: POSTEXECUTE
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doAfterExecute - success
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: EXECUTED
DEBUG CASE Switch Variable (End) 7:3636 Configure succeeded. (CASE Switch Variable (End))
DEBUG Variable Loop End 7:3632 Configure succeeded. (Variable Loop End)
DEBUG Google Sheets Updater 7:3571 PageSpeed Submission Form 7 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG NodeContainer ROOT has new state: CONFIGURED_MARKEDFOREXEC

I’m going to try the bottom port as well. Thank you!!

Bottom is same as top. (I removed a selection of variable from Variable Loop End but didn’t make a difference.)

DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doBeforePreExecution
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: PREEXECUTE
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doBeforeExecution
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: EXECUTING
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 Start execute
INFO Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 End execute (0 secs)
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doBeforePostExecution
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: POSTEXECUTE
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 doAfterExecute - success
DEBUG Rule Engine Variable 7:3553 Rule Engine Variable 7:3553 has new state: EXECUTED
DEBUG CASE Switch Variable (Start) 7:3554 Configure succeeded. (CASE Switch Variable (Start))
DEBUG Rule Engine Variable 7:3553 CASE Switch Variable (Start) 7:3554 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doBeforePreExecution
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: PREEXECUTE
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doBeforeExecution
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: EXECUTING
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 Start execute
INFO CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 End execute (0 secs)
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doBeforePostExecution
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: POSTEXECUTE
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 doAfterExecute - success
DEBUG CASE Switch Variable (Start) 7:3554 CASE Switch Variable (Start) 7:3554 has new state: EXECUTED
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3589 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3589 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3589 has new state: CONFIGURED_QUEUED
WARN Excel Reader 7:3592 The stored spec has not been created with the given file/path.
DEBUG Excel Reader 7:3592 Configure succeeded. (Excel Reader)
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3592 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3599 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3599 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3599 has new state: CONFIGURED_QUEUED
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3571 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3571 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3571 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3600 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3600 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Table Row to Variable 7:3600 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3601 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3601 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Rule-based Row Filter 7:3601 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3598 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3598 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3598 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3604 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3604 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Excel Reader 7:3604 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3605 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3605 has new state: IDLE
DEBUG CASE Switch Variable (Start) 7:3554 Google Sheets Updater 7:3605 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doBeforePreExecution
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: PREEXECUTE
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doBeforeExecution
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: EXECUTING
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 Start execute
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doBeforePreExecution
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: PREEXECUTE
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doBeforeExecution
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: EXECUTING
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 Start execute
DEBUG Excel Reader 7:3589 No file store handler set on “Excel Reader” (possibly running in 3rd party executor)
INFO Excel Reader 7:3589 Excel Reader 7:3589 End execute (0 secs)
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doBeforePostExecution
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: POSTEXECUTE
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 doAfterExecute - success
DEBUG Excel Reader 7:3589 Can’t close file store handler, not writable:
DEBUG Excel Reader 7:3589 Excel Reader 7:3589 has new state: EXECUTED
DEBUG Excel Reader 7:3589 Google Sheets Updater 7:3571 has new state: CONFIGURED_QUEUED
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doBeforePreExecution
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: PREEXECUTE
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doBeforeExecution
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: EXECUTING
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 Start execute
DEBUG Google Sheets Updater 7:3571 No file store handler set on “Google Sheets Updater” (possibly running in 3rd party executor)
INFO Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 End execute (0 secs)
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doBeforePostExecution
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: POSTEXECUTE
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 doAfterExecute - success
DEBUG Google Sheets Updater 7:3571 Can’t close file store handler, not writable:
DEBUG Google Sheets Updater 7:3571 Google Sheets Updater 7:3571 has new state: EXECUTED
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doBeforePreExecution
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: PREEXECUTE
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doBeforeExecution
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: EXECUTING
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 Start execute
DEBUG Excel Reader 7:3599 No file store handler set on “Excel Reader” (possibly running in 3rd party executor)
INFO Excel Reader 7:3599 Excel Reader 7:3599 End execute (0 secs)
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doBeforePostExecution
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: POSTEXECUTE
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 doAfterExecute - success
DEBUG Excel Reader 7:3599 Can’t close file store handler, not writable:
DEBUG Excel Reader 7:3599 Excel Reader 7:3599 has new state: EXECUTED
DEBUG Excel Reader 7:3599 Table Row to Variable 7:3600 has new state: CONFIGURED_QUEUED
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doBeforePreExecution
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: PREEXECUTE
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doBeforeExecution
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: EXECUTING
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 Start execute
DEBUG Table Row to Variable 7:3600 No file store handler set on “Table Row to Variable” (possibly running in 3rd party executor)
INFO Table Row to Variable 7:3600 Table Row to Variable 7:3600 End execute (0 secs)
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doBeforePostExecution
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: POSTEXECUTE
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 doAfterExecute - success
DEBUG Table Row to Variable 7:3600 Can’t close file store handler, not writable:
DEBUG Table Row to Variable 7:3600 Table Row to Variable 7:3600 has new state: EXECUTED
DEBUG Table Row to Variable 7:3600 Rule-based Row Filter 7:3601 has new state: CONFIGURED_QUEUED
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doBeforePreExecution
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: PREEXECUTE
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doBeforeExecution
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: EXECUTING
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 Start execute
DEBUG Rule-based Row Filter 7:3601 No file store handler set on “Rule-based Row Filter” (possibly running in 3rd party executor)
INFO Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 End execute (0 secs)
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doBeforePostExecution
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: POSTEXECUTE
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 doAfterExecute - success
DEBUG Rule-based Row Filter 7:3601 Can’t close file store handler, not writable:
DEBUG Rule-based Row Filter 7:3601 Rule-based Row Filter 7:3601 has new state: EXECUTED
ERROR Rule-based Row Filter 7:3601 Caught “IllegalStateException”: Illegal state “IDLE” encountered in method “org.knime.core.node.workflow.SingleNodeContainer#markForReExecution” in node Chunk Loop Start 7:3628
DEBUG Excel Reader 7:3592 Thread parsing an Excel spreadsheet started.
DEBUG Excel Reader 7:3592 Thread parsing an Excel spreadsheet finished successfully.
DEBUG Excel Reader 7:3592 Using Table Backend “BufferedTableBackend”.
DEBUG Excel Reader 7:3592 Thread parsing an Excel spreadsheet started.
DEBUG Excel Reader 7:3592 Thread parsing an Excel spreadsheet finished successfully.
DEBUG Excel Reader 7:3592 Using table format org.knime.core.data.container.DefaultTableStoreFormat
INFO Excel Reader 7:3592 Excel Reader 7:3592 End execute (0 secs)
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doBeforePostExecution
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: POSTEXECUTE
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 doAfterExecute - success
DEBUG Excel Reader 7:3592 Excel Reader 7:3592 has new state: EXECUTED
DEBUG Table Row to Variable 7:3594 Configure succeeded. (Table Row to Variable)
DEBUG Excel Reader 7:3592 Table Row to Variable 7:3594 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Excel Reader 7:3592 Table Row to Variable 7:3594 has new state: CONFIGURED_QUEUED
DEBUG Rule-based Row Filter 7:3593 Configure succeeded. (Rule-based Row Filter)
DEBUG Excel Reader 7:3592 Rule-based Row Filter 7:3593 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Google Sheets Updater 7:3597 Configure succeeded. (Google Sheets Updater)
DEBUG Excel Reader 7:3592 Google Sheets Updater 7:3597 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG CASE Switch Variable (End) 7:3636 Configure succeeded. (CASE Switch Variable (End))
DEBUG Excel Reader 7:3592 CASE Switch Variable (End) 7:3636 has new state: CONFIGURED_MARKEDFOREXEC
WARN Variable Loop End 7:3632 No variables selected
DEBUG Variable Loop End 7:3632 Configure succeeded. (Variable Loop End)
DEBUG Excel Reader 7:3592 Variable Loop End 7:3632 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doBeforePreExecution
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: PREEXECUTE
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doBeforeExecution
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: EXECUTING
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 Start execute
INFO Table Row to Variable 7:3594 Table Row to Variable 7:3594 End execute (0 secs)
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doBeforePostExecution
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: POSTEXECUTE
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 doAfterExecute - success
DEBUG Table Row to Variable 7:3594 Table Row to Variable 7:3594 has new state: EXECUTED
DEBUG Rule-based Row Filter 7:3593 Configure succeeded. (Rule-based Row Filter)
DEBUG Table Row to Variable 7:3594 Rule-based Row Filter 7:3593 has new state: CONFIGURED_QUEUED
DEBUG Google Sheets Updater 7:3597 Configure succeeded. (Google Sheets Updater)
DEBUG CASE Switch Variable (End) 7:3636 Configure succeeded. (CASE Switch Variable (End))
WARN Variable Loop End 7:3632 No variables selected
DEBUG Variable Loop End 7:3632 Configure succeeded. (Variable Loop End)
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doBeforePreExecution
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: PREEXECUTE
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doBeforeExecution
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: EXECUTING
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 Start execute
DEBUG Rule-based Row Filter 7:3593 Using Table Backend “BufferedTableBackend”.
DEBUG Rule-based Row Filter 7:3593 Using Table Backend “BufferedTableBackend”.
DEBUG Rule-based Row Filter 7:3593 Using table format org.knime.core.data.container.DefaultTableStoreFormat
DEBUG Rule-based Row Filter 7:3593 Using table format org.knime.core.data.container.DefaultTableStoreFormat
INFO Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 End execute (0 secs)
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doBeforePostExecution
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: POSTEXECUTE
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 doAfterExecute - success
DEBUG Rule-based Row Filter 7:3593 Rule-based Row Filter 7:3593 has new state: EXECUTED
DEBUG Google Sheets Updater 7:3597 Configure succeeded. (Google Sheets Updater)
DEBUG Rule-based Row Filter 7:3593 Google Sheets Updater 7:3597 has new state: CONFIGURED_QUEUED
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doBeforePreExecution
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: PREEXECUTE
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doBeforeExecution
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: EXECUTING
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 Start execute
INFO Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 End execute (0 secs)
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doBeforePostExecution
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: POSTEXECUTE
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 doAfterExecute - success
DEBUG Google Sheets Updater 7:3597 Google Sheets Updater 7:3597 has new state: EXECUTED
DEBUG CASE Switch Variable (End) 7:3636 Configure succeeded. (CASE Switch Variable (End))
WARN Variable Loop End 7:3632 No variables selected
DEBUG Variable Loop End 7:3632 Configure succeeded. (Variable Loop End)
DEBUG Google Sheets Updater 7:3597 PageSpeed Submission Form 7 has new state: CONFIGURED_MARKEDFOREXEC
DEBUG NodeContainer ROOT has new state: CONFIGURED_MARKEDFOREXEC

I rewrote the loop section to flatten it out with if-switch logics. There were some issues with how Google Sheet Reader behaves and updates the data tables as it moves through nodes and loop, but it’s working now. :slight_smile:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.