KNIME AP not responding

[Subramanyam]

Hi Team,

I am trying to upload the data to Microsoft SQL Server DB using DB Writer node and tried with DB Insert Node also which is 4K records of data.
It is turning into not responding state like below.

Please help me in resolving the issue.

Please let me know for further information.

Thanks,
Subramanyam Kinthada.

[Subramanyam]

Hi Team,

Please suggest me any solution.

[mlauber71]

@Subramanyam have you considered doing it in chunks?

[Subramanyam]

Hi @mlauber71,

Yes, I have tried it with 1K records but the same issue repeated.

[mlauber71]

@Subramanyam does this work at all? Have you tried just a few lines maybe. Is there any response or anything in the Log file?

[Subramanyam]

well, its working with less than 400 records. but not working for more than that limit.

[mlauber71]

@Subramanyam it might work to use a loop and only send that amount in one go. Or you could check if there are settings limiting the intake of the server.

Or you could try and adapt the BATCHSIZE in the driver connecting to the server. Could look like this:

[Subramanyam]

Hi @mlauber71

I have tried the above settings. the node got failed and KNIME AP changed to not responding state.