tMSSqlConnection java.sql.SQLException: Network error IOException: Too many open files issue while running my job through TAC

[TamilM]

Hi Team,

We are facing an unknown issue like 'Too many open files' in one of my MSSQL connection component when we run our job through TAC. I have verified that my job is not using any temp directory in any of my tMap or components, can you please advice or anyone faced similar issue? any help on this is highly appreciated!!

Exception in component tMSSqlConnection_7
java.sql.SQLException: Network error IOException: Too many open files
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)

Thanks

Tamil 

[vapukov]

Hi,

as I understand this error you have on TAC

is your TAC is a Linux server?

do you change default files limits?

you could check it by command

ulimit -n

how to proper change limit - depend from your system (not hard but slightly different for some of them), better to talk with system admin guys