I’m attempting to update a google sheet with a table that’s roughly 80k rows and 29 columns, using the Google Sheets Appender node. I’m just adding a new tab to the sheet and writing out the data. This is consistently erroring with the following error message: ERROR Google Sheets Appender 0:572:567 Execute failed: Read timed out In the same workflow, I am also attempting to update an existing tab in the same sheet where it clears out and replaces the records each time it runs. Similar volume, and it is also getting this time out error. Occasionally, I find that the updates to the sheet happen even though the process errored out, so this really seems to be a matter of just needing the process to wait a bit longer for this action to complete. Can someone point me to how this timeout setting can be increased? (This is on Knime desktop, not server.)

Hello @scottb , [image] scottb: I’m not clear on the action I would take if it encounters an exception? Simply re-execute. Of course this doesn’t make sense if you are constantly (every time) hitting this error (which seems you do from your original post). Check this topic for more on this approach: [image] Re-execute on error KNIME Analytics Platform Hello. I have an issue with a workflow whereby a node may error and needs to be manually re-executed. I believe the error may be caused as I run concurrent nodes with RFC connectors which can’t always connect first time. Whilst one option would be to run each node separately, this would not be the ideal as it would take too long. Is there a simple method by which I could restart a node which has stopped? This is possible with the Try/Catch nodes but seems overly complicated and I’ve been unabl… [image] scottb: For the breakpoint node, out of curiosity, what would you choose in this case? Think I used Column Rename node first time. But whatever node is used I would make sure to document it with “Dummy” or “pass through” node for example. You are right, there is no such node (see here ). This would be my approach: [GoogleTimeOutLoop] Br, Ivan

Possible to increase timeout for google sheets nodes?

KNIME Analytics Platform

ipazin September 17, 2021, 10:55am 8

Hello @scottb,

currently there is no timeout configuration for Google nodes. See here for workaround:

Also I have added +1 to existing ticket in above linked topic. Upon news someone will update this topic.

Br,
Ivan

2 Likes