Facing Timeout Exception while reading data using CSV Reader

I am facing the error "Execute failed:

CSV Reader : java.net.Socket TimeoutException - Read timed out Parser Configuration: CsvParserSettings:
Auto configuration enabled=true
Auto-closing enabled=true
Autodetect column delimiter=false
Autodetect quotes=false
"
I have connected this CSV Reader to Amazon S3 connector node and am using KNIME version 4.7. Any suggestions?

@Sowjanya_Y welcome to the KNIME forum. Have you tried to first transfer the CSV file to a local driven and then import it? Has this ever worked?

Thank you @mlauber71. My requirement is to read the files available in S3 and transform them. I tried adding these below in the knime.ini file and it worked.

-Dsun.net.client.defaultConnectTimeout=60000
-Dsun.net.client.defaultReadTimeout=60000

Thank you :slight_smile:

2 Likes

Hello,
the S3 Connector node allows you to adjust the read/write timeouts via the Advanced tab in the node dialog.
Bye
Tobias

1 Like

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