I have a simple Job, which reads information from a csv (40 columns) and tries to send it to an Azure SQL database.
But I get always the message : "Invalid state, the Connection object is closed."
I already tried to remove some columns, and then sometimes it works and sometimes it doesn't work. I don't have any clue anymore where I need to look for the solution. Has anyone some ways to troubleshoot this further.
“Invalid State, the connection object is closed” – this issue occurs due to database connections being closed. It can happen because of the connection timeout between servers or database unavailable(might be restarted or down).
There is also a community posting on this :
Have you tried to reduce batch size in the Advanced settings of the component(Batch size as 50 or 100) to see if it works?
I have faced this issue and found a solution. Use the microsoft driver instead of the jtds driver for large inserts.
Let us know if it works for you.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema