Pentaho Data Integration - Connection time out

0
votes

I am developing a PDI transformation, which takes data from a MySql database, and output the data into an MSSQL table. But before output, I add a deletion step to delete records in dest. table with same key field values. But I do not know why that by this setting the transformation always fails casting exception of connection timeout of data source.

But, after I added a "Block" step between "table input" and "Delete", the issue got gone, and the transformation got successfully finished.

My configuration and exception message are as blow:

Transformation setting and system exception message

Data Input SQL, and Delete condition

1
mysqlinputconnectiontimeoutpentaho

1 Answers

0
votes

Error what I see from the screen-shot you attached and also recommendation in the 4th error line from top "consider raising value of 'net_write_timeout' on the server"

Default value will be 60, Kindly increase the value for the same. Follow below document for more reference.

https://wiki.pentaho.com/display/EAI/MySQL