Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error "No buffer space available "

Hi,
I added 4GO of RAM and 3 processors on the remote desktop. Then when I executed the job Talend, I obtain the following error:
"Exception in component tMSSqlOutput_3
java.sql.SQLException: Network error IOException: No buffer space available (maximum connections reached?): connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:410)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at iac_dev.alim_mesures_meteo_temp_1_0.Alim_Mesures_METEO_Temp.tFileInputDelimited_3Process(Alim_Mesures_METEO_Temp.java:1648)
at iac_dev.alim_mesures_meteo_temp_1_0.Alim_Mesures_METEO_Temp.runJobInTOS(Alim_Mesures_METEO_Temp.java:5992)
at iac_dev.alim_mesures_meteo_temp_1_0.Alim_Mesures_METEO_Temp.runJob(Alim_Mesures_METEO_Temp.java:5783)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.tFileList_1Process(Alim_Mesures_METEO.java:786)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.runJobInTOS(Alim_Mesures_METEO.java:3675)

at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.main(Alim_Mesures_METEO.java:3463)
Caused by: java.net.SocketException: No buffer space available (maximum connections reached?): connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:307)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:257)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:311)

Exception in component tRunJob_3
java.lang.RuntimeException: Child job running failed
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.tFileList_1Process(Alim_Mesures_METEO.java:808)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.runJobInTOS(Alim_Mesures_METEO.java:3675)
at iac_dev.alim_mesures_meteo_1_0.Alim_Mesures_METEO.main(Alim_Mesures_METEO.java:3463)"

What is that you know the cause of this error?
Labels (4)
2 Replies
willm1
Creator
Creator

I first tempted to say your java heap size needs to be checked, but when I looked at the stack trace, I noted that this might be a DB issue...
Looks like it's a connection issue to Windows using RDP - http://stackoverflow.com/questions/10088363/java-net-socketexception-no-buffer-space-available-maxim...
Anonymous
Not applicable
Author

Hello,
Thank you for your answer. But what I have to make to solve the problem?