In the process of data transfer in InfoBright We have dumped the data into sql script files ,
Then removed the primary keys and other indexes in the script , as info bright do not support them
And from the Script file we are trying the load the data into InfoBright

We successfully connected to info bright and started the data transfer
But the InfoBright server is disconnecting frequently in the middle of the data transfer
and giving the errors like

Lost Connection to MYSQL Server during Query, MYSQL Server Gone away,
can’nt connect to MYSQL Server on localhost

I tried to reconnect the InfoBright , by continuously observing the data transfer process
But at certain period of time , we are not able to restore the connection  

please help so that i cant go in proper way of data transfer

Hi Vamsi,

A couple of questions;

Can I assume that you are using Jasper ETL to load the data?
Are you trying to load the same table with multiple threads?
Are you loading the data using the standard MySQL connector of the Talend/ETL connector from the contributed code page?
Are you running Jasper and ICE on the same server?
What version of Jasper ETL are you using?

... Bob